Compatibility =FTEST(array1,array2)

Quiz =FTEST — 15 Questions

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

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Since which Excel version is =FTEST available?

Question 3 of 15 3/15

In =FTEST, which is argument #2?

Question 4 of 15 4/15

In =FTEST, which is argument #1?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

How many optional arguments does =FTEST have?

Question 7 of 15 7/15

What is the fix for #DIV/0! in =FTEST?

Question 8 of 15 8/15

Is =FTEST volatile?

Question 9 of 15 9/15

Which function is NOT related to =FTEST?

Question 10 of 15 10/15

What is the output type of =FTEST?

Question 11 of 15 11/15

Which formula is a valid example of =FTEST?

Question 12 of 15 12/15

Which function is related to =FTEST?

Question 13 of 15 13/15

Which is the correct syntax of =FTEST?

Question 14 of 15 14/15

Is argument “array1” required in =FTEST?

Question 15 of 15 15/15

Is argument “array2” required in =FTEST?

Click a question to see the answer.

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

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

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

2. Since which Excel version is =FTEST available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

3. In =FTEST, which is argument #2?

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

Explanation: Argument #2 is “array2”.

4. In =FTEST, which is argument #1?

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

Explanation: Argument #1 is “array1”.

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

A. Select entire column for best performance
B. Volatile and recalculates every time
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, FTEST returns the #DIV/0! error value. ✓
D. Output is always a dynamic array

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. How many optional arguments does =FTEST have?

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

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

7. What is the fix for #DIV/0! in =FTEST?

A. Text is always ignored
B. Requires add-in
C. مطمئن شوید هر آرایه حداقل دو مقدار عددی دارد و واریانس آن صفر نیست. ✓
D. Select entire column for best performance

8. Is =FTEST volatile?

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

Explanation: FTEST is not volatile.

9. Which function is NOT related to =FTEST?

A. PERCENTILE
B. MODE
C. NA ✓
D. FORECAST

Explanation: “NA” is not related to FTEST.

10. What is the output type of =FTEST?

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

Explanation: Output is “Number”.

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

12. Which function is related to =FTEST?

A. STEYX
B. FORECAST ✓
C. ASINH
D. ISOMITTED

Explanation: “FORECAST” is related to FTEST.

13. Which is the correct syntax of =FTEST?

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

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

14. Is argument “array1” required in =FTEST?

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

Explanation: “array1” is required.

15. Is argument “array2” required in =FTEST?

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

Explanation: “array2” is required.