; latihan hlookup & vlookup
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

latihan hlookup & vlookup

VIEWS: 674 PAGES: 3

  • pg 1
									PENJUALAN TOKO SERBA ADA
     BULAN APRIL 2010

         No Urut         Nama Toko     Kode Sepatu   Merk Sepatu   Harga Satuan
             1     Juita                    A          Adidas        200000
             2     Alex                     C         Crocodile      300000
             3     Neraca                   C         Crocodile      300000
             4     Ronald                   B         Barcelona      250000
             5     Permindo                 A          Adidas        200000
             6     Sport                    D          Diamon        350000
             7     Idola                    D          Diamon        350000
             8     Adidas                   B         Barcelona      250000
             9     Kontak                   A          Adidas        200000
            10     Miyami                   C         Crocodile      300000
            11     Alisa                    A          Adidas        200000
            12     Sandra                   B         Barcelona      250000
            13     Abadi                    C         Crocodile      300000
            14     Boby                     B         Barcelona      250000
            15     Annise                   B         Barcelona      250000
       Jumlah
       Rata-rata
       Nilai Terbesar
          Ket :
                         Kode Sepatu       A              B             C
                         Merk Sepatu     Adidas       Barcelona     Crocodile
                        Harga Satuan     200000        250000        300000
                           Bonus          Jam           Kaos         Payung
Jumlah Barang   Jumlah Harga     Bonus       Kode Barang    Merk
     20           4000000         Jam             1         Philip
     50           15000000       Payung           3        Maspion
     70           21000000       Payung           1         Philip
     30           7500000         Kaos            2          Sony
     35           7000000         Jam             4         Sanyo
     29           10150000       Setrika          3        Maspion
     60           21000000       Setrika          5        Yongma
     45           11250000        Kaos            2          Sony
     35           7000000         Jam             1         Philip
     62           18600000       Payung           5        Yongma
     59           11800000        Jam             2          Sony
     32           8000000         Kaos            5        Yongma
     34           10200000       Payung           3        Maspion
     28           7000000         Kaos            5        Yongma
     56           14000000        Kaos            4         Sanyo




     D                         Kode Barang     Merk         Harga
  Diamon                            1          Philip      450000
  350000                            2           Sony       400000
  Setrika                           3         Maspion      350000
                                    4          Sanyo       300000
                                    5         Yongma       250000
 Harga     Discount   Tanggal Beli   Tanggal Kirim
 450000       5%        2-Apr-11       3-Apr-11
 350000       3%        4-Apr-11       5-Apr-11
 450000       5%        3-Apr-11       4-Apr-11
 400000       4%        7-Apr-11       8-Apr-11
 300000       2%       10-Apr-11      11-Apr-11
 350000       3%       25-Apr-11      26-Apr-11
 250000       1%       20-Apr-11      21-Apr-11
 400000       4%       15-Apr-11      16-Apr-11
 450000       5%       17-Apr-11      18-Apr-11
 250000       1%       13-Apr-11      14-Apr-11
 400000       4%       12-Apr-11      13-Apr-11
 250000       1%        5-Apr-11       6-Apr-11
 350000       3%        9-Apr-11      10-Apr-11
 250000       1%       30-Apr-11       1-May-11
 300000       2%       28-Apr-11      29-Apr-11
5200000
 346667
 450000

Discount
   5%
   4%
   3%
   2%
   1%

								
To top