To create a forecast sheet,enter two data series corresponding to each other in a worksheet,select both the data series,then click on the following: Data tab Forecast group Forecast Sheet Create Forecast Worksheet box Select Line Chart or Column Chart Pick an end date in Forecast End box Create.

Question

To create a forecast sheet,enter two data series corresponding to each other in a worksheet,select both the data series,then click on the following: Data tab > Forecast group > Forecast Sheet > Create Forecast Worksheet box > Select Line Chart or Column Chart > Pick an end date in Forecast End box > Create.

Quizplus · Accepted Answer

This is the correct process to create a forecast sheet in Excel.

To Create a Forecast Sheet,enter Two Data Series Corresponding to Each