Task 6

To find the Highest Sale,use the formula of "=max(column:column)"

  After filling the formula in,press enter and the amount will shown out.

To find the lowest sale,use the formula of =min(column:column)

 Press enter and it will shown the amount of the lowest sale.

 To find the average sale,use the formula of =average(column:column)

 Press enter and it will show the average sale.

To find the total amount of four place,have to use the formula to calculate the total amount,"=sum(column:column) 

             Press enter and the result will be shown

Using the same formula to calculate the amount of Midlands,South East and South West

To calculate the total sale of all four areas.Use equation of"=sum(column:column)"which can give the amount of all those four areas.

After putting in the equation,press enter and it will give the total sale.

first calculate the amount of mileage after the fuel have risen

Then calculate the total amount to be paid after the fuel have risen,by using the formula of "=sum(column:column)"

 Press enter and the total amount will be shown.

Here is the original total amount  to be paid and the total amount to be paid after risen mileage.

To calculate the remain of all the paid out.First calculate the sum of the total amount to be paid.

Which by using "=sum(column:column)

After calculate the amount is 46251.37.Use calculator to calculate 47000 take away 46251.37 and the remain is 749 and round it to the nearest 10 which is £750