Statistical =STDEV.P(number1,[number2],...)

Quiz =STDEV.P — 10 Questions

10 quiz questions about =STDEV.P — test syntax, arguments, examples & errors!

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

← STDEV.P ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =STDEV.P belong to?

Question 2 of 10 2/10

How many optional arguments does =STDEV.P have?

Question 3 of 10 3/10

Is argument “number2” required in =STDEV.P?

Question 4 of 10 4/10

Which statement about =STDEV.P is correct?

Question 5 of 10 5/10

In =STDEV.P, which is argument #2?

Question 6 of 10 6/10

Is argument “number1” required in =STDEV.P?

Question 7 of 10 7/10

Does =STDEV.P return a dynamic array?

Question 8 of 10 8/10

In =STDEV.P, which is argument #1?

Question 9 of 10 9/10

Which is the correct syntax of =STDEV.P?

Question 10 of 10 10/10

Which function is related to =STDEV.P?

Click a question to see the answer.

1. Which category does =STDEV.P belong to?

A. Database
B. Statistical ✓
C. Lookup & Reference
D. Text

Explanation: Category is “Statistical”.

2. How many optional arguments does =STDEV.P have?

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

Explanation: =STDEV.P has 1 required, 1 optional (2 total).

3. Is argument “number2” required in =STDEV.P?

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

Explanation: “number2” is optional.

4. Which statement about =STDEV.P is correct?

A. The standard deviation is calculated using the "n" method.
B. If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
C. Only works in old versions
D. STDEV.P assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using STDEV. ✓

Explanation: Correct: STDEV.P assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using STDEV.

5. In =STDEV.P, which is argument #2?

A. range
B. lookup_value
C. criteria
D. number2 ✓

Explanation: Argument #2 is “number2”.

6. Is argument “number1” required in =STDEV.P?

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

Explanation: “number1” is required.

7. Does =STDEV.P return a dynamic array?

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

Explanation: STDEV.P does not spill.

8. In =STDEV.P, which is argument #1?

A. value
B. number2
C. criteria
D. number1 ✓

Explanation: Argument #1 is “number1”.

9. Which is the correct syntax of =STDEV.P?

A. STDEV.P(number1,[number2],...)
B. =STDEV.P(number1,[number2],..., 0)
C. =AVERAGE(number1,[number2],...)
D. =STDEV.P(number1,[number2],...) ✓

Explanation: Correct syntax: =STDEV.P(number1,[number2],...)

10. Which function is related to =STDEV.P?

A. PPMT
B. HYPGEOMDIST
C. AVERAGE ✓
D. COLUMN

Explanation: “AVERAGE” is related to STDEV.P.