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

Quiz =BINOMDIST — 15 Questions

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

Question 1 of 15 1/15

How many required arguments does =BINOMDIST have?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which formula is a valid example of =BINOMDIST?

Question 4 of 15 4/15

Which function is NOT related to =BINOMDIST?

Question 5 of 15 5/15

Which statement about =BINOMDIST is correct?

Question 6 of 15 6/15

Is =BINOMDIST volatile?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

In =BINOMDIST, which is argument #1?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

What usually causes #VALUE! in =BINOMDIST?

Question 11 of 15 11/15

Which function is related to =BINOMDIST?

Question 12 of 15 12/15

Which is the correct syntax of =BINOMDIST?

Question 13 of 15 13/15

Is argument “number_s” required in =BINOMDIST?

Question 14 of 15 14/15

Is argument “cumulative” required in =BINOMDIST?

Question 15 of 15 15/15

Since which Excel version is =BINOMDIST available?

Click a question to see the answer.

1. How many required arguments does =BINOMDIST have?

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

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

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

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

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

3. Which formula is a valid example of =BINOMDIST?

A. =FORECAST(A2,A3,A4,FALSE)
B. =BINOMDIST(A2,A3,A4,FALSE) ✓
C. =BINOMDIST(A2,A3,A4,FALSE, 0)
D. BINOMDIST(A2,A3,A4,FALSE)

Explanation: Correct example: =BINOMDIST(A2,A3,A4,FALSE)

4. Which function is NOT related to =BINOMDIST?

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

Explanation: “LINEST” is not related to BINOMDIST.

5. Which statement about =BINOMDIST is correct?

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

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.

6. Is =BINOMDIST volatile?

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

Explanation: BINOMDIST is not volatile.

7. What is the type of argument “probability_s” in =BINOMDIST?

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

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

8. In =BINOMDIST, which is argument #1?

A. number_s ✓
B. value
C. criteria
D. probability_s

Explanation: Argument #1 is “number_s”.

9. What is the type of argument “trials” in =BINOMDIST?

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

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

10. What usually causes #VALUE! in =BINOMDIST?

A. If number_s, trials, or probability_s is nonnumeric, BINOMDIST returns the #VALUE! error value. ✓
B. زمانی رخ می‌دهد که number_s کوچک‌تر از ۰ یا بزرگ‌تر از trials باشد، یا probability_s کوچک‌تر از ۰ یا بزرگ‌تر از ۱ باشد.
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: If number_s, trials, or probability_s is nonnumeric, BINOMDIST returns the #VALUE! error value. — Fix: مطمئن شوید هر سه آرگومان عدد هستند و موارد متنی یا خانه‌های خالی را اصلاح کنید.

11. Which function is related to =BINOMDIST?

A. IRR
B. FORECAST ✓
C. FREQUENCY
D. IMSINH

Explanation: “FORECAST” is related to BINOMDIST.

12. Which is the correct syntax of =BINOMDIST?

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

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

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

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

Explanation: “number_s” is required.

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

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

Explanation: “cumulative” is required.

15. Since which Excel version is =BINOMDIST available?

A. Excel 2019
B. All versions
C. Excel 2007 (Compatibility) ✓
D. Excel 365

Explanation: Version: “Excel 2007 (Compatibility)”.