B F H 1 2 A B E G Summary of Sales for 22 June 2019 2 Product Sold Price (RM) Qty Sales Total (RM) Cost (RM) Gross Profit (RM) 3 Widget A 100 200.00 60.00 140.00 4 Widget B 120 4 480.00 100.00 380.00 5 Widget C 150 3 450.00 100.00 350.00 6 Widget D 300 6 1800.00 220.00 1580.00 7 Widget E 130 5 650.00 90.00 560.00 8 Widget F 89 7 623.00 50.00 573.00 9 4203.00 20.00 3583.00 10 103.33 1580.00 11 12 Based on the questions below, complete the table using formula in the respective cell. 13 14 i. Calculate the Gross Profit in cell F3 (2 marks). Copy formula from F3 to F8. (1 mark) 15 ii . Calculate Sales Total in cell 09. (2 marks) 16 iii. Calculate the highest Gross Profit and display it in cell F10. (2 marks) 17 iv. Calculate the average of COST for each (2 marks)sales and display them in Column E10. 18 v. Calculate the Total Gross Profit in cell F9. (2 marks) 19 vi. Calculate the Total Cost in cell E9. (2 marks) 20 21