In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if: MCQ with Answer and Explanation

Question Report Error

In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:

A. A1/B1 results in any error value

B. Only if #DIV/0!

C. If B1 is zero

D. If A1 is blank

Answer: Option A

Solution (By JKExamLibrary)

IFERROR catches all error types and returns specified 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 Word, which option is used to change the page color?

A. Design -> Page Color

B. Home -> Shading

C. Insert -> Background

D. Layout -> Page Background

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Page Color is on the Design tab.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which key combination is used to switch between open applications in Windows (and also in Office)?

A. Windows + Tab

B. Ctrl + Tab

C. Alt + Tab

D. Shift + Tab

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Alt+Tab switches between open windows. Ctrl+Tab switches between document windows within an application.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

Which key combination is used to extend a selection to the beginning of a document in MS Word?

A. Shift + Home

B. Ctrl + Home

C. Alt + Home

D. Ctrl + Shift + Home

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Ctrl+Shift+Home selects from cursor to document start.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs