Compatibility =GAMMAINV(probability,alpha,beta)

Quiz =GAMMAINV — 15 Questions

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

Question 1 of 15 1/15

Which is the correct syntax of =GAMMAINV?

Question 2 of 15 2/15

In =GAMMAINV, which is argument #3?

Question 3 of 15 3/15

Which statement about =GAMMAINV is correct?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Is =GAMMAINV volatile?

Question 6 of 15 6/15

What is the output type of =GAMMAINV?

Question 7 of 15 7/15

How many arguments does =GAMMAINV have in total?

Question 8 of 15 8/15

Is argument “alpha” required in =GAMMAINV?

Question 9 of 15 9/15

In =GAMMAINV, which is argument #1?

Question 10 of 15 10/15

What usually causes #VALUE! in =GAMMAINV?

Question 11 of 15 11/15

Which formula is a valid example of =GAMMAINV?

Question 12 of 15 12/15

What usually causes #NUM! in =GAMMAINV?

Question 13 of 15 13/15

Which use case fits =GAMMAINV?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which is the correct syntax of =GAMMAINV?

A. =GAMMAINV(probability,alpha,beta) ✓
B. =FORECAST(probability,alpha,beta)
C. GAMMAINV(probability,alpha,beta)
D. =GAMMAINV(probability,alpha,beta, 0)

Explanation: Correct syntax: =GAMMAINV(probability,alpha,beta)

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

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

Explanation: Argument #3 is “beta”.

3. Which statement about =GAMMAINV is correct?

A. Select entire column for best performance
B. Text is always ignored
C. 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. ✓
D. Output is always a dynamic array

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.

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

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

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

5. Is =GAMMAINV volatile?

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

Explanation: GAMMAINV is not volatile.

6. What is the output type of =GAMMAINV?

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

Explanation: Output is “Number”.

7. How many arguments does =GAMMAINV have in total?

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

Explanation: =GAMMAINV has 3 required, 0 optional (3 total).

8. Is argument “alpha” required in =GAMMAINV?

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

Explanation: “alpha” is required.

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

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

Explanation: Argument #1 is “probability”.

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

A. Text is always ignored
B. جستجوی تکرارشونده پس از ۱۰۰ تکرار همگرا نشده است.
C. مقدار probability بیرون از بازه ۰ تا ۱ است یا alpha کوچک‌تر یا مساوی ۰ یا beta کوچک‌تر یا مساوی ۰ است.
D. If any argument is text, GAMMAINV returns the #VALUE! error value. ✓

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

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

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

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

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

A. یک یا چند آرگومان متنی هستند.
B. Requires add-in
C. Text is always ignored
D. 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. ✓

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

13. Which use case fits =GAMMAINV?

A. Lookup & Retrieval
B. Reporting ✓
C. Numbering & Sample Data
D. Daily Tasks

Explanation: Use case “Reporting” fits GAMMAINV.

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

A. Output is always a dynamic array
B. همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید. ✓
C. جستجوی تکرارشونده پس از ۱۰۰ تکرار همگرا نشده است.
D. Only works in old versions

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

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

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

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