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

Is argument “deg_freedom” required in =TINV?

Question 2 of 15 2/15

Which function is related to =TINV?

Question 3 of 15 3/15

What usually causes #NUM! in =TINV?

Question 4 of 15 4/15

Which statement about =TINV is correct?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which function is NOT related to =TINV?

Question 7 of 15 7/15

In =TINV, which is argument #2?

Question 8 of 15 8/15

Which use case fits =TINV?

Question 9 of 15 9/15

What usually causes #N/A in =TINV?

Question 10 of 15 10/15

What is the output type of =TINV?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Is =TINV volatile?

Question 13 of 15 13/15

How many optional arguments does =TINV have?

Question 14 of 15 14/15

Which category does =TINV belong to?

Question 15 of 15 15/15

How many required arguments does =TINV have?

Click a question to see the answer.

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

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

Explanation: “deg_freedom” is required.

2. Which function is related to =TINV?

A. FORECAST ✓
B. FTEST
C. MIRR
D. PROPER

Explanation: “FORECAST” is related to TINV.

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

A. If probability <= 0 or if probability > 1, TINV returns the #NUM! error value. If deg_freedom < 1, TINV returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Volatile and recalculates every time
D. اگر هر آرگومانی غیرعددی باشد، تابع TINV خطای #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

4. Which statement about =TINV is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Select entire column for best performance
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.

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

A. اگر هر آرگومانی غیرعددی باشد، تابع TINV خطای #VALUE! را برمی‌گرداند.
B. Output is always a dynamic array
C. اگر probability کوچک‌تر یا مساوی ۰ یا بزرگ‌تر از ۱ باشد، یا deg_freedom کوچک‌تر از ۱ باشد، تابع TINV خطای #NUM! را برمی‌گرداند.
D. مقادیر ورودی را بررسی کنید و با مقادیر معتبر دوباره امتحان کنید؛ در صورت تکرار، احتمال یا درجات آزادی را کمی تغییر دهید. ✓

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

6. Which function is NOT related to =TINV?

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

Explanation: “ASINH” is not related to TINV.

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

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

Explanation: Argument #2 is “deg_freedom”.

8. Which use case fits =TINV?

A. Financial Calculations
B. Reporting ✓
C. Daily Tasks
D. External Data, Web & Cube

Explanation: Use case “Reporting” fits TINV.

9. What usually causes #N/A in =TINV?

A. Requires add-in
B. Text is always ignored
C. Volatile and recalculates every time
D. If the search has not converged after 100 iterations, the function returns the #N/A error value. ✓

10. What is the output type of =TINV?

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

Explanation: Output is “Number”.

11. What is the type of argument “deg_freedom” in =TINV?

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

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

12. Is =TINV volatile?

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

Explanation: TINV is not volatile.

13. How many optional arguments does =TINV have?

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

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

14. Which category does =TINV belong to?

A. Logical
B. Compatibility ✓
C. Cube
D. Financial

Explanation: Category is “Compatibility”.

15. How many required arguments does =TINV have?

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

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