Kareem Merchandise has several warehouses for its inventory located around the United States. The companys controller has

Question:

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 inventory records in that Excel file.

For each of the situations listed below, indicate whether a sort, a filter, or both simultaneously would be the most efficient way of getting the information needed for management. Indicate the column(s) and the related sorting and/or filtering criteria.

1. What items are in the Rocky River warehouse, listed in Item # order?
2. Which warehouses have Item # GR-113 in stock? List the warehouses in alphabetic order.
3. Which warehouses have inventory items with a cost of more than $3,000? List the warehouses in alphabetic order.
4. What inventory items in warehouses in California have a cost greater than $5,000? The inventory items should be listed in alphabetic order.
5. What are the oldest inventory items in the warehouses in Ohio? Prepare a list of inventory items in the Ohio warehouses in date order.