MENU SOALSTUDI KASUS --> 1STUDI KASUS --> 21STUDI KASUS --> 41STUDI KASUS --> 61STUDI KASUS --> 81STUDI KASUS --> 2STUDI KASUS --> 22STUDI KASUS --> 42STUDI KASUS --> 62STUDI KASUS --> 82STUDI KASUS --> 3STUDI KASUS --> 23STUDI KASUS --> 43STUDI KASUS --> 63STUDI KASUS --> 83STUDI KASUS --> 4STUDI KASUS --> 24STUDI KASUS --> 44STUDI KASUS --> 64STUDI KASUS --> 84STUDI KASUS --> 5STUDI KASUS --> 25STUDI KASUS --> 45STUDI KASUS --> 65STUDI KASUS --> 85STUDI KASUS --> 6STUDI KASUS --> 26STUDI KASUS --> 46STUDI KASUS --> 66STUDI KASUS --> 86STUDI KASUS --> 7STUDI KASUS --> 27STUDI KASUS --> 47STUDI KASUS --> 67STUDI KASUS --> 87STUDI KASUS --> 8STUDI KASUS --> 28STUDI KASUS --> 48STUDI KASUS --> 68STUDI KASUS --> 88STUDI KASUS --> 9STUDI KASUS --> 29STUDI KASUS --> 49STUDI KASUS --> 69STUDI KASUS --> 89STUDI KASUS --> 10STUDI KASUS --> 30STUDI KASUS --> 50STUDI KASUS --> 70STUDI KASUS --> 90STUDI KASUS --> 11STUDI KASUS --> 31STUDI KASUS --> 51STUDI KASUS --> 71STUDI KASUS --> 91STUDI KASUS --> 12STUDI KASUS --> 32STUDI KASUS --> 52STUDI KASUS --> 72STUDI KASUS --> 92STUDI KASUS --> 13STUDI KASUS --> 33STUDI KASUS --> 53STUDI KASUS --> 73STUDI KASUS --> 93STUDI KASUS --> 14STUDI KASUS --> 34STUDI KASUS --> 54STUDI KASUS --> 74STUDI KASUS --> 94STUDI KASUS --> 15STUDI KASUS --> 35STUDI KASUS --> 55STUDI KASUS --> 75STUDI KASUS --> 95STUDI KASUS --> 16STUDI KASUS --> 36STUDI KASUS --> 56STUDI KASUS --> 76STUDI KASUS --> 96STUDI KASUS --> 17STUDI KASUS --> 37STUDI KASUS --> 57STUDI KASUS --> 77STUDI KASUS --> 97STUDI KASUS --> 18STUDI KASUS --> 38STUDI KASUS --> 58STUDI KASUS --> 78STUDI KASUS --> 98STUDI KASUS --> 19STUDI KASUS --> 39STUDI KASUS --> 59STUDI KASUS --> 79STUDI KASUS --> 99STUDI KASUS --> 20STUDI KASUS --> 40STUDI KASUS --> 60STUDI KASUS --> 80STUDI KASUS --> 100

STUDI KASUS --> 1STUDI KASUS --> 2STUDI KASUS --> 3STUDI KASUS --> 4STUDI KASUS --> 5STUDI KASUS --> 6STUDI KASUS --> 7STUDI KASUS --> 8STUDI KASUS --> 9STUDI KASUS --> 10STUDI KASUS --> 11STUDI KASUS --> 12STUDI KASUS --> 13STUDI KASUS --> 14STUDI KASUS --> 15STUDI KASUS --> 16STUDI KASUS --> 17STUDI KASUS --> 18STUDI KASUS --> 19STUDI KASUS --> 20STUDI KASUS --> 21STUDI KASUS --> 22STUDI KASUS --> 23STUDI KASUS --> 24STUDI KASUS --> 25STUDI KASUS --> 26STUDI KASUS --> 27STUDI KASUS --> 28STUDI KASUS --> 29STUDI KASUS --> 30STUDI KASUS --> 31STUDI KASUS --> 32STUDI KASUS --> 33STUDI KASUS --> 34STUDI KASUS --> 35STUDI KASUS --> 36STUDI KASUS --> 37STUDI KASUS --> 38STUDI KASUS --> 39STUDI KASUS --> 40STUDI KASUS --> 41STUDI KASUS --> 42STUDI KASUS --> 43STUDI KASUS --> 44STUDI KASUS --> 45STUDI KASUS --> 46STUDI KASUS --> 47STUDI KASUS --> 48STUDI KASUS --> 49STUDI KASUS --> 50STUDI KASUS --> 51STUDI KASUS --> 52STUDI KASUS --> 53STUDI KASUS --> 54STUDI KASUS --> 55STUDI KASUS --> 56STUDI KASUS --> 57STUDI KASUS --> 58STUDI KASUS --> 59STUDI KASUS --> 60STUDI KASUS --> 61STUDI KASUS --> 62STUDI KASUS --> 63STUDI KASUS --> 64STUDI KASUS --> 65STUDI KASUS --> 66STUDI KASUS --> 67STUDI KASUS --> 68STUDI KASUS --> 69STUDI KASUS --> 70STUDI KASUS --> 71STUDI KASUS --> 72STUDI KASUS --> 73STUDI KASUS --> 74STUDI KASUS --> 75STUDI KASUS --> 76STUDI KASUS --> 77STUDI KASUS --> 78STUDI KASUS --> 79STUDI KASUS --> 80STUDI KASUS --> 81STUDI KASUS --> 82STUDI KASUS --> 83STUDI KASUS --> 84STUDI KASUS --> 85STUDI KASUS --> 86STUDI KASUS --> 87STUDI KASUS --> 88STUDI KASUS --> 89STUDI KASUS --> 90STUDI KASUS --> 91STUDI KASUS --> 92STUDI KASUS --> 93STUDI KASUS --> 94STUDI KASUS --> 95STUDI KASUS --> 96STUDI KASUS --> 97STUDI KASUS --> 98STUDI KASUS --> 99STUDI KASUS --> 100

MENU JAWABANSTUDI KASUS --> 1STUDI KASUS --> 21STUDI KASUS --> 41STUDI KASUS --> 61STUDI KASUS --> 81STUDI KASUS --> 2STUDI KASUS --> 22STUDI KASUS --> 42STUDI KASUS --> 62STUDI KASUS --> 82STUDI KASUS --> 3STUDI KASUS --> 23STUDI KASUS --> 43STUDI KASUS --> 63STUDI KASUS --> 83STUDI KASUS --> 4STUDI KASUS --> 24STUDI KASUS --> 44STUDI KASUS --> 64STUDI KASUS --> 84STUDI KASUS --> 5STUDI KASUS --> 25STUDI KASUS --> 45STUDI KASUS --> 65STUDI KASUS --> 85STUDI KASUS --> 6STUDI KASUS --> 26STUDI KASUS --> 46STUDI KASUS --> 66STUDI KASUS --> 86STUDI KASUS --> 7STUDI KASUS --> 27STUDI KASUS --> 47STUDI KASUS --> 67STUDI KASUS --> 87STUDI KASUS --> 8STUDI KASUS --> 28STUDI KASUS --> 48STUDI KASUS --> 68STUDI KASUS --> 88STUDI KASUS --> 9STUDI KASUS --> 29STUDI KASUS --> 49STUDI KASUS --> 69STUDI KASUS --> 89STUDI KASUS --> 10STUDI KASUS --> 30STUDI KASUS --> 50STUDI KASUS --> 70STUDI KASUS --> 90STUDI KASUS --> 11STUDI KASUS --> 31STUDI KASUS --> 51STUDI KASUS --> 71STUDI KASUS --> 91STUDI KASUS --> 12STUDI KASUS --> 32STUDI KASUS --> 52STUDI KASUS --> 72STUDI KASUS --> 92STUDI KASUS --> 13STUDI KASUS --> 33STUDI KASUS --> 53STUDI KASUS --> 73STUDI KASUS --> 93STUDI KASUS --> 14STUDI KASUS --> 34STUDI KASUS --> 54STUDI KASUS --> 74STUDI KASUS --> 94STUDI KASUS --> 15STUDI KASUS --> 35STUDI KASUS --> 55STUDI KASUS --> 75STUDI KASUS --> 95STUDI KASUS --> 16STUDI KASUS --> 36STUDI KASUS --> 56STUDI KASUS --> 76STUDI KASUS --> 96STUDI KASUS --> 17STUDI KASUS --> 37STUDI KASUS --> 57STUDI KASUS --> 77STUDI KASUS --> 97STUDI KASUS --> 18STUDI KASUS --> 38STUDI KASUS --> 58STUDI KASUS --> 78STUDI KASUS --> 98STUDI KASUS --> 19STUDI KASUS --> 39STUDI KASUS --> 59STUDI KASUS --> 79STUDI KASUS --> 99STUDI KASUS --> 20STUDI KASUS --> 40STUDI KASUS --> 60STUDI KASUS --> 80STUDI KASUS --> 100

STUDI KASUS --> 1STUDI KASUS --> 2STUDI KASUS --> 3STUDI KASUS --> 4STUDI KASUS --> 5STUDI KASUS --> 6STUDI KASUS --> 7STUDI KASUS --> 8STUDI KASUS --> 9STUDI KASUS --> 10STUDI KASUS --> 11STUDI KASUS --> 12STUDI KASUS --> 13STUDI KASUS --> 14STUDI KASUS --> 15STUDI KASUS --> 16STUDI KASUS --> 17STUDI KASUS --> 18STUDI KASUS --> 19STUDI KASUS --> 20STUDI KASUS --> 21STUDI KASUS --> 22STUDI KASUS --> 23STUDI KASUS --> 24STUDI KASUS --> 25STUDI KASUS --> 26STUDI KASUS --> 27STUDI KASUS --> 28STUDI KASUS --> 29STUDI KASUS --> 30STUDI KASUS --> 31STUDI KASUS --> 32STUDI KASUS --> 33STUDI KASUS --> 34STUDI KASUS --> 35STUDI KASUS --> 36STUDI KASUS --> 37STUDI KASUS --> 38STUDI KASUS --> 39STUDI KASUS --> 40STUDI KASUS --> 41STUDI KASUS --> 42STUDI KASUS --> 43STUDI KASUS --> 44STUDI KASUS --> 45STUDI KASUS --> 46STUDI KASUS --> 47STUDI KASUS --> 48STUDI KASUS --> 49STUDI KASUS --> 50STUDI KASUS --> 51STUDI KASUS --> 52STUDI KASUS --> 53STUDI KASUS --> 54STUDI KASUS --> 55STUDI KASUS --> 56STUDI KASUS --> 57STUDI KASUS --> 58STUDI KASUS --> 59STUDI KASUS --> 60STUDI KASUS --> 61STUDI KASUS --> 62STUDI KASUS --> 63STUDI KASUS --> 64STUDI KASUS --> 65STUDI KASUS --> 66STUDI KASUS --> 67STUDI KASUS --> 68STUDI KASUS --> 69STUDI KASUS --> 70STUDI KASUS --> 71STUDI KASUS --> 72STUDI KASUS --> 73STUDI KASUS --> 74STUDI KASUS --> 75STUDI KASUS --> 76STUDI KASUS --> 77STUDI KASUS --> 78STUDI KASUS --> 79STUDI KASUS --> 80STUDI KASUS --> 81STUDI KASUS --> 82STUDI KASUS --> 83STUDI KASUS --> 84STUDI KASUS --> 85STUDI KASUS --> 86STUDI KASUS --> 87STUDI KASUS --> 88STUDI KASUS --> 89STUDI KASUS --> 90STUDI KASUS --> 91STUDI KASUS --> 92STUDI KASUS --> 93STUDI KASUS --> 94STUDI KASUS --> 95STUDI KASUS --> 96STUDI KASUS --> 97STUDI KASUS --> 98STUDI KASUS --> 99STUDI KASUS --> 100

1-S1. Penjumlahan Data yang Tidak Benar123456789101247111622293746562481526426493130176232371530569816225538556179341126561122103726271012157323665164298210420792141924314004637062264162372792158430035434943815808729932556271419300360061144020878366868371303851012243154341144022880437588044494617656115734004943820878437588751616796010562327932366637015808366868044416796033592011672991092345898282563662322142766310726646646127937814704928147564039210271424548055620612028521392470194068682162462016164730410210966416216926814106576251693843100893024257754667964163438038036481512169732131259743605136629394383106234726967276500375

MENU

1-J1. Solusi - Penjumlahan Data12345678910123456789101123456789101112345678910111213456789101112131456789101112131415678910111213141516789101112131415161789101112131415161718910111213141516171819101112131415161718192011121314151617181920211213141516171819202122131415161718192021222314151617181920212223241516171819202122232425

MENUMENU

2-S2. Perkalian Data yang Tidak Benar1234567891011262412072050404032036288036288002242457669120497664002508226560001011316948992000036698669445021696000001331721316820947400000000000036245763317762293235712011412608573767700002862540794360781400000000000002894936022518081000000000000000000000000000000106240300154876940000000000000000000000000000000000000000000000000001414824724217054300000000000000000000000000000000000000000000000000000000000000000000000000000004245763317761100753141762524286414780230500000288086927799661400000000000000000000000082466058314859980000000000000000000000000000000000000000000000000000023873396285076490000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002536316787042850400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000035884436987549860000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005120691202293235712025242864147802305000006372021903844030000000000000000000000000000183569621415057600000000000000000000000000000000000000000000000000000000000000000001513826310445090800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000036140175416030876000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006720497664001141260857376770000288086927799661400000000000000000000000018356962141505760000000000000000000000000000000000000000000000000000000000000000000336978059064675700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000075040250822656000286254079436078140000000000000824660583148599800000000000000000000000000000000000000000000000000000151382631044509080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000084032010113169489920000289493602251808100000000000000000000000000000023873396285076490000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003614017541603087600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000936288036698669445021696000001062403001548769400000000000000000000000000000000000000000000000000025363167870428504000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000103628800133172131682094740000000000001414824724217054300000000000000000000000000000000000000000000000000000000000000000000000000000003588443698754986000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000113991680053158053459278390000000000000000000075209328325438980000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012479001600254627926598798850000000000000000000000000000191503953323948400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000136227020800158557339519159370000000000000000000000000000000000000030364357346446537000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014871782912001382275791649854300000000000000000000000000000000000000000000000004197191608899846000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000015130767436800018075666222474228000000000000000000000000000000000000000000000000000000000000000000000

MENU

2-J2. Solusi - Perkalian Data yang Tidak Benar12345678910112345678910224681012141618203369121518212427304481216202428323640551015202530354045506612182430364248546077142128354249566370881624324048566472809918273645546372819010102030405060708090100111122334455667788991101212243648607284961081201313263952657891104117130141428425670849811212614015153045607590105120135150

MENU

3-S3. Kesalahan Penggunaan Rumus Relatif dan AbsolutHarga Premium/Liter4,500Jumlah LiterJumlah Harga14,50020.030.0418,00050.060.07126,00080.090.0101,260,000110.0120.01316,380,000140.0150.0

MENU

3-J3. Solusi - Kesalahan Penggunaan Rumus Relatif dan AbsolutHarga Premium/Liter4,500Jumlah LiterJumlah Harga14,50029,000313,500418,000522,500627,000731,500836,000940,5001045,0001149,5001254,0001358,5001463,0001567,500

MENUMENU

4-S4. Penulisan Rumus yang Tidak TepatNilai PokokRp5,000,000Bunga Per Tahun8%TahunSaldo AwalBungaSaldo Akhir2007Rp5,000,000Rp400,000Rp5,400,0002008Rp5,400,0000.0Rp5,400,0002009Rp5,400,0000.00.020100.00.00.020110.00.00.020120.00.00.020130.00.00.020140.00.00.020150.00.00.0CatatanAlamat sel bunga seharusnya semi absolut

MENU

