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'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.