Grader Instructionsexcel 2016 Projectyo Excel16 Ch04 Ps1 V2project ✓ Solved

Grader - Instructions Excel 2016 Project YO_Excel16_Ch04_PS1_v2 Project Description: The marketing manager of the Painted Paradise Golf Resort and Spa, Timothy Smith, has created a spreadsheet of the first six months (first two quarters) of advertising expenses for the various amenities of the resort. He is planning to display the data at the next Board of Directors meeting and wants to create a few charts to make the figures easier to view and the presentation more visually appealing. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open the file named e02ch04_grader_hw_Advertising.xlsx . Save the file with the name e02ch04_grader_hw_Advertising_LastFirst , replacing LastFirst with your last and first name.

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. Rename the line chart title to Total Advertising Expenses per Month . Change the Vertical Axis minimum to 26000 , 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 AdvertisingCosts sheet. On the AdvertisingCosts worksheet, create a 3-D Pie chart of the amenities and their six-month totals in the range A16:B22. Reposition the chart so the top left corner of the chart is in cell C14. On the 3-D pie chart, edit the Chart Title to read 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 percentage in the data labels. Slightly explode the segment of the chart that was allocated the smallest amount of advertising funds. Adjust the rotation of the 3-D Pie chart with a X rotation of 20 , a Y rotation of 40 , and a Perspective of 10 . Modify the 3-D Format by changing the Top bevel to a Relaxed Inset for the Chart Area.

In cells H5:H11, add Column Sparklines that chart the advertising expense by amenity type over the months January to June. Apply the style Sparkline Style Accent 5, Darker 50%. Note, the style name may be Dark Blue, Sparkline Style Accent 5, Darker 50% depending on the version of Office used. Insert the File Name in the left footer section of the AdvertisingCosts worksheet. Save the workbook.

Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100 Created On: 07/05/2019 1 YO_Excel16_Ch04_PS1_v2 AdvertisingCosts Advertising Expenses Monthly Data Amenities January February March April May June Spa $ 3,200 $ 3,500 $ 3,000 $ 3,200 $ 2,700 $ 2,100 Exercise Facility $ 2,000 $ 2,500 $ 2,000 $ 1,800 $ 1,500 $ 2,000 Golf $ 4,500 $ 5,000 $ 5,000 $ 4,800 $ 5,200 $ 3,000 Banquet Facilities $ 7,000 $ 8,000 $ 7,000 $ 7,250 $ 8,500 $ 8,700 Technology Facilities $ 4,000 $ 3,000 $ 4,000 $ 4,500 $ 4,800 $ 3,500 Community Events $ 3,000 $ 5,000 $ 4,000 $ 3,700 $ 4,200 $ 3,600 Family Events $ 2,700 $ 2,650 $ 2,000 $ 3,500 $ 2,750 $ 4,200 Total $ 26,400 $ 29,650 $ 27,000 $ 28,750 $ 29,650 $ 27,100 Semi-Annual Summary Amenities Total Spa $ 17,700 Exercise Facility $ 11,800 Golf $ 27,500 Banquet Facilities $ 46,450 Technology Facilities $ 23,800 Community Events $ 23,500 Family Events $ 17,800 Total $ 168,550

Paper for above instructions

Introduction

The Painted Paradise Golf Resort and Spa, under the guidance of marketing manager Timothy Smith, has compiled a comprehensive spreadsheet detailing the advertising expenses for the first two quarters of the year. This report describes the methodology for creating visual representations of the data that will be utilized at an upcoming Board of Directors meeting. The Excel project includes creating charts, inputting sparklines, and customizing the presentation to enhance data interpretation and decision support.

Data Overview

The dataset provided in the "AdvertisingCosts" worksheet outlines the advertising expenses categorized by different amenities (such as Spa, Exercise Facility, Golf, etc.) from January to June. Each entry corresponds to the respective monthly expenditure for marketing these amenities, as seen in the following table extracted from the dataset:
| Amenities | January | February | March | April | May | June |
|----------------------|---------|----------|-------|-------|-----|------|
| Spa |