Week 7(a) - Spreadsheet

For this week, we have to do two assignment which is 8(a) and 8(b)


for assignment 8a...

1. Plan, create and edit a simple  one year  personal financial management (income and spending)  spreadsheet using Calc .
2. Name the sheet  according to the month
3. Create a formula  to calculate  a  balance  for each month 
4. Link the formula between  the sheets.
5. Upload the file to google docs (spreadsheet) and edit it if necessary. 
6. Share with your lecturers

for assignment 8b....

we have to use the Microsoft Excel and use the function to create a student's score..

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