FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which should you do before formatting an entire row or column?
A
Click the row heading or column heading to select it
B
Open print preview
C
Go to Page Layout view
D
Select a cell range
Explanation: 

Detailed explanation-1: -When inserting rows and columns, make sure you select the entire row or column by clicking the heading. If you select only a cell in the row or column, the Insert command will only insert a new cell.

Detailed explanation-2: -Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column. Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.

Detailed explanation-3: -Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Row Height. In the Row height box, type the value that you want, and then click OK.

There is 1 question to complete.