{"id":3211,"date":"2023-07-18T16:07:41","date_gmt":"2023-07-18T16:07:41","guid":{"rendered":"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/"},"modified":"2023-07-18T16:07:41","modified_gmt":"2023-07-18T16:07:41","slug":"google-lintas-spreadsheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/","title":{"rendered":"Cara membuat tab silang di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Tab silang<\/strong> adalah tabel yang merangkum hubungan antara dua variabel kategori.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat tab silang di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan dataset berikut ke Google Sheets yang menampilkan informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27272 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise1.jpg\" alt=\"\" width=\"580\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat tab silang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>PivotTable<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27273 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise2.jpg\" alt=\"\" width=\"530\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, masukkan <strong>Sheet1!A1:C13<\/strong> sebagai Data Range dan <strong>Sheet1!E1<\/strong> sebagai Insert Location, lalu klik <strong>Create<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27274 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise3.jpg\" alt=\"\" width=\"657\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Isi tab silang dengan nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Buat<\/strong> , panel Editor PivotTable baru akan muncul di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pilih Tim untuk <strong>Baris<\/strong> , Posisi untuk <strong>Kolom<\/strong> dan Poin untuk <strong>Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27275 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise4.jpg\" alt=\"\" width=\"328\" height=\"650\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah selesai, tab silang berikut akan muncul di sel yang Anda tentukan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27276\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise5.jpg\" alt=\"tab silang di Google Spreadsheet\" width=\"534\" height=\"305\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Tafsirkan tab silang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan nilai tab silang:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Total baris utama:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total ada <strong>6<\/strong> pemain yang tergabung dalam tim A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total ada <strong>6<\/strong> pemain yang tergabung dalam Tim B.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Total keseluruhan kolom:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total ada <strong>3<\/strong> pemain yang menempati posisi Center<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total ada <strong>4<\/strong> pemain yang menempati posisi Attacker.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total ada <strong>5<\/strong> pemain yang memiliki posisi Guard<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Sel individu:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> pemain mempunyai posisi Center di Tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> pemain memiliki posisi Penyerang di Tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> pemain memiliki posisi Penjaga di Tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> pemain mempunyai posisi Center di tim B<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> pemain mempunyai posisi Penyerang di tim B<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> pemain memiliki posisi Penjaga di tim B<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung frekuensi di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-kumulatif-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Kumulatif di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak nilai N pertama dari rentang di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tab silang adalah tabel yang merangkum hubungan antara dua variabel kategori. Contoh langkah demi langkah berikut menunjukkan cara membuat tab silang di Google Spreadsheet. Langkah 1: Masukkan datanya Pertama, masukkan dataset berikut ke Google Sheets yang menampilkan informasi tentang berbagai pemain bola basket: Langkah 2: Buat tab silang Selanjutnya, klik tab Sisipkan di sepanjang pita [&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>Cara Membuat Crosstab di Google Sheets \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat crosstab di Google Sheets, dengan sebuah 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\/google-lintas-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Crosstab di Google Sheets \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat crosstab di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T16:07:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise1.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\/google-lintas-spreadsheet\/\",\"url\":\"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/\",\"name\":\"Cara Membuat Crosstab di Google Sheets \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T16:07:41+00:00\",\"dateModified\":\"2023-07-18T16:07:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat crosstab di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat tab silang di google spreadsheet\"}]},{\"@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":"Cara Membuat Crosstab di Google Sheets \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat crosstab di Google Sheets, dengan sebuah 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\/google-lintas-spreadsheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Crosstab di Google Sheets \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat crosstab di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/","og_site_name":"Statorials","article_published_time":"2023-07-18T16:07:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise1.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\/google-lintas-spreadsheet\/","url":"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/","name":"Cara Membuat Crosstab di Google Sheets \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T16:07:41+00:00","dateModified":"2023-07-18T16:07:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat crosstab di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-lintas-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat tab silang di google spreadsheet"}]},{"@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\/3211"}],"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=3211"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3211\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}