OCR Cambridge Nationals IT (J836) – R060 - Lesson 1 - Basic Formula

Basic Spreadsheet Formulae

Learners find out how spreadsheets do calculations automatically. They write formulae that start with an equals sign, use the arithmetic operators (+, −, *, /) and refer to cells instead of typing in values, so results update whenever the data changes. Practical tasks let them build and copy formulae across a spreadsheet, which gives them a solid base before moving on to functions and the more advanced techniques.