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

Quiz =VAR.P — 15 Questions

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

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

← VAR.P ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

In =VAR.P, which is argument #1?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which function is related to =VAR.P?

Question 4 of 15 4/15

How many optional arguments does =VAR.P have?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

What is the type of argument “number2” in =VAR.P?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Does =VAR.P return a dynamic array?

Question 9 of 15 9/15

Since which Excel version is =VAR.P available?

Question 10 of 15 10/15

Which statement about =VAR.P is correct?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Which use case fits =VAR.P?

Question 13 of 15 13/15

How many arguments does =VAR.P have in total?

Question 14 of 15 14/15

What is the output type of =VAR.P?

Question 15 of 15 15/15

Is =VAR.P volatile?

Click a question to see the answer.

1. In =VAR.P, which is argument #1?

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

Explanation: Argument #1 is “number1”.

2. Is argument “number2” required in =VAR.P?

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

Explanation: “number2” is optional.

3. Which function is related to =VAR.P?

A. HEX2DEC
B. INT
C. SQRT ✓
D. FORECAST.LINEAR

Explanation: “SQRT” is related to VAR.P.

4. How many optional arguments does =VAR.P have?

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

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

5. Is argument “number1” required in =VAR.P?

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

Explanation: “number1” is required.

6. What is the type of argument “number2” in =VAR.P?

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

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

7. Which formula is a valid example of =VAR.P?

A. VAR.P(A2:A11)
B. =VAR.P(A2:A11) ✓
C. =VAR.P(A2:A11, 0)
D. =SQRT(A2:A11)

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

8. Does =VAR.P return a dynamic array?

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

Explanation: VAR.P does not spill.

9. Since which Excel version is =VAR.P available?

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

Explanation: Version: “Excel 2010”.

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

A. Text is always ignored
B. VAR.P assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the variance by using VAR.S. ✓
C. The equation for VAR.P is: where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size.
D. If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.

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

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

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

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

12. Which use case fits =VAR.P?

A. Conditional Aggregation
B. Securities & Bonds
C. Descriptive Statistics ✓
D. Sort, Filter & Dedupe

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

13. How many arguments does =VAR.P have in total?

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

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

14. What is the output type of =VAR.P?

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

Explanation: Output is “Number”.

15. Is =VAR.P volatile?

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

Explanation: VAR.P is not volatile.