Statistical =VARPA(value1, [value2], ...)

Quiz =VARPA — 10 Questions

10 quiz questions about =VARPA — test syntax, arguments, examples & errors!

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

← VARPA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “value1” required in =VARPA?

Question 2 of 10 2/10

Which use case fits =VARPA?

Question 3 of 10 3/10

In =VARPA, which is argument #1?

Question 4 of 10 4/10

Which category does =VARPA belong to?

Question 5 of 10 5/10

Is =VARPA volatile?

Question 6 of 10 6/10

Which formula is a valid example of =VARPA?

Question 7 of 10 7/10

How many required arguments does =VARPA have?

Question 8 of 10 8/10

What is the type of argument “value1” in =VARPA?

Question 9 of 10 9/10

Which is the correct syntax of =VARPA?

Question 10 of 10 10/10

Which statement about =VARPA is correct?

Click a question to see the answer.

1. Is argument “value1” required in =VARPA?

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

Explanation: “value1” is required.

2. Which use case fits =VARPA?

A. Advanced Formulas
B. Reporting
C. Worksheet Info & Navigation
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits VARPA.

3. In =VARPA, which is argument #1?

A. lookup_value
B. range
C. value1 ✓
D. value

Explanation: Argument #1 is “value1”.

4. Which category does =VARPA belong to?

A. Database
B. Financial
C. Statistical ✓
D. Information

Explanation: Category is “Statistical”.

5. Is =VARPA volatile?

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

Explanation: VARPA is not volatile.

6. Which formula is a valid example of =VARPA?

A. =VARPA(A2:A11, 0)
B. =STDEVPA(A2:A11)
C. VARPA(A2:A11)
D. =VARPA(A2:A11) ✓

Explanation: Correct example: =VARPA(A2:A11)

7. How many required arguments does =VARPA have?

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

Explanation: =VARPA has 1 required, 0 optional (1 total).

8. What is the type of argument “value1” in =VARPA?

A. Date
B. Any type ✓
C. Text
D. Reference

Explanation: Type of “value1” is “Any type”.

9. Which is the correct syntax of =VARPA?

A. =VARPA(value1, [value2], ..., 0)
B. =STDEVPA(value1, [value2], ...)
C. =VARPA(value1, [value2], ...) ✓
D. VARPA(value1, [value2], ...)

Explanation: Correct syntax: =VARPA(value1, [value2], ...)

10. Which statement about =VARPA is correct?

A. If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
B. Only works in old versions
C. VARPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the variance by using VARA. ✓
D. If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the VARP function.

Explanation: Correct: VARPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the variance by using VARA.