DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
blue square
|
|
|
red circle
|
|
|
green triangle
|
|
|
green diamond
|
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: -An #REF error (the “ref” stands for reference) is the message Excel displays when a formula references a cell that no longer exists, usually caused by deleting cells that a formula is referring to.
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.