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

In =FTEST, which is argument #1?

Question 2 of 15 2/15

Which use case fits =FTEST?

Question 3 of 15 3/15

Which is the correct syntax of =FTEST?

Question 4 of 15 4/15

Since which Excel version is =FTEST available?

Question 5 of 15 5/15

Is argument “array1” required in =FTEST?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Is =FTEST volatile?

Question 8 of 15 8/15

How many required arguments does =FTEST have?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which formula is a valid example of =FTEST?

Question 11 of 15 11/15

How many arguments does =FTEST have in total?

Question 12 of 15 12/15

Which function is NOT related to =FTEST?

Question 13 of 15 13/15

Is argument “array2” required in =FTEST?

Question 14 of 15 14/15

How many optional arguments does =FTEST have?

Question 15 of 15 15/15

Which statement about =FTEST is correct?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “array1”.

2. Which use case fits =FTEST?

A. Loans & Installments
B. Reporting ✓
C. Reshape Tables
D. Financial Calculations

Explanation: Use case “Reporting” fits FTEST.

3. Which is the correct syntax of =FTEST?

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

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

4. Since which Excel version is =FTEST available?

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

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

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

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

Explanation: “array1” is required.

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

A. Range ✓
B. Date
C. Value
D. Logical

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

7. Is =FTEST volatile?

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

Explanation: FTEST is not volatile.

8. How many required arguments does =FTEST have?

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

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

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

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

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

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

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

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

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

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

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

12. Which function is NOT related to =FTEST?

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

Explanation: “DEC2BIN” is not related to FTEST.

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

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

Explanation: “array2” is required.

14. How many optional arguments does =FTEST have?

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

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

15. Which statement about =FTEST is correct?

A. Select entire column for best performance
B. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓
C. Requires add-in
D. Only works in old versions

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.