Chapter 4 Edit rows and columns; calculate totals ・ MISSION 18
Mission 18: Apply currency formatting
Keycat
Let's display the amount (B2-B5) in currency like "¥1,280".
B2fx1280
A
B
C
D
1
Item
Amount
2
Transportation expenses
1280
3
Stationery
860
4
Meeting expenses
3200
5
Books
540
6
7
8
Keystrokes 0/ Best example: 2
Chapter 4 ・ MISSION 18
Apply currency formatting
Let's display the amount (B2-B5) in currency like "¥1,280".
A
B
C
1
Item
Amount
2
Transportation expenses
1280
3
Stationery
860
4
Meeting expenses
3200
5
Books
540
6
A
B
C
1
Item
Amount
2
Transportation expenses
¥1,280
3
Stationery
¥860
4
Meeting expenses
¥3,200
5
Books
¥540
6
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- CtrlShift↓
- →Ctrl$
Ctrl+Shift+4 applies currency formatting. This simulator uses yen and thousands separators.
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.