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

Quiz =VAR.S — 15 Questions

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

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

← VAR.S ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

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

Question 3 of 15 3/15

How many required arguments does =VAR.S have?

Question 4 of 15 4/15

Since which Excel version is =VAR.S available?

Question 5 of 15 5/15

Which function is related to =VAR.S?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Is argument “number1” required in =VAR.S?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is =VAR.S volatile?

Question 10 of 15 10/15

Which statement about =VAR.S is correct?

Question 11 of 15 11/15

What is the output type of =VAR.S?

Question 12 of 15 12/15

Which category does =VAR.S belong to?

Question 13 of 15 13/15

Which is the correct syntax of =VAR.S?

Question 14 of 15 14/15

Does =VAR.S return a dynamic array?

Question 15 of 15 15/15

Which use case fits =VAR.S?

Click a question to see the answer.

1. Is argument “number2” required in =VAR.S?

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

Explanation: “number2” is optional.

2. Which formula is a valid example of =VAR.S?

A. VAR.S(A2:A11)
B. =VAR.S(A2:A11, 0)
C. =COVARIANCE-S(A2:A11)
D. =VAR.S(A2:A11) ✓

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

3. How many required arguments does =VAR.S have?

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

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

4. Since which Excel version is =VAR.S available?

A. All versions
B. Excel 365
C. Excel 2010 ✓
D. Excel 2019

Explanation: Version: “Excel 2010”.

5. Which function is related to =VAR.S?

A. COVARIANCE-S ✓
B. PMT
C. MIRR
D. EXP

Explanation: “COVARIANCE-S” is related to VAR.S.

6. In =VAR.S, which is argument #2?

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

Explanation: Argument #2 is “number2”.

7. Is argument “number1” required in =VAR.S?

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

Explanation: “number1” is required.

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

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

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

9. Is =VAR.S volatile?

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

Explanation: VAR.S is not volatile.

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

A. Only works in old versions
B. VAR.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VAR.P. ✓
C. Logical values, and text representations of numbers that you type directly into the list of arguments are counted.
D. Arguments that are error values or text that cannot be translated into numbers cause errors.

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

11. What is the output type of =VAR.S?

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

Explanation: Output is “Number”.

12. Which category does =VAR.S belong to?

A. Date & Time
B. Financial
C. Statistical ✓
D. Lookup & Reference

Explanation: Category is “Statistical”.

13. Which is the correct syntax of =VAR.S?

A. VAR.S(number1,[number2],...)
B. =VAR.S(number1,[number2],...) ✓
C. =COVARIANCE-S(number1,[number2],...)
D. =VAR.S(number1,[number2],..., 0)

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

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

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

Explanation: VAR.S does not spill.

15. Which use case fits =VAR.S?

A. Scientific & Unit Conversion
B. Data Cleaning
C. Ranking & Top N
D. Descriptive Statistics ✓

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