Karen Merchandise has several warehouses for its inventory located around the United States The company's controller has imported its inventory records into Excel. The following is a sample of the table of inventory records in (Click the icon to view the Excel worksheet) that Excelle For each of the situations listed below, indicate whether a sort, a fter, or both simultaneously would be the most efficient way of getting the information needed for management Indicate the columns) and the related sorting and/or hering criteria (Note: You do not need to perform the sorts and hers in Excel in this exercise) Data table - X Date purchased Quantity Cost Warehouse ID State Situation 1. What Rems are in the Rock 12/200019 50 % 3.450 Pho 36-470 1/30/2019 100 4.500 Forest MI Suation 2. Which warehouses have te GR-113 12/29/2019 700 10 650 Oakland CA DT-3311 2/17/2019 670 3200 Rocky River O 87-421 4/3/2018 2006 150 Condel GA Situation 3. Which warehouses have in GR-113 11/5/2019 530 S 8010 Ft H MI OT-331 1250019 270 5 300 Forest S Situation 4. What inventory arms in w JB-476 560018 276 6200 Santa Clar CA abetic order EM-964 732019 150 $ 500 Racky River OH Next Kareem Merchandise has several warehouses for its inventory located around the United States. The company's controller has imported its inventory records into Exc Situation 1. What items are in the Rocky River warehouse, listed in Item # order? Filter Cost for greater than $3,000 and filter Warehouse ID alphabetically Filter Cost for greater than $3,000 and filter Warehouse ID by location Filter Cost for greater than $3,000 and sort Warehouse ID alphabetically Filter inventory items by state to only include Ohio and then sort by date Filter Item # for GR-113 only and sort Warehoue ID alphabetically Filter Item # for RT-923 only and sort Warehoue ID alphabetically Filter state to include only CA, filter cost greater than $5,000, and sort in alphabetical order Filter state to include only OH, filter cost greater than $5,000, and sort in alphabetical order Filter Warehouse ID for Rocky River only and sort Item # alphabetically der be listed in alphabetic order. arehouses in date order. Kareem Merchandise has several warehouses for its inventory located around the United States. The company's controller has imported its inventory records into Excel. The following is a sample of the table of inventa Situation 1. What items are in the Rocky River warehouse, fisted in Item # order? Situation 2. Which warehouses have Item # GR-113 in stock? List the warehouses in alphabetic order Situation 3. Which warehouses have inventory items with a cost of more than 53.0007 List the warehouses in alphabetic order Situation 4. What inventory Bems in warehouses in Califormia have a cost greater than $5,000? The inventory items should be listed in alphabetic order Situation 5. What are the oldest inventory items in the warehouses in Ohio? Prepare a list of inventory items in the Ohio warshouses in date order