LATIHAN EXCEL

gred MATH gred SAINS gred Jumlah Purata KedudukanGRED

B 75 B 86 B 327 81.75 1 B

C 78 B 91 A 326 81.50 2 B

C 90 A 70 C 316 79.00 3 B

B 76 B 75 B 316 79.00 3 B

B 80 B 60 C 315 78.75 5 B

C 89 B 78 B 307 76.75 6 B

B 76 B 69 C 304 76.00 7 B

B 60 C 88 B 303 75.75 8 B

C 70 C 67 C 302 75.50 9 B

B 70 C 82 B 302 75.50 9 B

C 75 B 86 B 301 75.25 11 B

B 79 B 67 C 301 75.25 11 B

C 78 B 94 A 295 73.75 13 C