soal praktek (ms excel)
TRANSCRIPT
1.
Kelas MAT B.IND IPA IPS
IV - A 8.00 - 9.00 9.00 - 10.00 10.15 - 11.15 11.15 - 12.15
IV - B 8.00 - 9.00 9.00 - 10.00 10.15 - 11.15 11.15 - 12.15
V - A 8.00 - 9.00 9.00 - 10.00 10.15 - 11.15 11.15 - 12.15
V - B 8.00 - 9.00 9.00 - 10.00 10.15 - 11.15 11.15 - 12.15
VI - A 8.00 - 9.00 9.00 - 10.00 10.15 - 11.15 11.15 - 12.15
VI - B 8.00 - 9.00 9.00 - 10.00 10.15 - 11.15 11.15 - 12.15
2. X Y X+Y X-Y X*Y X/Y
10 8 18 2 80 1,25
15 20 35 -5 300 0,75
25 12 37 13 300 2,083333
3. PANJANG LEBAR KELILING LUAS
15 12 54 180
10 8 36 80
20 14 40 280
4.
NO NAMA MAT IPA IPA
1 Aryo 80 70 65
2 Benigno 75 60 70
3 Ivana 90 85 95
4 Rusmanto 70 80 85
5 Susilawati 80 75 85
395 370 400
79 74 80
90 85 95
70 60 65NILAI MINIMUM
MATA PELAJARAN
JUMLAH
RATA-RATA
NILAI MAKSIMUM
5. NO MATA PELAJARAN NILAI
1 AGAMA 85
2 B.INDONEISA 75
3 MATEMATIKA 65
4 IPA 60
5 IPS 80
0%
20%
40%
60%
80%
100%
AGAMA
B.INDONEISA
MATEMATIKA
IPA
IPS
1 2 3 4 5
NILAI
NILAI