Assignment
Your company has asked you to create a spreadsheet to analyze the following data. The data will be reviewed for top salespeople bonuses and commissions payments based on individual sales. Averages will be used to analyze month-over-month sales throughout the years.
Use the Sales Analysis Microsoft Excel spreadsheet and apply formatting to accomplish the following:
• Calculate total sales using the SUM function.
• Calculate total sales for each quarter. (March, June, and September each represent a quarter.). A quarter is three months.
• Calculate average sales for each quarter to help determine 4th-quarter potential sales.
• Highlight the top salesperson in each quarter.
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.