Practical lesson for consolidation
In a practical lesson a table is built from scratch and all the tools of the earlier lessons are used together. The order of work: first the headings and the starting data are written; a shared number such as a tax rate is put in a separate cell and joined with an absolute reference; then the formula for one row is written and copied down; at the end a total row is added. Always check the result with a rough estimate: 12% VAT should be a little more than a tenth of the price. Save the file with a meaningful name (for example prices_VAT.xlsx) and keep a copy in another place as well. When working on another person’s or a shared file, make a copy before changing its formulas.
Young people in a neighbourhood made a table for a clean-up day: sacks, gloves and water containers. The total looked strangely large, so they compared it with a rough estimate and found one row where the formula had been copied wrongly.
Event planners, small business owners and accountants check a result against a rough estimate and spot mistakes quickly.
Before adding three numbers, round them and say the rough total aloud (for example 19, 31 and 48 are about 100), then calculate exactly and compare.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 12% | ||||
| 2 | 250 000 | 30 000 | 280 000 | ||
| 3 | 90 000 | 10 800 | 100 800 | ||
| 4 | 140 000 | 16 800 | 156 800 | ||
| 5 | 537 600 |
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 68 | 74 | 80 | 74 | yaxshi |
“Mini-shop”: groups build a table of 5 invented products, prices and VAT, then change one price in another group’s file and predict in advance how the total will change.