FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which tab of the ribbon should you go to for removing gridlines on a worksheet?
A
Page Layout
B
View
C
Review
D
Developer
Explanation: 

Detailed explanation-1: -To hide gridlines: On the Layout tab, under View, clear the Gridlines check box.

Detailed explanation-2: -You can also use the keyboard shortcut – ALT + WVG (hold the ALT key and enter W V G). This shortcut would remove the gridlines if it is visible, else it will make it visible. Removing the gridlines would remove it from the entire worksheet. This setting is specific to each worksheet.

Detailed explanation-3: -Click anywhere on the chart in which you want to hide chart gridlines. On the Layout tab, in the Axes group, click Gridlines. Do one or more of the following: Click Primary Horizontal Gridlines, Primary Vertical Gridlines, or Depth Gridlines (on a 3-D chart), and then click None.

Detailed explanation-4: -Click the Table Layout tab, and then under Settings, click Gridlines.

There is 1 question to complete.