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

Quiz =GAMMADIST — 10 Questions

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

Question 1 of 10 1/10

Which function is NOT related to =GAMMADIST?

Question 2 of 10 2/10

Which formula is a valid example of =GAMMADIST?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

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

Question 5 of 10 5/10

In =GAMMADIST, which is argument #3?

Question 6 of 10 6/10

Which category does =GAMMADIST belong to?

Question 7 of 10 7/10

Is argument “x” required in =GAMMADIST?

Question 8 of 10 8/10

Is =GAMMADIST volatile?

Question 9 of 10 9/10

Which statement about =GAMMADIST is correct?

Question 10 of 10 10/10

How many optional arguments does =GAMMADIST have?

Click a question to see the answer.

1. Which function is NOT related to =GAMMADIST?

A. FORECAST
B. MODE
C. REPLACE ✓
D. PERCENTILE

Explanation: “REPLACE” is not related to GAMMADIST.

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

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

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

3. What is the type of argument “alpha” in =GAMMADIST?

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

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

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

A. Date
B. Value
C. Text
D. Logical ✓

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

5. In =GAMMADIST, which is argument #3?

A. lookup_value
B. range
C. beta ✓
D. x

Explanation: Argument #3 is “beta”.

6. Which category does =GAMMADIST belong to?

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

Explanation: Category is “Compatibility”.

7. Is argument “x” required in =GAMMADIST?

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

Explanation: “x” is required.

8. Is =GAMMADIST volatile?

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

Explanation: GAMMADIST is not volatile.

9. Which statement about =GAMMADIST is correct?

A. Requires add-in
B. Text is always ignored
C. Only works in old versions
D. 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. ✓

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.

10. How many optional arguments does =GAMMADIST have?

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

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