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

What usually causes #VALUE! in =LOGINV?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which function is related to =LOGINV?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which formula is a valid example of =LOGINV?

Question 6 of 15 6/15

In =LOGINV, which is argument #2?

Question 7 of 15 7/15

Is =LOGINV volatile?

Question 8 of 15 8/15

Which category does =LOGINV belong to?

Question 9 of 15 9/15

Does =LOGINV return a dynamic array?

Question 10 of 15 10/15

Which use case fits =LOGINV?

Question 11 of 15 11/15

Is argument “standard_dev” required in =LOGINV?

Question 12 of 15 12/15

Which statement about =LOGINV is correct?

Question 13 of 15 13/15

Is argument “probability” required in =LOGINV?

Question 14 of 15 14/15

Is argument “mean” required in =LOGINV?

Question 15 of 15 15/15

In =LOGINV, which is argument #1?

Click a question to see the answer.

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

A. If any argument is nonnumeric, LOGINV returns the #VALUE! error value. ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Text is always ignored

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

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

A. Enter allowed values ✓
B. Text is always ignored
C. Volatile and recalculates every time
D. Only works in old versions

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

3. Which function is related to =LOGINV?

A. UNIQUE
B. FORECAST ✓
C. NUMBERVALUE
D. XOR

Explanation: “FORECAST” is related to LOGINV.

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

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

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

5. 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)

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

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

Explanation: Argument #2 is “mean”.

7. Is =LOGINV volatile?

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

Explanation: LOGINV is not volatile.

8. Which category does =LOGINV belong to?

A. Compatibility ✓
B. Financial
C. Date & Time
D. Logical

Explanation: Category is “Compatibility”.

9. Does =LOGINV return a dynamic array?

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

Explanation: LOGINV does not spill.

10. Which use case fits =LOGINV?

A. Loans & Installments
B. Investment Appraisal
C. Reporting ✓
D. Worksheet Info & Navigation

Explanation: Use case “Reporting” fits LOGINV.

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

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

Explanation: “standard_dev” is required.

12. Which statement about =LOGINV is correct?

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

13. Is argument “probability” required in =LOGINV?

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

Explanation: “probability” is required.

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

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

Explanation: “mean” is required.

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

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

Explanation: Argument #1 is “probability”.