MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

You can find the data for this chapter’s problems in the file Makeupsubtotals.xlsx. Use the Subtotal command for the following computations:

1. Find the units sold and revenue for each salesperson.

2. Find the number of sales transactions for each product.

3. Find the largest transaction (in terms of revenue) for each product.

4. Find the average dollar amount per transaction by region.

5. Display a breakdown of units sold and revenue for each salesperson that shows the results for each product by region.