Succeed with maths – Part 2
Succeed with maths – Part 2

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

Free course

Succeed with maths – Part 2

1.1 Finding the balance

A similar approach can be used for working out other values in the spreadsheet. Have a go yourself in this next activity.

Activity 2 Working out the balance

Timing: Allow approximately 5 minutes

Formulas have also been used to calculate the total monthly expenses and the balance. If you were working these calculations out by hand, what would you do? Write this using the appropriate cell numbers and maths operators as shown in the previous example. Finally, check these comparing your answers using the formulas with the values in cell B13 and B15.

Answer

To calculate the total monthly expenses, you need to add the individual expenses of ‘Rent’, ‘Food’, ‘Transportation’, ‘Regular Bills’, and ‘Other’. The formula will therefore be:

value in cap b 13 equals value in cap b eight plus value in cap b nine plus value in cap b 10 plus value in cap b 11 plus value in cap b 12

To find the balance, you need to take the expenses away from the total income. So, the formula to calculate the balance will be:

value in cap b 15 equals value in cap b five minus value in cap b 13

Checking these now:

multiline equation line 1 Value in cap b 13 equation left hand side equals right hand side sum with, 5 , summands 819.82 plus 233.14 plus 174.40 plus 221.12 plus 136.70 line 2 equals 1585.18

multiline equation line 1 Value in cap b 15 equation left hand side equals right hand side 1751.90 minus 1585.18 line 2 equals 166.72

Comparing these with the values in the spreadsheet, it is clear that they agree. This should give us confidence that the formulas built are correct!

How are these formulas actually put into the spreadsheet though? To do this you type the formula directly into the relevant cell, starting with an equals sign to tell the software that you are entering a formula rather than a word. This is shown in Figure 2:

Described image
Figure 2 Finding the balance

Notice that in cell B13, a shorthand form for the sum (total) has been entered. The formula ‘= B8 + B9 + B10 + B11 + B12’ could have also been entered, but it is much quicker to use the shorthand form ‘= SUM(B8:B12)’, which is shown here. This instruction tells the computer to add the values in all the cells from B8 to B12.

If you have access to spreadsheet software, try and recreate this example now and see how you get on with entering formulas yourself.

Another advantage of using a spreadsheet is that if you change some of the numbers, all the calculations that use that particular number will be automatically updated to reflect the change. For example, in this budget, the amounts for the salary, rent and the regular bills are likely to remain the same from one month to the next, and may only be updated once or twice a year. However, the amounts for food, transportation, other bills and other income will probably change from month to month. These values can be changed easily on the spreadsheet and the revised balance produced immediately, taking some of the work from you and reducing the risk of calculation errors.

Skip Your course resources
SWMB_2

Take your learning further

Making the decision to study can be a big step, which is why you'll want a trusted University. The Open University has 50 years’ experience delivering flexible learning and 170,000 students are studying with us right now. Take a look at all Open University courses.

If you are new to university level study, find out more about the types of qualifications we offer, including our entry level Access courses and Certificates.

Not ready for University study then browse over 900 free courses on OpenLearn and sign up to our newsletter to hear about new free courses as they are released.

Every year, thousands of students decide to study with The Open University. With over 120 qualifications, we’ve got the right course for you.

Request an Open University prospectus