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

Question

Share Report Error

In Excel, the error '#DIV/0!' occurs when:

A. Invalid reference

B. A formula divides by zero or an empty cell

C. Value not available

D. Name not recognized

Answer: Option B

Solution (By JKSSB Mock Tests)

#DIV/0! division by zero.

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

In MS Access, a 'Navigation form' is used to:

A. Create tables

B. Enter data

C. Provide a menu system to open forms and reports

D. Print reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Navigation form acts as a switchboard.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

To select an entire paragraph in MS Word, you can:

A. Double-click the paragraph

B. Shift + Click

C. Triple-click anywhere in the paragraph

D. Ctrl + Click

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Triple-click selects the whole paragraph.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to insert a comment in MS Word?

A. Ctrl + Shift + M

B. Ctrl + Alt + M

C. Alt + M

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Alt + M inserts a comment. Ctrl + M indents a paragraph in Word. The others are not standard for comments.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs