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 A1 is blank

B. Only if #DIV/0!

C. A1/B1 results in any error value

D. If B1 is zero

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 PowerPoint, which of the following is an entrance animation effect?

A. Spin

B. Teeter

C. Fly In

D. Desaturate

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Fly In is an entrance effect. Spin is emphasis, Teeter is also emphasis, Desaturate is not a standard animation.

This question belongs to: Computer Microsoft Office

Question #2

Which shortcut key is used to center align text in MS Office?

A. Ctrl + L

B. Ctrl + R

C. Ctrl + E

D. Ctrl + J

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + E centers text. Ctrl + L left aligns, Ctrl + R right aligns, Ctrl + J justifies.

This question belongs to: Computer Microsoft Office

Question #3

What is the function of the keyboard shortcut Ctrl + F2 across Microsoft Word and Excel applications?

A. Displays the Print Preview layout tab screen

B. Opens the Save As file dialog menu window

C. Minimizes the core active parent window application

D. Launches the automated spelling check wizard

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + F2 is the traditional keyboard shortcut to launch the Print Preview screen, allowing users to check document layouts before physical printing.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs