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

What usually causes #N/A in =COVAR?

Question 2 of 15 2/15

What is the output type of =COVAR?

Question 3 of 15 3/15

Since which Excel version is =COVAR available?

Question 4 of 15 4/15

Is argument “array2” required in =COVAR?

Question 5 of 15 5/15

Is =COVAR volatile?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which statement about =COVAR is correct?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Does =COVAR return a dynamic array?

Question 10 of 15 10/15

In =COVAR, which is argument #2?

Question 11 of 15 11/15

In =COVAR, which is argument #1?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which use case fits =COVAR?

Question 14 of 15 14/15

How many arguments does =COVAR have in total?

Question 15 of 15 15/15

Which is the correct syntax of =COVAR?

Click a question to see the answer.

1. What usually causes #N/A in =COVAR?

A. If array1 and array2 have different numbers of data points, COVAR returns the #N/A error value. ✓
B. Select entire column for best performance
C. Volatile and recalculates every time
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

2. What is the output type of =COVAR?

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

Explanation: Output is “Number”.

3. Since which Excel version is =COVAR available?

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

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

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

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

Explanation: “array2” is required.

5. Is =COVAR volatile?

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

Explanation: COVAR is not volatile.

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

A. Text is always ignored
B. Requires add-in
C. Output is always a dynamic array
D. بررسی کنید هر دو محدوده حداقل یک مقدار عددی داشته باشند. ✓

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

7. Which statement about =COVAR is correct?

A. 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.
B. 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. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

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. What is the type of argument “array2” in =COVAR?

A. Value
B. Range ✓
C. Date
D. Mixed

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

9. Does =COVAR return a dynamic array?

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

Explanation: COVAR does not spill.

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

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

Explanation: Argument #2 is “array2”.

11. In =COVAR, which is argument #1?

A. range
B. value
C. array1 ✓
D. array2

Explanation: Argument #1 is “array1”.

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

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

13. Which use case fits =COVAR?

A. Securities & Bonds
B. Reporting ✓
C. Depreciation
D. Comparation

Explanation: Use case “Reporting” fits COVAR.

14. 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).

15. Which is the correct syntax of =COVAR?

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

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