Como Se Pone Raiz Cuadrada en Excel

Chiyambi

Excel, chida chodziwika bwino cha spreadsheet chopangidwa ndi Microsoft, chimagwiritsidwa ntchito kwambiri m'magawo aukadaulo ndi bizinesi kuti achite masamu ovuta komanso kusanthula deta. Chimodzi mwazinthu zomwe amafunsidwa kwambiri ndi ogwiritsa ntchito ndikutha kuwerengera raíz cuadrada ya nambala mwachangu komanso molondola. M'nkhani ino, tifufuza sitepe ndi sitepe monga ikani square root mu Excel, kupatsa ogwiritsa ntchito malangizo omveka bwino komanso achidule kuti akwaniritse izi.

Zoyambira za Square Root mu Excel

Square root ndi ntchito ya masamu yomwe imatilola kupeza nambala yomwe, ikachulukitsidwa yokha, imatipatsa mtengo wina. Mu Excel, ⁢ndizotheka kuwerengera mizu ya sikweya ⁤mwamsanga komanso mosavuta ⁢kugwiritsa ntchito njira inayake. Kuti tiyike muzu mu Excel, tiyenera kugwiritsa ntchito "ROOT" ntchito yotsatiridwa ndi nambala yomwe tikufuna kupeza mizu. Mwachitsanzo, ngati tili ndi nambala 25 ⁤ndipo tikufuna kupeza masikweya ake, titha kulemba «=ROOT(25)» mu cell ya Excel Ndipo zotsatira zake zidzakhala 5. Izi zimatithandiza kuchita mawerengedwe ovuta popanda kufunikira kochita ntchito pamanja ndi calculator.

Ndikofunika kuzindikira kuti ntchito ya square root mu Excel imangovomereza mkangano umodzi, womwe ndi nambala yomwe tikufuna kupeza muzu. Ngati tikufuna kuwerengera muzu wa sikweya wa manambala angapo, titha kugwiritsa ntchito "ROOT" pamodzi ndi mitundu⁤ yamaselo. Mwachitsanzo, ngati tili ndi manambala 16, 25 ndi ⁤36 m'maselo A1, A2 ndi A3 motsatana, ⁤ tikhoza kulemba «=ROOT(A1:A3)» ⁣ mu selo lina ndipo tidzapeza zotsatira zake mndandanda. ndi masikweya mizu ya manambala onenedwawo. Izi zimatithandiza kusunga nthawi ndi khama powerengera mu Excel.

Kuphatikiza pa ntchito ya "ROOT", Excel nayonso zimatipatsa ntchito zina zokhudzana ndi square root. Mwachitsanzo, ntchito ya "SCROOT" imatilola kuwerengera muzu wapakati wa nambala yovuta, pomwe ntchito ya "SEXTROOT" imatilola kuwerengera muzu wa nambala kuwerengera. Mwachidule, Excel imatipatsa zida zofunika kuti tichite mawerengedwe a mizu bwino ndi zolondola, motero kuwongolera ntchito zathu zamasamu ndikufewetsa ntchito yathu mu pulogalamuyi.

Fomula yowerengera mizu yayikulu mu Excel

Muzu wa square Ndi ntchito ya masamu yomwe imatithandiza kupeza chiwerengero chomwe, chikachulukitsidwa chokha, chimatipatsa chifukwa cha chiwerengero chomwe tikufuna kudziwa muzu. Mu Excel, titha kugwiritsa ntchito njira yosavuta kuwerengera mizu yayikulu ya nambala. Kuwerengera muzu wa square mu Excel, tiyenera kugwiritsa ntchito "ROOT" ntchito.

La "ROOT" ntchito mu Excel imatilola kuwerengera mizu yayikulu ya nambala inayake. Kuti tigwiritse ntchito ntchitoyi, tiyenera kuyika nambala yomwe tikufuna kuwerengera muzu muzokambirana zantchito. Mwachitsanzo, ngati tikufuna kupeza masikweya a ⁢ 25, tiyenera kulemba “= ROOT(25)” mu cell ya Excel. Ntchitoyi idzabwezera zotsatira za square root, zomwe mu nkhani iyi zikanakhala 5. Ndikofunika kukumbukira kuti ntchito ya "ROOT" imangovomereza mkangano umodzi, kotero ngati tikufuna kuwerengera mzere wa mzere wa manambala. , tiyenera kugwiritsa ntchito ntchitoyi mu iliyonse⁢ mwa iwo.

