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

What is the type of argument “cumulative” in =EXPONDIST?

Question 3 of 10 3/10

How many optional arguments does =EXPONDIST have?

Question 4 of 10 4/10

Is argument “lambda” required in =EXPONDIST?

Question 5 of 10 5/10

Which statement about =EXPONDIST is correct?

Question 6 of 10 6/10

How many arguments does =EXPONDIST have in total?

Question 7 of 10 7/10

In =EXPONDIST, which is argument #2?

Question 8 of 10 8/10

Which function is related to =EXPONDIST?

Question 9 of 10 9/10

Which formula is a valid example of =EXPONDIST?

Question 10 of 10 10/10

What usually causes #NUM! in =EXPONDIST?

Click a question to see the answer.

1. Which category does =EXPONDIST belong to?

A. Compatibility ✓
B. Cube
C. Logical
D. Financial

Explanation: Category is “Compatibility”.

2. What is the type of argument “cumulative” in =EXPONDIST?

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

Explanation: Type of “cumulative” is “Logical”.

3. How many optional arguments does =EXPONDIST have?

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

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

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

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

Explanation: “lambda” is required.

5. Which statement about =EXPONDIST is correct?

A. Requires add-in
B. The equation for the cumulative distribution function is:
C. Output is always a dynamic array
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.

6. How many arguments does =EXPONDIST have in total?

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

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

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

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

Explanation: Argument #2 is “lambda”.

8. Which function is related to =EXPONDIST?

A. RANK
B. RANDARRAY
C. WEIBULL ✓
D. TRIM

Explanation: “WEIBULL” is related to EXPONDIST.

9. Which formula is a valid example of =EXPONDIST?

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

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

10. What usually causes #NUM! in =EXPONDIST?

A. If x < 0, EXPONDIST returns the #NUM! error value. If lambda ≤ 0, EXPONDIST returns the #NUM! error value. ✓
B. Only works in old versions
C. Text is always ignored
D. Select entire column for best performance

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