Statistical =T.TEST(array1,array2,tails,type)

Quiz =T.TEST — 10 Questions

10 quiz questions about =T.TEST — test syntax, arguments, examples & errors!

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

← T.TEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =T.TEST, which is argument #3?

Question 2 of 10 2/10

What usually causes #N/A in =T.TEST?

Question 3 of 10 3/10

Is argument “tails” required in =T.TEST?

Question 4 of 10 4/10

What is the output type of =T.TEST?

Question 5 of 10 5/10

How many arguments does =T.TEST have in total?

Question 6 of 10 6/10

Since which Excel version is =T.TEST available?

Question 7 of 10 7/10

What is the type of argument “array1” in =T.TEST?

Question 8 of 10 8/10

Is argument “type” required in =T.TEST?

Question 9 of 10 9/10

What is the type of argument “tails” in =T.TEST?

Question 10 of 10 10/10

Which function is related to =T.TEST?

Click a question to see the answer.

1. In =T.TEST, which is argument #3?

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

Explanation: Argument #3 is “tails”.

2. What usually causes #N/A in =T.TEST?

A. Output is always a dynamic array
B. Only works in old versions
C. If array1 and array2 have a different number of data points, and type = 1 (paired), T.TEST returns the #N/A error value. ✓
D. اگر tails مقداری غیر از ۱ یا ۲ باشد، تابع T.TEST خطای #NUM! را برمی‌گرداند.

Explanation: If array1 and array2 have a different number of data points, and type = 1 (paired), T.TEST returns the #N/A error value. — Fix: Make the two ranges the same size

3. Is argument “tails” required in =T.TEST?

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

Explanation: “tails” is required.

4. What is the output type of =T.TEST?

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

Explanation: Output is “Number”.

5. How many arguments does =T.TEST have in total?

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

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

6. Since which Excel version is =T.TEST available?

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

Explanation: Version: “Excel 2010”.

7. What is the type of argument “array1” in =T.TEST?

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

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

8. Is argument “type” required in =T.TEST?

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

Explanation: “type” is required.

9. What is the type of argument “tails” in =T.TEST?

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

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

10. Which function is related to =T.TEST?

A. AVERAGE ✓
B. SUMPRODUCT
C. GROWTH
D. CONCATENATE

Explanation: “AVERAGE” is related to T.TEST.