Description

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.