Statistical =GAMMA(number)

Quiz =GAMMA — 10 Questions

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

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

← GAMMA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “number” in =GAMMA?

Question 2 of 10 2/10

Does =GAMMA return a dynamic array?

Question 3 of 10 3/10

How many required arguments does =GAMMA have?

Question 4 of 10 4/10

Which category does =GAMMA belong to?

Question 5 of 10 5/10

What usually causes #NUM! in =GAMMA?

Question 6 of 10 6/10

Which is the correct syntax of =GAMMA?

Question 7 of 10 7/10

In =GAMMA, which is argument #1?

Question 8 of 10 8/10

What is the output type of =GAMMA?

Question 9 of 10 9/10

Is =GAMMA volatile?

Question 10 of 10 10/10

What usually causes #VALUE! in =GAMMA?

Click a question to see the answer.

1. What is the type of argument “number” in =GAMMA?

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

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

2. Does =GAMMA return a dynamic array?

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

Explanation: GAMMA does not spill.

3. How many required arguments does =GAMMA have?

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

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

4. Which category does =GAMMA belong to?

A. Cube
B. Web
C. Statistical ✓
D. Financial

Explanation: Category is “Statistical”.

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

A. Select entire column for best performance
B. If Number is a negative integer or 0, GAMMA returns the #NUM! error value. ✓
C. مقدار Number شامل نویسه‌های نامعتبر است.
D. Output is always a dynamic array

Explanation: If Number is a negative integer or 0, GAMMA returns the #NUM! error value. — Fix: Correct the input value

6. Which is the correct syntax of =GAMMA?

A. =GAMMA(number, 0)
B. =GAMMA(number) ✓
C. =GAMMA-DIST(number)
D. GAMMA(number)

Explanation: Correct syntax: =GAMMA(number)

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

A. value
B. range
C. number ✓
D. lookup_value

Explanation: Argument #1 is “number”.

8. What is the output type of =GAMMA?

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

Explanation: Output is “Number”.

9. Is =GAMMA volatile?

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

Explanation: GAMMA is not volatile.

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. If Number contains characters that are not valid, GAMMA returns the #VALUE! error value. ✓
D. Text is always ignored

Explanation: If Number contains characters that are not valid, GAMMA returns the #VALUE! error value. — Fix: برای Number مقدار عددی معتبر وارد کنید و ورودی‌های متنی را اصلاح کنید.