Compatibility =CHIINV(probability,deg_freedom)

Quiz =CHIINV — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which function is NOT related to =CHIINV?

Question 4 of 10 4/10

Which statement about =CHIINV is correct?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

What usually causes #NUM! in =CHIINV?

Question 7 of 10 7/10

How many optional arguments does =CHIINV have?

Question 8 of 10 8/10

What usually causes #N/A in =CHIINV?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Does =CHIINV return a dynamic array?

Click a question to see the answer.

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

A. Requires add-in
B. Between 0 and 1 ✓
C. Only works in old versions
D. Volatile and recalculates every time

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 is the fix for #N/A in =CHIINV?

A. مقادیر ورودی را بررسی کنید یا با احتمال و درجات آزادی دیگری دوباره امتحان کنید. ✓
B. احتمال خارج از ‎۰ تا ۱ است یا درجات آزادی کمتر از ‎۱ است.
C. Text is always ignored
D. Output is always a dynamic array

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

3. Which function is NOT related to =CHIINV?

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

Explanation: “IFS” is not related to CHIINV.

4. 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. Only works in old versions
C. Select entire column for best performance
D. Text is always ignored

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.

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

A. Number ✓
B. Array
C. Logical
D. Mixed

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

6. 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. Volatile and recalculates every time
C. Output is always a dynamic array
D. Only works in old versions

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

7. How many optional arguments does =CHIINV have?

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

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

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

A. یکی از آرگومان‌ها غیرعددی است.
B. If the search has not converged after 100 iterations, the function returns the #N/A error value. ✓
C. Select entire column for best performance
D. Requires add-in

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

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

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

10. Does =CHIINV return a dynamic array?

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

Explanation: CHIINV does not spill.