Assignment
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.
You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.
Latest completed orders:
| # | topic title | discipline | academic level | pages | delivered |
|---|---|---|---|---|---|
|
6
|
Writer's choice
|
Business
|
University
|
2
|
1 hour 32 min
|
|
7
|
Wise Approach to
|
Philosophy
|
College
|
2
|
2 hours 19 min
|
|
8
|
1980's and 1990
|
History
|
College
|
3
|
2 hours 20 min
|
|
9
|
pick the best topic
|
Finance
|
School
|
2
|
2 hours 27 min
|
|
10
|
finance for leisure
|
Finance
|
University
|
12
|
2 hours 36 min
|
