Chapter 2 Entering and editing ・ MISSION 6
Mission 6: Fill the amount formula down
Keycat
Copy the amount formula in D2 down to D6.
D2fx=B2*C2
A
B
C
D
E
F
1
Product name
Unit price
Quantity
Amount
2
Ballpoint pen
120
10
1200
3
Notebook
180
5
4
Sticky notes
250
4
5
Paper clips
90
3
6
File
300
6
7
8
9
10
11
Keystrokes 0/ Best example: 5
Chapter 2 ・ MISSION 6
Fill the amount formula down
Copy the amount formula in D2 down to D6.
A
B
C
D
E
F
1
Product name
Unit price
Quantity
Amount
2
Ballpoint pen
120
10
1200
3
Notebook
180
5
4
Sticky notes
250
4
5
Paper clips
90
3
6
File
300
6
7
8
A
B
C
D
E
F
1
Product name
Unit price
Quantity
Amount
2
Ballpoint pen
120
10
1200
3
Notebook
180
5
900
4
Sticky notes
250
4
1000
5
Paper clips
90
3
270
6
File
300
6
1800
7
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↓
- →Shift↓
- →CtrlD
Ctrl+D copies the top cell of the selection down. The row numbers in the formula adjust to each row. To the right, use Ctrl+R.
On a Mac, the keys on screen change to Mac keys (⌘, Option, control).
To check shortcuts in a list, see:Google Sheets shortcut list
Keyboard only (the mouse does not work here).
* This simulates the behavior of Google Sheets (Chrome on Windows) and may differ in part from the real thing.
* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.