Reps and Regions Spreadsheet Directions • Use Reps and Regions.xls Worksheet Fol

ID: 367813 • Letter: R

Question

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?

This is the screenshot of the spreadsheet you are looking for.

I cant upload the spreadsheet file here. Please rate if you like it.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.