Statistical =FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])

Quiz =FORECAST.ETS — 10 Questions

10 quiz questions about =FORECAST.ETS — test syntax, arguments, examples & errors!

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

← FORECAST.ETS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #N/A in =FORECAST.ETS?

Question 2 of 10 2/10

Is argument “target_date” required in =FORECAST.ETS?

Question 3 of 10 3/10

Is argument “timeline” required in =FORECAST.ETS?

Question 4 of 10 4/10

Is argument “seasonality” required in =FORECAST.ETS?

Question 5 of 10 5/10

In =FORECAST.ETS, which is argument #1?

Question 6 of 10 6/10

Which statement about =FORECAST.ETS is correct?

Question 7 of 10 7/10

In =FORECAST.ETS, which is argument #2?

Question 8 of 10 8/10

What is the output type of =FORECAST.ETS?

Question 9 of 10 9/10

How many arguments does =FORECAST.ETS have in total?

Question 10 of 10 10/10

What is the type of argument “seasonality” in =FORECAST.ETS?

Click a question to see the answer.

1. What usually causes #N/A in =FORECAST.ETS?

A. Volatile and recalculates every time
B. Select entire column for best performance
C. Text is always ignored
D. If the ranges of the timeline and values aren't of same size, FORECAST.ETS will return the #N/A error. ✓

Explanation: If the ranges of the timeline and values aren't of same size, FORECAST.ETS will return the #N/A error. — Fix: Make the two ranges the same size

2. Is argument “target_date” required in =FORECAST.ETS?

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

Explanation: “target_date” is required.

3. Is argument “timeline” required in =FORECAST.ETS?

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

Explanation: “timeline” is required.

4. Is argument “seasonality” required in =FORECAST.ETS?

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

Explanation: “seasonality” is optional.

5. In =FORECAST.ETS, which is argument #1?

A. data
B. target_date ✓
C. value
D. aggregation

Explanation: Argument #1 is “target_date”.

6. Which statement about =FORECAST.ETS is correct?

A. Output is always a dynamic array
B. The FORECAST.ETS function is not available in Excel for the web, iOS, or Android. ✓
C. Text is always ignored
D. Volatile and recalculates every time

Explanation: Correct: The FORECAST.ETS function is not available in Excel for the web, iOS, or Android.

7. In =FORECAST.ETS, which is argument #2?

A. target_date
B. value
C. timeline
D. values ✓

Explanation: Argument #2 is “values”.

8. What is the output type of =FORECAST.ETS?

A. Mixed
B. Logical
C. Number ✓
D. Value

Explanation: Output is “Number”.

9. How many arguments does =FORECAST.ETS have in total?

A. 6 ✓
B. 8
C. 7
D. 5

Explanation: =FORECAST.ETS has 3 required, 3 optional (6 total).

10. What is the type of argument “seasonality” in =FORECAST.ETS?

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

Explanation: Type of “seasonality” is “Number”.