Question $3(25$ marks$)$

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

AWESOME Computer Center

Profit Analysis

Perform the following tasks:

$($a$)$ Insert a main title and subtitle on the cell.

$($b$)$ 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.$

$[20$ marks$]$