Rabu, 28 November 2012

Fungsi RIGHT



Fungsi Right
Ø  Fungsi RIGHT digunakan untuk mengambil beberapa karakter Microsoft Excel dari sebelah kanan pada string.
Rumus/ formula dasar dari fungsi RIGHT adalah …..
= RIGHT (String, X) // = RIGHT (alamat sel, X) atau
= RIGHT (String; X) // = RIGHT (alamat sel; X)
Keterangan :
String : kalimat atau string, atau sel yang akan diambil karakternya
X : Jumlah karakter yang diambil dari kanan.
Ø  Bentuk umum penulisan rumus fungsi RIGHT adalah :
=RIGHT(text;num_chars).
Ø  TEXT : adalah referensi yang menyatakan alamat cell yang ingin kita ambil teksnya. Misalnya pada cell B6. Disini juga dapat kita tulis langsung teks yang ingin diambil teksnya, seperti “MICROSOFT” (harus diberi tanda kutip diantara teks tersebut).
=RIGHT(B6;….)
atau
=RIGHT(“MICROSOFT”;….)
Ø  NUM_CHARS : menunjukkan banyaknya karakter yang ingin diambil dari data tersebut. Nilai ini harus berisi dengan angka. Jika num_chars tidak diisi, maka excel akan memberikannya nilai 1.
=RIGHT(B6;4)
atau
=RIGHT(“MICROSOFT”;4)
22.bmp

Soal Microsoft Excel 1 untuk mendapatkan fungsi RIGHT
No
Nama Siswa
Ambil 2 Karakter Di Kanan 2 Karakter


1
Oklisa
sa

2
Farida
da

3
Yaya
ya

4
Ryana
na

5
Ani
ni

6
Rizky
ky

7
Nurhasanah
ah

8
Azizah
ah

Gunakan fungsi RIGHT untuk mengambil 2 karakter dari KANAN
Ø  Langkah – langkah menggunakan Fungsi RIGHT
1.      Buka Microsoft Excel
1.bmp







2.      Buat colom sesuai dengan soal
2.bmp













3.      Masukan rumusnya seperti berikut ini

3.bmp












4.      Hasil dari penggunaan rumus FUngsi RIGHT maka akan sperti dibawah ini :
11.bmp


Soal Microsoft Excel 2 untuk mendapatkan fungsi RIGHT
Data Pengiriman Barang Bulan November
No.
Kode
Tujuan Pemgiriman
Kode Tempat
1
100-550-BPN
Balikpapan
BPN
2
100-551-SMD
Samarinda
SMD
3
100-553-PPU
Penajam Paser Utara
PPU
4
100-601-BJR
Banjar
BJR
Gunakan Fungsi RIGHT untuk mendapatkan “Kode Tempat”



Ø  Langkah – langkah menggunakan Fungsi RIGHT
1.      Buka Microsoft Excel
1.bmp
2.      Tulis semua soal dalam Microsoft Excel
4.bmp


3.      Masukan rumus Fungsi RIGHT seperti di bawah ini
5.bmp





















4.      Maka hasil dari penggunaan rumus Fungsi RIGHT  seperti dibawah ini
6.bmp

Senin, 19 November 2012

Lee Hi - 1,2,3,4






English Translation:
Hey.
C
mon now.
I said 1, 2, 3
Your delusion that Im still yours ends here.
I
m not that same girl you knew before.
At the sound of morning, the flowers have already bloomed so much.
But why are you still so out of focus?
Im sick and tired of your hypocrisy.
You lame liar. (Ooh) Will you just back off now?
I think I
m going, going crazy (ooh).
I think I
m going, going crazy (ooh).
Dont act so miserably and pitifully.
Go disappear far, far away. No, no. Na-na-na-na-na-na.
Don
t cry so pathetically. Just forget everything forever. No, no.
Listen.
Stop worrying about others and just mind your own business.
I don
t need your sympathy or pity. Uh.
I said 1 and 2 and 3, 4 (ooh).
Time will be the one resolving everything.
1 and 2 and 3, 4 (ooh).
Game over. Game over (ooh). Game over.
No matter where you go, no matter how hard you rub your eyes,
another girl like me is so hard to find.
All the boys cry and go like babies at my sexiness and purity.
Im sick and tired of your hypocrisy.
You lame liar. (Ooh) Will you just back off now?
I think I
m going, going crazy (ooh).
I think I
m going, going crazy (ooh).
Dont act so miserably and pitifully.
Go disappear far, far away. No, no. Na-na-na-na-na-na.
Don
t cry so pathetically. Just forget everything forever. No, no.
Listen.
Stop worrying about others and just mind your own business.
I don
t need your sympathy or pity. Uh.
I said 1 and 2 and 3, 4 (ooh).
Time will be the one resolving everything.
1 and 2 and 3, 4 (ooh).
Game over. Game over (ooh). Game over.
It hurts so much. I guess Ive already forgotten you.
Hey baby. Just leave.
I said 1 and 2 and 3, 4 (ooh).
Time will be the one resolving everything.
1 and 2 and 3, 4 (ooh).
Game over. Game over (ooh)
Game over.
1 and 2 and 3, 4
1 and 2 and 3, 4
1 and 2 and 3, 4
Game over
Game over
Game over
Romanized:
Hey
C
mon now
I said 1 2 3
Ajikdo naega ni georaneun
Chakgageun geuman
Yejeonui geuttae naega anya
Achimi barngneun sorie
Kkocheun jeomanchi pyeonneunde
Yeojeonhi jeongsin mot charyeo wae
I’m sick and tired neoui wiseone
Eoseolpeun liar ooh ije jom kkeojyeojullae
I think I’m going going crazy ooh
I think I’m going going crazy ooh
Deo bichamhage guljineun ma
Sarajyeojwo jeo meolli
No no nananananana
Guchahage uljineun ma
Da ijeojwo yeongwonhi no no
Listen
Nam geokjeonghaji malgo neona jal hae
Ni geureon dongjeong ttawin pillyo eobseo uh
I said 1 and 2 and 3 4 ooh
Sigani modeungeol haegyeolhalgeoya
1 and 2 and 3 4 ooh
Game over game over ooh
Game over
Na gateun yeoja eodil gado
Nun ssitgo bwado bogi deumune
Ttaeroneun seksi ttaeron cheongsunhame
Namjadeureun ulgo gane yuchihage
I’m sick and tired neoui wiseone
Eoseolpeun liar ooh jebal jom kkeojyeojullae
I think I’m going going crazy ooh
I think I’m going going crazy ooh
Deo bichamhage guljineun ma
Sarajyeojwo jeo meolli
No no nananananana
Guchahage uljineun ma
Da ijeojwo yeongwonhi no no
Listen
Nam geokjeonghaji malgo neona jal hae
Ni geureon dongjeong ttawin pillyo eobseo uh
I said 1 and 2 and 3 4 ooh
Sigani modeungeol haegyeolhalgeoya
1 and 2 and 3 4 ooh
Game over game over ooh
Game over
Neomuna apa
Beolsseo ijeonna bwa
Hey baby
Tteonagajwo
I said 1 and 2 and 3 4 ooh
Sigani modeungeol haegyeolhalgeoya
1 and 2 and 3 4 ooh
Game over game over ooh
Game over
1 and 2 and 3 4
1 and 2 and 3 4
1 and 2 and 3 4
Game over
Game over
Game over