Carla Mae Cardano - G11_STEM A_CARDANO_CARLAMAE.xlsx

	A	B	C	D	E
1	2022 BUDGET
2	EXPENSES
3	Expenses	January	February	March	Total
4	Rent	3000	3000	3000	9000
5	Car Payment	15000	15000	15000	45000
6	Electric Bill	1500	2000	2500	6000
7	Telephone Bill	1000	1200	1500	3700
8	Internet Bill	1299	1299	1299	3897
9	Food	2500	2800	3000	8300
10	Gas	3000	3500	4000	10500
11	Total Expenses	27299	28799	30299	86397
12
13	INCOME
14	INCOME	January	February	March	Total
15	Parents	50000	50000	50000	150000
16	Part-time Job	5000	6000	7000	18000
17	Small Business	10000	15000	18000	43000
18	Total Income	65000	71000	75000	211000
19
20	BALANCE	124603
21	INSTRUCTIONS
22	1. Ok, fill in the formulas to add up the expenses for each month (dark blue area). Fill in the sum for each expense as well (yellow area). You are free to use either formulas or functions to create these totals.
23	(Hint: If you are going to use a function, your best choice here would be the SUM function.)
24
25	2. Now, fill (right/down) the formulas to add up the income for each month as well as the total from each income source (green and light blue areas). If you used a straight formula for the last step, try using a function this time. And, if you used a function last time, then try using a straight formula this time.
26	3. Now finish off the calculations and subtract the expenses from the income for each month, that is, the purple cell minus the red cell. This calculation should be located in cell B20 (grey cell).
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100