Information =NA( )

Quiz =NA — 10 Questions

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

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

← NA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which is the correct syntax of =NA?

Question 2 of 10 2/10

Since which Excel version is =NA available?

Question 3 of 10 3/10

What usually causes #N/A in =NA?

Question 4 of 10 4/10

Is =NA volatile?

Question 5 of 10 5/10

Which category does =NA belong to?

Question 6 of 10 6/10

Which formula is a valid example of =NA?

Question 7 of 10 7/10

What is the fix for #N/A in =NA?

Question 8 of 10 8/10

Which use case fits =NA?

Question 9 of 10 9/10

Which statement about =NA is correct?

Question 10 of 10 10/10

How many arguments does =NA have in total?

Click a question to see the answer.

1. Which is the correct syntax of =NA?

A. =IF( )
B. =NA( , 0)
C. =NA( ) ✓
D. NA( )

Explanation: Correct syntax: =NA( )

2. Since which Excel version is =NA available?

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

Explanation: Version: “All versions”.

3. What usually causes #N/A in =NA?

A. You can also type the value #N/A directly into a cell. ✓
B. Output is always a dynamic array
C. Requires add-in
D. Select entire column for best performance

Explanation: You can also type the value #N/A directly into a cell. — Fix: اگر این خطا ناخواسته ظاهر شد، بررسی کنید فرمول به سلول حاوی NA ارجاع ندهد؛ در صورت نیاز با IFNA یا IFERROR آن را مدیریت کنید.

4. Is =NA volatile?

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

Explanation: NA is not volatile.

5. Which category does =NA belong to?

A. Statistical
B. Compatibility
C. Lookup & Reference
D. Information ✓

Explanation: Category is “Information”.

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

A. =IF()
B. =NA() ✓
C. NA()
D. =NA(, 0)

Explanation: Correct example: =NA()

7. What is the fix for #N/A in =NA?

A. Select entire column for best performance
B. Text is always ignored
C. اگر این خطا ناخواسته ظاهر شد، بررسی کنید فرمول به سلول حاوی NA ارجاع ندهد؛ در صورت نیاز با IFNA یا IFERROR آن را مدیریت کنید. ✓
D. Output is always a dynamic array

8. Which use case fits =NA?

A. Workdays & Due Dates
B. Error Handling ✓
C. Scientific & Unit Conversion
D. Numbering & Sample Data

Explanation: Use case “Error Handling” fits NA.

9. Which statement about =NA is correct?

A. You must include the empty parentheses with the function name. Otherwise, Microsoft Excel will not recognize it as a function. ✓
B. Text is always ignored
C. Output is always a dynamic array
D. Volatile and recalculates every time

Explanation: Correct: You must include the empty parentheses with the function name. Otherwise, Microsoft Excel will not recognize it as a function.

10. How many arguments does =NA have in total?

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

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