$4\mathrm{.}1$ Retrieve the document you saved as SPRING CONCERT.

$4\mathrm{.}2$ Change QUESTION $3$ in the footer to QUESTION $4.$

$4\mathrm{.}3$ Insert the header Passionate about spring in capital letter, bold, italics and centre.

$4\mathrm{.}4$ Make all the changes as indicated on the spreadsheet and according to the instructions

below.

$4\mathrm{.}5$ Change the paper orientation to landscape.

$4\mathrm{.}6$ Insert rows, columns and text as indicated on the spreadsheet.

$4\mathrm{.}7$ Insert formulae where the letters of the alphabet appear to do the following calculations:

A$.$ AMOUNT $=$ GUESTS multiplied by DAYS multiplied by LUNCH $($use absolute cell address$)$

B$.$ VAT $15\%=15\%$ of AMOUNT $($use absolute cell address$)$

C$.$ TOTAL AMOUNT $=$ The sum of AMOUNT and VAT $15\%$

D$.$ TOTAL $=$ TOTAL of each column

E$.$ HIGHEST TOTAL AMOUNT

F$.$ AVERAGE of GUESTS

$4\mathrm{.}8$ Copy the formulae to the other cells as indicated on the spreadsheet.

$4\mathrm{.}9$ Display AMOUNT, VAT $15\%,$ TOTAL AMOUNT and HIGHEST as currency with TWO decimals.

$4\mathrm{.}10$ Display TOTAL of DAYS and GUEST as well as AVERAGE as integers.

$4\mathrm{.}11$ Insert horizontal lines as indicated using the method with which you are familiar.