Which of the following errors is thrown by MS Excel when a formula attempts to divide a numeric value by zero or an empty cell? MCQ with Answer and Explanation

Question

Which of the following errors is thrown by MS Excel when a formula attempts to divide a numeric value by zero or an empty cell?

A. #DIV/0!

B. #REF!

C. #NUM!

D. #VALUE!

Answer: Option A

Solution (By JKSSB Mock Tests)

The #DIV/0! error is explicitly thrown by Excel whenever a formula attempts division by zero or references an empty cell as the divisor.

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 is NOT a valid file format to save a PowerPoint presentation?

A. .pdf

B. .xps

C. .pptx

D. .ppsx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.xps is XML Paper Specification, not a PowerPoint save format (though you can export as XPS). But typical save-as formats: pptx, ppt, pdf, ppsx. However, you can save as XPS from Office. I'll avoid ambiguous. I'll change: .wav is not a presentation format. I'll ask: Which is not a presentation file format? Options: .pptx, .ppsx, .potx, .wav. Answer D. So I'll adjust.

This question belongs to: Computer Microsoft Office