4-J4. Solusi - Penulisan Rumus yang Tidak TepatNilai PokokRp5,000,000Bunga Per Tahun8%TahunSaldo AwalBungaSaldo Akhir2007Rp5,000,000Rp400,000Rp5,400,0002008Rp5,400,000Rp432,000Rp5,832,0002009Rp5,832,000Rp466,560Rp6,298,5602010Rp6,298,560Rp503,885Rp6,802,4452011Rp6,802,445Rp544,196Rp7,346,6402012Rp7,346,640Rp587,731Rp7,934,3722013Rp7,934,372Rp634,750Rp8,569,1212014Rp8,569,121Rp685,530Rp9,254,6512015Rp9,254,651Rp740,372Rp9,995,023

MENUMENU

5-S5. Kesalahan Pembuatan Rumus AbsolutNO.NAMA BARANGHARGAVOLUMEJML.HARGADISKON 30%JML.DIBAYAR1Meja BelajarRp775,0007Rp5,425,000Rp1,627,500Rp3,797,5002Rak BukuRp250,0006Rp1,500,000Rp2,441,250,000,000Rp(2,441,248,500,000)3Meja KerjaRp350,0008Rp2,800,000Rp6,835,500,000,000,000,000Rp(6,835,499,999,997,200,000)4Almari PakaianRp175,0008Rp1,400,000Rp9,569,700,000,000,000,000,000,000Rp(9,569,700,000,000,000,000,000,000)5Meja KomputerRp450,0007Rp3,150,000Rp30,144,555,000,000,000,000,000,000,000,000Rp(30,144,555,000,000,000,000,000,000,000,000)6Meja MakanRp375,0005Rp1,875,000Rp56,521,040,625,000,000,000,000,000,000,000,000,000Rp(56,521,040,625,000,000,000,000,000,000,000,000,000)7Tempat Tidur SingleRp650,0006Rp3,900,000Rp220,432,058,437,500,000,000,000,000,000,000,000,000,000,000Rp(220,432,058,437,500,000,000,000,000,000,000,000,000,000,000)8Tempat Tidur DoubleRp900,00012Rp10,800,000Rp2,380,666,231,125,000,000,000,000,000,000,000,000,000,000,000,000,000Rp(2,380,666,231,125,000,000,000,000,000,000,000,000,000,000,000,000,000)TOTAL PENJUALANRp3,925,00059Rp30,850,000Rp9,255,000Rp21,595,000CatatanAlamat pada diskon harusnya semi absolut

MENU

5-J5. Solusi - Kesalahan Pembuatan Rumus AbsolutNO.NAMA BARANGHARGAVOLUMEJML.HARGADISKON 30%JML.DIBAYAR1Meja BelajarRp775,0007Rp5,425,000Rp1,627,500Rp3,797,5002Rak BukuRp250,0006Rp1,500,000Rp450,000Rp1,050,0003Meja KerjaRp350,0008Rp2,800,000Rp840,000Rp1,960,0004Almari PakaianRp175,0008Rp1,400,000Rp420,000Rp980,0005Meja KomputerRp450,0007Rp3,150,000Rp945,000Rp2,205,0006Meja MakanRp375,0005Rp1,875,000Rp562,500Rp1,312,5007Tempat Tidur SingleRp650,0006Rp3,900,000Rp1,170,000Rp2,730,0008Tempat Tidur DoubleRp900,00012Rp10,800,000Rp3,240,000Rp7,560,000TOTAL PENJUALANRp3,925,00059Rp30,850,000Rp9,255,000Rp21,595,000

MENUMENU

6-S6. Kesalahan Penulisan Fungsi Pembacaan Tabel, VLOOKUPNO.NAMAGOLGAJITUNJANGANGOLGAJITUNJANGAN1MOCHAMAD HASANA1,000,000100,000B2,000,00020%2DJONG DJIT TJINC3,000,000900,000A1,000,00010%3SRI ADYANTI SUDHARMONOB0.00.0C3,000,00030%4HARI MARTONOC0.00.05H.M KOERNIA POETRAD0.00.06MIMI RUSMINIC0.00.07EBO KUSMANTOD0.00.08NG.WILLIAM HARTONOB0.00.09RUSTAM RAUFB0.00.010THE LE FAB0.00.011VINCIA QUINTARIA0.00.012SOEBAKTI HARSONOC0.00.013SUKATOND0.00.014WINS INDRAJAYA, WONGB0.00.015SILFRIANIA0.00.0T O T A L

MENU

6-J6. Solusi - Kesalahan Penulisan Fungsi Pembacaan Tabel, VLOOKUPNO.NAMAGOLGAJITUNJANGANGOLGAJITUNJANGAN1MOCHAMAD HASANA1,000,000100,000B2,000,00020%2DJONG DJIT TJINC3,000,000900,000A1,000,00010%3SRI ADYANTI SUDHARMONOB1,000,000100,000C3,000,00030%4HARI MARTONOC3,000,000900,0005H.M KOERNIA POETRAD3,000,000900,0006MIMI RUSMINIC3,000,000900,0007EBO KUSMANTOD3,000,000900,0008NG.WILLIAM HARTONOB1,000,000100,0009RUSTAM RAUFB1,000,000100,00010THE LE FAB1,000,000100,00011VINCIA QUINTARIA1,000,000100,00012SOEBAKTI HARSONOC3,000,000900,00013SUKATOND3,000,000900,00014WINS INDRAJAYA, WONGB1,000,000100,00015SILFRIANIA1,000,000100,000T O T A L29,000,0007,100,000

MENUMENU

7-S7. Kesalahan Saat Menggunakan Fungsi VLOOKUPNO.NAMAKODEJABATANGAJI POKOKKODEJABATANGAJI POKOK1TULUS RAHARDJO1DIREKTUR10,000,0001DIREKTUR10,000,0002DARMONO3MANAGER6,000,0002MANAGER6,000,0003NASRIL DARWIS3MANAGER6,000,0003SUPERVISOR4,000,0004HENDIC WARJAYA2MANAGER6,000,0004STAFF2,000,0005COLLIN SITUMORANG3MANAGER6,000,0006BUDI SETIAWAN2MANAGER6,000,0007H. SUTRISNO3MANAGER6,000,0008JC.SRI MARTINI4MANAGER6,000,0009ROSMIE SIMANJUNTAK3MANAGER6,000,00010AGUS SAEFULLAH4MANAGER6,000,00011TAN JULIANA3MANAGER6,000,00012PHUN IRWAN4MANAGER6,000,00013F MURYATI ARRYONO3MANAGER6,000,00014MORAKAS HARUMANTO3MANAGER6,000,00015TIOLINA MANURUNG3MANAGER6,000,000T O T A L94,000,000

MENU

7-J7. Solusi - Kesalahan Saat Menggunakan Fungsi VLOOKUPNO.NAMAKODEJABATANGAJI POKOKKODEJABATANGAJI POKOK1TULUS RAHARDJO1DIREKTUR10,000,0001DIREKTUR10,000,0002DARMONO3SUPERVISOR4,000,0002MANAGER6,000,0003NASRIL DARWIS3SUPERVISOR4,000,0003SUPERVISOR4,000,0004HENDIC WARJAYA2MANAGER6,000,0004STAFF2,000,0005COLLIN SITUMORANG3SUPERVISOR4,000,0006BUDI SETIAWAN2MANAGER6,000,0007H. SUTRISNO3SUPERVISOR4,000,0008JC.SRI MARTINI4STAFF2,000,0009ROSMIE SIMANJUNTAK3SUPERVISOR4,000,00010AGUS SAEFULLAH4STAFF2,000,00011TAN JULIANA3SUPERVISOR4,000,00012PHUN IRWAN4STAFF2,000,00013F MURYATI ARRYONO3SUPERVISOR4,000,00014MORAKAS HARUMANTO3SUPERVISOR4,000,00015TIOLINA MANURUNG3SUPERVISOR4,000,000T O T A L64,000,000

MENUMENU

8-S8. Kesalahan dalam Penggunaan Fungsi HLOOKUPNO.NAMAKODEHARGADISKONKODEABC1SILFRIANIA500,00050,000HARGA500,000750,0001,000,0002MOCHAMAD HASANC0.00.0DISKON10%15%20%3DJONG DJIT TJINB0.00.04SRI ADYANTI SUDHARMONOB0.00.05RUSTAM RAUFC0.00.06THE LE FAB0.00.07VINCIA QUINTARIC0.00.08SOEBAKTI HARSONOA0.00.09SUKATONB0.00.010WINS INDRAJAYA, WONGC0.00.011HARI MARTONOD0.00.012H.M KOERNIA POETRAE0.00.013MIMI RUSMINID0.00.014EBO KUSMANTOD0.00.015NG.WILLIAM HARTONOD0.00.0T O T A L

MENU

8-J8. Solusi - Kesalahan dalam Penggunaan Fungsi HLOOKUPNO.NAMAKODEHARGADISKONKODEABC1SILFRIANIA500,00050,000HARGA500,000750,0001,000,0002MOCHAMAD HASANC1,000,000200,000DISKON10%15%20%3DJONG DJIT TJINB750,000112,5004SRI ADYANTI SUDHARMONOB750,000112,5005RUSTAM RAUFC1,000,000200,0006THE LE FAB750,000112,5007VINCIA QUINTARIC1,000,000200,0008SOEBAKTI HARSONOA500,00050,0009SUKATONB750,000112,50010WINS INDRAJAYA, WONGC1,000,000200,00011HARI MARTONOD1,000,000200,00012H.M KOERNIA POETRAE1,000,000200,00013MIMI RUSMINID1,000,000200,00014EBO KUSMANTOD1,000,000200,00015NG.WILLIAM HARTONOD1,000,000200,000T O T A L

MENUMENU

9-S9. Kesalahan Penulisan pada Argumen Fungsi VLOOKUPNO.NAMAKIMIAFISIKABIOLOGIRATA-RATAPREDIKATKETERANGANRATA-RATAPREDIKATKETERANGAN1MOCHAMAD HASAN828277800.00.00DKURANG MEMUASKAN2DJONG DJIT TJIN869189890.00.060CCUKUP MEMUASKAN3SRI ADYANTI SUDHARMONO868684850.00.085BMEMUASKAN4HARI MARTONO828186830.00.095ASANGAT MEMUASKAN5RUSTAM RAUF828177800.00.06H.M KOERNIA POETRA919191910.00.07MIMI RUSMINI869189890.00.08EBO KUSMANTO818281810.00.09NG.WILLIAM HARTONO819181840.00.010THE LE FA778679800.00.011VINCIA QUINTARI828177800.00.012SOEBAKTI HARSONO868189850.00.013SUKATON818181810.00.014WINS INDRAJAYA, WONG778179790.00.015SILFRIANI367254540.00.0

MENU

9-J9. Solusi - Kesalahan Penulisan pada Argumen Fungsi VLOOKUPNO.NAMAKIMIAFISIKABIOLOGIRATA-RATAPREDIKATKETERANGANRATA-RATAPREDIKATKETERANGAN1MOCHAMAD HASAN82827780CCUKUP MEMUASKAN0DKURANG MEMUASKAN2DJONG DJIT TJIN86918989BMEMUASKAN60CCUKUP MEMUASKAN3SRI ADYANTI SUDHARMONO86868485BMEMUASKAN85BMEMUASKAN4HARI MARTONO82818683CCUKUP MEMUASKAN95ASANGAT MEMUASKAN5RUSTAM RAUF82817780CCUKUP MEMUASKAN6H.M KOERNIA POETRA91919191BMEMUASKAN7MIMI RUSMINI86918989BMEMUASKAN8EBO KUSMANTO81828181CCUKUP MEMUASKAN9NG.WILLIAM HARTONO81918184CCUKUP MEMUASKAN10THE LE FA77867980CCUKUP MEMUASKAN11VINCIA QUINTARI82817780CCUKUP MEMUASKAN12SOEBAKTI HARSONO86818985BMEMUASKAN13SUKATON81818181CCUKUP MEMUASKAN14WINS INDRAJAYA, WONG77817979CCUKUP MEMUASKAN15SILFRIANI36725454DKURANG MEMUASKAN

MENUMENU

10-S10. Lupa Tidak Mengawali Tanda "=" di depan Rumus PenjumlahanNO.NAMAGOLGAJITUNJANGANJUMLAHGOLGAJITUNJANGAN1MOCHAMAD HASANA1,000,000100,000SUM(E5:F5)A1,000,00010%2DJONG DJIT TJINC3,000,000900,000SUM(E5:F5)B2,000,00020%3SRI ADYANTI SUDHARMONOB2,000,000400,000SUM(E5:F5)C3,000,00030%4HARI MARTONOC3,000,000900,000SUM(E5:F5)5H.M KOERNIA POETRAA1,000,000100,000SUM(E5:F5)6MIMI RUSMINIC3,000,000900,000SUM(E5:F5)7EBO KUSMANTOC3,000,000900,000SUM(E5:F5)8NG.WILLIAM HARTONOB2,000,000400,000SUM(E5:F5)9RUSTAM RAUFB2,000,000400,000SUM(E5:F5)10THE LE FAB2,000,000400,000SUM(E5:F5)11VINCIA QUINTARIA1,000,000100,000SUM(E5:F5)12SOEBAKTI HARSONOC3,000,000900,000SUM(E5:F5)13SUKATONB2,000,000400,000SUM(E5:F5)14WINS INDRAJAYA, WONGB2,000,000400,000SUM(E5:F5)15SILFRIANIA1,000,000100,000SUM(E5:F5)T O T A L31,000,0007,300,0000.0

MENU

10-J10. Solusi - Lupa Tidak Mengawali Tanda "=" di depan Rumus PenjumlahanNO.NAMAGOLGAJITUNJANGANJUMLAHGOLGAJITUNJANGAN1MOCHAMAD HASANA1,000,000100,0001,100,000A1,000,00010%2DJONG DJIT TJINC3,000,000900,0003,900,000B2,000,00020%3SRI ADYANTI SUDHARMONOB2,000,000400,0002,400,000C3,000,00030%4HARI MARTONOC3,000,000900,0003,900,0005H.M KOERNIA POETRAA1,000,000100,0001,100,0006MIMI RUSMINIC3,000,000900,0003,900,0007EBO KUSMANTOC3,000,000900,0003,900,0008NG.WILLIAM HARTONOB2,000,000400,0002,400,0009RUSTAM RAUFB2,000,000400,0002,400,00010THE LE FAB2,000,000400,0002,400,00011VINCIA QUINTARIA1,000,000100,0001,100,00012SOEBAKTI HARSONOC3,000,000900,0003,900,00013SUKATONB2,000,000400,0002,400,00014WINS INDRAJAYA, WONGB2,000,000400,0002,400,00015SILFRIANIA1,000,000100,0001,100,000T O T A L31,000,0007,300,00038,300,000

MENUMENU

11-S11. Penulisan Fungsi VLOOKUP Tidak TepatNO.NAMAGAJI POKOKRANGEGAJI POKOKRANGE1LIM TJIN HIOK4,000,00000< RP. 5 JUTA2DARLAN E.HARAHAP10,000,00010 - < RP. 15 JUTA5,000,0005 - < RP. 10 JUTA3DJAMAN10,000,00010 - < RP. 15 JUTA10,000,00010 - < RP. 15 JUTA4TOMIGAN TARIGAN7,000,000015,000,000> RP. 15 JUTA5GUNAWAN AGUS SUBRATA10,000,00010 - < RP. 15 JUTA6SOENARRIYONO BS7,000,00007I DEWA NYOMAN SUWINADJA10,000,00010 - < RP. 15 JUTA8ACHMAD R.15,000,000> RP. 15 JUTA9RIANG SUDARMANTO10,000,00010 - < RP. 15 JUTA10ACHMAD BUDIYANTO15,000,000> RP. 15 JUTA11MARZUKI DAUD10,000,00010 - < RP. 15 JUTA12SOLFEMI15,000,000> RP. 15 JUTA13H.DIDI SURYANA TISDIANA10,000,00010 - < RP. 15 JUTA14POERWOKO SOEPARYONO10,000,00010 - < RP. 15 JUTA15CHRISTIANI J.A10,000,00010 - < RP. 15 JUTAT O T A L153,000,000

