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 persons sales that came from each
location. Create a PivotChart to summarize this information.
c. Summarize each girls sales by location and use the Report Filter to
change the calculations to include any subset of products.