DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Under the Freeze Panes feature, which of these IS NOT part of its menu?
|
|
Freeze Panes
|
|
|
Freeze Top Row
|
|
|
Freeze First Column
|
|
|
Freeze Selected Cell
|
Explanation:
Detailed explanation-1: -Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
Detailed explanation-2: -To freeze the multiple rows, follow these steps: For example, select row 5. Go to View tab > Windows group > Freeze Panes. Select Freeze Panes.
Detailed explanation-3: -Detailed Solution. The correct answer is option 2 i.e freeze panes command on the view menu. Freeze panes command on the view menu is used to hold row and column titles in place so that they do not scroll when you scroll a worksheet in MS Excel 2007. Select View > Freeze Panes > Freeze Panes.
There is 1 question to complete.