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

Quiz =VARA — 15 Questions

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

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

← VARA ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many arguments does =VARA have in total?

Question 2 of 15 2/15

Which category does =VARA belong to?

Question 3 of 15 3/15

Since which Excel version is =VARA available?

Question 4 of 15 4/15

Which use case fits =VARA?

Question 5 of 15 5/15

How many required arguments does =VARA have?

Question 6 of 15 6/15

Which function is NOT related to =VARA?

Question 7 of 15 7/15

Which formula is a valid example of =VARA?

Question 8 of 15 8/15

In =VARA, which is argument #1?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which is the correct syntax of =VARA?

Question 11 of 15 11/15

Does =VARA return a dynamic array?

Question 12 of 15 12/15

Is =VARA volatile?

Question 13 of 15 13/15

Which function is related to =VARA?

Question 14 of 15 14/15

Which statement about =VARA is correct?

Question 15 of 15 15/15

Is argument “value1” required in =VARA?

Click a question to see the answer.

1. How many arguments does =VARA have in total?

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

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

2. Which category does =VARA belong to?

A. Statistical ✓
B. Engineering
C. Text
D. Information

Explanation: Category is “Statistical”.

3. Since which Excel version is =VARA available?

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

Explanation: Version: “All versions”.

4. Which use case fits =VARA?

A. Lookup & Retrieval
B. Daily Tasks
C. Workdays & Due Dates
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits VARA.

5. How many required arguments does =VARA have?

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

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

6. Which function is NOT related to =VARA?

A. VAR-S
B. YEAR ✓
C. VARPA
D. STDEVA

Explanation: “YEAR” is not related to VARA.

7. Which formula is a valid example of =VARA?

A. =STDEVA(A2:A11)
B. =VARA(A2:A11) ✓
C. VARA(A2:A11)
D. =VARA(A2:A11, 0)

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

8. In =VARA, which is argument #1?

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

Explanation: Argument #1 is “value1”.

9. What is the type of argument “value1” in =VARA?

A. Any type ✓
B. Value
C. Array
D. Reference

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

10. Which is the correct syntax of =VARA?

A. =VARA(value1, [value2], ..., 0)
B. =VARA(value1, [value2], ...) ✓
C. VARA(value1, [value2], ...)
D. =STDEVA(value1, [value2], ...)

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

11. Does =VARA return a dynamic array?

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

Explanation: VARA does not spill.

12. Is =VARA volatile?

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

Explanation: VARA is not volatile.

13. Which function is related to =VARA?

A. COUPDAYSNC
B. RTD
C. DPRODUCT
D. STDEVA ✓

Explanation: “STDEVA” is related to VARA.

14. Which statement about =VARA is correct?

A. Arguments that are error values or text that cannot be translated into numbers cause errors.
B. If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the VAR function.
C. VARA assumes that its arguments are a sample of the population. If your data represents the entire population, you must compute the variance by using VARPA. ✓
D. 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.

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

15. Is argument “value1” required in =VARA?

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

Explanation: “value1” is required.