Compatibility =POISSON(x,mean,cumulative)

Quiz =POISSON — 15 Questions

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

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

← POISSON ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many arguments does =POISSON have in total?

Question 2 of 15 2/15

What usually causes #VALUE! in =POISSON?

Question 3 of 15 3/15

How many optional arguments does =POISSON have?

Question 4 of 15 4/15

In =POISSON, which is argument #2?

Question 5 of 15 5/15

Which is the correct syntax of =POISSON?

Question 6 of 15 6/15

Which formula is a valid example of =POISSON?

Question 7 of 15 7/15

Which function is NOT related to =POISSON?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

What is the output type of =POISSON?

Question 10 of 15 10/15

Which statement about =POISSON is correct?

Question 11 of 15 11/15

What usually causes #NUM! in =POISSON?

Question 12 of 15 12/15

How many required arguments does =POISSON have?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

In =POISSON, which is argument #1?

Question 15 of 15 15/15

What is the type of argument “mean” in =POISSON?

Click a question to see the answer.

1. How many arguments does =POISSON have in total?

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

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

2. What usually causes #VALUE! in =POISSON?

A. If x or mean is nonnumeric, POISSON returns the #VALUE! error value. ✓
B. Select entire column for best performance
C. Text is always ignored
D. مقدار x یا mean کوچک‌تر از صفر است.

Explanation: If x or mean is nonnumeric, POISSON returns the #VALUE! error value. — Fix: برای x و mean مقادیر عددی وارد کنید و بررسی کنید سلول‌ها متنی یا خالی نباشند.

3. How many optional arguments does =POISSON have?

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

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

4. In =POISSON, which is argument #2?

A. mean ✓
B. x
C. lookup_value
D. cumulative

Explanation: Argument #2 is “mean”.

5. Which is the correct syntax of =POISSON?

A. =POISSON(x,mean,cumulative, 0)
B. POISSON(x,mean,cumulative)
C. =POISSON(x,mean,cumulative) ✓
D. =FORECAST(x,mean,cumulative)

Explanation: Correct syntax: =POISSON(x,mean,cumulative)

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

A. =FORECAST(A2,A3,TRUE)
B. POISSON(A2,A3,TRUE)
C. =POISSON(A2,A3,TRUE) ✓
D. =POISSON(A2,A3,TRUE, 0)

Explanation: Correct example: =POISSON(A2,A3,TRUE)

7. Which function is NOT related to =POISSON?

A. CHISQ.TEST ✓
B. MODE
C. PERCENTILE
D. FORECAST

Explanation: “CHISQ.TEST” is not related to POISSON.

8. What is the type of argument “cumulative” in =POISSON?

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

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

9. What is the output type of =POISSON?

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

Explanation: Output is “Number”.

10. Which statement about =POISSON is correct?

A. Requires add-in
B. Text is always ignored
C. Output is always a dynamic array
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 POISSON.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 POISSON.DIST function.

11. What usually causes #NUM! in =POISSON?

A. Volatile and recalculates every time
B. مقدار x یا mean غیرعددی است.
C. Select entire column for best performance
D. If x < 0, POISSON returns the #NUM! error value. If mean < 0, POISSON returns the #NUM! error value. ✓

Explanation: If x < 0, POISSON returns the #NUM! error value. If mean < 0, POISSON returns the #NUM! error value. — Fix: Enter allowed values

12. How many required arguments does =POISSON have?

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

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

13. What is the fix for #VALUE! in =POISSON?

A. Text is always ignored
B. Only works in old versions
C. برای x و mean مقادیر عددی وارد کنید و بررسی کنید سلول‌ها متنی یا خالی نباشند. ✓
D. Requires add-in

14. In =POISSON, which is argument #1?

A. x ✓
B. cumulative
C. range
D. value

Explanation: Argument #1 is “x”.

15. What is the type of argument “mean” in =POISSON?

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

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