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

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

Question 2 of 15 2/15

Which statement about =CRITBINOM is correct?

Question 3 of 15 3/15

Is =CRITBINOM volatile?

Question 4 of 15 4/15

Which use case fits =CRITBINOM?

Question 5 of 15 5/15

In =CRITBINOM, which is argument #3?

Question 6 of 15 6/15

Is argument “probability_s” required in =CRITBINOM?

Question 7 of 15 7/15

How many optional arguments does =CRITBINOM have?

Question 8 of 15 8/15

Which function is NOT related to =CRITBINOM?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

What is the output type of =CRITBINOM?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Which category does =CRITBINOM belong to?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many required arguments does =CRITBINOM have?

Question 15 of 15 15/15

What usually causes #NUM! in =CRITBINOM?

Click a question to see the answer.

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

A. Output is always a dynamic array
B. Only works in old versions
C. Allowed values ✓
D. Requires add-in

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 statement about =CRITBINOM is correct?

A. Requires add-in
B. Volatile and recalculates every time
C. If trials is not an integer, it is truncated.
D. 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. ✓

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 =CRITBINOM volatile?

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

Explanation: CRITBINOM is not volatile.

4. Which use case fits =CRITBINOM?

A. Financial Calculations
B. Ranking & Top N
C. Loans & Installments
D. Reporting ✓

Explanation: Use case “Reporting” fits CRITBINOM.

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

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

Explanation: Argument #3 is “alpha”.

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

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

Explanation: “probability_s” is required.

7. How many optional arguments does =CRITBINOM have?

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

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

8. Which function is NOT related to =CRITBINOM?

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

Explanation: “DDB” is not related to CRITBINOM.

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

A. مقدار trials منفی است، احتمال موفقیت خارج از بازه (۰، ۱) است، یا alpha خارج از بازه (۰، ۱) است.
B. Text is always ignored
C. Output is always a dynamic array
D. برای همه آرگومان‌ها مقدار عددی وارد کنید و مطمئن شوید سلول‌های مرجع متن نیستند. ✓

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

10. What is the output type of =CRITBINOM?

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

Explanation: Output is “Number”.

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

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

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

12. Which category does =CRITBINOM belong to?

A. Database
B. Math & Trig
C. Engineering
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

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

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

14. How many required arguments does =CRITBINOM have?

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

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

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

A. Text is always ignored
B. 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. ✓
C. Output is always a dynamic array
D. یکی از آرگومان‌ها غیرعددی است.