Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Excel Homework, Need Help! Painted Paradise On the Documentation worksheet, insert the appropriate content. Fill in any of the other documentation information about the workbook.

Excel Homework, Need Help!image text in transcribed

image text in transcribed

image text in transcribed Painted Paradise On the Documentation worksheet, insert the appropriate content. Fill in any of the other documentation information about the workbook. On the AdvertisingCosts worksheet, create a Line chart of the data for the total spent on advertising each month from January through June. The primary horizontal axis should be the months of the year and the Vertical (value) Axis should be the total spent on advertising each month (Right click -> Select Data to edit the Horizontal Axis labels and change to months). Rename the line chart title to Total Advertising Expenses per Month. Change the Vertical Axis minimum to $26,000 (Right click on the Y axis value ranges -> Format Axis) and change the chart style to Style 12 . Move the line chart to a chart sheet and rename the sheet AdvertisingPerMonth. If necessary move the chart sheet to the right of the Advertising Costs sheet. On the Advertising Costs worksheet, create a 3-D Pie chart of the amenities and their 6-month totals in the range A16:B22. Reposition the chart to the right of the semi-annual data. On the 3-D pie chart, insert the title Semi-Annual Advertising Costs. Apply Style 8 to the chart. Add Data Callouts as data labels to the 3-D pie chart. Include the category name and percent in the data labels (Clicking on the addition button inside the chart area or Chart Design > Add Chart Element). On the 3-D pie chart, explode the segment of the chart that was allocated the smallest amount of advertising funds. In cells H5:H11, add sparklines that chart the advertising expenses by amenity type over the months Painted Paradise On the Documentation worksheet, insert the appropriate content. Fill in any of the other documentation information about the workbook. On the AdvertisingCosts worksheet, create a Line chart of the data for the total spent on advertising each month from January through June. The primary horizontal axis should be the months of the year and the Vertical (value) Axis should be the total spent on advertising each month (Right click -> Select Data to edit the Horizontal Axis labels and change to months). Rename the line chart title to Total Advertising Expenses per Month. Change the Vertical Axis minimum to $26,000 (Right click on the Y axis value ranges -> Format Axis) and change the chart style to Style 12 . Move the line chart to a chart sheet and rename the sheet AdvertisingPerMonth. If necessary move the chart sheet to the right of the Advertising Costs sheet. On the Advertising Costs worksheet, create a 3-D Pie chart of the amenities and their 6-month totals in the range A16:B22. Reposition the chart to the right of the semi-annual data. On the 3-D pie chart, insert the title Semi-Annual Advertising Costs. Apply Style 8 to the chart. Add Data Callouts as data labels to the 3-D pie chart. Include the category name and percent in the data labels (Clicking on the addition button inside the chart area or Chart Design > Add Chart Element). On the 3-D pie chart, explode the segment of the chart that was allocated the smallest amount of advertising funds. In cells H5:H11, add sparklines that chart the advertising expenses by amenity type over the months

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions