Yadda ake Shigar da Tushen Square a Excel

Gabatarwa

Excel, sanannen kayan aikin da Microsoft ya haɓaka, ana amfani da shi sosai a fagen fasaha da kasuwanci don yin hadaddun ayyukan lissafin lissafi da nazarin bayanai. Ɗayan ayyukan da masu amfani ke buƙata shine ikon yin lissafin tushen murabba'i na lamba cikin sauri da daidai. A cikin wannan labarin, za mu bincika mataki-mataki kamar yadda sanya tushen tushe a cikin Excel, Samar da masu amfani da jagora mai haske da taƙaitacce don cimma wannan.

Basic Features of Square Root a Excel

Tushen murabba'in aiki ne na lissafi wanda ke ba mu damar nemo lambar da idan aka ninka ta da kanta, tana ba mu ƙima. A cikin Excel, ⁢ yana yiwuwa a yi lissafin tushen murabba'in cikin sauri da sauƙi ta hanyar amfani da takamaiman tsari. Don sanya tushen murabba'i a cikin Excel, kawai dole ne mu yi amfani da aikin "ROOT" tare da adadin da muke son samun tushen. Misali, idan muna da lamba 25 kuma muna son nemo tushen murabba'in sa, zamu iya rubuta "= Tushen(25)" a cikin Excel cell kuma sakamakon zai zama 5. Wannan yana ba mu damar yin lissafin hadaddun ba tare da buƙatar yin aiki da hannu tare da na'urar lissafi ba.

Yana da mahimmanci a lura cewa aikin tushen murabba'in a cikin Excel kawai yana karɓar hujja ɗaya kawai, wanda shine adadin abin da muke son samun tushen. Idan muna son lissafin tushen murabba'in jerin lambobi, zamu iya amfani da aikin "TUSHE" tare da kewayon sel. Misali, idan muna da lambobi 16, 25 da ⁤36 a cikin sel A1, A2 da A3 bi da bi, za mu iya rubuta «= Tushen(A1: A3)» a cikin wani tantanin halitta kuma za mu sami lissafi a sakamakon haka. tare da murabba'in tushen lambobi. Wannan yana ba mu damar adana lokaci da ƙoƙari yayin yin ƙididdiga a cikin Excel.

Baya ga aikin "ROOT", Excel kuma yana yi mana sauran ayyuka masu alaƙa da tushen murabba'in. Misali, aikin "SCROOT" yana ba mu damar lissafin tushen murabba'i na hadadden lamba, yayin da aikin "SEXTROOT" yana ba mu damar yin lissafin tushen lamba lissafi. A taƙaice, Excel yana ba mu kayan aikin da ake buƙata don yin lissafin tushen murabba'in yadda ya kamata kuma daidai, don haka sauƙaƙe ayyukanmu na lissafi da sauƙaƙe aikinmu a cikin shirin.

Formula don lissafin tushen murabba'in a cikin Excel

Tushen murabba'i Aiki ne na lissafi wanda ke taimaka mana gano lambar da idan aka ninka ta da kanta, tana ba mu sakamakon adadin da muke son sanin tushen. A cikin Excel, zamu iya amfani da dabara mai sauƙi don ƙididdige tushen murabba'in lamba. Don lissafta tushen murabba'in a cikin Excel, dole ne mu yi amfani da aikin "ROOT"..

La aikin "TUSHEN". a cikin Excel yana ba mu damar lissafin tushen murabba'in takamaiman lamba. Don amfani da wannan aikin, muna buƙatar shigar da lambar da muke son ƙididdige tushen a cikin hujjar aikin. Misali, idan muna son nemo tushen murabba'in ⁢ 25, dole ne mu rubuta "= Tushen(25)" a cikin tantanin halitta na Excel. Ayyukan zai dawo da sakamakon tushen murabba'in, wanda a cikin wannan yanayin zai zama 5. Yana da mahimmanci a tuna cewa aikin "ROOT" kawai yana yarda da hujja guda ɗaya, don haka idan muna so mu lissafta tushen murabba'in saitin lambobi. , dole ne mu yi amfani da aikin a kowane ɗayan su.

