Compatibility =BINOMDIST(number_s,trials,probability_s,cumulative)

Quiz =BINOMDIST — 10 Questions

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

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

← BINOMDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =BINOMDIST is correct?

Question 2 of 10 2/10

What is the type of argument “number_s” in =BINOMDIST?

Question 3 of 10 3/10

How many required arguments does =BINOMDIST have?

Question 4 of 10 4/10

Is argument “probability_s” required in =BINOMDIST?

Question 5 of 10 5/10

Is argument “trials” required in =BINOMDIST?

Question 6 of 10 6/10

Is argument “number_s” required in =BINOMDIST?

Question 7 of 10 7/10

What usually causes #NUM! in =BINOMDIST?

Question 8 of 10 8/10

Which is the correct syntax of =BINOMDIST?

Question 9 of 10 9/10

How many arguments does =BINOMDIST have in total?

Question 10 of 10 10/10

Is argument “cumulative” required in =BINOMDIST?

Click a question to see the answer.

1. Which statement about =BINOMDIST is correct?

A. Text is always ignored
B. Volatile and recalculates every time
C. 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. ✓
D. Only works in old versions

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.

2. What is the type of argument “number_s” in =BINOMDIST?

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

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

3. How many required arguments does =BINOMDIST have?

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

Explanation: =BINOMDIST has 4 required, 0 optional (4 total).

4. Is argument “probability_s” required in =BINOMDIST?

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

Explanation: “probability_s” is required.

5. Is argument “trials” required in =BINOMDIST?

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

Explanation: “trials” is required.

6. Is argument “number_s” required in =BINOMDIST?

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

Explanation: “number_s” is required.

7. What usually causes #NUM! in =BINOMDIST?

A. زمانی رخ می‌دهد که number_s یا trials یا probability_s غیرعددی باشد.
B. Text is always ignored
C. Only works in old versions
D. If number_s < 0 or number_s > trials, BINOMDIST returns the #NUM! error value. If probability_s < 0 or probability_s > 1, BINOMDIST returns the #NUM! error value. ✓

Explanation: If number_s < 0 or number_s > trials, BINOMDIST returns the #NUM! error value. If probability_s < 0 or probability_s > 1, BINOMDIST returns the #NUM! error value. — Fix: Put the inputs within the allowed range

8. Which is the correct syntax of =BINOMDIST?

A. =BINOMDIST(number_s,trials,probability_s,cumulative, 0)
B. =BINOMDIST(number_s,trials,probability_s,cumulative) ✓
C. =FORECAST(number_s,trials,probability_s,cumulative)
D. BINOMDIST(number_s,trials,probability_s,cumulative)

Explanation: Correct syntax: =BINOMDIST(number_s,trials,probability_s,cumulative)

9. How many arguments does =BINOMDIST have in total?

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

Explanation: =BINOMDIST has 4 required, 0 optional (4 total).

10. Is argument “cumulative” required in =BINOMDIST?

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

Explanation: “cumulative” is required.