Latihan Kelas 8 Excel Pertemuan 1.xlsx

A 56 50 60 80 78 79 80 55 85 90 98 95 35 75 85 90 50 60

B 60 70 80 90 95 98 76 80 55 90 70 60 65 38 85 70 60 50

TOTAL RATA-RATA NILAI TERTINGGI NILAI TERENDAH JUMLAH ITEM

A+B 116 120 140 170 173 177 156 135 140 180 168 155 100 113 170 160 110 110 2593 144.0556 180 100 18

ARITMATIKA MATEMATIKA DASAR A-B A*B A/B A*10% -4 3360 0.933333 5.6 -20 3500 0.714286 5 -20 4800 0.75 6 -10 7200 0.888889 8 -17 7410 0.821053 7.8 -19 7742 0.806122 7.9 4 6080 1.052632 8 -25 4400 0.6875 5.5 30 4675 1.545455 8.5 0 8100 1 9 28 6860 1.4 9.8 35 5700 1.583333 9.5 -30 2275 0.538462 3.5 37 2850 1.973684 7.5 0 7225 1 8.5 20 6300 1.285714 9 -10 3000 0.833333 5 10 3000 1.2 6

B*20% 12 14 16 18 19 19.6 15.2 16 11 18 14 12 13 7.6 17 14 12 10

B - (B*20%) 48 56 64 72 76 78.4 60.8 64 44 72 56 48 52 30.4 68 56 48 40

9 94477 19.0138 130.1 258.4 1033.6 0.5 5248.722 1.056322 7.227778 14.35556 57.42222222 37 8100 1.973684 9.8 19.6 78.4 -30 2275 0.538462 3.5 7.6 30.4 18 18 18 18 18 18

COUNT

A B 56 60 50 70 60 80 80 90 78 95 79 98 80 76 55 80 85 55 90 90 98 70 95 60 35 65 75 38 85 85 90 70 50 60 60 50 TOTAL RATA-RATA NILAI TERTINGGI NILAI TERENDAH JUMLAH ITEM

A+B 116 120 140 170 173 177

ARITMATIKA MATEMATIKA DASAR A-B A*B A/B A*10% -4 3360 0.933333 5.6 -20

B*20% 12

B - (B*20%) 48