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

Since which Excel version is =COVARIANCE.S available?

Question 2 of 10 2/10

Which category does =COVARIANCE.S belong to?

Question 3 of 10 3/10

How many arguments does =COVARIANCE.S have in total?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

How many required arguments does =COVARIANCE.S have?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is NOT related to =COVARIANCE.S?

Question 8 of 10 8/10

Which use case fits =COVARIANCE.S?

Question 9 of 10 9/10

Which formula is a valid example of =COVARIANCE.S?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Since which Excel version is =COVARIANCE.S available?

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

Explanation: Version: “Excel 2010”.

2. Which category does =COVARIANCE.S belong to?

A. Web
B. Math & Trig
C. Statistical ✓
D. Lookup & Reference

Explanation: Category is “Statistical”.

3. How many arguments does =COVARIANCE.S have in total?

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

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

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

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

Explanation: “array1” is required.

5. How many required arguments does =COVARIANCE.S have?

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

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

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

A. Text is always ignored
B. Make the two ranges the same size ✓
C. Requires add-in
D. Select entire column for best performance

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

7. Which function is NOT related to =COVARIANCE.S?

A. ISNUMBER ✓
B. VAR-S
C. COVARIANCE-P
D. CORREL

Explanation: “ISNUMBER” is not related to COVARIANCE.S.

8. Which use case fits =COVARIANCE.S?

A. Loans & Installments
B. Lookup & Retrieval
C. Descriptive Statistics ✓
D. Numbering & Sample Data

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

9. Which formula is a valid example of =COVARIANCE.S?

A. =COVARIANCE.S({2,4,8},{5,11,12}, 0)
B. =COVARIANCE.S({2,4,8},{5,11,12}) ✓
C. =COVARIANCE-P({2,4,8},{5,11,12})
D. COVARIANCE.S({2,4,8},{5,11,12})

Explanation: Correct example: =COVARIANCE.S({2,4,8},{5,11,12})

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

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

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