Related Question 5
If a formula references a cell that contains text instead of a numerical value, what error does Excel display?
-
A.
#NUM!
-
B.
#VALUE!
-
C.
#REF!
-
D.
#DIV/0!
Correct Answer: B
Explanation:
#VALUE! An error appears when the formula expects numbers but receives text.