Statistical =COVARIANCE.S(array1,array2)

Quiz =COVARIANCE.S — 10 Questions

10 quiz questions about =COVARIANCE.S — test syntax, arguments, examples & errors!

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

← COVARIANCE.S ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #DIV/0! in =COVARIANCE.S?

Question 2 of 10 2/10

How many optional arguments does =COVARIANCE.S have?

Question 3 of 10 3/10

What is the fix for #N/A in =COVARIANCE.S?

Question 4 of 10 4/10

What is the type of argument “array2” in =COVARIANCE.S?

Question 5 of 10 5/10

Is argument “array1” required in =COVARIANCE.S?

Question 6 of 10 6/10

Which statement about =COVARIANCE.S is correct?

Question 7 of 10 7/10

Is argument “array2” required in =COVARIANCE.S?

Question 8 of 10 8/10

What is the type of argument “array1” in =COVARIANCE.S?

Question 9 of 10 9/10

What is the output type of =COVARIANCE.S?

Question 10 of 10 10/10

Which use case fits =COVARIANCE.S?

Click a question to see the answer.

1. What usually causes #DIV/0! in =COVARIANCE.S?

A. If either array1 or array2 is empty or contains only 1 data point each, COVARIANCE.S returns the #DIV/0! error value. ✓
B. Output is always a dynamic array
C. Only works in old versions
D. Select entire column for best performance

Explanation: If either array1 or array2 is empty or contains only 1 data point each, COVARIANCE.S returns the #DIV/0! error value. — Fix: مطمئن شوید هر دو محدوده حداقل دو مقدار عددی دارند.

2. How many optional arguments does =COVARIANCE.S have?

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

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

3. What is the fix for #N/A in =COVARIANCE.S?

A. یکی از آرایه‌ها خالی است یا هر کدام فقط یک نقطه داده دارند.
B. Only works in old versions
C. Select entire column for best performance
D. Make the two ranges the same size ✓

Explanation: If array1 and array2 have different numbers of data points, COVARIANCE.S returns the #N/A error value. — Fix: Make the two ranges the same size

4. What is the type of argument “array2” in =COVARIANCE.S?

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

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

5. Is argument “array1” required in =COVARIANCE.S?

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

Explanation: “array1” is required.

6. Which statement about =COVARIANCE.S is correct?

A. Select entire column for best performance
B. The arguments must either be numbers or be names, arrays, or references that contain numbers. ✓
C. Only works in old versions
D. Output is always a dynamic array

Explanation: Correct: The arguments must either be numbers or be names, arrays, or references that contain numbers.

7. Is argument “array2” required in =COVARIANCE.S?

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

Explanation: “array2” is required.

8. What is the type of argument “array1” in =COVARIANCE.S?

A. Array ✓
B. Reference
C. Text
D. Date

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

9. What is the output type of =COVARIANCE.S?

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

Explanation: Output is “Number”.

10. Which use case fits =COVARIANCE.S?

A. Advanced Formulas
B. Depreciation
C. Sort, Filter & Dedupe
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits COVARIANCE.S.