Excel Practice

Filter practice

Focus on matching orders while preserving the complete log.

Lesson 83 of 92 · 4 exercises

Practise Filter

What you will practise

The visible-row count changes while the original data stays available. Clearing filters restores hidden records.

Data → Filter → column, comparison and value

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

First exercise example

Team Equals Studio; Apply filter.

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

4 exercises in this lesson

  1. Exercise 1

    Show only orders where Team equals Studio.

  2. Exercise 2

    Show only orders with Revenue greater than or equal to 100.

  3. Exercise 3

    Show only Studio orders with Units greater than or equal to 7.

  4. Exercise 4

    Clear the active filters so all seven original orders are visible.

Before you check your answer

  • Hide without deleting. Apply filter keeps the complete source and changes which records are visible. The visible count helps you check the result.
  • Combine conditions deliberately. Filters on different columns must all match. Check Equals versus Greater than or equal to against the task.
  • Clear the old criteria. Clear filters restores every row, including a filter that was already active when the exercise opened.

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.