Statistical =LOGEST(known_y's, [known_x's], [const], [stats])

Quiz =LOGEST — 15 Questions

15 quiz questions about =LOGEST — test syntax, arguments, examples & errors!

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

← LOGEST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “known_x's” in =LOGEST?

Question 2 of 15 2/15

Which statement about =LOGEST is correct?

Question 3 of 15 3/15

What is the type of argument “known_y's” in =LOGEST?

Question 4 of 15 4/15

Which function is related to =LOGEST?

Question 5 of 15 5/15

What is the type of argument “stats” in =LOGEST?

Question 6 of 15 6/15

Is argument “const” required in =LOGEST?

Question 7 of 15 7/15

In =LOGEST, which is argument #2?

Question 8 of 15 8/15

Is argument “stats” required in =LOGEST?

Question 9 of 15 9/15

How many arguments does =LOGEST have in total?

Question 10 of 15 10/15

Is argument “known_y's” required in =LOGEST?

Question 11 of 15 11/15

How many optional arguments does =LOGEST have?

Question 12 of 15 12/15

Is =LOGEST volatile?

Question 13 of 15 13/15

Which category does =LOGEST belong to?

Question 14 of 15 14/15

Does =LOGEST return a dynamic array?

Question 15 of 15 15/15

Which function is NOT related to =LOGEST?

Click a question to see the answer.

1. What is the type of argument “known_x's” in =LOGEST?

A. Reference
B. Range ✓
C. Date
D. Text

Explanation: Type of “known_x's” is “Range”.

2. Which statement about =LOGEST is correct?

A. Volatile and recalculates every time
B. The more a plot of your data resembles an exponential curve, the better the calculated line will fit your data. Like LINEST, LOGEST returns an array of values that describes a relationship among the values, but LINEST fits a straight line to your data; LOGEST fits an exponential curve. For more information, see LINEST. ✓
C. Text is always ignored
D. You should note that the y-values predicted by the regression equation may not be valid if they are outside the range of y-values you used to determine the equation.

Explanation: Correct: The more a plot of your data resembles an exponential curve, the better the calculated line will fit your data. Like LINEST, LOGEST returns an array of values that describes a relationship among the values, but LINEST fits a straight line to your data; LOGEST fits an exponential curve. For more information, see LINEST.

3. What is the type of argument “known_y's” in =LOGEST?

A. Value
B. Mixed
C. Text
D. Range ✓

Explanation: Type of “known_y's” is “Range”.

4. Which function is related to =LOGEST?

A. EUROCONVERT
B. GROWTH ✓
C. DSTDEVP
D. RANK.EQ

Explanation: “GROWTH” is related to LOGEST.

5. What is the type of argument “stats” in =LOGEST?

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

Explanation: Type of “stats” is “Logical”.

6. Is argument “const” required in =LOGEST?

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

Explanation: “const” is optional.

7. In =LOGEST, which is argument #2?

A. lookup_value
B. known_y's
C. known_x's ✓
D. criteria

Explanation: Argument #2 is “known_x's”.

8. Is argument “stats” required in =LOGEST?

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

Explanation: “stats” is optional.

9. How many arguments does =LOGEST have in total?

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

Explanation: =LOGEST has 1 required, 3 optional (4 total).

10. Is argument “known_y's” required in =LOGEST?

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

Explanation: “known_y's” is required.

11. How many optional arguments does =LOGEST have?

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

Explanation: =LOGEST has 1 required, 3 optional (4 total).

12. Is =LOGEST volatile?

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

Explanation: LOGEST is not volatile.

13. Which category does =LOGEST belong to?

A. Statistical ✓
B. Financial
C. Compatibility
D. Math & Trig

Explanation: Category is “Statistical”.

14. Does =LOGEST return a dynamic array?

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

Explanation: LOGEST does not spill.

15. Which function is NOT related to =LOGEST?

A. LINEST
B. SUBSTITUTE ✓
C. GROWTH
D. RRI

Explanation: “SUBSTITUTE” is not related to LOGEST.