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. A1/B1 results in any error value

B. If B1 is zero

C. Only if #DIV/0!

D. If A1 is blank

Answer: Option A

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

Which of the following is a valid file extension for an Excel macro-enabled workbook?

A. .xltm

B. .xlsb

C. .xlsm

D. .xlsx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
.xlsm is macro-enabled workbook. .xlsb is binary workbook, .xltm macro-enabled template.

This question belongs to: Computer Microsoft Office

Question #2

Which PowerPoint feature allows you to package the presentation with all linked files and fonts?

A. Export as PDF

B. Compress Media

C. Package for CD

D. Create Video

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Package for CD bundles the presentation and all external files for portability.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, what does the formula =LEN(TRIM(A1)) do if A1 contains leading spaces?

A. Counts only visible characters

B. Gives error

C. Removes all spaces and counts

D. Returns the length of the trimmed text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
TRIM removes extra spaces, LEN counts characters.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs