Back to lesson
1. What type of data is required to build a Forecast sheet in Excel 2016?
A rectangular set of data with dates in one row or column and values in the other
Data from a database
Data formatted as an official Excel table
2. Assuming that your data is in good form and you’ve selected a single cell within it, how do you create a Forecast Sheet in Excel 2016?
Go to Insert --> Forecast Charts --> Forecast Sheet
Go to Data --> Forecast Sheet
Go to Insert --> Forecast Sheet
3. You are inserting a Forecast Sheet in Excel 2016, and notice that the default seasonality appears to be incorrect. How do you change it?
Expand the Options triangle and adjust the confidence interval
Expand the Options triangle, choose to set your Seasonality manually, and change the value
Create the chart, then right click it, choose Format Data series and adjust the seasonality
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement