USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
On which of these tabs will you find the Freeze Panes feature?
|
|
Insert
|
|
|
View
|
|
|
Data
|
|
|
File
|
Explanation:
Detailed explanation-1: -To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Detailed explanation-2: -On the View tab, click Freeze Panes > Freeze Panes.
Detailed explanation-3: -1. If you want to freeze all worksheets in the same position, select a cell that you want to freeze in the worksheet, and then hold Shift key to select all sheet tabs.
There is 1 question to complete.