USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If your selection is C5 and you applied Freeze Pane, which of the following columns will be in place?
|
|
Column A
|
|
|
Column B
|
|
|
Columns A and B
|
|
|
Columns A, B, and C
|
Explanation:
Detailed explanation-1: -Freeze as many rows or columns as you want To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. Say you want to freeze the top four rows and leftmost three columns. You’d select cell D5, and then on the View tab, click Freeze Panes.
Detailed explanation-2: -If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.
Detailed explanation-3: -Select the column (or the first cell in the column) to the right of the last column you want to lock. Go to the View tab, and click Freeze Panes > Freeze Panes.
There is 1 question to complete.