Compatibility =TDIST(x,deg_freedom,tails)

Quiz =TDIST — 10 Questions

10 quiz questions about =TDIST — test syntax, arguments, examples & errors!

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

← TDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Which is the correct syntax of =TDIST?

Question 3 of 10 3/10

What usually causes #NUM! in =TDIST?

Question 4 of 10 4/10

How many arguments does =TDIST have in total?

Question 5 of 10 5/10

Does =TDIST return a dynamic array?

Question 6 of 10 6/10

In =TDIST, which is argument #2?

Question 7 of 10 7/10

Which statement about =TDIST is correct?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is =TDIST volatile?

Question 10 of 10 10/10

How many optional arguments does =TDIST have?

Click a question to see the answer.

1. What is the type of argument “tails” in =TDIST?

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

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

2. Which is the correct syntax of =TDIST?

A. =FORECAST(x,deg_freedom,tails)
B. =TDIST(x,deg_freedom,tails) ✓
C. TDIST(x,deg_freedom,tails)
D. =TDIST(x,deg_freedom,tails, 0)

Explanation: Correct syntax: =TDIST(x,deg_freedom,tails)

3. What usually causes #NUM! in =TDIST?

A. Select entire column for best performance
B. اگر هر آرگومانی غیرعددی باشد، تابع TDIST خطای #VALUE! را برمی‌گرداند.
C. Output is always a dynamic array
D. If Deg_freedom < 1, TDIST returns the #NUM! error value. If Tails is any value other than 1 or 2, TDIST returns the #NUM! error value. If x < 0, then TDIST returns the #NUM! error value. ✓

Explanation: If Deg_freedom < 1, TDIST returns the #NUM! error value. If Tails is any value other than 1 or 2, TDIST returns the #NUM! error value. If x < 0, then TDIST returns the #NUM! error value. — Fix: Enter allowed values

4. How many arguments does =TDIST have in total?

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

Explanation: =TDIST has 3 required, 0 optional (3 total).

5. Does =TDIST return a dynamic array?

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

Explanation: TDIST does not spill.

6. In =TDIST, which is argument #2?

A. x
B. lookup_value
C. criteria
D. deg_freedom ✓

Explanation: Argument #2 is “deg_freedom”.

7. Which statement about =TDIST is correct?

A. If Tails = 1, TDIST is calculated as TDIST = P( X>x ), where X is a random variable that follows the t-distribution. If Tails = 2, TDIST is calculated as TDIST = P(|X| > x) = P(X > x or X < -x).
B. Only works in old versions
C. Volatile and recalculates every time
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.

8. What is the fix for #NUM! in =TDIST?

A. اگر هر آرگومانی غیرعددی باشد، تابع TDIST خطای #VALUE! را برمی‌گرداند.
B. Text is always ignored
C. Requires add-in
D. Enter allowed values ✓

9. Is =TDIST volatile?

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

Explanation: TDIST is not volatile.

10. How many optional arguments does =TDIST have?

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

Explanation: =TDIST has 3 required, 0 optional (3 total).