Here is a sample listing of the Valley Mercantile Companys sales data from the most recent year

Question:

Here is a sample listing of the Valley Mercantile Company’s sales data from the most recent year in an Excel table.

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. Management wants to send customers a follow-up survey about any order that totaled more than $10,000.
2. Due to unusually high returns by Cameron Howell’s customers, management wants to audit each order placed by Cameron Howell’s customers.
3. Management wants to rank all the orders from largest to smallest sales.
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.