Removing duplicate rows

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A student wants to delete rows where the same student ID appears twice. Which setting is correct?

A Run Remove Duplicates comparing only the Student ID column

B Run Remove Duplicates comparing every column, including Date and Score

2. Before using Remove Duplicates on the original dataset, what should you do first?

A Run it straight away because Undo is always available later

B Save a copy of the raw data on a separate sheet or file

3. Which statement describes what Remove Duplicates does?

A It deletes later rows that repeat the same values in the chosen columns

B It highlights repeated rows but leaves every row in the data

4. Two rows have the same Name and Suburb, but different Phone numbers. You compare only Name and Suburb. What happens?

A Both rows are kept because the Phone numbers differ

B The second row is removed as a duplicate

5. Two rows match in every column. Which row does Remove Duplicates keep?

A The first row that appears in the list

B The last row that appears in the list

Match the Pairs

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

Left column		Right column
1Data > Remove Duplicates		AMany different students share the same gender, so rows would be wrongly deleted. Compare a column that identifies the record, such as StudentID.
2Tick only the StudentID column		BRight-click sheet tab > Move or Copy > Create a copy
3Before removing duplicates, keep a copy of the raw data so deleted rows can be recovered		CRows are deleted permanently from the original, so there is no raw data left to check or recover. Make a copy of the sheet first.
4To count a row as a duplicate only when every column matches, select all the columns to compare		DSelect All in the Remove Duplicates box
5Run Remove Duplicates on the only copy of the raw data		EOpens the tool that deletes rows repeating the same values in the columns you tick, keeping the first match
6Tick only the Gender column to remove duplicate students		FRows are treated as duplicates when their StudentID matches, even if other columns differ

Definitions

Remove Duplicates

Fill in the Blanks

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

Data > Data Tools > _________________

1. ____ the raw data sheet before cleaning

Tick ___ columns to match whole rows

Remove Duplicates keeps the _____ match

Row 2: Ava,7 Row 5: Ava,7 Remove Duplicates deletes row _

Spot the Error

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

Question 1

A Copy sheet Raw to Clean

B Select A1:D50 on Clean

C Data > Remove Blank Rows

D Tick column: StudentID

Question 2

A Copy sheet Raw to Clean

B Select A1:C20 on Clean

C Data > Remove Duplicates

D Tick column: Mark

Question 3

A Sheet Raw holds the original

B Work on a copy named Clean

C Run Remove Duplicates on Raw

Question 4

A Edit Raw directly, no copy

B Select the data range

C Data > Remove Duplicates

Question 5

A Select only the header row A1

B Data > Remove Duplicates

C Tick column: StudentID

Answer Key

Removing duplicate rows

Section A: Quick Questions

A — Run Remove Duplicates comparing only the Student ID column

B — Save a copy of the raw data on a separate sheet or file

A — It deletes later rows that repeat the same values in the chosen columns

B — The second row is removed as a duplicate

A — The first row that appears in the list

Section B: Match the Pairs

Data > Remove Duplicates → Opens the tool that deletes rows repeating the same values in the columns you tick, keeping the first match

Tick only the StudentID column → Rows are treated as duplicates when their StudentID matches, even if other columns differ

Before removing duplicates, keep a copy of the raw data so deleted rows can be recovered → Right-click sheet tab > Move or Copy > Create a copy

To count a row as a duplicate only when every column matches, select all the columns to compare → Select All in the Remove Duplicates box

Run Remove Duplicates on the only copy of the raw data → Rows are deleted permanently from the original, so there is no raw data left to check or recover. Make a copy of the sheet first.

Tick only the Gender column to remove duplicate students → Many different students share the same gender, so rows would be wrongly deleted. Compare a column that identifies the record, such as StudentID.

Section C: Definitions

Remove Duplicates — A spreadsheet tool that deletes rows repeating the same values in the columns you choose to compare, keeping the first match. Always keep a copy of the raw data first.

Section D: Fill in the Blanks

Data > Data Tools > Remove Duplicates

1. Copy the raw data sheet before cleaning

Tick all columns to match whole rows

Remove Duplicates keeps the first match

Row 2: Ava,7  Row 5: Ava,7
Remove Duplicates deletes row 5

Section E: Spot the Error

C — Remove Blank Rows deletes empty rows, not repeated ones. The tool that deletes rows repeating the same values is Data > Remove Duplicates.

D — Different students can have the same mark, so comparing on Mark would delete real rows. Compare on a column that identifies a record, such as Email.

C — The tool permanently deletes rows. Run it on the Clean copy so the Raw data stays safe.

A — Always keep a copy of the raw data first. Without a copy, deleted rows cannot be recovered or checked later.

A — Select the whole table, A1:D50, so every row can be compared. Selecting only the header row leaves no data rows to check.