A B B F G H Data given below belongs to a store selling consumer electronics. It includes name of the salesperson, sales quarter, 1 product type, and number of sales. a. Highlight with blue color each salesperson's name whose sales for any kind of product is greater than 60 and less 2 than 90 by using conditional formatting. (10p) b. Use the data given below to create a Pivot Table that shows the sum of sales and number of sales for each 3 salesperson and each product. Please create your Pivot Table somewhere in the existing Excel sheet. (15p) c. Assume that cost of the products are $300 and selling price of the products are $500. Use calculated field to create 4 a column called "Profit". Hint: (profit=revenue-cost) (10p) 5 6 7 8 9 10 11 Quarter 1 2 3 4 Nm N 2 4 2 1 3 3 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Salesperson Nil Selin Yaman Yaman Yaman Deniz Deniz Deniz Nil Bar Baris Bar Selin Selin Nil Bar Nil Selin Bar Deniz Bar Selin Selin Product Television Television Computer Television Computer Phone Television Phone Computer Television Phone Computer Television Phone Phone Television Computer Computer Television Phone Phone Television Phone Sales 50 90 95 52 95 50 95 63 98 56 96 73 50 99 56 76 85 76 58 95 57 95 89 1 4 3 N N w 28 NNN mm 2 2 4 2 4 3 3 29 30 31