MENU

11-J11. Solusi - Penulisan Fungsi VLOOKUP Tidak TepatNO.NAMAGAJI POKOKRANGEGAJI POKOKRANGE1LIM TJIN HIOK4,000,000< RP. 5 JUTA0< RP. 5 JUTA2DARLAN E.HARAHAP10,000,00010 - < RP. 15 JUTA5,000,0005 - < RP. 10 JUTA3DJAMAN10,000,00010 - < RP. 15 JUTA10,000,00010 - < RP. 15 JUTA4TOMIGAN TARIGAN7,000,0005 - < RP. 10 JUTA15,000,000> RP. 15 JUTA5GUNAWAN AGUS SUBRATA10,000,00010 - < RP. 15 JUTA6SOENARRIYONO BS7,000,0005 - < RP. 10 JUTA7I DEWA NYOMAN SUWINADJA10,000,00010 - < RP. 15 JUTA8ACHMAD R.15,000,000> RP. 15 JUTA9RIANG SUDARMANTO10,000,00010 - < RP. 15 JUTA10ACHMAD BUDIYANTO15,000,000> RP. 15 JUTA11MARZUKI DAUD10,000,00010 - < RP. 15 JUTA12SOLFEMI15,000,000> RP. 15 JUTA13H.DIDI SURYANA TISDIANA10,000,00010 - < RP. 15 JUTA14POERWOKO SOEPARYONO10,000,00010 - < RP. 15 JUTA15CHRISTIANI J.A10,000,00010 - < RP. 15 JUTAT O T A L153,000,000

MENUMENU

12-S12. Penulisan Argumen pada Fungsi VLOOKUP Tidak TepatNO.NAMAGOLGAJITUNJANGANGOLGAJITUNJANGAN1MOCHAMAD HASANA01,000,000B2,000,00020%2DJONG DJIT TJINC03,000,000A1,000,00010%3SRI ADYANTI SUDHARMONOB01,000,000C3,000,00030%4HARI MARTONOC03,000,0005H.M KOERNIA POETRAD03,000,0006MIMI RUSMINIC03,000,0007EBO KUSMANTOD03,000,0008NG.WILLIAM HARTONOB01,000,0009RUSTAM RAUFB01,000,00010THE LE FAB01,000,00011VINCIA QUINTARIA01,000,00012SOEBAKTI HARSONOC03,000,00013SUKATOND03,000,00014WINS INDRAJAYA, WONGB01,000,00015SILFRIANIA01,000,000T O T A L

MENU

12-J12. Solusi - Penulisan Argumen pada Fungsi VLOOKUP Tidak TepatNO.NAMAGOLGAJITUNJANGANGOLGAJITUNJANGAN1MOCHAMAD HASANA1,000,000100,000B2,000,00020%2DJONG DJIT TJINC3,000,000900,000A1,000,00010%3SRI ADYANTI SUDHARMONOB1,000,000100,000C3,000,00030%4HARI MARTONOC3,000,000900,0005H.M KOERNIA POETRAD3,000,000900,0006MIMI RUSMINIC3,000,000900,0007EBO KUSMANTOD3,000,000900,0008NG.WILLIAM HARTONOB1,000,000100,0009RUSTAM RAUFB1,000,000100,00010THE LE FAB1,000,000100,00011VINCIA QUINTARIA1,000,000100,00012SOEBAKTI HARSONOC3,000,000900,00013SUKATOND3,000,000900,00014WINS INDRAJAYA, WONGB1,000,000100,00015SILFRIANIA1,000,000100,000T O T A L29,000,0007,100,000

MENUMENU

13-S13. Penulisan Argumen Fungsi VLOOKUP Tidak TepatNO.NAMAGOLGAJITUNJANGANGOLGAJITUNJANGAN1MOCHAMAD HASANA00B2,000,00020%2DJONG DJIT TJINC00A1,000,00010%3SRI ADYANTI SUDHARMONOB00C3,000,00030%4HARI MARTONOC005H.M KOERNIA POETRAD006MIMI RUSMINIC007EBO KUSMANTOD008NG.WILLIAM HARTONOB009RUSTAM RAUFB0010THE LE FAB0011VINCIA QUINTARIA0012SOEBAKTI HARSONOC0013SUKATOND0014WINS INDRAJAYA, WONGB0015SILFRIANIA00T O T A L

MENU

13-J13. Solusi - Penulisan Argumen Fungsi VLOOKUP Tidak TepatNO.NAMAGOLGAJITUNJANGANGOLGAJITUNJANGAN1MOCHAMAD HASANA1,000,000100,000B2,000,00020%2DJONG DJIT TJINC3,000,000900,000A1,000,00010%3SRI ADYANTI SUDHARMONOB1,000,000100,000C3,000,00030%4HARI MARTONOC3,000,000900,0005H.M KOERNIA POETRAD3,000,000900,0006MIMI RUSMINIC3,000,000900,0007EBO KUSMANTOD3,000,000900,0008NG.WILLIAM HARTONOB1,000,000100,0009RUSTAM RAUFB1,000,000100,00010THE LE FAB1,000,000100,00011VINCIA QUINTARIA1,000,000100,00012SOEBAKTI HARSONOC3,000,000900,00013SUKATOND3,000,000900,00014WINS INDRAJAYA, WONGB1,000,000100,00015SILFRIANIA1,000,000100,000T O T A L29,000,0007,100,000

MENUMENU

14-S14. Penulisan Rumus Waktu Tidak TepatSEWA/JAMRp7,000.00NO.NAMAMULAISELESAILAMASEWAJML.BIAYA SEWADISKONTOTAL1Indah9:0017:008:00Rp2,3330.0Rp2,3332Dinda9:0016:307:30Rp2,1880.0Rp2,1883Erni9:0018:009:00Rp2,6250.0Rp2,6254Afrezar9:2014:305:10Rp1,5070.0Rp1,5075Falaq9:3014:004:30Rp1,3130.0Rp1,3136Kempul9:3014:305:00Rp1,4580.0Rp1,4587Ien Ien10:0015:005:00Rp1,4580.0Rp1,4588Yulie10:0015:005:00Rp1,4580.0Rp1,4589Arto10:0016:006:00Rp1,7500.0Rp1,75010Dani10:0016:006:00Rp1,7500.0Rp1,75011Arum10:0016:006:00Rp1,7500.0Rp1,75012Libra10:0016:006:00Rp1,7500.0Rp1,75013Aries11:0016:005:00Rp1,4580.0Rp1,45814Umie Koe11:0017:006:00Rp1,7500.0Rp1,75015Debora11:4517:005:15Rp1,5310.0Rp1,531JUMLAHRp26,0800.0Rp26,080

MENU

14-J14. Solusi - Penulisan Rumus Waktu Tidak TepatSEWA/JAMRp7,000.00NO.NAMAMULAISELESAILAMASEWAJML.BIAYA SEWADISKONTOTAL1Indah9:0017:008.00Rp56,000Rp11,200Rp44,8002Dinda9:0016:307.50Rp52,500Rp10,500Rp42,0003Erni9:0018:009.00Rp63,000Rp12,600Rp50,4004Afrezar9:2014:305.17Rp36,167Rp7,233Rp28,9335Falaq9:3014:004.50Rp31,5000.0Rp31,5006Kempul9:3014:305.00Rp35,0000.0Rp35,0007Ien Ien10:0015:005.00Rp35,0000.0Rp35,0008Yulie10:0015:005.00Rp35,0000.0Rp35,0009Arto10:0016:006.00Rp42,000Rp8,400Rp33,60010Dani10:0016:006.00Rp42,000Rp8,400Rp33,60011Arum10:0016:006.00Rp42,000Rp8,400Rp33,60012Libra10:0016:006.00Rp42,000Rp8,400Rp33,60013Aries11:0016:005.00Rp35,0000.0Rp35,00014Umie Koe11:0017:006.00Rp42,000Rp8,400Rp33,60015Debora11:4517:005.25Rp36,750Rp7,350Rp29,400JUMLAHRp625,917Rp90,883Rp535,033

MENUMENU

15-S15. Kurang Cermat Memilih Fungsi yang DigunakanNO.KODEMUSIKHARGAVOLUMEJML.HARGAKODEMUSIKKASETVCDDVD11-INAKaset IndonesiaRp22,000.007Rp154,00012321-ASIKaset Asia0.090.0ASIAsiaRp25,000Rp30,000Rp51,00032-BARVcd Barat0.080.0BARBaratRp27,500Rp33,000Rp56,10042-ASIVcd Asia0.0140.0INAIndonesiaRp22,000Rp26,400Rp44,88051-INAKaset Indonesia0.0230.0INDIndiaRp20,000Rp24,000Rp40,80061-ASIKaset Asia0.050.073-INDDvd India0.080.083-ASIDvd Asia0.090.091-BARKaset Barat0.050.0103-INADvd Indonesia0.060.0112-BARVcd Barat0.0120.0122-ASIVcd Asia0.0200.0TOTAL PENJUALAN1260.0

MENU

15-J15. Solusi - Kurang Cermat Memilih Fungsi yang DigunakanNO.KODEMUSIKHARGAVOLUMEJML.HARGAKODEMUSIKKASETVCDDVD11-INAKaset IndonesiaRp22,000.007Rp154,00012321-ASIKaset AsiaRp25,000.009Rp225,000ASIAsiaRp25,000Rp30,000Rp51,00032-BARVcd BaratRp27,500.008Rp220,000BARBaratRp27,500Rp33,000Rp56,10042-ASIVcd AsiaRp25,000.0014Rp350,000INAIndonesiaRp22,000Rp26,400Rp44,88051-INAKaset IndonesiaRp22,000.0023Rp506,000INDIndiaRp20,000Rp24,000Rp40,80061-ASIKaset AsiaRp25,000.005Rp125,00073-INDDvd IndiaRp20,000.008Rp160,00083-ASIDvd AsiaRp25,000.009Rp225,00091-BARKaset BaratRp27,500.005Rp137,500103-INADvd IndonesiaRp22,000.006Rp132,000112-BARVcd BaratRp27,500.0012Rp330,000122-ASIVcd AsiaRp25,000.0020Rp500,000TOTAL PENJUALAN126Rp3,064,500

MENUMENU

16-S16. Tidak Cermat Menggunakan Rumus AbsolutNO.KODEMUSIKHARGAVOLUMEJML. HARGADISKONHRG. DIBAYARKODEMUSIKKASETVCDDVD11-INAKaset Indonesia22,0007154,00015,400138,60012321-ASIKaset Asia25,0009225,00022,500202,500ASIAsiaRp25,000Rp30,000Rp51,00032-BARVcd Barat27,5008220,00011,000209,000BARBaratRp27,500Rp33,000Rp56,10042-ASIVcd Asia25,00014350,00017,500332,500INAIndonesiaRp22,000Rp26,400Rp44,88051-INAKaset Indonesia22,00023506,00050,600455,400INDIndiaRp20,000Rp24,000Rp40,80061-ASIKaset Asia25,0005125,00012,500112,50073-INDDvd India20,0006120,0000.0120,000BARANGDISKON83-ASIDvd Asia25,0007175,0000.0175,000KASET10%91-BARKaset Barat27,5008220,00022,000198,000VCD5%103-INADvd Indonesia22,0009198,0000.0198,000DVD0%112-BARVcd Barat27,50012330,00016,500313,500122-ASIVcd Asia25,00020500,00025,000475,000TOTAL PENJUALAN1283,123,000193,0002,930,000JUMLAH TERJUALVOLUMEHRG. DIBAYARKaset Asia14315,000Kaset Barat8198,000Kaset Indonesia23455,400Kaset India0.00.0Vcd Asia20475,000Vcd Barat12313,500Vcd Indonesia0.00.0Vcd India0.00.0Dvd Asia0.00.0Dvd Barat0.00.0Dvd Indonesia0.00.0Dvd India0.00.0TOTAL771,756,900

MENU

16-J16. Solusi - Tidak Cermat Menggunakan Rumus AbsolutNO.KODEMUSIKHARGAVOLUMEJML. HARGADISKONHRG. DIBAYARKODEMUSIKKASETVCDDVD11-INAKaset Indonesia22,0007154,00015,400138,60012321-ASIKaset Asia25,0009225,00022,500202,500ASIAsia25,00030,00051,00032-BARVcd Barat27,5008220,00011,000209,000BARBarat27,50033,00056,10042-ASIVcd Asia25,00014350,00017,500332,500INAIndonesia22,00026,40044,88051-INAKaset Indonesia22,00023506,00050,600455,400INDIndia20,00024,00040,80061-ASIKaset Asia25,0005125,00012,500112,50073-INDDvd India20,0006120,0000.0120,000BARANGDISKON83-ASIDvd Asia25,0007175,0000.0175,000KASET10%91-BARKaset Barat27,5008220,00022,000198,000VCD5%103-INADvd Indonesia22,0009198,0000.0198,000DVD0%112-BARVcd Barat27,50012330,00016,500313,500122-ASIVcd Asia25,00020500,00025,000475,000TOTAL PENJUALAN1283,123,000193,0002,930,000JUMLAH TERJUALVOLUMEHRG. DIBAYARKaset Asia14315,000Kaset Barat8198,000Kaset Indonesia30594,000Kaset India0.00.0Vcd Asia34807,500Vcd Barat20522,500Vcd Indonesia0.00.0Vcd India0.00.0Dvd Asia7175,000Dvd Barat0.00.0Dvd Indonesia9198,000Dvd India6120,000TOTAL1282,930,000

MENUMENU

17-S17. Penulisan Option Fungsi VLOOKUP Tidak TepatNO.NAMA SISWATGL. DAFTARKODEKELAS1Yasmin1-Jan-07YPMicrosoft Office2Hartanto11-Mar-07SPSenior Programmer3Arief Nugroho7-Feb-07SPSenior Programmer4Ridwan Siagian1-Feb-07YPMicrosoft Office5Ayu Anandhika21-Jan-07OF06Raditya W1-Feb-07OF07Chichi11-Jan-07YPMicrosoft Office8Yenny12-Jan-07YPMicrosoft Office9Novelina15-Feb-07OF010Elza Riana3-Jan-07OF011Agus Djamal3-Feb-07YPMicrosoft Office12Johan Jawara4-Feb-07OF013Ananto Wibowo14-Jan-07YPMicrosoft Office14Ubaidillah2-Jan-07OF0KODEKELASYPYunior ProgrammerSPSenior ProgrammerOFMicrosoft Office

MENU

17-J17. Solusi - Penulisan Option Fungsi VLOOKUP Tidak TepatNO.NAMA SISWATGL. DAFTARKODEKELAS1Yasmin1-Jan-07YPYunior Programmer2Hartanto11-Mar-07SPSenior Programmer3Arief Nugroho7-Feb-07SPSenior Programmer4Ridwan Siagian1-Feb-07YPYunior Programmer5Ayu Anandhika21-Jan-07OFMicrosoft Office6Raditya W1-Feb-07OFMicrosoft Office7Chichi11-Jan-07YPYunior Programmer8Yenny12-Jan-07YPYunior Programmer9Novelina15-Feb-07OFMicrosoft Office10Elza Riana3-Jan-07OFMicrosoft Office11Agus Djamal3-Feb-07YPYunior Programmer12Johan Jawara4-Feb-07OFMicrosoft Office13Ananto Wibowo14-Jan-07YPYunior Programmer14Ubaidillah2-Jan-07OFMicrosoft OfficeKODEKELASYPYunior ProgrammerSPSenior ProgrammerOFMicrosoft Office

MENUMENU

