Maureen added a trendline to a chart that shows sales trends for the past 10 years. To extend the trendline to forecast sales for the next two years, she enters 2 in the Backward box in the Format Trendline pane.

Question

Quizplus · Accepted Answer

To forecast future values, Maureen should enter 2 in the Forward box, not the Backward box, which is used to extend the trendline into the past.

Maureen Added a Trendline to a Chart That Shows Sales