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

Which category does =VARP belong to?

Question 2 of 10 2/10

Is argument “number2” required in =VARP?

Question 3 of 10 3/10

In =VARP, which is argument #1?

Question 4 of 10 4/10

Which function is related to =VARP?

Question 5 of 10 5/10

Which statement about =VARP is correct?

Question 6 of 10 6/10

Does =VARP return a dynamic array?

Question 7 of 10 7/10

How many required arguments does =VARP have?

Question 8 of 10 8/10

Which formula is a valid example of =VARP?

Question 9 of 10 9/10

What is the output type of =VARP?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which category does =VARP belong to?

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

Explanation: Category is “Compatibility”.

2. Is argument “number2” required in =VARP?

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

Explanation: “number2” is optional.

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

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

Explanation: Argument #1 is “number1”.

4. Which function is related to =VARP?

A. LOGNORM.DIST
B. IMSUB
C. FORECAST ✓
D. ACCRINT

Explanation: “FORECAST” is related to VARP.

5. Which statement about =VARP is correct?

A. Logical values, and text representations of numbers that you type directly into the list of arguments are counted.
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. If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are 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.

6. Does =VARP return a dynamic array?

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

Explanation: VARP does not spill.

7. How many required arguments does =VARP have?

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

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

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

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

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

9. What is the output type of =VARP?

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

Explanation: Output is “Number”.

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

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

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