Compatibility =NORMSDIST(z)

Quiz =NORMSDIST — 15 Questions

15 quiz questions about =NORMSDIST — test syntax, arguments, examples & errors!

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

← NORMSDIST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Since which Excel version is =NORMSDIST available?

Question 2 of 15 2/15

What is the type of argument “z” in =NORMSDIST?

Question 3 of 15 3/15

Which statement about =NORMSDIST is correct?

Question 4 of 15 4/15

What is the output type of =NORMSDIST?

Question 5 of 15 5/15

Which category does =NORMSDIST belong to?

Question 6 of 15 6/15

Is argument “z” required in =NORMSDIST?

Question 7 of 15 7/15

Which use case fits =NORMSDIST?

Question 8 of 15 8/15

Which is the correct syntax of =NORMSDIST?

Question 9 of 15 9/15

How many required arguments does =NORMSDIST have?

Question 10 of 15 10/15

How many optional arguments does =NORMSDIST have?

Question 11 of 15 11/15

Is =NORMSDIST volatile?

Question 12 of 15 12/15

What usually causes #VALUE! in =NORMSDIST?

Question 13 of 15 13/15

How many arguments does =NORMSDIST have in total?

Question 14 of 15 14/15

Which function is NOT related to =NORMSDIST?

Question 15 of 15 15/15

What is the fix for #VALUE! in =NORMSDIST?

Click a question to see the answer.

1. Since which Excel version is =NORMSDIST available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

2. What is the type of argument “z” in =NORMSDIST?

A. Text
B. Array
C. Number ✓
D. Reference

Explanation: Type of “z” is “Number”.

3. Which statement about =NORMSDIST is correct?

A. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓
B. The equation for the standard normal density function is:
C. Volatile and recalculates every time
D. Select entire column for best performance

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

4. What is the output type of =NORMSDIST?

A. Array
B. Number ✓
C. Mixed
D. Value

Explanation: Output is “Number”.

5. Which category does =NORMSDIST belong to?

A. Compatibility ✓
B. Lookup & Reference
C. Database
D. Date & Time

Explanation: Category is “Compatibility”.

6. Is argument “z” required in =NORMSDIST?

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

Explanation: “z” is required.

7. Which use case fits =NORMSDIST?

A. Securities & Bonds
B. Advanced Formulas
C. Reporting ✓
D. Sort, Filter & Dedupe

Explanation: Use case “Reporting” fits NORMSDIST.

8. Which is the correct syntax of =NORMSDIST?

A. NORMSDIST(z)
B. =NORMSDIST(z) ✓
C. =FORECAST(z)
D. =NORMSDIST(z, 0)

Explanation: Correct syntax: =NORMSDIST(z)

9. How many required arguments does =NORMSDIST have?

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

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

10. How many optional arguments does =NORMSDIST have?

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

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

11. Is =NORMSDIST volatile?

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

Explanation: NORMSDIST is not volatile.

12. What usually causes #VALUE! in =NORMSDIST?

A. Select entire column for best performance
B. Only works in old versions
C. Volatile and recalculates every time
D. If z is nonnumeric, NORMSDIST returns the #VALUE! error value. ✓

Explanation: If z is nonnumeric, NORMSDIST returns the #VALUE! error value. — Fix: Enter a number

13. How many arguments does =NORMSDIST have in total?

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

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

14. Which function is NOT related to =NORMSDIST?

A. FORECAST
B. LET ✓
C. PERCENTILE
D. MODE

Explanation: “LET” is not related to NORMSDIST.

15. What is the fix for #VALUE! in =NORMSDIST?

A. Select entire column for best performance
B. Enter a number ✓
C. Output is always a dynamic array
D. Text is always ignored

Explanation: If z is nonnumeric, NORMSDIST returns the #VALUE! error value. — Fix: Enter a number