PSDT 3013 Lipscomb Units of Lip Gloss Did Zaret Sell During 2004 and 2005 Excel Task
Using the data in the file Makeupdb.xlsx (attached below), answer the following:
- How many units of lip gloss did Zaret sell during 2004 and 2005?
- Create a data table that contains each person’s total revenue and units sold.
- How many units of lip gloss did Colleen sell outside the West region?
- Using the data in the file Makeupdb.xlsx, create a data table that shows the average per-unit revenue generated by each person for sales in which the average per-unit price exceeded $3.30.
