Compatibility =LOGNORMDIST(x,mean,standard_dev)

Quiz =LOGNORMDIST — 15 Questions

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

Question 1 of 15 1/15

What is the output type of =LOGNORMDIST?

Question 2 of 15 2/15

How many arguments does =LOGNORMDIST have in total?

Question 3 of 15 3/15

What usually causes #VALUE! in =LOGNORMDIST?

Question 4 of 15 4/15

Which function is NOT related to =LOGNORMDIST?

Question 5 of 15 5/15

Since which Excel version is =LOGNORMDIST available?

Question 6 of 15 6/15

Which statement about =LOGNORMDIST is correct?

Question 7 of 15 7/15

Which use case fits =LOGNORMDIST?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is argument “mean” required in =LOGNORMDIST?

Question 10 of 15 10/15

In =LOGNORMDIST, which is argument #3?

Question 11 of 15 11/15

Does =LOGNORMDIST return a dynamic array?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which is the correct syntax of =LOGNORMDIST?

Question 14 of 15 14/15

What is the type of argument “mean” in =LOGNORMDIST?

Question 15 of 15 15/15

Is argument “x” required in =LOGNORMDIST?

Click a question to see the answer.

1. What is the output type of =LOGNORMDIST?

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

Explanation: Output is “Number”.

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

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

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

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

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

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

4. Which function is NOT related to =LOGNORMDIST?

A. MODE
B. MEDIAN ✓
C. PERCENTILE
D. FORECAST

Explanation: “MEDIAN” is not related to LOGNORMDIST.

5. Since which Excel version is =LOGNORMDIST available?

A. Excel 2019
B. Excel 2007 (Compatibility) ✓
C. All versions
D. Excel 365

Explanation: Version: “Excel 2007 (Compatibility)”.

6. Which statement about =LOGNORMDIST is correct?

A. The equation for the lognormal cumulative distribution function is:
B. Output is always a dynamic array
C. Only works in old versions
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.

7. Which use case fits =LOGNORMDIST?

A. Depreciation
B. Comparation
C. Reporting ✓
D. Advanced Formulas

Explanation: Use case “Reporting” fits LOGNORMDIST.

8. What is the fix for #VALUE! in =LOGNORMDIST?

A. برای تمام آرگومان‌ها مقدار عددی وارد کنید. ✓
B. Volatile and recalculates every time
C. Only works in old versions
D. مقدار x کوچک‌تر یا مساوی صفر یا مقدار Standard_dev کوچک‌تر یا مساوی صفر است.

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

9. Is argument “mean” required in =LOGNORMDIST?

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

Explanation: “mean” is required.

10. In =LOGNORMDIST, which is argument #3?

A. x
B. standard_dev ✓
C. value
D. range

Explanation: Argument #3 is “standard_dev”.

11. Does =LOGNORMDIST return a dynamic array?

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

Explanation: LOGNORMDIST does not spill.

12. What is the type of argument “x” in =LOGNORMDIST?

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

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

13. Which is the correct syntax of =LOGNORMDIST?

A. =FORECAST(x,mean,standard_dev)
B. =LOGNORMDIST(x,mean,standard_dev) ✓
C. =LOGNORMDIST(x,mean,standard_dev, 0)
D. LOGNORMDIST(x,mean,standard_dev)

Explanation: Correct syntax: =LOGNORMDIST(x,mean,standard_dev)

14. What is the type of argument “mean” in =LOGNORMDIST?

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

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

15. Is argument “x” required in =LOGNORMDIST?

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

Explanation: “x” is required.