v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#ieooui) }
<!– /* Font Definitions */ @font-face {font-family:”Angsana New”; panose-1:2 2 6 3 5 4 5 2 3 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:16777219 0 0 0 65537 0;} @font-face {font-family:”Calisto MT”; mso-font-alt:”Book Antiqua”; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:”Book Antiqua”; panose-1:2 4 6 2 5 3 5 3 3 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:647 0 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:””; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} h1 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:1; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-font-kerning:0pt; mso-bidi-language:AR-SA; font-weight:normal;} h3 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:3; font-size:14.0pt; mso-bidi-font-size:10.0pt; font-family:”Calisto MT”; mso-bidi-language:AR-SA; mso-bidi-font-weight:normal; font-style:italic; mso-bidi-font-style:normal;} h4 {mso-style-next:Normal; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:18.0pt; margin-bottom:.0001pt; text-indent:-18.0pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:4; mso-list:l16 level1 lfo1; tab-stops:list 18.0pt; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-bidi-language:AR-SA; mso-bidi-font-weight:normal;} h5 {mso-style-next:Normal; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:21.3pt; margin-bottom:.0001pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:5; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-bidi-language:AR-SA; font-weight:normal;} h6 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:6; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-bidi-language:AR-SA; font-weight:normal;} p.MsoHeading7, li.MsoHeading7, div.MsoHeading7 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:7; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA; font-weight:bold; mso-bidi-font-weight:normal;} p.MsoHeader, li.MsoHeader, div.MsoHeader {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; tab-stops:center 216.0pt right 432.0pt; font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} p.MsoBodyText2, li.MsoBodyText2, div.MsoBodyText2 {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Book Antiqua”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:35085151; mso-list-type:simple; mso-list-template-ids:371361932;} @list l0:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l1 {mso-list-id:52433589; mso-list-type:simple; mso-list-template-ids:-579428720;} @list l1:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l2 {mso-list-id:56783516; mso-list-type:simple; mso-list-template-ids:834968836;} @list l2:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l3 {mso-list-id:216403345; mso-list-type:simple; mso-list-template-ids:983597792;} @list l3:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l4 {mso-list-id:233707199; mso-list-type:simple; mso-list-template-ids:-1088227666;} @list l4:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l5 {mso-list-id:256717472; mso-list-type:simple; mso-list-template-ids:-1595237518;} @list l5:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l6 {mso-list-id:278148935; mso-list-type:simple; mso-list-template-ids:-1165452972;} @list l6:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l7 {mso-list-id:361175859; mso-list-type:simple; mso-list-template-ids:799814104;} @list l7:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l8 {mso-list-id:361715105; mso-list-type:simple; mso-list-template-ids:1887852714;} @list l8:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l9 {mso-list-id:402794470; mso-list-type:simple; mso-list-template-ids:-1381217970;} @list l9:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l10 {mso-list-id:468090083; mso-list-type:simple; mso-list-template-ids:-1397966684;} @list l10:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l11 {mso-list-id:487593401; mso-list-type:simple; mso-list-template-ids:-115578058;} @list l11:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l12 {mso-list-id:492332495; mso-list-type:simple; mso-list-template-ids:52051118;} @list l12:level1 {mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l13 {mso-list-id:644697810; mso-list-type:simple; mso-list-template-ids:970496472;} @list l13:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l14 {mso-list-id:670765248; mso-list-type:simple; mso-list-template-ids:67698709;} @list l14:level1 {mso-level-number-format:alpha-upper; mso-level-tab-stop:18.0pt; mso-level-number-position:left; margin-left:18.0pt; text-indent:-18.0pt;} @list l15 {mso-list-id:671103220; mso-list-type:simple; mso-list-template-ids:1423843930;} @list l15:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l16 {mso-list-id:815101085; mso-list-type:simple; mso-list-template-ids:886623932;} @list l16:level1 {mso-level-number-format:alpha-upper; mso-level-style-link:”Heading 4″; mso-level-tab-stop:18.0pt; mso-level-number-position:left; margin-left:18.0pt; text-indent:-18.0pt;} @list l17 {mso-list-id:874005160; mso-list-type:simple; mso-list-template-ids:-731761424;} @list l17:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l18 {mso-list-id:904803929; mso-list-type:simple; mso-list-template-ids:2081869642;} @list l18:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l19 {mso-list-id:948008746; mso-list-type:simple; mso-list-template-ids:-1120744006;} @list l19:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l20 {mso-list-id:967323292; mso-list-type:simple; mso-list-template-ids:-872904690;} @list l20:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l21 {mso-list-id:1066955958; mso-list-type:simple; mso-list-template-ids:1862170292;} @list l21:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l22 {mso-list-id:1098135455; mso-list-type:simple; mso-list-template-ids:90605400;} @list l22:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l23 {mso-list-id:1170027574; mso-list-type:simple; mso-list-template-ids:2053282134;} @list l23:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l24 {mso-list-id:1280331536; mso-list-type:simple; mso-list-template-ids:-1312378896;} @list l24:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l25 {mso-list-id:1338969097; mso-list-type:simple; mso-list-template-ids:-932125682;} @list l25:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l26 {mso-list-id:1385906487; mso-list-type:simple; mso-list-template-ids:417617052;} @list l26:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l27 {mso-list-id:1451238987; mso-list-type:simple; mso-list-template-ids:-1407674364;} @list l27:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l28 {mso-list-id:1556889111; mso-list-type:simple; mso-list-template-ids:1478815418;} @list l28:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l29 {mso-list-id:1627540121; mso-list-type:simple; mso-list-template-ids:201605670;} @list l29:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l30 {mso-list-id:1702978121; mso-list-type:simple; mso-list-template-ids:-1530082656;} @list l30:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l31 {mso-list-id:1802183589; mso-list-type:simple; mso-list-template-ids:1690336700;} @list l31:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l32 {mso-list-id:1899197430; mso-list-type:simple; mso-list-template-ids:-913298620;} @list l32:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l33 {mso-list-id:1905021555; mso-list-type:simple; mso-list-template-ids:-2118112758;} @list l33:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l34 {mso-list-id:1938827677; mso-list-type:simple; mso-list-template-ids:1738436224;} @list l34:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l35 {mso-list-id:1959067771; mso-list-type:simple; mso-list-template-ids:1407204852;} @list l35:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l36 {mso-list-id:1973291233; mso-list-type:simple; mso-list-template-ids:2137297724;} @list l36:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l37 {mso-list-id:2043480454; mso-list-type:simple; mso-list-template-ids:833812174;} @list l37:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l38 {mso-list-id:2053728868; mso-list-type:simple; mso-list-template-ids:-2052966310;} @list l38:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l39 {mso-list-id:2133017251; mso-list-type:simple; mso-list-template-ids:1967398252;} @list l39:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} –>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
FUNGSI
MICROSOFT EXCEL
Fungsi adalah turunan perintah yang berguna untuk melengkapi, mengoptimalkan serta lebih memberdayakan perintah Microsoft Excel yang telah ada.
Pada dasarnya Fungsi adalah data yang bertype Formula atau Rumus, akan tetapi lebih komplek dan memiliki kegunaan tertentu.
A. FUNGSI STATISTIKA
- Count
a. Kegunaannya adalah untuk menghitung jumlah sel yang ada ( baik Numeric, Formula / Rumus ataupun Label )
b. Syntax / Perintah baku adalah =Count ( Range )
- Counta
a. Kegunaannya adalah untuk menghitung jumlah sel yang mengandung data Numeric dan Label
b. Syntax / Perintah baku adalah = Counta ( Range )
- CountBlank
a. Kegunaannya adalah untuk menghitung jumlah sel yang kosong
b. Syntax / Perintah baku adalah = CountBlank ( Range )
- CountIf
a. Kegunaannya adalah untuk menghitung jumlah sel dengan aturan tertentuSyntax / Perintah baku adalah = CountIf ( Range )
|
- Sum
a. Kegunaannya adalah untuk menjumlah beberapa sel / Menjumlah Range
b. Syntax / Perintah baku adalah =Sum (Range )
- Average
a. Kegunaannya adalah untuk menentukan nilai rata – rata pada beberapa sel yang ditunjuk
b. Syntax / Perintah baku adalah = Average ( Range )
- Max
a. Kegunaannya adalah untuk menentukan nilai tertinggi pada suatu Range yang di seleksi
b. Syntax / Perintah baku adalah = Max ( Range )
- Min
a. Kegunaannya adalah untuk menentukan nilai terendah pada suatu Range yang sudah diseleksi
b. Syntax / Perintah baku adalah = Min ( range )
|
B. FUNGSI MATEMATIKA
- Abs
a. Kegunaannya adalah untuk menentukan nilai absolut dari data yang dimasukkan. Yaitu nilai yang selalu berbentu positif.
b. Syntax / perintah baku adalah = Abs( Nilai )
- Int
a. Kegunaannya adalah untuk memberikan nilai Integral dari data yang dimasukkan. Yaitu nilai yang membuang seluruh nilai desimal
b. Syntax / Perintah baku adalah = Int ( Nilai )
- Mod
a. kegunaannya adalah untuk memberikan nilai sisa bagi dari dua buah nilai yang dimasukkan
b. Syntax / Perintah baku adalah = Mod ( Nilai, Pembagi )
Untuk lebih cermatnya coba perhatikan gambar dibawah ini :
- Round
a. Kegunaannya adalah untuk memberikan nilai pembulatan dari sebuah nilai ke dalam jumlah desimal tertentu.
b. Syntax / Perintah baku adalah = Round ( Nilai, Jumlah Desimal )
- Sqrt
a. Kegunaannya adalah untk memberikan nilai akar pangkat dua dari suatu nilai
b. Syntax / Perintah baku adalah = Sqrt ( Nilai )
|
- Degrees
a. Kegunaannya adalah untuk mengubah atau mengkonversi nilai Radian ke nilai sudut
b. Syntax / Perintah baku adalah = Degrees (Nilai Sudut)
- Radians
a. Kegunaannya adalah untuk mengubah atau mengkonversi nilai sudut ke nilai Radians
b. Syntax / Perintah baku adalah = Radians(Nilai Sudut)
- Log
a. Kegunaannya adalah untuk mencari logaritma sebuah nilai dengan nilai dasar tertentu. Jika nilai dasar tidak diberikan, maka nilai dasar dianggap 10.
b. Syntax / Perintah baku adalah = Log ( Nilai, Nilai Dasar )
- Pi
a. Kegunaanny adalah untuk memberikan nilai bilangan Pi, yaitu Pi=3,14
b. Syntax / Perintah baku adalah =Pi()
- Sin
a. Kegunaannya adalah untuk memberikan nilai Sinus dari suatu sudut
b. Syntax / Perintah baku adalah = Sin(Nilai Sudut)
- Cos
a. Kegunaannya adalah untuk memberikan nilai Cosinus dari suatu sudut
b. Syntax / Perintah baku adalah = Coc(Nilai Sudut)
- Tan
a. Kegunaannya adalah untuk memberikan nilai Tangens dari suatu sudut
b. Syntax / Perintah baku adalah = Tan(Nilai Sudut)
|
C. FUNGSI LABEL
Masukan dari Fungsi Label adalah seluruh data yang mempunyai nilai hasil ( Return Value ) berupa huruf atau label.
- Len
a. Kegunaannya adalah untuk menghitung panjang suatu Teks
b. Syntax / Perintah baku adalah =Len(teks)
- Left
a. Kegunaannya adalah untuk mengambil huruf sejumlah nilai yang dimasukkan dihitung mulai dari kiri
b. Syntax / Perintah baku adalah = Left (Teks, Nilai )
- Right
a. Kegunaannya adalah untuk mengambuil huruf sejumlah nilai yang dimasukkan dihitung mulai dari kanan
b. Syntax / Perintah baku adalah = Right ( Teks, Nilai )
- Mid
a. Kegunaannya adalah untuk mengambil huruf sejumlah nilai – nilai yang dimasukkan dihitung mulai dari huruf ke nilai1
b. Syntax / Perintah baku adalah = Mid ( Teks, Nilai1, Nilai2 )
Contoh dan hasilnya :
A |
B |
C |
D |
1 |
Teks |
Fungsi |
Hasil |
2 |
Wike Wijayanti |
=Len(B2) |
14 |
3 |
Novi Mariana |
=Len(B3) |
12 |
4 |
Angga Ferdyan |
=Left(B4,4) |
Angg |
5 |
Ririn Asriyanti |
=Left(B5,7) |
Ririn A |
6 |
Ucik Dini Wahyuni |
=Right(B6,7) |
Wahyuni |
7 |
Efa Kiki Afdiyan |
=Right(B7,4) |
Iyan |
8 |
Bagus Rahmad. H |
=Mid (C8,3,4) |
Gus |
9 |
Dodik Harianto |
=Mid(C9,2,6) |
Odik H |
|
|
|
|
- Upper
a. Kegunaannya adalah untuk merubah Teks menjadi huruf besar
b. Syntax / Perintah baku adalah = Upper (Teks)
- Lower
a. Kegunaannya adalah untuk merubah Teks menjadi huruf kecil
b. Syntax / perintah baku adalah = Lower (Teks)
7. Proper
a. Kegunaannya adalah untuk merubah huruf dalam Teks setiap awal kata menjadi huruf besar kapital dan sisanya huruf kecil
b. Syntax / perintah baku adalah = Proper (Teks)
Contoh dan hasilnya :
A |
B |
C |
D |
1 |
Teks |
Fungsi |
Hasil |
2 |
Wike Wijayanti |
=Upper(B2) |
WIKE WIJAYANTI |
3 |
Novi Mariana |
=Upper(B3) |
NOVI MARIANA |
4 |
Angga ferdyan |
=Lower(B4) |
angga ferdyan |
5 |
Dodik Harianto |
=Lower(B5) |
dodik harianto |
6 |
ucik dini wahyuni |
=Proper(B6) |
Ucik Dini Wahyuni |
7 |
BAGUS RAHMAD |
=Proper(B6) |
Bagus Rahmad |
D. FUNGSI LOGIKA
- Or
a. Kegunaannya adalah menggabungkan dua atau lebih kondisi, Ekspresi atau perintah yang tidak saling berhubungan. Fungsi ini akan bernilai False ( salah ) bila seluruh Ekspresi tidak dipenuhi.
b. Syntax / Perintah baku adalah = Or(Ekspresi1, Ekspresi2, ……….)
- And
a. Kegunaannya adalah untuk menggabungkan dua atau lebih kondisi, Ekspresi atau perintah yang saling berhubungan
b. Syntax / Perintah baku adalah =And(Ekspresi1, Ekspresi2, …………)
- Not
a. Kegunaannya adalah untuk mencari nilai kebalikan dari suatu ekspresi yang dimasukkan
b. Syntax / Perintah baku adalah =Not( Ekspresi)
Contoh dan hasilnya :
|
A |
B |
1 |
Fungsi |
Hasil |
2 |
=Or(TRUE,TRUE) |
TRUE |
3 |
=OR(FALSE,TRUE) |
TRUE |
4 |
=AND(TRUE,TRUE) |
TRUE |
5 |
=AND(TRUE,FALSE) |
FALSE |
6 |
=NOT(FALSE) |
TRUE |
7 |
=NOT(TRUE) |
FALSE |
- If
a. Kegunaannya adalah untuk memilih dan menentukan Ekspresi yang harus dijalankan dari kondisi yang diberikan.
b. Syntax / Perintah baku adalah =If(Kondisi, Ekspresi Benar, Ekspresi Salah )
- Vlook Up
a. Kegunaannya adalah untuk menampilkan data dari tabel berdasarkan kunci yang diberikan secara menurun ( vertikal ) menurut kolom yang ditentukan.
b. Syntax / Perintah baku adalah =Vlookup (Kunci, Tabel, Kolom)
- Hlookup
a. Kegunaannya adalah untuk menampilkan data dari tabel berdasarkan kunci yang diberikan secara mendatar ( Horizontal ) menurut baris yang ditentukan.
b. Syntax / Perintah baku adalah = Hlookup(Kunci,Tabel,Baris)
Contoh Kasus :
|
A |
B |
C |
D |
E |
F |
G |
1 |
Daftar Nilai |
||||||
2 |
No |
Induk |
Kelas |
Program |
N a m a |
Nilai |
Keterangan |
3 |
1 |
2051 |
A |
|
Wike Wijayanti |
70 |
|
4 |
2 |
2052 |
B |
|
Angga Ferdyan |
60 |
|
5 |
3 |
2053 |
A |
|
Ucik Dini Wahyuni |
50 |
|
6 |
4 |
2054 |
B |
|
Robert |
40 |
|
7 |
|
|
|
|
|
|
|
8 |
|
Keterangan |
|
|
|
|
|
9 |
|
A |
MS. Word |
|
|
|
|
10 |
|
B |
MS. Excel |
|
|
|
Penyelesaian :
1. Pada Kolom G3, Ketiklah : =If(f3>=60,”Lulus”,”Gagal”)
2. Gandakan G3 sampai dengan G6
3. Pada Kolom D3, Ketiklah : =Vlookup(C3,$B$9:$C$10,2)
4. Gandakan D3 sampai dengan D6
Hasil yang akan tampil dilayar adalah :
|
A |
B |
C |
D |
E |
F |
G |
1 |
Daftar Nilai |
||||||
2 |
No |
Induk |
Kelas |
Program |
N a m a |
Nilai |
Keterangan |
3 |
1 |
2051 |
A |
MS. Word |
Wike Wijayanti |
70 |
Lulus |
4 |
2 |
2052 |
B |
MS. Excel |
Angga Ferdyan |
60 |
Lulus |
5 |
3 |
2053 |
A |
Ms. Word |
Ucik Dini Wahyuni |
50 |
Gagal |
6 |
4 |
2054 |
B |
MS. Excel |
Robert |
40 |
Gagal |
7 |
|
|
|
|
|
|
|
8 |
|
Keterangan |
|
|
|
|
|
9 |
|
A |
MS. Word |
|
|
|
|
10 |
|
B |
MS. Excel |
|
|
|
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#ieooui) }
<!– /* Font Definitions */ @font-face {font-family:”Angsana New”; panose-1:2 2 6 3 5 4 5 2 3 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:16777219 0 0 0 65537 0;} @font-face {font-family:”Calisto MT”; mso-font-alt:”Book Antiqua”; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:”Book Antiqua”; panose-1:2 4 6 2 5 3 5 3 3 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:647 0 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:””; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} h1 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:1; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-font-kerning:0pt; mso-bidi-language:AR-SA; font-weight:normal;} h3 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:3; font-size:14.0pt; mso-bidi-font-size:10.0pt; font-family:”Calisto MT”; mso-bidi-language:AR-SA; mso-bidi-font-weight:normal; font-style:italic; mso-bidi-font-style:normal;} h4 {mso-style-next:Normal; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:18.0pt; margin-bottom:.0001pt; text-indent:-18.0pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:4; mso-list:l16 level1 lfo1; tab-stops:list 18.0pt; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-bidi-language:AR-SA; mso-bidi-font-weight:normal;} h5 {mso-style-next:Normal; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:21.3pt; margin-bottom:.0001pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:5; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-bidi-language:AR-SA; font-weight:normal;} h6 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:6; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-bidi-language:AR-SA; font-weight:normal;} p.MsoHeading7, li.MsoHeading7, div.MsoHeading7 {mso-style-next:Normal; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:7; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA; font-weight:bold; mso-bidi-font-weight:normal;} p.MsoHeader, li.MsoHeader, div.MsoHeader {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; tab-stops:center 216.0pt right 432.0pt; font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} p.MsoBodyTextIndent, li.MsoBodyTextIndent, div.MsoBodyTextIndent {margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:21.3pt; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} p.MsoBodyText2, li.MsoBodyText2, div.MsoBodyText2 {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; mso-bidi-font-size:10.0pt; font-family:”Book Antiqua”; mso-fareast-font-family:”Times New Roman”; mso-bidi-font-family:”Angsana New”; mso-bidi-language:AR-SA;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:35085151; mso-list-type:simple; mso-list-template-ids:371361932;} @list l0:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l1 {mso-list-id:52433589; mso-list-type:simple; mso-list-template-ids:-579428720;} @list l1:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l2 {mso-list-id:56783516; mso-list-type:simple; mso-list-template-ids:834968836;} @list l2:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l3 {mso-list-id:216403345; mso-list-type:simple; mso-list-template-ids:983597792;} @list l3:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l4 {mso-list-id:233707199; mso-list-type:simple; mso-list-template-ids:-1088227666;} @list l4:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l5 {mso-list-id:256717472; mso-list-type:simple; mso-list-template-ids:-1595237518;} @list l5:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l6 {mso-list-id:278148935; mso-list-type:simple; mso-list-template-ids:-1165452972;} @list l6:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l7 {mso-list-id:361175859; mso-list-type:simple; mso-list-template-ids:799814104;} @list l7:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l8 {mso-list-id:361715105; mso-list-type:simple; mso-list-template-ids:1887852714;} @list l8:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l9 {mso-list-id:402794470; mso-list-type:simple; mso-list-template-ids:-1381217970;} @list l9:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l10 {mso-list-id:468090083; mso-list-type:simple; mso-list-template-ids:-1397966684;} @list l10:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l11 {mso-list-id:487593401; mso-list-type:simple; mso-list-template-ids:-115578058;} @list l11:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l12 {mso-list-id:492332495; mso-list-type:simple; mso-list-template-ids:52051118;} @list l12:level1 {mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l13 {mso-list-id:644697810; mso-list-type:simple; mso-list-template-ids:970496472;} @list l13:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l14 {mso-list-id:670765248; mso-list-type:simple; mso-list-template-ids:67698709;} @list l14:level1 {mso-level-number-format:alpha-upper; mso-level-tab-stop:18.0pt; mso-level-number-position:left; margin-left:18.0pt; text-indent:-18.0pt;} @list l15 {mso-list-id:671103220; mso-list-type:simple; mso-list-template-ids:1423843930;} @list l15:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l16 {mso-list-id:815101085; mso-list-type:simple; mso-list-template-ids:886623932;} @list l16:level1 {mso-level-number-format:alpha-upper; mso-level-style-link:”Heading 4″; mso-level-tab-stop:18.0pt; mso-level-number-position:left; margin-left:18.0pt; text-indent:-18.0pt;} @list l17 {mso-list-id:874005160; mso-list-type:simple; mso-list-template-ids:-731761424;} @list l17:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l18 {mso-list-id:904803929; mso-list-type:simple; mso-list-template-ids:2081869642;} @list l18:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l19 {mso-list-id:948008746; mso-list-type:simple; mso-list-template-ids:-1120744006;} @list l19:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l20 {mso-list-id:967323292; mso-list-type:simple; mso-list-template-ids:-872904690;} @list l20:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l21 {mso-list-id:1066955958; mso-list-type:simple; mso-list-template-ids:1862170292;} @list l21:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l22 {mso-list-id:1098135455; mso-list-type:simple; mso-list-template-ids:90605400;} @list l22:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l23 {mso-list-id:1170027574; mso-list-type:simple; mso-list-template-ids:2053282134;} @list l23:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l24 {mso-list-id:1280331536; mso-list-type:simple; mso-list-template-ids:-1312378896;} @list l24:level1 {mso-level-tab-stop:36.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l25 {mso-list-id:1338969097; mso-list-type:simple; mso-list-template-ids:-932125682;} @list l25:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l26 {mso-list-id:1385906487; mso-list-type:simple; mso-list-template-ids:417617052;} @list l26:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l27 {mso-list-id:1451238987; mso-list-type:simple; mso-list-template-ids:-1407674364;} @list l27:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l28 {mso-list-id:1556889111; mso-list-type:simple; mso-list-template-ids:1478815418;} @list l28:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l29 {mso-list-id:1627540121; mso-list-type:simple; mso-list-template-ids:201605670;} @list l29:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l30 {mso-list-id:1702978121; mso-list-type:simple; mso-list-template-ids:-1530082656;} @list l30:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l31 {mso-list-id:1802183589; mso-list-type:simple; mso-list-template-ids:1690336700;} @list l31:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l32 {mso-list-id:1899197430; mso-list-type:simple; mso-list-template-ids:-913298620;} @list l32:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l33 {mso-list-id:1905021555; mso-list-type:simple; mso-list-template-ids:-2118112758;} @list l33:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l34 {mso-list-id:1938827677; mso-list-type:simple; mso-list-template-ids:1738436224;} @list l34:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l35 {mso-list-id:1959067771; mso-list-type:simple; mso-list-template-ids:1407204852;} @list l35:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l36 {mso-list-id:1973291233; mso-list-type:simple; mso-list-template-ids:2137297724;} @list l36:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l37 {mso-list-id:2043480454; mso-list-type:simple; mso-list-template-ids:833812174;} @list l37:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l38 {mso-list-id:2053728868; mso-list-type:simple; mso-list-template-ids:-2052966310;} @list l38:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} @list l39 {mso-list-id:2133017251; mso-list-type:simple; mso-list-template-ids:1967398252;} @list l39:level1 {mso-level-number-format:alpha-lower; mso-level-tab-stop:54.0pt; mso-level-number-position:left; margin-left:54.0pt; text-indent:-18.0pt;} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} –>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}