Compatibility =TINV(probability,deg_freedom)

Quiz =TINV — 15 Questions

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

Question 1 of 15 1/15

In =TINV, which is argument #2?

Question 2 of 15 2/15

What usually causes #VALUE! in =TINV?

Question 3 of 15 3/15

Which function is NOT related to =TINV?

Question 4 of 15 4/15

Which function is related to =TINV?

Question 5 of 15 5/15

Is =TINV volatile?

Question 6 of 15 6/15

In =TINV, which is argument #1?

Question 7 of 15 7/15

Which statement about =TINV is correct?

Question 8 of 15 8/15

Is argument “deg_freedom” required in =TINV?

Question 9 of 15 9/15

Since which Excel version is =TINV available?

Question 10 of 15 10/15

Which use case fits =TINV?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

What is the fix for #N/A in =TINV?

Question 13 of 15 13/15

Which category does =TINV belong to?

Question 14 of 15 14/15

Is argument “probability” required in =TINV?

Question 15 of 15 15/15

What usually causes #NUM! in =TINV?

Click a question to see the answer.

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

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

Explanation: Argument #2 is “deg_freedom”.

2. What usually causes #VALUE! in =TINV?

A. If either argument is nonnumeric, TINV returns the #VALUE! error value. ✓
B. Volatile and recalculates every time
C. اگر جستجو پس از ۱۰۰ تکرار همگرا نشود، تابع خطای #N/A را برمی‌گرداند.
D. Output is always a dynamic array

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

3. Which function is NOT related to =TINV?

A. MODE
B. FORECAST
C. PERCENTILE
D. WEIBULL.DIST ✓

Explanation: “WEIBULL.DIST” is not related to TINV.

4. Which function is related to =TINV?

A. FORECAST.LINEAR
B. FORECAST ✓
C. ROWS
D. ERF.PRECISE

Explanation: “FORECAST” is related to TINV.

5. Is =TINV volatile?

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

Explanation: TINV is not volatile.

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

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

Explanation: Argument #1 is “probability”.

7. Which statement about =TINV is correct?

A. Select entire column for best performance
B. Output is always a dynamic array
C. TINV returns that value t, such that P(|X| > t) = probability where X is a random variable that follows the t-distribution and P(|X| > t) = P(X < -t or X > t).
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. For more information about the new functions, see T.INV.2T function or T.INV function. ✓

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.

8. Is argument “deg_freedom” required in =TINV?

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

Explanation: “deg_freedom” is required.

9. Since which Excel version is =TINV available?

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

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

10. Which use case fits =TINV?

A. Financial Calculations
B. Error Handling
C. Reporting ✓
D. Sort, Filter & Dedupe

Explanation: Use case “Reporting” fits TINV.

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

A. Only works in old versions
B. Between 0 and 1 ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

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

12. What is the fix for #N/A in =TINV?

A. Requires add-in
B. مقادیر ورودی را بررسی کنید و با مقادیر معتبر دوباره امتحان کنید؛ در صورت تکرار، احتمال یا درجات آزادی را کمی تغییر دهید. ✓
C. Output is always a dynamic array
D. Text is always ignored

Explanation: If the search has not converged after 100 iterations, the function returns the #N/A error value. — Fix: مقادیر ورودی را بررسی کنید و با مقادیر معتبر دوباره امتحان کنید؛ در صورت تکرار، احتمال یا درجات آزادی را کمی تغییر دهید.

13. Which category does =TINV belong to?

A. Compatibility ✓
B. Math & Trig
C. Logical
D. Date & Time

Explanation: Category is “Compatibility”.

14. Is argument “probability” required in =TINV?

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

Explanation: “probability” is required.

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

A. Text is always ignored
B. Only works in old versions
C. If probability <= 0 or if probability > 1, TINV returns the #NUM! error value. If deg_freedom < 1, TINV returns the #NUM! error value. ✓
D. Select entire column for best performance

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