Week 6: Personal Financial Management (Assignment 8a)

The task for this week are:-

a.       Plan, create and edit a simple one year personal financial management (income and spending) spreadsheet using Calc .

b.      Plan, create and edit a spreadsheet of students score and grade analysis

Personal Financial Management

Personal financial management using Calc. I doubt I'll be using this in near future. But it will be useful, say if i
have to do budget for certain event or activities. The task is easier than the other one. Probably because the
simple nature of adding and subtracting the amount, plus the automatic calculation (after you set it up) make
calculating easier all around.

As you can see in the picture above, income is written on the same column.

1) When you want to add the values say in this case, income+previous month balance.

2) Click on the column that you want the sum to appear, type = B3(income/first value)+ B4 (Previous Month Balance/ second value) and ENTER.


Note: The same steps can be applied to subtracting operation, just change the add symbol to minus.