18-S18. Rumus Perhitungan Waktu Tidak TepatTanggal1-Aug-07NO.NAMATGL LAHIRU M U R0 - 11 BULAN12 - 23 BLN24 - 59 BLN> 591Emmy Marlia1-Jun-0721,3101,2661,2682Annie Sofia1-Nov-06(1,301)43(1)03Risdianto1-Jan-06(1,291)43(1)04Irfan Affandi1-Jul-070.00.00.00.05Etika11-Jan-07(1,261)8439416Henny1-Apr-07(1,306)44(1)07Evie1-Jun-07(1,308)44(1)08Ita12-Jan-070.00.00.00.09Firdaus1-Jun-07(1,306)45(0)110Fira1-Jan-05(1,278)43(1)011Ayu1-Mar-07(1,305)43(1)012Adhit1-Aug-070.00.00.00.013Nurul1-Feb-02(1,243)41(1)014Evelyne1-Jan-99(1,205)40(1)015Dewi Anjarsari1-Jan-05(1,278)43(1)016Ema Amalia1-Mar-075JUMLAH13121212

MENU

18-J18. Solusi - Rumus Perhitungan Waktu Tidak TepatTanggal1-Aug-07NO.NAMATGL LAHIRU M U R0 - 11 BULAN12 - 23 BLN24 - 59 BLN> 591Emmy Marlia1-Jun-072 Bulan0 Bulan0 Bulan0 Bulan2Annie Sofia1-Nov-069 Bulan0 Bulan0 Bulan0 Bulan3Risdianto1-Jan-060 Bulan19 Bulan0 Bulan0 Bulan4Irfan Affandi1-Jul-071 Bulan0 Bulan0 Bulan0 Bulan5Etika11-Jan-077 Bulan0 Bulan0 Bulan0 Bulan6Henny1-Apr-074 Bulan0 Bulan0 Bulan0 Bulan7Evie1-Jun-072 Bulan0 Bulan0 Bulan0 Bulan8Ita12-Jan-077 Bulan0 Bulan0 Bulan0 Bulan9Firdaus1-Jun-072 Bulan0 Bulan0 Bulan0 Bulan10Fira1-Jan-050 Bulan0 Bulan31 Bulan0 Bulan11Ayu1-Mar-075 Bulan0 Bulan0 Bulan0 Bulan12Adhit1-Aug-071 Bulan0 Bulan0 Bulan0 Bulan13Nurul1-Feb-020 Bulan0 Bulan0 Bulan66 Bulan14Evelyne1-Jan-990 Bulan0 Bulan0 Bulan103 Bulan15Dewi Anjarsari1-Jan-050 Bulan0 Bulan31 Bulan0 Bulan16Ema Amalia1-Mar-075 Bulan0 Bulan0 Bulan0 BulanJUMLAH11122

MENUMENU

19-S19. Penggunaan Rumus Absolut Tidak TepatSALESMANTAPE%TELEVISI%TOTAL%Ferry Indarto240000007.82%6700000012.74%910000000.00%Kemal Alamsyah340000000.00%770000000.00%00.00%Syam Chandra540000000.00%760000000.00%00.00%Tony Yuseno320000000.00%500000000.00%00.00%Adi Aseno330000000.00%560000000.00%00.00%Deddy Suroso550000000.00%450000000.00%00.00%I Putu Raka440000000.00%780000000.00%00.00%Kusmawan310000000.00%770000000.00%00.00%T o t a l3070000000.00%5260000000.00%00.00%Catatan

MENU

19-J19. Solusi - Penggunaan Rumus Absolut Tidak TepatSALESMANTAPE%TELEVISI%TOTAL%Ferry Indarto240000007.82%6700000012.74%9100000010.92%Kemal Alamsyah3400000011.07%7700000014.64%11100000013.33%Syam Chandra5400000017.59%7600000014.45%13000000015.61%Tony Yuseno3200000010.42%500000009.51%820000009.84%Adi Aseno3300000010.75%5600000010.65%8900000010.68%Deddy Suroso5500000017.92%450000008.56%10000000012.00%I Putu Raka4400000014.33%7800000014.83%12200000014.65%Kusmawan3100000010.10%7700000014.64%10800000012.97%T o t a l307000000100.00%526000000100.00%833000002100.00%

MENUMENU

20-S20. Kesalahan Penulisan Argumen pada Fungsi COUNTIFNO.NAMAKODEKELASTARIFKODEKELASTARIF1Syam ChandraEKOEkonomi60,000BISBisnis75,0002I Putu RakaBISBisnis75,000EKOEkonomi60,0003KusmawanBISBisnis75,000EKSEksekutif90,0004Sri NurulEKOEkonomi60,000SUPSuper Eksekutif125,0005Ridwan SiagianEKSEksekutif90,0006Raditya WEKOEkonomi60,0007NovelinaBISBisnis75,0008Johan JawaraEKSEksekutif90,0009HartantoEKSEksekutif90,00010Dara JelitaEKOEkonomi60,00011Sarah NoordevianaSUPSuper Eksekutif125,00012FindiBISBisnis75,00013Elza RianaEKOEkonomi60,00014ChichiBISBisnis75,00015Ayu AnandhikaEKSEksekutif90,00016Tony YusenoSUPSuper Eksekutif125,00017Adi AsenoSUPSuper Eksekutif125,00018Deddy SurosoEKOEkonomi60,00019Ferry IndartoBISBisnis75,00020Kemal AlamsyahEKSEksekutif90,000Jumlah Penumpang KelasBisnis6 OrangEkonomi6 OrangEksekutif6 OrangSuper Eksekutif6 OrangTOTAL24 Orang

MENU

20-J20. Solusi - Kesalahan Penulisan Argumen pada Fungsi COUNTIFNO.NAMAKODEKELASTARIFKODEKELASTARIF1Syam ChandraEKOEkonomi60,000BISBisnis75,0002I Putu RakaBISBisnis75,000EKOEkonomi60,0003KusmawanBISBisnis75,000EKSEksekutif90,0004Sri NurulEKOEkonomi60,000SUPSuper Eksekutif125,0005Ridwan SiagianEKSEksekutif90,0006Raditya WEKOEkonomi60,0007NovelinaBISBisnis75,0008Johan JawaraEKSEksekutif90,0009HartantoEKSEksekutif90,00010Dara JelitaEKOEkonomi60,00011Sarah NoordevianaSUPSuper Eksekutif125,00012FindiBISBisnis75,00013Elza RianaEKOEkonomi60,00014ChichiBISBisnis75,00015Ayu AnandhikaEKSEksekutif90,00016Tony YusenoSUPSuper Eksekutif125,00017Adi AsenoSUPSuper Eksekutif125,00018Deddy SurosoEKOEkonomi60,00019Ferry IndartoBISBisnis75,00020Kemal AlamsyahEKSEksekutif90,000Jumlah Penumpang KelasBisnis6 OrangEkonomi6 OrangEksekutif5 OrangSuper Eksekutif3 OrangTOTAL20 Orang

MENUMENU

21-S21. Kesalahan Penulisan Fungsi PMTBunga Per Tahun35.00%Per Bulan2.92%NO.NAMANO. NSBHTENORKODEMEREK SPD MOTORHARGA TUNAIKREDIT (ANGSURAN/BLN)1DAMAR GRAHASM100112 bulanHSFHONDA SUPRA FITRp11,990,000Rp(1,198,556)2TAZKIA MUTIASM100223 bulanSSHSUZUKI SHOGUNRp11,990,000Rp(521,304)3EZRASM100329 bulanYJZYAMAHA JUPITER ZRp12,535,0000.04ATILLASM100435 bulanYNOYAMAHA NOUVORp11,717,5000.05SABRINASM100535 bulanHSFHONDA SUPRA FITRp11,990,0000.06EDDY SENASM100622 bulanHKXHONDA KARISMA XDRp13,897,5000.07MAYASM100729 bulanSSTSUZUKI SATRIARp12,535,0000.08ANISSM100835 bulanSSMSUZUKI SMASHRp11,445,0000.09RARASM100912 bulanYMIYAMAHA MIORp10,355,0000.010ATHORISM101035 bulanYNOYAMAHA NOUVORp11,717,5000.0KODEMEREK SPD MOTORHARGAHKXKARISMA XDRp13,897,500HSFSUPRA FITRp11,990,000SSHSHOGUNRp11,990,000SSMSMASHRp11,445,000SSTSATRIARp12,535,000YJZJUPITER ZRp12,535,000YMIMIORp10,355,000YNONOUVORp11,717,500

MENU

21-J21. Solusi - Kesalahan Penulisan Fungsi PMTBunga Per Tahun35.00%Per Bulan2.92%NO.NAMANO. NSBHTENORKODEMEREK SPD MOTORHARGA TUNAIKREDIT (ANGSURAN/BLN)1DAMAR GRAHASM100112 bulanHSFHONDA SUPRA FITRp11,990,000Rp1,198,5562TAZKIA MUTIASM100223 bulanSSHSUZUKI SHOGUNRp11,990,000Rp722,8553EZRASM100329 bulanYJZYAMAHA JUPITER ZRp12,535,000Rp646,4294ATILLASM100435 bulanYNOYAMAHA NOUVORp11,717,500Rp538,7105SABRINASM100535 bulanHSFHONDA SUPRA FITRp11,990,000Rp551,2386EDDY SENASM100622 bulanHKXHONDA KARISMA XDRp13,897,500Rp864,7687MAYASM100729 bulanSSTSUZUKI SATRIARp12,535,000Rp646,4298ANISSM100835 bulanSSMSUZUKI SMASHRp11,445,000Rp526,1829RARASM100912 bulanYMIYAMAHA MIORp10,355,000Rp1,035,11710ATHORISM101035 bulanYNOYAMAHA NOUVORp11,717,500Rp538,710KODEMEREK SPD MOTORHARGAHKXKARISMA XDRp13,897,500HSFSUPRA FITRp11,990,000SSHSHOGUNRp11,990,000SSMSMASHRp11,445,000SSTSATRIARp12,535,000YJZJUPITER ZRp12,535,000YMIMIORp10,355,000YNONOUVORp11,717,500

MENU

22-S22. Kesalahan Pemilihan Fungsi Pembacaan TabelNO.NAMAGOLTGL.MULAI KERJALAMA KERJAGAJI POKOKPESANGONGOLGAJI POKOKPESANGON DENGAN MASA KERJA1Adhit119-Jan-8421 TahunRp7,500,0000.0< 5 Tahun5 - 10 Tahun>10 Tahun2Nurul319-Jan-9015 TahunRp3,000,0000.01Rp7,500,000Rp7,500,000Rp22,500,000Rp112,500,0003Evelyne219-Mar-8322 TahunRp5,000,0000.02Rp5,000,000Rp5,000,000Rp15,000,000Rp75,000,0004Dewi Anjarsari319-Jun-8223 TahunRp3,000,0000.03Rp3,000,000Rp3,000,000Rp9,000,000Rp45,000,0005Henny219-Nov-023 TahunRp5,000,0000.04Rp1,500,000Rp1,500,000Rp4,500,000Rp22,500,0006Annie Sofia319-Sep-014 TahunRp3,000,0000.07Risdianto419-Apr-8718 TahunRp1,500,0000.08Irfan Affandi419-Feb-8520 TahunRp1,500,0000.09Etika419-Jul-7728 TahunRp1,500,0000.010Ema Amalia419-Aug-7926 TahunRp1,500,0000.011Evie319-May-032 TahunRp3,000,0000.012Ita419-Oct-8124 TahunRp1,500,0000.013Firdaus319-Jan-8025 TahunRp3,000,0000.014Fira419-Feb-050 TahunRp1,500,0000.015Ayu219-Jan-8025 TahunRp5,000,0000.0T O T A LRp46,500,0000

MENU

22-J22. Solusi - Kesalahan Pemilihan Fungsi Pembacaan TabelNO.NAMAGOLTGL.MULAI KERJALAMA KERJAGAJI POKOKPESANGONGOLGAJI POKOKPESANGON DENGAN MASA KERJA1Adhit119-Jan-8421 TahunRp7,500,000Rp112,500,000< 5 Tahun5 - 10 Tahun>10 Tahun2Nurul319-Jan-9015 TahunRp3,000,000Rp45,000,0001Rp7,500,000Rp7,500,000Rp22,500,000Rp112,500,0003Evelyne219-Mar-8322 TahunRp5,000,000Rp75,000,0002Rp5,000,000Rp5,000,000Rp15,000,000Rp75,000,0004Dewi Anjarsari319-Jun-8223 TahunRp3,000,000Rp45,000,0003Rp3,000,000Rp3,000,000Rp9,000,000Rp45,000,0005Henny219-Nov-023 TahunRp5,000,000Rp5,000,0004Rp1,500,000Rp1,500,000Rp4,500,000Rp22,500,0006Annie Sofia319-Sep-014 TahunRp3,000,000Rp3,000,0007Risdianto419-Apr-8718 TahunRp1,500,000Rp22,500,0008Irfan Affandi419-Feb-8520 TahunRp1,500,000Rp22,500,0009Etika419-Jul-7728 TahunRp1,500,000Rp22,500,00010Ema Amalia419-Aug-7926 TahunRp1,500,000Rp22,500,00011Evie319-May-032 TahunRp3,000,000Rp3,000,00012Ita419-Oct-8124 TahunRp1,500,000Rp22,500,00013Firdaus319-Jan-8025 TahunRp3,000,000Rp45,000,00014Fira419-Feb-050 TahunRp1,500,000Rp1,500,00015Ayu219-Jan-8025 TahunRp5,000,000Rp75,000,000T O T A LRp46,500,000Rp522,500,000

MENUMENU

23-S23. Tidak Cermat Menulis Status RumusNO.NAMANIPNILAIMIDFINALPAPERTOTALMidFinalPaper30%50%20%1Juwono.100423250609015.0035.0018.0068.002Tobing .10042339978801485.003150.001440.006075.003Prabowo .1004234897570132165.00141750.00100800.00374715.004Kadarusman.10042357070906608250.0011056500.009072000.0026736750.005Gandha1004236908989462577500.00829237500.00807408000.002099223000.006Cahyasasi.100422245507820815987500.0058046625000.0062977824000.00141840436500.007Kusmono.10042237875501623647025000.003192564375000.003148891200000.007965102600000.008Kahar Masjhur.1004224759999121773526875000.00223479506250000.00311740228800000.00656993261925000.009Jamaludin Niode10042307090890.0011173975312500000.0027744880363200000.0038918855675700000.0010Burhanudin .10042315560500.001083875605312500000.001387244018160000000.002471119623472500000.0011D.S10042267085700.0096464928872812500000.0097107081271200000000.00193572010144012500000.0012Gozali.10042275070450.000.004369818657204000500000.004369818657204000500000.0013Hessel Nathanael.10042289750780.000.00340845855261912060000000.00340845855261912060000000.0014Tjanderasa10042298997750.000.0025563439144643403000000000.0025563439144643403000000000.00

MENU

23-J23. Solusi - Tidak Cermat Menulis Status RumusNO.NAMANIPNILAIMIDFINALPAPERTOTALMidFinalPaper30%50%20%1Juwono.100423250609015.0035.0018.0068.002Tobing .100423399788024.0045.0012.0081.003Prabowo .100423489757021.0022.5015.6059.104Kadarusman.100423570709027.0039.0015.0081.005Gandha100423690898926.7037.5014.0078.206Cahyasasi.100422245507823.4035.0017.8076.207Kusmono.100422378755022.5025.0010.0057.508Kahar Masjhur.100422475999929.7048.5019.8098.009Jamaludin Niode100423070908927.0044.5017.8089.3010Burhanudin .100423155605018.0027.5010.0055.5011D.S100422670857025.5035.0014.0074.5012Gozali.100422750704521.0025.009.0055.0013Hessel Nathanael.100422897507815.0049.5015.6080.1014Tjanderasa100422989977529.1044.5015.0088.60

MENUMENU

