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

Which statement about =NORMSDIST is correct?

Question 2 of 15 2/15

In =NORMSDIST, which is argument #1?

Question 3 of 15 3/15

Does =NORMSDIST return a dynamic array?

Question 4 of 15 4/15

How many arguments does =NORMSDIST have in total?

Question 5 of 15 5/15

Which is the correct syntax of =NORMSDIST?

Question 6 of 15 6/15

What is the output type of =NORMSDIST?

Question 7 of 15 7/15

How many required arguments does =NORMSDIST have?

Question 8 of 15 8/15

Which formula is a valid example of =NORMSDIST?

Question 9 of 15 9/15

Which category does =NORMSDIST belong to?

Question 10 of 15 10/15

Is argument “z” required in =NORMSDIST?

Question 11 of 15 11/15

Which use case fits =NORMSDIST?

Question 12 of 15 12/15

Which function is related to =NORMSDIST?

Question 13 of 15 13/15

What usually causes #VALUE! in =NORMSDIST?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which statement about =NORMSDIST is correct?

A. Requires add-in
B. 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. ✓
C. Only works in old versions
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.

2. In =NORMSDIST, which is argument #1?

A. z ✓
B. value
C. lookup_value
D. criteria

Explanation: Argument #1 is “z”.

3. Does =NORMSDIST return a dynamic array?

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

Explanation: NORMSDIST does not spill.

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

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

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

5. Which is the correct syntax of =NORMSDIST?

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

Explanation: Correct syntax: =NORMSDIST(z)

6. What is the output type of =NORMSDIST?

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

Explanation: Output is “Number”.

7. How many required arguments does =NORMSDIST have?

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

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

8. Which formula is a valid example of =NORMSDIST?

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

Explanation: Correct example: =NORMSDIST(1.333333)

9. Which category does =NORMSDIST belong to?

A. Text
B. Lookup & Reference
C. Compatibility ✓
D. Web

Explanation: Category is “Compatibility”.

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

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

Explanation: “z” is required.

11. Which use case fits =NORMSDIST?

A. Financial Calculations
B. Conditional Logic
C. Text Manipulation
D. Reporting ✓

Explanation: Use case “Reporting” fits NORMSDIST.

12. Which function is related to =NORMSDIST?

A. FORECAST ✓
B. CONFIDENCE.T
C. IMDIV
D. BINOMDIST

Explanation: “FORECAST” is related to NORMSDIST.

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

A. If z is nonnumeric, NORMSDIST returns the #VALUE! error value. ✓
B. Requires add-in
C. Only works in old versions
D. Select entire column for best performance

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

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

A. Enter a number ✓
B. Select entire column for best performance
C. Volatile and recalculates every time
D. Only works in old versions

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

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

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

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