Computation percent of the quota of sales and raking on profitability

1. Import the Sale Rep List.csv into a worksheet.

2. Create a List of the data

3. Add three more fields

a.Percent of Quota - calculate what percent of the quota has been met with current sales

b. Rank - Use a function to look up in a rank table for the percent of Quota and return the correct rank. create a Rank Table in the worksheet

Percent Rank
90% 1
80% 2
60% 3
0% 4

c. Bonus - Use a function that will give the sales rep $5000 if their Rank is 1 and their District is either 1 or 2.