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

Quiz =LINEST — 15 Questions

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

Question 1 of 15 1/15

Which statement about =LINEST is correct?

Question 2 of 15 2/15

Since which Excel version is =LINEST available?

Question 3 of 15 3/15

Which category does =LINEST belong to?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which is the correct syntax of =LINEST?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is argument “const” required in =LINEST?

Question 10 of 15 10/15

Is =LINEST volatile?

Question 11 of 15 11/15

How many arguments does =LINEST have in total?

Question 12 of 15 12/15

Which function is related to =LINEST?

Question 13 of 15 13/15

In =LINEST, which is argument #1?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which formula is a valid example of =LINEST?

Click a question to see the answer.

1. Which statement about =LINEST is correct?

A. Output is always a dynamic array
B. Text is always ignored
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.

2. Since which Excel version is =LINEST available?

A. Excel 2019
B. Excel 365
C. All versions ✓
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

3. Which category does =LINEST belong to?

A. Statistical ✓
B. Logical
C. Cube
D. Information

Explanation: Category is “Statistical”.

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

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

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

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

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

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

6. Which is the correct syntax of =LINEST?

A. =LINEST(known_y's, [known_x's], [const], [stats]) ✓
B. =LINEST(known_y's, [known_x's], [const], [stats], 0)
C. =INDEX(known_y's, [known_x's], [const], [stats])
D. LINEST(known_y's, [known_x's], [const], [stats])

Explanation: Correct syntax: =LINEST(known_y's, [known_x's], [const], [stats])

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

A. SLOPE and INTERCEPT return a #DIV/0! error. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Requires add-in

8. Is argument “known_y's” required in =LINEST?

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

Explanation: “known_y's” is required.

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

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

Explanation: “const” is optional.

10. Is =LINEST volatile?

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

Explanation: LINEST is not volatile.

11. How many arguments does =LINEST have in total?

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

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

12. Which function is related to =LINEST?

A. T.INV.2T
B. CSCH
C. INDEX ✓
D. SIGN

Explanation: “INDEX” is related to LINEST.

13. In =LINEST, which is argument #1?

A. known_y's ✓
B. stats
C. const
D. lookup_value

Explanation: Argument #1 is “known_y's”.

14. What is the type of argument “known_y's” in =LINEST?

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

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

15. Which formula is a valid example of =LINEST?

A. SUM(LINEST(B1:B6, A1:A6)*{9,1})
B. =SUM(LINEST(B1:B6, A1:A6)*{9,1}, 0)
C. =SUM(LINEST(B1:B6, A1:A6)*{9,1}) ✓
D. =SUM(INDEX(B1:B6, A1:A6)*{9,1})

Explanation: Correct example: =SUM(LINEST(B1:B6, A1:A6)*{9,1})