Hi this is computer in network society course. Help me solve this.

Question 3 [40 marks) Using the information given below, use Microsoft Excel to create a workbook called Profit Analysis Brawstar Computer Center Profit Analysis ITEM Unit Cost Unit Profit Unit (RM) (RM) Sold Microprocessor - 600Mhz Intel PII 230 70 32.000 Computer Cases - Full ATX Towers 200 50 25,000 Motherboard - Asus PIIB-F 290 100 42.000 Motherboard Memory - 128Mb PC100 SDRAM 3.3V 570 120 15,000 Sound Card ASUS XONAR US USB 220 80 19.500 Power Supply AX860i (PLATINUM) 500 200 10,000 Hard Drive - 16G 280 120 20,500 Graphics Card / PCI Express 16X ASUS 900 200 9,500 Perform the following tasks: (a) Insert a main title and subtitle on the cell. [1 mark] (b) Insert the Total sales in E3, Total profit in F3, % Total profit in 63, Totals in A12, Lowest A13, Highest A14 and Average A15. [7 marks] (c) Use the following formulas in cells E4, F4 and G4: (i) Total sales (cell E4) = Units sold (Unit cost + Unit profit) (ii) Total profit (cell F4) = Units sold Unit profit % Total profit (cell G4) = (Total profit/Total sales) 100 (Up to 2 decimal places) (iv) Use the fill handle to copy the three formulas in the range E4:G4 to the range E5:G11. [8 marks] (d) Determine the totals for the units sold, total sales, and total profit in row 12 using formula (Sum up the unit sold in 04:D11 in D12, the total sales in E4:E11 in E12, and the total profit in F4:F11 in F12). [12 marks] (e) In the range B13:B15, determine the lowest value, highest value, and average value, respectively, for the values in the range B4:B11. Use the fill handle to copy the three functions to the range C13:G15. Delete the average from cell G15, because an average of percentages of this type is mathematically invalid. [12 marks]