Compatibility =NEGBINOMDIST(number_f,number_s,probability_s)

Quiz =NEGBINOMDIST — 10 Questions

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

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

← NEGBINOMDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =NEGBINOMDIST, which is argument #3?

Question 2 of 10 2/10

What is the type of argument “number_s” in =NEGBINOMDIST?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Is argument “number_f” required in =NEGBINOMDIST?

Question 5 of 10 5/10

Which function is NOT related to =NEGBINOMDIST?

Question 6 of 10 6/10

Which function is related to =NEGBINOMDIST?

Question 7 of 10 7/10

Is =NEGBINOMDIST volatile?

Question 8 of 10 8/10

Which category does =NEGBINOMDIST belong to?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

How many optional arguments does =NEGBINOMDIST have?

Click a question to see the answer.

1. In =NEGBINOMDIST, which is argument #3?

A. number_f
B. probability_s ✓
C. value
D. number_s

Explanation: Argument #3 is “probability_s”.

2. What is the type of argument “number_s” in =NEGBINOMDIST?

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

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

3. What is the fix for #NUM! in =NEGBINOMDIST?

A. Output is always a dynamic array
B. یک یا چند آرگومان غیرعددی است.
C. Requires add-in
D. Enter a value between 0 and 1 ✓

Explanation: If probability_s < 0 or if probability > 1, NEGBINOMDIST returns the #NUM! error value. If number_f < 0 or number_s < 1, NEGBINOMDIST returns the #NUM! error value. — Fix: Enter a value between 0 and 1

4. Is argument “number_f” required in =NEGBINOMDIST?

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

Explanation: “number_f” is required.

5. Which function is NOT related to =NEGBINOMDIST?

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

Explanation: “SECOND” is not related to NEGBINOMDIST.

6. Which function is related to =NEGBINOMDIST?

A. SKEW.P
B. ISBLANK
C. CSC
D. FORECAST ✓

Explanation: “FORECAST” is related to NEGBINOMDIST.

7. Is =NEGBINOMDIST volatile?

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

Explanation: NEGBINOMDIST is not volatile.

8. Which category does =NEGBINOMDIST belong to?

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

Explanation: Category is “Compatibility”.

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. Only works in old versions
D. مطمئن شوید همه آرگومان‌ها عددی هستند؛ سلول‌های متنی یا خالی را اصلاح کنید. ✓

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

10. How many optional arguments does =NEGBINOMDIST have?

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

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