202X2 Basic Spreadsheet Formulae Exercise

 |  No Comments

The greatest power of spreadsheets is that they can be programmed (the formula) to do the maths as you update the data

The most basic calculations are:

  • add +
  • subtract (minus) –
  • multiply *
  • divide /

These symbols are keys on your keyboard (on the main keyboard – you will need SHIFT for the * as it is over the 8). They are also on the calculator keyboard of a desktop computer

  • You can combine + – / * according to the maths you need
  • The answer of the calculation will display instead of the formula
  • You tell the spreadsheet you are about to write a formula by always starting with = (equals)
  • You can build very complex formulae

https://www.youtube.com/watch?v=RgvdCHjOKYg

You need to be logged in to view the rest of the content. Please . Not a Member? Join Us