Statistical =STDEV.S(number1,[number2],...)

Quiz =STDEV.S — 15 Questions

15 quiz questions about =STDEV.S — test syntax, arguments, examples & errors!

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

← STDEV.S ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which is the correct syntax of =STDEV.S?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Is =STDEV.S volatile?

Question 4 of 15 4/15

Which function is NOT related to =STDEV.S?

Question 5 of 15 5/15

How many required arguments does =STDEV.S have?

Question 6 of 15 6/15

Which function is related to =STDEV.S?

Question 7 of 15 7/15

Is argument “number2” required in =STDEV.S?

Question 8 of 15 8/15

How many optional arguments does =STDEV.S have?

Question 9 of 15 9/15

Which category does =STDEV.S belong to?

Question 10 of 15 10/15

Which statement about =STDEV.S is correct?

Question 11 of 15 11/15

Which formula is a valid example of =STDEV.S?

Question 12 of 15 12/15

What is the type of argument “number2” in =STDEV.S?

Question 13 of 15 13/15

Which use case fits =STDEV.S?

Question 14 of 15 14/15

Does =STDEV.S return a dynamic array?

Question 15 of 15 15/15

What is the type of argument “number1” in =STDEV.S?

Click a question to see the answer.

1. Which is the correct syntax of =STDEV.S?

A. STDEV.S(number1,[number2],...)
B. =AVERAGE(number1,[number2],...)
C. =STDEV.S(number1,[number2],..., 0)
D. =STDEV.S(number1,[number2],...) ✓

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

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

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

Explanation: Argument #2 is “number2”.

3. Is =STDEV.S volatile?

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

Explanation: STDEV.S is not volatile.

4. Which function is NOT related to =STDEV.S?

A. DCOUNT ✓
B. AVEDEV
C. STDEV
D. AVERAGE

Explanation: “DCOUNT” is not related to STDEV.S.

5. How many required arguments does =STDEV.S have?

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

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

6. Which function is related to =STDEV.S?

A. AVERAGE ✓
B. COTH
C. MUNIT
D. NORMINV

Explanation: “AVERAGE” is related to STDEV.S.

7. Is argument “number2” required in =STDEV.S?

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

Explanation: “number2” is optional.

8. How many optional arguments does =STDEV.S have?

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

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

9. Which category does =STDEV.S belong to?

A. Statistical ✓
B. Cube
C. Text
D. Date & Time

Explanation: Category is “Statistical”.

10. Which statement about =STDEV.S is correct?

A. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the STDEVA function.
B. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
C. STDEV.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the standard deviation using STDEV.P. ✓
D. Volatile and recalculates every time

Explanation: Correct: STDEV.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the standard deviation using STDEV.P.

11. Which formula is a valid example of =STDEV.S?

A. =STDEV.S(A2:A11) ✓
B. STDEV.S(A2:A11)
C. =STDEV.S(A2:A11, 0)
D. =AVERAGE(A2:A11)

Explanation: Correct example: =STDEV.S(A2:A11)

12. What is the type of argument “number2” in =STDEV.S?

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

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

13. Which use case fits =STDEV.S?

A. Investment Appraisal
B. Descriptive Statistics ✓
C. Daily Tasks
D. Worksheet Info & Navigation

Explanation: Use case “Descriptive Statistics” fits STDEV.S.

14. Does =STDEV.S return a dynamic array?

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

Explanation: STDEV.S does not spill.

15. What is the type of argument “number1” in =STDEV.S?

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

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