1. The Makeup2007.xlsx fi le (available for download on the companion website)

1. The Makeup2007.xlsx fi le (available for download on the companion website)

gives sales data for a small makeup company. Each row lists the salesperson,

product sold, location of the sale, units sold, and revenue generated. Use this

fi le to perform the following exercises:

a. Summarize the total revenue and units sold by each person of each

product.

b. Summarize the percentage of each person’s sales that came from each

location. Create a PivotChart to summarize this information.

c. Summarize each girl’s sales by location and use the Report Filter to

change the calculations to include any subset of products.