Statistical =F.TEST(array1,array2)

Quiz =F.TEST — 10 Questions

10 quiz questions about =F.TEST — test syntax, arguments, examples & errors!

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

← F.TEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =F.TEST, which is argument #2?

Question 2 of 10 2/10

Is argument “array1” required in =F.TEST?

Question 3 of 10 3/10

What is the type of argument “array1” in =F.TEST?

Question 4 of 10 4/10

What is the fix for #DIV/0! in =F.TEST?

Question 5 of 10 5/10

What is the type of argument “array2” in =F.TEST?

Question 6 of 10 6/10

How many optional arguments does =F.TEST have?

Question 7 of 10 7/10

How many arguments does =F.TEST have in total?

Question 8 of 10 8/10

What usually causes #DIV/0! in =F.TEST?

Question 9 of 10 9/10

Is argument “array2” required in =F.TEST?

Question 10 of 10 10/10

How many required arguments does =F.TEST have?

Click a question to see the answer.

1. In =F.TEST, which is argument #2?

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

Explanation: Argument #2 is “array2”.

2. Is argument “array1” required in =F.TEST?

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

Explanation: “array1” is required.

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

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

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

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

A. Check the amount and values of the data ✓
B. Text is always ignored
C. Only works in old versions
D. Volatile and recalculates every time

Explanation: If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, F.TEST returns the #DIV/0! error value. — Fix: Check the amount and values of the data

5. What is the type of argument “array2” in =F.TEST?

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

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

6. How many optional arguments does =F.TEST have?

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

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

7. How many arguments does =F.TEST have in total?

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

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

8. What usually causes #DIV/0! in =F.TEST?

A. Select entire column for best performance
B. If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, F.TEST returns the #DIV/0! error value. ✓
C. Text is always ignored
D. Requires add-in

9. Is argument “array2” required in =F.TEST?

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

Explanation: “array2” is required.

10. How many required arguments does =F.TEST have?

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

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