Kuphatikiza pa kugwiritsa ntchito "ROOT" mu Excel, Tithanso kuwerengera masikweya a manambala pogwiritsa ntchito masamu. Ngati tikudziwa kale ma syntax a formula mu Excel, titha kugwiritsa ntchito chizindikiro champhamvu «"pamodzi ndi 0.5 kuwerengera mizu yayikulu. Mwachitsanzo, kuti tipeze mzere wa ⁣36, titha kulemba "=360.5 ″. Fomu iyi idzatipatsa zotsatira za 6, zomwe ndi square root 36. Njirayi ingakhale yothandiza ngati sitikufuna kugwiritsa ntchito ntchito ya "ROOT" kapena ngati tikufuna kuwerengera zovuta kwambiri pogwiritsa ntchito masamu ena.

Momwe mungalowetse deta mu square root formula

Chimodzi mwazinthu zothandiza komanso zodziwika bwino mu Excel ndi njira ya square root. Kudzera mu ntchitoyi, titha kuwerengera mwachangu komanso molondola masikweya a nambala iliyonse. Kenako, tikukufotokozerani mu Excel, kuti mutha kuwerengera masamu apamwamba njira yothandiza.

Kuti mulowetse deta mumtundu wa square root mu Excel, mumangotsatira izi:

• Sankhani selo limene⁤ mukufuna kuti zotsatira za square root ziwonekere.
• Lembani chizindikiro chofanana (=) chotsatiridwa ndi ntchitoyo SQRT (kuchokera ku Chingerezi "square ⁣root", kutanthauza square root).
• Tsegulani zolembera ndi⁢ lembani nambala yomwe mukufuna kuwerengera masikweya mizu yake.
• Tsekani zolembera ndikusindikiza Enter.

Zapadera - Dinani apa  ¿Es Sublime Text un editor de código?

Mwachitsanzo, ngati mukufuna kuwerengera masikweya a 25, mumangolemba "=SQRT(25)" mu cell yomwe mwasankha ndikudina Enter. Chotsatiracho chidzangowonekera mu selo, pamenepa zotsatira zake zidzakhala 5. Kumbukirani kuti mutha kuyika nambala iliyonse mkati mwa fomula kuti muwerenge mizu yake yayikulu mu Excel. Ndi njira yosavuta ⁢ iyi, mutha ⁢ kusunga nthawi ndikuwerengera masamu ovuta kwambiri m'maspredishiti anu.

Pogwiritsa ntchito ntchito ya SQRT ya square root⁢ mu Excel

Ntchito ya SQRT mu Excel ndi ⁢njira yabwino⁤ yowerengetsera sikweya mizu ya nambala mkati mwa selo. Ntchitoyi imakhala yothandiza makamaka pogwira ntchito ndi deta yambiri komanso ikufuna njira yothetsera masamu mwamsanga. ‍ Kuti mugwiritse ntchito ntchito ya SQRT mu Excel, ingosankhani selo lomwe mukufuna kuti zotsatira ziwonekere ndikulemba "=SQRT(nambala)" popanda mawu, m'malo mwa "nambala" ndi mtengo womwe mukufuna kuwerengera muzu wapakati.

Ndikofunika kuzindikira kuti ntchito ya SQRT mu Excel imangovomereza manambala abwino Ngati muyesa kuwerengera muzu wa nambala yolakwika, Excel idzabwezera cholakwika "#NUM!" Kuonjezera apo, ngati ⁢SQRT ntchito ikugwiritsidwa ntchito pa selo yomwe ili ndi malemba kapena zilembo zina zosavomerezeka, Excel iwonetsa cholakwika "#VALUE!" Chifukwa chake, ndikofunikira kuwonetsetsa kuti zomwe zalowa ndi nambala komanso zabwino..

