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

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

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which use case fits =TINV?

Question 4 of 10 4/10

How many arguments does =TINV have in total?

Question 5 of 10 5/10

Is argument “deg_freedom” required in =TINV?

Question 6 of 10 6/10

Which statement about =TINV is correct?

Question 7 of 10 7/10

Which function is related to =TINV?

Question 8 of 10 8/10

Which is the correct syntax of =TINV?

Question 9 of 10 9/10

In =TINV, which is argument #1?

Question 10 of 10 10/10

What usually causes #VALUE! in =TINV?

Click a question to see the answer.

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

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

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

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

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

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

3. Which use case fits =TINV?

A. Dynamic Ranges & Dashboards
B. Conditional Aggregation
C. Reporting ✓
D. Workdays & Due Dates

Explanation: Use case “Reporting” fits TINV.

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

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

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

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

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

Explanation: “deg_freedom” is required.

6. Which statement about =TINV is correct?

A. If deg_freedom is not an integer, it is truncated.
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. Text is always ignored
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.

7. Which function is related to =TINV?

A. FORECAST ✓
B. COS
C. UNICODE
D. DOLLARDE

Explanation: “FORECAST” is related to TINV.

8. Which is the correct syntax of =TINV?

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

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

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

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

Explanation: Argument #1 is “probability”.

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

A. Text is always ignored
B. اگر probability کوچک‌تر یا مساوی ۰ یا بزرگ‌تر از ۱ باشد، یا deg_freedom کوچک‌تر از ۱ باشد، تابع TINV خطای #NUM! را برمی‌گرداند.
C. Output is always a dynamic array
D. If either argument is nonnumeric, TINV returns the #VALUE! error value. ✓

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