Chapter 4 Edit rows and columns; calculate totals ・ MISSION 20
Mission 20: Get the total instantly
Keycat
In B6, calculate the total sales of the four branches.
B6fx
A
B
C
D
1
Branch
Sales
2
Tokyo
1200
3
Osaka
980
4
Nagoya
1540
5
Fukuoka
760
6
Total
7
8
Keystrokes 0/ Best example: 2
Chapter 4 ・ MISSION 20
Get the total instantly
In B6, calculate the total sales of the four branches.
A
B
C
1
Branch
Sales
2
Tokyo
1200
3
Osaka
980
4
Nagoya
1540
5
Fukuoka
760
6
Total
7
A
B
C
1
Branch
Sales
2
Tokyo
1200
3
Osaka
980
4
Nagoya
1540
5
Fukuoka
760
6
Total
4480
7
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- Alt=
- →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.