Here ha sample Listing of the Valley Mercantie Company's sales data from the most recent year in an etable im (Cick the icon to view the Excel Workshoot) For each of the situation isted below, Indicate whether a sorta Sher, or both simultaneously would be the most efficient way of getting the information needed for management indicate the cand the resorting Sering criteria (Note You do not need to perform the sort and in Excel in this even Situation 1. Management wants to send customers follow-up suwy about any order that the more than 10.000 Situation 2. Due to unutuly high return by Cameron Howells customers, management wants to and each order eed by Center wedi customers Situation Management wants to rank all the orders from aroma Situation Management wants a stof orders word hom target to smalt sales for cole Roston to can loow up with comes Data Table - sm Order # Product ID Date Sales Customer # Salesperson Amro, Wei 3425 3/30/2020 EM-770 $ 2,150 4694 sn 9276 9/1/2020 IF-484 $ 18,772 7393 Howell, Cameron 4908 3/29/2020 EG-133 $ 3,830 8141 Gerbig. Gracen Calvin, Frank 3548 4/3/2020 EM-770 $ 31.229 3799 5185 6/27/2020 FD-101 $ 1,509 5074 Harris, Gabriella 7000 7/3/2020 IF-302 $ 2.231 6074 Ross, Nicole 8393 8/4/2020 IF-484 $ 8.328 7362 Howell, Cameron est 5870 4/29/2020 TR-134 $ 1.884 5514 Ross Nicole Situation 1. Management wants to send customers G Camer orders Filter by Sales greater than $10,000 Filter by Sales, sort by Salesperson Filter by Salesperson = Cameron Howell Filter by Salesperson sort by Sales Sort by Sales Sort by Sales greater than $10 000 Sort by Salesperson Sort by Salesperson = Cameron Howell sorted