Practice · Formulas & Functions

0
14 shortcuts

Excel Practice: Formulas & Functions

Master every shortcut in the "Formulas & Functions" category through quizzes

Progress 0 / 14

Practice Formulas & Functions Excel Shortcuts

Formulas are the heart of Excel, and these 14 shortcuts make working with them dramatically faster. Learn to insert SUM with a single keystroke (Alt+=), toggle absolute references with F4, show all formulas on screen (Ctrl+`), and quickly insert functions.

Whether you're building financial models, grading spreadsheets, or analyzing survey data, formula shortcuts eliminate tedious typing and reduce errors. The F4 key alone — toggling between relative and absolute references — saves hours of manual dollar-sign insertion.

Excel Practice Format

This category practice mode shows you a keyboard shortcut and asks you to identify the correct action from 4 choices. You'll work through all 14 shortcuts in the Formulas & Functions category in random order. Correct answers are tracked, so you can see which shortcuts you've mastered and which need more practice.

Your progress is saved automatically. Come back anytime to review or retry. Once you're confident, test your speed in the Speed Challenge or try the Real Scenarios to apply these shortcuts in context.

Excel Formulas & Functions Practice FAQ

How many shortcuts are in the Formulas & Functions category?
There are 14 shortcuts in this category. Each one is tested individually, and your progress is saved so you can pick up where you left off.
Do these shortcuts work on both Windows and Mac?
Yes. Every shortcut in our database has both Windows and Mac key combinations. The practice exercises currently show the Windows keys, but you can find the full list with both platforms on our Cheat Sheet page.
What's the best order to practice categories?
We recommend: Basics first (highest daily impact), then Navigation & Selection (essential for large spreadsheets), then Formatting, Formulas & Functions, Data Processing, and finally Advanced Techniques. But feel free to jump to whichever category is most relevant to your current work.