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 D4 and you applied Freeze Pane, which of the following rows will be in place?
|
|
Rows 1 and 2
|
|
|
Rows 1, 2 and 3
|
|
|
Rows 1, 2, 3 and 4
|
|
|
Rows 1 and 3
|
Explanation:
Detailed explanation-1: -Go to the View tab of a worksheet to select Freeze Panes, which locks specific rows and columns in place when you scroll to another area, or Split Panes, which creates separate windows of the same spreadsheet.
Detailed explanation-2: -To lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row. This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet.
There is 1 question to complete.