Chapter 4 Edit rows and columns; calculate totals ・ MISSION 20

Mission 20: Get the total instantly

📋 Mission list

Keycat

In B6, calculate the total sales of the four branches.

Keystrokes 0/ Best example: 2

Chapter 4 ・ MISSION 20

Get the total instantly

In B6, calculate the total sales of the four branches.

Now
Goal

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

  1. Alt=
  2. →Enter

Alt+= (AutoSum) inserts a formula that adds the numbers above. Check the range, then press Enter.

On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).

Practise individual shortcuts or check the shortcut reference here. Shortcut drillsExcel shortcut list

Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.

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