Compatibility =STDEVP(number1,[number2],...)

Quiz =STDEVP — 15 Questions

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

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

← STDEVP ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is NOT related to =STDEVP?

Question 2 of 15 2/15

Which statement about =STDEVP is correct?

Question 3 of 15 3/15

How many arguments does =STDEVP have in total?

Question 4 of 15 4/15

Does =STDEVP return a dynamic array?

Question 5 of 15 5/15

What is the output type of =STDEVP?

Question 6 of 15 6/15

Which category does =STDEVP belong to?

Question 7 of 15 7/15

What is the type of argument “number1” in =STDEVP?

Question 8 of 15 8/15

In =STDEVP, which is argument #2?

Question 9 of 15 9/15

Is =STDEVP volatile?

Question 10 of 15 10/15

Is argument “number2” required in =STDEVP?

Question 11 of 15 11/15

In =STDEVP, which is argument #1?

Question 12 of 15 12/15

Which formula is a valid example of =STDEVP?

Question 13 of 15 13/15

Since which Excel version is =STDEVP available?

Question 14 of 15 14/15

How many required arguments does =STDEVP have?

Question 15 of 15 15/15

Which is the correct syntax of =STDEVP?

Click a question to see the answer.

1. Which function is NOT related to =STDEVP?

A. PERCENTILE
B. DGET ✓
C. MODE
D. FORECAST

Explanation: “DGET” is not related to STDEVP.

2. Which statement about =STDEVP is correct?

A. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓
B. Arguments can either be numbers or names, arrays, or references that contain numbers.
C. Requires add-in
D. STDEVP 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: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

3. How many arguments does =STDEVP have in total?

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

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

4. Does =STDEVP return a dynamic array?

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

Explanation: STDEVP does not spill.

5. What is the output type of =STDEVP?

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

Explanation: Output is “Number”.

6. Which category does =STDEVP belong to?

A. Information
B. Compatibility ✓
C. Logical
D. Statistical

Explanation: Category is “Compatibility”.

7. What is the type of argument “number1” in =STDEVP?

A. Date
B. Logical
C. Number/Range ✓
D. Value

Explanation: Type of “number1” is “Number/Range”.

8. In =STDEVP, which is argument #2?

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

Explanation: Argument #2 is “number2”.

9. Is =STDEVP volatile?

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

Explanation: STDEVP is not volatile.

10. Is argument “number2” required in =STDEVP?

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

Explanation: “number2” is optional.

11. In =STDEVP, which is argument #1?

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

Explanation: Argument #1 is “number1”.

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

A. =STDEVP(A3:A12) ✓
B. =FORECAST(A3:A12)
C. =STDEVP(A3:A12, 0)
D. STDEVP(A3:A12)

Explanation: Correct example: =STDEVP(A3:A12)

13. Since which Excel version is =STDEVP available?

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

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

14. How many required arguments does =STDEVP have?

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

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

15. Which is the correct syntax of =STDEVP?

A. =STDEVP(number1,[number2],..., 0)
B. =STDEVP(number1,[number2],...) ✓
C. STDEVP(number1,[number2],...)
D. =FORECAST(number1,[number2],...)

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