Link for File:

https://drive.google.com/open?id=1wtXOqSRKtxuj_ECHoMFNxwzOjj64KUKF

5 6 8 0 Backspace Insert HomePag Dc G H BISI 3250-80, Fall 2018 Quiz-2 Name: the The file Makeupdb.xlsx (under Chapter 43 sales of makeup prod - Practice Files) contains information about t ucts. For each transaction, you are given the following information Name of salesperson . Date of sale Product sold Units sold . Transaction revenue Locationn Create PivotTable to compile the following information: aThe average number ofsales transactions for each location. b For each location, the total revenue by year. Total number of transactions by each salesperson, broken down by product. Total revenue by location and year d Save the file as your name and submit in DropBox through eLearn