Statistical =LOGNORM.INV(probability, mean, standard_dev)

Quiz =LOGNORM.INV — 15 Questions

15 quiz questions about =LOGNORM.INV — test syntax, arguments, examples & errors!

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

← LOGNORM.INV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Which formula is a valid example of =LOGNORM.INV?

Question 3 of 15 3/15

What is the type of argument “probability” in =LOGNORM.INV?

Question 4 of 15 4/15

What is the type of argument “mean” in =LOGNORM.INV?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Does =LOGNORM.INV return a dynamic array?

Question 7 of 15 7/15

Which category does =LOGNORM.INV belong to?

Question 8 of 15 8/15

Is =LOGNORM.INV volatile?

Question 9 of 15 9/15

Since which Excel version is =LOGNORM.INV available?

Question 10 of 15 10/15

How many arguments does =LOGNORM.INV have in total?

Question 11 of 15 11/15

Which use case fits =LOGNORM.INV?

Question 12 of 15 12/15

How many optional arguments does =LOGNORM.INV have?

Question 13 of 15 13/15

Is argument “probability” required in =LOGNORM.INV?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

What is the output type of =LOGNORM.INV?

Click a question to see the answer.

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

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

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

2. Which formula is a valid example of =LOGNORM.INV?

A. =LOGNORM.INV(A2, A3, A4, 0)
B. =LOGNORM.INV(A2, A3, A4) ✓
C. =RAND(A2, A3, A4)
D. LOGNORM.INV(A2, A3, A4)

Explanation: Correct example: =LOGNORM.INV(A2, A3, A4)

3. What is the type of argument “probability” in =LOGNORM.INV?

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

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

4. What is the type of argument “mean” in =LOGNORM.INV?

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

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

5. In =LOGNORM.INV, which is argument #2?

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

Explanation: Argument #2 is “mean”.

6. Does =LOGNORM.INV return a dynamic array?

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

Explanation: LOGNORM.INV does not spill.

7. Which category does =LOGNORM.INV belong to?

A. Financial
B. Text
C. Logical
D. Statistical ✓

Explanation: Category is “Statistical”.

8. Is =LOGNORM.INV volatile?

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

Explanation: LOGNORM.INV is not volatile.

9. Since which Excel version is =LOGNORM.INV available?

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

Explanation: Version: “Excel 2010”.

10. How many arguments does =LOGNORM.INV have in total?

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

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

11. Which use case fits =LOGNORM.INV?

A. Probability & Hypothesis Testing ✓
B. Dynamic Ranges & Dashboards
C. Numbering & Sample Data
D. Lookup & Retrieval

Explanation: Use case “Probability & Hypothesis Testing” fits LOGNORM.INV.

12. How many optional arguments does =LOGNORM.INV have?

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

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

13. Is argument “probability” required in =LOGNORM.INV?

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

Explanation: “probability” is required.

14. What usually causes #NUM! in =LOGNORM.INV?

A. Volatile and recalculates every time
B. یک یا چند آرگومان غیرعددی هستند.
C. If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value. If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value. ✓
D. Output is always a dynamic array

Explanation: If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value. If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value. — Fix: Correct the input value

15. What is the output type of =LOGNORM.INV?

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

Explanation: Output is “Number”.