USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Preview the gridlines – To see how the gridlines will print, press Ctrl+F2 to open the File tab, which displays a preview of printed worksheet. Gridlines print only around actual data in a worksheet. If you want to print gridlines around empty cells also, you must set the print area to include those cells.
Detailed explanation-2: -By default, gridlines in Excel are not printed. If you want to print the gridlines as well, make the following change: Go to Page Layout tab. In the Sheet Options group, within Gridlines, check the Print checkbox.
Detailed explanation-3: -On the screen, by default, the worksheet’s pages have gridlines, making it easier to read across rows and down columns. But when you print, by default, the gridlines are not printed. To print gridlines in a worksheet, on the PAGE LAYOUT tab, under Gridlines, check Print .
Detailed explanation-4: -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.