{"id":4823,"date":"2014-05-12T17:03:28","date_gmt":"2014-05-12T10:03:28","guid":{"rendered":"http:\/\/webmediacenter.com\/?p=4823"},"modified":"2021-03-05T15:55:39","modified_gmt":"2021-03-05T08:55:39","slug":"mengenal-referensi-sel-microsoft-excel","status":"publish","type":"post","link":"https:\/\/sample.webmediacenter.com\/index.php\/2014\/05\/12\/mengenal-referensi-sel-microsoft-excel\/","title":{"rendered":"Mengenal Referensi Sel di Microsoft Excel | Kursus Komputer"},"content":{"rendered":"<p><a href=\"https:\/\/webmediacenter.com\/mengenal-referen\u2026-microsoft-excel\/\">https:\/\/webmediacenter.com\/mengenal-referen\u2026-microsoft-excel\/<\/a>Anda dapat menggunakan tiga jenis referensi sel di formula Excel, yaitu relatif, absolut, dan semi absolut. Dengan menggunakan \u00a0jenis \u00a0\u00a0referensi yang tepat \u00a0pada sel untuk memastikan bahwa formula bekerja seperti yang diharapkan ketika Anda menyalinnya ke lokasi lain dalam worksheet. Rumus dan fungsi tersebut akan sangat \u00a0berguna ketika menggunakan referensi suatu sel dalam rumus excel yang digunakan, sehingga Anda perlu memahami cara penggunaanya dengan baik.<\/p>\n<p>Excel akan menjadi dinamis ketika kita menduplikasi suatu formula ke suatu alamat sel. Jika Anda memiliki sel dengan formula yang referensi alamat selnya \u00a0berbeda dan Anda akan menyalin rumus dari sel pertama ke sel yang lain, maka secara otomatis excel akan meng-update formula yang anda buat.<\/p>\n<p>Untuk lebih memahami lebih baik, berikut kami berikan jenis pembagian penggunaan referesi pada excel;<\/p>\n<table border=\"1\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>\n<p align=\"center\"><strong>Jenis Referensi\u00a0 <\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>Formula<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>Yang terjadi ketika meng-copy formulanya<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Relative<\/td>\n<td>=A1<\/td>\n<td>Baris 1 dan kolom A akan berganti<\/td>\n<\/tr>\n<tr>\n<td>Absolute<\/td>\n<td>=$A$1<\/td>\n<td>Baris 1 dan kolom A tidak akan berganti<\/td>\n<\/tr>\n<tr>\n<td>Mixed (semi absolut)<\/td>\n<td>=$A1<\/td>\n<td>Baris 1 akan berganti dan kolom A tidak akan berganti<\/td>\n<\/tr>\n<tr>\n<td>Mixed (semi absolut)<\/td>\n<td>=A$1<\/td>\n<td>Baris 1 tidak akan berganti dan kolom A akan berganti<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><em><span style=\"text-decoration: underline;\">Contoh Penggunaan :<\/span><\/em><\/strong><\/p>\n<p>Coba anda ikuti latihan berikut ini :<\/p>\n<p><a href=\"http:\/\/webmediacenter.com\/wp-content\/uploads\/2014\/05\/1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4824\" title=\"1\" src=\"http:\/\/webmediacenter.com\/wp-content\/uploads\/2014\/05\/1-300x256.png\" alt=\"\" width=\"300\" height=\"256\" \/><\/a><\/p>\n<p>Langkah mengerjakanya adalah ;<\/p>\n<ul>\n<li>Isikan formula berikut pada sel C6 =C$3*$B6<\/li>\n<li>Kemudian copy-kan sampai ke sel D12<\/li>\n<li>Lihat hasil perhitunganya<\/li>\n<\/ul>\n<p><a href=\"http:\/\/webmediacenter.com\/wp-content\/uploads\/2014\/05\/2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4825\" title=\"2\" src=\"http:\/\/webmediacenter.com\/wp-content\/uploads\/2014\/05\/2-300x251.png\" alt=\"\" width=\"300\" height=\"251\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em><span style=\"text-decoration: underline;\">Ulasan Formula :<\/span><\/em><\/strong><\/p>\n<p>Coba kita kembali perhatikan formula yang kita buat, =C$3*$B6. Disini kita ingin menghitung <strong>Total Tipe 1 <\/strong>dan <strong>Total Tipe 2<\/strong> dengan sekali membuat formula dengan acuan referensi\u00a0 Harga Tipe 1 dan Harga Tipe 2. Maka yang kita perlukan bagaimana supaya\u00a0 ketika kita copy ke bawah sel referensi harga tetap berda di Harga Tipe 1 dan kalau kita copy ke samping\u00a0 referensi harga berpindah ke Harga Tipe 2, maka yang harus kita kunci\/Absolutkan adalah baris-nya ($3) karena kolomnya harus berganti, nah begitu juga sebaliknya untuk sel unit ($B6).<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em><span style=\"text-decoration: underline;\">Tugas<\/span><\/em><\/strong><\/p>\n<p>Menggunakan referensi absolut, buatlah tabel perkalian bilangan 1 sampai 10 dengan satu kali membuat formula?<\/p>\n<p><strong>Tabel Perhitungan Perkalian Bilangan 1 sampai dengan 10<\/strong><\/p>\n<table border=\"0\" width=\"460\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">Bilangan<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">1<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">2<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">3<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">4<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">5<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">6<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">7<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">8<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">9<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\">\n<p align=\"center\">10<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">1<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">2<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">3<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">4<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">5<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">6<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">7<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">8<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">9<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"60\">\n<p align=\"center\">10<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\" width=\"40\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><em>Selamat belajar\u2026\u2026<\/em><br \/>\ninfo lebih lanjut : http:\/\/webmediaonline.com\/course\/microsoft-office-excel-2013\/<\/p>\n<p align=\"left\"><strong>WEBMEDIA Training Center<\/strong><br \/>\nJl. Setiabudi, Komp. Setiabudi Bisnis Point No.12-13 CC, Medan \u2013 20122<br \/>\nHP\/WA : 0852 6114 0004, 0852 1266 5455<br \/>\nTwitter : <a href=\"https:\/\/twitter.com\/webmediatc\">@webmediatc<\/a><br \/>\nInstagram : <a href=\"https:\/\/www.instagram.com\/webmediatc\/\">@webmediatc<\/a><br \/>\nMap : <a href=\"https:\/\/g.page\/lkp-webmedia-training-center?share\">LKP Webmedia Training Center<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/webmediacenter.com\/mengenal-referen\u2026-microsoft-excel\/Anda dapat menggunakan tiga jenis referensi sel di formula Excel, yaitu relatif, absolut, dan semi absolut. Dengan menggunakan \u00a0jenis \u00a0\u00a0referensi yang tepat \u00a0pada sel untuk memastikan bahwa formula bekerja seperti yang diharapkan ketika Anda menyalinnya ke lokasi lain dalam worksheet. Rumus dan fungsi tersebut akan sangat \u00a0berguna ketika menggunakan referensi suatu sel dalam rumus excel [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-4823","post","type-post","status-publish","format-standard","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/posts\/4823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/comments?post=4823"}],"version-history":[{"count":0,"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/posts\/4823\/revisions"}],"wp:attachment":[{"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/media?parent=4823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/categories?post=4823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sample.webmediacenter.com\/index.php\/wp-json\/wp\/v2\/tags?post=4823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}