2024 – 1 The Makeup2007 xlsx fi le available for download on the companion website gives sales data for

 

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.