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

Which is the correct syntax of =VAR?

Question 2 of 15 2/15

Does =VAR return a dynamic array?

Question 3 of 15 3/15

What is the output type of =VAR?

Question 4 of 15 4/15

Is argument “number2” required in =VAR?

Question 5 of 15 5/15

How many optional arguments does =VAR have?

Question 6 of 15 6/15

Since which Excel version is =VAR available?

Question 7 of 15 7/15

Which statement about =VAR is correct?

Question 8 of 15 8/15

How many arguments does =VAR have in total?

Question 9 of 15 9/15

Which category does =VAR belong to?

Question 10 of 15 10/15

How many required arguments does =VAR have?

Question 11 of 15 11/15

Which use case fits =VAR?

Question 12 of 15 12/15

Is argument “number1” required in =VAR?

Question 13 of 15 13/15

Which function is NOT related to =VAR?

Question 14 of 15 14/15

Which function is related to =VAR?

Question 15 of 15 15/15

Which formula is a valid example of =VAR?

Click a question to see the answer.

1. Which is the correct syntax of =VAR?

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

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

2. Does =VAR return a dynamic array?

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

Explanation: VAR does not spill.

3. What is the output type of =VAR?

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

Explanation: Output is “Number”.

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

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

Explanation: “number2” is optional.

5. How many optional arguments does =VAR have?

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

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

6. Since which Excel version is =VAR available?

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

Explanation: Version: “All versions”.

7. Which statement about =VAR is correct?

A. Select entire column for best performance
B. 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. ✓
C. Requires add-in
D. Arguments can either be numbers or names, arrays, or references that contain numbers.

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.

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

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

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

9. Which category does =VAR belong to?

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

Explanation: Category is “Compatibility”.

10. How many required arguments does =VAR have?

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

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

11. Which use case fits =VAR?

A. Lookup & Retrieval
B. Descriptive Statistics ✓
C. Rounding & Numeric
D. Comparation

Explanation: Use case “Descriptive Statistics” fits VAR.

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

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

Explanation: “number1” is required.

13. Which function is NOT related to =VAR?

A. SQRT
B. STDEV
C. VAR-P
D. MODE.SNGL ✓

Explanation: “MODE.SNGL” is not related to VAR.

14. Which function is related to =VAR?

A. TINV
B. SQRT ✓
C. DDB
D. MAP

Explanation: “SQRT” is related to VAR.

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

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

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