Chapter 5 Combined practice: add, organise and summarise data ・ MISSION 23
Mission 23: Organize and filter your roster
Keycat
Delete "Old Memo" in column C of the list and add a filter to the table.
A1fxName
A
B
C
D
E
1
Name
Department
Old notes
Extension
2
Sato
Accounting
Completed
2101
3
Suzuki
Administration
2204
4
Takahashi
Sales
Contact required
3150
5
Tanaka
Sales
3162
6
Ito
Human resources
Completed
2330
7
8
9
Keystrokes 0/ Best example: 5
Chapter 5 ・ MISSION 23
Organize and filter your roster
Delete "Old Memo" in column C of the list and add a filter to the table.
A
B
C
D
E
1
Name
Department
Old notes
Extension
2
Sato
Accounting
Completed
2101
3
Suzuki
Administration
2204
4
Takahashi
Sales
Contact required
3150
5
Tanaka
Sales
3162
6
Ito
Human resources
Completed
2330
7
A
B
C
D
E
3
Suzuki
Administration
2204
4
Takahashi
Sales
3150
5
Tanaka
Sales
3162
6
Ito
Human resources
2330
7
8
9
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- →
- →→
- →CtrlSpace
- →Ctrl-
- →CtrlShiftL
Delete column → Filter flow. Ctrl+Space → Ctrl+- → Ctrl+Shift+L.
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.