1. Sort spreadsheet and calculate each regions order totals using excel sort and sum functions. Which regions order generated highest $ amount? What % of total sales does this region represent.

2. Sort spreadsheet & calculate each reps order totals. Which rep had the highest sales?

3. Create a bar chart or pie graph to illustrate both trends