Practical: Microsoft Excel

Answer the questions accordingly

QUESTION $2$:

$(40$ marks$)$

$1\mathrm{.}1.$ Insert the following content starting at A$2$:

$1\mathrm{.}2.$ Bold all the headings

$1\mathrm{.}3.$ Calculate the final mark

$1\mathrm{.}4.$ Calculate the sum of Final Exam in cell F$9$

$1\mathrm{.}5.$ Calculate the average mark in F$9$ using the Exam Mark

$1\mathrm{.}6.$ Calculate the Maximum of Test $2$ in cell E$9$

$1\mathrm{.}7.$ Calculate the Minimum of Test $1$ in cell D$9$

$1\mathrm{.}8.$ Merge and Centre cells A$1-$ G$1$

$1\mathrm{.}9.$ Add a border around the edges of the table

$1\mathrm{.}10.$ Change the colour of each column to a different colour

$1\mathrm{.}11.$ Add the colour Blue accent $5$ lighter $60\%$ to the first row and label it Mark sheet $1$

$1\mathrm{.}12.$ Change the sheet name to Business Management

$1\mathrm{.}13.$ Change the Tab labelled Business Management colour to purple

$1\mathrm{.}14.$ Change the width of the columns accordingly

$1\mathrm{.}15.$ Change the marks to numbers, with no decimals

$1\mathrm{.}16.$ Insert a bar graph of your choice using the information from:

Exam mark

Final mark

The graph should show all labels