Logical =IFERROR(value, value_if_error)

Quiz =IFERROR — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Since which Excel version is =IFERROR available?

Question 2 of 15 2/15

Is argument “value” required in =IFERROR?

Question 3 of 15 3/15

Which statement about =IFERROR is correct?

Question 4 of 15 4/15

How many optional arguments does =IFERROR have?

Question 5 of 15 5/15

In =IFERROR, which is argument #1?

Question 6 of 15 6/15

Which formula is a valid example of =IFERROR?

Question 7 of 15 7/15

What usually causes #DIV/0! in =IFERROR?

Question 8 of 15 8/15

In =IFERROR, which is argument #2?

Question 9 of 15 9/15

What usually causes #REF! in =IFERROR?

Question 10 of 15 10/15

Which function is related to =IFERROR?

Question 11 of 15 11/15

What usually causes #NULL! in =IFERROR?

Question 12 of 15 12/15

Is =IFERROR volatile?

Question 13 of 15 13/15

Which function is NOT related to =IFERROR?

Question 14 of 15 14/15

Which use case fits =IFERROR?

Question 15 of 15 15/15

Which is the correct syntax of =IFERROR?

Click a question to see the answer.

1. Since which Excel version is =IFERROR available?

A. Excel 365
B. Excel 2007 ✓
C. Excel 2007 (Compatibility)
D. Excel 2019

Explanation: Version: “Excel 2007”.

2. Is argument “value” required in =IFERROR?

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

Explanation: “value” is required.

3. Which statement about =IFERROR is correct?

A. Only works in old versions
B. 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.
C. Volatile and recalculates every time
D. If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (""). ✓

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

4. How many optional arguments does =IFERROR have?

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

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

5. In =IFERROR, which is argument #1?

A. criteria
B. range
C. lookup_value
D. value ✓

Explanation: Argument #1 is “value”.

6. Which formula is a valid example of =IFERROR?

A. IFERROR(A2/B2, "Error in calculation")
B. =IFERROR(A2/B2, "Error in calculation", 0)
C. =VLOOKUP(A2/B2, "Error in calculation")
D. =IFERROR(A2/B2, "Error in calculation") ✓

Explanation: Correct example: =IFERROR(A2/B2, "Error in calculation")

7. What usually causes #DIV/0! in =IFERROR?

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

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

8. In =IFERROR, which is argument #2?

A. criteria
B. lookup_value
C. value
D. value_if_error ✓

Explanation: Argument #2 is “value_if_error”.

9. What usually causes #REF! in =IFERROR?

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. فرمول مقدار خطای ‎#NAME?‎ برگردانده است.
D. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. ✓

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

10. Which function is related to =IFERROR?

A. SUMIFS
B. POISSON.DIST
C. IFS
D. VLOOKUP ✓

Explanation: “VLOOKUP” is related to IFERROR.

11. What usually causes #NULL! in =IFERROR?

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

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

12. Is =IFERROR volatile?

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

Explanation: IFERROR is not volatile.

13. Which function is NOT related to =IFERROR?

A. ERROR-TYPE
B. VLOOKUP
C. COTH ✓
D. IFNA

Explanation: “COTH” is not related to IFERROR.

14. Which use case fits =IFERROR?

A. Advanced Formulas
B. Forecasting & Trends
C. Daily Tasks ✓
D. Probability & Hypothesis Testing

Explanation: Use case “Daily Tasks” fits IFERROR.

15. Which is the correct syntax of =IFERROR?

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

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