Fixing spelling variations with Find and Replace

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. You typed Sydeny in 30 cells instead of Sydney. Which is the fastest way to fix every one?

A Use Find and Replace to change Sydeny to Sydney in one step

B Click each cell and retype Sydney 30 times

2. Which shortcut opens Find and Replace in most spreadsheets?

A Ctrl+Z

B Ctrl+H

3. In the Find and Replace box, where do you type the misspelled word Sydeny?

A In the Find box

B In the Replace with box

4. In the Find and Replace box, where do you type the correct spelling Sydney?

A In the Find box

B In the Replace with box

5. A column has the cities Perth and Perth West. You want to change only cells that say exactly Perth to Perth City. Which setting helps?

A Tick Match entire cell contents

B Leave it unticked so it matches part of any cell

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Ctrl+H		AFind: Sydeny Replace with: Sydney
2Replace All		BWith Match entire cell contents off, a cell already reading Melbourne would be changed to Melbournebourne. Tick the option so only cells that are exactly Mel are replaced.
3To fix every misspelling of Sydney in one step, find the wrong spelling and replace it with the correct spelling		C[x] Match entire cell contents
4Tick Match entire cell contents so that only cells containing exactly the text you searched for are changed		DChanges every cell that matches the spelling you searched for in one step, not just one cell
5Find: Sydney Replace with: Sydeny		EThe boxes are swapped. This would change the correct spelling into the wrong one. Find should hold Sydeny and Replace with should hold Sydney.
6Find: Mel Replace with: Melbourne (Match entire cell contents is off)		FOpens the Find and Replace box in a spreadsheet so you can fix a spelling in many cells at once

Definitions

Find and Replace

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Press Ctrl+_ to open Find and Replace

Find what: Sydeny ____________: Sydney

_________: Sydeny Replace with: Sydney

Tick Match ______ cell contents

Click ___________ to fix every cell

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Press Ctrl+H

B Find what: Sydney

C Replace with: Sydney

D Click Replace All

Question 2

A Press Ctrl+F

B Find what: Melborne

C Replace with: Melbourne

D Click Replace All

Question 3

A Press Ctrl+H

B Find what: Brisbain

C Replace with: Brisbain

D Click Replace All

Question 4

A Press Ctrl+H

B Find what: Adelaid

C Replace with: Adelaide

D Match entire cell: off

E Click Replace All

Question 5

A Press Ctrl+H

B Find what: Hobrat

C Replace with: Hobart

D Click Replace once

Answer Key

Fixing spelling variations with Find and Replace

Section A: Quick Questions

A — Use Find and Replace to change Sydeny to Sydney in one step

B — Ctrl+H

A — In the Find box

B — In the Replace with box

A — Tick Match entire cell contents

Section B: Match the Pairs

Ctrl+H → Opens the Find and Replace box in a spreadsheet so you can fix a spelling in many cells at once

Replace All → Changes every cell that matches the spelling you searched for in one step, not just one cell

To fix every misspelling of Sydney in one step, find the wrong spelling and replace it with the correct spelling → Find: Sydeny Replace with: Sydney

Tick Match entire cell contents so that only cells containing exactly the text you searched for are changed → [x] Match entire cell contents

Find: Sydney Replace with: Sydeny → The boxes are swapped. This would change the correct spelling into the wrong one. Find should hold Sydeny and Replace with should hold Sydney.

Find: Mel Replace with: Melbourne (Match entire cell contents is off) → With Match entire cell contents off, a cell already reading Melbourne would be changed to Melbournebourne. Tick the option so only cells that are exactly Mel are replaced.

Section C: Definitions

Find and Replace — A spreadsheet tool (Ctrl+H) that finds every cell with one spelling and changes them all to the correct spelling in one step, like turning Sydeny into Sydney.

Section D: Fill in the Blanks

Press Ctrl+H to open Find and Replace

Find what: Sydeny
Replace with: Sydney

Find what: Sydeny
Replace with: Sydney

Tick Match entire cell contents

Click Replace All to fix every cell

Section E: Spot the Error

B — Find what must hold the wrong spelling (Sydeny), because that is what Find and Replace searches for. It should be 'Find what: Sydeny'. Searching for the correct spelling would fix nothing.

A — Ctrl+F only opens Find, which has no Replace box. Ctrl+H opens Find and Replace, so line 1 should be 'Press Ctrl+H'.

C — Replace with must be the correct spelling. Replacing Brisbain with Brisbain changes nothing. It should be 'Replace with: Brisbane'.

D — With match entire cell contents off, the tool also changes the correct 'Adelaide' cells into 'Adelaidee'. It should be 'Match entire cell: on' so only cells that are exactly 'Adelaid' change.

D — Replace changes only one cell at a time, so other Hobrat cells stay wrong. 'Click Replace All' fixes every cell in one step.