Excel_4g_recreation | Computer Science homework help



Project Description:

In the following project, you will assist James Davis, the Recreation Director, in creating and modifying a PivotTable report and a PivotChart report.


Navigate   to your Excel Chapter 4 folder, and then double-click the Excel file you   downloaded from MyLab IT that displays your name—Student_Excel_4G_Recreation_as.xlsx.


Click cell A2, and then insert a   Recommended PivotTable by choosing the Blank PivotTable option in the lower   left corner of the dialog box. Add the Month field to the Filters area, add   the Center field to the Rows area and the Program field to the Columns area.   Place the Amount field in the Values area and then Close the PivotTable   Fields list.

  Note, Mac users, move fields as necessary so that they are placed in the   correct areas of the layout section.


Format the values in the PivotTable using the Number category to   display zero decimal places and the 1000 Separator.


Insert slicers for the Program   and Center fields, and then filter by the Bard Hall Senior Center and   Ceramics and Water Color revenue. Move the Program slicer so that it’s upper   left corner aligns with the upper left corner of E3. Move the Center slicer so   that its upper left corner aligns with H3. Make a copy of this worksheet, and   then name the copied worksheet Bard Hall


Display Sheet1 and clear the   filters from the slicers and remove the slicers from the worksheet. Rename   the sheet 3Q Revenue


Insert a PivotChart using the   Stacked Column chart type. Move the chart to a new worksheet named 3Q Revenue   Chart


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


Add a new worksheet to the   workbook. On the Data tab, click Get Data and then from your downloaded   files, import the Microsoft Access Database Excel_4G_Rec_Centers.accdb. Load both of the tables in the   database.

  Note, Mac users, on the Data tab, click From Text. From your downloaded   files, click Excel_Rec_Center_Supplies_csv.csv,   and then click Get Data. Use Comma delimiters and General column data format.   Put the data in the Existing sheet in A1.


Insert a PivotTable in the   Existing Worksheet and verify that Use this workbook’s Data Model is   selected. 


To create the PivotTable, place   the Supplier field from the Suppliers table in the Columns area. From the   Supply Order Summary table, place the Item field in the Rows area, and the   Quantity field in the Values area. Apply the Number format to the values in   the PivotTable with zero decimals and the 1000 separator.


Insert a row above the   PivotTable, if necessary, and in cell A1, type Recreation Center Supplies and then apply the Title cell   style. Rename the sheet Recreation Supplies


Click in the PivotTable, and   then insert a 3-D Pie PivotChart. Move the chart to a new sheet with the name   Supplies   Chart


Display the Field List and then   modify the chart so that only the Supplier field displays in the Axis   (Categories) area. Remove any fields that display in the Legend (Series)   area. 


Apply Style 3, remove the legend   from the chart, and display only the Category Name and Percentage data labels   positioned in the Center. 


Change the chart title to Supply   Purchases and   then change the font size to 24. Hide all of the field buttons on the chart,   and then insert a footer with the file name in the left section.


Hide the Program Revenue sheet.   Select all the sheets (excluding the chart sheets) and insert a footer in the   left section that includes the file name, and then center the worksheet   Horizontally on the page. Change the Orientation to Landscape and scale the   Width to fit to 1 page.


Display the properties. As the   Tags/Keywords, type rec center and as the Subject, type your course name and   section #. Under Related People, be sure that your name displays as Author.   Save your workbook.


Ensure the worksheets are in the   following order:
Bard Hall, 3Q Revenue Chart, Supplies   Chart, Recreation Supplies, 3Q Revenue

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

Calculate Your Essay Price
(550 words)

Approximate price: $22

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 10% with the coupon code: best10