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

Quiz =FORECAST.ETS.STAT — 15 Questions

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

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

← FORECAST.ETS.STAT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which use case fits =FORECAST.ETS.STAT?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

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

Question 7 of 15 7/15

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

Question 8 of 15 8/15

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

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

What usually causes #VALUE! in =FORECAST.ETS.STAT?

Question 12 of 15 12/15

In =FORECAST.ETS.STAT, which is argument #3?

Question 13 of 15 13/15

Since which Excel version is =FORECAST.ETS.STAT available?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Does =FORECAST.ETS.STAT return a dynamic array?

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

Explanation: FORECAST.ETS.STAT does not spill.

2. Which function is related to =FORECAST.ETS.STAT?

A. UPPER
B. MINVERSE
C. FORECAST-ETS ✓
D. NETWORKDAYS.INTL

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

3. Which is the correct syntax of =FORECAST.ETS.STAT?

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

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

4. Which use case fits =FORECAST.ETS.STAT?

A. Conditional Logic
B. Forecasting & Trends ✓
C. Rounding & Numeric
D. Data Cleaning

Explanation: Use case “Forecasting & Trends” fits FORECAST.ETS.STAT.

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

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

Explanation: “timeline” is required.

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

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

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

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

A. مقادیر تکراری را از خط زمانی حذف کنید. ✓
B. Select entire column for best performance
C. Requires add-in
D. اندازه محدوده‌های خط زمانی و مقادیر یکسان نیست.

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

8. Which statement about =FORECAST.ETS.STAT is correct?

A. Text is always ignored
B. Only works in old versions
C. Volatile and recalculates every time
D. The function FORECAST.ETS.STAT is not available in Excel for the Web, iOS, or Android. ✓

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

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

A. Volatile and recalculates every time
B. Only works in old versions
C. If the ranges of the timeline and values aren't of same size, FORECAST.ETS.STAT will return the #N/A error. ✓
D. Text is always ignored

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

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

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

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

11. What usually causes #VALUE! in =FORECAST.ETS.STAT?

A. Text is always ignored
B. If timeline contains duplicate values, FORECAST.ETS.STAT will return the #VALUE! error. ✓
C. Requires add-in
D. Output is always a dynamic array

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

12. In =FORECAST.ETS.STAT, which is argument #3?

A. range
B. timeline
C. statistic_type ✓
D. lookup_value

Explanation: Argument #3 is “statistic_type”.

13. Since which Excel version is =FORECAST.ETS.STAT available?

A. All versions
B. Excel 2007 (Compatibility)
C. Excel 2016 ✓
D. Excel 365

Explanation: Version: “Excel 2016”.

14. What is the output type of =FORECAST.ETS.STAT?

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

Explanation: Output is “Number”.

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

A. timeline ✓
B. seasonality
C. aggregation
D. range

Explanation: Argument #2 is “timeline”.