Compatibility =COVAR(array1,array2)

Quiz =COVAR — 15 Questions

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

Question 1 of 15 1/15

Since which Excel version is =COVAR available?

Question 2 of 15 2/15

Which function is related to =COVAR?

Question 3 of 15 3/15

Which is the correct syntax of =COVAR?

Question 4 of 15 4/15

Is argument “array1” required in =COVAR?

Question 5 of 15 5/15

In =COVAR, which is argument #2?

Question 6 of 15 6/15

What is the fix for #DIV/0! in =COVAR?

Question 7 of 15 7/15

What usually causes #DIV/0! in =COVAR?

Question 8 of 15 8/15

What is the fix for #N/A in =COVAR?

Question 9 of 15 9/15

Which statement about =COVAR is correct?

Question 10 of 15 10/15

Which function is NOT related to =COVAR?

Question 11 of 15 11/15

How many optional arguments does =COVAR have?

Question 12 of 15 12/15

How many required arguments does =COVAR have?

Question 13 of 15 13/15

How many arguments does =COVAR have in total?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Does =COVAR return a dynamic array?

Click a question to see the answer.

1. Since which Excel version is =COVAR available?

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

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

2. Which function is related to =COVAR?

A. GAMMALN
B. CEILING.MATH
C. FORECAST.ETS.SEASONALITY
D. FORECAST ✓

Explanation: “FORECAST” is related to COVAR.

3. Which is the correct syntax of =COVAR?

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

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

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

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

Explanation: “array1” is required.

5. In =COVAR, which is argument #2?

A. lookup_value
B. criteria
C. value
D. array2 ✓

Explanation: Argument #2 is “array2”.

6. What is the fix for #DIV/0! in =COVAR?

A. Requires add-in
B. بررسی کنید هر دو محدوده حداقل یک مقدار عددی داشته باشند. ✓
C. Volatile and recalculates every time
D. Text is always ignored

Explanation: If either array1 or array2 is empty, COVAR returns the #DIV/0! error value. — Fix: بررسی کنید هر دو محدوده حداقل یک مقدار عددی داشته باشند.

7. What usually causes #DIV/0! in =COVAR?

A. Requires add-in
B. Output is always a dynamic array
C. If either array1 or array2 is empty, COVAR returns the #DIV/0! error value. ✓
D. تعداد نقاط داده در array1 و array2 متفاوت است.

8. What is the fix for #N/A in =COVAR?

A. Volatile and recalculates every time
B. Text is always ignored
C. Equal sizes ✓
D. Requires add-in

Explanation: If array1 and array2 have different numbers of data points, COVAR returns the #N/A error value. — Fix: Equal sizes

9. 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. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
C. Volatile and recalculates every time
D. The covariance is: where are the sample means AVERAGE(array1) and AVERAGE(array2), and n is the sample size.

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.

10. Which function is NOT related to =COVAR?

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

Explanation: “ROUNDUP” is not related to COVAR.

11. How many optional arguments does =COVAR have?

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

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

12. How many required arguments does =COVAR have?

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

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

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

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

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

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

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

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

15. Does =COVAR return a dynamic array?

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

Explanation: COVAR does not spill.