Compatibility =CRITBINOM(trials,probability_s,alpha)

Quiz =CRITBINOM — 10 Questions

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

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

← CRITBINOM ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which formula is a valid example of =CRITBINOM?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which is the correct syntax of =CRITBINOM?

Question 4 of 10 4/10

What usually causes #NUM! in =CRITBINOM?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is argument “alpha” required in =CRITBINOM?

Question 7 of 10 7/10

Which statement about =CRITBINOM is correct?

Question 8 of 10 8/10

Is =CRITBINOM volatile?

Question 9 of 10 9/10

Does =CRITBINOM return a dynamic array?

Question 10 of 10 10/10

In =CRITBINOM, which is argument #3?

Click a question to see the answer.

1. Which formula is a valid example of =CRITBINOM?

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

Explanation: Correct example: =CRITBINOM(A2,A3,A4)

2. What is the type of argument “trials” in =CRITBINOM?

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

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

3. Which is the correct syntax of =CRITBINOM?

A. =CRITBINOM(trials,probability_s,alpha) ✓
B. =FORECAST(trials,probability_s,alpha)
C. =CRITBINOM(trials,probability_s,alpha, 0)
D. CRITBINOM(trials,probability_s,alpha)

Explanation: Correct syntax: =CRITBINOM(trials,probability_s,alpha)

4. What usually causes #NUM! in =CRITBINOM?

A. یکی از آرگومان‌ها غیرعددی است.
B. Requires add-in
C. If trials < 0, CRITBINOM returns the #NUM! error value. If probability_s is <= 0 or probability_s => 1, CRITBINOM returns the #NUM! error value. If alpha <= 0 or alpha => 1, CRITBINOM returns the #NUM! error value. ✓
D. Output is always a dynamic array

Explanation: If trials < 0, CRITBINOM returns the #NUM! error value. If probability_s is <= 0 or probability_s => 1, CRITBINOM returns the #NUM! error value. If alpha <= 0 or alpha => 1, CRITBINOM returns the #NUM! error value. — Fix: Allowed values

5. What is the type of argument “probability_s” in =CRITBINOM?

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

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

6. Is argument “alpha” required in =CRITBINOM?

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

Explanation: “alpha” is required.

7. Which statement about =CRITBINOM 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. If trials is not an integer, it is truncated.
C. Requires add-in
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.

8. Is =CRITBINOM volatile?

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

Explanation: CRITBINOM is not volatile.

9. Does =CRITBINOM return a dynamic array?

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

Explanation: CRITBINOM does not spill.

10. In =CRITBINOM, which is argument #3?

A. value
B. range
C. alpha ✓
D. trials

Explanation: Argument #3 is “alpha”.