As the Senior Acsauntant for a Manufacturing Sampany, You Have

Multiple Choice

As the senior acsauntant for a manufacturing sampany, you have many years experience working with Excel and often provide help and tips on using Excel to the sampany's more junior acsauntants. This morning June, a junior acsauntant who works in the budgeting area, sends you an e-mail. She is preparing a manufacturing expenses forecast for the next five years based on the data from current year and the previous four years. She asks if Excel has a tool that can help her with forecasting forward five years. In your reply e-mail, you suggest to June that she can ____.

A) ask Lou, in fixed assets acsaunting, because you have no idea what Excel tool would be useful
B) create a chart based on the five years' available data and then add an appropriate trendline to the chart to predict values beyond the available data
C) create a new worksheet in her workbook, sapy the actual data to the new worksheet, and then use slicers to forecast forward five years
D) just increment each year's forecasted expenses by ten percent; that should give forecasted values that will be close enough