DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
freeze panes
|
|
|
wrapping text in a cell
|
|
|
rotating text in a cell
|
|
|
creating styles
|
Detailed explanation-1: -In such cases, freeze command is very helpful. Just freeze the heading area and you can see it no matter which data cell you are using.
Detailed explanation-2: -You’re scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.
Detailed explanation-3: -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.
Detailed explanation-4: -On the View tab, click Freeze Panes > Freeze Panes.