Question

analyzing data to make financial decisions
kaysons budget spreadsheet
what formula did kayson use to calculate the net savings/deficit in cell c25?
category subcategory amount ($)
salary 2,500
freelance work 500
investments 200
total 3,200
housing rent/mortgage 1,000
utilities 150
maintenance 50
insurance 30
total 1,230
transportation fuel 100
public transport 50
maintenance 40
insurance 70
total 260
food groceries 300
dining out 100
coffee & snacks 30
total 40
entertainment movies & shows 40
= c25
= sum(c5 : c24)
= c5 + c10 + c15 + c19 + c24
= c5 - c10 - c15 - c19 - c24

Explanation:

Step1: Understand net - savings/deficit

Net savings/deficit is calculated as total income minus total expenses. In the spreadsheet, cell C5 is the total income and cells C10, C15, C19, C24 are the total expenses for different categories.

Step2: Identify the correct formula

To calculate the net savings/deficit, we subtract the sum of total expenses from the total income. So the formula should be the total income cell minus the sum of total - expense cells.

Answer:

= C5 - C10 - C15 - C19 - C24