Excel Supreme

Excel exercises

Excel exercises: Getting started

This group has one exercise about moving around a sheet without the mouse.

The first screen asks you to select A2 to A40 in one chord. Shift extends the selection, and Ctrl or Command turns the arrow key into a jump to the last filled cell. The jump stops at the first blank row, so a gap in the data ends the selection early. Press it, look at where the highlight stopped, and extend again from there.

The second screen keeps row 1 in view using the ribbon key tips: Alt, then W, then F, then R. A key tip is the letter each tab shows while Alt is held, so the route reads as a left-to-right walk across the ribbon. Freeze panes sits two levels in, and the same keys bring you back to unfreeze it.

Two screens, one at level 1, and no formula to type. The grader checks the range or the view you finish with, so a near miss is visible on the sheet rather than in a message.

All Excel exercises

A stale exercise is one you finished two weeks ago or longer. One that needs practice took a hint, or more than one try.

0 of 1 complete

  1. Select to the edge of a block Paid Select a whole column of data with two keys instead of the mouse. Not started