Excel Practice

Sort practice

Bring important records to the top without separating values from their labels.

Lesson 82 of 92 · 4 exercises

Practise Sort

What you will practise

Sorting moves whole records and keeps the header fixed. Equal keys retain their previous relative order.

Data → Sort → column and direction

Open Data · Sort 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; Item Ascending; Apply sort.

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

4 exercises in this lesson

  1. Exercise 1

    Sort the entire order log by Item from A to Z.

  2. Exercise 2

    Sort the entire order log by Revenue, largest to smallest.

  3. Exercise 3

    Sort the entire order log by Date, oldest to newest.

  4. Exercise 4

    Sort by Team A to Z, then by Units largest to smallest within each team.

Before you check your answer

  • Move complete records. Include the header and every source column so values stay with their labels.
  • Read both sort keys. Choose the requested column and direction. Then by resolves ties in the first key; tied records keep their relative order.
  • Check the dates. Oldest to newest is ascending for these ISO dates. Inspect the actual reordered rows before checking.

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.