← ACARA Digital Technologies Years 9–10

Standardising spelling variations with Find and Replace

A spreadsheet tool that swaps every spelling variation of a category, such as Vic or VIC, for one agreed value like Victoria, so each category is counted only once.

Part of: ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data — Module 96, QCE Digital Solutions Unit 4 — Complex Digital Data Exchange Problems and Solution Requirements — Module 71

Understanding Standardising spelling variations with Find and Replace in ACARA Digital Technologies Years 9–10

What it does: The filter list shows every different value in the column, so any leftover variation such as VIC. or Vict is easy to spot. Replace All changes every matching cell at once, so repeating it for each variation leaves one agreed spelling for the category. Matching the whole cell means only cells that are exactly Vic are replaced. Without it, Victoria could become Victoriatoria. If spellings differ, the counts are split across several categories and the frequency table is wrong.

Common mistakes: Leaving Replace with empty deletes the state names. It should be Replace with: Victoria, the one agreed value. Find what must be the spelling variation to remove, such as VIC. Finding Victoria and replacing it with Victoria changes nothing.

Class: _____________________ · Name: _____________________ · Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Standardising spelling variations with Find and Replace to a class →

This module's key terms are also in a printable crossword (Modules 255–329) and word search (Modules 226–329).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning

Duo

A State column has Vic, VIC and Victoria. What is the aim of using Find and Replace here?

Delete every row that is not spelled VictoriaChange every variation to one agreed value, such as Victoria

Matches

Find: Vic Replace with: Victoria (Match entire cell contents is OFF)

↓

With whole-cell matching off, the Vic inside a cell that already says Victoria is replaced too, giving Victoriatoria.

Applying

Meanings

Term

Find and Replace

Meaning

A spreadsheet tool that swaps every spelling variation of a category, such as Vic or VIC, for one agreed value like Victoria, so each category is counted only once.

Practice

Find what: Vic

Testing

Gaps

: Victoria

Check Answer

Spots

1Find what: Vic

2Replace with: (leave empty)

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy

Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games

Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print

Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. A State column has Vic, VIC and Victoria. What is the aim of using Find and Replace here?

A. Change every variation to one agreed value, such as Victoria ✓

B. Delete every row that is not spelled Victoria

Find and Replace standardises the spelling so each category is counted only once. It does not delete data.

2. You want to change Vic to Victoria. Which setting should you tick so that cells like Victoria are not changed?

A. Match entire cell contents ✓

B. Match case only

Matching the whole cell means only cells that are exactly Vic are replaced. Without it, Victoria could become Victoriatoria.

3. What could happen if you replace Vic with Victoria WITHOUT matching the whole cell?

A. Nothing, because Victoria is already correct

B. Victoria could become Victoriatoria ✓

Without whole-cell matching, the tool also finds Vic inside Victoria and replaces that part, which creates a new wrong spelling.

4. Which is the better way to standardise Vic, VIC and vic in a column?

A. Retype only the first few cells and ignore the rest

B. Replace each variation with Victoria, matching the whole cell ✓

Find and Replace changes every matching cell at once, so no variation is missed.

5. After replacing, how can you check that no spelling variations are left in the State column?

A. Open the filter list and check that each state appears only once ✓

B. Look at the first five rows and assume the rest are fine

A filter drop-down list shows every unique value in the column, so any leftover variation like VIC stands out.

Match the Pairs

Find what: Vic Replace with: Victoria → Swaps the short spelling Vic for the one agreed value Victoria

Match entire cell contents → Only replaces cells that are exactly Vic, so cells already saying Victoria are left alone

After replacing, check with the filter drop-down list that only one version of each category is left → Data > Filter, then open the State drop-down list

Replace each variation in turn so Vic. and VIC both become one agreed value → Find: Vic. Replace with: Victoria [Replace All]

Find: Vic Replace with: Victoria (Match entire cell contents is OFF) → With whole-cell matching off, the Vic inside a cell that already says Victoria is replaced too, giving Victoriatoria.

Find: Vic Replace with: Victoria [Replace All] then start counting → The result was never checked, so variations such as Vict or Vic with a space could remain and be counted as separate categories.

Key Term

Find and Replace

A spreadsheet tool that swaps every spelling variation of a category, such as Vic or VIC, for one agreed value like Victoria, so each category is counted only once.

Fill in the Blanks

1. Find what: Vic Replace with: Victoria

Hint: Type the label of the box that holds the agreed value that will be swapped in.

2. Find what: Vic Replace with: Victoria Click Replace All

Hint: Type the button that changes every matching cell at once.

3. Find what: Vic [x] Match entire cell contents

Hint: Type the two words that say how much of a cell must match, so Victoria is not changed again.

4. Open the filter drop-down list Each state should appear once

Hint: Type the word for how many times each category should be listed after standardising.

5. =COUNTIF(B2:B30,"Vic") Counts cells still using the old spelling

Hint: Type the function that counts cells matching a value, used to check the replace worked.

Spot the Error

Question 1

A Find what: Vic

B Replace with: (leave empty)

C Match entire cell: ON

D Click Replace All

Line B — Leaving Replace with empty deletes the state names. It should be Replace with: Victoria, the one agreed value.

Question 2

A Select column C (State)

B Find what: Victoria

C Replace with: Victoria

D Match entire cell: ON

E Click Replace All

Line B — Find what must be the spelling variation to remove, such as VIC. Finding Victoria and replacing it with Victoria changes nothing.

Question 3

A Find what: Vic

B Replace with: Victoria

C Match entire cell: OFF

D Click Replace All

Line C — With match whole cell off, Vic inside Victoria is also replaced, giving Victoriatoria. Turn Match entire cell ON.

Question 4

A Find what: vic

B Replace with: Victoria

C Match entire cell: ON

D Click Find Next

Line D — Find Next only moves to one cell and changes nothing. Click Replace All to fix every variation at once.

Question 5

A Find what: Vic.

B Replace with: Victoria

C Match entire cell: ON

D Click Replace All

Line A — The extra full stop means the search does not match cells that contain just Vic. It should be Find what: Vic.

Student with a class code? Join your class →