24-S24. Tidak Tepat Memilih Status RumusBunga50%TYPEUANG MUKA11 Bulan17 Bulan23 Bulan29 Bulan35 BulanYAMAHA MIO1,000,0001,180,569602,941445,652353,448292,857Rp11,250,0001,500,00028,437,509573,529423,913336,207278,5712,000,000225,744,047,619544,118402,174318,966264,2862,500,000203,125,000,000514,706380,435301,724250,0003,000,000181,696,428,571485,294358,696284,483235,7143,500,000161,458,333,333455,882336,957267,241221,4294,000,000142,410,714,286426,471315,217250,000207,1434,500,000124,553,571,429397,059293,478232,759192,8575,000,000107,886,904,762367,647271,739215,517178,5716,000,00084,375,000,000308,824228,261181,034150,000

MENU

24-J24. Solusi - Tidak Tepat Memilih Status RumusBunga50%TYPEUANG MUKA11 Bulan17 Bulan23 Bulan29 Bulan35 BulanYAMAHA MIO1,000,0001,180,569853,461701,350615,484561,659Rp11,250,0001,500,0001,122,980811,829667,138585,460534,2612,000,0001,065,391770,197632,926555,437506,8632,500,0001,007,803728,565598,714525,413479,4653,000,000950,214686,932564,501495,390452,0673,500,000892,625645,300530,289465,366424,6694,000,000835,036603,668496,077435,342397,2714,500,000777,448562,036461,865405,319369,8735,000,000719,859520,403427,653375,295342,4756,000,000604,682437,139359,228315,248287,679

MENUMENU

25-S25. Kesalahan Penulisan Rumus WaktuNama Karyawan:Sarah NoordevianaN I P:00001127Departemen:HRDUpah Lembur /jam Hari Kerja:Rp12,000Upah Lembur /jam Hari Libur:Rp17,500TanggalJam MasukJam KeluarJam BekerjaJam LemburHariUpah Lembur1-Aug-078:0017:000 jam0 jamRabu0.02-Aug-078:0019:000 jam0 jamKamis0.03-Aug-078:0020:001 jam0 jamJumat0.04-Aug-078:0017:000 jam0 jamSabtu0.05-Aug-078:0018:000 jam0 jamMinggu0.06-Aug-078:0017:000 jam0 jamSenin0.07-Aug-078:0017:000 jam0 jamSelasa0.08-Aug-078:0021:001 jam0 jamRabu0.026-Aug-078:0017:000 jam0 jamMinggu0.027-Aug-078:0021:001 jam0 jamSenin0.028-Aug-078:0022:001 jam0 jamSelasa0.029-Aug-078:0017:000 jam0 jamRabu0.030-Aug-078:0017:000 jam0 jamKamis0.031-Aug-078:0021:001 jam0 jamJumat0.0T o t a l U p a h L e m b u r0.0

MENU

25-J25. Solusi - Kesalahan Penulisa Rumus WaktuNama Karyawan:Sarah NoordevianaN I P:00001127Departemen:HRDUpah Lembur /jam Hari Kerja:Rp12,000Upah Lembur /jam Hari Libur:Rp17,500TanggalJam MasukJam KeluarJam BekerjaJam LemburHariUpah Lembur1-Aug-078:0017:009 jam2 jamRabu24,0002-Aug-078:0019:0011 jam4 jamKamis48,0003-Aug-078:0020:0012 jam5 jamJumat60,0004-Aug-078:0017:009 jam2 jamSabtu35,0005-Aug-078:0018:0010 jam3 jamMinggu52,5006-Aug-078:0017:009 jam2 jamSenin24,0007-Aug-078:0017:009 jam2 jamSelasa24,0008-Aug-078:0021:0013 jam6 jamRabu72,00026-Aug-078:0017:009 jam2 jamMinggu35,00027-Aug-078:0021:0013 jam6 jamSenin72,00028-Aug-078:0022:0014 jam7 jamSelasa84,00029-Aug-078:0017:009 jam2 jamRabu24,00030-Aug-078:0017:009 jam2 jamKamis24,00031-Aug-078:0021:0013 jam6 jamJumat72,000T o t a l U p a h L e m b u r650,500

MENUMENU

26-S26. Kesalahan Input DataNama Mahasiswa: Sarah Noordeviana Meriam KusumawardhaniNomor Induk: 20041002Fakultas: EkonomiNo.Kode MatakuliahNama MatakuliahSKSBiaya/SKSJumlah Biaya1EKA1Akuntansi 13Rp. 100.000,-0.02STA1Statistik 13Rp. 100.000,-0.03BIN1Bahasa Indonesia 12Rp. 100.000,-0.04PAMPengantar Manajemen3Rp. 100.000,-0.05PAGPendidikan Agama2Rp. 100.000,-0.06MAT1Matematika 13Rp. 100.000,-0.07BIG1Bahasa Inggris 12Rp. 100.000,-0.0J u m l a h180.0

MENU

26-J26. Solusi - Kesalahan Input DataNama Mahasiswa: Sarah Noordeviana Meriam KusumawardhaniNomor Induk: 20041002Fakultas: EkonomiNo.Kode MatakuliahNama MatakuliahSKSBiaya/SKSJumlah Biaya1EKA1Akuntansi 13Rp100,000300,0002STA1Statistik 13Rp100,000300,0003BIN1Bahasa Indonesia 12Rp100,000200,0004PAMPengantar Manajemen3Rp100,000300,0005PAGPendidikan Agama2Rp100,000200,0006MAT1Matematika 13Rp100,000300,0007BIG1Bahasa Inggris 12Rp100,000200,000J u m l a h181,800,000

MENUMENU

27-S27. Kesalahan Input DataJUMLAHSOLARPERTAMAXPERTAMAX+PREMIUMLITERRp4,000Rp5,000Rp5,500Rp4,5001Rp4,000Rp20,000,000Rp110,000,000,000Rp495,000,000,000,0002Rp8,000Rp160,000,000,000Rp17,600,000,000,000,000,000,000Rp8,712,000,000,000,000,000,000,000,000,000,000,0003Rp24,000Rp3,840,000,000,000,000Rp67,584,000,000,000,000,000,000,000,000,000,000,000Rp588,791,808,000,000,100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0004Rp96,000Rp368,640,000,000,000,000,000Rp24,914,165,760,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000Rp14,669,256,702,642,095,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0005Rp480,000Rp176,947,200,000,000,000,000,000,000Rp4,408,491,871,567,872,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000Rp64,669,298,935,540,200,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0006Rp2,880,000Rp509,607,936,000,000,000,000,000,000,000,000Rp2,246,602,443,542,480,400,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.07Rp20,160,000Rp10,273,695,989,760,000,000,000,000,000,000,000,000,000Rp23,080,910,514,807,400,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.08Rp161,280,000Rp1,656,941,689,228,492,800,000,000,000,000,000,000,000,000,000,000Rp38,243,722,857,336,654,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.09Rp1,451,520,000Rp2,405,084,000,748,941,700,000,000,000,000,000,000,000,000,000,000,000,000,000Rp91,979,365,973,256,990,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.010Rp14,515,200,000Rp34,910,275,287,671,040,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.00.011Rp159,667,200,000Rp5,574,025,906,411,630,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.00.012Rp1,916,006,400,000Rp10,679,869,310,450,484,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0000.00.0

MENU

27-J27. Solusi - Kesalahan Input DataJUMLAHSOLARPERTAMAXPERTAMAX+PREMIUMLITERRp4,000Rp5,000Rp5,500Rp4,5001Rp4,000Rp5,000Rp5,500Rp4,5002Rp8,000Rp10,000Rp11,000Rp9,0003Rp12,000Rp15,000Rp16,500Rp13,5004Rp16,000Rp20,000Rp22,000Rp18,0005Rp20,000Rp25,000Rp27,500Rp22,5006Rp24,000Rp30,000Rp33,000Rp27,0007Rp28,000Rp35,000Rp38,500Rp31,5008Rp32,000Rp40,000Rp44,000Rp36,0009Rp36,000Rp45,000Rp49,500Rp40,50010Rp40,000Rp50,000Rp55,000Rp45,00011Rp44,000Rp55,000Rp60,500Rp49,50012Rp48,000Rp60,000Rp66,000Rp54,000

MENUMENU

28-S28. Kesalahan Input Tipe DataJumlah LembarCANON RP. 100SHARP RP. 150XEROX RP. 20010.00.00.020.00.00.030.00.00.040.00.00.050.00.00.060.00.00.070.00.00.080.00.00.090.00.00.0100.00.00.0110.00.00.0120.00.00.0

MENU

28-J28. Solusi - Kesalahan Input Tipe DataJumlah LembarCanon = Rp 100Sharp = Rp 150Xerox = Rp 200110015020022003004003300450600440060080055007501,00066009001,20077001,0501,40088001,2001,60099001,3501,800101,0001,5002,000111,1001,6502,200121,2001,8002,400

MENUMENU

29-S29. Kesalahan Penulisan RumusXYXY542076209820111020131220151420171620191820212020232220252420272620292820

MENU

29-J29. Solusi - Kesalahan Penulisan RumusXYXY5420764298721110110131215615142101716272191834221204202322506252460027267022928812

MENUMENU

30-S30. Kesalahan Penulisan RumusBARANGVOLHARGAJML.HARGAA131,6294,8870.0A252,71513,5750.0A342,1728,6880.0A463,25819,5480.0A573,80126,6070.0A684,34434,7520.0A752,71513,5750.0A863,25819,5480.0A942,1728,688

MENU

30-J30. Solusi - Kesalahan Penulisan RumusBARANGVOLHARGAJML.HARGAA131,6294,8870.0A252,71513,5750.0A342,1728,6880.0A463,25819,5480.0A573,80126,6070.0A684,34434,7520.0A752,71513,5750.0A863,25819,5480.0A942,1728,688

MENUMENU

31-S31. Kesalahan Pemulisan RumusKELOMPOKJML UNITHARGA SATUANNILAI RpKELOMPOK 1BARANG A$500$42,000$21,000,000BARANG B$750$30,000$22,500,000BARANG C dst-nya$1,000$18,000$18,000,000Sub Jumlah Kelompok 1$2,250$61,500,000KELOMPOK 2BARANG A$1,500$24,000$36,000,000BARANG B$1,750$21,000$36,750,000BARANG C dst-nya$2,000$18,000$36,000,000Sub Jumlah Kelompok 2$5,250$108,750,000KELOMPOK 3BARANG A$2,500$96,000$240,000,000BARANG B$2,750$90,000$247,500,000BARANG C dst-nya$3,000$72,000$216,000,000Sub Jumlah Kelompok 3$8,250$703,500,000TOTAL JUMLAH$582,500,000

MENU

31-J31. Solusi - Kesalahan Menulis RumusKELOMPOKJML UNITHARGA SATUANNILAI RpKELOMPOK 1BARANG A$500$42,000$21,000,000BARANG B$750$30,000$22,500,000BARANG C dst-nya$1,000$18,000$18,000,000Sub Jumlah Kelompok 1$2,250$61,500,000KELOMPOK 2BARANG A$1,500$24,000$36,000,000BARANG B$1,750$21,000$36,750,000BARANG C dst-nya$2,000$18,000$36,000,000Sub Jumlah Kelompok 2$5,250$108,750,000KELOMPOK 3BARANG A$2,500$96,000$240,000,000BARANG B$2,750$90,000$247,500,000BARANG C dst-nya$3,000$72,000$216,000,000Sub Jumlah Kelompok 3$8,250$703,500,000TOTAL JUMLAH$873,750,000

MENUMENU

32-S32. Kesalahan Menulis Rumus dengan ArrayNAMAKODEHRGVOLJML.HRGANI110,0005{=D6:D12*E6:E12}INA35,0007{=D6:D12*E6:E12}IRA27,5006{=D6:D12*E6:E12}ADI35,0004{=D6:D12*E6:E12}ITA27,5008{=D6:D12*E6:E12}IKA35,0009{=D6:D12*E6:E12}IFA110,0008{=D6:D12*E6:E12}

MENU

32-J32. Solusi - Kesalahan Menulis Rumus dengan ArrayNAMAKODEHRGVOLJML.HRGANI110,000550,000INA35,000735,000IRA27,500645,000ADI35,000420,000ITA27,500860,000IKA35,000945,000IFA110,000880,000

MENUMENU

33-S33. Kesalahan Penulisan Nama FungsiNAMAKODEHRGVOLJML.HRGANI110,000550,000INA35,000735,000IRA27,500645,000ADI35,000420,000ITA27,500860,000IKA35,000945,000IFA110,000880,000J U M L A H0

MENU

33-J33. Kesalahan Penulisan Nama FungsiNAMAKODEHRGVOLJML.HRGANI110,000550,000INA35,000735,000IRA27,500645,000ADI35,000420,000ITA27,500860,000IKA35,000945,000IFA110,000880,000J U M L A H335,000

MENUMENU

34-S34. Penulisan Parameter Tidak LengkapNAMAGOLGAJITUNJANGANGAJI BERSIHANTO110,000,000010,000,000IRFAN110,000,000010,000,000ARIF27,500,00007,500,000IWAN27,500,00007,500,000AGUS35,000,00005,000,000BAMBANG35,000,00005,000,000YANTO35,000,00005,000,000J U M L A H50,000,001

MENU

34-J34. Solusi - Penulisan Parameter Tidak LengkapNAMAGOLGAJITUNJANGANGAJI BERSIHANTO110,000,0001,000,00011,000,000IRFAN110,000,0001,000,00011,000,000ARIF27,500,0001,125,0008,625,000IWAN27,500,0001,125,0008,625,000AGUS35,000,0001,000,0006,000,000BAMBANG35,000,0001,000,0006,000,000YANTO35,000,0001,000,0006,000,000J U M L A H57,250,000

MENUMENU

35-S35. Kesalahan Penulisan Rumus Semi AbsolutNAMAPENDIDIKANGAJITUNJANGANGAJI KOTORPPH 15%GAJI BERSIHPENDIDIKANTUNJANGANANISD1,070,000321,0001,391,000208,6501,182,350SD30%INASMA3,270,000981,0004,251,000886,971,150,000(886,966,899,000)SMP20%IRASMA3,210,000963,0004,173,0003,701,330,608,950,000,000(3,701,330,608,945,830,000)SMA10%ADISMP2,180,000436,0002,616,0009,682,680,873,013,200,000,000,000(9,682,680,873,013,200,000,000,000)UNIVERSITAS5%ITASD1,170,000351,0001,521,00014,727,357,607,853,076,000,000,000,000,000(14,727,357,607,853,076,000,000,000,000,000)IKASMP2,180,000436,0002,616,00038,526,767,502,143,647,000,000,000,000,000,000,000(38,526,767,502,143,647,000,000,000,000,000,000,000)IFASD1,270,000381,0001,651,00063,607,693,146,039,160,000,000,000,000,000,000,000,000,000(63,607,693,146,039,160,000,000,000,000,000,000,000,000,000)ANTOSD1,090,000327,0001,417,00090,132,101,187,937,490,000,000,000,000,000,000,000,000,000,000,000(90,132,101,187,937,490,000,000,000,000,000,000,000,000,000,000,000)IRFANSMA3,450,0001,035,0004,485,000404,242,473,827,899,600,000,000,000,000,000,000,000,000,000,000,000,000,000(404,242,473,827,899,600,000,000,000,000,000,000,000,000,000,000,000,000,000)ARIFSMA3,270,000981,0004,251,0001,718,434,756,242,401,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(1,718,434,756,242,401,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)IWANUNIVERSITAS5,450,000272,5005,722,5009,833,742,892,597,141,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(9,833,742,892,597,141,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)AGUSSMA3,210,000963,0004,173,00041,036,209,090,807,870,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(41,036,209,090,807,870,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)BAMBANGSD1,150,000345,0001,495,00061,349,132,590,757,770,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(61,349,132,590,757,770,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)YANTOUNIVERSITAS5,750,000287,5006,037,500370,395,388,016,700,040,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(370,395,388,016,700,040,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)ENDANGSMP2,340,000468,0002,808,0001,040,070,249,550,893,700,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(1,040,070,249,550,893,700,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)CHICHISD1,090,000327,0001,417,0001,473,779,543,613,616,400,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(1,473,779,543,613,616,400,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)ANITASMP2,540,000508,0003,048,0004,492,080,048,934,302,600,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(4,492,080,048,934,302,600,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)RUDYUNIVERSITAS5,450,000272,5005,722,50025,705,928,080,026,545,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000(25,705,928,080,026,545,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000)

