ShortcutdrillInsert a function by name
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
In H2, open the Insert Function box and start a SUMIFS.
What this drill teaches
Shift+F3 opens Insert Function with the search box focused. Type the name, press Enter, and the formula is started for you.
A hint if you get stuck
Windows: Shift+F3, type SUMIFS, Enter. Mac: Fn+Shift+F3. 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.