As the Senior Acsauntant for a Manufacturing Sampany, You Have

question 75

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

---

Definitions:

First Nations

refers to indigenous peoples in Canada who are not Inuit or Métis, often recognized as the original inhabitants of the land.

Hispanic

A term used to describe people, cultures, or countries related to the Spanish language, Hispanic America, Spain, and Spanish heritage or origin.

African American

African American pertains to individuals in the United States who have African ancestry, with cultural, historical, and social distinctions.

Static Time

A concept of time considered unchanging, fixed, and unmoving, often contrasted with dynamic or real-time environments.