Use the spreadsheet extract to answer the questions

Required

Which of the following cells require the input of an actual value rather than a formula relating to another cell on the spreadsheet?Answer 1Choose...B15B16C10C7

Suggest a formula for the following:

D17; Answer 2Choose...=-B15 or =-C14*0.04=SUM(D14:D16)=D10 or =D7*B25=C17*B26 or =C17*$B$26=D7+B25=D10*D7

The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column.

E15: Answer 3Choose...=E10=SUM(B16:D16)=D15=B15=SUM(B10:D10)=D16=B16=SUM(B10:E10)=SUM(B15:D15)

E10: Answer 3Choose...=E10=SUM(B16:D16)=D15=B15=SUM(B10:D10)=D16=B16=SUM(B10:E10)=SUM(B15:D15)