analyzing data to make financial decisions\nkaysons budget spreadsheet\nwhat formula did kayson use to…

analyzing data to make financial decisions\nkaysons budget spreadsheet\nwhat formula did kayson use to calculate the net savings/deficit in cell c25?\ncategory subcategory amount ($)\nsalary 2,500\nfreelance work 500\ninvestments 200\ntotal 3,200\nhousing rent/mortgage 1,000\nutilities 150\nmaintenance 50\ninsurance 30\ntotal 1,230\ntransportation fuel 100\npublic transport 50\nmaintenance 40\ninsurance 70\ntotal 260\nfood groceries 300\ndining out 100\ncoffee & snacks 30\ntotal 40\nentertainment movies & shows 40\n= c25\n= sum(c5 : c24)\n= c5 + c10 + c15 + c19 + c24\n= c5 - c10 - c15 - c19 - c24

analyzing data to make financial decisions\nkaysons budget spreadsheet\nwhat formula did kayson use to calculate the net savings/deficit in cell c25?\ncategory subcategory amount ($)\nsalary 2,500\nfreelance work 500\ninvestments 200\ntotal 3,200\nhousing rent/mortgage 1,000\nutilities 150\nmaintenance 50\ninsurance 30\ntotal 1,230\ntransportation fuel 100\npublic transport 50\nmaintenance 40\ninsurance 70\ntotal 260\nfood groceries 300\ndining out 100\ncoffee & snacks 30\ntotal 40\nentertainment movies & shows 40\n= c25\n= sum(c5 : c24)\n= c5 + c10 + c15 + c19 + c24\n= c5 - c10 - c15 - c19 - c24

Answer

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