Compatibility =CHIINV(probability,deg_freedom)

Quiz =CHIINV — 15 Questions

15 quiz questions about =CHIINV — test syntax, arguments, examples & errors!

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

← CHIINV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which use case fits =CHIINV?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which formula is a valid example of =CHIINV?

Question 5 of 15 5/15

How many required arguments does =CHIINV have?

Question 6 of 15 6/15

Which function is related to =CHIINV?

Question 7 of 15 7/15

Which category does =CHIINV belong to?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Which function is NOT related to =CHIINV?

Question 10 of 15 10/15

Since which Excel version is =CHIINV available?

Question 11 of 15 11/15

How many optional arguments does =CHIINV have?

Question 12 of 15 12/15

In =CHIINV, which is argument #2?

Question 13 of 15 13/15

What usually causes #N/A in =CHIINV?

Question 14 of 15 14/15

What usually causes #NUM! in =CHIINV?

Question 15 of 15 15/15

Does =CHIINV return a dynamic array?

Click a question to see the answer.

1. Which use case fits =CHIINV?

A. Conditional Formatting & Validation
B. Reporting ✓
C. Conditional Logic
D. External Data, Web & Cube

Explanation: Use case “Reporting” fits CHIINV.

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

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

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

3. What is the fix for #N/A in =CHIINV?

A. احتمال خارج از ‎۰ تا ۱ است یا درجات آزادی کمتر از ‎۱ است.
B. Volatile and recalculates every time
C. Text is always ignored
D. مقادیر ورودی را بررسی کنید یا با احتمال و درجات آزادی دیگری دوباره امتحان کنید. ✓

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

4. Which formula is a valid example of =CHIINV?

A. =CHIINV(A2,A3) ✓
B. =CHIINV(A2,A3, 0)
C. CHIINV(A2,A3)
D. =FORECAST(A2,A3)

Explanation: Correct example: =CHIINV(A2,A3)

5. How many required arguments does =CHIINV have?

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

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

6. Which function is related to =CHIINV?

A. FORECAST ✓
B. TANH
C. TIMEVALUE
D. CHISQ.TEST

Explanation: “FORECAST” is related to CHIINV.

7. Which category does =CHIINV belong to?

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

Explanation: Category is “Compatibility”.

8. What is the fix for #VALUE! in =CHIINV?

A. Only works in old versions
B. Volatile and recalculates every time
C. برای هر دو آرگومان مقدار عددی وارد کنید. ✓
D. جستجو پس از ‎۱۰۰ تکرار همگرا نشده است.

Explanation: If either argument is nonnumeric, CHIINV returns the #VALUE! error value. — Fix: برای هر دو آرگومان مقدار عددی وارد کنید.

9. Which function is NOT related to =CHIINV?

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

Explanation: “MODE.MULT” is not related to CHIINV.

10. Since which Excel version is =CHIINV available?

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

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

11. How many optional arguments does =CHIINV have?

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

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

12. In =CHIINV, which is argument #2?

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

Explanation: Argument #2 is “deg_freedom”.

13. What usually causes #N/A in =CHIINV?

A. Volatile and recalculates every time
B. یکی از آرگومان‌ها غیرعددی است.
C. Only works in old versions
D. If the search has not converged after 100 iterations, the function returns the #N/A error value. ✓

14. What usually causes #NUM! in =CHIINV?

A. If probability < 0 or probability > 1, CHIINV returns the #NUM! error value. If deg_freedom < 1, CHIINV returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Only works in old versions
D. جستجو پس از ‎۱۰۰ تکرار همگرا نشده است.

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

15. Does =CHIINV return a dynamic array?

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

Explanation: CHIINV does not spill.