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

Is argument “number1” required in =STDEVP?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

How many optional arguments does =STDEVP have?

Question 5 of 15 5/15

In =STDEVP, which is argument #2?

Question 6 of 15 6/15

Which use case fits =STDEVP?

Question 7 of 15 7/15

How many arguments does =STDEVP have in total?

Question 8 of 15 8/15

Which function is related to =STDEVP?

Question 9 of 15 9/15

Which is the correct syntax of =STDEVP?

Question 10 of 15 10/15

Which formula is a valid example of =STDEVP?

Question 11 of 15 11/15

Which statement about =STDEVP is correct?

Question 12 of 15 12/15

In =STDEVP, which is argument #1?

Question 13 of 15 13/15

What is the output type of =STDEVP?

Question 14 of 15 14/15

Is =STDEVP volatile?

Question 15 of 15 15/15

Which function is NOT related to =STDEVP?

Click a question to see the answer.

1. Is argument “number1” required in =STDEVP?

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

Explanation: “number1” is required.

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

A. Number
B. Reference
C. Number/Range ✓
D. Text

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

3. What is the type of argument “number2” in =STDEVP?

A. Logical
B. Number/Range ✓
C. Text
D. Mixed

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

4. How many optional arguments does =STDEVP have?

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

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

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

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

Explanation: Argument #2 is “number2”.

6. Which use case fits =STDEVP?

A. Securities & Bonds
B. Forecasting & Trends
C. Text Manipulation
D. Reporting ✓

Explanation: Use case “Reporting” fits STDEVP.

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

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

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

8. Which function is related to =STDEVP?

A. TEXTAFTER
B. MEDIAN
C. FORECAST ✓
D. TIME

Explanation: “FORECAST” is related to STDEVP.

9. Which is the correct syntax of =STDEVP?

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

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

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

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

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

11. Which statement about =STDEVP is correct?

A. Text is always ignored
B. 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. ✓
C. The standard deviation is calculated using the "n" method.
D. Select entire column for best performance

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.

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

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

Explanation: Argument #1 is “number1”.

13. What is the output type of =STDEVP?

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

Explanation: Output is “Number”.

14. Is =STDEVP volatile?

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

Explanation: STDEVP is not volatile.

15. Which function is NOT related to =STDEVP?

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

Explanation: “EOMONTH” is not related to STDEVP.