Baya ga amfani da aikin "ROOT" a cikin Excel, Hakanan zamu iya ƙididdige tushen murabba'in lamba ta amfani da ma'aikatan lissafi. Idan mun riga mun san tsarin ƙididdiga a cikin Excel, za mu iya amfani da alamar wutar lantarki ""tare da 0.5 don lissafin tushen murabba'in. Misali, don nemo tushen murabba'in ⁣36, zamu iya rubuta "=360.5 ″. Wannan dabarar za ta ba mu sakamakon 6, wanda shine tushen murabba'in 36. Wannan zaɓin zai iya zama da amfani idan ba mu so mu yi amfani da aikin "ROOT" ko kuma idan muna son yin ƙarin ƙididdiga masu rikitarwa ta amfani da wasu ayyukan lissafi.

Yadda ake shigar da bayanai cikin dabarar tushen square

Daya daga cikin mafi amfani da na kowa ayyuka a Excel ne square tushen dabara. Ta hanyar wannan aikin, za mu iya sauri da daidai lissafin tushen murabba'in kowane lamba. Na gaba, za mu yi muku bayani a cikin Excel, ta yadda za ku iya yin ci-gaban lissafin lissafi na hanya mai inganci.

Don shigar da bayanai a cikin tsarin tushen murabba'in a cikin Excel, kawai ku bi matakai masu zuwa:

