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 usually causes #VALUE! in =NORMDIST?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Is argument “mean” required in =NORMDIST?

Question 5 of 15 5/15

Is argument “standard_dev” required in =NORMDIST?

Question 6 of 15 6/15

What usually causes #NUM! in =NORMDIST?

Question 7 of 15 7/15

Which statement about =NORMDIST is correct?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Since which Excel version is =NORMDIST available?

Question 11 of 15 11/15

How many optional arguments does =NORMDIST have?

Question 12 of 15 12/15

Which formula is a valid example of =NORMDIST?

Question 13 of 15 13/15

Which is the correct syntax of =NORMDIST?

Question 14 of 15 14/15

Which category does =NORMDIST belong to?

Question 15 of 15 15/15

Is argument “cumulative” required in =NORMDIST?

Click a question to see the answer.

1. What usually causes #VALUE! in =NORMDIST?

A. Volatile and recalculates every time
B. If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value. ✓
C. Only works in old versions
D. Output is always a dynamic array

Explanation: If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value. — Fix: برای mean و standard_dev مقادیر عددی وارد کنید.

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

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

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

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

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

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

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

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

Explanation: “mean” is required.

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

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

Explanation: “standard_dev” is required.

6. What usually causes #NUM! in =NORMDIST?

A. مقدار mean یا standard_dev غیرعددی است.
B. Only works in old versions
C. Text is always ignored
D. If standard_dev ≤ 0, NORMDIST returns the #NUM! error value. ✓

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

7. Which statement about =NORMDIST is correct?

A. 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. ✓
B. If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST.
C. Only works in old versions
D. Text is always ignored

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.

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

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

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

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

A. Logical ✓
B. Reference
C. Mixed
D. Array

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

10. Since which Excel version is =NORMDIST available?

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

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

11. How many optional arguments does =NORMDIST have?

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

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

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

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

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

13. Which is the correct syntax of =NORMDIST?

A. =FORECAST(x,mean,standard_dev,cumulative)
B. =NORMDIST(x,mean,standard_dev,cumulative, 0)
C. =NORMDIST(x,mean,standard_dev,cumulative) ✓
D. NORMDIST(x,mean,standard_dev,cumulative)

Explanation: Correct syntax: =NORMDIST(x,mean,standard_dev,cumulative)

14. Which category does =NORMDIST belong to?

A. Database
B. Compatibility ✓
C. Lookup & Reference
D. Cube

Explanation: Category is “Compatibility”.

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

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

Explanation: “cumulative” is required.