Week 7a- Spreadsheet (Excel and open office Calc)

hello guys, girls.

quickly, I'll write on this week's task, two as usual:

Assignment 8a- One year personal financial management sheet.

this time, i have to do a one-year financial management sheet. take a look at the picture below:

this is my financial management sheet for the month of January.

 use formula to automatically count the total income for each month. as you can see in the picture above, the total income = B3+B4. B refers to the column, and the number 3 and 4 refer to the rows.

total expenditure= E4+E5+E6+E7+E8+E9+E10.

total balance= B7-E12. 

done for assignment 8a.now proceed to assignment 8b. creating a spreadsheet using Microsoft office excel 2007. for this task, i have to create a spreadsheet on students' score and grade analysis. the elements below have to be used in this spreadsheet.

1. define name
2. fill series.
3. VLOOKUP
4.STDEV
5.AVERAGE
6.COUNTIF
7.Graph
8.Sort
9.Filter

that's all for this week. thank you!