Statistical
=FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])
Quiz =FORECAST.ETS.SEASONALITY — 10 Questions
10 quiz questions about =FORECAST.ETS.SEASONALITY — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
In =FORECAST.ETS.SEASONALITY, which is argument #1?
Explanation: Argument #1 is “values”.
Question 2 of 10
2/10
Is argument “values” required in =FORECAST.ETS.SEASONALITY?
Explanation: “values” is required.
Question 3 of 10
3/10
Which statement about =FORECAST.ETS.SEASONALITY is correct?
Explanation: Correct: The function FORECAST.ETS.SEASONALITY is not available in Excel for the Web, iOS, or Android.
Question 4 of 10
4/10
What is the fix for #VALUE! in =FORECAST.ETS.SEASONALITY?
Explanation: If timeline contains duplicate values, FORECAST.ETS.SEASONALITY will return the #VALUE! error. — Fix: مقادیر تکراری را از خط زمانی حذف کنید.
Question 5 of 10
5/10
Since which Excel version is =FORECAST.ETS.SEASONALITY available?
Explanation: Version: “Excel 2016”.
Question 6 of 10
6/10
What is the type of argument “data” in =FORECAST.ETS.SEASONALITY?
Explanation: Type of “data” is “Number”.
Question 7 of 10
7/10
Does =FORECAST.ETS.SEASONALITY return a dynamic array?
Explanation: FORECAST.ETS.SEASONALITY does not spill.
Question 8 of 10
8/10
Which category does =FORECAST.ETS.SEASONALITY belong to?
Explanation: Category is “Statistical”.
Question 9 of 10
9/10
What is the type of argument “values” in =FORECAST.ETS.SEASONALITY?
Explanation: Type of “values” is “Range”.
Question 10 of 10
10/10
Is argument “timeline” required in =FORECAST.ETS.SEASONALITY?
Explanation: “timeline” is required.