Compatibility =POISSON(x,mean,cumulative)

Quiz =POISSON — 10 Questions

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

Question 1 of 10 1/10

How many arguments does =POISSON have in total?

Question 2 of 10 2/10

Does =POISSON return a dynamic array?

Question 3 of 10 3/10

Is argument “x” required in =POISSON?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

In =POISSON, which is argument #1?

Question 6 of 10 6/10

In =POISSON, which is argument #3?

Question 7 of 10 7/10

Is argument “cumulative” required in =POISSON?

Question 8 of 10 8/10

Which statement about =POISSON is correct?

Question 9 of 10 9/10

How many optional arguments does =POISSON have?

Question 10 of 10 10/10

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. 3 ✓
B. 4
C. 2
D. 5

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

2. Does =POISSON return a dynamic array?

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

Explanation: POISSON does not spill.

3. Is argument “x” required in =POISSON?

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

Explanation: “x” is required.

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

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

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

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

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

Explanation: Argument #1 is “x”.

6. In =POISSON, which is argument #3?

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

Explanation: Argument #3 is “cumulative”.

7. Is argument “cumulative” required in =POISSON?

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

Explanation: “cumulative” is required.

8. Which statement about =POISSON is correct?

A. If x is not an integer, it is truncated.
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 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.

9. How many optional arguments does =POISSON have?

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

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

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

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

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