DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Excel displays the error message #NULL! to indicate a cell reference error.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Change error display Select the For error values show check box under Format. In the box, type the value that you want to display instead of errors. To display errors as blank cells, delete any characters in the box. Change empty cell display Select the For empty cells show check box.
Detailed explanation-2: -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 #####.
Detailed explanation-3: -#VALUE is Excel’s way of saying, “There’s something wrong with the way your formula is typed. Or, there’s something wrong with the cells you are referencing."
There is 1 question to complete.