25 of 28 (9 complete) From the most recent year in an Excel table. or n Data Table . a Order # Date Product ID Sales 3425 m 9276 3/30/2020 EM-770 $ 2,150 9/1/2020 IF-484 $ 18,772 3/29/2020 EG-133 h 3,830 4908 sm 3548 5185 4/3/2020 EM-770 $ 31 229 6/27/2020 FD-101 $ 1,509 7/3/2020 IF-302 $ 2.231 Customer # Salesperson 4694 Amro, Wei 7393 Howell, Cameron 8141 Gerbig, Gracen 3799 Calvin, Frank 5074 Harris, Gabriella 6074 Ross, Nicole 7362 Howell, Cameron 5514 Ross, Nicole 7000 sn 8393 8/4/2020 IF-484 $ 8,328 5870 4/29/2020 TR-134 $ 1,884 Print Done estion er la sample sting of the Valley Mercantile Company's data from the most recent year in an Click the icon to view the Excel workshet) For each of the stressed indicate whether or a hoboth day would be the most ucient way of getting the formation needed for management indicate the deated arting andler thering chia You do not need to perform the stand in Excel in this) Shustion 1. Management was to send customs oow.covey shout any conder that otated more than 10.000 Shustion 2 Dururumly wagh vatants by Cameron Howells cantonnagement was to put such ander placed by Cameron Hits customers Station 1. anagement wants to rank waarders from largest tomatest sales Shunion 4. Management ist es sorted from a water sales tax bicole Rossasalon chatou can tulos vut for the customers Helsing of the Valley Mean Company's data from the most recente Co the late Ercel worksheet) For each of the winted indicate whether or a while you be most cont way of getting the numaton for management indicate the cou) and the water ander eing criteria Note You do not need to perform the art and then train the Station 1. Management arts to send atomers a follow up survey about any rerut totaled more than 10.000 Situation 2. hy husby Cameron Howl's customers, management want to auf each ander placed by Caneten Howels customers Simion Management want to make the ones from largest o smallest Sution 4, Management was to order sted from largest to test for Nicole Rosentha Ross can foot with her tap customers