latihan 4_miftah.xlsx

5
Data Gaji Karyawan PT.XYZ No ID Nama Jabatan Gaji Pokok Tunjangan 1 S-1206 LALA Staf 1,700,000 500,000 2 O-1207 LUKY Operator 1,500,000 3 O-1208 SINTA Operator 1,500,000 4 M-1201 NARIS Manager 2,000,000 1,000,000 5 D-1201 GITA Direktur 3,500,000 1,500,000 keterangan Gaji Kotor : gapok+tunjangan+transport Gaji bersih : gaji kotor-PPh 21

Upload: giegiez-bgr

Post on 06-Nov-2015

219 views

Category:

Documents


0 download

DESCRIPTION

hello

TRANSCRIPT

latihan 1Data Gaji Karyawan PT.XYZNoIDNamaJabatanGaji PokokTunjanganTransportGaji Kotorpph 21 Gaji Bersih1S-1206LALAStaf1,700,000500,000200,0002,400,000100,0002,300,0002O-1207LUKYOperator1,500,000500,0002,000,000100,0001,900,0003O-1208SINTAOperator1,500,000500,0002,000,000100,0001,900,0004M-1201NARISManager2,000,0001,000,000500,0003,500,000100,0003,400,0005D-1201GITADirektur3,500,0001,500,000800,0005,800,000100,0005,700,000Total15,200,000Gaji Terbesar5,700,000keteranganGaji Terkecil1,900,000Gaji Kotor : gapok+tunjangan+transportRata-rata gaji3,040,000Gaji bersih : gaji kotor-PPh 21

latihan 2Data Nilai CybernonamaNilai Tugasrata nilai TUGAS Nilai UTSNilai UAStotal rata2 nilaiKeterangan12341DADAN7590758882808080.67LULUS2DEDEN8070759078.75787878.25LULUS3DILA8075808078.75757576.25LULUS4DESTI8085807078.75858582.92LULUS5DIFA8080807077.5808079.17LULUS

latihan 3teksLENLEFTRIGHTMIDSMK-1207SMA-11088SM8A-1SMK-1201suryadilaga.fajar@gmail.comtugas_1_nama