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

Since which Excel version is =CRITBINOM available?

Question 2 of 10 2/10

Which statement about =CRITBINOM is correct?

Question 3 of 10 3/10

Is argument “trials” required in =CRITBINOM?

Question 4 of 10 4/10

Is =CRITBINOM volatile?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

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

Question 7 of 10 7/10

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

Question 8 of 10 8/10

In =CRITBINOM, which is argument #1?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

In =CRITBINOM, which is argument #3?

Click a question to see the answer.

1. Since which Excel version is =CRITBINOM available?

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

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

2. Which statement about =CRITBINOM is correct?

A. Requires add-in
B. Output is always a dynamic array
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. 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.

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

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

Explanation: “trials” is required.

4. Is =CRITBINOM volatile?

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

Explanation: CRITBINOM is not volatile.

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

A. Allowed values ✓
B. Output is always a dynamic array
C. Text is always ignored
D. Volatile and recalculates every time

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

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

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

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

7. What is the fix for #VALUE! in =CRITBINOM?

A. Select entire column for best performance
B. Requires add-in
C. برای همه آرگومان‌ها مقدار عددی وارد کنید و مطمئن شوید سلول‌های مرجع متن نیستند. ✓
D. Output is always a dynamic array

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

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

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

Explanation: Argument #1 is “trials”.

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

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

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

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

A. criteria
B. alpha ✓
C. trials
D. lookup_value

Explanation: Argument #3 is “alpha”.