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

Quiz =STDEVPA — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which statement about =STDEVPA is correct?

Question 2 of 15 2/15

In =STDEVPA, which is argument #1?

Question 3 of 15 3/15

Is =STDEVPA volatile?

Question 4 of 15 4/15

Which function is NOT related to =STDEVPA?

Question 5 of 15 5/15

Which formula is a valid example of =STDEVPA?

Question 6 of 15 6/15

How many arguments does =STDEVPA have in total?

Question 7 of 15 7/15

How many optional arguments does =STDEVPA have?

Question 8 of 15 8/15

Since which Excel version is =STDEVPA available?

Question 9 of 15 9/15

Which is the correct syntax of =STDEVPA?

Question 10 of 15 10/15

Is argument “value1” required in =STDEVPA?

Question 11 of 15 11/15

Does =STDEVPA return a dynamic array?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

How many required arguments does =STDEVPA have?

Question 14 of 15 14/15

Which function is related to =STDEVPA?

Question 15 of 15 15/15

What is the output type of =STDEVPA?

Click a question to see the answer.

1. Which statement about =STDEVPA is correct?

A. 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. ✓
B. Arguments can be the following: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
C. If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
D. Text is always ignored

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. In =STDEVPA, which is argument #1?

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

Explanation: Argument #1 is “value1”.

3. Is =STDEVPA volatile?

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

Explanation: STDEVPA is not volatile.

4. Which function is NOT related to =STDEVPA?

A. STDEV-P
B. VARPA
C. STDEVA
D. TEXTBEFORE ✓

Explanation: “TEXTBEFORE” is not related to STDEVPA.

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

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

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

6. How many arguments does =STDEVPA have in total?

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

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

7. How many optional arguments does =STDEVPA have?

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

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

8. Since which Excel version is =STDEVPA available?

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

Explanation: Version: “All versions”.

9. Which is the correct syntax of =STDEVPA?

A. =STDEVPA(value1, [value2], ...) ✓
B. =STDEVPA(value1, [value2], ..., 0)
C. STDEVPA(value1, [value2], ...)
D. =STDEV-P(value1, [value2], ...)

Explanation: Correct syntax: =STDEVPA(value1, [value2], ...)

10. Is argument “value1” required in =STDEVPA?

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

Explanation: “value1” is required.

11. Does =STDEVPA return a dynamic array?

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

Explanation: STDEVPA does not spill.

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

A. Any type ✓
B. Date
C. Logical
D. Number

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

13. How many required arguments does =STDEVPA have?

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

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

14. Which function is related to =STDEVPA?

A. STDEV-P ✓
B. NETWORKDAYS
C. TRANSLATE
D. LEFT

Explanation: “STDEV-P” is related to STDEVPA.

15. What is the output type of =STDEVPA?

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

Explanation: Output is “Number”.