Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On the AdvertisingPlan worksheet, you need to make two charts for your presentation. Based on the data in cell ranges A5:A9, D5:D9, and L5:L9, add
On the AdvertisingPlan worksheet, you need to make two charts for your presentation. Based on the data in cell ranges A5:A9, D5:D9, and L5:L9, add a 3-D Clustered Column chart to compare the past guest results to the anticipated guest results based on the new monthly advertising. Apply the Chart Style 3. Change the title to Past vs. Anticipated Guest Results Add data labels to the chart. Move and resize the chart so the top-left corner is in cell A13 and the bottom-right corner is in cell L32. Create an additional chart based on the data. lin cell ranges A5:A9, D5:D9, and E5:E9, add a Clustered Column - Line on Secondary Axis Combo Chart. Move this chart to a chart sheet named GuestResultsBx Specdnd. Apply Chart Style 5. Change the title to Advertising Amount Spent by Past Guest Results Set the chart title to 18pt font size, set the value axis labels to 12pt font size, and set all legend text to 12pt font size. E G I J New Budget Analysis Today's Date 2/5/2023 4 y Advertising 14 In cell J6, calculate the monthly Amount to Spend by multiplying the New Cost Per Ad and the Ads to Place. Copy the formula through cell range J6:J. 15 In cell G10, calculate the appropriate totals for each column. Copy the formula through cell range G10:J10. If necessary, change the format for cell I 10 to General. 16 In cell K6, 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. 18 In cell L10, calculate the appropriate total for Anticipated Guest Results. 19 In cell L11, 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. On the AdvertisingPlan worksheet, you need to make two charts for your presentation. Based on the data in cell ranges A5:A9, D5:D9, and L5:L9, add a 3-D Clustered Column chart to compare the past guest results to the anticipated guest results based on the new monthly advertising. Apply the Chart Style 3. Change the title to Past vs. Anticipated Guest Results Add data labels to the chart. Move and resize the chart so the top-left corner is in cell A13 and the bottom-right corner is in cell L32. Create an additional chart based on the data. lin cell ranges A5:A9, D5:D9, and E5:E9, add a Clustered Column - Line on Secondary Axis Combo Chart. Move this chart to a chart sheet named GuestResultsBx Specdnd. Apply Chart Style 5. Change the title to Advertising Amount Spent by Past Guest Results Set the chart title to 18pt font size, set the value axis labels to 12pt font size, and set all legend text to 12pt font size. E G I J New Budget Analysis Today's Date 2/5/2023 4 y Advertising 14 In cell J6, calculate the monthly Amount to Spend by multiplying the New Cost Per Ad and the Ads to Place. Copy the formula through cell range J6:J. 15 In cell G10, calculate the appropriate totals for each column. Copy the formula through cell range G10:J10. If necessary, change the format for cell I 10 to General. 16 In cell K6, 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. 18 In cell L10, calculate the appropriate total for Anticipated Guest Results. 19 In cell L11, 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started