Excel_4e_concessions | Computer Science homework help



Project Description:

In the following Mastering Excel project, you will help Lindsay Johnson, the Director of Parks and Recreation, create and modify a PivotTable report and PivotChart report to analyze revenue from park concessions such as food, boat rentals, and golf fees.


Start   Excel. From the files you downloaded with this project, open the file Student_Excel_4E_Concessions.xlsx.


Click cell A2. Insert the last   Recommend PivotTable—Sum of Amount by Park. Add the Month field to the Rows   area below Park, and the Item field in the Columns area, and then Close the   PivotTable Fields pane. (Mac users, be sure that Park displays above Month.)


Insert two slicers, one for the   Park field and one for the Item field. Move the slicers so that they are to   the right of the PivotTable. Apply Lavender, Slicer Style Light 4 to the Park   slicer and Light Orange, Slicer Style Light 6 to the Item slicer.


Use the slicers to filter the   PivotTable by Memorial Park, and then by Golf Fees. Change the Number Format   to the Number category and display zero decimal places and the 1000   Separator. Move the Park slicer so that its upper left corner aligns with the   upper left corner of cell E3. Move the Item slicer so that its upper left   corner aligns with the upper left corner of cell H3.


Make a copy of this worksheet   and Rename the copied worksheet Memorial Golf Fees Insert a footer with the file name in the left   section. Change the Orientation to Landscape, set the Width to 1 page, and   center the sheet Horizontally.


Rename Sheet1 Concessions   Revenue and   then clear the filters and remove the slicers. In cell A1, type Third Quarter   Park Concession Revenue and apply the Title cell style.


Display the Field List, and then   remove the Month field from the Rows area to display the Grand totals for   each park and for each item. Close the PivotTable Fields pane.


Insert a PivotChart using the   Stacked Column chart type. (Mac users, click the Design tab, click Change   Chart Type, point to Column, and then click Stacked Column.) Move the chart   to a new worksheet named Concessions Chart.


Apply the Layout 3 chart layout   and Chart Style 5. As the Chart Title, type 3rd Quarter Concession Revenue and then insert a custom footer   with the file name in the left section. Hide all of the field buttons on the   chart, if necessary. 


Hide the Park Concessions   worksheet. Display the Concessions Revenue sheet, and then insert a footer   with the file name in the left section. Change the Orientation to Landscape,   set the Width to 1 page, and center the sheet Horizontally.


Display the properties. As the   Tags, type concession revenue and as the Subject, type your course name and   section number. 


Save and close the file, and   then submit for grading.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 20% with the discount code RESEARCH