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

Which use case fits =LOGNORMDIST?

Question 2 of 10 2/10

What is the output type of =LOGNORMDIST?

Question 3 of 10 3/10

Is argument “x” required in =LOGNORMDIST?

Question 4 of 10 4/10

Is argument “mean” required in =LOGNORMDIST?

Question 5 of 10 5/10

Which function is related to =LOGNORMDIST?

Question 6 of 10 6/10

Which statement about =LOGNORMDIST is correct?

Question 7 of 10 7/10

How many arguments does =LOGNORMDIST have in total?

Question 8 of 10 8/10

Since which Excel version is =LOGNORMDIST available?

Question 9 of 10 9/10

Is argument “standard_dev” required in =LOGNORMDIST?

Question 10 of 10 10/10

Which category does =LOGNORMDIST belong to?

Click a question to see the answer.

1. Which use case fits =LOGNORMDIST?

A. Rounding & Numeric
B. Reporting ✓
C. Securities & Bonds
D. Data Cleaning

Explanation: Use case “Reporting” fits LOGNORMDIST.

2. What is the output type of =LOGNORMDIST?

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

Explanation: Output is “Number”.

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

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

Explanation: “x” is required.

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

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

Explanation: “mean” is required.

5. Which function is related to =LOGNORMDIST?

A. RTD
B. T.DIST
C. TRUE
D. FORECAST ✓

Explanation: “FORECAST” is related to LOGNORMDIST.

6. Which statement about =LOGNORMDIST is correct?

A. Only works in old versions
B. Select entire column for best performance
C. Volatile and recalculates every time
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. How many arguments does =LOGNORMDIST have in total?

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

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

8. Since which Excel version is =LOGNORMDIST available?

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

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

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

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

Explanation: “standard_dev” is required.

10. Which category does =LOGNORMDIST belong to?

A. Compatibility ✓
B. Logical
C. Statistical
D. Web

Explanation: Category is “Compatibility”.