excel project

User Generated

94pu

Business Finance

Description

please follow the instruction for finish the excel

let me know if you have any questions. thank you!

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions Excel Project YO16_XL_CH04_GRADER_PS1_HW - Advertising 1.3 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. Instructions: For the purpose of grading the project you are required to perform the following tasks: 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. 0 2 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. 20 3 4 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. 15 5 5 On the AdvertisingCosts worksheet, create a 3-D Pie chart of the amenities and their sixmonth totals in the range A16:B22. Reposition the chart so the top left corner of the chart is in cell C14. 20 6 On the 3-D pie chart, edit the Chart Title to read Semi-Annual Advertising Costs. Apply Style 8 to the chart. 15 7 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. 10 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%. 8 Note, the style name may be Dark Blue, Sparkline Style Accent 5, Darker 50% depending on the version of Office used. 13 9 Insert the File Name in the left footer section of the AdvertisingCosts worksheet. 2 Updated: 03/12/2018 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Excel Project Step Instructions Points Possible 10 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points Updated: 03/12/2018 2 100 Current_Instruction.docx Advertising Expenses Monthly Data Amenities Spa Exercise Facility Golf Banquet Facilities Technology Facilities Community Events Family Events Total Semi-Annual Summary Amenities Spa Exercise Facility Golf Banquet Facilities Technology Facilities Community Events Family Events Total $ $ $ $ $ $ $ $ January 3.200 2.000 4.500 7.000 4.000 3.000 2.700 26.400 $ $ $ $ $ $ $ $ Total 17.700 11.800 27.500 46.450 23.800 23.500 17.800 168.550 $ $ $ $ $ $ $ $ February 3.500 2.500 5.000 8.000 3.000 5.000 2.650 29.650 $ $ $ $ $ $ $ $ March 3.000 2.000 5.000 7.000 4.000 4.000 2.000 27.000 $ $ $ $ $ $ $ $ April 3.200 1.800 4.800 7.250 4.500 3.700 3.500 28.750 $ $ $ $ $ $ $ $ May 2.700 1.500 5.200 8.500 4.800 4.200 2.750 29.650 $ $ $ $ $ $ $ $ June 2.100 2.000 3.000 8.700 3.500 3.600 4.200 27.100
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Pleas...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags