I do not know how to do this please help. The quarterly profits list keeps going down all the way to the 624 for B,C,D,E (so it goes to B624,C624, D624,E624) but i figured that the first 50 cells would be enough information to help show me the what i should be doing

G H MN 0 1 2 4 5 6 7 The table below shows the quarterly profits of 150 salespersons in three different regions (East, South, and West). Use the data to complete items below. I already created the cell ranges salesperson and profits for you. A-for each salesperson, calculate annual profits using quarterly profits. Use SUMIF function B- Sort the data by annual profit in descending order and assign each salesman an overall rank, so that the salesman with the highest profit is ranked 1 1 and the second highest score is ranked 2, etc. (You could also use a RANK.EQ function) C-Use VLOOKUP to assign each salesperson to a quintile based on his or her rank, using the data in the Quintiles table. part c. (Recall that you with each salesperson to a quintille based on his or her rank. The results should match the obtained when completing to . part c. (Recall that you will need n-1 IF statements, where n-tt of categories). 9 10 11 12 13 14 15 16 17 19 19 20 21 22 23 E. Use VLOOKUP to find the annual profits, overall rank, and quintile for the three salespersons listed in the table. F. Use AVERAGEIFS to calculate the average annual prolits of salespersons for a given quintile and region. Use AVERAGEIF to cakulate the average annual protits of salespersons within a given quintile (Qtl 1, Qt1 2, etc.) Quarterly Profits Quintiles Annual Profits (A) SUMIF (B) RANKE (C) VLOOKUP C Annual Overall Rank Overall Profits Quintile (DIT Overall Quintile Quarter Salesperson Profits Region Salesperson Overall Rank Quintile Name 1 2 0 31 61 3 atli QUI 2 Otis atl 4 otis 4 91 121 1 2 3 4 VUOUP Region 24 25 West 26 West 27 West 20 West 29 West 30 West 31 West 32 West 33 South 34 South 35 South 36 South 37 West 38 West 39 West 40 West 41 East East Part() Annual Profils Overall Quintile Overall Rank 1 2 2 3 3 4 1 2 Adsit, Donald Adsit, Donald Adsit, Donald Adsit, Donald Armstrong, Pau Armstrong, Pau Armstrong, Pau Armstrong, Pau Arnald, Farris Arnald, Farris Arnald, Farris Arnald, Farris Barkley, Jared Barkley, lared Barkley, lares Barkley, lares Barry, Molly Barry, Molly Barry, Molly Barry, Molly Bexley, Grittin Bexley Grittin , Bexley, Grittin Bexley, Griffin Bishop, Andrev Bishop, Andrey $5,876.00 $6,542.00 $0.900.00 1$330.00) 19512.00) $6,523.00 $1,475.00 $7,350.00 $883.00 $7,569.00 $2,232.00 $1.290.00 $198.00 $4,096.00 $7,063.00 $2,495.00 $4,511.00 $1,892.00 $8.955.00 $2A88.00 $9,823.00 $41.00) $1,150.00 $5.979,00 $8 536.00 $2,001.00 Chambers, Dwayne Kael, Banca Blank, Tomi West West South West Cast West West South South East West East South West South South East East West West East West South East East South Adeit, Donald Armstrong, Paul Arnold, Farris Barkley, Jared Barry, Molly Bexley, Griffin Bishop, Andrew Blvins, Amelia Black, Melinda Blaissell, Jonathan Blank, Tomi Blount, Banca Bollinger, Cameron Brayman, Valauna Brittain, Armelle Bryant, Christofer Carter, Charmeca Chambers, Dwayne Channell, Jarrod Chapman, Rebecca Cline, Troy Cooper, Christofer Cory, Bennett Culberson, Phillip Currey, Bennett Delehman, Kate 3 4 AVERAGEIFS AVERAGEIF 1 2 West Overall east 4 1 2 East West West 47 West 48 West 49 West 50 West Part(F) East South Ot1 Oti 2 Otis Ot14 Ot15 Be careful with your use of cell references here! 3 4 1 2 G H MN 0 1 2 4 5 6 7 The table below shows the quarterly profits of 150 salespersons in three different regions (East, South, and West). Use the data to complete items below. I already created the cell ranges salesperson and profits for you. A-for each salesperson, calculate annual profits using quarterly profits. Use SUMIF function B- Sort the data by annual profit in descending order and assign each salesman an overall rank, so that the salesman with the highest profit is ranked 1 1 and the second highest score is ranked 2, etc. (You could also use a RANK.EQ function) C-Use VLOOKUP to assign each salesperson to a quintile based on his or her rank, using the data in the Quintiles table. part c. (Recall that you with each salesperson to a quintille based on his or her rank. The results should match the obtained when completing to . part c. (Recall that you will need n-1 IF statements, where n-tt of categories). 9 10 11 12 13 14 15 16 17 19 19 20 21 22 23 E. Use VLOOKUP to find the annual profits, overall rank, and quintile for the three salespersons listed in the table. F. Use AVERAGEIFS to calculate the average annual prolits of salespersons for a given quintile and region. Use AVERAGEIF to cakulate the average annual protits of salespersons within a given quintile (Qtl 1, Qt1 2, etc.) Quarterly Profits Quintiles Annual Profits (A) SUMIF (B) RANKE (C) VLOOKUP C Annual Overall Rank Overall Profits Quintile (DIT Overall Quintile Quarter Salesperson Profits Region Salesperson Overall Rank Quintile Name 1 2 0 31 61 3 atli QUI 2 Otis atl 4 otis 4 91 121 1 2 3 4 VUOUP Region 24 25 West 26 West 27 West 20 West 29 West 30 West 31 West 32 West 33 South 34 South 35 South 36 South 37 West 38 West 39 West 40 West 41 East East Part() Annual Profils Overall Quintile Overall Rank 1 2 2 3 3 4 1 2 Adsit, Donald Adsit, Donald Adsit, Donald Adsit, Donald Armstrong, Pau Armstrong, Pau Armstrong, Pau Armstrong, Pau Arnald, Farris Arnald, Farris Arnald, Farris Arnald, Farris Barkley, Jared Barkley, lared Barkley, lares Barkley, lares Barry, Molly Barry, Molly Barry, Molly Barry, Molly Bexley, Grittin Bexley Grittin , Bexley, Grittin Bexley, Griffin Bishop, Andrev Bishop, Andrey $5,876.00 $6,542.00 $0.900.00 1$330.00) 19512.00) $6,523.00 $1,475.00 $7,350.00 $883.00 $7,569.00 $2,232.00 $1.290.00 $198.00 $4,096.00 $7,063.00 $2,495.00 $4,511.00 $1,892.00 $8.955.00 $2A88.00 $9,823.00 $41.00) $1,150.00 $5.979,00 $8 536.00 $2,001.00 Chambers, Dwayne Kael, Banca Blank, Tomi West West South West Cast West West South South East West East South West South South East East West West East West South East East South Adeit, Donald Armstrong, Paul Arnold, Farris Barkley, Jared Barry, Molly Bexley, Griffin Bishop, Andrew Blvins, Amelia Black, Melinda Blaissell, Jonathan Blank, Tomi Blount, Banca Bollinger, Cameron Brayman, Valauna Brittain, Armelle Bryant, Christofer Carter, Charmeca Chambers, Dwayne Channell, Jarrod Chapman, Rebecca Cline, Troy Cooper, Christofer Cory, Bennett Culberson, Phillip Currey, Bennett Delehman, Kate 3 4 AVERAGEIFS AVERAGEIF 1 2 West Overall east 4 1 2 East West West 47 West 48 West 49 West 50 West Part(F) East South Ot1 Oti 2 Otis Ot14 Ot15 Be careful with your use of cell references here! 3 4 1 2