Please HELP

11. Use a function in cell B1 of the Questions 11 - 16 worksheet to answer the following question: What is the average number of Chiefs jerseys sold? Use another function in the same formula to round the results to two decimal places.

Figure Sense: What function will computer the average of only the Chiefs jerseys? What function will round the results to two decimal places? How can you use these functions to compute the result for the first cell? Can you check to make sure that you did this correctly?

B1 x fx K A B D E F G G H 1 J L M N O 1,128 1 11) 2 3 12) 4 5 13) 6 7 14) 8 9 15) 10 11 16) 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Orders States O Prices Discounts Questions 11 - 16 + O Ready + 100% N P R V w D 1 D 1 Order ID Salesperson Order Date Ship To State Name Region Product 2 MG1000 MG 1/1/21 9-UT-29 Utah West Teans Jersey 3 SP1003 ) Sp 1/1/21 4-WY-85 Wyoming West Buccaneers Jersey 4 SP1001 SP 1/1/21 2-ID-81 Idaho West 49ers Jersey 5 ST1000 TJ 1/1/21 2-IL-24 Illinois Central Dolphins Jersey 6 TJ1001 T TJ 1/1/21 1-C0-77 Colorado West Chiels Jersey 7 7 T11001 T 1/1/21 1-D-77 Colorado West Broncos Jersey 8 M61001 MG 1/2/21 9-TN-76 Tennessee Fast Panthers Jersey 9 SP1002 SP 1/2/21 2-KS-90 Kansas Central Broncos Jersey 10 SP1003 SP 1/2/21 5-MT-60 Montana West Packers Jersey 1. TJ1002 TJ 1/2/21 4-10-45 Idaho West Packers Jersey 12 MG1002 MG 1/3/21 1 VA 83 Virginia East Falcons Jersey 13 SP1004 SP 1/3/21 9-CA-15 Califomia West - Rams Jersey 14 SP1004 SP 1/3/21 9-CA-15 California West Jaguars Jersey 15 SP1004 SP 1/3/21 9-CA-15 California West Texans Jersey 16 SP1004 SP 1/3/21 9-CA-15 California West Dolphins Jersey 17 SP1004 SP 1/3/21 9 CA 15 California West Colts Jersey 18 T11003 TI 1/3/21 5-AR-37 Arkansas South Dolphins Jersey 19 MG1003 MG 1/4/21 1-TX-77 Texas South Chiefs Jersey 20 MG10:14 MG 1/4/21 Z-AK-77 Alaska West Falcons jersey 2T11004 T TJ 1/4/21 4-AK-24 Alaska West Packers Jersey 22 IMG1005 MG 1/5/21 7 AK 65 Alaska West Rams Jersey 23 T11005 TJ T 1/5/21 4-AL-13 Alabama South Patriots Jersey 24 T1005 TJ 1/5/21 4-AL-13 Alabama South Broncos Jersey 25 TI100 T 1/5/21 4-AL-13 Alabama South Seahawks lersey 26 T/1005 TU 1/5/21 4-AL-13 Alabama South Steelers Jersey 27 T11005 TJ 1/5/21 4 AL 13 Alabama South Rams Jersey 28 M61006 MG 1/5/21 8-MT-66 Montana West Chargers Jersey 29 IMG1007 MG 1/7/21 7-CA-93 California West Saints Jersey 30 SPipa SP 1/7/21 9-NE-10 Nebraska Central Chiefs Jersey 3. MG1000 MG 1/8/21 8-OR-65 Oregon West Panthers Jersey 32 MG1008 MG 1/8/21 8 OR 65 Oregon West Patriats Jersey 33 MG 1008 MG 1/8/21 8-OR-65 Oregon West Titans Jersey 34 MG1000 MG 1/8/21 8-01-65 Oregon West Vikings Jersey 35 MG 10018 MG 1/8/21 8-02-65 Oregon West Texans Jersey 36 SP1006 SP 1/10/21 8-KS-78 Kansas Central Chiefs Jersey 37 SP120G SP 1/10/21 8 KS 78 | Kareas Central Eagles Jersey 38 SP1005 SP 1/10/21 8-K5-78 Kansas Central Browns Jersey 39 TJ1006 1/12/21 5-WA-40 Washington West Patriots Jersey 40 SP1007 SP 1/14/21 5-WY-64 Wyoming West Chargers Jersey Orders States Prices Discounts Questions 11-16 H K L Quantity Price Discount % Total Team 1 $94.52 0% $84.52 Texans 2 $79.99 0% $159.98 Buccaneers B $99.95 10% $719.64 49ers 8 $85. Sa 10% $615.60 Dolphins 1 1 $99.95 0% $99.95 Chiels 2 $99.99 06 $179.99 Broncos 1 $52.89 0% $62.89 Panthers 3 3 $99.99 0% $269.97 Broncos 8 $10.99 10% $583.13 Packers 2 $80.99 0% $161.98 Packers 7 $95.99 106 $541.74 Falcons 6 $50.99 10% $329,35 Rams 1 1 $61.89 0% $61.99 Jaguars 2 $84.52 0% $169.04 Texans 1 1 $85.50 0% $85.50 Delphins 3 $70.99 5% $202.32 Colts 5 $85.50 10% $384.75 Dolphins 6 $99.95 10% $599.73 Chiefs 5 $85.99 10% $8.96 Falcons 3 $30.99 5% $230.82 Packers 1 $60.99 0 $60.99 Rams 1 $92.99 0% $92.99 Patriots 2 $99.99 0% $179.98 Broncos 15 $75.95 10% $341.78 Seahawks 1 1 $84.95 0% $84.95 Steelers 10 $60.99 20% $487.92 Rams 1 $89.25 0% $89.25 Chargers 1 $95.99 0% $95.99 Saints 4 $99.95 5% $379.81 chefs 3 $62.89 5% $179.24 Panthers 7 7 $92.99 10% $585.84 Patriots 9 $54.99 10% $52642 Titans 4 $92.89 5% $314.94 Vikings 4 $84.57 5% $321.18 Texans 2 $99.95 0% $199.90 Chiels 7 7 $76.99 10% $485.04 Eagles 7 7 $73.00 10% $459.30 Browns 7 $92.99 10% $585.94 Patriots 4 $89.25 5% $339.15 Chargers + Ready IC -- + 100% B1 x fx K A B D E F G G H 1 J L M N O 1,128 1 11) 2 3 12) 4 5 13) 6 7 14) 8 9 15) 10 11 16) 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Orders States O Prices Discounts Questions 11 - 16 + O Ready + 100% N P R V w D 1 D 1 Order ID Salesperson Order Date Ship To State Name Region Product 2 MG1000 MG 1/1/21 9-UT-29 Utah West Teans Jersey 3 SP1003 ) Sp 1/1/21 4-WY-85 Wyoming West Buccaneers Jersey 4 SP1001 SP 1/1/21 2-ID-81 Idaho West 49ers Jersey 5 ST1000 TJ 1/1/21 2-IL-24 Illinois Central Dolphins Jersey 6 TJ1001 T TJ 1/1/21 1-C0-77 Colorado West Chiels Jersey 7 7 T11001 T 1/1/21 1-D-77 Colorado West Broncos Jersey 8 M61001 MG 1/2/21 9-TN-76 Tennessee Fast Panthers Jersey 9 SP1002 SP 1/2/21 2-KS-90 Kansas Central Broncos Jersey 10 SP1003 SP 1/2/21 5-MT-60 Montana West Packers Jersey 1. TJ1002 TJ 1/2/21 4-10-45 Idaho West Packers Jersey 12 MG1002 MG 1/3/21 1 VA 83 Virginia East Falcons Jersey 13 SP1004 SP 1/3/21 9-CA-15 Califomia West - Rams Jersey 14 SP1004 SP 1/3/21 9-CA-15 California West Jaguars Jersey 15 SP1004 SP 1/3/21 9-CA-15 California West Texans Jersey 16 SP1004 SP 1/3/21 9-CA-15 California West Dolphins Jersey 17 SP1004 SP 1/3/21 9 CA 15 California West Colts Jersey 18 T11003 TI 1/3/21 5-AR-37 Arkansas South Dolphins Jersey 19 MG1003 MG 1/4/21 1-TX-77 Texas South Chiefs Jersey 20 MG10:14 MG 1/4/21 Z-AK-77 Alaska West Falcons jersey 2T11004 T TJ 1/4/21 4-AK-24 Alaska West Packers Jersey 22 IMG1005 MG 1/5/21 7 AK 65 Alaska West Rams Jersey 23 T11005 TJ T 1/5/21 4-AL-13 Alabama South Patriots Jersey 24 T1005 TJ 1/5/21 4-AL-13 Alabama South Broncos Jersey 25 TI100 T 1/5/21 4-AL-13 Alabama South Seahawks lersey 26 T/1005 TU 1/5/21 4-AL-13 Alabama South Steelers Jersey 27 T11005 TJ 1/5/21 4 AL 13 Alabama South Rams Jersey 28 M61006 MG 1/5/21 8-MT-66 Montana West Chargers Jersey 29 IMG1007 MG 1/7/21 7-CA-93 California West Saints Jersey 30 SPipa SP 1/7/21 9-NE-10 Nebraska Central Chiefs Jersey 3. MG1000 MG 1/8/21 8-OR-65 Oregon West Panthers Jersey 32 MG1008 MG 1/8/21 8 OR 65 Oregon West Patriats Jersey 33 MG 1008 MG 1/8/21 8-OR-65 Oregon West Titans Jersey 34 MG1000 MG 1/8/21 8-01-65 Oregon West Vikings Jersey 35 MG 10018 MG 1/8/21 8-02-65 Oregon West Texans Jersey 36 SP1006 SP 1/10/21 8-KS-78 Kansas Central Chiefs Jersey 37 SP120G SP 1/10/21 8 KS 78 | Kareas Central Eagles Jersey 38 SP1005 SP 1/10/21 8-K5-78 Kansas Central Browns Jersey 39 TJ1006 1/12/21 5-WA-40 Washington West Patriots Jersey 40 SP1007 SP 1/14/21 5-WY-64 Wyoming West Chargers Jersey Orders States Prices Discounts Questions 11-16 H K L Quantity Price Discount % Total Team 1 $94.52 0% $84.52 Texans 2 $79.99 0% $159.98 Buccaneers B $99.95 10% $719.64 49ers 8 $85. Sa 10% $615.60 Dolphins 1 1 $99.95 0% $99.95 Chiels 2 $99.99 06 $179.99 Broncos 1 $52.89 0% $62.89 Panthers 3 3 $99.99 0% $269.97 Broncos 8 $10.99 10% $583.13 Packers 2 $80.99 0% $161.98 Packers 7 $95.99 106 $541.74 Falcons 6 $50.99 10% $329,35 Rams 1 1 $61.89 0% $61.99 Jaguars 2 $84.52 0% $169.04 Texans 1 1 $85.50 0% $85.50 Delphins 3 $70.99 5% $202.32 Colts 5 $85.50 10% $384.75 Dolphins 6 $99.95 10% $599.73 Chiefs 5 $85.99 10% $8.96 Falcons 3 $30.99 5% $230.82 Packers 1 $60.99 0 $60.99 Rams 1 $92.99 0% $92.99 Patriots 2 $99.99 0% $179.98 Broncos 15 $75.95 10% $341.78 Seahawks 1 1 $84.95 0% $84.95 Steelers 10 $60.99 20% $487.92 Rams 1 $89.25 0% $89.25 Chargers 1 $95.99 0% $95.99 Saints 4 $99.95 5% $379.81 chefs 3 $62.89 5% $179.24 Panthers 7 7 $92.99 10% $585.84 Patriots 9 $54.99 10% $52642 Titans 4 $92.89 5% $314.94 Vikings 4 $84.57 5% $321.18 Texans 2 $99.95 0% $199.90 Chiels 7 7 $76.99 10% $485.04 Eagles 7 7 $73.00 10% $459.30 Browns 7 $92.99 10% $585.94 Patriots 4 $89.25 5% $339.15 Chargers + Ready IC -- + 100%