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

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

Question 2 of 10 2/10

How many arguments does =FTEST have in total?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which statement about =FTEST is correct?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Since which Excel version is =FTEST available?

Question 7 of 10 7/10

In =FTEST, which is argument #1?

Question 8 of 10 8/10

Which function is NOT related to =FTEST?

Question 9 of 10 9/10

Which use case fits =FTEST?

Question 10 of 10 10/10

Does =FTEST return a dynamic array?

Click a question to see the answer.

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

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

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

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

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

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

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

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

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: مطمئن شوید هر آرایه حداقل دو مقدار عددی دارد و واریانس آن صفر نیست.

4. Which statement about =FTEST is correct?

A. Output is always a dynamic array
B. Select entire column for best performance
C. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
D. 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. ✓

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.

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

A. Text is always ignored
B. Select entire column for best performance
C. Volatile and recalculates every time
D. 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. ✓

6. Since which Excel version is =FTEST available?

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

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

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

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

Explanation: Argument #1 is “array1”.

8. Which function is NOT related to =FTEST?

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

Explanation: “OCT2BIN” is not related to FTEST.

9. Which use case fits =FTEST?

A. Rounding & Numeric
B. Scientific & Unit Conversion
C. Reporting ✓
D. Workdays & Due Dates

Explanation: Use case “Reporting” fits FTEST.

10. Does =FTEST return a dynamic array?

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

Explanation: FTEST does not spill.