Excel Practice

Tables and duplicates practice

Identify headers and remove repeated records using an explicit definition of a match.

Lesson 85 of 92 · 3 exercises

Practise Tables and duplicates

What you will practise

A table identifies the header row and supplies filter affordances without deleting any orders.

Data → Table / Remove duplicates

Open Data · Tables and duplicates above the worksheet. Read the task, select the requested range and apply the operation to see its actual effect.

First exercise example

Range A1:F8; Create table with headers.

This example uses the original practice data. Fresh data changes the records; follow the current task.

3 exercises in this lesson

  1. Exercise 1

    Create a table over A1:F8 with the first row used as headers.

  2. Exercise 2

    Remove duplicate records in A1:F8 by comparing all six columns. Retain the first occurrence.

  3. Exercise 3

    Keep the first order for each Item and Team combination in A1:F8. Compare only those two columns.

Before you check your answer

  • Include the header row. Create table uses the first selected row as headers and exposes working header filter controls.
  • Choose the duplicate key. Compare all six columns for exact repeats, or only Item and Team when the task asks for that combination.
  • Keep the first record. Remove duplicates retains the first matching row. Reset worksheet restores the original records if you remove the wrong ones.

How the answer is checked

Apply changes the worksheet; it does not mark an exercise complete. Choose Check worksheet to check the actual operations against the requested configuration and resulting rows, formats, selection, summary or chart. Valid equivalent workflows can pass. Invented source values or a claimed final result cannot replace the operation. Account progress is saved only after the server verifies the same task and access rules.

Use progressive hints when you need help, then try the task again with fresh data. Correctly solving a step opens the next exercise.