Statistical =F.TEST(array1,array2)

Quiz =F.TEST — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which use case fits =F.TEST?

Question 2 of 15 2/15

How many required arguments does =F.TEST have?

Question 3 of 15 3/15

Which statement about =F.TEST is correct?

Question 4 of 15 4/15

Does =F.TEST return a dynamic array?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

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

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which category does =F.TEST belong to?

Question 9 of 15 9/15

Which function is NOT related to =F.TEST?

Question 10 of 15 10/15

Is =F.TEST volatile?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Since which Excel version is =F.TEST available?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which use case fits =F.TEST?

A. Conditional Logic
B. Conditional Aggregation
C. Ranking & Top N
D. Probability & Hypothesis Testing ✓

Explanation: Use case “Probability & Hypothesis Testing” fits F.TEST.

2. 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).

3. Which statement about =F.TEST is correct?

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

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

4. Does =F.TEST return a dynamic array?

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

Explanation: F.TEST does not spill.

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

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

Explanation: Argument #2 is “array2”.

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

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

Explanation: “array1” is required.

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

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

Explanation: Argument #1 is “array1”.

8. Which category does =F.TEST belong to?

A. Web
B. Engineering
C. Financial
D. Statistical ✓

Explanation: Category is “Statistical”.

9. Which function is NOT related to =F.TEST?

A. T-TEST
B. VAR-S
C. IMEXP ✓
D. F-DIST-RT

Explanation: “IMEXP” is not related to F.TEST.

10. Is =F.TEST volatile?

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

Explanation: F.TEST is not volatile.

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

A. Output is always a dynamic array
B. Text is always ignored
C. 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. ✓
D. Requires add-in

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

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

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

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

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. Check the amount and values of the data ✓
D. Only works in old versions

14. Since which Excel version is =F.TEST available?

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

Explanation: Version: “Excel 2010”.

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

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

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