5. Functions

A function does a very specific job within a spreadsheet. For example, SUM will add up a set of numbers for you. AVERAGE is another common one which will give you the average of a set of numbers.

There are hundreds of functions available for you to make use of within a spreadsheet package. Some are going to be useful to you now, some you will probably never use.

All of these functions can be combined in a formula, for example =SUM(A1:A5) is a formula which is making use of the SUM function.