Compatibility =COVAR(array1,array2)

Quiz =COVAR — 10 Questions

10 quiz questions about =COVAR — test syntax, arguments, examples & errors!

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

← COVAR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which is the correct syntax of =COVAR?

Question 2 of 10 2/10

What is the output type of =COVAR?

Question 3 of 10 3/10

What is the type of argument “array2” in =COVAR?

Question 4 of 10 4/10

How many arguments does =COVAR have in total?

Question 5 of 10 5/10

Which statement about =COVAR is correct?

Question 6 of 10 6/10

Which function is related to =COVAR?

Question 7 of 10 7/10

Which use case fits =COVAR?

Question 8 of 10 8/10

Is argument “array1” required in =COVAR?

Question 9 of 10 9/10

How many required arguments does =COVAR have?

Question 10 of 10 10/10

What is the type of argument “array1” in =COVAR?

Click a question to see the answer.

1. Which is the correct syntax of =COVAR?

A. =COVAR(array1,array2, 0)
B. =COVAR(array1,array2) ✓
C. =FORECAST(array1,array2)
D. COVAR(array1,array2)

Explanation: Correct syntax: =COVAR(array1,array2)

2. What is the output type of =COVAR?

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

Explanation: Output is “Number”.

3. What is the type of argument “array2” in =COVAR?

A. Number
B. Logical
C. Date
D. Range ✓

Explanation: Type of “array2” is “Range”.

4. How many arguments does =COVAR have in total?

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

Explanation: =COVAR has 2 required, 0 optional (2 total).

5. Which statement about =COVAR 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. Select entire column for best performance
C. Text is always ignored
D. The arguments must either be numbers or be 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.

6. Which function is related to =COVAR?

A. T
B. FORECAST ✓
C. BITRSHIFT
D. SUBTOTAL

Explanation: “FORECAST” is related to COVAR.

7. Which use case fits =COVAR?

A. Investment Appraisal
B. Rounding & Numeric
C. Reporting ✓
D. Comparation

Explanation: Use case “Reporting” fits COVAR.

8. Is argument “array1” required in =COVAR?

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

Explanation: “array1” is required.

9. How many required arguments does =COVAR have?

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

Explanation: =COVAR has 2 required, 0 optional (2 total).

10. What is the type of argument “array1” in =COVAR?

A. Text
B. Mixed
C. Range ✓
D. Number

Explanation: Type of “array1” is “Range”.