Chapter 1 Sums and averages ・ MISSION 2

Mission 2: Point to a range with the arrow keys for an average

📋 Mission list

Task

In B7, find the average number of visitors over 5 months. You can point to the range with the arrow keys.

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 1 ・ MISSION 2

Point to a range with the arrow keys for an average

In B7, find the average number of visitors over 5 months. You can point to the range with the arrow keys.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =AVERAGE(B2:B6)

Pressing an arrow key while typing a formula points to a cell and inserts its address. Shift+arrow extends it to a range. Dragging with the mouse does the same.

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).