Statistical
=NORM.S.DIST(z,cumulative)
Quiz =NORM.S.DIST — 10 Questions
10 quiz questions about =NORM.S.DIST — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Which statement about =NORM.S.DIST is correct?
Explanation: Correct: The standard normal density function is determined with this equation:
Question 2 of 10
2/10
How many required arguments does =NORM.S.DIST have?
Explanation: =NORM.S.DIST has 2 required, 2 optional (4 total).
Question 3 of 10
3/10
Does =NORM.S.DIST return a dynamic array?
Explanation: NORM.S.DIST does not spill.
Question 4 of 10
4/10
What is the fix for #VALUE! in =NORM.S.DIST?
Explanation: If z is nonnumeric, NORM.S.DIST returns the #VALUE! error. — Fix: Ensure the arguments are real numbers, not text
Question 5 of 10
5/10
Is argument “cumulative” required in =NORM.S.DIST?
Explanation: “cumulative” is required.
Question 6 of 10
6/10
What is the type of argument “tRUE” in =NORM.S.DIST?
Explanation: Type of “tRUE” is “Number”.
Question 7 of 10
7/10
Which is the correct syntax of =NORM.S.DIST?
Explanation: Correct syntax: =NORM.S.DIST(z,cumulative)
Question 8 of 10
8/10
In =NORM.S.DIST, which is argument #1?
Explanation: Argument #1 is “z”.
Question 9 of 10
9/10
Is argument “z” required in =NORM.S.DIST?
Explanation: “z” is required.
Question 10 of 10
10/10
Which formula is a valid example of =NORM.S.DIST?
Explanation: Correct example: =NORM.S.DIST(1.333333,TRUE)