Reps and Regions Spreadsheet Directions
• Use Reps and Regions.xls Worksheet Follow the steps below to complete the spreadsheet:
1. Create Dashboard including a chart.
2. Arrange slicers.
3. Make each slicer a different color.
4. Put three columns in “Order Date”
5. Put two columns in “Rep”
6. Put useful number of columns in “Units”
7. Add column(s) to “Total”
8. On what item did Jones have the largest dollar sales?
9. On what date did Howard sell the most pens?
10. On 9/10/2016, what product did Sorvino sell?
11. Is Kivell or Parent the best overall salesperson?