In Excel, the error '#NULL!' occurs when: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the error '#NULL!' occurs when:

A. A formula is not recognized

B. You specify an intersection of two areas that don't intersect

C. Cell reference is invalid

D. Division by zero

Answer: Option B

Solution (By JKSSB Mock Tests)

#NULL! means no intersection when using space operator.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

Which of the following Excel functions is used to rank a number in a list?

A. RANK.AVG()

B. All of these

C. RANK.EQ()

D. RANK()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
RANK (old), RANK.EQ, RANK.AVG are all ranking functions.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, the keyboard shortcut to edit a cell comment (note) is:

A. Alt + F2

B. F2

C. Ctrl + F2

D. Shift + F2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F2 inserts or edits comment.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, to display the 'Go To' dialog, press:

A. Alt + G

B. Both A and B

C. Ctrl + G

D. F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F5 and Ctrl+G both open Go To.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs