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