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

Which statement about =CHIINV is correct?

Question 2 of 10 2/10

In =CHIINV, which is argument #1?

Question 3 of 10 3/10

How many optional arguments does =CHIINV have?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is argument “deg_freedom” required in =CHIINV?

Question 7 of 10 7/10

What usually causes #NUM! in =CHIINV?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

What usually causes #N/A in =CHIINV?

Question 10 of 10 10/10

Since which Excel version is =CHIINV available?

Click a question to see the answer.

1. 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. Select entire column for best performance
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.

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

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

Explanation: Argument #1 is “probability”.

3. How many optional arguments does =CHIINV have?

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

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

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

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

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

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

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

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

6. Is argument “deg_freedom” required in =CHIINV?

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

Explanation: “deg_freedom” is required.

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

A. Requires add-in
B. If probability < 0 or probability > 1, CHIINV returns the #NUM! error value. If deg_freedom < 1, CHIINV returns the #NUM! error value. ✓
C. Text is always ignored
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

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

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

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

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

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

10. Since which Excel version is =CHIINV available?

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

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