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

Quiz =VAR.P — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Since which Excel version is =VAR.P available?

Question 4 of 10 4/10

Is =VAR.P volatile?

Question 5 of 10 5/10

Which statement about =VAR.P is correct?

Question 6 of 10 6/10

Which function is related to =VAR.P?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Does =VAR.P return a dynamic array?

Question 10 of 10 10/10

How many required arguments does =VAR.P have?

Click a question to see the answer.

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

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

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

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

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

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

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

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

Explanation: Version: “Excel 2010”.

4. Is =VAR.P volatile?

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

Explanation: VAR.P is not volatile.

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

A. Requires add-in
B. 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.
C. 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. ✓
D. The equation for VAR.P is: where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size.

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.

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

A. BESSELJ
B. ACOS
C. XNPV
D. SQRT ✓

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

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

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

Explanation: “number1” is required.

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

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

Explanation: Argument #1 is “number1”.

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

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

Explanation: VAR.P does not spill.

10. How many required arguments does =VAR.P have?

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

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