FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Where are the check boxes you can select to view or print gridlines?
A
In Print Preview
B
On the Home tab in the Cells group
C
On the PAGE LAYOUT tab, in the sheet options group
D
On the PAGE LAYOUT tab in the Page Setup Group
Explanation: 

Detailed explanation-1: -On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.

Detailed explanation-2: -To show gridlines: On the Layout tab, under View, select the Gridlines check box. Note: Gridlines cannot be customized. To change the width, color, or other attributes of the lines around cells, use border formatting. To hide gridlines: On the Layout tab, under View, clear the Gridlines check box.

Detailed explanation-3: -To print gridlines in a worksheet, on the PAGE LAYOUT tab, under Gridlines, check Print . Now when you print the worksheet, the gridlines are printed and it is easier to read. You can print row and column headings. This is 1, 2, 3 and so-on for rows and A, B, C, and so on for columns.

Detailed explanation-4: -Click the Page Layout tab to expand the page layout commands and then go to the Gridlines section.

There is 1 question to complete.
Previous
Next