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

Question:

Here is a sample of the Kent 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 Rupert Webster’s customers, management wants to audit each order placed by Rupert Webster’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 Dolly Lopez, a salesperson, so that Lopez can follow up with her top customers. What is the dollar amount of the largest sale by Lopez? The dollar amount of the smallest sale by Lopez? What is the total of the sales made by Lopez? How many different orders were placed by Lopez’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.