The Quick Analysis menu won't replace everything you do in Excel, but it handles the repetitive stuff faster than navigating through ribbons. This shortcut eliminates most of the steps for you if you ...

Pick the right answer from the set provided. But anyone who’s taken enough of these tests knows there’s more to it.

Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...