Type the formula to calculate the AVERAGE Maths score.

Type the formula the user applied to calculate the Actual Cost TOTAL in cell C9

How did the user calculate the difference for costumes in cell D9?

If the ‘Actual Cost’ of costumes in cell C3 was changed to £290,

what three other cells would change automatically?

What simple calculation has the user entered to calculate the difference between highest and lowest

What symbol separate the first cell and last cell in a cell range?

There is something missing from the following IF AND formula

=IF(AND(A1>10,B1>200,”Pass”, Fail”)

Can you write out the formula correctly?