Compatibility =VAR(number1,[number2],...)

Quiz =VAR — 10 Questions

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

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

← VAR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =VAR have?

Question 2 of 10 2/10

Is =VAR volatile?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Does =VAR return a dynamic array?

Question 5 of 10 5/10

Which category does =VAR belong to?

Question 6 of 10 6/10

What is the output type of =VAR?

Question 7 of 10 7/10

In =VAR, which is argument #1?

Question 8 of 10 8/10

Which statement about =VAR is correct?

Question 9 of 10 9/10

In =VAR, which is argument #2?

Question 10 of 10 10/10

Since which Excel version is =VAR available?

Click a question to see the answer.

1. How many optional arguments does =VAR have?

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

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

2. Is =VAR volatile?

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

Explanation: VAR is not volatile.

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

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

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

4. Does =VAR return a dynamic array?

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

Explanation: VAR does not spill.

5. Which category does =VAR belong to?

A. Date & Time
B. Engineering
C. Cube
D. Compatibility ✓

Explanation: Category is “Compatibility”.

6. What is the output type of =VAR?

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

Explanation: Output is “Number”.

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

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

Explanation: Argument #1 is “number1”.

8. Which statement about =VAR is correct?

A. VAR assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VARP.
B. Requires add-in
C. Text is always ignored
D. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

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

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

Explanation: Argument #2 is “number2”.

10. Since which Excel version is =VAR available?

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

Explanation: Version: “All versions”.