Module 05 · Lesson 14
Class exercise: the store stock list
Eight tasks that use everything in the course.
Practice45 min
Download the mini practice file (CSV)
16 rows from the store stock list with the same six problems planted: no header style, a missing number (12), “long” in the Quantity column, messy text, empty prices and totals, a duplicate and a spelling slip. Opens in Excel. Blank quantities and prices are blank on purpose: type your own numbers to practise formulas.
Take this home
- Clean first, format second.
- Never type numbers: fill, formula or Numbering button.
- Use formulas and styles so changes update themselves.
- Preview every page before you print.