Statistical =LOGNORM.DIST(x,mean,standard_dev,cumulative)

Quiz =LOGNORM.DIST — 10 Questions

10 quiz questions about =LOGNORM.DIST — test syntax, arguments, examples & errors!

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

← LOGNORM.DIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =LOGNORM.DIST, which is argument #2?

Question 2 of 10 2/10

What is the fix for #VALUE! in =LOGNORM.DIST?

Question 3 of 10 3/10

How many optional arguments does =LOGNORM.DIST have?

Question 4 of 10 4/10

Which function is NOT related to =LOGNORM.DIST?

Question 5 of 10 5/10

What usually causes #NUM! in =LOGNORM.DIST?

Question 6 of 10 6/10

Is =LOGNORM.DIST volatile?

Question 7 of 10 7/10

What is the type of argument “standard_dev” in =LOGNORM.DIST?

Question 8 of 10 8/10

Does =LOGNORM.DIST return a dynamic array?

Question 9 of 10 9/10

Which statement about =LOGNORM.DIST is correct?

Question 10 of 10 10/10

What is the output type of =LOGNORM.DIST?

Click a question to see the answer.

1. In =LOGNORM.DIST, which is argument #2?

A. cumulative
B. value
C. mean ✓
D. standard_dev

Explanation: Argument #2 is “mean”.

2. What is the fix for #VALUE! in =LOGNORM.DIST?

A. برای تمام آرگومان‌ها مقدار عددی وارد کنید. ✓
B. مقدار x کوچک‌تر یا مساوی صفر یا مقدار standard_dev کوچک‌تر یا مساوی صفر است.
C. Requires add-in
D. Text is always ignored

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

3. How many optional arguments does =LOGNORM.DIST have?

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

Explanation: =LOGNORM.DIST has 4 required, 0 optional (4 total).

4. Which function is NOT related to =LOGNORM.DIST?

A. LOGNORM.DIST_X
B. LOGNORM-INV
C. NORM-DIST
D. TRIMMEAN ✓

Explanation: “TRIMMEAN” is not related to LOGNORM.DIST.

5. What usually causes #NUM! in =LOGNORM.DIST?

A. If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Select entire column for best performance
D. Only works in old versions

Explanation: If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value. — Fix: Correct the input value

6. Is =LOGNORM.DIST volatile?

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

Explanation: LOGNORM.DIST is not volatile.

7. What is the type of argument “standard_dev” in =LOGNORM.DIST?

A. Value
B. Mixed
C. Reference
D. Number ✓

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

8. Does =LOGNORM.DIST return a dynamic array?

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

Explanation: LOGNORM.DIST does not spill.

9. Which statement about =LOGNORM.DIST is correct?

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. The equation for the lognormal cumulative distribution function is: LOGNORM.DIST(x,µ,o) = NORM.S.DIST(1n(x)-µ / o) ✓
D. Requires add-in

Explanation: Correct: The equation for the lognormal cumulative distribution function is: LOGNORM.DIST(x,µ,o) = NORM.S.DIST(1n(x)-µ / o)

10. What is the output type of =LOGNORM.DIST?

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

Explanation: Output is “Statistical”.