Statistical =STDEVPA(value1, [value2], ...)

Quiz =STDEVPA — 10 Questions

10 quiz questions about =STDEVPA — test syntax, arguments, examples & errors!

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

← STDEVPA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =STDEVPA is correct?

Question 2 of 10 2/10

Since which Excel version is =STDEVPA available?

Question 3 of 10 3/10

In =STDEVPA, which is argument #1?

Question 4 of 10 4/10

How many optional arguments does =STDEVPA have?

Question 5 of 10 5/10

How many required arguments does =STDEVPA have?

Question 6 of 10 6/10

What is the type of argument “value1” in =STDEVPA?

Question 7 of 10 7/10

What is the output type of =STDEVPA?

Question 8 of 10 8/10

Which formula is a valid example of =STDEVPA?

Question 9 of 10 9/10

Which category does =STDEVPA belong to?

Question 10 of 10 10/10

Does =STDEVPA return a dynamic array?

Click a question to see the answer.

1. Which statement about =STDEVPA is correct?

A. Arguments that are error values or text that cannot be translated into numbers cause errors.
B. STDEVPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the standard deviation by using STDEVA. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

Explanation: Correct: STDEVPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the standard deviation by using STDEVA.

2. Since which Excel version is =STDEVPA available?

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

Explanation: Version: “All versions”.

3. In =STDEVPA, which is argument #1?

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

Explanation: Argument #1 is “value1”.

4. How many optional arguments does =STDEVPA have?

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

Explanation: =STDEVPA has 1 required, 0 optional (1 total).

5. How many required arguments does =STDEVPA have?

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

Explanation: =STDEVPA has 1 required, 0 optional (1 total).

6. What is the type of argument “value1” in =STDEVPA?

A. Any type ✓
B. Value
C. Array
D. Date

Explanation: Type of “value1” is “Any type”.

7. What is the output type of =STDEVPA?

A. Number ✓
B. Array
C. Logical
D. Value

Explanation: Output is “Number”.

8. Which formula is a valid example of =STDEVPA?

A. =STDEVPA(A3:A12) ✓
B. =STDEVPA(A3:A12, 0)
C. STDEVPA(A3:A12)
D. =STDEV-P(A3:A12)

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

9. Which category does =STDEVPA belong to?

A. Statistical ✓
B. Lookup & Reference
C. Financial
D. Cube

Explanation: Category is “Statistical”.

10. Does =STDEVPA return a dynamic array?

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

Explanation: STDEVPA does not spill.