Question

analyzing data to make financial decisions
kaysons budget spreadsheet
what formula did kayson use to get the income category total in cell c5?
category subcategory amount ($)
1 salary 2,500
2 freelance work 500
3 investments 200
4 total 3,200
housing rent/mortgage 1,000
6 utilities 150
7 maintenance 50
8 insurance 30
9 total 1,230
transportation fuel 100
11 public transport 50
12 maintenance 40
13 insurance 70
14 total 260
food groceries 300
16 dining out 100
17 coffee & snacks 30
18 total 40
entertainment movies & shows 40
19
20
= c5 - c2
= c2 + c4
= sum(c2 : c4)
= sum(c2 + c4)

Explanation:

Step1: Identify income sub - categories

The income sub - categories are Salary (C2), Freelance work (C3), and Investments (C4).

Step2: Determine the formula for total

To find the total of these income sub - categories in cell C5, we use the sum function for the range of cells. The correct formula is to sum the values in cells C2, C3 and C4. In spreadsheet notation, this is written as $=sum(C2:C4)$.

Answer:

$=sum(C2:C4)$