Logical =IFNA(value, value_if_na)

Quiz =IFNA — 10 Questions

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

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

← IFNA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =IFNA?

Question 2 of 10 2/10

Which formula is a valid example of =IFNA?

Question 3 of 10 3/10

Is argument “value” required in =IFNA?

Question 4 of 10 4/10

What usually causes #N/A in =IFNA?

Question 5 of 10 5/10

Which use case fits =IFNA?

Question 6 of 10 6/10

Is argument “value_if_na” required in =IFNA?

Question 7 of 10 7/10

What is the output type of =IFNA?

Question 8 of 10 8/10

Is =IFNA volatile?

Question 9 of 10 9/10

What is the type of argument “value_if_na” in =IFNA?

Question 10 of 10 10/10

Which statement about =IFNA is correct?

Click a question to see the answer.

1. Which function is NOT related to =IFNA?

A. VLOOKUP
B. MROUND ✓
C. IFERROR
D. ISNA

Explanation: “MROUND” is not related to IFNA.

2. Which formula is a valid example of =IFNA?

A. =VLOOKUP(VLOOKUP(E2, A2:C100, 3, FALSE), "Not found")
B. IFNA(VLOOKUP(E2, A2:C100, 3, FALSE), "Not found")
C. =IFNA(VLOOKUP(E2, A2:C100, 3, FALSE), "Not found", 0)
D. =IFNA(VLOOKUP(E2, A2:C100, 3, FALSE), "Not found") ✓

Explanation: Correct example: =IFNA(VLOOKUP(E2, A2:C100, 3, FALSE), "Not found")

3. Is argument “value” required in =IFNA?

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

Explanation: “value” is required.

4. What usually causes #N/A in =IFNA?

A. Select entire column for best performance
B. Only works in old versions
C. Requires add-in
D. The argument that is checked for the #N/A error value. The value to return if the formula evaluates to the #N/A error value. ✓

Explanation: The argument that is checked for the #N/A error value. The value to return if the formula evaluates to the #N/A error value. — Fix: با IFNA مقدار جایگزین برای ‎#N/A‎ تعیین کنید؛ در صورت نیاز منبع خطا مانند VLOOKUP ناموفق را بررسی کنید.

5. Which use case fits =IFNA?

A. Comparation ✓
B. Advanced Formulas
C. Error Handling
D. Date & Time Calculations

Explanation: Use case “Comparation” fits IFNA.

6. Is argument “value_if_na” required in =IFNA?

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

Explanation: “value_if_na” is required.

7. What is the output type of =IFNA?

A. Logical
B. Date
C. Mixed ✓
D. Text

Explanation: Output is “Mixed”.

8. Is =IFNA volatile?

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

Explanation: IFNA is not volatile.

9. What is the type of argument “value_if_na” in =IFNA?

A. Logical
B. Any type ✓
C. Number
D. Array

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

10. Which statement about =IFNA is correct?

A. Volatile and recalculates every time
B. Text is always ignored
C. If value is an array formula, IFNA returns an array of results for each cell in the range specified in value.
D. If value or value_if_na is an empty cell, IFNA treats it as an empty string value (""). ✓

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