DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Freezing a row or column creates what Windows calls a pane. Changing the magnification of the display does not change the magnification for printing. Select all the cell blocks in each worksheet of a group individually, before changing the formatting for those blocks.
Detailed explanation-2: -The Excel Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen.
Detailed explanation-3: -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.