Compatibility =GAMMADIST(x,alpha,beta,cumulative)

Quiz =GAMMADIST — 15 Questions

15 quiz questions about =GAMMADIST — test syntax, arguments, examples & errors!

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

← GAMMADIST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

In =GAMMADIST, which is argument #2?

Question 3 of 15 3/15

Is argument “alpha” required in =GAMMADIST?

Question 4 of 15 4/15

Which category does =GAMMADIST belong to?

Question 5 of 15 5/15

How many required arguments does =GAMMADIST have?

Question 6 of 15 6/15

Which formula is a valid example of =GAMMADIST?

Question 7 of 15 7/15

In =GAMMADIST, which is argument #1?

Question 8 of 15 8/15

Which statement about =GAMMADIST is correct?

Question 9 of 15 9/15

Which function is related to =GAMMADIST?

Question 10 of 15 10/15

Is argument “beta” required in =GAMMADIST?

Question 11 of 15 11/15

What usually causes #VALUE! in =GAMMADIST?

Question 12 of 15 12/15

What is the type of argument “cumulative” in =GAMMADIST?

Question 13 of 15 13/15

How many optional arguments does =GAMMADIST have?

Question 14 of 15 14/15

Is argument “cumulative” required in =GAMMADIST?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. What is the type of argument “beta” in =GAMMADIST?

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

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

2. In =GAMMADIST, which is argument #2?

A. criteria
B. beta
C. alpha ✓
D. x

Explanation: Argument #2 is “alpha”.

3. Is argument “alpha” required in =GAMMADIST?

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

Explanation: “alpha” is required.

4. Which category does =GAMMADIST belong to?

A. Compatibility ✓
B. Information
C. Database
D. Cube

Explanation: Category is “Compatibility”.

5. How many required arguments does =GAMMADIST have?

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

Explanation: =GAMMADIST has 4 required, 0 optional (4 total).

6. Which formula is a valid example of =GAMMADIST?

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

Explanation: Correct example: =GAMMADIST(A2,A3,A4,FALSE)

7. In =GAMMADIST, which is argument #1?

A. x ✓
B. range
C. criteria
D. alpha

Explanation: Argument #1 is “x”.

8. Which statement about =GAMMADIST 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. For more information about the new function, see GAMMA.DIST function. ✓
B. When alpha = 1, GAMMADIST returns the exponential distribution with:
C. The equation for the gamma probability density function is: The standard gamma probability density function is:
D. For a positive integer n, when alpha = n/2, beta = 2, and cumulative = TRUE, GAMMADIST returns (1 - CHIDIST(x)) with n degrees of freedom.

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. For more information about the new function, see GAMMA.DIST function.

9. Which function is related to =GAMMADIST?

A. STDEV.P
B. T
C. FORECAST ✓
D. GROUPBY

Explanation: “FORECAST” is related to GAMMADIST.

10. Is argument “beta” required in =GAMMADIST?

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

Explanation: “beta” is required.

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

A. مقدار x کوچک‌تر از ۰ است یا alpha کوچک‌تر یا مساوی ۰ یا beta کوچک‌تر یا مساوی ۰ است.
B. If x, alpha, or beta is nonnumeric, GAMMADIST returns the #VALUE! error value. ✓
C. Select entire column for best performance
D. Output is always a dynamic array

Explanation: If x, alpha, or beta is nonnumeric, GAMMADIST returns the #VALUE! error value. — Fix: برای هر سه آرگومان مقدار عددی وارد کنید.

12. What is the type of argument “cumulative” in =GAMMADIST?

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

Explanation: Type of “cumulative” is “Logical”.

13. How many optional arguments does =GAMMADIST have?

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

Explanation: =GAMMADIST has 4 required, 0 optional (4 total).

14. Is argument “cumulative” required in =GAMMADIST?

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

Explanation: “cumulative” is required.

15. What is the fix for #NUM! in =GAMMADIST?

A. Valid values ✓
B. Only works in old versions
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: If x < 0, GAMMADIST returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMADIST returns the #NUM! error value. — Fix: Valid values