{"id":12437,"date":"2022-11-26T07:54:27","date_gmt":"2022-11-26T00:54:27","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12437"},"modified":"2022-12-08T16:23:02","modified_gmt":"2022-12-08T09:23:02","slug":"cach-tinh-can-bac-2-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12437&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">N\u1ebfu \u0111\u1ec3 n\u00f3i v\u1ec1 s\u1ef1 th\u00f4ng minh c\u1ee7a con ng\u01b0\u1eddi th\u00ec ch\u00fang ta s\u1ebd d\u1ef1a v\u00e0o nh\u1eefng ph\u00e1t minh khoa h\u1ecdc v\u0129 \u0111\u1ea1i hay nh\u1eefng c\u00f4ng tr\u00ecnh ki\u1ebfn tr\u00fac \u0111\u1ed3 s\u1ed9. Ch\u00fang ta s\u1ed1ng trong x\u00e3 h\u1ed9i ph\u00e1t tri\u1ec3n th\u00ec con ng\u01b0\u1eddi c\u0169ng s\u1ebd d\u1ef1a v\u00e0o s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a c\u00f4ng ngh\u1ec7 \u0111\u1ec3 gi\u00fap cu\u1ed9c s\u1ed1ng tr\u1edf n\u00ean t\u1ed1t \u0111\u1eb9p h\u01a1n.\u00a0<\/span><span style=\"font-weight: 400;\">Excel l\u00e0 ph\u1ea7n m\u1ec1m s\u1edbm \u0111\u00e3 \u0111\u01b0\u1ee3c con ng\u01b0\u1eddi \u0111\u01b0a v\u00e0o s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u00fap nh\u1eefng kh\u00f3 kh\u0103n v\u1ec1 t\u00ednh to\u00e1n v\u00e0 s\u1ed1 li\u1ec7u \u0111\u01b0\u1ee3c gi\u1ea3m b\u1edbt v\u00e0 gi\u1ea3i quy\u1ebft nhanh ch\u00f3ng h\u01a1n. Tuy nhi\u00ean, \u0111\u1ec3 hi\u1ec3u h\u1ebft v\u1ec1 excel v\u00e0 bi\u1ebft <\/span><b>c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel<\/b><span style=\"font-weight: 400;\"> th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft. V\u00ec th\u1ebf b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft c\u00e1ch t\u00ednh h\u00e0m c\u0103n b\u1eadc 2 trong excel, c\u00f9ng t\u00ecm hi\u1ec3u ngay th\u00f4i.\u00a0<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#Thong_tin_ve_can_bac_2\" >Th\u00f4ng tin v\u1ec1 c\u0103n b\u1eadc 2<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#Can_bac_2_co_tinh_chat_gi_khong\" >C\u0103n b\u1eadc 2 c\u00f3 t\u00ednh ch\u1ea5t g\u00ec kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#Tac_dung_cua_ham_can_bac_2\" >T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m c\u0103n b\u1eadc 2<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#Cach_tinh_can_bac_2_trong_excel_bang_ham_SQRT\" >C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel b\u1eb1ng h\u00e0m SQRT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#Su_dung_ham_SQRT_de_tinh_can_bac_2_cho_gia_tri_am\" >S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 cho gi\u00e1 tr\u1ecb \u00e2m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#Tinh_can_bac_2_trong_excel_bang_cong_thuc_mu_nhanh_chong\" >T\u00ednh c\u0103n b\u1eadc 2 trong excel b\u1eb1ng c\u00f4ng th\u1ee9c m\u0169 nhanh ch\u00f3ng<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_ve_can_bac_2\"><\/span><b>Th\u00f4ng tin v\u1ec1 c\u0103n b\u1eadc 2<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 \u0111\u1eb3ng th\u1ee9c to\u00e1n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong c\u00e1c c\u00f4ng th\u1ee9c<a href=\"https:\/\/vi.wikipedia.org\/wiki\/To%C3%A1n_h%E1%BB%8Dc\" rel=\"nofollow noreferrer\"> to\u00e1n h\u1ecdc<\/a>. Ch\u00fang ta c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01a1n gi\u1ea3n c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 th\u00ec x2 b\u1eb1ng ch\u00ednh s\u1ed1 \u0111\u00f3. Hi\u1ec3u \u0111\u01a1n gi\u1ea3n l\u00e0 b\u00ecnh ph\u01b0\u01a1ng c\u1ee7a s\u1ed1 n\u00e0o b\u1eb1ng x th\u00ec s\u1ed1 \u0111\u00f3 l\u00e0 c\u0103n b\u1eadc 2 c\u1ee7a x. C\u0103n b\u1eadc 2 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong gi\u1edbi to\u00e1n h\u1ecdc \u0111\u1ec3 gi\u00fap con ng\u01b0\u1eddi t\u01b0 duy nhanh h\u01a1n.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u00e0m c\u0103n b\u1eadc 2 trong Excel, c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 b\u1eb1ng h\u00e0m SQRT\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/hCxUq0nxzCQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 c\u00e1ch vi\u1ebft tay th\u00f4ng th\u01b0\u1eddng th\u00ec c\u0103n b\u1eadc 2 c\u00f3 k\u00fd hi\u1ec7u \u221aa. C\u00f2n t\u00f9y thu\u1ed9c v\u00e0o giao di\u1ec7n c\u1ee7a c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c nhau th\u00ec k\u00fd hi\u1ec7u c\u0103n b\u1eadc 2 s\u1ebd hi\u1ec7n kh\u00e1c nhau. Tuy nhi\u00ean ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng v\u00e0i l\u1ea7n l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 th\u00e0nh th\u1ea1o r\u1ed3i.\u00a0<\/span><\/p>\n<figure id=\"attachment_13067\" aria-describedby=\"caption-attachment-13067\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13067 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-5-e1648947091994.jpg\" alt=\"Th\u00f4ng tin v\u1ec1 c\u0103n b\u1eadc 2\" width=\"600\" height=\"276\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-5-e1648947091994.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-5-e1648947091994-400x184.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13067\" class=\"wp-caption-text\">Th\u00f4ng tin v\u1ec1 c\u0103n b\u1eadc 2<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Can_bac_2_co_tinh_chat_gi_khong\"><\/span>C\u0103n b\u1eadc 2 c\u00f3 t\u00ednh ch\u1ea5t g\u00ec kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng c\u0103n b\u1eadc 2 b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm r\u00f5 nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c t\u00ednh ch\u1ea5t c\u1ee7a c\u0103n b\u1eadc 2:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u0103n b\u1eadc 2 c\u1ee7a 0 b\u1eb1ng 0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 \u0111\u1ec1u c\u00f3 c\u1ea3 c\u0103n b\u1eadc 2 \u00e2m v\u00e0 c\u0103n b\u1eadc 2 d\u01b0\u01a1ng; m\u1eb7c d\u00f9 nghe \u0111\u1ebfn c\u0103n b\u1eadc 2 ch\u00fang ta ch\u1ec9 ngh\u0129 \u0111\u1ebfn c\u00e1c s\u1ed1 \u00e2m nh\u1eefng th\u1ef1c ra n\u00f3 v\u1eabn c\u00f3 c\u1ea3 c\u0103n b\u1eadc 2 \u00e2m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong excel, khi t\u00ednh c\u0103n b\u1eadc 2 c\u00e1c gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 ch\u1ec9 l\u00e0 s\u1ed1 d\u01b0\u01a1ng; n\u1ebfu ra s\u1ed1 0 ho\u1eb7c s\u1ed1 0 th\u00ec s\u1ebd kh\u00f4ng s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong gi\u1ea5y b\u00fat truy\u1ec1n th\u1ed1ng ch\u00fang ta c\u00f3 c\u00e1ch vi\u1ebft c\u0103n b\u1eadc 2 quen thu\u1ed9c; tuy nhi\u00ean khi s\u1eed d\u1ee5ng c\u00e1c ph\u1ea7n m\u1ec1m th\u00f4ng minh nh\u01b0 excel th\u00ec c\u0103n b\u1eadc 2 c\u00f3 hi\u1ec3n th\u1ecb kh\u00e1c v\u1edbi b\u00ecnh th\u01b0\u1eddng. Trong excel h\u00e0m c\u0103n b\u1eadc 2 c\u00f3 k\u00fd hi\u1ec7u l\u00e0 SQRT, d\u00f9ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a c\u00e1c s\u1ed1 t\u1eeb nh\u1ecf \u0111\u1ebfn to; \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p nh\u01b0 s\u1ed1 pi th\u00ec excel v\u1eabn x\u1eed l\u00fd \u0111\u01b0\u1ee3c.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tac_dung_cua_ham_can_bac_2\"><\/span><span style=\"font-weight: 400;\">T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m c\u0103n b\u1eadc 2<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_13063\" aria-describedby=\"caption-attachment-13063\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13063 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-1.jpg\" alt=\"T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m c\u0103n b\u1eadc 2\" width=\"600\" height=\"565\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-1-400x377.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13063\" class=\"wp-caption-text\">T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m c\u0103n b\u1eadc 2<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u0103n b\u1eadc 2 trong excel gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u to v\u00e0 nhanh ch\u00f3ng; v\u1edbi c\u00e1c s\u1ed1 c\u00f3 c\u0103n b\u1eadc 2 l\u1edbn.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m c\u0103n b\u1eadc 2 trong excel l\u00e0 \u0111i\u1ec3m gi\u00fap con ng\u01b0\u1eddi s\u1eed d\u1ee5ng t\u00ednh to\u00e1n d\u1ec5 d\u00e0ng h\u01a1n; kh\u00f4ng ph\u1ea3i lo r\u1eb1ng m\u00e1y t\u00ednh c\u1ea7m tay s\u1ebd kh\u00f4ng \u0111\u00e1p \u1ee9ng n\u1ed5i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m c\u0103n b\u1eadc 2 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ed9c l\u1eadp tr\u1ef1c ti\u1ebfp; ch\u1ee9 kh\u00f4ng c\u1ea7n k\u1ebft h\u1ee3p v\u1edbi h\u00e0m n\u00e0o v\u00ec th\u1ebf b\u1ea1n c\u00f3 th\u1ec3 y\u00ean t\u00e2m khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y.\u00a0<\/span><\/li>\n<\/ul>\n<p>Xem th\u00eam:<\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/\">Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?<\/a><\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\">H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_tinh_can_bac_2_trong_excel_bang_ham_SQRT\"><\/span><b>C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel b\u1eb1ng h\u00e0m SQRT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_13066\" aria-describedby=\"caption-attachment-13066\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13066 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-4-e1648947145671.jpg\" alt=\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel b\u1eb1ng h\u00e0m SQRT\" width=\"600\" height=\"253\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-4-e1648947145671.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-4-e1648947145671-400x169.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13066\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel b\u1eb1ng h\u00e0m SQRT<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng excel th\u00ec c\u00f3 th\u1ec3 nhi\u1ec1u ng\u01b0\u1eddi \u0111\u00e3 bi\u1ebft s\u1eed d\u1ee5ng; tuy nhi\u00ean \u0111\u1ec3 n\u00f3i v\u1ec1 s\u1ef1 \u0111a d\u1ea1ng c\u1ee7a c\u00e1c thao t\u00e1c th\u00ec kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng. \u0110\u1ec3 t\u00ecm c\u00f4ng th\u1ee9c t\u00ednh c\u0103n b\u1eadc 2 trong excel; b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 nh\u1eefng h\u00e0m chuy\u00ean d\u1ee5ng \u0111\u1ec3 ch\u00ednh c\u0103n b\u1eadc 2. H\u00e3y c\u00f9ng xem c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel nh\u01b0 n\u00e0o nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi ti\u1ebfn h\u00e0nh s\u1eed d\u1ee5ng h\u00e0m SQRT ta \u00e1p d\u1ee5ng thao t\u00e1c =SQRT(s\u1ed1). Trong \u0111\u00f3, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c tham chi\u1ebfu tr\u00ean cells t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 ch\u00fang ta mu\u1ed1n t\u00ednh c\u0103n b\u1eadc 2. M\u1eb7c d\u00f9 t\u00ednh b\u1eb1ng m\u00e1y m\u00f3c tuy nhi\u00ean c\u00e1c t\u00edch ch\u1ea5t c\u1ee7a h\u00e0m c\u0103n b\u1eadc 2 s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u0111\u00fang nh\u01b0 ki\u1ebfn th\u1ee9c to\u00e1n h\u1ecdc.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_SQRT_de_tinh_can_bac_2_cho_gia_tri_am\"><\/span><b>S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 cho gi\u00e1 tr\u1ecb \u00e2m<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1eb7c d\u00f9 c\u0103n b\u1eadc 2 \u0111\u01b0\u1ee3c bi\u1ebft l\u00e0 kh\u00f4ng s\u1eed d\u1ee5ng khi l\u00e0 s\u1ed1 \u00e2m; tuy nhi\u00ean c<\/span><b>\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel<\/b><span style=\"font-weight: 400;\"> v\u1edbi gi\u00e1 tr\u1ecb \u00e2m b\u1eb1ng h\u00e0m SQRT kh\u00e1 \u0111\u01a1n gi\u1ea3n. M\u1eb7c d\u00f9 khi b\u1eaft \u0111\u1ea7u thao t\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd b\u1ecb l\u1ed7i l\u00e0 #NUM; tuy nhi\u00ean trong tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta mu\u1ed1n t\u00ecm ra k\u1ebft qu\u1ea3 th\u00ec v\u1eabn c\u00f3 c\u00e1ch t\u00ednh.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ecm ra k\u1ebft qu\u1ea3 b\u1ea1n c\u1ea7n ti\u1ebfn h\u00e0nh chuy\u1ec3n s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 d\u01b0\u01a1ng trong excel; sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 nh\u01b0 b\u00ecnh th\u01b0\u1eddng. Th\u1eed k\u1ebft h\u1ee3p v\u1edbi h\u00e0m ABS \u0111\u1ec3 t\u00ecm k\u1ebft qu\u1ea3 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i nh\u00e9.\u00a0<\/span><\/p>\n<figure id=\"attachment_13065\" aria-describedby=\"caption-attachment-13065\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13065 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-3-e1648947177736.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 cho gi\u00e1 tr\u1ecb \u00e2m\" width=\"600\" height=\"249\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-3-e1648947177736.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-3-e1648947177736-400x166.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13065\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 cho gi\u00e1 tr\u1ecb \u00e2m<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_can_bac_2_trong_excel_bang_cong_thuc_mu_nhanh_chong\"><\/span><b>T\u00ednh c\u0103n b\u1eadc 2 trong excel b\u1eb1ng c\u00f4ng th\u1ee9c m\u0169 nhanh ch\u00f3ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n kh\u00f4ng hi\u1ec3u l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2; th\u00ec ch\u00fang t\u00f4i s\u1ebd \u0111em \u0111\u1ebfn cho b\u1ea1n <\/span><b>c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel<\/b><span style=\"font-weight: 400;\"> b\u1eb1ng c\u00f4ng th\u1ee9c m\u0169. B\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u0169 trong excel \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2; ngo\u00e0i ra c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c c\u0103n b\u1eadc 3, th\u1eadm ch\u00ed \u0111\u1ebfn c\u0103n b\u1eadc n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd n\u1ebfu s\u1ed1 m\u0169 l\u00e0 ph\u00e2n s\u1ed1 th\u00ec h\u00e3y b\u1ecf v\u00e0o ngo\u1eb7c \u0111\u01a1n nh\u00e9.\u00a0<\/span><\/p>\n<p>T\u00ednh c\u0103n b\u1eadc 2 b\u1eb1ng h\u00e0m POWER trong excel:<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u0103n b\u1eadc 2 trong excel, ng\u01b0\u1eddi ta s\u1eed d\u1ee5ng h\u00e0m POWER. Lo\u1ea1i h\u00e0m n\u00e0y l\u00e0 h\u00e0m s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u0169, gi\u00fap b\u1ea1n t\u00ednh to\u00e1n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n<p>H\u00e0m POWER c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<p>=POWER(number, power), trong \u0111\u00f3:<\/p>\n<ul>\n<li>power l\u00e0 s\u1ed1 m\u0169<\/li>\n<li>number l\u00e0 s\u1ed1 m\u00e0 b\u1ea1n \u0111ang c\u1ea7n t\u00ednh<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady, h\u00e0m POWER kh\u00f4ng gi\u1ed1ng v\u1edbi h\u00e0m SQRT \u1edf ch\u1ed7 l\u00e0 n\u00f3 c\u00f3 th\u1ec3 t\u00ednh c\u0103n b\u1eadc, v\u1eeba c\u00f3 th\u1ec3 t\u00ecm k\u1ebft qu\u1ea3 gi\u00e1 tr\u1ecb l\u0169y th\u1eeba c\u1ee7a m\u1ed9t s\u1ed1 n\u00e0o \u0111\u00f3. T\u1ee9c l\u00e0 h\u00e0m n\u00e0y c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb c\u0103n b\u1eadc 2 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p>V\u00ed d\u1ee5 minh h\u1ecda:<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang mu\u1ed1n t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a 64 th\u00ec c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m c\u0103n b\u1eadc 2 \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p>=POWER(64,1\/2) ho\u1eb7c =POWER(16,0.5)<\/p>\n<p>trong \u0111\u00f3: 64 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2; 1\/2 v\u00e0 0.5 l\u00e0 s\u1ed1 m\u0169 d\u00f9ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a 64.<\/p>\n<figure id=\"attachment_13064\" aria-describedby=\"caption-attachment-13064\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13064 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-2.jpg\" alt=\"T\u00ednh c\u0103n b\u1eadc 2 b\u1eb1ng h\u00e0m POWER\" width=\"600\" height=\"260\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-2-400x173.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13064\" class=\"wp-caption-text\">T\u00ednh c\u0103n b\u1eadc 2 b\u1eb1ng h\u00e0m POWER<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1eadt ra \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel kh\u00f4ng h\u1ec1 kh\u00f3 nh\u01b0 ch\u00fang ta ngh\u0129; ch\u1ec9 c\u1ea7n d\u00e0nh ch\u00fat th\u1eddi gian \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00ec b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng excel h\u1ebft s\u1ee9c th\u00e0nh th\u1ea1o. Ch\u00ednh v\u00ec th\u1ebf nh\u1eefng <\/span><b>c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c ch\u00fang t\u00f4i t\u1ed5ng h\u1ee3p v\u00e0 g\u1eedi t\u1edbi c\u00e1c b\u1ea1n. N\u1ebfu c\u00e1c b\u1ea1n c\u00f3 th\u1eafc m\u1eafc g\u00ec, h\u00e3y li\u00ean h\u1ec7 ngay cho Teky.edu.vn \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n v\u00e0 gi\u1ea3i \u0111\u00e1p nh\u00e9.\u00a0<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>N\u1ebfu \u0111\u1ec3 n\u00f3i v\u1ec1 s\u1ef1 th\u00f4ng minh c\u1ee7a con ng\u01b0\u1eddi th\u00ec ch\u00fang ta s\u1ebd d\u1ef1a v\u00e0o nh\u1eefng ph\u00e1t minh khoa h\u1ecdc v\u0129 \u0111\u1ea1i hay nh\u1eefng c\u00f4ng tr\u00ecnh ki\u1ebfn tr\u00fac \u0111\u1ed3 s\u1ed9. Ch\u00fang ta s\u1ed1ng trong x\u00e3 h\u1ed9i ph\u00e1t tri\u1ec3n th\u00ec con ng\u01b0\u1eddi c\u0169ng s\u1ebd d\u1ef1a v\u00e0o s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a c\u00f4ng ngh\u1ec7 \u0111\u1ec3 gi\u00fap cu\u1ed9c &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13062,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12437","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c<\/title>\n<meta name=\"description\" content=\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-26T00:54:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T09:23:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"325\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c\",\"datePublished\":\"2022-11-26T00:54:27+00:00\",\"dateModified\":\"2022-12-08T09:23:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\"},\"wordCount\":1913,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\",\"name\":\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg\",\"datePublished\":\"2022-11-26T00:54:27+00:00\",\"dateModified\":\"2022-12-08T09:23:02+00:00\",\"description\":\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg\",\"width\":600,\"height\":325,\"caption\":\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c","description":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9.","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:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c","og_description":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-26T00:54:27+00:00","article_modified_time":"2022-12-08T09:23:02+00:00","og_image":[{"width":600,"height":325,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c","datePublished":"2022-11-26T00:54:27+00:00","dateModified":"2022-12-08T09:23:02+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/"},"wordCount":1913,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/","name":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg","datePublished":"2022-11-26T00:54:27+00:00","dateModified":"2022-12-08T09:23:02+00:00","description":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879.jpg","width":600,"height":325,"caption":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-tinh-can-bac-2-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-tinh-can-bac-2-e1648947030879-400x217.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12437"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12437\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13062"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}