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

How many arguments does =STDEV.P have in total?

Question 2 of 10 2/10

Which function is NOT related to =STDEV.P?

Question 3 of 10 3/10

Since which Excel version is =STDEV.P available?

Question 4 of 10 4/10

What is the output type of =STDEV.P?

Question 5 of 10 5/10

Which category does =STDEV.P belong to?

Question 6 of 10 6/10

Which statement about =STDEV.P is correct?

Question 7 of 10 7/10

How many required arguments does =STDEV.P have?

Question 8 of 10 8/10

Is =STDEV.P volatile?

Question 9 of 10 9/10

How many optional arguments does =STDEV.P have?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. How many arguments does =STDEV.P have in total?

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

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

2. Which function is NOT related to =STDEV.P?

A. STDEV-S
B. IMAGINARY ✓
C. AVERAGE
D. STDEVPA

Explanation: “IMAGINARY” is not related to STDEV.P.

3. Since which Excel version is =STDEV.P available?

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

Explanation: Version: “Excel 2010”.

4. What is the output type of =STDEV.P?

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

Explanation: Output is “Number”.

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

A. Cube
B. Financial
C. Statistical ✓
D. Database

Explanation: Category is “Statistical”.

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

A. Arguments that are error values or text that cannot be translated into numbers cause errors.
B. For large sample sizes, STDEV.S and STDEV.P return approximately equal values.
C. 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. ✓
D. The standard deviation is calculated using the "n" method.

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.

7. How many required arguments does =STDEV.P have?

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

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

8. Is =STDEV.P volatile?

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

Explanation: STDEV.P is not volatile.

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

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

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

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

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

Explanation: Argument #2 is “number2”.