{"id":1697,"date":"2020-11-03T02:28:34","date_gmt":"2020-11-02T19:28:34","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1697"},"modified":"2020-11-03T02:35:09","modified_gmt":"2020-11-02T19:35:09","slug":"tinh-can-bac-2-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/tinh-can-bac-2-trong-excel\/","title":{"rendered":"C\u00e1ch T\u00ednh C\u0103n B\u1eadc N V\u00e0 C\u0103n B\u1eadc 2 Trong Excel"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Khi s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh Excel, kh\u00f4ng ph\u1ea3i ng\u01b0\u1eddi d\u00f9ng n\u00e0o c\u0169ng \u0111\u00e3 t\u1eebng th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh l\u0169y th\u1eeba, khai c\u0103n v\u00ec ch\u00fang kh\u00f4ng th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 c\u00e1c ph\u00e9p to\u00e1n c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia.<\/span><\/p>

\u00a0<\/span><\/p>

Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd gi\u1edbi thi\u1ec7u c\u00e1ch t\u00ednh c\u0103n b\u1eadc b\u1ea5t k\u1ef3 v\u00e0 c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng to\u00e1n t\u1eed ^ (d\u1ea5u m\u0169) v\u00e0 h\u00e0m SQRT.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

1, C\u0103n B\u1eadc N V\u00e0 C\u0103n B\u1eadc 2 S\u1ed1 H\u1ecdc<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u0110\u1ea7u ti\u00ean, h\u00e3y c\u00f9ng hoctin.vn t\u00ecm hi\u1ec3u kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 c\u0103n b\u1eadc n v\u00e0 c\u0103n b\u1eadc 2 trong to\u00e1n h\u1ecdc.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

C\u0103n b\u1eadc n c\u1ee7a m\u1ed9t s\u1ed1 a l\u00e0 s\u1ed1 x sao cho x m\u0169 n b\u1eb1ng a: x<\/span>n<\/span><\/span> = a.<\/span><\/p>

C\u0103n b\u1eadc n c\u1ee7a m\u1ed9t s\u1ed1 a c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i theo m\u1ed9t c\u00e1ch kh\u00e1c, l\u00e0 l\u0169y th\u1eeba b\u1eadc 1\/n c\u1ee7a a, hay n\u00f3i c\u00e1ch kh\u00e1c th\u00ec a<\/span>1\/n<\/span><\/span> = x.<\/span><\/p>

V\u00ed d\u1ee5:<\/span><\/p>

\u221b8=2 hay 8<\/span>1\/3<\/span><\/span>=2 v\u00ec 2<\/span>3<\/span><\/span>=8;<\/span><\/p>

\u221c16=2 hay 16<\/span>1\/4<\/span><\/span>=2 v\u00ec 2<\/span>4<\/span><\/span> = 16.<\/span><\/p>

\u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

C\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 a kh\u00f4ng \u00e2m l\u00e0 s\u1ed1 x sao cho x<\/span>2<\/span><\/span> = a, hay a<\/span>1\/2<\/span><\/span> = x, v\u00ed d\u1ee5 \u221a16 = 4 v\u00ec 4 m\u0169 2 b\u1eb1ng 16.<\/span><\/p>

V\u00ec b\u00ecnh ph\u01b0\u01a1ng c\u1ee7a 2 s\u1ed1 \u0111\u1ed1i nhau x v\u00e0 -x \u0111\u1ec1u b\u1eb1ng a n\u00ean s\u1ed1 a kh\u00f4ng \u00e2m c\u00f3 hai c\u0103n b\u1eadc 2:<\/span><\/p>

– C\u0103n b\u1eadc 2 c\u1ee7a a l\u00e0 s\u1ed1 d\u01b0\u01a1ng k\u00ed hi\u1ec7u l\u00e0 \u221aa<\/span><\/p>

– C\u0103n b\u1eadc 2 c\u1ee7a a l\u00e0 s\u1ed1 \u00e2m k\u00ed hi\u1ec7u l\u00e0 -\u221aa<\/span><\/p>

– S\u1ed1 0 c\u00f3 \u0111\u00fang m\u1ed9t c\u0103n b\u1eadc hai l\u00e0 ch\u00ednh n\u00f3: \u221a0 = -\u221a0 = 0.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

2, C\u00e1ch T\u00ednh L\u0169y Th\u1eeba V\u00e0 C\u0103n B\u1eadc N C\u1ee7a M\u1ed9t S\u1ed1 Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

T\u1eeb kh\u00e1i ni\u1ec7m to\u00e1n h\u1ecdc \u1edf tr\u00ean, \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc n v\u00e0 c\u0103n b\u1eadc 2 trong Excel, c\u1ea7n s\u1eed d\u1ee5ng to\u00e1n t\u1eed d\u1ea5u m\u0169 (^) thay cho d\u1ea5u c\u0103n trong Excel.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

2.1, C\u00e1ch T\u00ednh L\u0169y Th\u1eeba Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u0110\u1ec3 t\u00ednh a m\u0169 b (a<\/span>b<\/span><\/span>) trong Excel, s\u1eed d\u1ee5ng c\u00fa ph\u00e1p =a^b<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"H\u00e0m\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

2.2, C\u00e1ch T\u00ednh C\u0103n B\u1eadc N C\u1ee7a M\u1ed9t S\u1ed1 Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Khai c\u0103n l\u00e0 ph\u00e9p to\u00e1n ng\u01b0\u1ee3c c\u1ee7a l\u0169y th\u1eeba.<\/span><\/p>

H\u00e0m c\u0103n b\u1eadc n trong Excel c\u1ee7a 1 s\u1ed1 m b\u1ea5t k\u1ef3: =m^(1\/n)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

T\u01b0\u01a1ng t\u1ef1, c\u00f4ng th\u1ee9c t\u00ednh c\u0103n b\u1eadc 2 trong Excel c\u1ee7a 1 s\u1ed1 a b\u1ea5t k\u1ef3 l\u00e0 =a^(1\/2) ho\u1eb7c =a^0.5<\/span><\/p>

C\u0103n b\u1eadc 3 trong Excel c\u1ee7a s\u1ed1 a l\u00e0: =a^(1\/3)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

V\u00ed d\u1ee5 t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 b\u1eadc 3 c\u1ee7a c\u00e1c s\u1ed1 b\u1ea5t k\u1ef3:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t