week 7a:Spreadsheet

For week 7a, we have to do spreadsheet using Calc and microsoft excel. in the task of assignment 8a, we have o plan a one year personal finalcial management which have consist of our income and our spending which inlucdes electricity bill, food, house rental and etc. in this financial management spreadsheet, i have to learn to use the formula in calc which we have have to calculate the balance for each month and the balanced will bring forward to the next month. after i done with this spreadsheet, i uploaded the file to Google doc as instructed by Dr Siti.
As for assignment 8b, I created a spreadsheet with 15 students and along with 5 subjects which are English, bahasa melayu, mathematics, science and history. for this spreadsheet, i learnt to use:
o Define name
o Fill Series
o VLOOKUP
o STDEV
o AVERAGE
o COUNTIF
o Graph
o Sort
o Filter
in microsoft excel. it is very comvenient and easy to do with all the data with microsoft excel because i can do everything very fast.