soal praktek (ms excel)

2
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 65 NILAI MINIMUM MATA PELAJARAN JUMLAH RATA-RATA NILAI MAKSIMUM

Upload: leo-mahesa

Post on 21-Mar-2017

45 views

Category:

Education


15 download

TRANSCRIPT

Page 1: Soal praktek (ms excel)

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

Page 2: Soal praktek (ms excel)

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