{"id":3836,"date":"2024-12-03T07:35:25","date_gmt":"2024-12-03T07:35:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt\/"},"modified":"2024-12-03T07:35:25","modified_gmt":"2024-12-03T07:35:25","slug":"huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel v\u1edbi h\u00e0m SQRT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1edbi\u00a0c\u00e1c ph\u00e9p t\u00ednh c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia trong\u00a0Excel ch\u00fang ta\u00a0\u0111\u1ec1u\u00a0hay s\u1eed d\u1ee5ng v\u00e0 bi\u1ebft c\u00e1ch l\u00e0m. Nh\u01b0ng v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u1edbi s\u1ed1 m\u0169, t\u00ednh c\u0103n th\u00ec l\u1ea1i\u00a0\u00edt s\u1eed d\u1ee5ng. V\u1eady trong\u00a0Excel <strong>vi\u1ec7c t\u00ednh c\u0103n b\u1eadc 2, c\u0103n b\u1eadc 3<\/strong>, c\u00e1ch vi\u1ebft s\u1ed1\u00a0m\u0169 nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674eb4bcc0888\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt.html#Cach_viet_so_mu_trong_Excel\" title=\"C\u00e1ch vi\u1ebft s\u1ed1 m\u0169 trong\u00a0Excel\">C\u00e1ch vi\u1ebft s\u1ed1 m\u0169 trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt.html#Cach_viet_can_bac_2_trong_Excel\" title=\"C\u00e1ch vi\u1ebft c\u0103n b\u1eadc 2 trong\u00a0Excel\">C\u00e1ch vi\u1ebft c\u0103n b\u1eadc 2 trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt.html#Ham_can_bac_2_trong_Excel\" title=\"H\u00e0m c\u0103n b\u1eadc 2 trong\u00a0Excel\">H\u00e0m c\u0103n b\u1eadc 2 trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_so_mu_trong_Excel\"><\/span>C\u00e1ch vi\u1ebft s\u1ed1 m\u0169 trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong to\u00e1n h\u1ecdc, vi\u1ebft s\u1ed1 m\u0169 th\u01b0\u1eddng c\u00f3 d\u1ea1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24539\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3a1ch-vie1babft-se1bb91-mc5a9-trong-excel.png\" width=\"275\" height=\"56\" title=\"cc3a1ch-vie1babft-se1bb91-mc5a9-trong-excel\"><\/p>\n<p>\u00d4 A1 ch\u00fang ta th\u1ea5y ch\u1eef s\u1ed1 2\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u1ecf h\u01a1n v\u00e0\u00a0\u1edf ph\u00eda tr\u00ean, b\u00ean ph\u1ea3i c\u1ee7a ch\u1eef A.<\/p>\n<p>\u00d4 A2 ch\u00fang ta th\u1ea5y ch\u1eef s\u1ed1\u00a02\u00a0\u0111\u01b0\u1ee3c vi\u1ebft ngang h\u00e0ng, c\u00e1ch ch\u1eef A b\u1edfi k\u00fd t\u1ef1 m\u0169 l\u00e0 <strong>^<\/strong> (<em>ph\u00edm shift + s\u1ed1 6<\/em>).<\/p>\n<p>Trong 2 c\u00e1ch vi\u1ebft tr\u00ean, ch\u00fang ta\u00a0\u0111\u1ec1u hi\u1ec3u l\u00e0 A m\u0169 2, tuy nhi\u00ean trong\u00a0Excel, c\u00e1ch vi\u1ebft\u00a0\u1edf\u00a0\u00f4 B1 m\u1edbi\u00a0\u0111\u01b0\u1ee3c t\u00ednh\u00a0\u0111\u1ec3 ra k\u1ebft qu\u1ea3. C\u00f2n c\u00e1ch vi\u1ebft\u00a0\u1edf A1 ch\u1ec9 l\u00e0\u00a0\u0111\u1ec3 tr\u00ecnh b\u00e0y d\u01b0\u1edbi d\u1ea1ng text m\u00e0 th\u00f4i.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-302.gif\" title=\"ex101_92019-nho-302\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24540\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-cach-viet-so-mu-excel.png\" width=\"274\" height=\"107\" title=\"vi-du-cach-viet-so-mu-excel\"><\/p>\n<p>\u1ede\u00a0\u00f4 A3, ch\u00fang ta nh\u1eadp con s\u1ed1 42 d\u01b0\u1edbi d\u1ea1ng TEXT (c\u00f3 d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n ( \u2018 ) \u1edf tr\u01b0\u1edbc s\u1ed1 4. Sau\u00a0\u0111\u00f3 Format Cells,\u00a0\u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 2 v\u1ec1 d\u1ea1ng ch\u1eef <strong>Superscript<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24541\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-text-dang-so-mu.png\" width=\"946\" height=\"409\" title=\"dinh-dang-text-dang-so-mu\"><\/p>\n<p>\u1ede\u00a0\u00f4 A4, ch\u00fang ta vi\u1ebft =4^2 cho ra k\u1ebft qu\u1ea3 l\u00e0 16<\/p>\n<p>Nh\u01b0 v\u1eady c\u00e1ch vi\u1ebft s\u1ed1 m\u0169 trong\u00a0Excel l\u00e0:\u00a0<strong>A m\u0169 n\u00a0=A^n<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_can_bac_2_trong_Excel\"><\/span>C\u00e1ch vi\u1ebft c\u0103n b\u1eadc 2 trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ng\u01b0\u1ee3c l\u1ea1i v\u1edbi s\u1ed1\u00a0m\u0169 ch\u00ednh l\u00e0 s\u1ed1 c\u0103n.\u00a0\u0110\u1ec3 vi\u1ebft c\u0103n b\u1eadc 2 trong\u00a0Excel, ta c\u00f3 c\u00e1ch vi\u1ebft nh\u01b0 sau:<\/p>\n<p>C\u0103n b\u1eadc 2 c\u1ee7a A =A^(1\/2)<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24542\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/can-bac-2-viet-dang-so-mu.png\" width=\"410\" height=\"115\" title=\"can-bac-2-viet-dang-so-mu\"><\/p>\n<p>C\u0103n b\u1eadc 2 c\u1ee7a 16 l\u00e0 16^(1\/2) = 4<\/p>\n<p>Nh\u01b0 v\u1eady c\u00f3 th\u1ec3 t\u1ed5ng qu\u00e1t:<\/p>\n<blockquote>\n<p>C\u0103n b\u1eadc n c\u1ee7a A =A^(1\/n)<\/p>\n<\/blockquote>\n<ul>\n<li>C\u0103n b\u1eadc 3 c\u1ee7a A =A^(1\/3)<\/li>\n<li>C\u0103n b\u1eadc 5 c\u1ee7a A =A^(1\/5)<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Ham_can_bac_2_trong_Excel\"><\/span>H\u00e0m c\u0103n b\u1eadc 2 trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ngo\u00e0i ra trong\u00a0Excel c\u00f2n c\u00f3 1 h\u00e0m ri\u00eang\u00a0\u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2,\u00a0\u0111\u00f3 l\u00e0 h\u00e0m SQRT. C\u00e1ch vi\u1ebft nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24543\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/can-bac-2-ham-sqrt.png\" width=\"316\" height=\"98\" title=\"can-bac-2-ham-sqrt\"><\/p>\n<p>H\u00e0m SQRT(number) l\u00e0 h\u00e0m gi\u00fap t\u00ednh ra k\u1ebft qu\u1ea3 c\u0103n b\u1eadc 2 c\u1ee7a 1 s\u1ed1. L\u01b0u\u00a0\u00fd l\u00e0 h\u00e0m n\u00e0y ch\u1ec9 t\u00ednh c\u0103n b\u1eadc 2, kh\u00f4ng\u00a0\u00e1p d\u1ee5ng cho c\u00e1c b\u1eadc kh\u00e1c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 t\u1ed5ng k\u1ebft l\u1ea1i m\u1ed9t s\u1ed1 ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n nh\u01b0 sau:<\/p>\n<ul>\n<li>Vi\u1ebft s\u1ed1\u00a0m\u0169 d\u1ea1ng A^n<\/li>\n<li>C\u0103n b\u1eadc 2 c\u00f3 h\u00e0m SQRT<\/li>\n<li>C\u0103n b\u1eadc n c\u1ee7a 1 s\u1ed1 c\u00f3 d\u1ea1ng A^(1\/n)<\/li>\n<\/ul>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1 sau\u00a0\u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-power-ham-tinh-luy-thua-trong-excel.html\">H\u00e0m POWER, h\u00e0m t\u00ednh l\u0169y th\u1eeba trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-trong-excel.html\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u to\u00e0n t\u1eadp trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/lam-chu-cong-thuc-trong-excel.html\">L\u00e0m ch\u1ee7 c\u00f4ng th\u1ee9c trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-302.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3836","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3836","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3836"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3836\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3837"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}