Posted: July 10th, 2022



Don't use plagiarized sources. Get Your Custom Essay on
Just from $13/Page
Order Essay

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


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.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Live Chat 1 7633094299EmailWhatsApp

Order your essay today and save 20% with the discount code WELCOME