Topic 10: Spreadsheets

What is a spreadsheet?

It is a piece of software which is used to work out calculations. They can handle all the financial calculations for a large business, they can work with statistics and calculate probability or other statistics.

Formula

• All you will need to know is how to use and identify basic formula and functions on a spreadsheet
• i.e. how to add two cells, take away the values in two cells, multiply and divide

Functions

• A function does a very specific job within a spreadsheet. For exmaple, 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

Function

• You start with an equals and then…