tugas 3 excel

2
No Kode Barang Nama Barang Harga Satuan 1 L1120 Minyak Goreng Rp 5,250.00 2 L1122 Gas LPG Rp 4,500.00 3 M1120 Mie Instan Rp 2,500.00 4 Q2010 Beras Punel Rp 9,500.00 5 Q2015 Gula Pasir Rp 4,500.00 6 T2110 Telur Ayam Kampung Rp 15,000.00 7 T2111 Telur Ayam Non Kampung Rp 13,000.00 8 T2112 Telur Burung Rp 7,500.00 9 T3110 Tepung Trigu Rp 9,000.00 10 T3112 Tepung Beras Rp 12,000.00

Upload: reza

Post on 07-Nov-2015

226 views

Category:

Documents


2 download

DESCRIPTION

mwnunjukan magaimana menggunakan excel

TRANSCRIPT

Sheet1NoKode BarangNama BarangHarga Satuan1L1120Minyak GorengRp5,250.002L1122Gas LPGRp4,500.003M1120Mie InstanRp2,500.004Q2010Beras PunelRp9,500.005Q2015Gula PasirRp4,500.006T2110Telur Ayam KampungRp15,000.007T2111Telur Ayam Non KampungRp13,000.008T2112Telur Burung Rp7,500.009T3110Tepung TriguRp9,000.0010T3112Tepung BerasRp12,000.00

Sheet2NoKode BarangNama BarangHarga SatuanQTTYJumlah1Q2015Gula Pasir45003135002T2111Telur Ayam Non Kampung13000101300003Q2010Beras Punel95002190004T3110Tepung Trigu90004360005M1120Mie Instan25005125006T3112Tepung Beras1200044800078TOTAL259000

Sheet3