Assignment
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →
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.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds