Apply your own expense categories in the sheets. $(10\text{'})$

Cells with a colored background are ones whose values will be generated through a formula. All calculated results must be correct.

a$.$ "Daily Spending" means how much you spent in total on that day. $(5\text{'})$

b$.$ "Daily Balance" means how much money you have in the bank at the end of that day. $(5\text{'})$

c$.$ "Sub Total" means the total of the month of all the values for that column. $(5\text{'})$

d$.$ "Percentage of Total Spending" means the percentage of spending on a particular category with regards to total spending of the month, e$.$g$.$ if you spent $$100$ on gas, and spent $$1000$ in total $($put all spending together$),$ the percentage will be $10\%.(5\text{'})$

e$.$ "Final Balance" means how much money you have at the end of the month. $(5\text{'})$

January's beginning balance can be entered as a number $($you decide what number to enter$).$ Beginning balance of February will be the final balance of January, so on and so forth, in this way, all $12$ sheets are connected. $(10\text{'})$

Absolute reference must be used where appropriate. $(5\text{'})$

Make sure the days in each month are correct. E$.$g$.$ There are usually $28$ days in February. $(10\text{'})$

Add the following charts in each month.

a$.$ a column or bar chart with a meaningful title, $x$ and $y$ axis labels. $(5\text{'})$

b$.$ a line chart with a meaningful title, $x$ and $y$ axis labels. $(5\text{'})$

c$.$ a pie chart with a meaningful title, $x$ and $y$ axis labels. $(5\text{'})$

You decide what data to use in each chart, as long as data matches the chart type. $(5\text{'})$

You need $12$ sheets for $12$ months. Create a ${13}^{th}$ sheet and use this sheet to store total income for this year $($this sheet just need to have a label and a calculated number$).(10\text{'})$

Each sheet has a meaningful name $($such as January, February $...).(5\text{'})$

Each sheet has meaningful header or labels. $(5\text{'})$