Chapter 3 Edit cells, fill ranges and copy formulas ・ MISSION 12
Mission 12: Fill a formula down
Keycat
Let's copy the tax-included calculation formula in B2 to B3-B5.
B2fx=A2*1.1
A
B
C
D
1
Unit price
Tax included
2
100
110
3
250
4
80
5
1200
6
7
*Tax rate 10%
8
Keystrokes 0/ Best example: 4
Chapter 3 ・ MISSION 12
Fill a formula down
Let's copy the tax-included calculation formula in B2 to B3-B5.
A
B
C
D
1
Unit price
Tax included
2
100
110
3
250
4
80
5
1200
6
7
*Tax rate 10%
8
A
B
C
D
1
Unit price
Tax included
2
100
110
3
250
275
4
80
88
5
1200
1320
6
7
*Tax rate 10%
8
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- Shift↓
- →Shift↓
- →Shift↓
- →CtrlD
Ctrl+D "Copy the cell above down". Formula references (A2 → A3...) are also automatically shifted.
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.