Question

Select the range- page layout> sheet options 2. select the range- page layout> print area> set print area

a. Both steps are correct
b. Only step 1 is correct
c. Only step 2 is correct
d. Neither step is correct

Answer 1

Only step 2 is correct for setting a print area in Excel. The process involves selecting the desired range and then using the Page Layout tab to set the print area.

Step-by-step explanation:

The correct steps for setting the print area in an Excel worksheet involve first selecting the range of cells that you want to print, and then specifying that range as the print area. Here's how you can do it:

1. Click on the Page Layout tab in the Excel ribbon.
2. In the Sheet Options group, ensure that the print settings such as gridlines and headings are as you desire them to be.
3. Select the range of cells that you want to set as your print area.
4. Again, click on the Page Layout tab.
5. Go to the Print Area drop-down in the Page Setup group.
6. Choose Set Print Area.

So, among the options given, c. Only step 2 is correct in terms of setting the print area.