{"id":1719,"date":"2023-11-09T22:59:40","date_gmt":"2023-11-09T22:59:40","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/"},"modified":"2023-12-06T06:15:30","modified_gmt":"2023-12-06T06:15:30","slug":"jumlah-kuadrat-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/","title":{"rendered":"Bagaimana cara menambahkan kotak di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-279658953\"><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>Di Excel, ada fungsi khusus yang bisa Anda gunakan untuk menghitung jumlah kuadrat angka dalam satu sel. Fungsi ini disebut SUM. Dan merujuk pada rentang sel atau dapat memasukkan nilai langsung ke dalam fungsi untuk mendapatkan hasilnya.<\/p><h2 id=\"h-formula-to-get-the-sum-of-squares\" class=\"wp-block-heading\"> Rumus untuk mendapatkan jumlah kuadrat<\/h2><p> Berikut langkah-langkah menulis rumus tersebut:<\/p><ol type=\"1\"><li> Ketik (=) di sel untuk memasukkan fungsi.<\/li><li> Masukkan (SUMQ) lalu masukkan tanda kurung di depannya.<\/li><li> Lihat rentang di mana Anda memiliki angka yang ingin Anda dapatkan jumlah nilai kuadratnya.<\/li><li> Tutup fungsinya dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85889\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah kotak\" width=\"635\" height=\"108\"><\/figure><\/div><p> Saat Anda menekan Enter, ini memberi Anda nilai akhir, jumlah kuadrat dari 25 dan 25, karena kita memiliki dua angka dalam rentang A1:B1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85890\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sommeq-en-somme-des-carres.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-ke-jumlah-kuadrat\" width=\"638\" height=\"293\"><\/figure><\/div><p> Untuk memverifikasinya, kita bisa melakukan pengecekan manual. Kuadrat dari 25 adalah 625, dan karena kita mempunyai 25 di kedua sel, maka hasilnya adalah 625 + 625 = 1250. Dan itulah hasilnya. Anda juga dapat merujuk ke rentang dengan banyak angka tanpa mengkhawatirkan jumlah sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85891\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-verification-manuelle-du-carre.png\" sizes=\"auto, \" srcset=\"\" alt=\"pemeriksaan persegi manual\" width=\"520\" height=\"424\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda menggunakan bilangan negatif, Anda akan selalu mendapatkan hasil berupa bilangan positif.<\/p><h2 id=\"h-use-a-simple-maths-formula\" class=\"wp-block-heading\"> Gunakan rumus matematika sederhana<\/h2><p> Daripada menggunakan fungsi tersebut, Anda bisa menggunakan rumus sederhana menggunakan operator tanda sisipan (^). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85892\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formules-mathematiques-pour-additionner-les-carres.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-matematika-dalam-jumlah-kuadrat\" width=\"453\" height=\"290\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(A1^2,B1^2)<\/code><\/pre><p> Di sini kami menggunakan fungsi SUM, dan untuk setiap angka kami menggunakan operator tanda sisipan (^) untuk mendapatkan kuadrat dari angka tersebut terlebih dahulu. Atau bisa juga dengan menuliskan rumus seperti ini:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1^2+B1^2<\/code><\/pre><p> Metode-metode ini penggunaannya terbatas. Jadi jika Anda memiliki daftar nomor yang panjang, lebih baik gunakan cara pertama. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-des-carres.xlsx\" rel=\"nofollow\">Unduh<\/a><\/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\/tambahkan-seluruh-kolom\/\">Tambahkan seluruh kolom atau baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\">Jumlahkan hanya sel yang terlihat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-sel-acak\/\">Jumlah sel acak di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-keseluruhan\/\">Tambahkan baris total di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\">Gunakan AutoSum di Excel dengan cepat<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1719","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 menambahkan kotak di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung jumlah kuadrat dengan dua cara berbeda. Mari kita periksa ini...\" \/>\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\/jumlah-kuadrat-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan kotak di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung jumlah kuadrat dengan dua cara berbeda. Mari kita periksa ini...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\" \/>\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\/jumlah-kuadrat-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/\",\"name\":\"Bagaimana cara menambahkan kotak di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\",\"datePublished\":\"2023-11-09T22:59:40+00:00\",\"dateModified\":\"2023-12-06T06:15:30+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung jumlah kuadrat dengan dua cara berbeda. Mari kita periksa ini...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan kotak 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 menambahkan kotak di Excel? (Tutorial 2023)","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung jumlah kuadrat dengan dua cara berbeda. Mari kita periksa ini...","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\/jumlah-kuadrat-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan kotak di Excel? (Tutorial 2023)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung jumlah kuadrat dengan dua cara berbeda. Mari kita periksa ini...","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png","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\/jumlah-kuadrat-2\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/","name":"Bagaimana cara menambahkan kotak di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png","datePublished":"2023-11-09T22:59:40+00:00","dateModified":"2023-12-06T06:15:30+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung jumlah kuadrat dengan dua cara berbeda. Mari kita periksa ini...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan kotak 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\/1719","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=1719"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1719\/revisions"}],"predecessor-version":[{"id":2415,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1719\/revisions\/2415"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}