• Zaɓi tantanin halitta inda⁤ kake son sakamakon tushen murabba'in ya bayyana.
• Rubuta alamar ‌ daidai (=) sannan aikin ya biyo baya SQRT (daga Ingilishi "square ⁣ root", wanda ke nufin tushen murabba'i).
• Buɗe baka kuma ⁢ rubuta lambar da kake son ƙididdige tushen murabba'in ta.
• Rufe baka kuma latsa Shigar.

Keɓaɓɓen abun ciki - Danna nan  Waɗanne saitunan daidaitawa ne MacTuneUp Pro ke bayarwa?

Misali, idan kana so ka lissafta tushen murabba'in 25, kawai ka rubuta "= SQRT(25)" a cikin tantanin da aka zaba sannan ka danna Shigar. Sakamakon zai bayyana ta atomatik a cikin tantanin halitta, a wannan yanayin sakamakon zai zama 5. Ka tuna cewa zaku iya shigar da kowace lamba a cikin dabara don ƙididdige tushen murabba'in sa a cikin Excel. Tare da wannan tsari mai sauƙi, za ku iya ɓata lokaci da yin ƙarin hadaddun lissafin lissafi a cikin maƙunsar bayanan ku.

Yin amfani da aikin SQRT don tushen tushe⁢ a cikin Excel

Ayyukan SQRT a cikin Excel hanya ce mai inganci don ƙididdige tushen murabba'in lamba a cikin tantanin halitta. Wannan aikin yana da amfani musamman lokacin aiki tare da adadi mai yawa na bayanai kuma yana buƙatar saurin bayani na lissafi.  Don amfani da aikin SQRT a cikin Excel, kawai zaɓi tantanin halitta inda kake son sakamakon ya bayyana sannan ka rubuta "= SQRT(lambar)" ba tare da ƙididdiga ba, maye gurbin "lambar" tare da ƙimar da kake son ƙididdige tushen murabba'in.

Yana da mahimmanci a lura cewa aikin SQRT a cikin Excel yana karɓar lambobi masu kyau kawai Idan kuna ƙoƙarin ƙididdige tushen murabba'in lamba mara kyau, Excel zai dawo da kuskuren "#NUM!" Bugu da ƙari, idan an yi amfani da aikin ⁢SQRT akan tantanin halitta da ke ɗauke da rubutu ko kowane hali mara inganci, Excel zai nuna kuskuren "#VALUE!" Don haka, yana da mahimmanci don tabbatar da cewa bayanan da aka shigar suna lambobi da inganci..

Lokacin amfani da aikin SQRT a cikin Excel, zaku iya haɗa shi da wasu ayyuka don yin ƙarin ƙididdiga masu rikitarwa. Bugu da ƙari, kuna iya amfani da nassoshi tantanin halitta maimakon lambobi kai tsaye, ba ku damar yin lissafin bisa la'akari da canje-canje a cikin ƙimar sauran sel. Wannan hanyar tana ba da sassauci sosai a cikin amfani da ƙa'idodi a cikin Excel., ba ku damar yin bincike na lissafi na ci gaba kuma ku sami ingantaccen sakamako mai inganci.

Nasihu don guje wa kurakurai yayin ƙididdige tushen murabba'in a cikin Excel

: Sanin yadda ake lissafin tushen murabba'in a cikin Excel na iya zama fasaha mai amfani ga waɗanda ke aiki tare da bayanan lambobi a cikin maƙunsar rubutu. Duk da haka, yana da mahimmanci a tuna cewa akwai wasu kurakurai na yau da kullum waɗanda za a iya yi yayin yin wannan lissafin. Anan akwai wasu mahimman shawarwari don guje wa waɗannan kurakuran kuma tabbatar da cewa kun sami ingantaccen sakamako:

1. Yi amfani da aikin da ya dace: Excel yana ba da manyan ayyuka guda biyu don ƙididdige tushen murabba'in: SQRT da POWER. Aikin SQRT⁤ shine aka fi amfani dashi kuma yakamata a fi son samun tushen ⁤square na lamba. A gefe guda kuma, ana amfani da aikin POWER don ƙididdige tushen nth na lamba. Yana da mahimmanci don tabbatar da cewa kayi amfani da aikin daidai don guje wa sakamakon da bai dace ba.

2. Duba lambar mara kyau: Tushen kuskure na gama gari lokacin ƙididdige tushen murabba'in a cikin Excel yana aiki tare da lambobi mara kyau. Aikin SQRT na Excel yana dawo da kuskure (#NUM!) lokacin da aka wuce lamba mara kyau. Don haka, yana da mahimmanci koyaushe a tabbatar da cewa lambobin da aka shigar suna da inganci kafin yin lissafin. Idan kana buƙatar lissafin tushen murabba'in lamba mara kyau, dole ne ka yi amfani da aikin WUTA a maimakon haka kuma ka ƙididdige juzu'in juzu'i daidai da 1/2.

3. Yi amfani da bayanan salula: Wani muhimmin shawarwarin shine a yi amfani da nassoshin tantanin halitta maimakon shigar da lambobi kai tsaye cikin dabara. Wannan ba kawai yana sauƙaƙa don gyarawa da sabunta dabi'u ba, har ma yana guje wa kurakurai daidai lokacin aiki tare da dogayen lambobi. Ta amfani da nassoshi tantanin halitta, zaku iya tabbatar da cewa ƙimar da aka yi amfani da su a cikin lissafin tushen murabba'in daidai ne kuma babu wani zagaye mara hankali ko yanke na ƙima.

Fadada da damar da square tushen dabara a cikin Excel

Microsoft Excel kayan aiki ne mai ƙarfi da miliyoyin masu amfani ke amfani da shi a duk duniya don yin ƙididdiga da nazarin bayanai. Ko da yake Excel yana da ayyuka da yawa da aka gina a ciki, tsarin tushen murabba'in yana ɗaya daga cikin mafi yawan amfani da mahimmanci a yawancin aikace-aikace. A cikin wannan labarin, za mu bincika yadda za a tsawaita ikon ma'aunin tushen murabba'in a cikin Excel don samun mafi kyawun wannan fasalin.

Basic Tushen Tushen Formula a cikin Excel
Kafin bincika ƙarin damar, yana da mahimmanci a fahimci yadda ake amfani da tushen tushen murabba'in a cikin Excel ana amfani da wannan dabarar don ƙididdige tushen murabba'in adadin da aka bayar. Don ƙididdige tushen murabba'in takamaiman lamba a cikin tantanin halitta, kawai yi amfani da dabara = Tushen(lamba) a cikin tantanin halitta da ake so. Misali, idan kana so ka lissafta tushen murabba'in 16, zaka iya rubuta = ROOT(16) a cikin tantanin halitta kuma Excel zai baka sakamakon.

Ƙarin damar aiki tare da tsarin tushen murabba'in a cikin Excel
Baya ga ainihin dabara, Excel yana ba da ƙarin ƙarin damar yin ƙarin ayyukan ci gaba tare da tushen murabba'in. Misali, zaku iya amfani da aikin ⁤SQUAREROOT don lissafta tushen murabba'in tushen kewayon tantanin halitta maimakon lamba ɗaya ⁤. Wannan yana da amfani musamman lokacin da kuke buƙatar ƙididdige tushen murabba'in ƙima da yawa a lokaci guda. Bugu da ƙari, za ka iya hada da square tushen dabara da sauran ayyuka a cikin Excel, kamar SUM ko AVERAGE, don yin ƙarin ƙididdiga masu rikitarwa. Waɗannan ƙarin damar damar suna faɗaɗa versatility na tushen tushen murabba'in a cikin Excel kuma suna ba ku damar yin ƙarin ingantaccen bincike na bayanai.

A takaice dai, tsarin tushen murabba'i a cikin Excel kayan aiki ne mai ƙarfi don aiwatar da lissafin lissafi. Tare da fadada iyawa, zaku iya ƙididdige tushen murabba'in lamba ɗaya ko kewayon sel, kuma haɗa shi tare da wasu ayyuka don yin ƙarin ƙididdiga masu rikitarwa. Ko kuna buƙatar ƙididdige tushen murabba'in tushen bayanai guda ɗaya ko yin bincike na ƙididdiga na ci gaba, Excel yana da damar da zai taimaka muku yin aikinku.

Keɓance tsarin amsa don tushen murabba'i a cikin Excel

Ayyukan tushen murabba'in a cikin Excel yana da matukar amfani don yin lissafin lissafi. Koyaya, ta hanyar tsoho, tsarin amsawa ⁢ bai fi dacewa ba. A cikin wannan sakon, za mu koya muku yadda ake tsara tsarin amsa don tushen murabba'in a cikin Excel.

1. Canja tsarin amsawa: Don tsara tsarin amsa don tushen murabba'in a cikin Excel, kawai ku bi waɗannan matakan. Da farko, zaɓi tantanin halitta inda kake son amsar ta bayyana. Sa'an nan, je zuwa dabara bar kuma rubuta da dabara ga square tushen, ta yin amfani da "SQRT" aiki. Bayan aikin, ƙara alamar daidai (=) da lambar da kake son samun tushen murabba'in na. Misali, idan kuna son nemo tushen murabba'in 25, zaku rubuta "= SQRT(25)".

2. Daidaita adadin wurare goma: Da zarar ka rubuta dabarar tushen murabba'i, za ka iya daidaita adadin wuraren goma da aka nuna a cikin amsar. Don yin wannan, zaɓi tantanin halitta inda amsar ta bayyana kuma je zuwa kayan aiki. Danna maɓallin "Format Cells" kuma zaɓi zaɓi "Lambar". A cikin taga mai bayyana, zaɓi adadin wuraren goma da kake son nunawa a cikin amsar kuma danna "Ok." Yanzu, za a nuna amsar tushen murabba'in a cikin sigar decimal ɗin da kuka zaɓa.

3. Aiwatar da tsarin sharadi: Baya ga keɓance adadin wurare na ƙima, kuna iya amfani da tsarin sharaɗi zuwa tushen tushen murabba'in a cikin Excel. Wannan yana ba ku damar haskaka ƙimar da suka dace da wasu sharuɗɗa. Misali, zaku iya saita Excel don haskaka ƙimar da ba ta kai sifili ba a ja, yana nuna cewa sakamakon ƙima ce lamba. Don aiwatar da tsarin yanayin yanayi, zaɓi tantanin amsawa, je zuwa shafin Gida, sannan danna maɓallin Tsarin Yanayi. Na gaba, zaɓi ƙa'idar da kake son amfani da ita, kamar nuna alamar ƙima waɗanda suka fi takamaiman lamba, sannan zaɓi launuka da tsarin da kake son amfani da su. Wannan sauki!

Yin amfani da aikin SQRT a cikin kewayon sel a cikin Excel

Ayyukan SQRT a cikin Excel kayan aiki ne mai amfani sosai lokacin da kake buƙatar ƙididdige tushen murabba'in lamba a cikin kewayon sel. Yin amfani da wannan fasalin, zaku iya adana lokaci da yin ƙididdiga masu rikitarwa⁤ cikin sauƙi. Bugu da ƙari, aikin SQRT yana goyan bayan ayyuka masu yawa na lissafin lissafi a cikin Excel, yana mai da shi zaɓi mai mahimmanci.

Don amfani da aikin SQRT a cikin kewayon ƙwayoyin halitta a cikin Excel, kawai zaɓi kewayon sel waɗanda kuke son yin lissafin kuma yi amfani da dabara mai zuwa: =SQRT(cell_reference). Sauya "cell_reference" tare da ma'anar tantanin halitta wanda ya ƙunshi lambar da kake son ƙididdige tushen murabba'in. Misali, idan kuna son lissafta tushen murabba'in lamba a cikin tantanin halitta A1, dabarar zata kasance =SQRT(A1). Kuna iya jawo wannan dabara zuwa ƙasa don ƙididdige tushen murabba'in tushen lambobi da yawa a cikin kewayon sel.

Yana da mahimmanci a lura cewa aikin SQRT yana dawo da ƙimar tushen murabba'i mai kyau kawai. Idan kuna son samun ƙimar tushen tushe mara kyau, dole ne ku yi amfani da wasu ayyuka da ayyuka a cikin Excel. Hakanan, lura cewa aikin SQRT yana dawo da ƙima na goma. ⁢Idan kuna buƙatar sakamakon ya zama lamba, zaku iya amfani da aikin ROUND ko TRUNCATE don zagaye ko yanke sakamakon.

A taƙaice, aikin SQRT a cikin Excel kayan aiki ne mai ƙarfi don ƙididdige tushen murabba'in lamba a cikin kewayon sel. Sauƙin amfaninsa da juzu'in sa ya sa ya zama kyakkyawan zaɓi don yin hadadden lissafin lissafi. ⁢ Ka tuna yin amfani da dabaru da ayyuka masu dacewa don samun ainihin sakamakon da kuke buƙata kuma ku yi amfani da damar iyawar Excel.

Aikace-aikace masu amfani na tushen square a cikin Excel

:

Tushen murabba'in aiki ne na lissafi mai amfani a cikin Excel wanda ke ba mu damar nemo ƙimar murabba'in kowane lamba. Wannan aikin yana da amfani musamman wajen nazarin bayanai da ƙididdige ƙididdiga. Tare da tushen square a cikin Excel, yana yiwuwa a ƙididdige ma'auni na daidaitattun bayanan saiti, yana ba mu damar fahimtar bambancin dabi'u da kuma yanke shawara. Bugu da ƙari, wannan aikin yana da amfani wajen magance matsalolin da suka shafi kimiyyar lissafi da lissafi, inda sau da yawa muna buƙatar gano tsawon gefen triangle ko radius na da'irar.

Hanya mai sauƙi don amfani da tushen murabba'in a cikin Excel ta hanyar aikin SQRT(). Misali, idan muna so mu nemo tushen murabba'in lamba 9, zamu iya rubuta dabara = SQRT(9) a cikin tantanin halitta kuma Excel zai dawo da sakamakon, wanda a cikin wannan yanayin zai zama 3. Wannan hanyar kuma zata kasance. ana iya amfani da shi zuwa jerin lambobi, kawai ta hanyar canza bayanan tantanin halitta a cikin dabara. Bugu da ƙari, za mu iya amfani da fasalin kammalawa ta atomatik don adana lokaci da kuma guje wa kurakurai yayin yin kwafin dabarar zuwa wasu sel.

Wani aikace-aikacen mai ban sha'awa na tushen murabba'in a cikin Excel es⁤ a cikin ƙirƙirar ginshiƙi da bayanan gani. Misali, zamu iya amfani da tushen murabba'in don ƙididdigewa da wakiltar girman ƙimar akan ginshiƙi ko ginshiƙi. Wannan yana taimaka mana mu hango yadda ake rarraba bayanai da gano alamu ko abubuwan da ke faruwa. Bugu da ƙari, za mu iya amfani da aikin tushen murabba'i tare da sauran ayyukan lissafi, kamar SUM da AVERAGE, don samun ƙarin hadaddun da cikakken sakamako a cikin abubuwan da muke gani.

A taƙaice, tushen murabba'in a cikin Excel yana da aikace-aikace masu amfani da yawa a cikin nazarin bayanai, ƙididdige ƙididdiga, da duba bayanai. Ta hanyar aikin SQRT()., za mu iya lissafin tushen murabba'in lamba ko jerin lambobi. Bugu da ƙari, za mu iya amfani da wannan aikin a haɗe tare da sauran ayyukan lissafi don samun ƙarin sakamako masu rikitarwa. Tushen murabba'in kuma yana da amfani wajen zana bayanan, inda za mu iya amfani da shi don ƙididdigewa da nuna girman ƙima a kan jadawali. Ƙarfinsa da sauƙin amfani ya sa tushen tushe ya zama kayan aiki mai mahimmanci ga kowane mai amfani da Excel.

Magance matsalolin gama gari yayin ƙididdige tushen murabba'in a cikin Excel

Ɗaya daga cikin matsalolin da aka fi sani a lokacin da ake ƙididdige tushen murabba'in a cikin Excel shine lokacin da sakamakon ya kasance lambar mara kyau. Wannan saboda aikin tushen murabba'in a cikin Excel baya karɓar lambobi mara kyau azaman hujja. Domin warware wannan matsalar, Dole ne mu yi amfani da ƙarin aiki don sarrafa lambobi mara kyau. Za mu iya amfani da aikin ABS‌ don samun cikakkiyar ƙimar lambar sannan mu yi amfani da aikin tushen murabba'in. Misali, idan muna so mu lissafta tushen murabba'in -4 a cikin Excel, zamu iya amfani da dabara mai zuwa a cikin tantanin halitta: =SQRT(ABS(-4)). Wannan zai bamu sakamako mai kyau na 2.

Wata matsalar gama gari yayin ƙididdige tushen murabba'in a cikin Excel shine lokacin da muke son ƙididdige tushen murabba'in lamba babba sosai o ƙarami sosai. Excel yana da ƙayyadaddun ƙayyadaddun ƙididdiga kuma yana iya ba da sakamako mai ƙima lokacin da lambobi suka yi girma ko ƙanana. Don samun ingantaccen sakamako, zamu iya amfani da aikin ROUND a haɗe tare da aikin tushen murabba'i. Misali, idan muna son ƙididdige tushen murabba'in 123456789, zamu iya amfani da wannan dabarar a cikin tantanin halitta: = ZAGAYA(SQRT(123456789),2). Wannan zai ba mu sakamako mai ma'ana tare da daidaitattun wurare guda biyu.

Ƙarin matsala yayin ƙididdige tushen murabba'in a cikin Excel shine lokacin da muke son ƙididdige tushen murabba'in jerin lambobi a cikin shafi. Maimakon yin amfani da dabarar da hannu ga kowane tantanin halitta, za mu iya amfani da dabarar tsararru don ƙididdige tushen murabba'in duk lambobin da ke cikin ginshiƙi. duka biyun. Don yin wannan, dole ne mu zaɓi tantanin halitta inda muke son sakamakon tushen murabba'in ya bayyana, shigar da dabarar da ke gaba kuma danna CTRL + SHIFT + ENTER: ⁤ = MATRIZ.SQRT(A1:A10). Wannan zai lissafta tushen ⁤square na kowace lamba a cikin ⁤range A1: A10 kuma ya nuna sakamakon a cikin ginshiƙin da aka zaɓa ta atomatik.