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

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

Question 2 of 15 2/15

What usually causes #NUM! in =CHIINV?

Question 3 of 15 3/15

How many arguments does =CHIINV have in total?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

How many required arguments does =CHIINV have?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which formula is a valid example of =CHIINV?

Question 8 of 15 8/15

Does =CHIINV return a dynamic array?

Question 9 of 15 9/15

In =CHIINV, which is argument #2?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

What usually causes #VALUE! in =CHIINV?

Question 12 of 15 12/15

How many optional arguments does =CHIINV have?

Question 13 of 15 13/15

Which function is NOT related to =CHIINV?

Question 14 of 15 14/15

Which function is related to =CHIINV?

Question 15 of 15 15/15

Which statement about =CHIINV is correct?

Click a question to see the answer.

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

A. جستجو پس از ‎۱۰۰ تکرار همگرا نشده است.
B. Between 0 and 1 ✓
C. Select entire column for best performance
D. Requires add-in

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

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

A. Volatile and recalculates every time
B. If probability < 0 or probability > 1, CHIINV returns the #NUM! error value. If deg_freedom < 1, CHIINV returns the #NUM! error value. ✓
C. Select entire column for best performance
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

3. How many arguments does =CHIINV have in total?

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

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

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

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

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

5. How many required arguments does =CHIINV have?

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

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

6. What is the type of argument “deg_freedom” in =CHIINV?

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

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

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

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

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

8. Does =CHIINV return a dynamic array?

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

Explanation: CHIINV does not spill.

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

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

Explanation: Argument #2 is “deg_freedom”.

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

A. برای هر دو آرگومان مقدار عددی وارد کنید. ✓
B. Select entire column for best performance
C. Text is always ignored
D. جستجو پس از ‎۱۰۰ تکرار همگرا نشده است.

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

11. What usually causes #VALUE! in =CHIINV?

A. Requires add-in
B. Only works in old versions
C. If either argument is nonnumeric, CHIINV returns the #VALUE! error value. ✓
D. Text is always ignored

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

12. How many optional arguments does =CHIINV have?

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

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

13. Which function is NOT related to =CHIINV?

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

Explanation: “DATE” is not related to CHIINV.

14. Which function is related to =CHIINV?

A. CHISQ.TEST
B. COLUMNS
C. MINIFS
D. FORECAST ✓

Explanation: “FORECAST” is related to CHIINV.

15. Which statement about =CHIINV is correct?

A. 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. ✓
B. Requires add-in
C. Output is always a dynamic array
D. If deg_freedom is not an integer, it is truncated.

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.