tag:blogger.com,1999:blog-36734055704439945362024-03-04T20:49:51.326-08:00Adi ngapakberbagi pengetahuan Anonymoushttp://www.blogger.com/profile/14257961015093176403noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3673405570443994536.post-61540310314450290232015-10-10T21:19:00.000-07:002015-10-10T21:19:33.125-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background: white; margin: 22.5pt 0in 0.0001pt;">
<b><span style="font-family: 'Palatino Linotype', serif; font-size: 20.5pt;">Bahasa Rakitan #8 / Cetak Karakater Berwarna<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<a href="http://mardziyant.files.wordpress.com/2012/09/col_char.png"><b><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 9.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-no-proof: yes; mso-themecolor: text1; text-decoration: none; text-underline: none;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_i1029" type="#_x0000_t75"
alt="http://mardziyant.files.wordpress.com/2012/09/col_char.png?w=450"
href="http://mardziyant.files.wordpress.com/2012/09/col_char.png" style='width:206.25pt;
height:137.25pt;visibility:visible;mso-wrap-style:square' o:button="t">
<v:fill o:detectmouseclick="t"/>
<v:imagedata src="file:///C:\Users\TELKOM\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title="col_char"/>
</v:shape><![endif]--><!--[if !vml]--><img alt="http://mardziyant.files.wordpress.com/2012/09/col_char.png?w=450" border="0" height="183" src="file:///C:/Users/TELKOM/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg" v:shapes="Picture_x0020_1" width="275" /><!--[endif]--></span></b></a><b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">“Bikin Hidup Lebih Hidup” </span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">kurang lebihnya seperti itulah kalimat yang pernah
terpampang di sebuah iklan yang sekarang sudah jarang sekali muncul. empat kata
itu sebetulnya punya makna yang bisa buat hidup kita lebih bersemangat, karena
setiap masalah yang muncul dalam hidup kita diposisikan sebagai pewarna hidup.
hidup tanpa warna bagaikan langit tanpa semburat jingga dan bagaikan setelah
hujan tanpa pelangi</span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><!--[if gte vml 1]><v:shape id="Picture_x0020_2"
o:spid="_x0000_i1028" type="#_x0000_t75" alt=";-)" style='width:11.25pt;
height:11.25pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\TELKOM\AppData\Local\Temp\msohtmlclip1\01\clip_image003.gif"
o:title=";-)"/>
</v:shape><![endif]--><!--[if !vml]--><img alt=";-)" border="0" height="15" src="file:///C:/Users/TELKOM/AppData/Local/Temp/msohtmlclip1/01/clip_image003.gif" v:shapes="Picture_x0020_2" width="15" /><!--[endif]--></span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">Nah..semoga dengan pembahasan kali ini pun
bisa seperti itu, karena yang akan kita bahas kali ini adalah tentang warna.
munculkan karakter saja banyak codenya, apalagi munculkan warna.</span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><span class="msoDel"><del> </del></span></span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><span class="msoDel"><del>sulitkah</del></span></span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">?<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">Dalam bahasa rakitan, memunculkan karakter
atau kata atau kalimat berwarna termasuk hal yang mudah, semudah kita
menghitamkan kulit (dibanding memutihkan</span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><!--[if gte vml 1]><v:shape
id="Picture_x0020_3" o:spid="_x0000_i1027" type="#_x0000_t75" alt=":-)"
style='width:11.25pt;height:11.25pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\TELKOM\AppData\Local\Temp\msohtmlclip1\01\clip_image004.gif"
o:title="-)"/>
</v:shape><![endif]--><!--[if !vml]--><img alt=":-)" border="0" height="15" src="file:///C:/Users/TELKOM/AppData/Local/Temp/msohtmlclip1/01/clip_image004.gif" v:shapes="Picture_x0020_3" width="15" /><!--[endif]--></span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">).<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">Warna yang dimaksud disini bukan hanya warna
dari teksnya saja, tapi akan termasuk juga latar belakangnya. untuk bisa
mengeluarkan karakter berwarna, coba anda tuliskan code ini :<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<a href="http://mardziyant.files.wordpress.com/2012/09/code_col.png"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 9.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-no-proof: yes; mso-themecolor: text1; text-decoration: none; text-underline: none;"><!--[if gte vml 1]><v:shape
id="Picture_x0020_4" o:spid="_x0000_i1026" type="#_x0000_t75" alt="http://mardziyant.files.wordpress.com/2012/09/code_col.png?w=450"
href="http://mardziyant.files.wordpress.com/2012/09/code_col.png" style='width:240.75pt;
height:270pt;visibility:visible;mso-wrap-style:square' o:button="t">
<v:fill o:detectmouseclick="t"/>
<v:imagedata src="file:///C:\Users\TELKOM\AppData\Local\Temp\msohtmlclip1\01\clip_image005.png"
o:title="code_col"/>
</v:shape><![endif]--><!--[if !vml]--><img alt="http://mardziyant.files.wordpress.com/2012/09/code_col.png?w=450" border="0" height="360" src="file:///C:/Users/TELKOM/AppData/Local/Temp/msohtmlclip1/01/clip_image006.gif" v:shapes="Picture_x0020_4" width="321" /><!--[endif]--></span></a><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin: 22.5pt 0in 0.0001pt; text-align: justify;">
<b><span style="font-family: 'Palatino Linotype', serif; font-size: 15.5pt;">Interupt 10h – Service 09h</span></b><b><span style="font-family: 'Palatino Linotype', serif; font-size: 15.5pt;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">AH =</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">Isikan nomor service (09h)<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">AL =</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">Isikan karakter yang akan
dicetak<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">BH =</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">Nomor Halaman (default 00)<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">BL =</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">Berisi atribut dari
karakter<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<a href="http://mardziyant.files.wordpress.com/2012/09/atr.png"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 9.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-no-proof: yes; mso-themecolor: text1; text-decoration: none; text-underline: none;"><!--[if gte vml 1]><v:shape
id="Picture_x0020_5" o:spid="_x0000_i1025" type="#_x0000_t75" alt="http://mardziyant.files.wordpress.com/2012/09/atr.png?w=450"
href="http://mardziyant.files.wordpress.com/2012/09/atr.png" style='width:323.25pt;
height:80.25pt;visibility:visible;mso-wrap-style:square' o:button="t">
<v:fill o:detectmouseclick="t"/>
<v:imagedata src="file:///C:\Users\TELKOM\AppData\Local\Temp\msohtmlclip1\01\clip_image007.png"
o:title="atr"/>
</v:shape><![endif]--><!--[if !vml]--><img alt="http://mardziyant.files.wordpress.com/2012/09/atr.png?w=450" border="0" height="107" src="file:///C:/Users/TELKOM/AppData/Local/Temp/msohtmlclip1/01/clip_image008.gif" v:shapes="Picture_x0020_5" width="431" /><!--[endif]--></span></a><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">Keterangan :</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">BL = Blink ( bekedip )<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">R = Merah<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">G = Hijau<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">B = Biru<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">I = Intensitas Warna<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">semua bit hanya bernilai 1 dan 0 saja. jika
kita ingin mengatifkan bit yang bersangkutan maka kita berikan nilai 1 pada bit
tersebut, demikian pula sebaliknya jika kita ingin mematikan bit tersebut.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">misalkan kita ingin memunculkan karakter yang
berlatar belakang</span><b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">biru</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> karakter berwarna </span><b><span style="font-family: Verdana, sans-serif; font-size: 9pt;">merah</span></b><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> </span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">berintensitas tinggi maka
nilai yang kita berikan pada BL adalah</span><span style="font-family: Verdana, sans-serif; font-size: 9pt;"> <b>00011100b</b></span><span style="font-family: Verdana, sans-serif; font-size: 9pt;">.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: white; line-height: 14.25pt; mso-background-themecolor: background1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: 9pt;">Sebagai percobaan, coba susun code yang dapat
memunculkan karakter berwarna hijau dengan latar belakang merah, intensitas
rendah dan berkedip<o:p></o:p></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/14257961015093176403noreply@blogger.com0tag:blogger.com,1999:blog-3673405570443994536.post-24414104028519734542015-10-10T20:58:00.000-07:002015-10-10T20:58:29.592-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-size: 36pt;">Cara setting Ulang Modem ADSL ZTE <o:p></o:p></span></b></div>
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-size: 14pt;">Asslamulaikum Wr Wb <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-size: 14pt;">Di bawah ini adalah cara mudah untuk seting modem ADSL+ dengan
merk ZTE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-size: 14pt;">Pertama siapkan terlebih nomor speedy terlebih dahulu <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-size: 14pt;">Siapkan password speedy <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<span style="font-family: Calibri, sans-serif; font-size: 14pt; line-height: 115%;">Lanjut masuk ke browser</span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">kemudian ketik IP defalut 192.168.1.254</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPUeKLKeJZXzbwNnlafsTvhxIffI7hITn4z5XdRH_vB_tO2R4r0nooL85NsEDJXElSGEYRSV99c0gov0iAtnKO31HtUJv5DwIuc16_uezuILxbQlmZvxyIQ_km50hYIRA8nfoR-Es5r0M/s1600/Untitled.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPUeKLKeJZXzbwNnlafsTvhxIffI7hITn4z5XdRH_vB_tO2R4r0nooL85NsEDJXElSGEYRSV99c0gov0iAtnKO31HtUJv5DwIuc16_uezuILxbQlmZvxyIQ_km50hYIRA8nfoR-Es5r0M/s320/Untitled.jpg" width="258" /></a></div>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">passwod login modem defalut </span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">user:admin</span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">password :admin</span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">oya pastikan lampu ADSL nyala ya broo ,,soalnya kalau Adsl nya mati itu jaringan nya belum tersambung ke modem </span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-jC6NOJXQL-FMCki9Wq8n-X-p7B4WZ3tHwwnPO78tmQx4-hFOgLHAVJflHCBGZFshC969nvYuL6j9738TMNAPP1S5CRL1Wl_OtwqUgkZ-YBBBH4xTA_6a1R9HEDm8XOucbVv0V_qnpww/s1600/Untitled.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-jC6NOJXQL-FMCki9Wq8n-X-p7B4WZ3tHwwnPO78tmQx4-hFOgLHAVJflHCBGZFshC969nvYuL6j9738TMNAPP1S5CRL1Wl_OtwqUgkZ-YBBBH4xTA_6a1R9HEDm8XOucbVv0V_qnpww/s320/Untitled.jpg" width="320" /></a><span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">Lanjut </span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;">masuk ke interface setup kemudian pilih internet </span></span><br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<br />
<span style="font-family: Calibri, sans-serif; font-size: 14pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 14pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 14pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 14pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 14pt; line-height: 115%;"><br /></span>
Kemudian Pilih Pvc 1.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqjkKHx8FyavMmT585c4sXkf-itmjnKaY6cl7PQjs2SyABh6LMmf-NmvFVvNzUycRKZ1Ulh6DeeVq_bowORQByRpDsfU63k0CJIjp89qUPjc2_oCD5usbXq1wkoktNi6ov-XV-ZXi3V6o/s1600/Untitled.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqjkKHx8FyavMmT585c4sXkf-itmjnKaY6cl7PQjs2SyABh6LMmf-NmvFVvNzUycRKZ1Ulh6DeeVq_bowORQByRpDsfU63k0CJIjp89qUPjc2_oCD5usbXq1wkoktNi6ov-XV-ZXi3V6o/s320/Untitled.jpg" width="320" /></a></div>
<br />
VPI :8<br />
VCI:81<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
kemudian masukan user speedy dan password<br />
pilih PPPoE LLC jika ingin di seting PPPoe<br />
klik save<br />
<br />
<br />
sekian terima kasih :D</div>
Anonymoushttp://www.blogger.com/profile/14257961015093176403noreply@blogger.com0tag:blogger.com,1999:blog-3673405570443994536.post-50642314591388063162015-10-10T20:28:00.003-07:002015-10-10T20:28:57.835-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
Assalamualaikum Wr.wb <div>
<br /></div>
<div>
<br /></div>
<div>
Ini lah beberapa rumus MS exel yang sering didunakan </div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div class="MsoListParagraphCxSpFirst" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit; font-size: 12pt; text-indent: -21.3pt;">1.<span style="font-size: 7pt;"> </span></span><span style="font-family: inherit; font-size: 12pt; text-indent: -21.3pt;">Fungsi VALUE </span></div>
<div class="MsoListParagraphCxSpFirst" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;"> digunakan untuk merubah nilai value menjadi nilai text, penulisannya :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> =VALUE(text)<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">2.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi FIND<br />digunakan untuk menghasilkan posisi substring dari sebuah string atau suatu nomor yang dicari,penulisannya :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> =FIND(cari text,pada text,mulai nomor)<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">3.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi MID<br />digunakan untu mengambil karakter tertentu dari sederet karakter, penulisannya :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> =MID(text,posisi awal,jumlah karakter)<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">4.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi REPLACE<br />digunakan untuk menggantikan substring dengan substring lain dalam sebuah string (sederetan karakter atau karakter),, penulisan :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpLast" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> = REPLACE (…)<o:p></o:p></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">5.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi CONCATENATE<br />digunakan untuk menggabungkan string menjadi satu kalimat maksimal 30 string, penulisannya =CONCATENATE(text1,text2,…)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">6.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi MAX<br />Digunakan untuk mencari nilai tertinggi dari sekumpulan data, penulisannya :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> =MAX(number1,number2,…)<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">7.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi STEDEV<br />Digunakan untuk menentukan standart devisiasi dari suatu range, penulisannya : =STEDEV(number1,number2,…)<o:p></o:p></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">8. Fungsi VAR<br />Digunakan untuk menentukan nilai varience dari suatu range, penulisannya : =VAR(number1,number2,…)<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">9. Fungsi LEFT<br />Fungsi ini digunakan untuk mendapatkan hasil beberapa huruf paling kiri. Text di sini merujuk kepada text yang akan diambil. Bisa berupa nilai sel ataupun langsung diketikkan textnya di situ, tapi dengan menambahkan tanda petik dua (") di awal dan di akhir text.<br />Rumusnya sangat simpel.<br />=LEFT(text)<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">10. Fungsi RIGHT<br />Fungsi ini adalah kebalikan dari fungsi LEFT, yaitu mengambil beberapa karakter yang dimulai dari kanan. Rumusnya mirip sekali dengan fungsi LEFT yaitu:<br />=RIGHT(text)<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">11. Fungsi LEN<br />Fungsi ini digunakan untuk menghitung jumlah karakter yang ada di dalam sebuah text. Rumusnya adalah:<br />=LEN(text)<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">12. Fungsi UPPER<br />Fungsi ini akan membuat semua text yang ada di sel menjadi huruf besar semua. penulisannya:<br />= UPPER(text)<o:p></o:p></span></div>
<span style="color: #333333; font-family: inherit; font-size: 13px; line-height: 20px;"><span style="line-height: 14.95px;"><br clear="all" style="page-break-before: always;" /></span></span><br style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px;" /><div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin-left: 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">13. Fungsi LOWER<br />Fungsi ini kebalikan dari fungsi UPPER, yaitu menjadikan huruf kecil semua. penulisannya:<br />=LOWER(text)<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-family: inherit;">14. Fungsi PROPER<br />Fungsi ini akan membuat teks menjadi huruf besar di karakter pertama di setiap kata. Penulisannya:<br />=PROPER(text)</span><o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;">15.<span style="font-size: 7pt;"> </span>Fungsi BAHTTEXT<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"> Mengubah</span><span class="shorttext"> </span><span class="hps">angka</span><span class="shorttext"> </span><span class="hps">ke dalam bentuk teks. Namun hanya beberapa saja yang dapat di rubah.<o:p></o:p></span></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span class="hps"> Penulisan :<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span class="hps"> =TTEXT(…)<o:p></o:p></span></div>
<div style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;">16.<span style="font-size: 7pt;"> </span></span></span><span style="font-size: 12pt;">Fungsi<span class="hps"> FACT<o:p></o:p></span></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;"> Menyatakan</span></span><span style="font-size: 12pt;"> <span class="hps">faktorial dari</span> suatu bilangan. Penulisan :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> =FACT(…)<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">17.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi GCD<o:p></o:p></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;"> Menyatakan</span></span><span style="font-size: 12pt;"> <span class="hps">pembagi</span> <span class="hps">umum terbesar. Penulisan :<o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> =GCD(number1, number2,…)<o:p></o:p></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraph" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">18.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi<span class="hps"> LN</span><o:p></o:p></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;"> Menyatakan</span></span><span style="font-size: 12pt;"> <span class="hps">logaritma natural dari</span> <span class="hps">suatu bilangan. Penulisan :<o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> =LN(number)<o:p></o:p></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraph" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;">19.<span style="font-size: 7pt;"> </span></span></span><span style="font-size: 12pt;">Fungsi<span class="hps"> RAND<o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;"> Menyatakan</span></span><span style="font-size: 12pt;"> <span class="hps">jumlah</span> <span class="hps">real</span> <span class="hps">secara acak</span> <span class="hps">merata</span> <span class="hps">lebih besar</span> <span class="hps">dari atau</span> <span class="hps">sama dengan 0</span> <span class="hps">dan kurang</span> <span class="hps">dari 1</span>. <span class="hps">Sebuah</span> <span class="hps">bilangan real</span><span class="hps">baru secara acak</span> <span class="hps">akan diperlihatkan</span> <span class="hps">setiap kali</span> <span class="hps">lembar kerja</span><span class="hps">dihitung</span>. Penulisan :<o:p></o:p></span></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> =RAND(…)<o:p></o:p></span></div>
<div class="MsoNormal" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;">20.<span style="font-size: 7pt;"> </span></span></span><span style="font-size: 12pt;">Fungsi<span class="hps"> CEILING<o:p></o:p></span></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;"> Menyatakan</span></span><span style="font-size: 12pt;"> <span class="hps">jumlah</span> <span class="hps">pembulatan</span>, jauh <span class="hps">dari nol</span>, <span class="hps">ke</span> <span class="hps">kelipatan terdekatnya. Penulisan :<o:p></o:p></span></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> =CEILING(…)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;">21.<span style="font-size: 7pt;"> </span></span></span><span style="font-size: 12pt;">Fungsi<span class="hps"> SQRT<o:p></o:p></span></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> Untuk menghitung akar dari bilangan yang positif tidak boleh negatif. Penulisan :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> =SQRT(…)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span class="hps"><span style="font-size: 12pt;">22.<span style="font-size: 7pt;"> </span></span></span><span style="font-size: 12pt;">Fungsi<span class="hps"> INT (number)<o:p></o:p></span></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> Untuk pembulatan angka ke bawah dari suatu nilai integer / bulat. Penulisan :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span class="hps"><span style="font-size: 12pt;"> =INT(number)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;">23.<span style="font-size: 7pt;"> </span></span><span style="font-size: 12pt;">Fungsi CHAR<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-size: 12pt;"> Untuk menyatakan karakter yang telah ditentukan menggunakan suatu kode angka. Penulisan :<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin-left: 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;"> Syntax</span><span style="font-size: 12pt;"><o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt;"> =CHAR</span><span style="font-size: 12pt;">(number)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0.0001pt 17.85pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin-left: 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span lang="EN-US" style="line-height: 14.95px;">24.<span style="line-height: normal;"> </span></span><span style="line-height: 14.95px;">F</span><span lang="EN-US" style="line-height: 14.95px;">ungsi SUM :<br />Digunakan untuk menjumlahkan sekumpulan data pada satu range, penulisannya : =SUM(number1,number2,..)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin-left: 0cm;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin-left: 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span lang="EN-US" style="line-height: 14.95px;">25.<span style="line-height: normal;"> </span></span><span lang="EN-US" style="line-height: 14.95px;">Fungsi AVERAGE :<br />Digunakan untuk mencari nilai rata-rata,</span><span lang="EN-US" style="line-height: 14.95px;"> </span><span lang="EN-US" style="line-height: 14.95px;">penulisannya :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin-left: 21.3pt;">
<span lang="EN-US" style="font-family: inherit; line-height: 14.95px;">=AVERAGE(number1,number2,…)<br /><br /><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span lang="EN-US" style="line-height: 14.95px;">26.<span style="line-height: normal;"> </span></span><span lang="EN-US" style="line-height: 14.95px;">Fungsi MIN:<br />Digunakan untuk <span style="color: #009a46;">mencari nilai terendah</span> dari sekumpulan data, penulisannya : =MAX(number1,number2,…)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span lang="EN-US" style="line-height: 14.95px;">27.<span style="line-height: normal;"> </span></span><span lang="EN-US" style="line-height: 14.95px;">Fungsi HLOOKUP</span><span style="line-height: 14.95px;"> :</span><span lang="EN-US" style="line-height: 14.95px;"><o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit;"><span lang="EN-US" style="line-height: 14.95px;">digunakan untuk membaca tabel</span><span style="line-height: 14.95px;"> / range</span><span lang="EN-US" style="line-height: 14.95px;"> secara <span style="color: #009a46;">horizonta</span></span><span style="color: #009a46; line-height: 14.95px;">l</span><span style="line-height: 14.95px;">, penulisannya :</span><span lang="EN-US" style="line-height: 14.95px;"><br />=HLOOKUP(lookup_value,table_array,row_index_num,…)<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span lang="EN-US" style="line-height: 14.95px;">28.<span style="line-height: normal;"> </span></span><span style="line-height: 14.95px;">Fungsi </span><span lang="EN-US" style="line-height: 14.95px;">VLOOKUP </span><span style="line-height: 14.95px;">:</span><span lang="EN-US" style="line-height: 14.95px;"><o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit;"><span style="line-height: 14.95px;">d</span><span lang="EN-US" style="line-height: 14.95px;">igunakan untuk membaca tabel </span><span style="line-height: 14.95px;">/ range </span><span lang="EN-US" style="line-height: 14.95px;">secara <span style="color: #009a46;">vertikal</span> (VLOOKUP)</span><span style="line-height: 14.95px;">,</span><span style="line-height: 14.95px;"><span lang="EN-US">penulisanya :<br />=VLOOKUP(lookup_value,table_array,row_index_num,…)</span></span><span style="line-height: 14.95px;"><o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="line-height: 14.95px;">29.<span style="line-height: normal;"> </span></span><span style="line-height: 14.95px;">Fungsi / Function COUNTIF :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit; line-height: 14.95px;">digunakan untuk <span style="color: #009a46;">menghitung jumlah cell dalam suatu range</span> dengan ciri-ciri / kriteria tertentu. Penulisannya : =COUNTIF(range;kriteria).<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit; line-height: 14.95px;">Misal : menghitung jumlah siswa yang tidak lulus ujian /remidi. =COUNTIF(D1:D45;”remidi”) maka dari contoh tadi keterangan siswa berada di range D1 sampai D45 dimana keterangannya remidi. Jadi, hasilnya adalah total siswa yang remidi.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="line-height: 14.95px;">30.<span style="line-height: normal;"> </span></span><span style="line-height: 14.95px;">Fungsi AND :<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit; line-height: 14.95px;">Fungsi AND menghasilkan nilai <b>TRUE</b> jika semua argument yang di uji bernilai BENAR<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit; line-height: 14.95px;">dan akan bernilai <b>FALSE</b> jika semua atau salah satu argument bernilai SALAH. Penulisan pada gambar ini.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-family: inherit; line-height: 14.95px;">Misal : Peserta ujian dinyatakan lulus jika nilai ujian teori dan praktik masing-masing harus di atas 7, jika kurang dari 7 maka dinyatakan gagal.</span></div>
<div class="separator" style="clear: both; color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; text-align: center;">
<a href="http://ilmuonline.net/wp-content/uploads/2013/02/rumus-if-dan-and.jpg" imageanchor="1" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(187, 187, 187); border-bottom-style: dotted; border-bottom-width: 1px; color: #333333; margin: 0px 1em; padding: 0px; text-decoration: none; vertical-align: baseline;"><img border="0" height="91" src="http://ilmuonline.net/wp-content/uploads/2013/02/rumus-if-dan-and.jpg" style="background: none 0px 0px repeat scroll rgb(248, 247, 241); border: 1px solid rgb(255, 255, 255); box-shadow: rgb(221, 221, 221) 0px 0px 5px 2px; max-width: 99%; padding: 10px;" width="400" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt; text-indent: -21.3pt;">
<span style="font-family: inherit;"><span style="font-size: 12pt; line-height: 18.4px;">31.<span style="font-size: 7pt; line-height: normal;"> </span></span><span style="font-size: 12pt; line-height: 18.4px;">Fungsi NOT :</span><span style="font-size: 12pt; line-height: 18.4px;"><o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-size: 12pt; line-height: 18.4px;">Fungsi not kebalikan dari fungsi AND, yakni menghasilkan TRUE jika kondisi yang di uji SALAH dan FALSE jika kondisi yang di uji BENAR<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-size: 12pt; line-height: 18.4px;">Penulisan : =NOT(argument)<o:p></o:p></span></div>
<div class="separator" style="clear: both; color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; text-align: center;">
<a href="http://ilmuonline.net/wp-content/uploads/2013/02/rumus-not-pada-excel.jpg" imageanchor="1" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(187, 187, 187); border-bottom-style: dotted; border-bottom-width: 1px; color: #333333; margin: 0px 1em; padding: 0px; text-decoration: none; vertical-align: baseline;"><img border="0" height="153" src="http://ilmuonline.net/wp-content/uploads/2013/02/rumus-not-pada-excel.jpg" style="background: none 0px 0px repeat scroll rgb(248, 247, 241); border: 1px solid rgb(255, 255, 255); box-shadow: rgb(221, 221, 221) 0px 0px 5px 2px; max-width: 99%; padding: 10px;" width="400" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
<span style="font-size: 12pt; line-height: 18.4px;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm 0cm 0cm 21.3pt;">
</div>
<div class="MsoListParagraph" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm; text-align: justify;">
<span style="font-size: 12pt; line-height: 18.4px;"><br /></span></div>
<div class="MsoListParagraph" style="color: #333333; font-family: Georgia, serif; font-size: 13px; line-height: 20px; margin: 0cm; text-align: justify;">
<br /></div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/14257961015093176403noreply@blogger.com0