ShortcutdrillName the inputs
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
B4:C9 is selected: six labels with their values. Create a name for each value from the label on its left.
What this drill teaches
Create from Selection names every input in one go. Formulas can then say =Price*Volume instead of =C4*C5.
A hint if you get stuck
Windows: select labels and values, Ctrl+Shift+F3, Enter. Mac: Cmd+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.