Question

basic budgeting analyzing data to make financial decisions what formula did kayson use to get the income category total in cell c5? = c5 - c2 = c2 + c4 = sum(c2 + c4) = sum(c2 : c4)

Explanation:

Step1: Identify income sub - categories

Income sub - categories are in cells C2 (Salary), C3 (Freelance work), C4 (Investments).

Step2: Determine formula for total

To get the total of income category in cell C5, we sum up the amounts in these sub - categories. In spreadsheet language, we use the sum function for a range. The range of income sub - category cells is C2:C4. So the formula is =sum(C2:C4).

Answer:

=sum(C2:C4)