Compatibility =TINV(probability,deg_freedom)

Quiz =TINV — 10 Questions

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

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

← TINV ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =TINV have?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =TINV, which is argument #1?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What usually causes #NUM! in =TINV?

Question 6 of 10 6/10

In =TINV, which is argument #2?

Question 7 of 10 7/10

What is the type of argument “probability” in =TINV?

Question 8 of 10 8/10

Does =TINV return a dynamic array?

Question 9 of 10 9/10

What is the output type of =TINV?

Question 10 of 10 10/10

Which statement about =TINV is correct?

Click a question to see the answer.

1. How many optional arguments does =TINV have?

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

Explanation: =TINV has 2 required, 0 optional (2 total).

2. What is the fix for #VALUE! in =TINV?

A. Only works in old versions
B. اگر probability کوچک‌تر یا مساوی ۰ یا بزرگ‌تر از ۱ باشد، یا deg_freedom کوچک‌تر از ۱ باشد، تابع TINV خطای #NUM! را برمی‌گرداند.
C. بررسی کنید Probability و Deg_freedom هر دو عددی باشند. ✓
D. Volatile and recalculates every time

Explanation: If either argument is nonnumeric, TINV returns the #VALUE! error value. — Fix: بررسی کنید Probability و Deg_freedom هر دو عددی باشند.

3. In =TINV, which is argument #1?

A. probability ✓
B. range
C. value
D. criteria

Explanation: Argument #1 is “probability”.

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

A. Between 0 and 1 ✓
B. Requires add-in
C. Output is always a dynamic array
D. اگر جستجو پس از ۱۰۰ تکرار همگرا نشود، تابع خطای #N/A را برمی‌گرداند.

Explanation: If probability <= 0 or if probability > 1, TINV returns the #NUM! error value. If deg_freedom < 1, TINV returns the #NUM! error value. — Fix: Between 0 and 1

5. What usually causes #NUM! in =TINV?

A. Only works in old versions
B. اگر جستجو پس از ۱۰۰ تکرار همگرا نشود، تابع خطای #N/A را برمی‌گرداند.
C. Select entire column for best performance
D. If probability <= 0 or if probability > 1, TINV returns the #NUM! error value. If deg_freedom < 1, TINV returns the #NUM! error value. ✓

Explanation: If probability <= 0 or if probability > 1, TINV returns the #NUM! error value. If deg_freedom < 1, TINV returns the #NUM! error value. — Fix: Between 0 and 1

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

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

Explanation: Argument #2 is “deg_freedom”.

7. What is the type of argument “probability” in =TINV?

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

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

8. Does =TINV return a dynamic array?

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

Explanation: TINV does not spill.

9. What is the output type of =TINV?

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

Explanation: Output is “Number”.

10. Which statement about =TINV 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. For more information about the new functions, see T.INV.2T function or T.INV function. ✓
B. Select entire column for best performance
C. Text is always ignored
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. For more information about the new functions, see T.INV.2T function or T.INV function.