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

How many optional arguments does =LOGINV have?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

How many arguments does =LOGINV have in total?

Question 4 of 10 4/10

What usually causes #NUM! in =LOGINV?

Question 5 of 10 5/10

Which formula is a valid example of =LOGINV?

Question 6 of 10 6/10

What usually causes #VALUE! in =LOGINV?

Question 7 of 10 7/10

Which use case fits =LOGINV?

Question 8 of 10 8/10

Which statement about =LOGINV is correct?

Question 9 of 10 9/10

In =LOGINV, which is argument #3?

Question 10 of 10 10/10

Is argument “standard_dev” required in =LOGINV?

Click a question to see the answer.

1. How many optional arguments does =LOGINV have?

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

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

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

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

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

3. How many arguments does =LOGINV have in total?

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

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

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

A. Select entire column for best performance
B. یک یا چند آرگومان غیرعددی هستند.
C. Only works in old versions
D. If probability <= 0 or probability >= 1, LOGINV returns the #NUM! error value. If standard_dev <= 0, LOGINV returns the #NUM! error value. ✓

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 formula is a valid example of =LOGINV?

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

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

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

A. Select entire column for best performance
B. Only works in old versions
C. If any argument is nonnumeric, LOGINV returns the #VALUE! error value. ✓
D. مقدار probability کوچک‌تر یا مساوی صفر یا بزرگ‌تر یا مساوی ۱ است، یا مقدار standard_dev کوچک‌تر یا مساوی صفر است.

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

7. Which use case fits =LOGINV?

A. Advanced Formulas
B. Workdays & Due Dates
C. Depreciation
D. Reporting ✓

Explanation: Use case “Reporting” fits LOGINV.

8. Which statement about =LOGINV is correct?

A. 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. ✓
B. Requires add-in
C. Output is always a dynamic array
D. Select entire column for best performance

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. In =LOGINV, which is argument #3?

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

Explanation: Argument #3 is “standard_dev”.

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

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

Explanation: “standard_dev” is required.