Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Kareem Merchandse has several warehouses for its inventory localed around the United States. The company's controller has imported its inventory recorits into Excel. The following
Kareem Merchandse has several warehouses for its inventory localed around the United States. The company's controller has imported its inventory recorits into Excel. The following is a sample of the table of irwentory records in that Excel fle. III (Cick the loon to view the Excel worksheet) For each of the situations listed below, incicale whether a sart, a filet, or both simultanecusly would be the most efficient way of geting the information needed for managernent indicale the column(s) and the related sorting andor fitering criana. (Note. You do not need to perform the sorts and fiters in Excel in this exerciso.) Situation 1, What iteme are in the Plocky River warehouse, listed in ltem if order? Situation 2. Which warehouses have hiem \& GR-113 in slock? List the warehouses in alphabefc order. Shuation 3. Which warehouses have invertory Hers wat a cost of mare than $3,0007 List the warehouses in alphabebc ocder Situation 4. What invertory tems in warnhouses in Callomia hwe a cost groater than 55,000 ? The inventory items should be fated in aiphabebc onder. 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 Situation 1. What items are in the Rocky River warehouse, listed in Item \# order? Situation 2. Which warehouses have Item \# GR-113 in stock? List the warehouses in alphabetic 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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