Question

You have been asked to create a report that lists all corporate customers and all orders that they have placed. The customers should be listed alphabetically beginning with the letter 'a', and their corresponding order totals should be sorted from the highest amount to the lowest amount. Which of the following statements should you issue?

a) "Sort customers by name in ascending order and orders by amount in descending order."
b) "Sort customers by name in descending order and orders by amount in ascending order."
c) "Arrange customers by order totals in ascending order and orders by name in descending order."
d) "Arrange customers by order totals in descending order and orders by name in ascending order."

Answer 1

To create the desired report, issue the statement "Arrange customers by order totals in descending order and orders by name in ascending order." This statement ensures that the customers are listed alphabetically and their corresponding order totals are sorted from highest to lowest.

Step-by-step explanation:

To create a report that lists all corporate customers and their corresponding order totals, you should issue the statement "Arrange customers by order totals in descending order and orders by name in ascending order."

This means that the customers should be listed alphabetically, starting with the letter 'a', while their order totals should be sorted from highest to lowest. The statement specifies the correct order for both the customers and their corresponding order totals.

For example, let's say we have three customers: Amy, Dale, and Nancy. Amy has placed 3 orders with order totals of $100, $150, and $200; Dale has placed 2 orders with order totals of $50 and $300; and Nancy has placed 4 orders with order totals of $250, $100, $200, and $150. The report should list the customers in the following order: Amy, Dale, Nancy. And within each customer, the order totals should be sorted from highest to lowest.