Compatibility =LOGINV(probability, mean, standard_dev)

Quiz =LOGINV — 15 Questions

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

Question 1 of 15 1/15

How many optional arguments does =LOGINV have?

Question 2 of 15 2/15

What usually causes #VALUE! in =LOGINV?

Question 3 of 15 3/15

Which function is NOT related to =LOGINV?

Question 4 of 15 4/15

How many required arguments does =LOGINV have?

Question 5 of 15 5/15

Is argument “standard_dev” required in =LOGINV?

Question 6 of 15 6/15

In =LOGINV, which is argument #1?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which statement about =LOGINV is correct?

Question 9 of 15 9/15

Which use case fits =LOGINV?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

In =LOGINV, which is argument #3?

Question 12 of 15 12/15

Which formula is a valid example of =LOGINV?

Question 13 of 15 13/15

What is the output type of =LOGINV?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

In =LOGINV, which is argument #2?

Click a question to see the answer.

1. How many optional arguments does =LOGINV have?

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

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

2. What usually causes #VALUE! in =LOGINV?

A. Requires add-in
B. Select entire column for best performance
C. If any argument is nonnumeric, LOGINV returns the #VALUE! error value. ✓
D. Output is always a dynamic array

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

3. Which function is NOT related to =LOGINV?

A. MODE
B. FORECAST
C. STDEV.S ✓
D. PERCENTILE

Explanation: “STDEV.S” is not related to LOGINV.

4. How many required arguments does =LOGINV have?

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

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

5. Is argument “standard_dev” required in =LOGINV?

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

Explanation: “standard_dev” is required.

6. In =LOGINV, which is argument #1?

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

Explanation: Argument #1 is “probability”.

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

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

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

8. Which statement about =LOGINV is correct?

A. Text is always ignored
B. Only works in old versions
C. The inverse of the lognormal distribution function is:
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.

9. Which use case fits =LOGINV?

A. Dynamic Ranges & Dashboards
B. Conditional Logic
C. Reporting ✓
D. Ranking & Top N

Explanation: Use case “Reporting” fits LOGINV.

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

A. Only works in old versions
B. Output is always a dynamic array
C. برای تمام آرگومان‌ها مقدار عددی وارد کنید و بررسی کنید سلول‌های مرجع خالی یا متنی نباشند. ✓
D. Text is always ignored

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

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

Explanation: Argument #3 is “standard_dev”.

12. Which formula is a valid example of =LOGINV?

A. =LOGINV(A2, A3, A4) ✓
B. =LOGINV(A2, A3, A4, 0)
C. LOGINV(A2, A3, A4)
D. =FORECAST(A2, A3, A4)

Explanation: Correct example: =LOGINV(A2, A3, A4)

13. What is the output type of =LOGINV?

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

Explanation: Output is “Number”.

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

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

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

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

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

Explanation: Argument #2 is “mean”.