Compatibility =NORMSDIST(z)

Quiz =NORMSDIST — 10 Questions

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

Question 1 of 10 1/10

How many arguments does =NORMSDIST have in total?

Question 2 of 10 2/10

Is =NORMSDIST volatile?

Question 3 of 10 3/10

Which formula is a valid example of =NORMSDIST?

Question 4 of 10 4/10

What usually causes #VALUE! in =NORMSDIST?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

In =NORMSDIST, which is argument #1?

Question 7 of 10 7/10

Does =NORMSDIST return a dynamic array?

Question 8 of 10 8/10

How many required arguments does =NORMSDIST have?

Question 9 of 10 9/10

Which statement about =NORMSDIST is correct?

Question 10 of 10 10/10

Which category does =NORMSDIST belong to?

Click a question to see the answer.

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

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

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

2. Is =NORMSDIST volatile?

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

Explanation: NORMSDIST is not volatile.

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

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

Explanation: Correct example: =NORMSDIST(1.333333)

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

A. Volatile and recalculates every time
B. If z is nonnumeric, NORMSDIST returns the #VALUE! error value. ✓
C. Requires add-in
D. Only works in old versions

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

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

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

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

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

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

Explanation: Argument #1 is “z”.

7. Does =NORMSDIST return a dynamic array?

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

Explanation: NORMSDIST does not spill.

8. How many required arguments does =NORMSDIST have?

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

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

9. 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. Output is always a dynamic array
C. The equation for the standard normal density function is:
D. Volatile and recalculates every time

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.

10. Which category does =NORMSDIST belong to?

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

Explanation: Category is “Compatibility”.