Here is a sample listing of the Valley Mercantile Company's sales data from the most recent year in an Excel table. (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.) Situation 1. Management wants to send customers a follow-up survey about any order that totaled more than $10,000. 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. 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.