{"id":1661,"date":"2023-11-12T18:51:05","date_gmt":"2023-11-12T18:51:05","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/"},"modified":"2023-12-06T06:14:00","modified_gmt":"2023-12-06T06:14:00","slug":"peringkat-bintang","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/","title":{"rendered":"Bagaimana cara membuat templat peringkat bintang di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1526927601\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p class=\"has-text-align-left\">Berikut tip singkat untuk membantu Anda membuat templat peringkat bintang di Excel. Untuk membuat template peringkat bintang ini, yang Anda perlukan hanyalah fungsi REPT. Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali.<\/p><h2 id=\"h-steps-to-create-a-star-rating-template\" class=\"wp-block-heading\"> Langkah-langkah Membuat Template Peringkat Bintang<\/h2><ol><li> Masukkan dua jenis bintang berbeda (\u2606\u2605) ke dalam spreadsheet Anda dan letakkan di dua sel berbeda.<\/li><li> Masukkan lima tombol opsi (kontrol formulir) dari tab pengembang. Dan buat satu tautan sel untuk semua tombol. Tempatkan mereka dalam lima sel dalam arah vertikal.<\/li><li> Gabungkan 5 sel, hanya satu kolom sebelumnya, di mana Anda memiliki tombol.<\/li><li> Masukkan \u201c=REPT(H11,5-K11)&amp;REPT(I11,K11)\u201d di sel gabungan.<\/li><li> Ubah orientasi teks sel menjadi teks vertikal, lalu ubah perataan teks menjadi tengah dan bawah.<\/li><\/ol><p> Model Anda sudah siap. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\" sizes=\"\" srcset=\"\" alt=\"templat peringkat bintang di excel\"><\/figure><\/div><h2 id=\"h-how-it-works\" class=\"wp-block-heading\"> Bagaimana itu bekerja<\/h2><p> Bagian pertama dari rumus ini akan memberi Anda bintang yang dijelaskan. Misalnya, ketika Anda mengeklik peringkat 3 bintang, dua bintang lainnya dalam rencana akan diberikan.<\/p><p> Bagian kedua dari rumus ini akan memberi Anda bintang yang terisi. Misalnya, ketika Anda mengklik peringkat bintang 4, Anda akan mendapatkan 4 bintang terisi.<\/p><p class=\"content-box-green\"> Anda juga dapat memasukkan simbol ke dalam rumus itu sendiri atau Anda juga dapat menggunakan jenis simbol lain sesuai keinginan. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Dapatkan file Excelnya <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/modele-devaluation-par-etoiles-excel-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><\/div><\/div><\/div><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\">Buat filter horizontal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-file\/\">Dapatkan nama file di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-lembar\/\">Dapatkan nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/\">Hasilkan huruf acak dengan cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\">Acak daftar (pengurutan acak) di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1661","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana Cara Membuat Templat Peringkat Bintang di Excel?<\/title>\n<meta name=\"description\" content=\"Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali. Dan, hari ini kita akan menggunakan rumus ini untuk membuat model pemeringkatan bintang.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana Cara Membuat Templat Peringkat Bintang di Excel?\" \/>\n<meta property=\"og:description\" content=\"Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali. Dan, hari ini kita akan menggunakan rumus ini untuk membuat model pemeringkatan bintang.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\",\"name\":\"Bagaimana Cara Membuat Templat Peringkat Bintang di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\",\"datePublished\":\"2023-11-12T18:51:05+00:00\",\"dateModified\":\"2023-12-06T06:14:00+00:00\",\"description\":\"Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali. Dan, hari ini kita akan menggunakan rumus ini untuk membuat model pemeringkatan bintang.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat templat peringkat bintang di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana Cara Membuat Templat Peringkat Bintang di Excel?","description":"Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali. Dan, hari ini kita akan menggunakan rumus ini untuk membuat model pemeringkatan bintang.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana Cara Membuat Templat Peringkat Bintang di Excel?","og_description":"Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali. Dan, hari ini kita akan menggunakan rumus ini untuk membuat model pemeringkatan bintang.","og_url":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/","url":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/","name":"Bagaimana Cara Membuat Templat Peringkat Bintang di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","datePublished":"2023-11-12T18:51:05+00:00","dateModified":"2023-12-06T06:14:00+00:00","description":"Fungsi REPT berguna ketika Anda ingin mengulang teks tertentu beberapa kali. Dan, hari ini kita akan menggunakan rumus ini untuk membuat model pemeringkatan bintang.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/peringkat-bintang\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat templat peringkat bintang di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1661"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1661\/revisions"}],"predecessor-version":[{"id":2324,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1661\/revisions\/2324"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}