Formuladrill

Level 7: Find the error Exercise 60 of 68 Free

The budget that looks fine

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

Nadia built this monthly budget, and the money left over looks too good. One formula is wrong. Find it and fix it, then choose Check answer.

What this exercise teaches

A total that stops one row short is one of the most common spreadsheet mistakes, often caused by adding a row below the range. Fixing B9 also fixes the money left over, because B11 depends on it.

A hint if you get stuck

Click each formula and look at the range it covers. Does it include every expense?

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 Find the error