FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In which of the following locations are check boxes that 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: -Page Setup in Excel-Method One Navigate to the Toolbar and select the Page Layout option. Once you click on the Page Layout option, you will find the Page Layout Ribbon, as shown in the image below.

Detailed explanation-3: -On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Detailed explanation-4: -Gridlines in Excel[1] are the horizontal and vertical gray lines that differentiate between cells in a worksheet. The gridlines guide users to differentiate between the specific cells and read the data in an organized manner. They also help users navigate through the worksheet columns and rows with ease.

There is 1 question to complete.