DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When you ____ a worksheet, Excel enlarges the view of the characters on the screen, but displays fewer columns and rows.
|
explode
|
|
freeze
|
|
magnify
|
|
zoom out
|
Explanation:
Detailed explanation-1: -In Normal view, Excel shows the aspects of the worksheet that are visible only on-screen.
Detailed explanation-2: -When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. A thin red border indicates the active cell. You should press the SPACEBAR to clear a cell.
Detailed explanation-3: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
There is 1 question to complete.