Compatibility =LOGNORMDIST(x,mean,standard_dev)

Quiz =LOGNORMDIST — 10 Questions

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

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

← LOGNORMDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =LOGNORMDIST?

Question 2 of 10 2/10

Which formula is a valid example of =LOGNORMDIST?

Question 3 of 10 3/10

How many required arguments does =LOGNORMDIST have?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which statement about =LOGNORMDIST is correct?

Question 6 of 10 6/10

Is argument “standard_dev” required in =LOGNORMDIST?

Question 7 of 10 7/10

How many arguments does =LOGNORMDIST have in total?

Question 8 of 10 8/10

What usually causes #VALUE! in =LOGNORMDIST?

Question 9 of 10 9/10

How many optional arguments does =LOGNORMDIST have?

Question 10 of 10 10/10

Which function is related to =LOGNORMDIST?

Click a question to see the answer.

1. What is the output type of =LOGNORMDIST?

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

Explanation: Output is “Number”.

2. Which formula is a valid example of =LOGNORMDIST?

A. =LOGNORMDIST(A2,A3,A4) ✓
B. LOGNORMDIST(A2,A3,A4)
C. =FORECAST(A2,A3,A4)
D. =LOGNORMDIST(A2,A3,A4, 0)

Explanation: Correct example: =LOGNORMDIST(A2,A3,A4)

3. How many required arguments does =LOGNORMDIST have?

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

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

4. What is the fix for #NUM! in =LOGNORMDIST?

A. Output is always a dynamic array
B. x>0 and stdev>0 ✓
C. Text is always ignored
D. یک یا چند آرگومان غیرعددی هستند.

Explanation: If x ≤ 0 or if Standard_dev ≤ 0, LOGNORMDIST returns the #NUM! error value. — Fix: x>0 and stdev>0

5. Which statement about =LOGNORMDIST is correct?

A. Text is always ignored
B. The equation for the lognormal cumulative distribution function is:
C. Requires add-in
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. Is argument “standard_dev” required in =LOGNORMDIST?

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

Explanation: “standard_dev” is required.

7. How many arguments does =LOGNORMDIST have in total?

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

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

8. What usually causes #VALUE! in =LOGNORMDIST?

A. Select entire column for best performance
B. If any argument is non-numeric, LOGNORMDIST returns the #VALUE! error value. ✓
C. Volatile and recalculates every time
D. Output is always a dynamic array

Explanation: If any argument is non-numeric, LOGNORMDIST returns the #VALUE! error value. — Fix: برای تمام آرگومان‌ها مقدار عددی وارد کنید.

9. How many optional arguments does =LOGNORMDIST have?

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

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

10. Which function is related to =LOGNORMDIST?

A. IMCSCH
B. NUMBERVALUE
C. PV
D. FORECAST ✓

Explanation: “FORECAST” is related to LOGNORMDIST.