Compatibility =FTEST(array1,array2)

Quiz =FTEST — 10 Questions

10 quiz questions about =FTEST — test syntax, arguments, examples & errors!

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

← FTEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =FTEST have?

Question 2 of 10 2/10

Which is the correct syntax of =FTEST?

Question 3 of 10 3/10

What is the type of argument “array2” in =FTEST?

Question 4 of 10 4/10

What is the type of argument “array1” in =FTEST?

Question 5 of 10 5/10

What usually causes #DIV/0! in =FTEST?

Question 6 of 10 6/10

What is the output type of =FTEST?

Question 7 of 10 7/10

How many arguments does =FTEST have in total?

Question 8 of 10 8/10

Which formula is a valid example of =FTEST?

Question 9 of 10 9/10

Does =FTEST return a dynamic array?

Question 10 of 10 10/10

Which function is related to =FTEST?

Click a question to see the answer.

1. How many optional arguments does =FTEST have?

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

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

2. Which is the correct syntax of =FTEST?

A. FTEST(array1,array2)
B. =FTEST(array1,array2) ✓
C. =FORECAST(array1,array2)
D. =FTEST(array1,array2, 0)

Explanation: Correct syntax: =FTEST(array1,array2)

3. What is the type of argument “array2” in =FTEST?

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

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

4. What is the type of argument “array1” in =FTEST?

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

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

5. What usually causes #DIV/0! in =FTEST?

A. If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, FTEST returns the #DIV/0! error value. ✓
B. Output is always a dynamic array
C. Requires add-in
D. Only works in old versions

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, FTEST returns the #DIV/0! error value. — Fix: مطمئن شوید هر آرایه حداقل دو مقدار عددی دارد و واریانس آن صفر نیست.

6. What is the output type of =FTEST?

A. Reference
B. Number ✓
C. Value
D. Date

Explanation: Output is “Number”.

7. How many arguments does =FTEST have in total?

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

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

8. Which formula is a valid example of =FTEST?

A. FTEST(A2:A6,B2:B6)
B. =FTEST(A2:A6,B2:B6, 0)
C. =FORECAST(A2:A6,B2:B6)
D. =FTEST(A2:A6,B2:B6) ✓

Explanation: Correct example: =FTEST(A2:A6,B2:B6)

9. Does =FTEST return a dynamic array?

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

Explanation: FTEST does not spill.

10. Which function is related to =FTEST?

A. FORECAST ✓
B. HYPERLINK
C. LOOKUP
D. COUPNCD

Explanation: “FORECAST” is related to FTEST.