Using the information given below, create a workbook called Profit Analysis.

XBOX Computer Center

Profit Analysis

ITEM Unit Cost

$($RM$)$

Unit Profit

$($RM$)$ Unit Sold

Microprocessor $-600$Mhz Intel PIII $1996522,000$

Computer Cases $-$ Full ATX Towers $2995015,000$

Motherboard $-$ Asus PIIIB$-$F

Motherboard $3999952,000$

Memory $-128$Mb PC$100$ SDRAM

$3\mathrm{.}3$V $57012535,000$

Sound Card ASUS XONAR U$5$ USB $2258019,500$

Power Supply AX$860$i $($PLATINUM$)59920011,000$

Hard Drive $-16$G $28012021,500$

Graphics Card $/$ PCI Express $16$X

ASUS $9002509,500$

Perform the following tasks:

i$.$ Insert a main title and subtitle on the cell. $[4$ mark$]$

ii$.$ Calculate the Total sales in E$3,$ Total profit in F$3,\%$ Total profit in G$3,$ Totals

in A$12,$ Lowest A$13,$ Highest A$14$ and Average A$15.[28$ marks