Mukamagwiritsa ntchito SQRT mu Excel, mutha kuyiphatikiza ndi ntchito zina kuti muwerenge zovuta kwambiri. Kuphatikiza apo, mutha kugwiritsa ntchito maumboni a cell m'malo mwa manambala achindunji, kukulolani kuti muwerenge motengera kusintha kwa ma cell ena. Njira iyi imapereka kusinthasintha kwakukulu pakugwiritsa ntchito fomula mu Excel., kukulolani kuti mufufuze masamu apamwamba ndikupeza zotsatira zolondola bwino.

Malangizo opewa zolakwika powerengera square root mu Excel

: Kudziwa kuwerengera mizu yayikulu mu Excel kumatha kukhala luso lothandiza kwa iwo omwe amagwira ntchito ndi manambala mumaspredishithi. Komabe, ndikofunika kukumbukira kuti pali zolakwika zina zomwe zingapangidwe powerengera izi. Nawa maupangiri ofunikira kuti mupewe zolakwikazo ndikuwonetsetsa⁤ kuti mupeze zotsatira zolondola:

1. Gwiritsani ntchito⁢ yoyenera: Excel imapereka ntchito zazikulu ziwiri zowerengera mizu yayikulu: SQRT ndi MPHAMVU. Ntchito ya SQRT⁤ ndiyomwe imagwiritsidwa ntchito kwambiri ndipo iyenera kukondedwa kuti mupeze ⁤square root ya nambala. Kumbali ina, ntchito ya MPHAMVU imagwiritsidwa ntchito kuwerengera muzu wa nambala. Ndikofunika kuwonetsetsa ⁢kuti mumagwiritsa ntchito moyenera kuti mupewe zotsatira zolakwika.

