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

Mission 25: Apply last month's formula to this month's column

📋 Mission list

Keycat

Let's copy the formula for April's amount (D2-D4) to May's amount (G2-G4).

Keystrokes 0/ Best example: 5

Chapter 5 ・ MISSION 25

Apply last month's formula to this month's column

Let's copy the formula for April's amount (D2-D4) to May's amount (G2-G4).

Now
Goal

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

Shortcuts used in this mission

  1. CtrlShift↓
  2. →CtrlC
  3. →Ctrl→
  4. →→
  5. →CtrlV

When copying formulas, the references shift relative to each other. If the table has the same shape, just paste it without retyping the formula.

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.