Add it up
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Five monthly costs are listed. Select cell B7, type a formula in the formula bar that adds all five, press Enter, then choose Check answer.
What this exercise teaches
SUM accepts a range, so it keeps working when a number inside the range changes.
A hint if you get stuck
Every formula starts with =. A range such as B2:B6 means every cell from B2 down to B6.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise