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

Quiz =VARP — 15 Questions

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

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

← VARP ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “number1” required in =VARP?

Question 2 of 15 2/15

How many arguments does =VARP have in total?

Question 3 of 15 3/15

How many optional arguments does =VARP have?

Question 4 of 15 4/15

In =VARP, which is argument #2?

Question 5 of 15 5/15

Which is the correct syntax of =VARP?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

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

Question 8 of 15 8/15

In =VARP, which is argument #1?

Question 9 of 15 9/15

Which category does =VARP belong to?

Question 10 of 15 10/15

Which use case fits =VARP?

Question 11 of 15 11/15

Since which Excel version is =VARP available?

Question 12 of 15 12/15

Which formula is a valid example of =VARP?

Question 13 of 15 13/15

Which statement about =VARP is correct?

Question 14 of 15 14/15

How many required arguments does =VARP have?

Question 15 of 15 15/15

Which function is NOT related to =VARP?

Click a question to see the answer.

1. Is argument “number1” required in =VARP?

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

Explanation: “number1” is required.

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

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

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

3. How many optional arguments does =VARP have?

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

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

4. In =VARP, which is argument #2?

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

Explanation: Argument #2 is “number2”.

5. Which is the correct syntax of =VARP?

A. =FORECAST(number1,[number2],...)
B. =VARP(number1,[number2],...) ✓
C. VARP(number1,[number2],...)
D. =VARP(number1,[number2],..., 0)

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

6. What is the type of argument “number1” in =VARP?

A. Date
B. Reference
C. Value
D. Number/Range ✓

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

7. What is the type of argument “number2” in =VARP?

A. Reference
B. Number/Range ✓
C. Array
D. Mixed

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

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

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

Explanation: Argument #1 is “number1”.

9. Which category does =VARP belong to?

A. Compatibility ✓
B. Financial
C. Text
D. Logical

Explanation: Category is “Compatibility”.

10. Which use case fits =VARP?

A. Financial Calculations
B. Reporting ✓
C. Depreciation
D. Securities & Bonds

Explanation: Use case “Reporting” fits VARP.

11. Since which Excel version is =VARP available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

12. Which formula is a valid example of =VARP?

A. =FORECAST(A2:A11)
B. =VARP(A2:A11) ✓
C. VARP(A2:A11)
D. =VARP(A2:A11, 0)

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

13. Which statement about =VARP is correct?

A. 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. ✓
B. Arguments that are error values or text that cannot be translated into numbers cause errors.
C. Volatile and recalculates every time
D. Requires add-in

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.

14. How many required arguments does =VARP have?

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

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

15. Which function is NOT related to =VARP?

A. PERCENTILE
B. FORECAST
C. BINOM.INV ✓
D. MODE

Explanation: “BINOM.INV” is not related to VARP.