tugas excel

2
DAFTAR PENJUALAN BAR TOKO JAYA WIJAYA POTONGAN HARGA TOKO Rp 20,000 NO Kode Barang Naa Barang Jen!" K#a$!%a" Harga Po&o& ' K2()B )o%*er+oard H K2 '000000 2 K'( P O-.e200/ K' /10000 K ()N )on!%or H K '210000 3 K'(PR Pr!n%er H K' /10000 1 K3(WD O-.e 200 K3 '100000 4 K (PK Ke5+oard H K '210000 Harga Ba5ar Ter%!ngg! Harga Ba5ar Terenda* Ta+e$ Harga Po&o& K#a$!%a" Harga Barang K' /10000 K2 '000000 K '210000 K3 '100000

Upload: ning45

Post on 08-Oct-2015

7 views

Category:

Documents


0 download

DESCRIPTION

tugas exel

TRANSCRIPT

Sheet1DAFTAR PENJUALAN BARANGTOKO JAYA WIJAYAPOTONGAN HARGA TOKORp20,000NOKode BarangNama BarangJenisKualitasHarga PokokJumlah BarangTotal HargaDiskonHarga Bayar1K2-MBMotherboardHK210000005500000050000Rp4,930,0002K1-XPOffice2007SK1750000645000000Rp4,480,0003K3-MNMonitorHK31250000101250000050000Rp12,430,0004K1-PRPrinterHK17500005375000050000Rp3,680,0005K4-WDOffice 2003SK415000007105000000Rp10,480,0006K3-PKKeyboardHK3125000091125000050000Rp11,180,000Harga Bayar TertinggiRp12,430,000Harga Bayar TerendahRp3,680,000Tabel Harga PokokKualitasHarga BarangK1750000K21000000K31250000K41500000

Sheet2

Sheet3