USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.
|
blue square
|
|
red circle
|
|
green triangle
|
|
green diamond
|
Explanation:
Detailed explanation-1: -If a cell contains a formula that breaks a rule that Excel uses to check for problems, a triangle appears in the top-left corner of the cell. You can prevent these indicators from displaying. On the Excel menu, click Preferences., and then clear the Enable background error checking check box.
Detailed explanation-2: -Excel displays the #REF! error when a formula refers to a cell that is not valid.
Detailed explanation-3: -Correct a # error value. If a formula cannot correctly evaluate a result, Excel displays an error value, such as #####, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each error type has different causes, and different solutions.
There is 1 question to complete.