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

Does =NA return a dynamic array?

Question 2 of 15 2/15

How many optional arguments does =NA have?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which function is related to =NA?

Question 5 of 15 5/15

Which use case fits =NA?

Question 6 of 15 6/15

Since which Excel version is =NA available?

Question 7 of 15 7/15

How many required arguments does =NA have?

Question 8 of 15 8/15

What is the output type of =NA?

Question 9 of 15 9/15

Which category does =NA belong to?

Question 10 of 15 10/15

How many arguments does =NA have in total?

Question 11 of 15 11/15

Which formula is a valid example of =NA?

Question 12 of 15 12/15

Which is the correct syntax of =NA?

Question 13 of 15 13/15

Which statement about =NA is correct?

Question 14 of 15 14/15

Which function is NOT related to =NA?

Question 15 of 15 15/15

Is =NA volatile?

Click a question to see the answer.

1. Does =NA return a dynamic array?

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

Explanation: NA does not spill.

2. How many optional arguments does =NA have?

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

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

3. 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

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

4. Which function is related to =NA?

A. ACCRINT
B. NORM.INV
C. MAX
D. IF ✓

Explanation: “IF” is related to NA.

5. Which use case fits =NA?

A. Loans & Installments
B. Conditional Formatting & Validation
C. Error Handling ✓
D. Advanced Formulas

Explanation: Use case “Error Handling” fits NA.

6. Since which Excel version is =NA available?

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

Explanation: Version: “All versions”.

7. How many required arguments does =NA have?

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

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

8. What is the output type of =NA?

A. Logical
B. Date
C. Error ✓
D. Reference

Explanation: Output is “Error”.

9. Which category does =NA belong to?

A. Cube
B. Information ✓
C. Statistical
D. Date & Time

Explanation: Category is “Information”.

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

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

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

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

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

Explanation: Correct example: =NA()

12. Which is the correct syntax of =NA?

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

Explanation: Correct syntax: =NA( )

13. Which statement about =NA is correct?

A. Output is always a dynamic array
B. Text is always ignored
C. You must include the empty parentheses with the function name. Otherwise, Microsoft Excel will not recognize it as a function. ✓
D. Requires add-in

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

14. Which function is NOT related to =NA?

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

Explanation: “PERCENTILE” is not related to NA.

15. Is =NA volatile?

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

Explanation: NA is not volatile.