Jawaban:

1. •Adzkia=85+75+80+80=320 {SUM(C6:F6)}

•Hasna=85+85+95+90=355 {SUM(C7:F7)}

•Nabila=75+80+85+90=330 {SUM(C8:F8)}

•Adilla=75+75+85+85=320 {SUM(C9:F9)}

•Firman=90+90+85+85=350 {SUM(C10:F10)}

2. Rata-rata=jumlah data:banyak data {AVERAGE}

•rata-rata Adzkia=320:4=80 {AVERAGE(C6:F6)}

•rata-rata Hasna=355:4=88,75 {AVERAGE(C7:F7)}

•rata-rata Nabila=330:4=82,5 {AVERAGE(C8:F8)}

•rata-rata Adilla=320:4=80 {AVERAGE(C9:F9)}

•rata-rata Firman=350:4=87,5 {AVERAGE(C10:F10)}

3. Ranking 1: Hasna

Ranking 2: Firman

Ranking 3: Nabila

Ranking 4: Adzkia dan Adilla

4. Nilai tertinggi IPA=Firman (90) {MAX(C6:C10)}

Nilai tertinggi TIK=Firman (90) {MAX(D6:D10)}

Nilai tertinggi MTK=Hasna (95) {MAX(E6:E7)}

Nilai tertinggi IPS=Hasna dan Nabila (90) {MAX(F6:F10)}

5. Nilai terendah IPA=Nabila dan adilla (75) {MIN(C6:C10)}

Nilai terendah TIK=Adzkia dan Adilla (75) {MIN(D6:D10)}

Nilai terendah MTK=Adzkia (80) {MIN(E6:E10)}

Nilai terendah IPS=Adzkia (80) {MIN(F6:F10)}

semoga membantu:)