Compatibility =NORMDIST(x,mean,standard_dev,cumulative)

Quiz =NORMDIST — 15 Questions

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

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

← NORMDIST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “cumulative” in =NORMDIST?

Question 2 of 15 2/15

Which statement about =NORMDIST is correct?

Question 3 of 15 3/15

Is argument “x” required in =NORMDIST?

Question 4 of 15 4/15

Which function is related to =NORMDIST?

Question 5 of 15 5/15

Which category does =NORMDIST belong to?

Question 6 of 15 6/15

In =NORMDIST, which is argument #3?

Question 7 of 15 7/15

What is the type of argument “mean” in =NORMDIST?

Question 8 of 15 8/15

What is the type of argument “x” in =NORMDIST?

Question 9 of 15 9/15

Is argument “mean” required in =NORMDIST?

Question 10 of 15 10/15

Which formula is a valid example of =NORMDIST?

Question 11 of 15 11/15

How many optional arguments does =NORMDIST have?

Question 12 of 15 12/15

How many required arguments does =NORMDIST have?

Question 13 of 15 13/15

What is the fix for #NUM! in =NORMDIST?

Question 14 of 15 14/15

Does =NORMDIST return a dynamic array?

Question 15 of 15 15/15

Is argument “standard_dev” required in =NORMDIST?

Click a question to see the answer.

1. What is the type of argument “cumulative” in =NORMDIST?

A. Text
B. Logical ✓
C. Value
D. Mixed

Explanation: Type of “cumulative” is “Logical”.

2. Which statement about =NORMDIST is correct?

A. Volatile and recalculates every time
B. This function has been replaced along with other functions that may provide improved accuracy and whose names better reflect their purpose. This function remains available for backward compatibility but may not be available in future versions of Excel. Consider now using the newer functions. ✓
C. When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
D. Select entire column for best performance

Explanation: Correct: This function has been replaced along with other functions that may provide improved accuracy and whose names better reflect their purpose. This function remains available for backward compatibility but may not be available in future versions of Excel. Consider now using the newer functions.

3. Is argument “x” required in =NORMDIST?

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

Explanation: “x” is required.

4. Which function is related to =NORMDIST?

A. FORECAST ✓
B. SLOPE
C. NA
D. WORKDAY

Explanation: “FORECAST” is related to NORMDIST.

5. Which category does =NORMDIST belong to?

A. Date & Time
B. Financial
C. Text
D. Compatibility ✓

Explanation: Category is “Compatibility”.

6. In =NORMDIST, which is argument #3?

A. lookup_value
B. mean
C. value
D. standard_dev ✓

Explanation: Argument #3 is “standard_dev”.

7. What is the type of argument “mean” in =NORMDIST?

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

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

8. What is the type of argument “x” in =NORMDIST?

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

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

9. Is argument “mean” required in =NORMDIST?

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

Explanation: “mean” is required.

10. Which formula is a valid example of =NORMDIST?

A. NORMDIST(A2,A3,A4,TRUE)
B. =NORMDIST(A2,A3,A4,TRUE, 0)
C. =NORMDIST(A2,A3,A4,TRUE) ✓
D. =FORECAST(A2,A3,A4,TRUE)

Explanation: Correct example: =NORMDIST(A2,A3,A4,TRUE)

11. How many optional arguments does =NORMDIST have?

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

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

12. How many required arguments does =NORMDIST have?

A. 5
B. 3
C. 4 ✓
D. 6

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

13. What is the fix for #NUM! in =NORMDIST?

A. >0 ✓
B. مقدار mean یا standard_dev غیرعددی است.
C. Requires add-in
D. Volatile and recalculates every time

Explanation: If standard_dev ≤ 0, NORMDIST returns the #NUM! error value. — Fix: >0

14. Does =NORMDIST return a dynamic array?

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

Explanation: NORMDIST does not spill.

15. Is argument “standard_dev” required in =NORMDIST?

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

Explanation: “standard_dev” is required.