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

Quiz =LINEST — 10 Questions

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

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

← LINEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the fix for #DIV/0! in =LINEST?

Question 2 of 10 2/10

How many required arguments does =LINEST have?

Question 3 of 10 3/10

What usually causes #DIV/0! in =LINEST?

Question 4 of 10 4/10

Which use case fits =LINEST?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which function is NOT related to =LINEST?

Question 7 of 10 7/10

Is argument “const” required in =LINEST?

Question 8 of 10 8/10

What is the output type of =LINEST?

Question 9 of 10 9/10

Which statement about =LINEST is correct?

Question 10 of 10 10/10

In =LINEST, which is argument #2?

Click a question to see the answer.

1. What is the fix for #DIV/0! in =LINEST?

A. Only works in old versions
B. Volatile and recalculates every time
C. اگر با SLOPE یا INTERCEPT خطای #DIV/0! گرفتید، بررسی کنید داده‌ها هم‌خط یا نامعین نباشند و در صورت نیاز از LINEST استفاده کنید. ✓
D. Requires add-in

Explanation: SLOPE and INTERCEPT return a #DIV/0! error. — Fix: اگر با SLOPE یا INTERCEPT خطای #DIV/0! گرفتید، بررسی کنید داده‌ها هم‌خط یا نامعین نباشند و در صورت نیاز از LINEST استفاده کنید.

2. How many required arguments does =LINEST have?

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

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

3. What usually causes #DIV/0! in =LINEST?

A. Output is always a dynamic array
B. SLOPE and INTERCEPT return a #DIV/0! error. ✓
C. Volatile and recalculates every time
D. Select entire column for best performance

4. Which use case fits =LINEST?

A. Reporting
B. Conditional Logic
C. Forecasting & Trends ✓
D. External Data, Web & Cube

Explanation: Use case “Forecasting & Trends” fits LINEST.

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

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

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

6. Which function is NOT related to =LINEST?

A. INDEX
B. LOGEST
C. IFNA ✓
D. INTERCEPT

Explanation: “IFNA” is not related to LINEST.

7. Is argument “const” required in =LINEST?

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

Explanation: “const” is optional.

8. What is the output type of =LINEST?

A. Value
B. Date
C. Array ✓
D. Reference

Explanation: Output is “Array”.

9. Which statement about =LINEST is correct?

A. When entering an array constant (such as known_x's) as an argument, use commas to separate values that are contained in the same row and semicolons to separate rows. Separator characters may be different depending on your regional settings.
B. Requires add-in
C. You can describe any straight line with the slope and the y-intercept: Slope (m): To find the slope of a line, often written as m, take two points on the line, (x1,y1) and (x2,y2); the slope is equal to (y2 - y1)/(x2 - x1). Y-intercept (b): The y-intercept of a line, often written as b, is the value of y at the point where the line crosses the y-axis. The equation of a straight line is y = mx + b. Once you know the values of m and b, you can calculate any point on the line by plugging the y- or x-value into that equation. You can also use the TREND function. ✓
D. Volatile and recalculates every time

Explanation: Correct: You can describe any straight line with the slope and the y-intercept: Slope (m): To find the slope of a line, often written as m, take two points on the line, (x1,y1) and (x2,y2); the slope is equal to (y2 - y1)/(x2 - x1). Y-intercept (b): The y-intercept of a line, often written as b, is the value of y at the point where the line crosses the y-axis. The equation of a straight line is y = mx + b. Once you know the values of m and b, you can calculate any point on the line by plugging the y- or x-value into that equation. You can also use the TREND function.

10. In =LINEST, which is argument #2?

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

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