using microsoft office excel

From this lesson, I've learnt on how to use microsoft office excel to organize students marks (examination mark etc).

The following steps will guide you on how to do it.

1) Create a pink table.
2) Key in the students marks...(yellow table).
3) On the grade column..type this formula : =VLOOKUP(C2,$F$2:$G$6,2)
4) Repeat step 3 to all students' marks.

Good luck folks!!!


microsoft office excel