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

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

Question 2 of 10 2/10

In =NEGBINOMDIST, which is argument #2?

Question 3 of 10 3/10

Which is the correct syntax of =NEGBINOMDIST?

Question 4 of 10 4/10

How many optional arguments does =NEGBINOMDIST have?

Question 5 of 10 5/10

Is =NEGBINOMDIST volatile?

Question 6 of 10 6/10

What usually causes #VALUE! in =NEGBINOMDIST?

Question 7 of 10 7/10

Which function is NOT related to =NEGBINOMDIST?

Question 8 of 10 8/10

Which function is related to =NEGBINOMDIST?

Question 9 of 10 9/10

Which statement about =NEGBINOMDIST is correct?

Question 10 of 10 10/10

In =NEGBINOMDIST, which is argument #1?

Click a question to see the answer.

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

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

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

2. In =NEGBINOMDIST, which is argument #2?

A. number_s ✓
B. criteria
C. lookup_value
D. number_f

Explanation: Argument #2 is “number_s”.

3. Which is the correct syntax of =NEGBINOMDIST?

A. =NEGBINOMDIST(number_f,number_s,probability_s) ✓
B. =FORECAST(number_f,number_s,probability_s)
C. =NEGBINOMDIST(number_f,number_s,probability_s, 0)
D. NEGBINOMDIST(number_f,number_s,probability_s)

Explanation: Correct syntax: =NEGBINOMDIST(number_f,number_s,probability_s)

4. How many optional arguments does =NEGBINOMDIST have?

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

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

5. Is =NEGBINOMDIST volatile?

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

Explanation: NEGBINOMDIST is not volatile.

6. What usually causes #VALUE! in =NEGBINOMDIST?

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

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

7. Which function is NOT related to =NEGBINOMDIST?

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

Explanation: “IMPORTTEXT” is not related to NEGBINOMDIST.

8. Which function is related to =NEGBINOMDIST?

A. FORECAST ✓
B. IMSQRT
C. ASINH
D. HYPERLINK

Explanation: “FORECAST” is related to NEGBINOMDIST.

9. Which statement about =NEGBINOMDIST 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. Requires add-in
C. Number_f and number_s are truncated to integers.
D. Volatile and recalculates every time

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.

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

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

Explanation: Argument #1 is “number_f”.