On the Adxectisingelan worksheet, in cell D$6,$ enter a formula that will reference the named range Avallagazine $($to return the value in cell D$19$ on the Guestlata, worksheet$).$

In cell D$7,$ reference the named range AxaRadla

In cell D$8,$ reference the named range AxaTelexision.

In cell D$9,$ reference the named range Avalotecoet

In cell E$6,$ calculate the monthly Amount Spent by multiplying the Cost Per Ad and the Ads Placed. Copy the formula through cell range E$6$:E$9.$

In cell F$6,$ calculate the Cost per Guest Result by dividing the Amount Spent by the Past Guest Results. Copy the formula through cell range F$6$:F$9.$

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

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

In cell $16,$ 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 Arough cell range G$10$:J$10.$ If necessary, change the format for cell $I10$ to General.

In cell K$6,$ determine if you will increase or decrease marketing based on the Ads to Place.

Enter an IF function that will return the value of Increase if the Ads to Place is equal to zero. Any other value should return a value of Decrease Copy the function through cell range $K6$:$K9.$

In cell L$6,$ calculate the Anticipated Guest Results by dividing the Amount to Spend by the Cost per Guest Result in column F$.$ The resulting value should be rounded $($not formatted$)$ to zero decimals. Copy the formula through cell range L$6$:L$9.$

In cell L$10,$ calculate the appropriate total for Anticipated Guest Results.

In cell L$11,$ calculate the amount of anticipated guest results compared to the past by subtracting the Past Guest Results total from the Anticipated Guest Results total. Note that the totals are in row $10.$ A negative number indicates an anticipated decrease in Guest Results. A positive number indicates an anticipated increase in Guest Results.