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

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

Question 2 of 15 2/15

Which is the correct syntax of =TINV?

Question 3 of 15 3/15

Since which Excel version is =TINV available?

Question 4 of 15 4/15

How many optional arguments does =TINV have?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

In =TINV, which is argument #2?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many arguments does =TINV have in total?

Question 9 of 15 9/15

In =TINV, which is argument #1?

Question 10 of 15 10/15

Is =TINV volatile?

Question 11 of 15 11/15

What is the output type of =TINV?

Question 12 of 15 12/15

Which statement about =TINV is correct?

Question 13 of 15 13/15

Which function is related to =TINV?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which function is NOT related to =TINV?

Click a question to see the answer.

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

A. Between 0 and 1 ✓
B. Requires add-in
C. Select entire column for best performance
D. Output is always a dynamic array

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

2. Which is the correct syntax of =TINV?

A. TINV(probability,deg_freedom)
B. =TINV(probability,deg_freedom) ✓
C. =FORECAST(probability,deg_freedom)
D. =TINV(probability,deg_freedom, 0)

Explanation: Correct syntax: =TINV(probability,deg_freedom)

3. Since which Excel version is =TINV available?

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

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

4. How many optional arguments does =TINV have?

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

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

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

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

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

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

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

Explanation: Argument #2 is “deg_freedom”.

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

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

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

8. How many arguments does =TINV have in total?

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

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

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

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

Explanation: Argument #1 is “probability”.

10. Is =TINV volatile?

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

Explanation: TINV is not volatile.

11. What is the output type of =TINV?

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

Explanation: Output is “Number”.

12. Which statement about =TINV is correct?

A. Text is always ignored
B. 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. ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

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.

13. Which function is related to =TINV?

A. FORECAST ✓
B. NPER
C. ERF.PRECISE
D. DCOUNT

Explanation: “FORECAST” is related to TINV.

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

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

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

15. Which function is NOT related to =TINV?

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

Explanation: “PV” is not related to TINV.