In cell $C10,$ calculate the appropriate total for the column. Copy the formula through cell range C$10$:E$10.$

On the Adxertisingelan worksheet, you need to finish out the new budget year analysis.

In cell I$6,$ calculate the Number of Ads that can be purchased based on the New Budget divided by the New Cost Per Ad$.$ A partial ad cannot be purchased, so you need to create a formula that will round the number down to the nearest integer. Copy the formula through cell range $16$:$19.$

In cell J$6,$ calculate the monthly Amount to Spend by multiplying the New Cost Per Ad and the Ads to Place. Copy the formula through cell range J$6$:J$9.$

In cell G$10,$ calculate the appropriate total for the column. Copy the formula through cell range G$10$:J$10.$ If necessary, change the format for cell I$10$ to General.