latihan dan praktek excel
TRANSCRIPT
Matematika IPA IPS
1 Anna 90 85 80
2 Benedicta 60 75 90
3 Cristina 70 65 80
4 Dona Harun 80 90 80
5 Elfrida 75 78 70
6 Fransiskus 95 90 85
7 Gani 80 80 85
8 Hardiman 65 70 80
9 Imron 70 80 70
10 Jesica 80 85 75
No Nama Agama B. Indonesia Matematika IPA IPS
1 Ariyuda 75 80 90 65 80
2 Budiman 80 80 84 75 85
3 caprio 75 85 75 70 75
4 dona 70 75 85 80 70
5 Ericson 65 75 80 80 85
6 Fatonah 85 80 80 85 75
7 Gusriar 70 80 85 75 80
8 Ivan 85 95 90 95 90
9 Jonatan 75 65 85 70 85
10 Kasmiran 80 70 80 80 80
11 Lusia 75 75 65 80 80
12 Mustar 80 80 70 75 65
13 Novi 80 80 60 80 80
14 Poniman 70 80 90 95 95
15 Ruben 80 70 65 65 70
1145 1170 1184 1170 1195
76.3333333 78 78.9333333 78 79.66667
Nilai Maximum 85 95 90 95 95
Nilai Minimum 65 65 60 65 65
B. Indonesia Matematika IPA IPS
1 Budiman 70 70 65 70
2 Chayono 65 65 75 75
3 Feiisitas 90 85 90 95
4 Guritno 70 69 85 78
5 Martua 80 80 65 80
6 Rusdi 85 65 75 75
7 Sutrisno 90 70 85 88
8 Zakia 65 75 80 85
Rata-rata
Jumlah
No NamaNilai
NoNama
Nilai
Matematika B. Indonesia IPA IPS
IV-A 08.00-09.00 09.00-10.00 10.15-11-15 11.15-12.15
IV-B 08.00-09.01 09.00-10.01 10.15-11-16 11.15-12.16
V-A 08.00-09.02 09.00-10.02 10.15-11-17 11.15-12.17
V-B 08.00-09.03 09.00-10.03 10.15-11-18 11.15-12.18
VI-A 08.00-09.04 09.00-10.04 10.15-11-19 11.15-12.19
VI-B 08.00-09.05 09.00-10.05 10.15-11-20 11.15-12.20
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
Panjang lebar keliling luas
15 12 52 180
10 8 36 80
20 14 68 280
Matematika IPA IPS
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
KelasMata pelajaran
Jumlah
Rata-rata
Nilai Maksimum
Nilai Minimum
No NamaNilai
0% 50% 100%
Budiman
Chayono
Feiisitas
Guritno
Martua
Rusdi
Sutrisno
Zakia1
23
45
67
8
Nilai B. Indonesia
Nilai Matematika
Nilai IPA
Nilai IPS
No Mata Pelajaran Nilai
1 Agama 85
2 B. Indonesia 75
3 Matematika 65
4 IPA 60
5 IPS 80
0102030405060708090
Aga
ma
B. I
nd
on
esia
Mat
em
atik
a
IPA
IPS
1 2 3 4 5
Nilai
Nilai