USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
T
|
|
F
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
Detailed explanation-2: -You can set the Print Area by highlighting the cells you want to include, then go to Page Layout tab. In the Page Setup group of functions, click the Print Area option and then click Set Print Area. When you print the spreadsheet going forward, only that print area is printed.
Detailed explanation-3: -The default print area in Excel in portrait orientation includes columns A to J or rows 1 to 50. In landscape orientation, it ranges from columns A to O or rows 1 to 33.