ShortcutdrillFill a block with one formula
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:F11 is selected. Enter =E2*$H$1 into every selected cell in one go (H1 holds the factor).
What this drill teaches
Ctrl+Enter writes the formula into the whole selection with the references adjusted for each cell. No fill step needed.
A hint if you get stuck
Windows: select, type the formula, Ctrl+Enter. Mac: Cmd+Return. The drill allows 1 key press.
This drill is part of Pro
Pro unlocks all 80 drills, with worked solutions and progress saved to your account. The free drills work without an account.
14-day refund, no questions. Cancel a subscription in one click. Students: 50% off annual with a .edu or .ac email.