In MS Excel, what does the error code '#NULL!' indicate?
A. A required lookup key value cannot be located inside a range array.
B. A formula specifies an intersection of two cell ranges that do not intersect.
C. A function name contains a typographical misspelling mistake.
D. A formula attempts to divide a numeric value by an empty cell row.
Answer: Option B
Solution (By JKSSB Mock Tests)
The #NULL! error occurs when a space operator is used between two ranges that do not intersect, such as evaluating =SUM(A1:A2 B1:B2) instead of using a comma operator.
No comments yet. Be the first to start the discussion!