Mr Lowe's Lessons...


Plough Farm - How to use Functions on a Spreadsheet

How work out averages, maximum values and other items in a list on a Spreadsheet

A FUNCTION is like a formula in that it will work out some calculation for you

This spreadsheet will show you how work out an average as well as some other values.

The spreadsheet is set up for you with instructions on how to use these functions

Click Here with the Right Hand Button and select Save Target As

Save the spreadsheet in to your Yr 8 ICT folder and then open it


REMEMBER to read the instructions on the spreadsheet CAREFULLY


We can now try applying some of these ideas in the context of Plough Farm Holiday Centre


BACK TO MAIN PAGE