Compatibility =EXPONDIST(x,lambda,cumulative)

Quiz =EXPONDIST — 10 Questions

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

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

← EXPONDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =EXPONDIST belong to?

Question 2 of 10 2/10

In =EXPONDIST, which is argument #1?

Question 3 of 10 3/10

Which function is NOT related to =EXPONDIST?

Question 4 of 10 4/10

Is argument “lambda” required in =EXPONDIST?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Does =EXPONDIST return a dynamic array?

Question 7 of 10 7/10

Which use case fits =EXPONDIST?

Question 8 of 10 8/10

Is argument “cumulative” required in =EXPONDIST?

Question 9 of 10 9/10

Which statement about =EXPONDIST is correct?

Question 10 of 10 10/10

Which formula is a valid example of =EXPONDIST?

Click a question to see the answer.

1. Which category does =EXPONDIST belong to?

A. Text
B. Financial
C. Engineering
D. Compatibility ✓

Explanation: Category is “Compatibility”.

2. In =EXPONDIST, which is argument #1?

A. range
B. criteria
C. x ✓
D. lookup_value

Explanation: Argument #1 is “x”.

3. Which function is NOT related to =EXPONDIST?

A. MODE.SNGL ✓
B. WEIBULL
C. NORMDIST
D. GAMMADIST

Explanation: “MODE.SNGL” is not related to EXPONDIST.

4. Is argument “lambda” required in =EXPONDIST?

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

Explanation: “lambda” is required.

5. What is the fix for #NUM! in =EXPONDIST?

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

Explanation: If x < 0, EXPONDIST returns the #NUM! error value. If lambda ≤ 0, EXPONDIST returns the #NUM! error value. — Fix: Enter allowed values

6. Does =EXPONDIST return a dynamic array?

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

Explanation: EXPONDIST does not spill.

7. Which use case fits =EXPONDIST?

A. Error Handling
B. Descriptive Statistics ✓
C. Depreciation
D. Comparation

Explanation: Use case “Descriptive Statistics” fits EXPONDIST.

8. Is argument “cumulative” required in =EXPONDIST?

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

Explanation: “cumulative” is required.

9. Which statement about =EXPONDIST is correct?

A. The equation for the cumulative distribution function is:
B. Volatile and recalculates every time
C. 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. ✓
D. Requires add-in

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. Which formula is a valid example of =EXPONDIST?

A. EXPONDIST(A2,A3,TRUE)
B. =EXPONDIST(A2,A3,TRUE) ✓
C. =EXPONDIST(A2,A3,TRUE, 0)
D. =WEIBULL(A2,A3,TRUE)

Explanation: Correct example: =EXPONDIST(A2,A3,TRUE)