In MS Excel, what does the error code '#NULL!' indicate? MCQ with Answer and Explanation

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 function name contains a typographical misspelling mistake.
C. A formula specifies an intersection of two cell ranges that do not intersect.
D. A formula attempts to divide a numeric value by an empty cell row.
Answer: Option C
Solution (By JKExamLibrary)
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.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In PowerPoint, to copy a slide from another presentation and keep its formatting, use:
A. Copy and paste
B. All of the above
C. Reuse Slides with 'Keep source formatting' checked
D. Insert -> Slides from File

Correct Answer: Option B


Explanation:
All methods allow copying slides, but Reuse Slides offers the option.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In Excel, which function is used to multiply numbers?
A. MULTIPLY
B. PRODUCT
C. Both B and C
D. *

Correct Answer: Option C


Explanation:
You can multiply using the * operator, or the PRODUCT function. MULTIPLY is not a function.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS PowerPoint, what key should a presenter hold down while using the pen tool during a live show to draw rigid horizontal or vertical annotation lines?
A. Shift
B. Tab
C. Alt
D. Ctrl

Correct Answer: Option A


Explanation:
Holding the Shift key during a presentation slide delivery locks the integrated pen tool tracking into perfect horizontal or vertical lines.

This question belongs to: Computer Microsoft Office