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

How many arguments does =COVAR have in total?

Question 2 of 10 2/10

Which is the correct syntax of =COVAR?

Question 3 of 10 3/10

In =COVAR, which is argument #2?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which formula is a valid example of =COVAR?

Question 8 of 10 8/10

How many optional arguments does =COVAR have?

Question 9 of 10 9/10

How many required arguments does =COVAR have?

Question 10 of 10 10/10

Which statement about =COVAR is correct?

Click a question to see the answer.

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

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

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

2. Which is the correct syntax of =COVAR?

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

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

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

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

Explanation: Argument #2 is “array2”.

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

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

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

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

A. Text is always ignored
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

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

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

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

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

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

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

8. How many optional arguments does =COVAR have?

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

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

9. How many required arguments does =COVAR have?

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

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

10. Which statement about =COVAR is correct?

A. Volatile and recalculates every time
B. Text is always ignored
C. The arguments must either be numbers or be names, arrays, or references that contain numbers.
D. 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. ✓

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.