Named ranges
IntermediateAdvanced
10 questions, about 17 minutes
Write =SUM(Marks) instead of =SUM(C2:C6): it's easier to read and you make fewer mistakes.
What we'll do
- Creating a name
- Using names in formulas
- Managing names
What you'll use
SUMMAXAVERAGEIF- The Excel menus
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.
2examplesYou watch
10questionsYou do it yourself