Skip to content

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.

Download
Eight tasks
0/8

Take this home

  1. Clean first, format second.
  2. Never type numbers: fill, formula or Numbering button.
  3. Use formulas and styles so changes update themselves.
  4. Preview every page before you print.