tag:blogger.com,1999:blog-40027108083266497232024-02-06T19:31:24.759-08:00Belajar Membuat ExcelMembuat Pekerjaan dengan ExcelPak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4002710808326649723.post-15673133375175414302013-07-14T08:36:00.000-07:002013-07-14T08:36:09.325-07:00Cara Mencetak Heading Kolom Dan Baris di Ms ExcelApabila kita akan mencetak heading kolom (A, B, dan seterusnya) dan heading baris (1, 2, dan seterusnya).<br /><br /><b>Caranya: </b><br />1. Untuk : <br /> Excel 2003 – Pada menu File, pilih Page Setup dan klik tab Sheet. <br /> Excel 2007 – Pada Page Layout tab, Page Setup group, klik Print Titles dan pilih tab Sheet. <br />2. Pada bagian Print, centang kotak Row and column headings.<br />3. Klik OK.Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-11913906814335653962013-07-14T08:26:00.000-07:002013-07-14T08:26:11.028-07:00Fungsi Statistik Dasar di Ms ExcelBerikut adalah beberapa Fungsi Statistik Dasar di Ms Excel<br />1. Sum berfungsi untuk menjumlahkan isi sebuah Range.<br /><i>=SUM(range)</i><br />2. Average berfungsi untuk mendapatkan rata-rata Range.<br /><i>=Average(range)</i><br />3. Max berfungsi untuk mendapatkan nilai terbesar dari sebuah Range.<br /><i>=Max(range)</i><br />4. Min berfungsi untuk mendapatkan nilai terkecil dari sebuah Range.<br /><i>=Min(range)</i><br />5. Count berfungsi untuk menghitung jumlah data dari sebuah Range.<br /><i>=Count(range)</i>Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-38594941492047720792013-07-14T08:09:00.001-07:002013-07-14T08:09:10.953-07:00Fungsi Submenu File di Ms Excel<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 8.0pt; mso-bidi-font-style: italic;">Berikut
Fungsi submenu File di Ms Excel</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif";">Submenu File </span></b></div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif";">Fungsi</span></b></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">New </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Membuka dokumen atau lembar
kerja yang baru yang masih kosong.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Open </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Membuka file atau dokumen yang
telah disimpan.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Close </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Menutup dokumen.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Save </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Menyimpan dokumen ke hard disk
atau disket.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 5;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Save As </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Menyimpan dokumen dengan nama
lain atau format lain.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 6;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Save as Web Page </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Menyimpan dalam format web
page.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 7;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">File Search </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Mencari teks tertentu dalam
file di dokumen.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 8;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Permission </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Menentukan sifat kerahasiaan
dokumen.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 9;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Web Page Preview </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Melihat tampilan dokumen dalam
format Web Page.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 10;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Page Setup </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Mengatur tampilan halaman yang
akan dicetak.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 11;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Print Area </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Memilih area pada lembar kerja
yang akan dicetak.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 12;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Print Preview </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Melihat tampilan dari dokumen
yang akan dicetak.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 13;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Print </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Mencetak dokumen dan mengatur
printer.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 14;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Send To </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif";">Mengirim dokumen melalui
E-mail.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 15; mso-yfti-lastrow: yes;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Times New Roman","serif";">Exit </span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Times New Roman","serif";">Menutup program
Microsoft Excel.</span></div>
</td>
</tr>
</tbody></table>
Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-38344199494070752242013-07-05T10:44:00.003-07:002013-07-05T10:45:59.738-07:00Menentukan Lulus atau Gagal<div class="MsoNormal">
<div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;">
<img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDdzGe7Qn5YQUt9SvvOJiw4e10Cz60jXPRg9qkdOrqwyX9vWtER_aOUojqZYFN74cEpscAruXTr6koXRC3oUFDk1Z65Ac5UQer2bjl8Y3Pa62-Zu9Ft0K-ewdcj2EDD-XMN0RrV_JoQLoC/s200/LOGO+X.jpg" width="200" /></div>
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">Menentukan Lulus atau Gagal dapat
dilakukan dengan mudah menggunakan Ms Excel, seperti contoh berikut :</span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">Peserta ujian dinyatakan lulus jika
ujian praktik lebih dari 7, jika kurang gagal</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: -1.5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 632px;">
<tbody>
<tr style="height: 12.75pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: #F2F2F2; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">A</span></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" width="60"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">B</span></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">C</span></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">D</span></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">E</span></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">F</span></div>
</td>
<td nowrap="" style="background: #F2F2F2; border-left: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">G</span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 1;">
<td style="background: #F2F2F2; border-top: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">1</span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">NO</span></span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt; width: 44.65pt;" valign="bottom" width="60"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">NAMA</span></span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">TEORI</span></span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">PRAKTEK</span></span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">NILAI</span></span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">N HRF</span></span></div>
</td>
<td nowrap="" style="background-attachment: scroll; background-clip: border-box; background-image: none; background-origin: padding-box; background-position: 0% 0%; background-repeat: repeat; background-size: auto auto; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; height: 12.75pt; padding: 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background-color: white;"><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">HASIL</span></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 2;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" valign="bottom" width="60"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">AGUS</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">B</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">LULUS</span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 3;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" valign="bottom" width="60"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">DEWI</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">A</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">LULUS</span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 4;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" valign="bottom" width="60"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">CUCU</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">C</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">LULUS</span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 5;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" valign="bottom" width="60"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">CECE</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">6</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">D</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">GAGAL</span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 6;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">6</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" width="60"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">COI</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">A</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">`=IF(AND(C8>=7,D8>=7),"LULUS","GAGAL")</span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 7;">
<td style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt; width: 44.65pt;" valign="bottom" width="60"><br /></td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes;">
<td style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
<td colspan="5" nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.35pt;" valign="bottom" width="294"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">`=IF(AND(C8>=7,D8>=7),"LULUS","GAGAL")</span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0in 5.4pt 0in 5.4pt;" valign="bottom"><br /></td>
</tr>
</tbody></table>
Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-9852793564062846322013-06-16T12:32:00.000-07:002013-07-05T10:47:35.144-07:00FUNGSI REPLACE<br />
<div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKIPcZJGC2w11le0PVTpwv6L1US3I9nmEhoPDY9isGGSDhGP4lMoTMsc1vUBT1_eHRwO7Nhyphenhyphen5tKE8poiG77osYf3pNv3mjSuRaGIRGN_8KG-n8U3yKiVCuKc-8RCsEh1voDbRv0kbkzm1/s1600/LOGO+X.jpg" /></div>
<br />
<b><span style="color: blue; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"><span style="color: black;">FUNGSI REPLACE UNTUK</span><span style="mso-tab-count: 1;"><span style="color: black;"> </span> </span></span></b><b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">MENGGANTI KARAKTER TERTENTU PADA TEKS, MULAI DARI POSISI
TERTENTU.</span></b>
<br />
<div class="MsoNormal">
<br /></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: -.25pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 511px;">
<tbody>
<tr style="height: 21.75pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: black; border: solid silver 1.0pt; height: 21.75pt; mso-border-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 143.95pt;" width="192"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">DATA</span></b></div>
</td>
<td style="background: black; border-bottom: none; border-left: none; border-right: solid silver 1.0pt; border-top: solid silver 1.0pt; height: 21.75pt; mso-border-right-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 119.0pt;" width="159"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">HASIL</span></b></div>
</td>
<td style="background: black; height: 21.75pt; padding: 0in 5.4pt 0in 5.4pt; width: 120.5pt;" width="161"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"><span style="color: white;">PENULISAN FUNGSI</span></span></b></div>
</td>
</tr>
<tr style="height: 16.5pt; mso-yfti-irow: 1;">
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: solid silver 1.0pt; border-right: none; border-top: none; height: 16.5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 143.95pt;" width="192"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Joko
Susilo</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border: solid red 1.0pt; height: 16.5pt; mso-border-alt: solid red .5pt; mso-border-bottom-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 119.0pt;" width="159"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">0oko
Susilo</span></div>
</td>
<td nowrap="" style="background: white; border-left: none; border: solid silver 1.0pt; height: 16.5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 120.5pt;" width="161"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">=REPLACE(C6,1,1,"O")</span></div>
</td>
</tr>
<tr style="height: 16.5pt; mso-yfti-irow: 2; mso-yfti-lastrow: yes;">
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: solid silver 1.0pt; border-right: none; border-top: none; height: 16.5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 143.95pt;" width="192"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Aku
Aminah</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: solid red 1.0pt; border-right: solid red 1.0pt; border-top: none; height: 16.5pt; mso-border-alt: solid red .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-top-alt: solid red .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 119.0pt;" width="159"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Uu
Aminah</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; height: 16.5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 120.5pt;" width="161"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">=REPLACE(C7,1,2,"O")</span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="color: blue; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"><span style="mso-tab-count: 1;"> </span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in; tab-stops: 195.4pt 314.4pt;">
<b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">BENTUK PENULISAN FUNGSI :<span style="mso-tab-count: 1;"> </span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span> </span></div>
<b><span style="color: blue; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"> <span style="mso-tab-count: 1;"> <span style="color: red;"> </span></span><span style="color: red;">=REPLACE(X,Y1,Y2,Z)</span></span></b>Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-1051688058688659552013-05-23T15:55:00.001-07:002013-05-23T15:58:35.577-07:00FUNGSI PROPER<br />
<div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;">
<a href="http://membuatexcel.blogspot.com/"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKIPcZJGC2w11le0PVTpwv6L1US3I9nmEhoPDY9isGGSDhGP4lMoTMsc1vUBT1_eHRwO7Nhyphenhyphen5tKE8poiG77osYf3pNv3mjSuRaGIRGN_8KG-n8U3yKiVCuKc-8RCsEh1voDbRv0kbkzm1/s1600/LOGO+X.jpg" /></a></div>
<br />
<b><span style="color: black; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman"; mso-themecolor: text1;">Fungsi Proper : Fungsi ini digunakan </span></b><b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">mengubah karakter pertama pada setiap kata menjadi huruf
kapital.<span style="mso-spacerun: yes;"> </span></span></b><br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in;">
<b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;">Contoh penggunaan Fungsi Proper adalah : </span></span></b>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in;">
<b><span style="color: blue; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span> </span></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none; margin-left: -.25pt; mso-border-alt: solid windowtext .5pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 533px;">
<tbody>
<tr style="height: 21.75pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: black; border: solid windowtext 1.0pt; height: 21.75pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 152.0pt;" width="203"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">DATA</span></b></div>
</td>
<td style="background: black; border-left: none; border: solid windowtext 1.0pt; height: 21.75pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" width="184"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">HASIL</span></b></div>
</td>
<td style="background: black; border-left: none; border: solid windowtext 1.0pt; height: 21.75pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 110.0pt;" width="147"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">PENULISAN FUNGSI</span></b></div>
</td>
</tr>
<tr style="height: 16.5pt; mso-yfti-irow: 1;">
<td nowrap="" style="background: white; border-top: none; border: solid windowtext 1.0pt; height: 16.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 152.0pt;" width="203"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">AGUS
WICAKSANA</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 16.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" width="184"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Agus
Wicaksana</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 16.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 110.0pt;" width="147"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">=PROPER(C6)</span></div>
</td>
</tr>
<tr style="height: 16.5pt; mso-yfti-irow: 2; mso-yfti-lastrow: yes;">
<td nowrap="" style="background: white; border-top: none; border: solid windowtext 1.0pt; height: 16.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 152.0pt;" width="203"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">ANDRI
ASMARA</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 16.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" width="184"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Andri
Asmara</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 16.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 110.0pt;" width="147"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">=PROPER(C7)</span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in;">
<b><span style="color: blue; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in;">
<b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">BENTUK PENULISAN FUNGSI :<span style="mso-tab-count: 1;"> </span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <b><span style="color: blue;">=PROPER(X)<span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span></span></b> </span></div>
<div class="MsoNormal">
<br /></div>
Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-10120408941654742312013-05-23T15:23:00.001-07:002013-05-23T15:34:19.507-07:00FUNGSI UPPER<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in; tab-stops: 225.4pt 363.4pt;">
<div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKIPcZJGC2w11le0PVTpwv6L1US3I9nmEhoPDY9isGGSDhGP4lMoTMsc1vUBT1_eHRwO7Nhyphenhyphen5tKE8poiG77osYf3pNv3mjSuRaGIRGN_8KG-n8U3yKiVCuKc-8RCsEh1voDbRv0kbkzm1/s1600/LOGO+X.jpg" /></div>
<span style="color: black; font-family: "Arial","sans-serif"; font-size: 12.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-themecolor: text1;">FUNGSI UPPER,Fungsi
ini <span style="mso-tab-count: 1;"> </span>mengubah semua karakter dalam suatu
teks menjadi huruf kapital (uppercase).</span></div>
<div class="MsoNormal">
Penggunaan Fungsi Upper seperti contoh berikut :</div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: -.75pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 519px;">
<tbody>
<tr style="height: 12.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: black; border: solid silver 1.0pt; height: 12.0pt; mso-border-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 126.25pt;" width="168"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">DATA</span></b></div>
</td>
<td style="background: black; border-bottom: none; border-left: none; border-right: solid silver 1.0pt; border-top: solid silver 1.0pt; height: 12.0pt; mso-border-right-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" width="184"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">HASIL</span></b></div>
</td>
<td style="background: black; height: 12.0pt; padding: 0in 5.4pt 0in 5.4pt; width: 125.0pt;" width="167"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="color: white; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">PENULISAN FUNGSI</span></b></div>
</td>
</tr>
<tr style="height: 12.0pt; mso-yfti-irow: 1;">
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: solid silver 1.0pt; border-right: none; border-top: none; height: 12.0pt; mso-border-bottom-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 126.25pt;" width="168"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">agus
wicaksana</span></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border: solid red 1.0pt; height: 12.0pt; mso-border-alt: solid red .5pt; mso-border-bottom-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" width="184"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">AGUS WICAKSANA</span></div>
</td>
<td nowrap="" style="background: white; border-left: none; border: solid silver 1.0pt; height: 12.0pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 125.0pt;" width="167"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">=UPPER(C6)</span></div>
</td>
</tr>
<tr style="height: 12.0pt; mso-yfti-irow: 2;">
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: solid silver 1.0pt; border-right: none; border-top: none; height: 12.0pt; mso-border-bottom-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 126.25pt;" width="168"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<br /></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: solid red 1.0pt; border-right: solid red 1.0pt; border-top: none; height: 12.0pt; mso-border-bottom-alt: solid silver .5pt; mso-border-left-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" width="184"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
<td nowrap="" style="background: white; border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; height: 12.0pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 125.0pt;" width="167"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-char-indent-count: 1.0; text-indent: 9.0pt;">
<br /></div>
</td>
</tr>
<tr style="height: 12.0pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes;">
<td nowrap="" style="background: white; height: 12.0pt; padding: 0in 5.4pt 0in 5.4pt; width: 126.25pt;" valign="bottom" width="168"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
<td nowrap="" style="background: white; height: 12.0pt; padding: 0in 5.4pt 0in 5.4pt; width: 138.0pt;" valign="bottom" width="184"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
<td nowrap="" style="background: white; height: 12.0pt; padding: 0in 5.4pt 0in 5.4pt; width: 125.0pt;" valign="bottom" width="167"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 56.8pt 225.4pt 363.4pt;">
<b><span style="color: blue; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"><span style="mso-tab-count: 1;"> </span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> <span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 5.4pt; margin-right: 0in; margin-top: 0in; tab-stops: 225.4pt 363.4pt;">
<b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">BENTUK PENULISAN FUNGSI : <span style="color: blue;">=UPPER(X)<span style="mso-tab-count: 1;"> </span> <span style="mso-tab-count: 1;"> </span></span></span></b><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";"> </span></div>
<div class="MsoNormal">
<div style="text-align: left;">
</div>
<br /></div>
Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-85457485884507190532013-05-18T18:28:00.003-07:002013-05-23T15:32:01.082-07:00Cara Merubah Huruf Menjadi Kecil<br />
<div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKIPcZJGC2w11le0PVTpwv6L1US3I9nmEhoPDY9isGGSDhGP4lMoTMsc1vUBT1_eHRwO7Nhyphenhyphen5tKE8poiG77osYf3pNv3mjSuRaGIRGN_8KG-n8U3yKiVCuKc-8RCsEh1voDbRv0kbkzm1/s1600/LOGO+X.jpg" /></div>
<br />
Cara membuat huruf di cell Ms Excel menjadi kecil semua. Fungsi yang bisa dimanfaatkan untuk merubah huruf Besar menjadi Kecil adalah Fungsi Lower. Bagaimana cara menggunakan fungsi Lower ini? Berikut contohnya :
<iframe frameborder="0" height="400" src="https://docs.google.com/spreadsheet/pub?key=0AvYKGh86CwfndEc5WkVPZ0lnenZCczZaTXJfMElBWFE&single=true&gid=0&output=html&widget=true" width="550"></iframe>Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0tag:blogger.com,1999:blog-4002710808326649723.post-82282774121342803112013-05-18T17:19:00.003-07:002013-05-23T15:59:24.673-07:00Fungsi LEN, Menghitung Jumlah Karakter di Cell Excel<br />
<div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigKIPcZJGC2w11le0PVTpwv6L1US3I9nmEhoPDY9isGGSDhGP4lMoTMsc1vUBT1_eHRwO7Nhyphenhyphen5tKE8poiG77osYf3pNv3mjSuRaGIRGN_8KG-n8U3yKiVCuKc-8RCsEh1voDbRv0kbkzm1/s1600/LOGO+X.jpg" /></div>
<br />
Fungsi LEN pada Ms Office Excel dapat kita gunakan untuk menghitung jumlah karakter di sebuah cell.<br />
Contoh penggunaan fungsi LEN seperti contoh berkut ini:
<iframe frameborder="0" height="300" src="https://docs.google.com/spreadsheet/pub?key=0AvYKGh86CwfndGhCOE5yVVhPUl9OM0ZQcVFYOWdUa3c&single=true&gid=0&output=html&widget=true" width="550"></iframe>
Pak Guruhttp://www.blogger.com/profile/07157774025606995440noreply@blogger.com0