Based on this material, create a spreadsheet of a sales compensation report.  Cr

Based on this material, create a spreadsheet of a sales compensation report.  Create data tables to analyze results of the sales team on an individual basis.Create a gender analysis table.  Utilize the IF, MAX, SUM IF, and COUNT IF Functions. The data for your spreadsheet can be found here Links to an external site. https://www.dropbox.com/scl/fi/yp1gmvsc5uzp7q7o0k8ur/assignment-5.xlsx?rlkey=mouozr0xw9mknc42vkn7dwm69&e=1&dl=0 Certain cells must have the proper formulas and not just the correct data in order to receive full credit.  Upload your excel assignment in the folder here. The Canvas Student Guide provides instructions for submitting an online AssignmentLinks to an external site..
The instructor will grade and provide comments on Assignments within 1 week of submission. See the Canvas guide page: How do I view assignment comments from my instructor?Links to an external site.
Rubric
Microsoft Excel Spreadsheet (1) (1)
Microsoft Excel Spreadsheet (1) (1)
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeNeatness and Organization
3 pts
This criterion is linked to a Learning OutcomeFormulas
4 pts
This criterion is linked to a Learning OutcomeTitles, Labels, and Headings
4 pts
This criterion is linked to a Learning OutcomeContent
4 pts
Total Points: 15