Compatibility =TDIST(x,deg_freedom,tails)

Quiz =TDIST — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

In =TDIST, which is argument #1?

Question 2 of 15 2/15

Which category does =TDIST belong to?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Does =TDIST return a dynamic array?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

How many required arguments does =TDIST have?

Question 7 of 15 7/15

Is argument “deg_freedom” required in =TDIST?

Question 8 of 15 8/15

Which function is related to =TDIST?

Question 9 of 15 9/15

How many optional arguments does =TDIST have?

Question 10 of 15 10/15

Which function is NOT related to =TDIST?

Question 11 of 15 11/15

In =TDIST, which is argument #3?

Question 12 of 15 12/15

In =TDIST, which is argument #2?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Which statement about =TDIST is correct?

Question 15 of 15 15/15

How many arguments does =TDIST have in total?

Click a question to see the answer.

1. In =TDIST, which is argument #1?

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

Explanation: Argument #1 is “x”.

2. Which category does =TDIST belong to?

A. Engineering
B. Information
C. Logical
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

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

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

4. Does =TDIST return a dynamic array?

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

Explanation: TDIST does not spill.

5. What is the type of argument “deg_freedom” in =TDIST?

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

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

6. How many required arguments does =TDIST have?

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

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

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

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

Explanation: “deg_freedom” is required.

8. Which function is related to =TDIST?

A. FORECAST ✓
B. VAR.S
C. SHEETS
D. COTH

Explanation: “FORECAST” is related to TDIST.

9. How many optional arguments does =TDIST have?

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

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

10. Which function is NOT related to =TDIST?

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

Explanation: “MINIFS” is not related to TDIST.

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

A. lookup_value
B. deg_freedom
C. tails ✓
D. range

Explanation: Argument #3 is “tails”.

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

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

Explanation: Argument #2 is “deg_freedom”.

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

A. Volatile and recalculates every time
B. Requires add-in
C. Enter allowed values ✓
D. اگر هر آرگومانی غیرعددی باشد، تابع TDIST خطای #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

14. Which statement about =TDIST 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. ✓
B. Requires add-in
C. Output is always a dynamic array
D. Only works in old versions

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.

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

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

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