MENU

35-J35. Solusi - Kesalahan Penulisan Rumus Semi AbsolutNAMAPENDIDIKANGAJITUNJANGANGAJI KOTORPPH 15%GAJI BERSIHPENDIDIKANTUNJANGANANISD1,070,000321,0001,391,000208,6501,182,350SD30%INASMA3,270,000981,0004,251,000637,6503,613,350SMP20%IRASMA3,210,000963,0004,173,000625,9503,547,050SMA10%ADISMP2,180,000436,0002,616,000392,4002,223,600UNIVERSITAS5%ITASD1,170,000351,0001,521,000228,1501,292,850IKASMP2,180,000436,0002,616,000392,4002,223,600IFASD1,270,000381,0001,651,000247,6501,403,350ANTOSD1,090,000327,0001,417,000212,5501,204,450IRFANSMA3,450,0001,035,0004,485,000672,7503,812,250ARIFSMA3,270,000981,0004,251,000637,6503,613,350IWANUNIVERSITAS5,450,000272,5005,722,500858,3754,864,125AGUSSMA3,210,000963,0004,173,000625,9503,547,050BAMBANGSD1,150,000345,0001,495,000224,2501,270,750YANTOUNIVERSITAS5,750,000287,5006,037,500905,6255,131,875ENDANGSMP2,340,000468,0002,808,000421,2002,386,800CHICHISD1,090,000327,0001,417,000212,5501,204,450ANITASMP2,540,000508,0003,048,000457,2002,590,800RUDYUNIVERSITAS5,450,000272,5005,722,500858,3754,864,125

MENUMENU

36-S36. Kesalahan Pemilihan RumusNAMAPENDIDIKANGAJIIFASD1,270,000ITASD1,170,000BAMBANGSD1,150,000ANTOSD1,090,000ENDANGSMP2,340,000ADISMP2,180,000IKASMP2,180,000IRFANSMU3,450,000ARIFSMU3,270,000INASMU3,270,000IWANUNIVERSITAS5,450,000RUDYUNIVERSITAS5,450,000T O T A L32,270,000GAJI KARYAWAN UNTUK PENDIDIKAN:SD4,680,000SMP5,750,000SMU6,760,000UNIVERSITAS7,790,000TOTAL24,980,000

MENU

36-J36. Solusi - Kesalahan Pemilihan RumusNAMAPENDIDIKANGAJIIFASD1,270,000ITASD1,170,000BAMBANGSD1,150,000ANTOSD1,090,000ENDANGSMP2,340,000ADISMP2,180,000IKASMP2,180,000IRFANSMU3,450,000ARIFSMU3,270,000INASMU3,270,000IWANUNIVERSITAS5,450,000RUDYUNIVERSITAS5,450,000T O T A L32,270,000GAJI KARYAWAN UNTUK PENDIDIKAN:SD4,680,000SMP6,700,000SMU9,990,000UNIVERSITAS10,900,000TOTAL32,270,000

MENUMENU

37-S37. Kesalahan Tidak Memanfaatkan Bantuan Fungsi LainKODE AREAHASILNO.KODE AREAWILAYAHNO.NOMOR TELEPONWILAYAH106111061272453464312062012062027243474013063113063127243483714064414064427243493415065215065227243503116071226071227243512817072727072727243522528073328073327243532229074629074627243541941007732100773272435516411021311021272453561301202513120251272435710013026731302672724358070140254314025427243590401502241502227245360010160612724360981170251272436195018025127243629201902512724363890200251724536486021025127243658302207732724366804230733272436777224073372453687422502672724358070260254272435904027022272453600102802127243609802906442724349341300652272435031131071227243512813202512724361950330251272436583034073372453687423506442724349341

MENU

37-J37. Solusi - Kesalahan Tidak Memanfaatkan Bantuan Fungsi LainKODE AREAHASILNO.KODE AREAWILAYAHNO.NOMOR TELEPONWILAYAH106111061272453464312062012062027243474013063113063127243483714064414064427243493415065215065227243503116071226071227243512827072727072727243522528073328073327243532229074629074627243541921007732100773272435516211021311021272453561331202513120251272435710313026731302672724358073140254314025427243590431502241502227245360014160612724360981170251272436195318025127243629231902512724363893200251724536486321025127243658332207732724366802230733272436777224073372453687422502672724358073260254272435904327022272453600142802127243609832906442724349341300652272435031131071227243512823202512724361953330251272436583334073372453687423506442724349341

MENU

38-S38. Kesalahan Penulisan Rumus yang Tidak Dilengkapi dengan KriteriaNAMAPENDIDIKANGAJIKEMAL ALAMSYAHSD1,270,000DEFRIANSYAHSD1,170,000MEIFIANAZSD1,150,000HANAFISD1,090,000SASTISMP2,340,000RULLIETASMP2,180,000ARYASMP2,180,000DICKYSMU3,450,000CATURSMU3,270,000SRI RAHAYUSMU3,270,000AGUSTINUNIVERSITAS5,450,000ROBBYUNIVERSITAS5,450,000T O T A L32,270,000GAJI KARYAWAN UNTUK PENDIDIKAN:JUMLAHSD0.0SMPSMUUNIVERSITASTOTAL4,680,000

MENU

38-J38. Solusi - Kesalahan Penulisan Rumus yang Tidak Dilengkapi dengan KriteriaNAMAPENDIDIKANGAJIKEMAL ALAMSYAHSD1,270,000DEFRIANSYAHSD1,170,000MEIFIANAZSD1,150,000HANAFISD1,090,000SASTISMP2,340,000RULLIETASMP2,180,000ARYASMP2,180,000DICKYSMU3,450,000CATURSMU3,270,000SRI RAHAYUSMU3,270,000AGUSTINUNIVERSITAS5,450,000ROBBYUNIVERSITAS5,450,000T O T A L32,270,000GAJI KARYAWAN UNTUK PENDIDIKAN:JUMLAHSD4,680,000SMPSMUUNIVERSITASTOTAL4,680,000

MENU

39-S39. Kesalahan Tidak Memanfaatkan Fasilitas LainNO.NAMANILAITOTALKIMIAFISIKABIOLOGIMATEMATIKA1ITA843847962652IKA755675752813IFA567528802394ANTO476675752635IRFAN475675482266RUDY287566642337ANI386656321918INA195647641869IRA3847384817010ADI28475611224311YANTO6628754821712ENDANG2856196416713CHICHI3838383815014ANITA5638285617815ARIF7556667527216IWAN6647389624617AGUS5628387519718BAMBANG47385675216

MENU

39-J39. Solusi - Kesalahan Tidak Memanfaatkan Fasilitas LainNO.NAMANILAITOTALKIMIAFISIKABIOLOGIMATEMATIKA1ITA843847962652IKA755675752813IFA567528802394ANTO476675752635IRFAN475675482266RUDY287566642337ANI386656321918INA195647641869IRA3847384817010ADI28475611224311YANTO6628754821712ENDANG2856196416713CHICHI3838383815014ANITA5638285617815ARIF7556667527216IWAN6647389624617AGUS5628387519718BAMBANG47385675216

MENUMENU

40-S40. Penulisan Rumus Tidak Sesuai dengan SintaksNAMANILAI 1NILAI 2NILAI 3RATA-RATAKETERANGANDEDDY GUSTRIZA65778977.00TIDAK LULUSDARMAWANTI66898981.33TIDAK LULUSCHRISNA PRIHAYANTO87899088.67TIDAK LULUSCASIYAN779083.50TIDAK LULUSCANDRA SAPUTRA896577.00TIDAK LULUSBUNGA RENATA KASTALISTY896577.00TIDAK LULUSBONG TJIE LAN907884.00TIDAK LULUSBIMO WINDYARTHO SUHARYONO786672.00TIDAK LULUSBENNY DJUMHANA65778977.00TIDAK LULUSBANDY SUBANDY898989.00TIDAK LULUSBAMBANG YULIANTO78899085.67TIDAK LULUSBAMBANG TRIGUNA669078.00TIDAK LULUSBAMBANG RAHAYU BAWIYONO756570.00TIDAK LULUSBAGUS WICAKSONO546559.50LULUSAZHARI337855.50LULUSASWIN, SH45786663.00TIDAK LULUSASNGARI67897577.00TIDAK LULUSANDREAS ARDIAN PRAMADITYA89905477.67TIDAK LULUS

MENU

40-J40. Solusi - Penulisan Rumus Tidak Sesuai dengan SintaksNAMANILAI 1NILAI 2NILAI 3RATA-RATAKETERANGANDEDDY GUSTRIZA65778977.00LULUSDARMAWANTI66898981.33LULUSCHRISNA PRIHAYANTO87899088.67LULUSCASIYAN779083.50LULUSCANDRA SAPUTRA896577.00LULUSBUNGA RENATA KASTALISTY896577.00LULUSBONG TJIE LAN907884.00LULUSBIMO WINDYARTHO SUHARYONO786672.00LULUSBENNY DJUMHANA65778977.00LULUSBANDY SUBANDY898989.00LULUSBAMBANG YULIANTO78899085.67LULUSBAMBANG TRIGUNA669078.00LULUSBAMBANG RAHAYU BAWIYONO756570.00LULUSBAGUS WICAKSONO546559.50TIDAK LULUSAZHARI337855.50TIDAK LULUSASWIN, SH45786663.00LULUSASNGARI67897577.00LULUSANDREAS ARDIAN PRAMADITYA89905477.67LULUS

MENUMENU

41-S41. Kesalahan Penulisan Posisi ArgumenNAMANILAI 1NILAI 2NILAI 3KETERANGANDEDDY GUSTRIZA405554LULUSDARMAWANTI668989TIDAK LULUSCHRISNA PRIHAYANTO878990TIDAK LULUSCASIYAN3050LULUSCANDRA SAPUTRA8965TIDAK LULUSBUNGA RENATA KASTALISTY8965TIDAK LULUSBONG TJIE LAN4545LULUSBIMO WINDYARTHO SUHARYONO7866TIDAK LULUSBENNY DJUMHANA657789TIDAK LULUSBANDY SUBANDY8989TIDAK LULUSBAMBANG YULIANTO788990TIDAK LULUSBAMBANG TRIGUNA6690TIDAK LULUSBAMBANG RAHAYU BAWIYONO7565TIDAK LULUSBAGUS WICAKSONO544044LULUSAZHARI3378TIDAK LULUSASWIN, SH457866TIDAK LULUSASNGARI678975TIDAK LULUSANDREAS ARDIAN PRAMADITYA899054TIDAK LULUS

MENU

41-J41. Solusi - Kesalahan Penulisan Posisi ArgumenNAMANILAI 1NILAI 2NILAI 3KETERANGANDEDDY GUSTRIZA405554TIDAK LULUSDARMAWANTI668989LULUSCHRISNA PRIHAYANTO878990LULUSCASIYAN3050TIDAK LULUSCANDRA SAPUTRA8965LULUSBUNGA RENATA KASTALISTY8965LULUSBONG TJIE LAN4545TIDAK LULUSBIMO WINDYARTHO SUHARYONO7866LULUSBENNY DJUMHANA657789LULUSBANDY SUBANDY8989LULUSBAMBANG YULIANTO788990LULUSBAMBANG TRIGUNA6690LULUSBAMBANG RAHAYU BAWIYONO7565LULUSBAGUS WICAKSONO544044TIDAK LULUSAZHARI3378LULUSASWIN, SH457866LULUSASNGARI678975LULUSANDREAS ARDIAN PRAMADITYA899054LULUS

MENUMENU

42-S42. Penulisan Rumus Tidak Sesuai dengan SintaksNAMANILAI 1NILAI 2NILAI 3KETERANGANDEDDY GUSTRIZA405554LULUSDARMAWANTI668989TIDAK LULUSCHRISNA PRIHAYANTO878990TIDAK LULUSCASIYAN3050LULUSCANDRA SAPUTRA8965TIDAK LULUSBUNGA RENATA KASTALISTY8965TIDAK LULUSBONG TJIE LAN4545LULUSBIMO WINDYARTHO SUHARYONO7866TIDAK LULUSBENNY DJUMHANA657789TIDAK LULUSBANDY SUBANDY8989TIDAK LULUSBAMBANG YULIANTO788990TIDAK LULUSBAMBANG TRIGUNA6690TIDAK LULUSBAMBANG RAHAYU BAWIYONO7565TIDAK LULUSBAGUS WICAKSONO544044LULUSAZHARI3378TIDAK LULUSASWIN, SH457866TIDAK LULUSASNGARI678975TIDAK LULUSANDREAS ARDIAN PRAMADITYA899054TIDAK LULUS

MENU

42-J42. Solusi - Penulisan Rumus Tidak Sesuai dengan SintaksNAMANILAI 1NILAI 2NILAI 3KETERANGANDEDDY GUSTRIZA405554TIDAK LULUSDARMAWANTI668989LULUSCHRISNA PRIHAYANTO878990LULUSCASIYAN3050TIDAK LULUSCANDRA SAPUTRA8965LULUSBUNGA RENATA KASTALISTY8965LULUSBONG TJIE LAN4545TIDAK LULUSBIMO WINDYARTHO SUHARYONO7866LULUSBENNY DJUMHANA657789LULUSBANDY SUBANDY8989LULUSBAMBANG YULIANTO788990LULUSBAMBANG TRIGUNA6690LULUSBAMBANG RAHAYU BAWIYONO7565LULUSBAGUS WICAKSONO544044TIDAK LULUSAZHARI3378LULUSASWIN, SH457866LULUSASNGARI678975LULUSANDREAS ARDIAN PRAMADITYA899054LULUS

MENUMENU

43-S43. Kesalahan Memilih FungsiNO.NAMASALAH1ANDRI GHAZALIandri ghazali3ARYADI SUBAGYOaryadi subagyo6IKA SISWANTIika siswanti7SITI HERYATIsiti heryati8VERONICA SUYATMIveronica suyatmi9MIKHRIANI HAPSARImikhriani hapsari10SUTOPO KHAIDARsutopo khaidar11AMALINDA SAVIRANIamalinda savirani12DANARDONO RIDWANdanardono ridwan13WAHYU ARDININGTYASwahyu ardiningtyas

MENU

43-J43. Solusi - Kesalahan Memilih FungsiNO.NAMA1Andri Ghazali3Aryadi Subagyo6Ika Siswanti7Siti Heryati8Veronica Suyatmi9Mikhriani Hapsari10Sutopo Khaidar11Amalinda Savirani12Danardono Ridwan13Wahyu Ardiningtyas

MENUMENU

44-S44. Kesalahan Tidak Memanfaatkan Fungsi LainNAMANAMA BARANGJUMLAH HARGAUNITHARGA/UNITDEDDY GUSTRIZABUKU250,000550,000DARMAWANTIPENSIL360,000660,000CHRISNA PRIHAYANTOBALLPOIN250,000550,000CASIYANBUKU0.0CANDRA SAPUTRAPENSIL250,000550,000BUNGA RENATA KASTALISTYPENSIL160,000440,000BONG TJIE LANBUKU360,000660,000BIMO WINDYARTHO SUHARYONOBUKU490,000770,000BENNY DJUMHANABUKU640,000880,000BANDY SUBANDYBALLPOIN490,000770,000BAMBANG YULIANTOBALLPOIN0.0BAMBANG TRIGUNABUKU250,000550,000BAMBANG RAHAYU BAWIYONOPENSIL360,000660,000BAGUS WICAKSONOBUKU250,000550,000AZHARIPENSIL0.0ASWIN, SHPENSIL250,000550,000ASNGARIBUKU360,000660,000ANDREAS ARDIAN PRAMADITYABUKU160,000440,0000.0

