Ms. excel pratik
2
SOAL PRATIK HAL 107 1. MAT B.INDO 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 4. Nilai 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 65 3. Panjang Lebar Keliling luas 15 12 54 180 10 8 36 80 20 14 68 280 5. NO Mata Pelajaran Nilai 1 Agama 85 2 B.indonesia 75 3 Matematika 65 4 IPA 60 5 IPS 80 Nilai Maxsimum Nilai Minimum Kelas Mata Pelajaran NO Nama Jumlah Rata-rata
-
Upload
riaastutiab -
Category
Education
-
view
58 -
download
3
Transcript of Ms. excel pratik
SOAL PRATIK HAL 107
1.
MAT B.INDO 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
4. Nilai
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 65
3. Panjang Lebar Keliling luas
15 12 54 180
10 8 36 80
20 14 68 280
5. NO Mata Pelajaran Nilai
1 Agama 85
2 B.indonesia 75
3 Matematika 65
4 IPA 60
5 IPS 80
Nilai Maxsimum
Nilai Minimum
KelasMata Pelajaran
NO Nama
Jumlah
Rata-rata
020406080
100
Agama
B.indonesia
Matematika
IPA
IPS
1 2 3 4 5
Nilai
Nilai
