Chapter 5 Combined practice: add, organise and summarise data ・ MISSION 21

Mission 21: Add one item to expense list

📋 Mission list

Keycat

Add a row below the expense table: today’s date, Transportation expenses (copied from above), and an amount of 500.

Keystrokes 0/ Best example: 10

Chapter 5 ・ MISSION 21

Add one item to expense list

Add a row below the expense table: today’s date, Transportation expenses (copied from above), and an amount of 500.

Now
Goal

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

  1. Ctrl↓
  2. →↓
  3. →Ctrl;
  4. →Tab
  5. →CtrlD
  6. →→
  7. →5
  8. →0
  9. →0
  10. →Enter

Ctrl+↓ then ↓ reaches the new row. Ctrl+; inserts the date, Tab moves right, and Ctrl+D copies the value above.

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.