Question

In Microsoft Excel, you have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this?A. Set a print areaB. Print titlesC. Adjust the page breaksD. Change the print page order

Answer 1

The answer is "Option D".

Explanation:

In Microsoft Excel, A dataset is a collection of the data. In other words a dataset is set of data like, Excel workbooks, spreadsheet tables, or table lists that are configurable objects storing the data. To print data sets related records on the same page we change the print at this data set only print the visible data, it will not print the confidential data. and other options are not correct that can be defined as follows:

• In option A, It is not correct, because the set area used to select the area which you want to print.
• In option B, It is used to print the same data on each page. it is not used in print page order.
• In option C, This option is available on the Home tab that is used for page break only that's why it is not correct.