Assignment #8

  (30 points)

  1. Watch the video Pivot Tables (MS Excel)   (CC).

  2. Create a MS Excel spreadsheet similar to the document developed in the video and shown below. (Data). One pivot table must be created to allow the user to view the customers and the profit. A second pivot table must be created to allow the user to view the customers and the revenue by region. Insert your name somewhere in the document. Rename this sheet "Assignment 8A".



  3. Create a new tab in the Microsoft Excel document created in the previous step. Rename this sheet "Assignment 8B". Enter the Data as shown in the image below. Insert a Pivot Table that displays the "Sum of Quantity" based on the Region (i.e., East, North, South, and West).



  4. Explore the tutorial Pivot Table Tips & Tutorials . Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.

  5. Save your work as "assignment8.xlsx" when you are finished.

  6. Upload this file to YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Spreadsheet (Assignment 8A) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Created one pivot table that allows the user to view the customers and the profit. Created a second pivot table that allows the user to view the customers and the revenue by region. 10 0 5 10 __/10
2. Spreadsheet (Assignment 8B) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Created a pivot table that displays the "Sum of Quantity" based on the Region (i.e., East, North, South, and West). 10 0 5 10 __/10
3. Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #4. 10 0 5 10 __/10
Total points __/30