Lucinda's small business earned $15,000 in profit in August.She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month.Which of the following can she do to make the calculation?
A) Use Flash Fill.
B) Fill a series with a growth trend.
C) Create a custom AutoFill list.
D) Use the Consolidate tool.

Question

Quizplus · Accepted Answer

To calculate the profit for 12 months, Lucinda can use a fill series with a growth trend to calculate the monthly growth rate of 1.5%. This will allow her to easily calculate the profit for each month and add them up to get the total profit for the year.

Lucinda's Small Business Earned $15,000 in Profit in August