Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 3/4

SORT and SORTBY

Exercise 1 of 3

In E2, list the amounts from smallest to largest.

About this lesson

SORT and SORTBY return a sorted copy of a range and leave the original as it is.

In this lesson

  1. In E2, list the amounts from smallest to largest.
  2. In E2, list the amounts from largest to smallest.
  3. In E2, list the regions, ordered by amount from largest to smallest.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in E2 and press Enter to check.