Learn. Practise. Build real understanding.
School subjects, languages, puzzles and practical skills—with worked examples, explanations and guided practice.
27 beginner courses100 lessonsFree starter library
Spreadsheet formulas
Cells hold values or formulas. Formulas usually begin with an equals sign. A relative reference changes when copied, while an absolute reference uses dollar signs to keep a row or column fixed.
Separate inputs from formulas and label units. Test with simple numbers whose answer you can calculate by hand. Avoid typing replacement values into calculated cells without understanding the effect.
Worked example
If B2 is quantity and C2 is unit price, =B2*C2 calculates cost. With 4 and 3.50, the result is 14.
Try it yourself
Sketch a five-row expense sheet with amount, category and total.
Check your understanding
Which formula multiplies B2 by C2?
The asterisk is the multiplication operator.
Save this math resource for later
Save to Pinterest
Save to Pinterest