1. The Makeup.xlsx file 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 file 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.

Write all steps for each question please and give a comment if needed

Search Transaction number Name Date Product Units Drag fields between areas below: Y Filters Rows Dofor Layout Indato Columns Values Update ose able Search Units Dollars Location. More Tables... Drag fields between areas below: Y Filters Rows Defer Layout Update Columns Values Update Search Transaction number Name Date Product Units Drag fields between areas below: Y Filters Rows Dofor Layout Indato Columns Values Update ose able Search Units Dollars Location. More Tables... Drag fields between areas below: Y Filters Rows Defer Layout Update Columns Values Update