Compatibility =EXPONDIST(x,lambda,cumulative)

Quiz =EXPONDIST — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

In =EXPONDIST, which is argument #3?

Question 3 of 15 3/15

What usually causes #NUM! in =EXPONDIST?

Question 4 of 15 4/15

Which function is related to =EXPONDIST?

Question 5 of 15 5/15

Which is the correct syntax of =EXPONDIST?

Question 6 of 15 6/15

How many arguments does =EXPONDIST have in total?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many optional arguments does =EXPONDIST have?

Question 9 of 15 9/15

In =EXPONDIST, which is argument #1?

Question 10 of 15 10/15

Which function is NOT related to =EXPONDIST?

Question 11 of 15 11/15

Does =EXPONDIST return a dynamic array?

Question 12 of 15 12/15

Is argument “x” required in =EXPONDIST?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which statement about =EXPONDIST is correct?

Click a question to see the answer.

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

A. Number
B. Text
C. Reference
D. Logical ✓

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

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

A. lambda
B. cumulative ✓
C. value
D. x

Explanation: Argument #3 is “cumulative”.

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

A. Select entire column for best performance
B. Volatile and recalculates every time
C. Only works in old versions
D. If x < 0, EXPONDIST returns the #NUM! error value. If lambda ≤ 0, EXPONDIST returns the #NUM! error value. ✓

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

4. Which function is related to =EXPONDIST?

A. DCOUNT
B. HYPERLINK
C. WEIBULL ✓
D. IMSIN

Explanation: “WEIBULL” is related to EXPONDIST.

5. Which is the correct syntax of =EXPONDIST?

A. =WEIBULL(x,lambda,cumulative)
B. EXPONDIST(x,lambda,cumulative)
C. =EXPONDIST(x,lambda,cumulative, 0)
D. =EXPONDIST(x,lambda,cumulative) ✓

Explanation: Correct syntax: =EXPONDIST(x,lambda,cumulative)

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

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

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

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

A. Volatile and recalculates every time
B. Requires add-in
C. Enter allowed values ✓
D. مقدار x یا lambda غیرعددی است.

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

8. How many optional arguments does =EXPONDIST have?

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

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

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

A. lambda
B. cumulative
C. criteria
D. x ✓

Explanation: Argument #1 is “x”.

10. Which function is NOT related to =EXPONDIST?

A. ROWS ✓
B. WEIBULL
C. NORMDIST
D. GAMMADIST

Explanation: “ROWS” is not related to EXPONDIST.

11. Does =EXPONDIST return a dynamic array?

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

Explanation: EXPONDIST does not spill.

12. Is argument “x” required in =EXPONDIST?

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

Explanation: “x” is required.

13. What is the fix for #VALUE! in =EXPONDIST?

A. مقدار x کوچک‌تر از ۰ است یا lambda کوچک‌تر یا مساوی ۰ است.
B. Text is always ignored
C. برای x و lambda مقدار عددی وارد کنید و ورودی‌های متنی را اصلاح کنید. ✓
D. Requires add-in

Explanation: If x or lambda is nonnumeric, EXPONDIST returns the #VALUE! error value. — Fix: برای x و lambda مقدار عددی وارد کنید و ورودی‌های متنی را اصلاح کنید.

14. What is the type of argument “x” in =EXPONDIST?

A. Array
B. Date
C. Number ✓
D. Text

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

15. Which statement about =EXPONDIST is correct?

A. The equation for the probability density function is:
B. Output is always a dynamic array
C. Select entire column for best performance
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.