Statistical =GAMMA.DIST(x,alpha,beta,cumulative)

Quiz =GAMMA.DIST — 10 Questions

10 quiz questions about =GAMMA.DIST — test syntax, arguments, examples & errors!

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

← GAMMA.DIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =GAMMA.DIST belong to?

Question 2 of 10 2/10

Which formula is a valid example of =GAMMA.DIST?

Question 3 of 10 3/10

What is the fix for #NUM! in =GAMMA.DIST?

Question 4 of 10 4/10

How many arguments does =GAMMA.DIST have in total?

Question 5 of 10 5/10

How many required arguments does =GAMMA.DIST have?

Question 6 of 10 6/10

What usually causes #NUM! in =GAMMA.DIST?

Question 7 of 10 7/10

Since which Excel version is =GAMMA.DIST available?

Question 8 of 10 8/10

How many optional arguments does =GAMMA.DIST have?

Question 9 of 10 9/10

Which function is NOT related to =GAMMA.DIST?

Question 10 of 10 10/10

Is argument “alpha” required in =GAMMA.DIST?

Click a question to see the answer.

1. Which category does =GAMMA.DIST belong to?

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

Explanation: Category is “Statistical”.

2. Which formula is a valid example of =GAMMA.DIST?

A. =GAMMA.DIST(A2,A3,A4,FALSE) ✓
B. GAMMA.DIST(A2,A3,A4,FALSE)
C. =GAMMA.DIST(A2,A3,A4,FALSE, 0)
D. =CHISQ-DIST(A2,A3,A4,FALSE)

Explanation: Correct example: =GAMMA.DIST(A2,A3,A4,FALSE)

3. What is the fix for #NUM! in =GAMMA.DIST?

A. Correct the input value ✓
B. Requires add-in
C. Text is always ignored
D. Select entire column for best performance

Explanation: If x < 0, GAMMA.DIST returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMA.DIST returns the #NUM! error value. — Fix: Correct the input value

4. How many arguments does =GAMMA.DIST have in total?

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

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

5. How many required arguments does =GAMMA.DIST have?

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

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

6. What usually causes #NUM! in =GAMMA.DIST?

A. If x < 0, GAMMA.DIST returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMA.DIST returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Only works in old versions
D. Text is always ignored

Explanation: If x < 0, GAMMA.DIST returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMA.DIST returns the #NUM! error value. — Fix: Correct the input value

7. Since which Excel version is =GAMMA.DIST available?

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

Explanation: Version: “Excel 2010”.

8. How many optional arguments does =GAMMA.DIST have?

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

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

9. Which function is NOT related to =GAMMA.DIST?

A. CHISQ-DIST
B. GAMMADIST ✓
C. EXPON-DIST
D. GAMMA-INV

Explanation: “GAMMADIST” is not related to GAMMA.DIST.

10. Is argument “alpha” required in =GAMMA.DIST?

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

Explanation: “alpha” is required.