Shortcutdrill

Level 4: Editing Drill 24 of 38 Free

Total in one key press

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

You are in E12, just below the Revenue column. Add a SUM of the column above in one key press.

What this drill teaches

AutoSum looks up for numbers and writes the SUM for you. It also works to the left of a row of numbers.

A hint if you get stuck

Windows: Alt+=. Mac: Option+= (in Excel for Mac: Cmd+Shift+T). The drill allows 1 key press.

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

More drills in Editing