ShortcutdrillEvaluate part of a formula
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
G8 holds =SUM(D8:E8)/F8. Select the SUM part in the formula and press F9 to see its value, then Esc to put the formula back.
What this drill teaches
F9 evaluates whatever is selected inside a formula without leaving the cell. Esc restores it; Enter would hard-code the number.
A hint if you get stuck
Windows: F2, Shift+arrows, F9, Esc. Mac: Fn+F9. The drill allows 3 key presses.
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.