FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can define a unique print area for each worksheet in your workbook.
A
T
B
F
C
Either A or B
D
None of the above
Explanation: 

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.

There is 1 question to complete.
Previous
Next