Statistical =COVARIANCE.P(array1,array2)

Quiz =COVARIANCE.P — 15 Questions

15 quiz questions about =COVARIANCE.P — test syntax, arguments, examples & errors!

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

← COVARIANCE.P ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is NOT related to =COVARIANCE.P?

Question 2 of 15 2/15

Is =COVARIANCE.P volatile?

Question 3 of 15 3/15

Which statement about =COVARIANCE.P is correct?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

In =COVARIANCE.P, which is argument #1?

Question 6 of 15 6/15

Which function is related to =COVARIANCE.P?

Question 7 of 15 7/15

How many optional arguments does =COVARIANCE.P have?

Question 8 of 15 8/15

Which is the correct syntax of =COVARIANCE.P?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which category does =COVARIANCE.P belong to?

Question 12 of 15 12/15

Since which Excel version is =COVARIANCE.P available?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which function is NOT related to =COVARIANCE.P?

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

Explanation: “NORM.INV” is not related to COVARIANCE.P.

2. Is =COVARIANCE.P volatile?

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

Explanation: COVARIANCE.P is not volatile.

3. Which statement about =COVARIANCE.P is correct?

A. Output is always a dynamic array
B. The arguments must either be numbers or be names, arrays, or references that contain numbers. ✓
C. Volatile and recalculates every time
D. Select entire column for best performance

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

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

A. Text is always ignored
B. Only works in old versions
C. Requires add-in
D. If either array1 or array2 is empty, COVARIANCE.P returns the #DIV/0! error value. ✓

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

5. In =COVARIANCE.P, which is argument #1?

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

Explanation: Argument #1 is “array1”.

6. Which function is related to =COVARIANCE.P?

A. COVARIANCE-S ✓
B. LOOKUP
C. FISHER
D. DEVSQ

Explanation: “COVARIANCE-S” is related to COVARIANCE.P.

7. How many optional arguments does =COVARIANCE.P have?

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

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

8. Which is the correct syntax of =COVARIANCE.P?

A. =COVARIANCE-S(array1,array2)
B. =COVARIANCE.P(array1,array2, 0)
C. =COVARIANCE.P(array1,array2) ✓
D. COVARIANCE.P(array1,array2)

Explanation: Correct syntax: =COVARIANCE.P(array1,array2)

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

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

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

10. Which formula is a valid example of =COVARIANCE.P?

A. =COVARIANCE.P(A2:A6, B2:B6) ✓
B. =COVARIANCE-S(A2:A6, B2:B6)
C. =COVARIANCE.P(A2:A6, B2:B6, 0)
D. COVARIANCE.P(A2:A6, B2:B6)

Explanation: Correct example: =COVARIANCE.P(A2:A6, B2:B6)

11. Which category does =COVARIANCE.P belong to?

A. Lookup & Reference
B. Compatibility
C. Statistical ✓
D. Cube

Explanation: Category is “Statistical”.

12. Since which Excel version is =COVARIANCE.P available?

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

Explanation: Version: “Excel 2010”.

13. Is argument “array1” required in =COVARIANCE.P?

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

Explanation: “array1” is required.

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

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

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

15. How many arguments does =COVARIANCE.P have in total?

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

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