What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor? MCQ with Answer and Explanation

Question Report Error

What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor?

A. #REF!

B. #NUM!

C. #DIV/0!

D. #VALUE!

Answer: Option C

Solution (By JKExamLibrary)

The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.

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 MS Access, the 'Lookup Wizard' is used to:

A. Search for a specific record

B. Create a field that allows selecting a value from a list or another table

C. Import data from Excel

D. Find duplicate records

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Lookup Wizard helps create a lookup field.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

To quickly switch between uppercase, lowercase, and title case in MS Word, select text and press:

A. Shift + F3

B. Alt + F3

C. F3

D. Ctrl + F3

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Shift+F3 toggles case.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What is the maximum number of columns in a table in MS Word?

A. 10

B. No limit

C. 256

D. 63

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
A Word table can have up to 63 columns.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs