Bil NAMA MURID BM gred BI gred MATH

1 Abdullah Ali 62 C 69 C 78

2 Ashraf Muhammad 75 B 80 B 60

3 Azizah Aziz 89 B 67 C 90

4 Chan Lin Lin 90 A 50 C 75

5 Mashitah Fazril 72 C 71 C 60

6 Munawar Rozaidi 68 C 87 B 79

7 Noradila Helmi 88 B 78 B 45

8 Norlina Ashaari 90 A 50 C 89

9 Dasuki Mamat 68 C 55 C 78

10 Ezlina Danial 37 E 86 B 79

11 Hayati Azam 90 A 67 C 78

12 Izadi Zizan 77 B 88 B 76

13 Jayathy a/p Pathma 56 C 83 B 39

14 Kamila Chin 78 B 45 D 70

15 Rosman Emran 90 A 43 D 89

16 Rosnani Nin 87 B 88 B 80

17 Suzi Ismail 90 A 76 B 75

18 Narita zaid 98 A 67 C 70

19 Amran Tawfeek 66 C 69 C 89

20 Zulaikha Mumin 67 C 83 B 70

21 Zaleha Ashaari 70 C 89 B 76

22 Zawawi Nabil 66 C 78 B 86

sort nama

GUNA SUM

VLOOKUP

RANK

AVERAGE

COUNTIF

markah gred keputusan

0 E GAGAL

40 D LULUS

50 C SEDERHANA

75 B BAIK

90 A CEMERLANG

gred SAINS gred Jumlah Purata Kedudukan GRED Keputusan

B 70 C 279 69.75 19 C SEDERHANA

C 88 B 303 75.75 8 B BAIK

A 70 C 316 79.00 3 B BAIK

B 86 B 301 75.25 11 B BAIK

C 69 C 272 68.00 20 C SEDERHANA

B 67 C 301 75.25 11 B BAIK

D 75 B 286 71.50 16 C SEDERHANA

B 78 B 307 76.75 6 B BAIK

B 94 A 295 73.75 13 C SEDERHANA

B 80 B 282 70.50 17 C SEDERHANA

B 91 A 326 81.50 2 B BAIK

B 75 B 316 79.00 3 B BAIK

E 57 C 235 58.75 22 C SEDERHANA

C 67 C 260 65.00 21 C SEDERHANA

B 60 C 282 70.50 17 C SEDERHANA

B 60 C 315 78.75 5 B BAIK

B 86 B 327 81.75 1 B BAIK

C 67 C 302 75.50 9 B BAIK

B 67 C 291 72.75 14 C SEDERHANA

C 82 B 302 75.50 9 B BAIK

B 69 C 304 76.00 7 B BAIK

B 58 C 288 72.00 15 C SEDERHANA

A B C D E

BAHASA MELAYU 6 6 9 0 1

BAHASA INGGERIS 0 11 9 2 0

MATHEMATIK 1 14 5 1 1

SCIENCE 2 8 12 0 0