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

Which is the correct syntax of =TDIST?

Question 2 of 10 2/10

Is argument “x” required in =TDIST?

Question 3 of 10 3/10

Which function is related to =TDIST?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which statement about =TDIST is correct?

Question 6 of 10 6/10

In =TDIST, which is argument #3?

Question 7 of 10 7/10

Is argument “deg_freedom” required in =TDIST?

Question 8 of 10 8/10

Since which Excel version is =TDIST available?

Question 9 of 10 9/10

How many optional arguments does =TDIST have?

Question 10 of 10 10/10

Which category does =TDIST belong to?

Click a question to see the answer.

1. Which is the correct syntax of =TDIST?

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

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

2. Is argument “x” required in =TDIST?

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

Explanation: “x” is required.

3. Which function is related to =TDIST?

A. REPLACE
B. F.INV.RT
C. FORECAST ✓
D. REGEXREPLACE

Explanation: “FORECAST” is related to TDIST.

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

A. Volatile and recalculates every time
B. Only works in old versions
C. Enter allowed values ✓
D. Requires add-in

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

5. Which statement about =TDIST is correct?

A. Only works in old versions
B. Select entire column for best performance
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. ✓
D. Text is always ignored

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.

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

A. criteria
B. tails ✓
C. lookup_value
D. value

Explanation: Argument #3 is “tails”.

7. Is argument “deg_freedom” required in =TDIST?

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

Explanation: “deg_freedom” is required.

8. Since which Excel version is =TDIST available?

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

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

9. How many optional arguments does =TDIST have?

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

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

10. Which category does =TDIST belong to?

A. Lookup & Reference
B. Logical
C. Cube
D. Compatibility ✓

Explanation: Category is “Compatibility”.