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

Quiz =FORECAST.ETS — 15 Questions

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

Question 1 of 15 1/15

What is the fix for #N/A in =FORECAST.ETS?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which is the correct syntax of =FORECAST.ETS?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which formula is a valid example of =FORECAST.ETS?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

What is the fix for #VALUE! in =FORECAST.ETS?

Question 9 of 15 9/15

What usually causes #NUM! in =FORECAST.ETS?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

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

Question 12 of 15 12/15

What is the fix for #NUM! in =FORECAST.ETS?

Question 13 of 15 13/15

Does =FORECAST.ETS return a dynamic array?

Question 14 of 15 14/15

Which function is related to =FORECAST.ETS?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. What is the fix for #N/A in =FORECAST.ETS?

A. Make the two ranges the same size ✓
B. Only works in old versions
C. تاریخ هدف قبل از پایان خط زمانی تاریخی است، یا نمی‌توان گام ثابتی در خط زمانی شناسایی کرد، یا مقدار seasonality نامعتبر یا بزرگ‌تر از ۸٬۷۶۰ است.
D. Volatile and recalculates every time

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. How many arguments does =FORECAST.ETS have in total?

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

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

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

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

Explanation: Type of “timeline” is “Range”.

4. Which is the correct syntax of =FORECAST.ETS?

A. =FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation], 0)
B. =FORECAST-ETS-CONFINT(target_date, values, timeline, [seasonality], [data_completion], [aggregation])
C. FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])
D. =FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation]) ✓

Explanation: Correct syntax: =FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])

5. Is argument “data” required in =FORECAST.ETS?

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

Explanation: “data” is optional.

6. Which formula is a valid example of =FORECAST.ETS?

A. FORECAST.ETS(A38, B2:B37, A2:A37)
B. =FORECAST.ETS(A38, B2:B37, A2:A37, 0)
C. =FORECAST.ETS(A38, B2:B37, A2:A37) ✓
D. =FORECAST-ETS-CONFINT(A38, B2:B37, A2:A37)

Explanation: Correct example: =FORECAST.ETS(A38, B2:B37, A2:A37)

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

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

Explanation: “target_date” is required.

8. What is the fix for #VALUE! in =FORECAST.ETS?

A. تاریخ هدف قبل از پایان خط زمانی تاریخی است، یا نمی‌توان گام ثابتی در خط زمانی شناسایی کرد، یا مقدار seasonality نامعتبر یا بزرگ‌تر از ۸٬۷۶۰ است.
B. Requires add-in
C. Output is always a dynamic array
D. مقادیر تکراری را از خط زمانی حذف کنید. ✓

Explanation: If timeline contains duplicate values, FORECAST.ETS will return the #VALUE! error. — Fix: مقادیر تکراری را از خط زمانی حذف کنید.

9. What usually causes #NUM! in =FORECAST.ETS?

A. خط زمانی شامل مقادیر تکراری است.
B. Select entire column for best performance
C. If the target date is chronologically before the end of the historical timeline, FORECAST.ETS returns the #NUM! error. If a constant step can't be identified in the provided timeline, FORECAST.ETS will return the #NUM! error. For any other value, FORECAST.ETS will return the #NUM! error. Any seasonality above that number will result in the #NUM! error. ✓
D. Volatile and recalculates every time

Explanation: If the target date is chronologically before the end of the historical timeline, FORECAST.ETS returns the #NUM! error. If a constant step can't be identified in the provided timeline, FORECAST.ETS will return the #NUM! error. For any other value, FORECAST.ETS will return the #NUM! error. Any seasonality above that number will result in the #NUM! error. — Fix: مطمئن شوید تاریخ هدف بعد از خط زمانی است، گام خط زمانی ثابت باشد و seasonality بین ۰ تا ۸٬۷۶۰ و مقدار مجاز باشد.

10. Is argument “aggregation” required in =FORECAST.ETS?

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

Explanation: “aggregation” is optional.

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

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

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

12. What is the fix for #NUM! in =FORECAST.ETS?

A. Text is always ignored
B. Volatile and recalculates every time
C. Requires add-in
D. مطمئن شوید تاریخ هدف بعد از خط زمانی است، گام خط زمانی ثابت باشد و seasonality بین ۰ تا ۸٬۷۶۰ و مقدار مجاز باشد. ✓

13. Does =FORECAST.ETS return a dynamic array?

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

Explanation: FORECAST.ETS does not spill.

14. Which function is related to =FORECAST.ETS?

A. DETECTLANGUAGE
B. FORECAST-ETS-CONFINT ✓
C. DOLLAR
D. SLOPE

Explanation: “FORECAST-ETS-CONFINT” is related to FORECAST.ETS.

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

A. Array
B. Reference
C. Number ✓
D. Mixed

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