Worksheetsexcel
Total questions: 10
Worksheet time: 5mins
Formulasi Rumus untuk Upah Kerja pada tabel adalah...
=C6*25000
=D6*25000
=45*25000
=15*25000
Formula Rumus Rata-rata Upah Seluruh karyawan adalah...
=SUM(i6:i15)
=Average(i6:i15)
=Min(i6:i15)
=Average(B6:B15)
Formulas Upah Tertinggi karyawan adalah...
=MIN(i6:i15)
=MAX(i6:i15)
=AVERAGE(i6:i15)
=SUM(i6:i15)
Formula rumus untuk Grade adalah...
=IF(D1<=90,"A",IF(D2<=80,"B",IF(D2<=70,"C","D")))
=IF(D2<=90,"A",IF(D2<=80,"B",IF(D2<=70,"C","D")))
=IF(D1>=90,"A",IF(D1>=80,"B",IF(D1>=70,"C","D")))
=IF(D2>=90,"A",IF(D2>=80,"B",IF(D2>=70,"C","D")))
Formula untuk Status adalah...
=IF(D2>75,"Complete","Failed")
=IF(D1>75,"Complete","Failed")
=IF(D1<75,"Complete","Failed")
=IF(D2<75,"Complete","Failed")
Formula untuk Diskon pada tabel adalah...
=VLOOKUP(C1;Tabel_Diskon,2)
=VLOOKUP(C1;Tabel_Diskon,1)
=VLOOKUP(C4;Tabel_Diskon,2)
=VLOOKUP(C4;Tabel_Diskon,1)
hasil dari =COUNT(B3:B12) dari tabel adalah...
5
7
9
10
hasil dari =COUNTA(B3:B12) adalah...
5
7
9
10
hasil dari =Left(B17;6)
F-2018
B-2018-I
F-2017
F-2017-A
hasil dari =MID(B16;2;4) adalah
2018
-201
018
18-1
