Allison's small business earns $10,000 in January. She expects income to increase by 5 percent per month until the end of the year. To use Excel to calculate monthly income from February to December, Allison can fill a series with a trend.

Question

Quizplus · Accepted Answer

Allison can use Excel's fill feature to create a series that increases by 5% each month and calculates the income for each month based on the previous month's income. This is called a trend and is a useful tool for forecasting future values based on historical data.

Allison's Small Business Earns $10,000 in January