In MS Excel, what does the error code '#NAME?' typically signify?
A. A data type mismatch occurred inside a mathematical function
B. A cell is too narrow to display the output digits
C. The formula contains an invalid mathematical divisor
D. Excel does not recognize text within a formula name or function
Answer: Option D
Solution (By JKSSB Mock Tests)
The #NAME? error occurs when Excel fails to recognize text inside a formula, such as misspelling a function name (e.g., writing =SUUM(A1:A5) instead of =SUM(A1:A5)).
No comments yet. Be the first to start the discussion!