Compatibility =LOGINV(probability, mean, standard_dev)

Quiz =LOGINV — 10 Questions

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

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

← LOGINV ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =LOGINV return a dynamic array?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =LOGINV, which is argument #2?

Question 4 of 10 4/10

What usually causes #NUM! in =LOGINV?

Question 5 of 10 5/10

Which use case fits =LOGINV?

Question 6 of 10 6/10

Is argument “mean” required in =LOGINV?

Question 7 of 10 7/10

Which is the correct syntax of =LOGINV?

Question 8 of 10 8/10

What is the output type of =LOGINV?

Question 9 of 10 9/10

Which function is NOT related to =LOGINV?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Does =LOGINV return a dynamic array?

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

Explanation: LOGINV does not spill.

2. What is the type of argument “mean” in =LOGINV?

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

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

3. In =LOGINV, which is argument #2?

A. lookup_value
B. mean ✓
C. standard_dev
D. range

Explanation: Argument #2 is “mean”.

4. What usually causes #NUM! in =LOGINV?

A. If probability <= 0 or probability >= 1, LOGINV returns the #NUM! error value. If standard_dev <= 0, LOGINV returns the #NUM! error value. ✓
B. یک یا چند آرگومان غیرعددی هستند.
C. Only works in old versions
D. Output is always a dynamic array

Explanation: If probability <= 0 or probability >= 1, LOGINV returns the #NUM! error value. If standard_dev <= 0, LOGINV returns the #NUM! error value. — Fix: Enter allowed values

5. Which use case fits =LOGINV?

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

Explanation: Use case “Reporting” fits LOGINV.

6. Is argument “mean” required in =LOGINV?

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

Explanation: “mean” is required.

7. Which is the correct syntax of =LOGINV?

A. LOGINV(probability, mean, standard_dev)
B. =FORECAST(probability, mean, standard_dev)
C. =LOGINV(probability, mean, standard_dev, 0)
D. =LOGINV(probability, mean, standard_dev) ✓

Explanation: Correct syntax: =LOGINV(probability, mean, standard_dev)

8. What is the output type of =LOGINV?

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

Explanation: Output is “Number”.

9. Which function is NOT related to =LOGINV?

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

Explanation: “BAHTTEXT” is not related to LOGINV.

10. What is the fix for #NUM! in =LOGINV?

A. Volatile and recalculates every time
B. یک یا چند آرگومان غیرعددی هستند.
C. Requires add-in
D. Enter allowed values ✓

Explanation: If probability <= 0 or probability >= 1, LOGINV returns the #NUM! error value. If standard_dev <= 0, LOGINV returns the #NUM! error value. — Fix: Enter allowed values