Chapter 6 Filter data, use absolute references and paste values ・ MISSION 27

Mission 27: Enter a formula with a fixed unit price all at once

📋 Mission list

Keycat

Amount (C2-C5) = Quantity x Unit Price (F1). Enter the formula in C2 to C5 at once. F1 must be fixed.

Keystrokes 0/ Best example: 11

Chapter 6 ・ MISSION 27

Enter a formula with a fixed unit price all at once

Amount (C2-C5) = Quantity x Unit Price (F1). Enter the formula in C2 to C5 at once. F1 must be fixed.

Now
Goal

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

Shortcuts used in this mission

  1. Shift↓
  2. →Shift↓
  3. →Shift↓
  4. →=
  5. →B
  6. →2
  7. →*
  8. →F
  9. →1
  10. →F4
  11. →CtrlEnter

F4 fixes reference ($F$1). If you select a range, type a formula, and confirm with Ctrl+Enter, the correctly shifted formula will be inserted into all cells.

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.