Compatibility =TTEST(array1,array2,tails,type)

Quiz =TTEST — 15 Questions

15 quiz questions about =TTEST — test syntax, arguments, examples & errors!

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

← TTEST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “tails” required in =TTEST?

Question 2 of 15 2/15

Is argument “array1” required in =TTEST?

Question 3 of 15 3/15

Which is the correct syntax of =TTEST?

Question 4 of 15 4/15

Is =TTEST volatile?

Question 5 of 15 5/15

How many arguments does =TTEST have in total?

Question 6 of 15 6/15

Which function is NOT related to =TTEST?

Question 7 of 15 7/15

What usually causes #N/A in =TTEST?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Since which Excel version is =TTEST available?

Question 10 of 15 10/15

What is the type of argument “tails” in =TTEST?

Question 11 of 15 11/15

How many optional arguments does =TTEST have?

Question 12 of 15 12/15

What is the fix for #VALUE! in =TTEST?

Question 13 of 15 13/15

What is the fix for #NUM! in =TTEST?

Question 14 of 15 14/15

Is argument “type” required in =TTEST?

Question 15 of 15 15/15

Which statement about =TTEST is correct?

Click a question to see the answer.

1. Is argument “tails” required in =TTEST?

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

Explanation: “tails” is required.

2. Is argument “array1” required in =TTEST?

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

Explanation: “array1” is required.

3. Which is the correct syntax of =TTEST?

A. =FORECAST(array1,array2,tails,type)
B. =TTEST(array1,array2,tails,type, 0)
C. =TTEST(array1,array2,tails,type) ✓
D. TTEST(array1,array2,tails,type)

Explanation: Correct syntax: =TTEST(array1,array2,tails,type)

4. Is =TTEST volatile?

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

Explanation: TTEST is not volatile.

5. How many arguments does =TTEST have in total?

A. 4 ✓
B. 3
C. 6
D. 5

Explanation: =TTEST has 4 required, 0 optional (4 total).

6. Which function is NOT related to =TTEST?

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

Explanation: “IMAGINARY” is not related to TTEST.

7. What usually causes #N/A in =TTEST?

A. Only works in old versions
B. Volatile and recalculates every time
C. Requires add-in
D. If array1 and array2 have a different number of data points, and type = 1 (paired), TTEST returns the #N/A error value. ✓

Explanation: If array1 and array2 have a different number of data points, and type = 1 (paired), TTEST returns the #N/A error value. — Fix: At least 2 values

8. What is the type of argument “array1” in =TTEST?

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

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

9. Since which Excel version is =TTEST available?

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

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

10. What is the type of argument “tails” in =TTEST?

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

Explanation: Type of “tails” is “Number”.

11. How many optional arguments does =TTEST have?

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

Explanation: =TTEST has 4 required, 0 optional (4 total).

12. What is the fix for #VALUE! in =TTEST?

A. برای tails مقدار ۱ یا ۲ و برای type مقدار ۱ تا ۳ را به‌صورت عددی وارد کنید. ✓
B. Text is always ignored
C. Select entire column for best performance
D. Volatile and recalculates every time

Explanation: If tails or type is nonnumeric, TTEST returns the #VALUE! error value. — Fix: برای tails مقدار ۱ یا ۲ و برای type مقدار ۱ تا ۳ را به‌صورت عددی وارد کنید.

13. What is the fix for #NUM! in =TTEST?

A. Select entire column for best performance
B. Output is always a dynamic array
C. آرگومان tails یا type غیرعددی است.
D. برای tails فقط ۱ (یک‌دامنه) یا ۲ (دو‌دامنه) وارد کنید. ✓

Explanation: If tails is any value other than 1 or 2, TTEST returns the #NUM! error value. — Fix: برای tails فقط ۱ (یک‌دامنه) یا ۲ (دو‌دامنه) وارد کنید.

14. Is argument “type” required in =TTEST?

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

Explanation: “type” is required.

15. Which statement about =TTEST is correct?

A. 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. For more information about the new function, see T.TEST function. ✓
B. Requires add-in
C. The tails and type arguments are truncated to integers.
D. Volatile and recalculates every time

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. For more information about the new function, see T.TEST function.