Blank Space pt.2

Latihan 1

=IF(E5="S3";25000000;IF(E5="S2";20000000;IF(E5="S1";15000000;IF(E5="D3";1000000;0)))) 

=IF(E6="S3";25000000;IF(E6="S2";2000000;IF(E6="S1";15000000;IF(E6="D3";1000000;0))))

=IF(E7="S3";25000000;IF(E7="S2";2000000;IF(E7="S1";15000000;IF(E7="D3";1000000;0))))

=IF(E8="S3";25000000;IF(E8="S2";20000000;IF(E8="S1";15000000;IF(E8="D3";10000000;0))))

=IF(E9="S3";25000000;IF(E9="S2";20000000;IF(E9="S1";15000000;IF(E9="D3";1000000;0))))

Latihan 2

JUMLAH SISWA HADIR   =COUNTA(C5:C19)

JUMLAH SISWA SAKIT =COUNTIF(G5:G19;"SAKIT")

JUMLAH SISWA ALFA =COUNTIF(G6:G20;"SAKIT")

JUMLAH SISWA IZIN =COUNTIF(G7:G21;"SAKIT")

Latihan 3

1. Total jual     =SUM(G6:J6)

2. Keuntungan       =(F6-E6)*L6

Total jual

Tkeseluruhan     =SUM(L6:L10)

Ttertinggi      =MAX(K6:K10)

Tterendah     =MIN(K6:K10)

Rta²    =AVERAGE(K6:K10)

Record      =COUNTA(A6:A10)

Latihan 4

Ttugas     =AVERAGE(D7:F7)

Tquiz      =AVERAGE(G7:H7)

Tnilai      =(I7+J7)/2

Grade         =IF(K7>=80;"A";IF(K7>=59;"B";IF(K7>=40;"C";"D")))