Information =NA( )

Quiz =NA — 15 Questions

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

Question 1 of 15 1/15

Which use case fits =NA?

Question 2 of 15 2/15

Since which Excel version is =NA available?

Question 3 of 15 3/15

Is =NA volatile?

Question 4 of 15 4/15

Which category does =NA belong to?

Question 5 of 15 5/15

What is the output type of =NA?

Question 6 of 15 6/15

Which function is NOT related to =NA?

Question 7 of 15 7/15

Which function is related to =NA?

Question 8 of 15 8/15

Does =NA return a dynamic array?

Question 9 of 15 9/15

Which formula is a valid example of =NA?

Question 10 of 15 10/15

How many arguments does =NA have in total?

Question 11 of 15 11/15

How many required arguments does =NA have?

Question 12 of 15 12/15

What usually causes #N/A in =NA?

Question 13 of 15 13/15

How many optional arguments does =NA have?

Question 14 of 15 14/15

Which is the correct syntax of =NA?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which use case fits =NA?

A. External Data, Web & Cube
B. Financial Calculations
C. Error Handling ✓
D. Depreciation

Explanation: Use case “Error Handling” fits NA.

2. Since which Excel version is =NA available?

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

Explanation: Version: “All versions”.

3. Is =NA volatile?

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

Explanation: NA is not volatile.

4. Which category does =NA belong to?

A. Statistical
B. Text
C. Engineering
D. Information ✓

Explanation: Category is “Information”.

5. What is the output type of =NA?

A. Error ✓
B. Number
C. Logical
D. Value

Explanation: Output is “Error”.

6. Which function is NOT related to =NA?

A. IF
B. ISNA
C. NORMSINV ✓
D. IFNA

Explanation: “NORMSINV” is not related to NA.

7. Which function is related to =NA?

A. IMPORTTEXT
B. ODDFPRICE
C. RAND
D. IF ✓

Explanation: “IF” is related to NA.

8. Does =NA return a dynamic array?

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

Explanation: NA does not spill.

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

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

Explanation: Correct example: =NA()

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

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

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

11. How many required arguments does =NA have?

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

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

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

A. You can also type the value #N/A directly into a cell. ✓
B. Only works in old versions
C. Output is always a dynamic array
D. Requires add-in

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

13. How many optional arguments does =NA have?

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

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

14. Which is the correct syntax of =NA?

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

Explanation: Correct syntax: =NA( )

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

A. Requires add-in
B. Volatile and recalculates every time
C. Text is always ignored
D. اگر این خطا ناخواسته ظاهر شد، بررسی کنید فرمول به سلول حاوی NA ارجاع ندهد؛ در صورت نیاز با IFNA یا IFERROR آن را مدیریت کنید. ✓