Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer this question ASAP. & provide the correct function to use. G E F H In Chap 21 w.mad how to use the SUMF,
Please answer this question ASAP. & provide the correct function to use.
G E F H In Chap 21 w.mad how to use the SUMF, SU MIPS, AVERAGBIF, and AVERAGES Runctions. 2. The class worked in the campus cafe over a period of time selling any drinks, free class, sandwiches, donuss, and bubble 3wing the functions, atswer the questions below based on the datable boinning in Row 38. (20 points) How many units and dollars were sold of each Product below? Peedus 2 donuts www which 10 butik 1 raw 2 3 Dating the Average Della id by each person? SA 26 J 27 AM 8 Dard 9 What were the Total Unibe for the person and product listed below Product daus 24 Cain anary drink 5 16 What were the Total Dallan uld in May 21/2017 27 Tool Ballas May 22.30 25$ IT $ 10 3.00 258.75 78.75 120.00 34121 95$ als 2 $ 10 What were the total Units sold by people with name containing only 4chandiera? 12 4cheats 4 What were the Average Dallan sold of Product that started with the late E? 15 La Dollars 16 Starts with 7 18 D 19 420 donuta 30 2 luni v 2 bubbia Em 1 3 San 22521 recent coffee 32 4 Cain 5229 donuts 13 Annika 1921 domate 8 Min 11/21/1999 andwiches 35 7 Chad 32121 g dwiches 36 a Grace 121919 donuts 37 9 Cha 715-20 gadwich 18 10 dana 120 donuta 19 11 Kathy 112220 energy drink 50 12 Bridge 11/19 donut 13 Andra 83119 dont 2 14 Danid 11/1999 dwiches 3 1 cawy 22019 bubblata 18 Jake 4129 margy drinka 55 4329 energy drink 56 18 Alec 83/19 donuts 57 19 din tor2N21 andwiches 58 20 June 11/21/21 donut 9 21 Mega 6221 megy drink 50 22 Jauh 22421 gandwiches 31 23 Austin 21/21 egy drink 2 24 Avon 5221 bubble 3 25 Anne 1/7/21 wergy drink 23 Joph 1299 donut ES 27 din 4/12/21 free them 96 28 Kailyn 2122 20 bubble 23 El 10/2919 bubble 8 30 Son 119 bubble 9 31 din 19 donut 0 32 Annika 32520 donuts 33 Min 1920 energy drink 34 Chad 2019 nergy drinka 3 35 G 122019 bubble 14 > Chades 21 donuta "S 31 dan W ndwiches 76 33 Kathryn | 14/2 Eugela ba 27 Bridge 22320 bubblatan 8 40 Aledra 62421 bubble 19 41 Dand 2021 9 dwiches 30 wy 409 energy drink 4/19 bubble 32 Myan 689 donuts 3 45 Alaca 2019 donut 43 Calin 2220 nergy drinka ES 41 LETE 24999 andwiches Q1 Q3 14 5 39 $ T$ 27 $ T2 $ 87 $ 298 9 $ ar $ 20$ 95 375 33 $ 2$ 50 $ $ Ta $ 57 $ 80 $ 23 $ $ 12 $ 9 $ 53 $ 25$ 81 $ GS 743 23 $ 21 $ 12 $ 17 $ 9 $ 75 $2$ 41 $ 35 $ 23 112.50 91.50 4125 195.00 33.75 90.00 382.75 345.00 140.00 217.50 12.50 50.25 4.25 95.00 253.50 125.00 445.00 105.00 97.50 2137 400.00 115,00 210.00 18.00 1125 1572 50 62.50 405.00 7.50 314.50 145.00 105.00 80.00 72 25 170.00 3.00 65.00 5128 37.50 101200 Q2 24 Q5 G E F H In Chap 21 w.mad how to use the SUMF, SU MIPS, AVERAGBIF, and AVERAGES Runctions. 2. The class worked in the campus cafe over a period of time selling any drinks, free class, sandwiches, donuss, and bubble 3wing the functions, atswer the questions below based on the datable boinning in Row 38. (20 points) How many units and dollars were sold of each Product below? Peedus 2 donuts www which 10 butik 1 raw 2 3 Dating the Average Della id by each person? SA 26 J 27 AM 8 Dard 9 What were the Total Unibe for the person and product listed below Product daus 24 Cain anary drink 5 16 What were the Total Dallan uld in May 21/2017 27 Tool Ballas May 22.30 25$ IT $ 10 3.00 258.75 78.75 120.00 34121 95$ als 2 $ 10 What were the total Units sold by people with name containing only 4chandiera? 12 4cheats 4 What were the Average Dallan sold of Product that started with the late E? 15 La Dollars 16 Starts with 7 18 D 19 420 donuta 30 2 luni v 2 bubbia Em 1 3 San 22521 recent coffee 32 4 Cain 5229 donuts 13 Annika 1921 domate 8 Min 11/21/1999 andwiches 35 7 Chad 32121 g dwiches 36 a Grace 121919 donuts 37 9 Cha 715-20 gadwich 18 10 dana 120 donuta 19 11 Kathy 112220 energy drink 50 12 Bridge 11/19 donut 13 Andra 83119 dont 2 14 Danid 11/1999 dwiches 3 1 cawy 22019 bubblata 18 Jake 4129 margy drinka 55 4329 energy drink 56 18 Alec 83/19 donuts 57 19 din tor2N21 andwiches 58 20 June 11/21/21 donut 9 21 Mega 6221 megy drink 50 22 Jauh 22421 gandwiches 31 23 Austin 21/21 egy drink 2 24 Avon 5221 bubble 3 25 Anne 1/7/21 wergy drink 23 Joph 1299 donut ES 27 din 4/12/21 free them 96 28 Kailyn 2122 20 bubble 23 El 10/2919 bubble 8 30 Son 119 bubble 9 31 din 19 donut 0 32 Annika 32520 donuts 33 Min 1920 energy drink 34 Chad 2019 nergy drinka 3 35 G 122019 bubble 14 > Chades 21 donuta "S 31 dan W ndwiches 76 33 Kathryn | 14/2 Eugela ba 27 Bridge 22320 bubblatan 8 40 Aledra 62421 bubble 19 41 Dand 2021 9 dwiches 30 wy 409 energy drink 4/19 bubble 32 Myan 689 donuts 3 45 Alaca 2019 donut 43 Calin 2220 nergy drinka ES 41 LETE 24999 andwiches Q1 Q3 14 5 39 $ T$ 27 $ T2 $ 87 $ 298 9 $ ar $ 20$ 95 375 33 $ 2$ 50 $ $ Ta $ 57 $ 80 $ 23 $ $ 12 $ 9 $ 53 $ 25$ 81 $ GS 743 23 $ 21 $ 12 $ 17 $ 9 $ 75 $2$ 41 $ 35 $ 23 112.50 91.50 4125 195.00 33.75 90.00 382.75 345.00 140.00 217.50 12.50 50.25 4.25 95.00 253.50 125.00 445.00 105.00 97.50 2137 400.00 115,00 210.00 18.00 1125 1572 50 62.50 405.00 7.50 314.50 145.00 105.00 80.00 72 25 170.00 3.00 65.00 5128 37.50 101200 Q2 24 Q5Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started