Compatibility =GAMMAINV(probability,alpha,beta)

Quiz =GAMMAINV — 10 Questions

10 quiz questions about =GAMMAINV — test syntax, arguments, examples & errors!

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

← GAMMAINV ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =GAMMAINV, which is argument #2?

Question 2 of 10 2/10

What usually causes #VALUE! in =GAMMAINV?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

What is the type of argument “beta” in =GAMMAINV?

Question 5 of 10 5/10

What usually causes #NUM! in =GAMMAINV?

Question 6 of 10 6/10

Since which Excel version is =GAMMAINV available?

Question 7 of 10 7/10

Is argument “probability” required in =GAMMAINV?

Question 8 of 10 8/10

Which formula is a valid example of =GAMMAINV?

Question 9 of 10 9/10

Does =GAMMAINV return a dynamic array?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

A. value
B. alpha ✓
C. probability
D. beta

Explanation: Argument #2 is “alpha”.

2. What usually causes #VALUE! in =GAMMAINV?

A. If any argument is text, GAMMAINV returns the #VALUE! error value. ✓
B. جستجوی تکرارشونده پس از ۱۰۰ تکرار همگرا نشده است.
C. Only works in old versions
D. Select entire column for best performance

Explanation: If any argument is text, GAMMAINV returns the #VALUE! error value. — Fix: همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید.

3. What is the fix for #VALUE! in =GAMMAINV?

A. مقدار probability بیرون از بازه ۰ تا ۱ است یا alpha کوچک‌تر یا مساوی ۰ یا beta کوچک‌تر یا مساوی ۰ است.
B. Requires add-in
C. Only works in old versions
D. همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید. ✓

Explanation: If any argument is text, GAMMAINV returns the #VALUE! error value. — Fix: همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید.

4. What is the type of argument “beta” in =GAMMAINV?

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

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

5. What usually causes #NUM! in =GAMMAINV?

A. جستجوی تکرارشونده پس از ۱۰۰ تکرار همگرا نشده است.
B. If probability < 0 or probability > 1, GAMMAINV returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMAINV returns the #NUM! error value. ✓
C. Select entire column for best performance
D. Text is always ignored

Explanation: If probability < 0 or probability > 1, GAMMAINV returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMAINV returns the #NUM! error value. — Fix: Between 0 and 1

6. Since which Excel version is =GAMMAINV available?

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

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

7. Is argument “probability” required in =GAMMAINV?

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

Explanation: “probability” is required.

8. Which formula is a valid example of =GAMMAINV?

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

Explanation: Correct example: =GAMMAINV(A2,A3,A4)

9. Does =GAMMAINV return a dynamic array?

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

Explanation: GAMMAINV does not spill.

10. What is the fix for #N/A in =GAMMAINV?

A. Output is always a dynamic array
B. Requires add-in
C. مقادیر ورودی را بررسی کنید یا با مقادیر probability متفاوت دوباره تلاش کنید. ✓
D. یک یا چند آرگومان متنی هستند.

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