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 formula is a valid example of =COVAR?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Is =COVAR volatile?

Question 5 of 10 5/10

How many arguments does =COVAR have in total?

Question 6 of 10 6/10

Which statement about =COVAR is correct?

Question 7 of 10 7/10

Does =COVAR return a dynamic array?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which use case fits =COVAR?

Question 10 of 10 10/10

What usually causes #N/A in =COVAR?

Click a question to see the answer.

1. Which formula is a valid example of =COVAR?

A. =COVAR(A2:A6, B2:B6) ✓
B. COVAR(A2:A6, B2:B6)
C. =COVAR(A2:A6, B2:B6, 0)
D. =FORECAST(A2:A6, B2:B6)

Explanation: Correct example: =COVAR(A2:A6, B2:B6)

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

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

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

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

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

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

4. Is =COVAR volatile?

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

Explanation: COVAR is not volatile.

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

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

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

6. Which statement about =COVAR is correct?

A. Requires add-in
B. The covariance is: where are the sample means AVERAGE(array1) and AVERAGE(array2), and n is the sample size.
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. Output is always a dynamic array

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.

7. Does =COVAR return a dynamic array?

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

Explanation: COVAR does not spill.

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

A. یکی از آرایه‌ها خالی است.
B. Equal sizes ✓
C. Only works in old versions
D. Output is always a dynamic array

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

9. Which use case fits =COVAR?

A. Loans & Installments
B. Conditional Aggregation
C. Dynamic Ranges & Dashboards
D. Reporting ✓

Explanation: Use case “Reporting” fits COVAR.

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

A. Requires add-in
B. Volatile and recalculates every time
C. If array1 and array2 have different numbers of data points, COVAR returns the #N/A error value. ✓
D. Only works in old versions

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