Here is a sample of the Maxwell Mercantile Companys sales data from the most recent year. Access

Question:

Here is a sample of the Maxwell Mercantile Company’s sales data from the most recent year. Access the full data set online in the MyLab Accounting exercise.

Create a table in the Excel file provided in MyLab Accounting. Sort and filter that table to answer the following questions. Add dynamic column subtotals where needed.

1. Management wants to send customers a follow-up survey about any order that totaled more than $10,000. How many orders total more than $10,000?
2. Due to unusually high returns by Rosemary Laurel’s customers, management wants to audit each order placed by Rosemary Laurel’s customers. How many orders will need to be audited?
3. Management wants to rank all the orders from largest to smallest sales. What is the sales dollar amount of the largest order? What is the sales dollar amount of the smallest order?
4. Management wants a list of orders sorted from largest to smallest sales for Joanna Howard, a salesperson, so that Howard can follow up with her top customers. What is the dollar amount of the largest sale by Howard? The dollar amount of the smallest sale by Howard? What is the total of the sales made by Howard? How many different orders were placed by Howard’s customers?
5. In an effort to cross-sell to midsize customers, management is targeting customers whose orders range from $5,000 and $10,000. Make a list of these customers and their orders, listed alphabetically by salesperson.