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

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

Question 2 of 10 2/10

Which function is related to =POISSON?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which formula is a valid example of =POISSON?

Question 6 of 10 6/10

Which is the correct syntax of =POISSON?

Question 7 of 10 7/10

In =POISSON, which is argument #1?

Question 8 of 10 8/10

Is argument “mean” required in =POISSON?

Question 9 of 10 9/10

In =POISSON, which is argument #2?

Question 10 of 10 10/10

Which statement about =POISSON is correct?

Click a question to see the answer.

1. What is the fix for #NUM! in =POISSON?

A. Output is always a dynamic array
B. Enter allowed values ✓
C. Select entire column for best performance
D. Text is always ignored

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

2. Which function is related to =POISSON?

A. FORECAST ✓
B. ISPMT
C. ERFC
D. FISHERINV

Explanation: “FORECAST” is related to POISSON.

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

A. Select entire column for best performance
B. برای x و mean مقادیر عددی وارد کنید و بررسی کنید سلول‌ها متنی یا خالی نباشند. ✓
C. Text is always ignored
D. مقدار x یا mean کوچک‌تر از صفر است.

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

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

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

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

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

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

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

6. Which is the correct syntax of =POISSON?

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

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

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

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

Explanation: Argument #1 is “x”.

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

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

Explanation: “mean” is required.

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

A. criteria
B. value
C. range
D. mean ✓

Explanation: Argument #2 is “mean”.

10. Which statement about =POISSON is correct?

A. Requires add-in
B. 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. ✓
C. Text is always ignored
D. Select entire column for best performance

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.