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

Quiz =VARP — 10 Questions

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

Question 1 of 10 1/10

Since which Excel version is =VARP available?

Question 2 of 10 2/10

Which function is related to =VARP?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which function is NOT related to =VARP?

Question 5 of 10 5/10

What is the output type of =VARP?

Question 6 of 10 6/10

How many optional arguments does =VARP have?

Question 7 of 10 7/10

Which statement about =VARP is correct?

Question 8 of 10 8/10

Does =VARP return a dynamic array?

Question 9 of 10 9/10

How many arguments does =VARP have in total?

Question 10 of 10 10/10

Which use case fits =VARP?

Click a question to see the answer.

1. Since which Excel version is =VARP available?

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

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

2. Which function is related to =VARP?

A. IMSQRT
B. F.DIST
C. FORECAST ✓
D. COVARIANCE.P

Explanation: “FORECAST” is related to VARP.

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

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

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

4. Which function is NOT related to =VARP?

A. MODE
B. FORECAST
C. COUNTIFS ✓
D. PERCENTILE

Explanation: “COUNTIFS” is not related to VARP.

5. What is the output type of =VARP?

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

Explanation: Output is “Number”.

6. How many optional arguments does =VARP have?

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

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

7. Which statement about =VARP is correct?

A. Arguments that are error values or text that cannot be translated into numbers cause errors.
B. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the VARPA function.
C. Only works in old versions
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.

8. Does =VARP return a dynamic array?

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

Explanation: VARP does not spill.

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

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

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

10. Which use case fits =VARP?

A. External Data, Web & Cube
B. Conditional Logic
C. Securities & Bonds
D. Reporting ✓

Explanation: Use case “Reporting” fits VARP.