Ringkasan Pembelajaran-3/8/2011

            Pada permulaan kuliah hari ini, Puan Zakiah bertanya siapakah biasa dengan mengguna Microsoft Excel? Kebanyakan dalam kalangan kita tidak biasa dengan mengguna Microsoft Excel. Microsoft Excel boleh digunakan untuk membuat pengajaran.

          Dalam Microsoft Excel fx bar merujuk kepada formula bar. If want type words can type on formula bar or on the cell.

when create markah peperiksaan ujian bulanan
 ~right click to insert a new row
~enlarge word
 ~highlight by using click at row
~can insert picture, example: logo sekolah
~Rename sheet->right click on Sheet 1 to rename
~type school name-> wrap text to make the text easy to see-> middle Alignment
If want to print out then highlight the part that want then go to bottom border

-Bil. write 1 and 2 then drag until the number that you want
*tarikh also can do like this
~Jumlah->formulas-> recently used-> sum->highlight cell that you want-> OK
can create our own formula also->click on Jumlah then write = then click on first mark then write + same go on others

~Purata= Average
Jumlah dan Purata juga boleh drag
Cara lain highrlight markah yang ingin kira-> Auto sum
see who is fail: highlight cell-> Home-> conditional formating-> new rule-> format only cells that contains-> format only cells with: cell value-> less than-> format>colour change to red

~Prestasi-> choose cell then write = -> Insert function-> find lookup-> choose lookup value, lookup vector, result vector-> OK-> Lookup_value click cell - Purata-> Lookup_vector click cell that have 0, 40, 60, 70, 80(after that highlight then click F4)-> Result-vector click cell Lemah until Cemerlang(after that highlight then click F4)-> OK

~Gred: click lookup-> lookup_value,array->OK->create gred then click on lookup to insert lookup_value-> insert array with gred that have create(after that highlight then click F4)-> OK