MENU

44-J44. Solusi - Kesalahan Tidak Memanfaatkan Fungsi LainNAMANAMA BARANGJUMLAH HARGAUNITHARGA/UNITDEDDY GUSTRIZABUKU250,000550,000DARMAWANTIPENSIL360,000660,000CHRISNA PRIHAYANTOBALLPOIN250,000550,000CASIYANBUKU0.0CANDRA SAPUTRAPENSIL250,000550,000BUNGA RENATA KASTALISTYPENSIL160,000440,000BONG TJIE LANBUKU360,000660,000BIMO WINDYARTHO SUHARYONOBUKU490,000770,000BENNY DJUMHANABUKU640,000880,000BANDY SUBANDYBALLPOIN490,000770,000BAMBANG YULIANTOBALLPOIN0.0BAMBANG TRIGUNABUKU250,000550,000BAMBANG RAHAYU BAWIYONOPENSIL360,000660,000BAGUS WICAKSONOBUKU250,000550,000AZHARIPENSIL0.0ASWIN, SHPENSIL250,000550,000ASNGARIBUKU360,000660,000ANDREAS ARDIAN PRAMADITYABUKU160,000440,000

MENUMENU

45-S45. Kesalahan Tidak Memanfaatkan Fungsi LainNAMANAMA BARANGJUMLAH HARGAUNITHARGA/UNITDEDDY GUSTRIZABUKU250,000550,000DARMAWANTIPENSIL360,000660,000CHRISNA PRIHAYANTOBALLPOIN250,000550,000CASIYANBUKU0.0CANDRA SAPUTRAPENSIL250,000550,000BUNGA RENATA KASTALISTYPENSIL160,000440,000BONG TJIE LANBUKU360,000660,000BIMO WINDYARTHO SUHARYONOBUKU490,000770,000BENNY DJUMHANABUKU640,000880,000BANDY SUBANDYBALLPOIN490,000770,000BAMBANG YULIANTOBALLPOIN0.0BAMBANG TRIGUNABUKU250,000550,000BAMBANG RAHAYU BAWIYONOPENSIL360,000660,000BAGUS WICAKSONOBUKU250,000550,000AZHARIPENSIL0.0ASWIN, SHPENSIL250,000550,000ASNGARIBUKU360,000660,000ANDREAS ARDIAN PRAMADITYABUKU160,000440,000PENSIL1,380,00026BUKU2,510,00041BALLPOIN740,00012

MENU

45-J45. Solusi - Kesalahan Tidak Memanfaatkan Fungsi LainNAMANAMA BARANGJUMLAH HARGAUNITHARGA/UNITDEDDY GUSTRIZABUKU250,000550,000DARMAWANTIPENSIL360,000660,000CHRISNA PRIHAYANTOBALLPOIN250,000550,000CASIYANBUKU0.0CANDRA SAPUTRAPENSIL250,000550,000BUNGA RENATA KASTALISTYPENSIL160,000440,000BONG TJIE LANBUKU360,000660,000BIMO WINDYARTHO SUHARYONOBUKU490,000770,000BENNY DJUMHANABUKU640,000880,000BANDY SUBANDYBALLPOIN490,000770,000BAMBANG YULIANTOBALLPOIN0.0BAMBANG TRIGUNABUKU250,000550,000BAMBANG RAHAYU BAWIYONOPENSIL360,000660,000BAGUS WICAKSONOBUKU250,000550,000AZHARIPENSIL0.0ASWIN, SHPENSIL250,000550,000ASNGARIBUKU360,000660,000ANDREAS ARDIAN PRAMADITYABUKU160,000440,000PENSIL1,380,00026BUKU2,760,00046BALLPOIN740,00012

MENUMENU

46-S46. Kesalahan dalam Memasukkan Hirarkhi OperatorNAMABHS.INDONESIABHS. INGGRISRATA-RATAKETERANGANDEDDY GUSTRIZA565583.50TIDAK LULUSDARMAWANTI446777.50TIDAK LULUSCHRISNA PRIHAYANTO458788.50TIDAK LULUSCASIYAN5599104.50TIDAK LULUSCANDRA SAPUTRA6778106.00TIDAK LULUSBUNGA RENATA KASTALISTY8777125.50TIDAK LULUSBONG TJIE LAN9986142.00TIDAK LULUSBIMO WINDYARTHO SUHARYONO7875115.50TIDAK LULUSBENNY DJUMHANA7755104.50TIDAK LULUSBANDY SUBANDY8667119.50TIDAK LULUSBAMBANG YULIANTO7587118.50TIDAK LULUSBAMBANG TRIGUNA6699115.50TIDAK LULUSBAMBANG RAHAYU BAWIYONO7878117.00TIDAK LULUSBAGUS WICAKSONO487786.50TIDAK LULUSAZHARI9786140.00TIDAK LULUSASWIN, SH6775104.50TIDAK LULUSASNGARI8866121.00TIDAK LULUSANDREAS ARDIAN PRAMADITYA9078129.00TIDAK LULUS

MENU

46-J46. Solusi - Kesalahan dalam Memasukkan Hirarkhi OperatorNAMABHS.INDONESIABHS. INGGRISRATA-RATAKETERANGANDEDDY GUSTRIZA565555.50LULUSDARMAWANTI446755.50LULUSCHRISNA PRIHAYANTO458766.00TIDAK LULUSCASIYAN559977.00TIDAK LULUSCANDRA SAPUTRA677872.50TIDAK LULUSBUNGA RENATA KASTALISTY877782.00TIDAK LULUSBONG TJIE LAN998692.50TIDAK LULUSBIMO WINDYARTHO SUHARYONO787576.50TIDAK LULUSBENNY DJUMHANA775566.00TIDAK LULUSBANDY SUBANDY866776.50TIDAK LULUSBAMBANG YULIANTO758781.00TIDAK LULUSBAMBANG TRIGUNA669982.50TIDAK LULUSBAMBANG RAHAYU BAWIYONO787878.00TIDAK LULUSBAGUS WICAKSONO487762.50TIDAK LULUSAZHARI978691.50TIDAK LULUSASWIN, SH677571.00TIDAK LULUSASNGARI886677.00TIDAK LULUSANDREAS ARDIAN PRAMADITYA907884.00TIDAK LULUS

MENUMENU

47-S47. Kesalahan dalam Menulis RumusNAMABHS.INDONESIABHS. INGGRISRATA-RATAKETERANGANPREDIKATDEDDY GUSTRIZA565555.50LULUSDDARMAWANTI446755.50LULUSDCHRISNA PRIHAYANTO458766.00TIDAK LULUSDCASIYAN559977.00TIDAK LULUSDCANDRA SAPUTRA677872.50TIDAK LULUSDBUNGA RENATA KASTALISTY877782.00TIDAK LULUSDBONG TJIE LAN998692.50TIDAK LULUSDBIMO WINDYARTHO SUHARYONO787576.50TIDAK LULUSDBENNY DJUMHANA775566.00TIDAK LULUSDBANDY SUBANDY866776.50TIDAK LULUSDBAMBANG YULIANTO758781.00TIDAK LULUSDBAMBANG TRIGUNA669982.50TIDAK LULUSDBAMBANG RAHAYU BAWIYONO787878.00TIDAK LULUSDBAGUS WICAKSONO487762.50TIDAK LULUSDAZHARI978691.50TIDAK LULUSDASWIN, SH677571.00TIDAK LULUSDASNGARI886677.00TIDAK LULUSDANDREAS ARDIAN PRAMADITYA907884.00TIDAK LULUSD

MENU

47-J47. Solusi - Kesalahan dalam Menulis RumusNAMABHS.INDONESIABHS. INGGRISRATA-RATAKETERANGANPREDIKATDEDDY GUSTRIZA565555.50TIDAK LULUSDDARMAWANTI446755.50TIDAK LULUSDCHRISNA PRIHAYANTO458766.00LULUSCCASIYAN559977.00LULUSCCANDRA SAPUTRA677872.50LULUSCBUNGA RENATA KASTALISTY877782.00LULUSBBONG TJIE LAN998692.50LULUSABIMO WINDYARTHO SUHARYONO787576.50LULUSCBENNY DJUMHANA775566.00LULUSCBANDY SUBANDY866776.50LULUSCBAMBANG YULIANTO758781.00LULUSBBAMBANG TRIGUNA669982.50LULUSBBAMBANG RAHAYU BAWIYONO787878.00LULUSCBAGUS WICAKSONO487762.50LULUSCAZHARI978691.50LULUSAASWIN, SH677571.00LULUSCASNGARI886677.00LULUSCANDREAS ARDIAN PRAMADITYA907884.00LULUSB

MENUMENU

48-S48. Kesalahan dalam Penentuan Alamat RangeNAMABHS.INDONESIABHS. INGGRISRATA-RATARANKINGDEDDY GUSTRIZA705562.5016DARMAWANTI446755.5017CHRISNA PRIHAYANTO458766.0014CASIYAN559977.008CANDRA SAPUTRA677872.5011BUNGA RENATA KASTALISTY877782.005BONG TJIE LAN998692.501BIMO WINDYARTHO SUHARYONO787576.507BENNY DJUMHANA775566.009BANDY SUBANDY866776.507BAMBANG YULIANTO758781.004BAMBANG TRIGUNA669982.503BAMBANG RAHAYU BAWIYONO787878.003BAGUS WICAKSONO487762.505AZHARI978691.501ASWIN, SH677571.003ASNGARI886677.002ANDREAS ARDIAN PRAMADITYA907884.001

MENU

48-J48. Solusi - Kesalahan dalam Penentuan Alamat RangeNAMABHS.INDONESIABHS. INGGRISRATA-RATARANKINGDEDDY GUSTRIZA705562.5016DARMAWANTI446755.5018CHRISNA PRIHAYANTO458766.0014CASIYAN559977.008CANDRA SAPUTRA677872.5012BUNGA RENATA KASTALISTY877782.005BONG TJIE LAN998692.501BIMO WINDYARTHO SUHARYONO787576.5010BENNY DJUMHANA775566.0014BANDY SUBANDY866776.5010BAMBANG YULIANTO758781.006BAMBANG TRIGUNA669982.504BAMBANG RAHAYU BAWIYONO787878.007BAGUS WICAKSONO487762.5016AZHARI978691.502ASWIN, SH677571.0013ASNGARI886677.008ANDREAS ARDIAN PRAMADITYA907884.003

MENUMENU

49-S49. Kesalahan dalam Menulis RumusLAPTOP (L) PER JAM3,000PC (P) PER JAM5,000NAMAKODEKOMPUTERMULAISELESAILAMABIAYA SEWADWI MULYONOLLAPTOP8:209:201:00:000:00:00DHANY PRAMBUDI NOVIANTOPPC9:2010:461:26:000:00:00DEWI SUMARTINILLAPTOP10:2012:001:40:480:00:00DEDDY GUSTRIZALLAPTOP8:2010:151:55:120:00:00DARMAWANTILLAPTOP8:2010:292:09:360:00:00CHRISNA PRIHAYANTOPPC8:2010:442:24:000:00:00CASIYANPPC10:2012:582:38:240:00:00CANDRA SAPUTRAPPC10:2513:172:52:480:00:00BUNGA RENATA KASTALISTYPPC10:3011:301:00:000:00:00BONG TJIE LANPPC10:3513:563:21:360:00:00BIMO WINDYARTHO SUHARYONOLLAPTOP8:2011:563:36:000:00:00BENNY DJUMHANAPPC8:2012:103:50:240:00:00BANDY SUBANDYLLAPTOP10:2014:244:04:480:00:00BAMBANG YULIANTOPPC10:2514:444:19:120:00:00BAMBANG TRIGUNALLAPTOP9:2013:534:33:360:00:00BAMBANG RAHAYU BAWIYONOPPC10:2015:084:48:000:00:00BAGUS WICAKSONOPPC8:2013:225:02:240:00:00AZHARIPPC8:2013:365:16:480:00:00ASWIN, SHPPC9:2014:515:31:120:00:00J U M L A H0:00:00

MENU

49-J49. Solusi - Kesalahan dalam Menulis RumusLAPTOP (L) PER JAM3,000PC (P) PER JAM5,000NAMAKODEKOMPUTERMULAISELESAILAMABIAYA SEWADWI MULYONOLLAPTOP8:209:201:00:000:00:00DHANY PRAMBUDI NOVIANTOPPC9:2010:461:26:0014:40:00DEWI SUMARTINILLAPTOP10:2012:001:40:480:00:00DEDDY GUSTRIZALLAPTOP8:2010:151:55:120:00:00DARMAWANTILLAPTOP8:2010:292:09:360:00:00CHRISNA PRIHAYANTOPPC8:2010:442:24:000:00:00CASIYANPPC10:2012:582:38:240:00:00CANDRA SAPUTRAPPC10:2513:172:52:480:00:00BUNGA RENATA KASTALISTYPPC10:3011:301:00:008:00:00BONG TJIE LANPPC10:3513:563:21:360:00:00BIMO WINDYARTHO SUHARYONOLLAPTOP8:2011:563:36:000:00:00BENNY DJUMHANAPPC8:2012:103:50:240:00:00BANDY SUBANDYLLAPTOP10:2014:244:04:480:00:00BAMBANG YULIANTOPPC10:2514:444:19:120:00:00BAMBANG TRIGUNALLAPTOP9:2013:534:33:360:00:00BAMBANG RAHAYU BAWIYONOPPC10:2015:084:48:000:00:00BAGUS WICAKSONOPPC8:2013:225:02:240:00:00AZHARIPPC8:2013:365:16:480:00:00ASWIN, SHPPC9:2014:515:31:120:00:00J U M L A H0:00:00

MENUMENU

50-S50. Penulisan Rumus yang Tidak LengkapLAPTOP (L) PER JAM3,000PC (P) PER JAM5,000NAMAKODEKOMPUTERMULAISELESAILAMABIAYA SEWADWI MULYONOLLAPTOP8:209:201:00:000:00:00DHANY PRAMBUDI NOVIANTOPPC9:2010:461:26:0014:40:00DEWI SUMARTINILLAPTOP10:2012:001:40:480:00:00DEDDY GUSTRIZALLAPTOP8:2010:151:55:120:00:00DARMAWANTILLAPTOP8:2010:292:09:360:00:00CHRISNA PRIHAYANTOPPC8:2010:442:24:000:00:00CASIYANPPC10:2012:582:38:240:00:00CANDRA SAPUTRAPPC10:2513:172:52:480:00:00BUNGA RENATA KASTALISTYPPC10:3011:301:00:008:00:00BONG TJIE LANPPC10:3513:563:21:360:00:00BIMO WINDYARTHO SUHARYONOLLAPTOP8:2011:563:36:000:00:00BENNY DJUMHANAPPC8:2012:103:50:240:00:00BANDY SUBANDYLLAPTOP10:2014:244:04:480:00:00BAMBANG YULIANTOPPC10:2514:444:19:120:00:00BAMBANG TRIGUNALLAPTOP9:2013:534:33:360:00:00BAMBANG RAHAYU BAWIYONOPPC10:2015:084:48:000:00:00BAGUS WICAKSONOPPC8:2013:225:02:240:00:00AZHARIPPC8:2013:365:16:480:00:00ASWIN, SHPPC9:2014:515:31:120:00:00J U M L A H22:40:00

MENU

