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

Quiz =STDEV — 15 Questions

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

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

← STDEV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Is argument “number2” required in =STDEV?

Question 3 of 15 3/15

How many arguments does =STDEV have in total?

Question 4 of 15 4/15

How many optional arguments does =STDEV have?

Question 5 of 15 5/15

Which use case fits =STDEV?

Question 6 of 15 6/15

Which function is related to =STDEV?

Question 7 of 15 7/15

In =STDEV, which is argument #1?

Question 8 of 15 8/15

Which is the correct syntax of =STDEV?

Question 9 of 15 9/15

How many required arguments does =STDEV have?

Question 10 of 15 10/15

Is argument “number1” required in =STDEV?

Question 11 of 15 11/15

What is the output type of =STDEV?

Question 12 of 15 12/15

Which formula is a valid example of =STDEV?

Question 13 of 15 13/15

Which category does =STDEV belong to?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which statement about =STDEV is correct?

Click a question to see the answer.

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

A. Date
B. Array
C. Number ✓
D. Text

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

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

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

Explanation: “number2” is optional.

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

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

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

4. How many optional arguments does =STDEV have?

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

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

5. Which use case fits =STDEV?

A. Sort, Filter & Dedupe
B. Descriptive Statistics ✓
C. Investment Appraisal
D. Comparation

Explanation: Use case “Descriptive Statistics” fits STDEV.

6. Which function is related to =STDEV?

A. F.DIST.RT
B. BINOM.DIST
C. CUBESETCOUNT
D. AVERAGE ✓

Explanation: “AVERAGE” is related to STDEV.

7. In =STDEV, which is argument #1?

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

Explanation: Argument #1 is “number1”.

8. Which is the correct syntax of =STDEV?

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

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

9. How many required arguments does =STDEV have?

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

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

10. Is argument “number1” required in =STDEV?

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

Explanation: “number1” is required.

11. What is the output type of =STDEV?

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

Explanation: Output is “Number”.

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

A. =STDEV(A3:A12, 0)
B. =AVERAGE(A3:A12)
C. STDEV(A3:A12)
D. =STDEV(A3:A12) ✓

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

13. Which category does =STDEV belong to?

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

Explanation: Category is “Compatibility”.

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

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

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

15. Which statement about =STDEV is correct?

A. Only works in old versions
B. Select entire column for best performance
C. Arguments can either be numbers or names, arrays, or references that contain numbers.
D. 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. ✓

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.