FUNDAMENTALS OF COMPUTER

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.
A
explode
B
freeze
C
magnify
D
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.