Question $3$

$(20$ marks$)$

Write an MS Excel Functions or formulae for each of the measures described below: $($Hint use cell reference or address$)$

a$)$ The result of the increase if B$3$ is increased by $4\%.$

b$)$ The fifth root of the value in G$4$

$(2$ marks$)$

c$)$ The simple interest, given the principal, annual rate and number of years in cells D$4,$ D$5$ and D$6$ respectively.

$(2$ marks$)$

d$)$ The statistical range of values in cells C$3$ to D$10$ raised to the power of the mode score in the same set of cells.

e$)$ Decrease cell F$3$ by $8\%.$

$(3$ marks$)$

f$)$ Take the square root of the quarter of cell L$4$ and then multiply the result by $20$

$(2\mathrm{.}5$ marks$)$

g$)$ Subtract the mode of B$3$:B$15$ from the square of F$8$

$(2$ marks$)$

h$)$ Calculate the value of one standard deviation above the mean, given the mean in cell A$4$ and the standard deviation in cell H$3.$

$(2\mathrm{.}5$ marks$)$

i$)$ An IF$()$ statement $($only one IF$()$ statement$)$ to display the text 'Cancel', if the salary in cell P$3$ is less that the amount in B$4,$ otherwise it should calculate $20\%$ of the salary.

$(3$ marks$)$