Question

kaysons budget spreadsheet
what formula did kayson use to calculate the net savings/deficit in cell c25? =c25 =sum(c5:c24) =c5 - c10 - c15 - c19 - c24 =c5 + c10 + c15 + c19 + c24

Explanation:

Step1: Understand net - savings/deficit formula

Net savings/deficit is calculated as total income minus total expenses. In the spreadsheet, income is in cell C5 (salary) and additional income sources (if any) in C10 (freelance work) and C15 (investments). Expenses are in cells C19 (housing total), C24 (entertainment total).

Step2: Identify the correct formula

The formula to calculate net savings/deficit should subtract all expenses from all income sources. So the formula is =C5 + C10 + C15 - C19 - C24.

Answer:

=C5 + C10 + C15 + C19 + C24