ShortcutdrillLock the column only
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 holds =B13*C$12. Lock the column of the B13 reference ($B13) so it can be filled right, then fill C13 right to E13.
What this drill teaches
F4 cycles a reference through $B$13, B$13, $B13 and back. Mixed references are what make one formula fill a whole grid.
A hint if you get stuck
Windows: F2, F4 until $B13, Enter, select, Ctrl+R. Mac: Fn+F4. The drill allows 9 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