week 7a (spreadsheet)

this week we are going to learn about calc and excel.


for assignment 8a, 
(1) we need to plan, create and edit a simple one year personal financial management which is about income and spending (spreadsheet) using Calc.


(2) neme the sheet according to the month for example, January, February, March and so on until December.


(3) to calculate a balance for each month, we need to create a formula and link it between the sheets.


(4) upload the file to Google docs (spreadsheet) and edit it if necessary.




and another assignment, 8a  (Microsoft Office Excel)

o Define name
o Fill Series
o VLOOKUP
o STDEV
o AVERAGE
o COUNTIF
o Graph
o Sort
o Filter

these are the functions that we need to learn throughout the lesson. 

 till then,

bye peeps!