DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The most common error when entering a formula is to reference the wrong cell in the formula.
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Because the most common error when entering a formula is to reference the wrong cell in a formula mistakenly, Excel colors the boarders of the cell referenced in the formula.
Detailed explanation-2: -The most common error when entering a formula is to reference the wrong cell in the formula.
Detailed explanation-3: -The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.
Detailed explanation-4: -You will get the #REF! error when a formula references a cell that’s not valid. This often happens when referenced cells get deleted or pasted over. Select the cell with the #REF!
There is 1 question to complete.