Statistical =TREND(known_y's, [known_x's], [new_x's], [const])

Quiz =TREND — 10 Questions

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

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

← TREND ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which is the correct syntax of =TREND?

Question 2 of 10 2/10

What is the type of argument “new_x's” in =TREND?

Question 3 of 10 3/10

Which statement about =TREND is correct?

Question 4 of 10 4/10

What is the output type of =TREND?

Question 5 of 10 5/10

How many required arguments does =TREND have?

Question 6 of 10 6/10

What is the type of argument “const” in =TREND?

Question 7 of 10 7/10

Which function is NOT related to =TREND?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Is =TREND volatile?

Click a question to see the answer.

1. Which is the correct syntax of =TREND?

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

Explanation: Correct syntax: =TREND(known_y's, [known_x's], [new_x's], [const])

2. What is the type of argument “new_x's” in =TREND?

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

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

3. Which statement about =TREND is correct?

A. Volatile and recalculates every time
B. You can use TREND for polynomial curve fitting by regressing against the same variable raised to different powers. For example, suppose column A contains y-values and column B contains x-values. You can enter x^2 in column C, x^3 in column D, and so on, and then regress columns B through D against column A.
C. Output is always a dynamic array
D. For information about how Microsoft Excel fits a line to data, see LINEST. ✓

Explanation: Correct: For information about how Microsoft Excel fits a line to data, see LINEST.

4. What is the output type of =TREND?

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

Explanation: Output is “Array”.

5. How many required arguments does =TREND have?

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

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

6. What is the type of argument “const” in =TREND?

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

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

7. Which function is NOT related to =TREND?

A. FORECAST-LINEAR
B. LINEST
C. MAP ✓
D. GROWTH

Explanation: “MAP” is not related to TREND.

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

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

Explanation: “known_y's” is required.

9. What is the type of argument “known_x's” in =TREND?

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

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

10. Is =TREND volatile?

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

Explanation: TREND is not volatile.