Question

Help with these Microsoft Office Excel questions..

Answer 1

HERE IS YOUR ANSWER

_____________________________


(i)
The following formula must be entered in B8

= MAX(B1:B7)

(ii)
The following formula must be entered in G2

= SUM(E2:F2)

(iii)
The following formula must be entered in E2

= B2 * C2

(iv)
The service tax can be calcukated using the following formula

= E2 * 20/100

_____________________________

THANK YOU