naskah ujian praktek excel

Sheet1PT. ADY DAYA SENTOSALAPORAN GAJI KARYAWANBULAN MARET 2014

NONAMA KARYWANNIPGOLDIVISIONSTATUSJML ANAKGAJI POKOKTUNJ. JABATANTUNJ. ISTRITUNJ. ANAKGAJI BRUTOPAJAKGAJI BERSIH

1H. DJUPRIH BIN MIMIN H4700710011DirekturMenikah4Rp7,800,000Rp1,200,000Rp450,000Rp700,000Rp10,150,000Rp1,522,500Rp8,627,5002HJ. ANIH4700710022SekretarisMenikah1Rp4,500,000Rp750,000Rp450,000Rp350,000Rp6,050,000Rp605,000Rp5,445,0003ASMAROH4700710034Public RelationMenikah2Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp371,250Rp4,578,7504MASDUKI4700710044Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp285,000Rp3,515,0005H. IMAM4700710053ManagerMenikah4Rp6,750,000Rp960,000Rp450,000Rp700,000Rp8,860,000Rp1,063,200Rp7,796,8006RICHARDUS DJOKO H.4700710061DirekturMenikah4Rp7,800,000Rp1,200,000Rp450,000Rp700,000Rp10,150,000Rp1,522,500Rp8,627,5007H. IMIN4700710073ManagerMenikah1Rp6,750,000Rp960,000Rp450,000Rp350,000Rp8,510,000Rp1,021,200Rp7,488,8008MANIH4700710084Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp285,000Rp3,515,0009AINUN ARYA SARI Ir.4700710094Public RelationMenikah3Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp371,250Rp4,578,75010SUYATI4700710104Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp285,000Rp3,515,00011MUKSIN4700710115Office BoyMenikah4Rp2,150,000Rp350,000Rp450,000Rp700,000Rp3,650,000Rp182,500Rp3,467,50012DEDE KADER APRINANSAH4700710124Public RelationMenikah1Rp3,200,000Rp600,000Rp450,000Rp350,000Rp4,600,000Rp345,000Rp4,255,00013PAIJEM4700710135Office BoyBujang0Rp2,150,000Rp350,0000.00.0Rp2,500,000Rp125,000Rp2,375,00014ENUNG NURHAYATI4700710144Public RelationMenikah0Rp3,200,000Rp600,000Rp450,0000.0Rp4,250,000Rp318,750Rp3,931,25015ADE ROCHAENI4700710152SekretarisMenikah4Rp4,500,000Rp750,000Rp450,000Rp700,000Rp6,400,000Rp640,000Rp5,760,00016IKSAN4700710164Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp285,000Rp3,515,00017SUKIRON4700710174Public RelationMenikah3Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp371,250Rp4,578,75018NASRIL NARUN4700710183ManagerMenikah4Rp6,750,000Rp960,000Rp450,000Rp700,000Rp8,860,000Rp1,063,200Rp7,796,80019HARUN BIN RIIN4700710194Public RelationMenikah4Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp371,250Rp4,578,75020USMAN4700710205Office BoyBujang0Rp2,150,000Rp350,0000.00.0Rp2,500,000Rp125,000Rp2,375,000JUMLAHRp83,300,000Rp13,830,000Rp6,300,000Rp8,050,000Rp111,480,000Rp11,158,850Rp100,321,150GAJI TERTINGGIRp7,800,000Rp1,200,000Rp450,000Rp700,000Rp10,150,000Rp1,522,500Rp8,627,500GAJI TERENDAHRp2,150,000Rp350,0000.00.0Rp2,500,000Rp125,000Rp2,375,000RATA-RATA GAJIRp4,165,000Rp691,500Rp315,000Rp402,500Rp5,574,000Rp557,943Rp5,016,058Petunjuk Pengisian Kolom yang kosongTABEL BANTU - Isilah Kolam Divisi, Gaji Pokok, TUNJ. JABATAN dan Pajak persen dari Gaji Pokok menggunakan Perintah =VLOOKUP - Kolom Tunj. Istri Menggunakan fungsi =if jika Kolom Status Menikah diberi tunjangan 450000, jika bujang 0 (nol)GOLDIVG. POKOKTUNJ. JABPAJAK - Kolom Tunj. Anak diisi dengan fungsi =if jika Jumlah anak 0, maka isilah 0, jika 1 (satu) isilah 350000 selainnya itu isilah 7000001Direktur7800000120000015% - iIsilah Kolom GAJI BRUTO dari GAJI POKOK + TUNJ. JABATAN + TUNJ. ISTRI + TUNJ. ANAK2Sekretaris450000075000010% - Isilah Kolom Gaji Bersih dari Gaji Buto - Pajak3Manager675000096000012% - Isilah Kolom Jumlah, Gaji Tertinggi, Gaji Terendah dan Rata-Rata dengan fungsi Statistik4Public Relation32000006000007.50% - Buatlah Grafik5Office Boy21500003500005% - Simpanlah file ke folder desktop yang kamu buat dengan nama UJIAN PRATIK EXCEL

Sheet2

Sheet3