explain step by step please

E F G B H Enter your 8-digit StudentID below (cell B4) 1 2 3 Average Total Sales is automatically calculated for you Enter your 8-digit studenti +49159 Average Total Sales calculated In shaded box on the right $0.00 Average Total Sales 5 6 Salesperson qtr_1 Qtr_2 Qtr_3 atr. Total Sales Above Average Total Sales Bonus $0.00 $0.00 $0.00 $0.00 SUMIF(Ortri) 8 Brandon Villa 9 Elsie Blankenship 10 Aria Mack 11 David Brennan 12 Jane Hester 13 Enrique Price 14 Taylor Koch 15 Malaysia Compton 16 Dominick Shepherd 17 June Elliott 18 Damian Hampton 19 Amber Durham 20 21 22 23 24 25 4. Enter a SUMIF() formula in cell B9 (column heading: Qtr_1) to calculate the total sales for Quarter 1 for the salesperson in cell A9. Your formula should sum up all sales for the salesperson in cell A9 for Quarter 1 (Quarter 1 sales data is found in worksheet "Sales", column D). The salesperson in A9 may have a number of sales in Quarter 1. Your SUMIF formula should total all of these sales for the salesperson in A9. 5. Similarly, enter a SUMIF() formula in cell 09 (column heading: Qtr_2) to calculate the total sales for Quarter 2 for the salesperson in cell A9. 6. Similarly, enter a SUMIF() formula in cell D9 (column heading: Qtr_3) to calculate the total sales for Quarter 3 for the salesperson in cell A9. 7. Similarly, enter a SUMIF() formula in cell E9 (column heading: Qtr_4) to calculate the total sales for Quarter 4 for the salesperson in cell A9. 8. Finally, copy the formulas from cells B9 - E9 into cells B10 - E19 to find the sales for the salespersons in A10 - A19 (Quarters 1-4). Note: Do not overwrite the formula in cells B8-E8 (i.e., quarterly sales that are on the line where you are the salesperson). These cells have different calculation formulas that have been previously defined in the worksheet. 9. Enter a formula in cell F8 to calculate the fotal sales (.e., a summation of sales in Quarter 1 - Quarter 4). Copy this formula into cells F9-F19 to calculate total sales for each of the other salespersons. F E G A D B C Enter your 8-digit StudentID below (cell B4) Average Total Sales is automatically calculated for you w N 2 3 Enter your 8-digit studenti 23749159 Average Total Sales calculated in shaded box on the right $0.00 Average Total Sales 5 6 Above Average Bonus Salesperson Qtr_1 Qtr_2 Qtr_3 Qtr_2 Total Sales Total Sales 7 $0.00 $0.00 $0.00 $0.00 8 Brandon Villa 9 Elsie Blankenship 10 Aria Mack 11 David Brennan 12 Jane Hester 13 Enrique Price 14 Taylor Koch 15 Malaysia Compton 16 Dominick Shepherd 17 June Elliott 18 Damian Hampton 19 Amber Durham 20 21 22 23 24 25 Scenario 1 Scenario 2 Sales Salespersons + D C B E F H G 2 $0 $0 $0 $0 Third Ranked (s.value of Weekly Sales Automatically computed (after you enter formulas for Scenario 1) 5 Salesperson QU Qu_2 Qtr_3 Qt_4 Num. of Quarters Among Top 3 Total Sales Bonus Yes Yes Yes Yes Yes Yes Yes Yes * Yes Yes 8 Brandon Villa 9 Elle Blankenship 10 Aria Mack 11 David Brennan 12 Jane Hester 13 Enrique Price 14 Taylor Koch 15 Malaysia Compton 16 Dominick Shepherd 17 June Elliott 18 Damian Hampton 19 Amber Durham 20 21 22 23 24 25 26 27 28 29 30 31 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Yes Scenario 1 Scerrio 2 Sales Salespersons Ready G A C D E B F Product Quarter_3 1 Sale No Employee Quarter_4 Quarter_1 Quarter_2 Rootbeer $192.00 $1,832.00 $1,457.00 2 500712 Daniella Woods $1,935.00 3 S00713 Makayla Raymond Green Beans $2,040.00 $430,00 $2,220.00 $2,277.00 Holden Myers 4 S00714 Peas $2,157.00 $1,531,00 $1,625.00 $1,243.00 Mozzarella 5 S00715 Colby Stuart $2,164.00 $2,304.00 $2,034.00 $1,246.00 6 S00716 Kenneth Quinn Chocolate $1,940.00 $1,140.00 $2,273.00 $641.00 7 500717 Quinn Saunders Chai $758.00 $681.00 $1,059.00 $1,878.00 8500718 Khloe Key Walnuts $1,823.00 $1,605.00 $980.00 $1,972.00 9 500719 Claire Gonzalez Brownie Mix $1,056.00 *$265.00 $1,353.00 $2,368.00 10 S00720 Hope Kent Dried Apples $2,010.00 $2,120.00 $938.00 $1,657.00 11 S00721 Claire Gonzalez Fruit Cocktail $1,665.00 $1,988.00 $1,568.00 $894.00 12 S00722 Margaret Hobbs Chocolate $625.00 $472.00 $1,240.00 $585.00 13 S00723 Savanna Soto Peaches $1,522.00 $2,053.00 $2,274.00 $1,232.00 14 S00724 Kara Barker Olive Oil $2,090.00 $255.00 $1,898.00 $1,947.00 15 S00725 Knox Chan Green Tea $1,565.00 $295.00 $410.00 $1,810.00 16 500726 Albert Christian Rootbeer $1,210.00 $2,154.00 $1,160.00 $1,282.00 17 S00727 Savannah Stevenson Chai $943.00 $710.00 $624.00 $906.00 18 S00728 Odin Dunn Peas $464.00 $2,433.00 $477.00 $190.00 19 S00729 Elsa Brewer Tomato Sauce $2,447.00 $1,121.00 $1,777.00 $2,079.00 20 500730 Athena Torres Cream Corn $1,207.00 $1,271.00 $342.00 $2,116.00 21 S00731 Lacey Jacobson Green Beans $1,031.00 $437.00 $1,439.00 $1,885.00 22 500732 Jane Hester Potato Chips $1,334.00 $737.00 $2,469.00 $1,129.00 23 500733 Emerson Perkins Dried Plums $109.00 $1,516.00 $785.00 $2,484.00 24 S00734 Mohamed Downs Ravioli $801.00 $605.00 $1,427.00 $2,345.00 25 500735 Derrick Castro Cream Corn $1,591.00 $2,329.00 $1,672.00 $2,020.00 26 S00736 Hazel Rodriguez Fruit Cocktail $1,438.00 $769.00 $411.00 $51.00 27 S00737 Mya Roy Peas $985.00 $793.00 $1,598.00 $1,472.00 28 500738 Aaliyah Lloyd Marmalade $1,787.00 $1,209.00 $1,408.00 $2,499.00 29 500739 Albert Rosales Fruit Cocktail $1,958.00 5602.00 $1,892.00 $316.00 30 S00740 Ariella Sherman Walnuts $1,867.00 $2,073.00 $1,446,00 $1,792.00 31 S00741 Raylan Cantu Granola $503.00 $187.00 $1,630.00 $968.00 32 500742 Julianna Kerr Potato Chips $1,671.00 $2,074.00 $1,773.00 $962.00 33 500743 Elliot Ruiz Green Tea $314.00 $468.00 $970.00 $653.00 34 500744 Case Combs Granola $1,916.00 $2,227.00 $1,085.00 $2,494.00 35 500745 Amy Mcguire Peaches $1,576.00 $2,202.00 $1,455.00 $1,884.00 36 500746 Kylee Pruitt Green Beans $823.00 $1,884.00 $2,141.00 37 500747 $1,623.00 Aubrey Lloyd Tomato Sauce $597.00 $1,435.00 $2,436.00 $727.00 38 50749 Mateo Mavers Cream Corn $239200 $352.00 $1.530.00 $11.695.00 Scenario 1 Scenario 2 Sales Salespersons + 4. Enter a SUMIF() formula in cell B9 (column heading: Qtr_1) to calculate the total sales for Quarter 1 for the salesperson in cell A9. Your formula should sum up all sales for the salesperson in cell A9 for Quarter 1 (Quarter 1 sales data is found in worksheet "Sales", column D). The salesperson in A9 may have a number of sales in Quarter 1. Your SUMIF formula should total all of these sales for the salesperson in A9. 5. Similarly, enter a SUMIF() formula in cell 09 (column heading: Qtr_2) to calculate the total sales for Quarter 2 for the salesperson in cell A9. 6. Similarly, enter a SUMIF() formula in cell 09 (column heading: Qtr_3) to calculate the total sales for Quarter 3 for the salesperson in cell A9. 7. Similarly, enter a SUMIF() formula in cell E9 (column heading: Qtr_4) to calculate the total sales for Quarter 4 for the salesperson in cell A9. 8. Finally, copy the formulas from cells B9 - E9 into cells B10 - E19 to find the sales for the salespersons in A10 - A19 (Quarters 1-4). Note: Do not overwrite the formula in cells B8-E8 (i.e., quarterly sales that are on the line where you are the salesperson). These cells have different calculation formulas that have been previously defined in the worksheet. 9. Enter a formula in cell F8 to calculate the total sales (.e., a summation of sales in Quarter 1 - Quarter 4). Copy this formula into cells F9-F19 to calculate total sales for each of the other salespersons