ShortcutdrillSum across a block
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
D2:F12 is selected: the Units and Revenue numbers plus a blank row and column. Total every row and every column at once.
What this drill teaches
AutoSum on a block with blank edges fills the edges with SUMs, including the grand total in the corner.
A hint if you get stuck
Windows: select the block plus a blank row and column, Alt+=. Mac: Cmd+Shift+T. 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.