Logical =IFERROR(value, value_if_error)

Quiz =IFERROR — 10 Questions

10 quiz questions about =IFERROR — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← IFERROR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =IFERROR is correct?

Question 2 of 10 2/10

What is the output type of =IFERROR?

Question 3 of 10 3/10

What is the fix for #REF! in =IFERROR?

Question 4 of 10 4/10

How many required arguments does =IFERROR have?

Question 5 of 10 5/10

What is the type of argument “value” in =IFERROR?

Question 6 of 10 6/10

How many optional arguments does =IFERROR have?

Question 7 of 10 7/10

Which is the correct syntax of =IFERROR?

Question 8 of 10 8/10

Which function is related to =IFERROR?

Question 9 of 10 9/10

Is argument “value_if_error” required in =IFERROR?

Question 10 of 10 10/10

What usually causes #VALUE! in =IFERROR?

Click a question to see the answer.

1. Which statement about =IFERROR is correct?

A. Select entire column for best performance
B. If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (""). ✓
C. If value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.
D. Text is always ignored

Explanation: Correct: If value or value_if_error is an empty cell, IFERROR treats it as an empty string value ("").

2. What is the output type of =IFERROR?

A. Reference
B. Mixed ✓
C. Array
D. Text

Explanation: Output is “Mixed”.

3. What is the fix for #REF! in =IFERROR?

A. ارجاع‌های نامعتبر را اصلاح کنید و با IFERROR خطا را مدیریت کنید. ✓
B. Requires add-in
C. فرمول مقدار خطای ‎#NUM!‎ برگردانده است.
D. Text is always ignored

Explanation: The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. — Fix: ارجاع‌های نامعتبر را اصلاح کنید و با IFERROR خطا را مدیریت کنید.

4. How many required arguments does =IFERROR have?

A. 2 ✓
B. 3
C. 4
D. 1

Explanation: =IFERROR has 2 required, 0 optional (2 total).

5. What is the type of argument “value” in =IFERROR?

A. Logical
B. Value
C. Reference
D. Any type ✓

Explanation: Type of “value” is “Any type”.

6. How many optional arguments does =IFERROR have?

A. 1
B. —
C. 0 ✓
D. 2

Explanation: =IFERROR has 2 required, 0 optional (2 total).

7. Which is the correct syntax of =IFERROR?

A. =VLOOKUP(value, value_if_error)
B. =IFERROR(value, value_if_error, 0)
C. =IFERROR(value, value_if_error) ✓
D. IFERROR(value, value_if_error)

Explanation: Correct syntax: =IFERROR(value, value_if_error)

8. Which function is related to =IFERROR?

A. VARPA
B. LOG10
C. VLOOKUP ✓
D. NORMINV

Explanation: “VLOOKUP” is related to IFERROR.

9. Is argument “value_if_error” required in =IFERROR?

A. Yes
B. Yes ✓
C. No
D. —

Explanation: “value_if_error” is required.

10. What usually causes #VALUE! in =IFERROR?

A. فرمول مقدار خطای ‎#NUM!‎ برگردانده است.
B. Select entire column for best performance
C. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. ✓
D. Only works in old versions

Explanation: The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. — Fix: نوع داده‌ها و آرگومان‌ها را بررسی کنید و با IFERROR مقدار جایگزین بدهید.