Shortcutdrill

Level 8: Formula editing speed Drill 93 of 103 Pro

Fix a reference in place

An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.

The task

F2 should divide Revenue by Units for row 2, but it reads =E2/D3. Fix the last character in edit mode instead of retyping the formula.

What this drill teaches

F2 opens the cell with the caret at the end, so one Backspace and one character fix a trailing typo. Retyping a long formula is where new mistakes creep in.

A hint if you get stuck

Windows: F2, Backspace, type 2, Enter. Mac: Fn+F2, Delete, type 2, Return. The drill allows 2 key presses.

This drill is part of Pro

Pro unlocks all 103 drills, with worked solutions and progress saved to your account. The free drills work without an account.

Annual starts with a 7-day free trial: $0 today, cancel before November 12, 2026 and you are not charged. 14-day refund on every plan, no questions. Cancel a subscription in one click. Founding price until 31 December 2026. Students: 50% off annual with a .edu or .ac email.

Start with the free drills

More drills in Formula editing speed