G M O P N (20pts) Make a Pivot Table in a new sheet. Answer the following questions based off the pivot table. Enter your answers in the yellow cell. 1. Which store made the highest sales revenue? 2. Which item was sold the less? 3. Which store made the highest profit in 4th quarter? 4. How many Apple iPhone were sold in total? A B C 1 Profit = Revenue - Expenses 2 $ 1,000 $ 2,000 $ 1,000 3 $ 1,000 $ 2,200 $ 1,200 4 $ 200 $ 1,800 $ 1,600 5 $ 300 $ 2,600 $ 2,300 6 $ 620 $ 1,500 $ 880 7 $ 1,000 $ 1,700 $ 700 8 $ 540 $ 1,200 $ 660 9 $ 900 $ 2,000 $ 1,100 10 $ 1,600 $ 3,000 $ 1,400 11 $ 1,700 $ 3,200 $ 1,500 12 $ 1,500 $ 2,800 $ 1,300 13 $ 1,900 $ 3,600 $ 1,700 14 $ 1,100 $ 2,200 $ 1,100 15 $ 1,100 $ 2,300 $ 1,200 16 $ 900 $ 1,900 $ 1,000 17 $ 1,300 $ 2,700 $ 1,400 18 $ 600 $ 1,000 $ 400 19 $ 700 $ 1,200 $ 500 20 $ 500 $ 800 $ 300 21 $ 900 $ 1,600 $ 700 22 $ 400 $ 700 $ 300 23 $ 500 $ 800 $ 300 24 $ 300 $ 500 $ 200 25 $ 700 $ 1,200 $ 500 26 $ 1,000 $ 2,000 $ 1,000 27 $ 900 $ 2,100 $ 1,200 28 $ 200 $ 1,800 $ 1,600 29 $ 400 $ 2,700 $ 2,300 30 $ 620 $ 1,500 $ 880 31 $ 900 $ 1,600 $ 700 32 $ 540 $ 1,200 $ 660 33 $ 1,000 $ 2,100 $ 1,100 D E 3 Stores 2 Products Queens Samsung Queens Samsung Queens Samsung Queens Samsung Queens Apple iPhone Queens Apple iPhone Queens Apple iPhone Queens Apple iPhone Brooklyn Samsung Brooklyn Samsung Brooklyn Samsung Brooklyn Samsung Brooklyn Apple iPhone Brooklyn Apple iPhone Brooklyn Apple iPhone Brooklyn Apple iPhone Bronx Bronx Bronx Samsung Bronx Samsung Bronx Apple iPhone Apple iPhone Bronx Apple iPhone Bronx Apple iPhone Queens Samsung Queens Samsung Queens Samsung Queens Samsung Queens Apple iPhone Queens Apple iPhone Queens Apple iPhone Queens Apple iPhone F 4 Quarters 4th 2nd 3rd 1 st 4th 2nd 3rd 1st 4th 2nd 3rd 1 st 4th 2nd 3rd 1 st 4th 2nd 3rd 1st 4th 2nd 3rd 1 st 4th 2nd 3rd 1 st 4th 2nd 3rd 1 st Samsung Samsung Bronx