Chapter 8 Functions that spill ・ MISSION 33

Mission 33: Sort by sales, largest first

📋 Mission list

Task

Enter one formula in E2 to show the table in columns A–C sorted by sales, largest first. Leave the original table as it is.

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 8 ・ MISSION 33

Sort by sales, largest first

Enter one formula in E2 to show the table in columns A–C sorted by sales, largest first. Leave the original table as it is.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =SORT(A2:C9,3,-1)

SORT puts the sorted result somewhere else. The original table keeps its order, so you can keep the source data and still view it another way.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).