hasil ujian praktik ms-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,170,000Rp8,980,0002HJ. ANIH4700710022SekretarisMenikah1Rp4,500,000Rp750,000Rp450,000Rp350,000Rp6,050,000Rp450,000Rp5,600,0003ASMAROH4700710034Public RelationMenikah2Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp240,000Rp4,710,0004MASDUKI4700710044Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp240,000Rp3,560,0005H. IMAM4700710053ManagerMenikah4Rp6,750,000Rp960,000Rp450,000Rp700,000Rp8,860,000Rp810,000Rp8,050,0006RICHARDUS DJOKO H.4700710061DirekturMenikah4Rp7,800,000Rp1,200,000Rp450,000Rp700,000Rp10,150,000Rp1,170,000Rp8,980,0007H. IMIN4700710073ManagerMenikah1Rp6,750,000Rp960,000Rp450,000Rp350,000Rp8,510,000Rp810,000Rp7,700,0008MANIH4700710084Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp240,000Rp3,560,0009AINUN ARYA SARI Ir.4700710094Public RelationMenikah3Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp240,000Rp4,710,00010SUYATI4700710104Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp240,000Rp3,560,00011MUKSIN4700710115Office BoyMenikah4Rp2,150,000Rp350,000Rp450,000Rp700,000Rp3,650,000Rp107,500Rp3,542,50012DEDE KADER APRINANSAH4700710124Public RelationMenikah1Rp3,200,000Rp600,000Rp450,000Rp350,000Rp4,600,000Rp240,000Rp4,360,00013PAIJEM4700710135Office BoyBujang0Rp2,150,000Rp350,0000.00.0Rp2,500,000Rp107,500Rp2,392,50014ENUNG NURHAYATI4700710144Public RelationMenikah0Rp3,200,000Rp600,000Rp450,0000.0Rp4,250,000Rp240,000Rp4,010,00015ADE ROCHAENI4700710152SekretarisMenikah4Rp4,500,000Rp750,000Rp450,000Rp700,000Rp6,400,000Rp450,000Rp5,950,00016IKSAN4700710164Public RelationBujang0Rp3,200,000Rp600,0000.00.0Rp3,800,000Rp240,000Rp3,560,00017SUKIRON4700710174Public RelationMenikah3Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp240,000Rp4,710,00018NASRIL NARUN4700710183ManagerMenikah4Rp6,750,000Rp960,000Rp450,000Rp700,000Rp8,860,000Rp810,000Rp8,050,00019HARUN BIN RIIN4700710194Public RelationMenikah4Rp3,200,000Rp600,000Rp450,000Rp700,000Rp4,950,000Rp240,000Rp4,710,00020USMAN4700710205Office BoyBujang0Rp2,150,000Rp350,0000.00.0Rp2,500,000Rp107,500Rp2,392,500JUMLAHRp83,300,000Rp13,830,000Rp6,300,000Rp8,050,000Rp111,480,000Rp8,392,500Rp103,087,500GAJI TERTINGGIRp7,800,000Rp1,200,000Rp450,000Rp700,000Rp10,150,000Rp1,170,000Rp8,980,000GAJI TERENDAHRp2,150,000Rp350,0000.00.0Rp2,500,000Rp107,500Rp2,392,500RATA-RATA GAJIRp4,165,000Rp691,500Rp315,000Rp402,500Rp5,574,000Rp419,625Rp5,154,375Petunjuk 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 EXCELKLIK UNTUK MELIHAT GRAFIK

Sheet2

GAJI KARYAWAN PT. ADY DAYA MAKMUR

Sheet3