Can help me solve this in excel and give the spreadsheet link pls

This question is based on Table 1. EXAMINATION REPORTS CORE SUBJECT ENGLISH MALAY MATH SEJARAH GEOGRAPHY GRADE TOTAL MARKS 500 CLASS NAME 100 100 100 100 100 A2 CHAN YEE SIN 78 65 80.54 43 67.03 A1 ASMIDAR AINI 67 85 75.02 25 87.87 A2 FUNG CHIN CHUA 32 77 78.76 56 43.90 A2 HANIS ANIDA 78 30 65.32 90 24.98 - A1 ABDULLAH KADIR 92 46 93.21 56 78.75 A1 HISYAM 77 75 72.02 76 53.08 B1 NAZRI ZAIRUL 49 23 62.43 76 90.98 2 Diploma OA220/ JUNE 22/ KOM4223 B2 FARHANA 54 80 75.09 80 53.04 B2 RAFIEDAA 98 65 90.03 88 47.56 B2 EARLY YUP 72 90 47.97 90 89.32 B3 LEE HOR SIN 69 76 73.03 80 70.98 B3 SEBASTIAN ADDIE 88 86 65.32 80 80.98 A3 FAIQ ZAHIN 95 80 58.09 92 80.87 A2 NAVATHEEN 75 78 50.94 92 54.04 A2 FARRAH NADHIRAH 80 95 59.01 60 93.02 A2 AMIRAH 57 87 95.06 60 90.21 B2 RAMADHANI 79 88 68.90 65 90.34 B2 HARITH HUSAINI 91 65 93.85 65 90.98 Table 1 A =>351 B = >310 and =251 and =250 E =