Jumat, 15 Februari 2013

FUNGSI LOGIKA 1 (LOGIKA BIASA)


Rumus umum:

= IF ( KUNCI_ P1;P2 )

KETERANGAN :

IF = jika
Kunci = alamat
_ = tanda kemungkinan => = , <= ,<,>=,>,<>


CIRI - CIRI :

  • Ada kata jikaatau bila
  • jumlah kemungkinan 
  • (jumlah IFdisesuaikan dengan nilai kemungkinan dikurangi 1 )
  • perlu memperhatikan type atau jenis data                                                                                           (bertype alphanumeric diapit tanda petik 2 (") )                                                                                      
contoh : jika nilai lebih dari 60 maka LULUS
             jika nilai kurang dari atau sama dengan 60 maka GAGAL

Jumat, 01 Februari 2013

Macam-Macam Fungsi Statistik Pada MS. Office Excel

1. SUM, berfungsi untuk melakukan penjumlahan 
Rumus :=SUM(Range), Contoh :SUM (A1:A20) 
2.AVERAGE, Berfungsi untuk mencari nilai Rata-Rata
 Rumus :=AVERAGE(Range), Contoh :SUM (A1:A20) 
3.MIN, Untuk Mencari Nilai terkecil 
Rumus :=MIN(Range), Contoh :MIN (A1:A20)
4. MAX, Untuk Mencari Nilai terkecil 
Rumus :=MAX(Range), Contoh :MAX (A1:A20)

Macam-macam Fungsi String Dalam MS. Office Excel

  • LEFT
    • Fungsi : Mengambil huruf/teks dari sebelah kiri
    • Penulisan : =LEFT(Alamat sel ; jumlah huruf yang diambil)
  • RIGHT
    • Fungsi : Mengambil huruf/teks dari sebelah kanan
    • Penulisan : =RIGHT(Alamat sel ; jumlah huruf yang diambil)


  • MID
    • Fungsi : Mengambil huruf/teks dari tengah




  • VALUE
    • Fungsi : Mengubah string menjadi numerik
    • Penulisan : =VALUE(Alamat sel)

Senin, 19 November 2012

Learning English

Why is Learning English Important? Language is the mean of communication. Mostly groups of society have their own languages. Some of them appear the top global languages. Most people in the world hear about English, Arabic, and Mandarin. However English is the most global spoken language. Then if a man wants to catch a global goal, he has to master English.

Everyone recognize that English is an international language. English is used in writing and speaking by many people all over the world. It can be either as a first or second language. We even hear British, American, Australian, and even Singaporean English. Those various names of English are used as the first language in those countries. Futhermore, some countries have their own languages as a mother language but also use English mostly in daily comunication.

Besides usage in daily interaction, English is also used as a key to open doors leading to scientific and technical knowledge. No wonder we find manual guides andinstructions of many devices written in English. Even if we have a pack of instant noodle, we will see the cooking instruction also written in English. This transfer of science and technic will include many countries in economic, social and politics developement.

Finaly, the most easily seen in the importance of learning English is that most top requirement in filling job opportunities is the ability using English; active or passive. Job applicants who master English are more favourable than ones who do not.

The above facts prove that everybody needs to learn English if he likes to greet the global era.