Create a pivot table showing the number of materials for each Mfr Name 2. Sort the result by count of material by (descending) 3. Label the worksheet - Summary by Material 4. Update the pivot table to show average sell price