4. Formulae
A formula is used to do every single calculation in the spreadsheet.
A formula can be as simple as adding up two numbers in different cells or it can be as complex as working out a statistical result from millions of pieces of data collected over months.
The reason that formulae are so important is that once you have set them up, they will track any changes that you make in the spreadsheet.
For example, your teacher might set up a formula to work out the percentages marks students got in a test. After going through the test with the students, maybe a couple of extra marks were given for some questions or some scores had been added up incorrectly.
Instead of having to work out the percentages again, the teacher simply enters the new score into the spreadsheet and the percentage is automatically recalculated.
A spreadsheet formula must start with an equals sign (=). It is the trigger to tell the spreadsheet that a calculation is needed.
Challenge see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: Spreadsheet Formulas
Do you know how to write a range of simple formulae?
Make sure that you know how to write a formula to add, subtract, multiply and divide