{"id":2864,"date":"2023-07-20T08:38:39","date_gmt":"2023-07-20T08:38:39","guid":{"rendered":"https:\/\/statorials.org\/id\/urutan-lembar-google\/"},"modified":"2023-07-20T08:38:39","modified_gmt":"2023-07-20T08:38:39","slug":"urutan-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/urutan-lembar-google\/","title":{"rendered":"Google spreadsheet: cara menggunakan fungsi urutan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <b>SEQUENCE<\/b> di Google Sheets untuk mengembalikan array nomor urut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">SEQUENCE(rows, columns, start, step)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>baris<\/strong> : Jumlah baris yang akan dikembalikan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kolom<\/strong> : Jumlah kolom yang akan dikembalikan (defaultnya adalah 1)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>start<\/strong> : Nomor untuk memulai urutan (defaultnya adalah 1)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>step<\/strong> : jumlah penambahan atau pengurangan setiap angka secara berurutan (defaultnya adalah 1)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan penggunaan fungsi ini dalam berbagai skenario di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Buat urutan nilai dalam kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk membuat urutan nilai dalam kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">SEQUENCE( <span style=\"color: #3366ff;\">10<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25065 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sequence1.jpg\" alt=\"\" width=\"492\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Hasilnya adalah satu kolom yang berisi nilai berurutan dari 1 hingga 10.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Buat rangkaian nilai dalam satu baris<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk membuat barisan nilai pada sebuah garis:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">SEQUENCE( <span style=\"color: #3366ff;\"><span style=\"color: #000000;\">1,5<\/span><\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25066 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sequence2.jpg\" alt=\"\" width=\"555\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah satu baris berisi nilai berurutan 1 hingga 5.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Buat matriks nilai berurutan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk membuat matriks nilai dengan <strong>10<\/strong> baris, <strong>3<\/strong> kolom, dimulai dari <strong>0<\/strong> dan masing-masing nilainya bertambah <strong>5<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\"><span style=\"color: #3366ff;\">SEQUENCE<\/span> <span style=\"color: #3366ff;\">(<\/span> <span style=\"color: #3366ff;\">10,3,0,5<\/span> <span style=\"color: #3366ff;\">)<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25067 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sequence3.jpg\" alt=\"Fungsi urutan Google Sheets\" width=\"512\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah matriks 10 baris, 3 kolom, dimulai dari 0 dan setiap nilainya bertambah 5.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <b>SEQUENCE<\/b> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/9368244?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menggunakan fungsi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi AVERAGEIFS di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi ISERROR di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/\" target=\"_blank\" rel=\"noopener\">Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi SEQUENCE di Google Sheets untuk mengembalikan array nomor urut. Fungsi ini menggunakan sintaks dasar berikut: SEQUENCE(rows, columns, start, step) Emas: baris : Jumlah baris yang akan dikembalikan kolom : Jumlah kolom yang akan dikembalikan (defaultnya adalah 1) start : Nomor untuk memulai urutan (defaultnya adalah 1) step : jumlah penambahan atau [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Spreadsheet: Cara menggunakan fitur URUTAN - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SEQUENCE di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/urutan-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menggunakan fitur URUTAN - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SEQUENCE di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/urutan-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T08:38:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sequence1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/urutan-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/urutan-lembar-google\/\",\"name\":\"Google Spreadsheet: Cara menggunakan fitur URUTAN - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T08:38:39+00:00\",\"dateModified\":\"2023-07-20T08:38:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi SEQUENCE di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/urutan-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/urutan-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/urutan-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menggunakan fungsi urutan\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Spreadsheet: Cara menggunakan fitur URUTAN - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi SEQUENCE di Google Sheets, dengan beberapa contoh.","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:\/\/statorials.org\/id\/urutan-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menggunakan fitur URUTAN - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi SEQUENCE di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/urutan-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-20T08:38:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sequence1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/urutan-lembar-google\/","url":"https:\/\/statorials.org\/id\/urutan-lembar-google\/","name":"Google Spreadsheet: Cara menggunakan fitur URUTAN - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T08:38:39+00:00","dateModified":"2023-07-20T08:38:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi SEQUENCE di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/urutan-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/urutan-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/urutan-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menggunakan fungsi urutan"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2864"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2864"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2864\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}