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 required arguments does =POISSON have?

Question 2 of 10 2/10

In =POISSON, which is argument #1?

Question 3 of 10 3/10

Is argument “cumulative” required in =POISSON?

Question 4 of 10 4/10

Which formula is a valid example of =POISSON?

Question 5 of 10 5/10

Which function is related to =POISSON?

Question 6 of 10 6/10

Which category does =POISSON belong to?

Question 7 of 10 7/10

Which function is NOT related to =POISSON?

Question 8 of 10 8/10

Is argument “mean” required in =POISSON?

Question 9 of 10 9/10

Which use case fits =POISSON?

Question 10 of 10 10/10

Which statement about =POISSON is correct?

Click a question to see the answer.

1. How many required arguments does =POISSON have?

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

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

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

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

Explanation: Argument #1 is “x”.

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

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

Explanation: “cumulative” is required.

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

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

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

5. Which function is related to =POISSON?

A. ISO.CEILING
B. FORECAST ✓
C. AND
D. EFFECT

Explanation: “FORECAST” is related to POISSON.

6. Which category does =POISSON belong to?

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

Explanation: Category is “Compatibility”.

7. Which function is NOT related to =POISSON?

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

Explanation: “EOMONTH” is not related to POISSON.

8. Is argument “mean” required in =POISSON?

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

Explanation: “mean” is required.

9. Which use case fits =POISSON?

A. Date & Time Calculations
B. Numbering & Sample Data
C. Daily Tasks
D. Reporting ✓

Explanation: Use case “Reporting” fits POISSON.

10. Which statement about =POISSON is correct?

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. If x is not an integer, it is truncated.
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.