Shortcuts for formulas
IntermediateBeginner
9 questions, about 8 minutes
AutoSum, filling, editing a cell and locking a reference, without the mouse.
What we'll do
- AutoSum
- Filling down and to the right
- Editing a cell and locking a reference
- Today's date
What you'll use
- Shortcuts on your keyboard
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
1exampleYou watch
9questionsYou do it yourself