50-J50. Solusi - Penulisan Rumus yang Tidak LengkapLAPTOP (L) PER JAM3,000PC (P) PER JAM5,000NAMAKODEKOMPUTERMULAISELESAILAMABIAYA SEWADWI MULYONOLLAPTOP8:209:2001.003,000DHANY PRAMBUDI NOVIANTOPPC9:2010:4601.267,167DEWI SUMARTINILLAPTOP10:2012:0001.405,040DEDDY GUSTRIZALLAPTOP8:2010:1501.555,760DARMAWANTILLAPTOP8:2010:2902.096,480CHRISNA PRIHAYANTOPPC8:2010:4402.2412,000CASIYANPPC10:2012:5802.3813,200CANDRA SAPUTRAPPC10:2513:1702.5214,400BUNGA RENATA KASTALISTYPPC10:3011:3001.005,000BONG TJIE LANPPC10:3513:5603.2116,800BIMO WINDYARTHO SUHARYONOLLAPTOP8:2011:5603.3610,800BENNY DJUMHANAPPC8:2012:1003.5019,200BANDY SUBANDYLLAPTOP10:2014:2404.0412,240BAMBANG YULIANTOPPC10:2514:4404.1921,600BAMBANG TRIGUNALLAPTOP9:2013:5304.3313,680BAMBANG RAHAYU BAWIYONOPPC10:2015:0804.4824,000BAGUS WICAKSONOPPC8:2013:2205.0225,200AZHARIPPC8:2013:3605.1626,400ASWIN, SHPPC9:2014:5105.3127,600J U M L A H269,567

MENUMENU

51-S51. Penggunaan Rumus yang Tidak TepatNAMATGL.LHRUMURSULINDA BR GINTING4/10/74-25122.0SULASTRI10/10/75SRI WURYANTI3/11/78SITI UMROH8/5/67SITI RUBIATI M DAMAJANTI9/15/54SITI DJULAEHA6/17/66SEPTI LIYA MARLINA9/11/81SARONIH9/10/62SARI MUJIATI12/6/78ROSMALA10/17/75ROKHAYATI9/9/82RINA NUR AENI4/6/73RIA SRI BULAN7/27/62

MENU

51-J51. Solusi - Penggunaan Rumus yang Tidak TepatNAMATGL.LHRUMURSULINDA BR GINTING4/10/7433 TAHUNSULASTRI10/10/7532 TAHUNSRI WURYANTI3/11/7829 TAHUNSITI UMROH8/5/6740 TAHUNSITI RUBIATI M DAMAJANTI9/15/5453 TAHUNSITI DJULAEHA6/17/6641 TAHUNSEPTI LIYA MARLINA9/11/8126 TAHUNSARONIH9/10/6245 TAHUNSARI MUJIATI12/6/7829 TAHUNROSMALA10/17/7532 TAHUNROKHAYATI9/9/8225 TAHUNRINA NUR AENI4/6/7334 TAHUNRIA SRI BULAN7/27/6245 TAHUN

MENUMENU

52-S52. Kesalahan Penggunaan Fungsi RIGHT pada Data Bertipe DATENAMATGL.LHRUMURSULINDA BR GINTING4/10/74-5122.0SULASTRI10/10/75-5670.0SRI WURYANTI3/11/78-6553.0SITI UMROH8/5/67-2682.0SITI RUBIATI M DAMAJANTI9/15/54-7975.0SITI DJULAEHA6/17/66-2268.0SEPTI LIYA MARLINA9/11/81-7833.0SARONIH9/10/62-892.0SARI MUJIATI12/6/78-6823.0ROSMALA10/17/75-5677.0ROKHAYATI9/9/8212/8/04 0:00RINA NUR AENI4/6/731/1/70 7:59RIA SRI BULAN7/27/621/1/70 7:59

MENU

52-J52. Solusi - Kesalahan Penggunaan Fungsi RIGHT pada Data Bertipe DATENAMATGL.LHRUMURSULINDA BR GINTING4/10/7433 TAHUNSULASTRI10/10/7532 TAHUNSRI WURYANTI3/11/7829 TAHUNSITI UMROH8/5/6740 TAHUNSITI RUBIATI M DAMAJANTI9/15/5453 TAHUNSITI DJULAEHA6/17/6641 TAHUNSEPTI LIYA MARLINA9/11/8126 TAHUNSARONIH9/10/6245 TAHUNSARI MUJIATI12/6/7829 TAHUNROSMALA10/17/7532 TAHUNROKHAYATI9/9/8225 TAHUNRINA NUR AENI4/6/7334 TAHUNRIA SRI BULAN7/27/6245 TAHUN

MENUMENU

53-S53. Kesalahan Penggunaan Fungsi MID pada Data Bertipe DATENAMATGL.LHRBULAN KESULINDA BR GINTING10/04/7429SULASTRI10/10/7577SRI WURYANTI11/03/7860SITI UMROH05/08/6789SITI RUBIATI M DAMAJANTI15/09/5482SITI DJULAEHA17/06/6675SEPTI LIYA MARLINA11/09/8140SARONIH10/09/6299SARI MUJIATI06/12/7830ROSMALA17/10/7584ROKHAYATI09/09/8203RINA NUR AENI06/04/7360RIA SRI BULAN27/07/6254

MENU

53-J53. Solusi - Penggunaan Fungsi MID pada Data Bertipe DATENAMATGL.LHRBULAN KESULINDA BR GINTING10/04/744SULASTRI10/10/7510SRI WURYANTI11/03/783SITI UMROH05/08/678SITI RUBIATI M DAMAJANTI15/09/549SITI DJULAEHA17/06/666SEPTI LIYA MARLINA11/09/819SARONIH10/09/629SARI MUJIATI06/12/7812ROSMALA17/10/7510ROKHAYATI09/09/829RINA NUR AENI06/04/734RIA SRI BULAN27/07/627

MENUMENU

54-S54. Penggunaan Fungsi MONTH yang Tidak TepatNAMATGL.LHRBULANSULINDA BR GINTING10/04/744SULASTRI10/10/7510SRI WURYANTI11/03/783SITI UMROH05/08/678SITI RUBIATI M DAMAJANTI15/09/549SITI DJULAEHA17/06/666SEPTI LIYA MARLINA11/09/819SARONIH10/09/629SARI MUJIATI06/12/7812ROSMALA17/10/7510ROKHAYATI09/09/829RINA NUR AENI06/04/734RIA SRI BULAN27/07/627

MENU

54-J54. Solusi - Penggunaan Fungsi MONTH yang Tidak TepatNAMATGL.LHRBULANSULINDA BR GINTING10/04/74APRILSULASTRI10/10/75OKTOBERSRI WURYANTI11/03/78MARETSITI UMROH05/08/67AGUSTUSSITI RUBIATI M DAMAJANTI15/09/54SEPTEMBERSITI DJULAEHA17/06/66JUNISEPTI LIYA MARLINA11/09/81SEPTEMBERSARONIH10/09/62SEPTEMBERSARI MUJIATI06/12/78DESEMBERROSMALA17/10/75OKTOBERROKHAYATI09/09/82SEPTEMBERRINA NUR AENI06/04/73APRILRIA SRI BULAN27/07/62JULI

MENUMENU

55-S55. Kesalahan Format dalam Penggunaan Fungsi NOWNAMATGL.LHRTGL. SEKARANGUMUR DLM HARISULINDA BR GINTING10/04/7410/09/0712,207SULASTRI10/10/7510/09/0711,659SRI WURYANTI11/03/7810/09/0710,776SITI UMROH05/08/6710/09/0714,647SITI RUBIATI M DAMAJANTI15/09/5410/09/0719,354SITI DJULAEHA17/06/6610/09/0715,061SEPTI LIYA MARLINA11/09/8110/09/079,496SARONIH10/09/6210/09/0716,437SARI MUJIATI06/12/7810/09/0710,506ROSMALA17/10/7510/09/0711,652ROKHAYATI09/09/8210/09/079,133RINA NUR AENI06/04/7310/09/0712,576RIA SRI BULAN27/07/6210/09/0716,482

MENU

55-J55. Solusi - Kesalahan Format dalam Penggunaan Fungsi NOWNAMATGL.LHRTGL. SEKARANGUMUR DLM HARISULINDA BR GINTING10/04/7410/09/0712,207 TAHUNSULASTRI10/10/7510/09/0711,659 TAHUNSRI WURYANTI11/03/7810/09/0710,776 TAHUNSITI UMROH05/08/6710/09/0714,647 TAHUNSITI RUBIATI M DAMAJANTI15/09/5410/09/0719,354 TAHUNSITI DJULAEHA17/06/6610/09/0715,061 TAHUNSEPTI LIYA MARLINA11/09/8110/09/079,496 TAHUNSARONIH10/09/6210/09/0716,437 TAHUNSARI MUJIATI06/12/7810/09/0710,506 TAHUNROSMALA17/10/7510/09/0711,652 TAHUNROKHAYATI09/09/8210/09/079,133 TAHUNRINA NUR AENI06/04/7310/09/0712,576 TAHUNRIA SRI BULAN27/07/6210/09/0716,482 TAHUN

MENUMENU

56-S56. Range Data pada Fungsi VLOOKUP Tidak DiabsolutkanNAMATGL.LHRUMURRANGE UMURUMURRANGE UMURSULINDA BR GINTING10/04/743300< 10 TAHUNSULASTRI10/10/753201010 - 20 TAHUNSRI WURYANTI11/03/782902020 - 30 TAHUNSITI UMROH05/08/6740> 40 TAHUN3030 - 40 TAHUNSITI RUBIATI M DAMAJANTI15/09/5453040> 40 TAHUNSITI DJULAEHA17/06/66410SEPTI LIYA MARLINA11/09/81260SARONIH10/09/62450SARI MUJIATI06/12/78290ROSMALA17/10/75320ROKHAYATI09/09/82250RINA NUR AENI06/04/73340RIA SRI BULAN27/07/62450

MENU

56-J56. Solusi - Range Data pada Fungsi VLOOKUP Tidak DiabsolutkanNAMATGL.LHRUMURRANGE UMURUMURRANGE UMURSULINDA BR GINTING10/04/743330 - 40 TAHUN0< 10 TAHUNSULASTRI10/10/753230 - 40 TAHUN1010 - 20 TAHUNSRI WURYANTI11/03/782920 - 30 TAHUN2020 - 30 TAHUNSITI UMROH05/08/6740> 40 TAHUN3030 - 40 TAHUNSITI RUBIATI M DAMAJANTI15/09/5453> 40 TAHUN40> 40 TAHUNSITI DJULAEHA17/06/6641> 40 TAHUNSEPTI LIYA MARLINA11/09/812620 - 30 TAHUNSARONIH10/09/6245> 40 TAHUNSARI MUJIATI06/12/782920 - 30 TAHUNROSMALA17/10/753230 - 40 TAHUNROKHAYATI09/09/822520 - 30 TAHUNRINA NUR AENI06/04/733430 - 40 TAHUNRIA SRI BULAN27/07/6245> 40 TAHUN

MENUMENU

57-S57. Kesalahan Penulisan Fungsi VLOOKUP dan Option FalseNo. MhsNamaNilaiHurufNilaiHuruf99-T-1301Malinda8500E99-T-1302Alan74060D99-T-1303Heru59080C99-T-1304Wiwien87090B99-T-1305Toto660100A99-T-1306Selviany91099-T-1307Chandra97099-T-1308Pinkan68099-T-1309Deddy78099-T-1310Abraham860

MENU

57-J57. Solusi - Kesalahan Penulisan Fungsi VLOOKUP dan Option FalseNo. MhsNamaNilaiHurufNilaiHuruf99-T-1301Malinda85C0E99-T-1302Alan74D60D99-T-1303Heru59E80C99-T-1304Wiwien87C90B99-T-1305Toto66D100A99-T-1306Selviany91B99-T-1307Chandra97B99-T-1308Pinkan68D99-T-1309Deddy78D99-T-1310Abraham86C

MENUMENU

58-S58. Menggunakan Fungsi MINUTE Untuk MenggambarkanJAM MASUK8:30:00 AMNamaTanggalJam HadirTerlambatSusanti02-08-20038:41:00 AM0.007638888888888862Nova Cherry02-08-20038:45:00 AM0.0Sugiharto04-08-20039:00:00 AM0.0Hartawan07-08-20039:40:00 AM0.0Diana08-08-20038:55:00 AM0.0Susanti10-08-20039:04:00 AM-37834.62222222222Diana13-08-20038:50:00 AM-37834.631944444445Hartawan16-08-20039:35:00 AM-37836.600694444445Susanti18-08-20038:35:00 AM-37839.64236111111Diana19-08-20039:25:00 AM-37840.60763888889Nova Cherry22-08-200310:05:00 AM-37842.57986111111Diana23-08-20038:31:00 AM-37845.64513888889Sugiharto28-08-20039:20:00 AM-37848.61111111111Irawan30-08-20039:14:00 AM-37850.615277777775Sugiharto30-08-20038:32:00 AM0.0

MENU

58-J58. Solusi - Menggunakan Fungsi MINUTE Untuk MenggambarkanJAM MASUK8:30:00 AMNamaTanggalJam HadirTerlambatSusanti02-08-20038:41:00 AM11.0Nova Cherry02-08-20038:45:00 AM15.0Sugiharto04-08-20039:00:00 AM30.0Hartawan07-08-20039:40:00 AM10.0Diana08-08-20038:55:00 AM25.0Susanti10-08-20039:04:00 AM34.0Diana13-08-20038:50:00 AM20.0Hartawan16-08-20039:35:00 AM5.0Susanti18-08-20038:35:00 AM5.0Diana19-08-20039:25:00 AM55.0Nova Cherry22-08-200310:05:00 AM35.0Diana23-08-20038:31:00 AM1.0Sugiharto28-08-20039:20:00 AM50.0Irawan30-08-20039:14:00 AM44.0Sugiharto30-08-20038:32:00 AM2.0

MENUMENU

59-S59. Mengabsolutkan Alamat RelatifKETERANGANPELATIHANPRODUKSIPEMASARANGUDANGJUMLAHGAJI$70,437,500$97,203,750$56,350,000$49,306,250$273,297,500LISTRIK$16,200,625$32,260,375$11,918,025$14,481,950$74,860,975TELEPON$10,199,350$16,087,925$8,311,625$11,889,850$46,488,750PERAWATAN GEDUNG$21,103,075$19,722,500$14,735,525$13,383,125$68,944,225PERAWATAN KENDARAAN$6,480,250$10,171,175$19,440,750$8,875,125$44,967,300JUMLAH$124,420,800$175,445,725$110,755,925$97,936,300$508,558,750PERSENTASE24.47%0.00%0.00%0.00%0.00%

MENU

59-J59. Solusi - Mengabsolutkan Alamat RelatifKETERANGANPELATIHANPRODUKSIPEMASARANGUDANGJUMLAHGAJI$70,437,500$97,203,750$56,350,000$49,306,250$273,297,500LISTRIK$16,200,625$32,260,375$11,918,025$14,481,950$74,860,975TELEPON$10,199,350$16,087,925$8,311,625$11,889,850$46,488,750PERAWATAN GEDUNG$21,103,075$19,722,500$14,735,525$13,383,125$68,944,225PERAWATAN KENDARAAN$6,480,250$10,171,175$19,440,750$8,875,125$44,967,300JUMLAH$124,420,800$175,445,725$110,755,925$97,936,300$508,558,750PERSENTASE24.47%34.50%21.78%19.26%100.00%

MENUMENU

60-S60. Menggabungkan Penulisan Angka dan Teks Sebagai RumusNO.NOMORTANGGALLAMAKAMARBIAYATOTALKAMARBIAYAPASIENMASUKKELUARRAWAT INAPKAMARDOKTERBIAYAKAMARDOKTER1900231-Jan-056-Jan-055 hariVIP0.00.00.01400,000150,0002900294-Jan-0513-Jan-059 hari10.00.00.02300,000100,00039003513-Jan-0518-Jan-057 hari20.00.00.03200,00050,0004900411-Jan-058-Jan-053 hari10.00.00.0VIP500,000200,0005900474-Jan-057-Jan-052 hari30.00.00.069005313-Jan-0521-Jan-052 hariVIP0.00.00.07900594-Jan-059-Jan-059 hari30.00.00.08900655-Jan-0512-Jan-057 hari20.00.00.09900714-Jan-0519-Jan-053 hari30.00.00.0109007713-Jan-0530-Jan-055 hariVIP0.00.00.011900834-Jan-