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

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

Question 2 of 10 2/10

Which function is NOT related to =CRITBINOM?

Question 3 of 10 3/10

How many optional arguments does =CRITBINOM have?

Question 4 of 10 4/10

Which statement about =CRITBINOM is correct?

Question 5 of 10 5/10

Is argument “trials” required in =CRITBINOM?

Question 6 of 10 6/10

Does =CRITBINOM return a dynamic array?

Question 7 of 10 7/10

In =CRITBINOM, which is argument #3?

Question 8 of 10 8/10

Which formula is a valid example of =CRITBINOM?

Question 9 of 10 9/10

What usually causes #VALUE! in =CRITBINOM?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

A. Text is always ignored
B. Select entire column for best performance
C. Allowed values ✓
D. Only works in old versions

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

2. Which function is NOT related to =CRITBINOM?

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

Explanation: “BITLSHIFT” is not related to CRITBINOM.

3. How many optional arguments does =CRITBINOM have?

A. 2
B. 1
C. 3
D. 0 ✓

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

4. Which statement about =CRITBINOM is correct?

A. Select entire column for best performance
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. ✓
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.

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

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

Explanation: “trials” is required.

6. Does =CRITBINOM return a dynamic array?

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

Explanation: CRITBINOM does not spill.

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

A. alpha ✓
B. probability_s
C. criteria
D. range

Explanation: Argument #3 is “alpha”.

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

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

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

9. What usually causes #VALUE! in =CRITBINOM?

A. If any argument is nonnumeric, CRITBINOM returns the #VALUE! error value. ✓
B. Requires add-in
C. Only works in old versions
D. Output is always a dynamic array

Explanation: If any argument is nonnumeric, CRITBINOM returns the #VALUE! error value. — Fix: برای همه آرگومان‌ها مقدار عددی وارد کنید و مطمئن شوید سلول‌های مرجع متن نیستند.

10. What is the type of argument “alpha” in =CRITBINOM?

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

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