What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)? MCQ with Answer and Explanation
What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)?
A. #REF!
B. #NAME?
C. #VALUE!
D. #NULL!
Answer: Option B
Solution (By JKSSB Mock Tests)
The #NAME? error occurs when Excel does not recognize text within a formula, which is typically caused by a misspelled function name or a missing quote around a text string.
No comments yet. Be the first to start the discussion!