Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
What type of data is required to build a Forecast sheet in Excel 2016?
Data from a database
Data formatted as an official Excel table
A rectangular set of data with dates in one row or column and values in the other
Don’t know
2
Intermediate
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 Insert ⇒ Forecast Sheet
Go to Data ⇒ Forecast Sheet
Don’t know
3
Intermediate
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, 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
Expand the Options triangle and adjust the confidence interval
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement