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

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

Question 2 of 15 2/15

Which category does =TTEST belong to?

Question 3 of 15 3/15

Is =TTEST volatile?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which function is NOT related to =TTEST?

Question 6 of 15 6/15

Which statement about =TTEST is correct?

Question 7 of 15 7/15

Does =TTEST return a dynamic array?

Question 8 of 15 8/15

How many arguments does =TTEST have in total?

Question 9 of 15 9/15

In =TTEST, which is argument #1?

Question 10 of 15 10/15

Which use case fits =TTEST?

Question 11 of 15 11/15

In =TTEST, which is argument #2?

Question 12 of 15 12/15

Which formula is a valid example of =TTEST?

Question 13 of 15 13/15

Which is the correct syntax of =TTEST?

Question 14 of 15 14/15

What usually causes #NUM! in =TTEST?

Question 15 of 15 15/15

How many required arguments does =TTEST have?

Click a question to see the answer.

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

A. برای tails مقدار ۱ یا ۲ و برای type مقدار ۱ تا ۳ را به‌صورت عددی وارد کنید. ✓
B. مقدار tails غیر از ۱ یا ۲ است.
C. Only works in old versions
D. تعداد نقاط داده array1 و array2 متفاوت است در حالی که type برابر ۱ (جفتی) است.

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

2. Which category does =TTEST belong to?

A. Statistical
B. Compatibility ✓
C. Engineering
D. Financial

Explanation: Category is “Compatibility”.

3. Is =TTEST volatile?

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

Explanation: TTEST is not volatile.

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

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

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

5. Which function is NOT related to =TTEST?

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

Explanation: “PERCENTILE.EXC” is not related to TTEST.

6. Which statement about =TTEST is correct?

A. Text is always ignored
B. Only works in old versions
C. 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. ✓
D. TTEST uses the data in array1 and array2 to compute a non-negative t-statistic. If tails=1, TTEST returns the probability of a higher value of the t-statistic under the assumption that array1 and array2 are samples from populations with the same mean. The value returned by TTEST when tails=2 is double that returned when tails=1 and corresponds to the probability of a higher absolute value of the t-statistic under the “same population means” assumption.

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.

7. Does =TTEST return a dynamic array?

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

Explanation: TTEST does not spill.

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

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

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

9. In =TTEST, which is argument #1?

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

Explanation: Argument #1 is “array1”.

10. Which use case fits =TTEST?

A. Reporting ✓
B. Conditional Formatting & Validation
C. Comparation
D. Date & Time Calculations

Explanation: Use case “Reporting” fits TTEST.

11. In =TTEST, which is argument #2?

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

Explanation: Argument #2 is “array2”.

12. Which formula is a valid example of =TTEST?

A. =TTEST(A2:A10,B2:B10,2,1) ✓
B. =FORECAST(A2:A10,B2:B10,2,1)
C. TTEST(A2:A10,B2:B10,2,1)
D. =TTEST(A2:A10,B2:B10,2,1, 0)

Explanation: Correct example: =TTEST(A2:A10,B2:B10,2,1)

13. Which is the correct syntax of =TTEST?

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

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

14. What usually causes #NUM! in =TTEST?

A. If tails is any value other than 1 or 2, TTEST returns the #NUM! error value. ✓
B. آرگومان tails یا type غیرعددی است.
C. تعداد نقاط داده array1 و array2 متفاوت است در حالی که type برابر ۱ (جفتی) است.
D. Output is always a dynamic array

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

15. How many required arguments does =TTEST have?

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

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