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

Quiz =VAR — 15 Questions

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

Question 1 of 15 1/15

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

Question 2 of 15 2/15

How many arguments does =VAR have in total?

Question 3 of 15 3/15

Which category does =VAR belong to?

Question 4 of 15 4/15

Does =VAR return a dynamic array?

Question 5 of 15 5/15

Which function is NOT related to =VAR?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Is argument “number2” required in =VAR?

Question 8 of 15 8/15

Which formula is a valid example of =VAR?

Question 9 of 15 9/15

Which is the correct syntax of =VAR?

Question 10 of 15 10/15

How many optional arguments does =VAR have?

Question 11 of 15 11/15

Is argument “number1” required in =VAR?

Question 12 of 15 12/15

Which function is related to =VAR?

Question 13 of 15 13/15

Since which Excel version is =VAR available?

Question 14 of 15 14/15

In =VAR, which is argument #1?

Question 15 of 15 15/15

Which statement about =VAR is correct?

Click a question to see the answer.

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

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

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

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

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

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

3. Which category does =VAR belong to?

A. Financial
B. Engineering
C. Database
D. Compatibility ✓

Explanation: Category is “Compatibility”.

4. Does =VAR return a dynamic array?

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

Explanation: VAR does not spill.

5. Which function is NOT related to =VAR?

A. LN ✓
B. STDEV
C. VAR-P
D. SQRT

Explanation: “LN” is not related to VAR.

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

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

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

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

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

Explanation: “number2” is optional.

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

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

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

9. Which is the correct syntax of =VAR?

A. =VAR(number1,[number2],...) ✓
B. =VAR(number1,[number2],..., 0)
C. =SQRT(number1,[number2],...)
D. VAR(number1,[number2],...)

Explanation: Correct syntax: =VAR(number1,[number2],...)

10. How many optional arguments does =VAR have?

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

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

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

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

Explanation: “number1” is required.

12. Which function is related to =VAR?

A. TINV
B. SQRT ✓
C. IMCOT
D. CHISQ.DIST.RT

Explanation: “SQRT” is related to VAR.

13. Since which Excel version is =VAR available?

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

Explanation: Version: “All versions”.

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

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

Explanation: Argument #1 is “number1”.

15. Which statement about =VAR is correct?

A. Select entire column for best performance
B. Arguments that are error values or text that cannot be translated into numbers cause errors.
C. 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. ✓
D. Text is always ignored

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.