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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Which function is NOT related to =NEGBINOMDIST?
Explanation: “TREND” is not related to NEGBINOMDIST.
Question 2 of 10
2/10
How many optional arguments does =NEGBINOMDIST have?
Explanation: =NEGBINOMDIST has 3 required, 0 optional (3 total).
Question 3 of 10
3/10
In =NEGBINOMDIST, which is argument #3?
Explanation: Argument #3 is “probability_s”.
Question 4 of 10
4/10
Which is the correct syntax of =NEGBINOMDIST?
Explanation: Correct syntax: =NEGBINOMDIST(number_f,number_s,probability_s)
Question 5 of 10
5/10
What is the output type of =NEGBINOMDIST?
Explanation: Output is “Number”.
Question 6 of 10
6/10
Which statement about =NEGBINOMDIST is correct?
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.
Question 7 of 10
7/10
Which use case fits =NEGBINOMDIST?
Explanation: Use case “Reporting” fits NEGBINOMDIST.
Question 8 of 10
8/10
Which function is related to =NEGBINOMDIST?
Explanation: “FORECAST” is related to NEGBINOMDIST.
Question 9 of 10
9/10
What is the type of argument “number_s” in =NEGBINOMDIST?
Explanation: Type of “number_s” is “Number”.
Question 10 of 10
10/10
Which category does =NEGBINOMDIST belong to?
Explanation: Category is “Compatibility”.