USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
total panes
|
|
excel panes
|
|
freeze panes
|
|
None of the above
|
Detailed explanation-1: -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-2: -On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top.
Detailed explanation-3: -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-4: -Split lets you divide an Excel worksheet into two or four windows that can scroll semi-independently so you can see different parts of the worksheet at the same time. The Split button is found on the View tab of the ribbon. To split your screen vertically, select a cell in the top row and click the Split button.