Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer Filter by Sales greater than $10,000 Filter by Sales, sort by Salesperson Filter by Salesperson = Cameron Howell Filter by Salesperson, sort by
please answer
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 LE Sort by Sales greater than $10.000 Sort by Salesperson Sort by Salesperson = Cameron Howell No Sort by Sales Situation 2. Due to unusually high returns by Cameron Howell's Situation 3. Management wants to rank all the orders from large Situation 4. Management wants a list of orders sorted from large Here is a sample listing of the Valley Mercantile Company's sales data from the most recent year in an Excel table. BBB (Click the icon to view the Excel worksheet) 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. (Note: You do not need to perform the sorts and filters in Excel in this exercise.) EGERI Situation 1. Management wants to send customers a follow-up survey about any order that totaled more than $ 10 000 Sort by Sales Situation 2. Due to unusually high returns by Cameron Howell's customers, management wants to audit each order placed by Cameron Howell's customers Situation 3. Management wants to rank all the orders from largest to smallest sales, V Situation 4. Management wants a list of orders sorted from largest to smallest sales for Nicole Ross a salesperson, so that Ross can follow up with her top customers. Submit qui - X Data table Product ID Order Date Sales Customer Salesperson 3425 3/30/2020 EM-770 $ 2,150 4694 Amro, Wei Howell, Cameron 9276 9/1/2020 IF-484 $ 18,772 7393 4908 3/29/2020 EG-133 $ 3.830 8141 Gerbig, Gracen 3548 4/3/2020 EM-770 $ 31.229 3799 Calvin, Frank 15185 6/27/2020 FD-101 $ 1,509 5074 Harris Gabriella 7000 7/3/2020 IF-302 69 2.231 6074 Ross. Nicole Howell. Cameron 8393 8/4/2020 IF-484 S 8.328 7362 5870 4/29/2020 TR-134 % 1.884 5514 Ross Nicole ers Print DoneStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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