excel project

Anonymous
timer Asked: Jul 4th, 2018
account_balance_wallet $15

Question description

please follow the instruction for finish the excel

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

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

Tutor Answer

Aljon2017
School: University of Virginia

Pleas...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors