Open {{code:sm3_vat_calc_practice}} in {{code:sm3}}. If it is missing, make it and paste this table into {{cell:A1}}. Then type {{formula:=B2*C2}} in {{cell:D2}} and fill it down to {{cell:D6}}.
| Item | Net (€) | VAT rate | VAT (€) |
|---|---|---|---|
| Vinyl sticker pack | 12.00 | 0.23 | |
| Shipping labels (100) | 8.50 | 0.23 | |
| A4 card stock pack | 15.00 | 0.23 | |
| Ink cartridge | 22.00 | 0.23 | |
| Table display stand | 35.00 | 0.23 |
Have you ever seen a cell show a code starting with #? What did you do?
#NAME? means a function name is spelled wrong, like {{code:=AVARAGE(B2:B10)}}.
#DIV/0! means a formula divides by zero or by an empty cell.
#REF! means a formula points to a cell you deleted.
#VALUE! means there is text in a cell where a number should be, like the word pending.
If the function is spelled right, look at what is in the cells instead.
In an hours tracker, {{code:=D2/E2}} shows {{code:#DIV/0!}} until you type the days worked in {{cell:E2}}.
You will sort eight spreadsheet mistakes into the error code each one causes. You will work through them together as a class.
You will break one formula on a copy of {{code:sm3_vat_calc_practice}}, and then fix it. Watch your teacher on the board first, then follow the steps in the box below.
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.