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

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

Question 2 of 10 2/10

Which category does =TREND belong to?

Question 3 of 10 3/10

How many arguments does =TREND have in total?

Question 4 of 10 4/10

Which statement about =TREND is correct?

Question 5 of 10 5/10

Which use case fits =TREND?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Is =TREND volatile?

Question 8 of 10 8/10

In =TREND, which is argument #2?

Question 9 of 10 9/10

Does =TREND return a dynamic array?

Question 10 of 10 10/10

In =TREND, which is argument #3?

Click a question to see the answer.

1. What is the type of argument “known_y's” in =TREND?

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

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

2. Which category does =TREND belong to?

A. Logical
B. Math & Trig
C. Statistical ✓
D. Web

Explanation: Category is “Statistical”.

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

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

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

4. Which statement about =TREND is correct?

A. For information about how Microsoft Excel fits a line to data, see LINEST. ✓
B. Only works in old versions
C. When entering an array constant for an argument such as known_x's, use commas to separate values in the same row and semicolons to separate rows.
D. 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.

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

5. Which use case fits =TREND?

A. Workdays & Due Dates
B. Forecasting & Trends ✓
C. Ranking & Top N
D. Daily Tasks

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

6. Is argument “known_x's” required in =TREND?

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

Explanation: “known_x's” is optional.

7. Is =TREND volatile?

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

Explanation: TREND is not volatile.

8. In =TREND, which is argument #2?

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

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

9. Does =TREND return a dynamic array?

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

Explanation: TREND does not spill.

10. In =TREND, which is argument #3?

A. const
B. new_x's ✓
C. known_x's
D. criteria

Explanation: Argument #3 is “new_x's”.