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

Question

Share Report Error

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

A. If B1 is zero

B. Only if #DIV/0!

C. A1/B1 results in any error value

D. If A1 is blank

Answer: Option C

Solution (By JKSSB Mock Tests)

IFERROR catches all error types and returns specified value.

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

In MS Access, which data type is used for long text (up to 1 GB) and formatted text?

A. Memo

B. Long Text

C. Attachment

D. Short Text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Long Text (formerly Memo) can hold large amounts of text.

This question belongs to: Computer Microsoft Office

Question #2

In Access, which of the following is used to create a form based on a table or query?

A. Create > Form Wizard

B. Create > Form Design

C. Both A and B

D. Create > Form

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can create a form using Form (auto), Form Design, or Form Wizard. So both A and B are valid.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, to change the case of selected text to toggle case (e.g., fROM tHIS), press:

A. Ctrl + Shift + A

B. Ctrl + Shift + K

C. Shift + F3 (repeatedly)

D. F3

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Shift+F3 cycles through case options.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs