Formuladrill

Level 1: Basics Exercise 1 of 68 Free

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.

Functions used: SUM

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

More exercises in Basics