2. Chongani nambalayi: Gwero lazolakwika powerengera square root mu Excel likugwira ntchito ndi manambala olakwika. Ntchito ya SQRT ya Excel imabweretsa cholakwika (#NUM!) ikadutsa nambala yolakwika. Chifukwa chake, ndikofunikira nthawi zonse kutsimikizira kuti manambala omwe adalowa ndi abwino musanawerenge. Ngati mukufuna kuwerengetsa square root⁤ ya nambala yotsutsa, muyenera kugwiritsa ntchito mphamvu ya MPHAMVU m'malo mwake ndikutchula gawo lofanana ndi 1/2.

3. Gwiritsani ntchito maumboni a ma cell: Lingaliro lina lofunikira ndikugwiritsa ntchito maumboni a cell m'malo moyika manambala mwachindunji mu fomula. Izi sizimangopangitsa kuti zikhale zosavuta kusintha ndikusintha zikhalidwe, komanso zimapewa zolakwika zolondola mukamagwira ntchito ndi manambala aatali. Pogwiritsa ntchito maumboni a cell, mutha kuwonetsetsa kuti zomwe zimagwiritsidwa ntchito powerengera mizu ndi zolondola ndipo palibe kuzunguliridwa mosadziwa kapena kuchepetsedwa kwa ma decimals.

Kuwonjezera mphamvu za square root formula mu Excel

Microsoft Excel ndi chida champhamvu chomwe chimagwiritsidwa ntchito ndi mamiliyoni a ogwiritsa ntchito padziko lonse lapansi kuwerengera ndikusanthula deta. Ngakhale Excel ili ndi ntchito zambiri zomangidwira, mawonekedwe a square root ndi amodzi omwe amagwiritsidwa ntchito kwambiri komanso ofunikira pamapulogalamu ambiri. M'nkhaniyi, tiwona momwe tingakulitsire luso la square root formula mu Excel kuti tipindule kwambiri ndi izi.

Basic Square Root Formula mu Excel
Musanalowe muzowonjezera, ndikofunikira kumvetsetsa momwe fomula yoyambira masikweya imagwiritsidwira ntchito mu Excel Fomula iyi imagwiritsidwa ntchito kuwerengera masikweya a nambala yoperekedwa. Kuti muwerenge muzu wa sikweya wa nambala yotchulidwa mu ⁢selo, ingogwiritsani ntchito fomula = ROOT(nambala) mu cell yomwe mukufuna. Mwachitsanzo, ngati mukufuna kuwerengera muzu wa 16, mutha kulemba = ROOT(16) mu cell ndipo Excel ikupatsani zotsatira.

Zowonjezera zowonjezera ndi square root formula mu Excel
Kuphatikiza pa fomula yoyambira, Excel imaperekanso zina zowonjezera kuti mugwire ntchito zapamwamba kwambiri ndi square root. Mwachitsanzo,⁤ mutha ⁢kugwiritsa ntchito ⁤SQUAREROOT kuti muwerengere mzere wapakati wa a gulu la maselo m'malo mwa nambala imodzi ⁤. Izi ndizothandiza makamaka mukafunika kuwerengera mizu yamitundu ingapo nthawi imodzi. Kuphatikiza apo, mutha kuphatikiza mawonekedwe a square root ndi ena ntchito mu Excel, monga SUM kapena AVERAGE, kuti muwerenge zovuta kwambiri. Kuthekera kowonjezera uku kumakulitsa kusinthasintha kwa mawonekedwe a square root mu Excel ndikukulolani kuti muthe kusanthula deta mwaukadaulo kwambiri.

Mwachidule, mawonekedwe a square root mu Excel ndi chida champhamvu chowerengera masamu. Ndi kuthekera kokulitsidwa, mutha kuwerengera masikweya a nambala imodzi kapena ma cell angapo, ndikuphatikiza ndi ntchito zina kuti muwerenge movutikira. Kaya mukufunika kuwerengera muzu wapakati pa mfundo imodzi kapena kusanthula kwapamwamba, Excel ili ndi kuthekera kokuthandizani kugwira ntchito yanu.

Sinthani mawonekedwe a mayankho a square root mu Excel

Ntchito ya square root mu Excel ndiyothandiza kwambiri powerengera masamu. Komabe, mwachisawawa, mtundu wa mayankho ⁢sioyenera kwambiri. Mu positi iyi, tikuphunzitsani momwe mungasinthire makonda a mayankho amtundu wa square mu Excel.

1. Sinthani mayankhidwe: ⁢Kuti musinthe mawonekedwe a mayankho a muzu wa square mu Excel, muyenera kungotsatira izi. Choyamba, sankhani selo lomwe mukufuna kuti yankho liwonekere. Kenako, pitani ku bar ya formula ndikulemba fomula ya square root, pogwiritsa ntchito "SQRT". Pambuyo pa ntchitoyi, yonjezerani chizindikiro chofanana (=) ndi nambala yomwe mukufuna kuti mupeze mzere wapakati. Mwachitsanzo, ngati mukufuna kupeza masikweya a 25, mungalembe "=SQRT(25)".

2. Sinthani⁢ kuchuluka kwa malo: Mukalemba chilinganizo cha square root, mutha kusintha kuchuluka kwa malo omwe akuwonetsedwa muyankho. Kuti muchite izi, sankhani selo lomwe yankho likuwonekera ndikupita ku toolbar. Dinani "Format Maselo" batani ndi kusankha "Nambala" njira. Pazenera lowonekera, sankhani kuchuluka kwa malo omwe mukufuna kuwonetsa mu yankho ndikudina "Chabwino." Tsopano, yankho la square root liwonetsedwa mumtundu wa decimal womwe mwasankha.

3. Ikani masanjidwe okhazikika: Kuphatikiza pakusintha kuchuluka kwa malo a decimal, mutha kugwiritsanso ntchito masanjidwe okhazikika ku yankho la square root mu Excel. Izi zimakupatsani mwayi wowunikira zomwe zimakwaniritsa zinthu zina. Mwachitsanzo, mutha kusintha Excel kuti iwonetsere zomwe zili zocheperapo ziro zofiira, zomwe zikuwonetsa kuti zotsatira zake ndi nambala yongoyerekeza. Kuti mugwiritse ntchito masanjidwe okhazikika, sankhani foni yoyankha, pitani ku tabu Yanyumba, ndikudina batani la Conditional Formatting. Kenako, sankhani lamulo lomwe mukufuna kugwiritsa ntchito, monga kuwunikira zomwe zili zazikulu kuposa nambala inayake, ndikusankha mitundu ndi masanjidwe omwe mukufuna kugwiritsa ntchito. Zosavuta zimenezo!

Kugwiritsa ntchito SQRT m'maselo osiyanasiyana mu Excel

Ntchito ya SQRT mu Excel ndi chida chothandiza kwambiri mukafuna kuwerengera muzu wa nambala m'magulu osiyanasiyana. Pogwiritsa ntchito izi, mutha kusunga nthawi ndikuwerengera zovuta⁤ mosavuta. Kuphatikiza apo, ntchito ya SQRT imathandizira masamu osiyanasiyana mu Excel, ndikupangitsa kuti ikhale yosunthika kwambiri.

Kuti mugwiritse ntchito ntchito ya SQRT mumitundu ingapo maselo mu Excel, ingosankhani kuchuluka kwa ma cell omwe mukufuna kuwerengera ⁢ndi kugwiritsa ntchito njira iyi: =SQRT(cell_reference). Bwezerani "cell_reference" ndi chilozera cha selo lomwe lili ndi nambala yomwe mukufuna kuwerengera square root. Mwachitsanzo, ngati mukufuna kuwerengera muzu lalikulu la nambala mu selo A1, njirayo ingakhale =SQRT(A1). Mutha kukokera fomulayi pansi kuti muwerenge muzu wa square wa manambala angapo m'magulu osiyanasiyana.

Ndikofunikira kudziwa kuti ntchito ya SQRT imangobweza mtengo wa sikweya wokwanira. ⁢Ngati mukufuna kupeza mtengo wa mizu yoyipa, muyenera kugwiritsa ntchito ntchito zina mu Excel. Komanso, dziwani kuti ntchito ya SQRT imabwezeretsa mtengo wa decimal. ⁢Ngati mukufuna kuti chotsatira chikhale chowerengeka, mutha kugwiritsa ntchito ROUND kapena TRUNCATE kuti muzungulire kapena kuchepetsa zotsatira zake.

Mwachidule, ntchito ya SQRT mu Excel ndi chida champhamvu chowerengera mizu yayikulu ya nambala m'maselo osiyanasiyana. Kusavuta kwake kugwiritsa ntchito komanso kusinthasintha kwake kumapangitsa kukhala chisankho choyenera powerengera masamu ovuta. ⁢ Kumbukirani kugwiritsa ntchito mafomu oyenerera ndi ntchito kuti mupeze zotsatira zomwe mukufuna ndikugwiritsa ntchito bwino luso la Excel.

Kugwiritsa ntchito kwa square root mu Excel

:

Square root ndi ntchito yothandiza masamu mu Excel yomwe imatilola kupeza masikweya a nambala iliyonse. Ntchitoyi ndiyothandiza makamaka pakusanthula deta komanso kuwerengera ziwerengero. Ndi square root mu Excel, ndizotheka kuwerengera kusokonekera kwa seti ya data, zomwe zimatilola kumvetsetsa kusiyanasiyana kwamitengo ndikupanga zisankho zodziwitsidwa. Kuphatikiza apo, ntchitoyi imathandizanso kuthetsa mavuto okhudzana ndi sayansi ndi geometry, pomwe nthawi zambiri timafunikira kupeza kutalika kwa mbali ya makona atatu kapena utali wa bwalo.

Njira yosavuta yogwiritsira ntchito square root mu Excel kudzera mu SQRT () ntchito. Mwachitsanzo, ngati tikufuna kupeza muzu wapakati wa nambala 9, titha kulemba chilinganizo = SQRT(9) mu selo ndipo Excel idzabwezera zotsatira, zomwe mu nkhani iyi zikanakhala 3. Njira iyi idzakhalanso ingagwiritsidwe ntchito ku mndandanda wa manambala, pongosintha maumboni a cell mu fomula. Kuphatikiza apo, titha kugwiritsa ntchito chojambulira chokhacho kuti tisunge nthawi ndikupewa zolakwika pokopera fomula kumaselo ena.

Ntchito ina yosangalatsa ya square root mu Excel es⁤ popanga ma chart ndi zowonera. Mwachitsanzo, titha kugwiritsa ntchito sikweya mizu kuwerengera ndikuyimira kukula kwamitengo pa tchati kapena tchati chobalalitsa. Izi zimatithandiza kuwona m'maganizo mwathu kugawidwa kwa deta ndikuzindikira machitidwe kapena machitidwe. Kuphatikiza apo, titha kugwiritsanso ntchito square root function kuphatikiza ndi masamu ena, monga SUM ndi AVERAGE, kuti tipeze zotsatira zovuta komanso zatsatanetsatane pazowonera zathu.

Mwachidule, square root mu Excel ili ndi ntchito zambiri pakusanthula deta, kuwerengera ziwerengero, ndi ⁢kuwonera zambiri. Kudzera mu SQRT () ntchito, titha kuwerengera muzu lalikulu la nambala kapena mndandanda wa manambala. Kuphatikiza apo, titha kugwiritsa ntchito ntchitoyi kuphatikiza ndi masamu ena kuti tipeze zotsatira zovuta. Mizu yayikulu imathandizanso pazithunzi za graphing, pomwe titha kuigwiritsa ntchito kuwerengera ndikuwonetsa kukula kwamitengo pa graph. Kusinthasintha kwake komanso kugwiritsa ntchito mosavuta kumapangitsa⁢ muzu waukulu kukhala chida chofunikira kwa aliyense wogwiritsa ntchito Excel.

Kuthetsa mavuto wamba powerengera square root mu Excel

Limodzi mwamavuto omwe amapezeka kwambiri powerengera masikweya mu Excel ndi pomwe zotsatira zake ndi nambala yolakwika. Izi ndichifukwa choti square root ntchito mu Excel savomereza manambala olakwika ngati mkangano. Za kuthetsa vutoli, tiyenera kugwiritsa ntchito zina kuti tigwire manambala olakwika. Titha kugwiritsa ntchito ntchito ya ABS kuti tipeze mtengo wokwanira wa nambalayo ndikuyika ntchito ya square root. Mwachitsanzo, ngati tikufuna kuwerengera muzu wa -4 mu Excel, titha kugwiritsa ntchito fomula ili muselo: =SQRT(ABS(-4)). Izi zitipatsa zotsatira zabwino za 2.

Vuto linanso lodziwika powerengera square root mu Excel ndi pamene tikufuna kuwerengera muzu wa nambala chachikulu kwambiri o⁤ yaying'ono kwambiri. Excel ili ndi malire owerengera ndipo imatha kupereka zotsatira zofananira zikakhala zazikulu kapena zazing'ono. ⁢Kuti tipeze zotsatira zolondola, titha kugwiritsa ntchito RoundUD kuphatikiza ndi square root function.⁤ Mwachitsanzo, ngati tikufuna ⁢kuwerengetsa sikweya mizu ya 123456789, titha kugwiritsa ntchito⁢ njira iyi mu selo: =ROUND(SQRT(123456789),2). Izi zidzatipatsa chifupikitso chokhala ndi malo awiri olondola.

Vuto linanso powerengera masikweya mu Excel ndipamene tikufuna kuwerengera mizu yayikulu ya manambala angapo pamzere. M'malo mogwiritsa ntchito fomula ⁢pamanja pa selo lililonse, titha kugwiritsa ntchito fomula yofananira kuti tiwerengere muzu wa sikweya wa manambala onse mu ⁤gawo. zonse ziwiri. Kuti tichite izi, tiyenera kusankha selo lomwe tikufuna kuti zotsatira za square root ziwonekere, lowetsani ndondomekoyi ndikusindikiza CTRL+SHIFT+ENTER: ⁤ =MATRIZ.SQRT(A1:A10). Izi ziwerengera ⁤muzu wa sikweya wa nambala iliyonse mu ⁤mtundu wa A1: A10 ndikuwonetsa zokha zomwe zili mugawo losankhidwa.