Assignment: Educational And Planning Excel
Manipulate the data in this sample order spreadsheet to address the following:
1. Sort your spreadsheet and then calculate each region's order totals using Excel sort and "sum" functions. Which region's order generated the highest dollar amount? What percent of total sales does this region represent?
2. Sort your spreadsheet and then calculate each rep's order totals using Excel sort and "sum" functions. Which rep generated the highest sales?
3. Create a bar chart or a pie graph to illustrate both trends.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.