Module 10 Hurdy Headphones PivotTable Project Paper

Please follow the instructions.

  • Colin Morin is the assistant sales manager for The Optical Boutique. One of hisassignments is to format the product sales records from 2018 to 2020 to make it easier to analyze.
  • Sort the data in the PrescriptionSales table first in ascending order by the Material field and then in the ascending order by the Shape field.
  • Insert a Total Row in the PrescriptionSales table, and then use the Total Row to calculate the total of the values in both the 2018 and 2019 fields. (Hint: The Total Row should automatically total the values in the 2020 field.)
  • Colin decides to create a PivotTable to allow him to better manipulate and filter the PrescriptionSales table data.

Switch to the Prescription worksheet. Unfreeze the top row of the worksheet.

Create a PivotTable based on the PrescriptionSales table in a new worksheet using Prescription PT as the worksheet name. Update the PivotTable as described below so that it matches Final Figure 1:

>>>>>>>>>>>>> The rest of the instructions are on the word file.

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support