Compatibility =CRITBINOM(trials,probability_s,alpha)

Quiz =CRITBINOM — 15 Questions

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

Question 1 of 15 1/15

Which function is NOT related to =CRITBINOM?

Question 2 of 15 2/15

How many required arguments does =CRITBINOM have?

Question 3 of 15 3/15

Is =CRITBINOM volatile?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Is argument “alpha” required in =CRITBINOM?

Question 6 of 15 6/15

In =CRITBINOM, which is argument #2?

Question 7 of 15 7/15

Which statement about =CRITBINOM is correct?

Question 8 of 15 8/15

What usually causes #NUM! in =CRITBINOM?

Question 9 of 15 9/15

Which function is related to =CRITBINOM?

Question 10 of 15 10/15

What usually causes #VALUE! in =CRITBINOM?

Question 11 of 15 11/15

Since which Excel version is =CRITBINOM available?

Question 12 of 15 12/15

Is argument “probability_s” required in =CRITBINOM?

Question 13 of 15 13/15

How many arguments does =CRITBINOM have in total?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which function is NOT related to =CRITBINOM?

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

Explanation: “MMULT” is not related to CRITBINOM.

2. How many required arguments does =CRITBINOM have?

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

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

3. Is =CRITBINOM volatile?

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

Explanation: CRITBINOM is not volatile.

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

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

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

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

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

Explanation: “alpha” is required.

6. In =CRITBINOM, which is argument #2?

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

Explanation: Argument #2 is “probability_s”.

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. Only works in old versions
C. If trials is not an integer, it is truncated.
D. Select entire column for best performance

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. What usually causes #NUM! in =CRITBINOM?

A. Only works in old versions
B. یکی از آرگومان‌ها غیرعددی است.
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. Select entire column for best performance

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

9. Which function is related to =CRITBINOM?

A. GAMMAINV
B. TRIMMEAN
C. TINV
D. FORECAST ✓

Explanation: “FORECAST” is related to CRITBINOM.

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

A. مقدار trials منفی است، احتمال موفقیت خارج از بازه (۰، ۱) است، یا alpha خارج از بازه (۰، ۱) است.
B. Requires add-in
C. Select entire column for best performance
D. If any argument is nonnumeric, CRITBINOM returns the #VALUE! error value. ✓

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

11. Since which Excel version is =CRITBINOM available?

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

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

12. Is argument “probability_s” required in =CRITBINOM?

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

Explanation: “probability_s” is required.

13. How many arguments does =CRITBINOM have in total?

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

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

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

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

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

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

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

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