ShortcutdrillLock everything
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
C13 multiplies B13 by the multiplier in B12. Make the B12 reference absolute, then fill C13 down to C16.
What this drill teaches
One F4 turns B12 into $B$12. Without it the reference slides down as you fill and every row reads a different cell.
A hint if you get stuck
Windows: F2, F4, Enter, select, Ctrl+D. Mac: Fn+F4. The drill allows 8 key presses.
Try it now, no account needed
This drill is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this drill