Book1.xlsx

Data Series 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday

january february march april may june july august september october november december january

Sunday Tuesday Thursday Saturday Monday Wednesday Friday Sunday Tuesday Thursday Saturday

14 senin 15 selasa 16 rabu 17 kamis 18 jumat 19 sabtu 20 minggu 21 senin 22 selasa 23 rabu 24 kamis 25 jumat 26 sabtu 27 minggu

DATA TYPE (TIPE DATA) NOMOR 670000600

NAMA Acounting currency fraction Rp 3,467.00 Rp46,987,658.00 1/2 Rp 234.00 Rp68,646,887.00 2/3 Rp 1,000,000.00 -Rp75,578.00 7/8 Rp 757,564.00 2 2/7 -Rp 3,000.00

000008965

Harga Rp Rp Rp Rp Rp

12,000.00 234,000.00 56,000.00 23,400.00 56,700.00

diskon 30.00% 20.00% 10.00% 5.00% 3.00%

Rp Rp Rp Rp Rp

total 8,400.00 187,200.00 50,400.00 22,230.00 54,999.00

(TIPE DATA)

persentace 2.00% 2.34% 23.00% 456.00% 67.00%

BORDER NO

D A F T A R N I L A I

NOMOR

NAMA SISWA

MTK

MATA PELAJARAN FIS KIM

TIK

GHJK HJJJ YJHFRHJKL

INI TULISAN YANG PANJANG

TABEL DAFTAR NILAI SISWA BONUS KELAS

DAFTAR NILAI SISWA

TABEL

NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

5.00% NIS 3340 3341 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3352 3353 3354

KKM NAMA Alisyah Sultana Mushkin Alatas Budi Iskandar Muda Cindy Lergiasti Nurul Afrilia Reno Sukiman Sukiman Jason Jr Lucas Darren Cecan Cogan Yoda

75

JK

KELAS

P L L L P P L L L L L P P L L

XI IPA 1 XI IPA 2 XI IPA 2 XI IPA 3 XI IPA 1 XI IPA 3 XI IPA 1 XI IPA 2 XI IPA 2 XI IPA 2 XI IPA 3 XI IPA 3 XI IPA 2 XI IPA 2 XI IPA 3

MTK 93 80 45 90 79 95 50 60 75 99 99 89 79 92 98

DAFTAR NILAI FISIKA BIOLOGI 80 80 30 90 75 63 88 66 84 75 96 97 65 75 84 94 91 97 90 91 75 92 68 88 99 77 70 66 75 86 Jumlah(SUM)

Jumlah per kriteria (SUMIFS)

Jumlah Data Per kriteria(COUNTIFS) Rata - rata (AVERAGE) Standasr Deviasi(STDEV) Nilai Tertinggi (MAX) Nilai Terendah (MIN) Median (MEDIAN) Jumlah Data (COUNT)

AR NILAI SISWA

DAFTAR NILAI KIMIA 90 20 77 88 99 97 64 67 78 94 97 85 84 84 78

ENGLISH 80 30 68 79 78 97 87 88 77 82 58 45 56 64 78

umlah(SUM)

iteria (SUMIFS)

kriteria(COUNTIFS)

E) DEV) X) N)

T)

L L L

JUMLAH NILAI 343 160 265 345 340 385 266 299 321 365 329 287 318 310 329 1223 788 451 10 6 3

101.06

RATA RANKING RATA TOTAL NILAI 85.75 90.04 4 40.00 42.00 15 66.25 69.56 14 86.25 90.56 3 85.00 89.25 5 96.25 101.06 1 66.50 69.83 13 74.75 78.49 11 80.25 84.26 8 91.25 95.81 2 82.25 86.36 6 71.75 75.34 12 79.50 83.48 9 77.50 81.38 10 82.25 86.36 6

KET.1

KET.2