Ka yi tunanin cewa kana aiki a cikin Excel kuma kana buƙatar ƙididdige tushen tushen lamba me kake yi? Mutane da yawa za su yi amfani da kalkuleta na Windows ko ma na'urar lissafi ta zahiri don samun sakamakon, duk da haka, wannan wani abu ne da za mu iya yi daga maƙunsar bayanai. Tushen murabba'in yana da aikace-aikace da yawa a fannoni daban-daban, daga fasaha zuwa kuɗi da gini.. Don haka, a yau za mu nuna muku yadda ake sauri gano menene tushen tushen kowane lamba a cikin Excel.
Wannan tsari yana da sauƙin gaske, domin kamar yadda yake a kowane yanayi a cikin wannan shirin, kawai muna buƙatar sanin dabarar da ma'anarsa.
Menene tushen murabba'i?
Tushen murabba'in aiki ne na lissafi wanda ke ba mu damar samun lamba wanda, idan aka ninka ta da kanta, yana haifar da lambar da aka bayar.. Misali, tushen murabba'in 25 a fili yana 5, saboda idan aka ninka ta da kanta yana ba mu 25. Yana da kyau a bayyana a sarari game da wannan ra'ayi kafin mu shiga cikin batun yadda ake lissafta shi a cikin Excel, don samun mahallin game da aikin abin da muke yi
Menene aikin tushen murabba'i da ake amfani dashi?
Kamar yadda muka ambata a farkon, lissafin tushen murabba'in yana da aikace-aikace a duk wuraren da suka cancanci ayyukan lissafi. KUMAGabaɗaya, ilimin lissafi yana cikin komai don haka waɗanda suka san yadda ake gudanar da wannan aiki suna da fa'ida sosai wajen samun sakamakon da suke buƙata cikin sauri..
Alal misali, A cikin kudi akwai ma'auni mai suna Standard Deviation wanda ke ba da damar sanin bambancin saitin bayanai. Ta wannan hanyar, yana yiwuwa a san haɗarin da ke tattare da yin saka hannun jari kuma don samun sakamakon da ake tambaya, ya zama dole a mamaye aikin tushen murabba'i.
A cikin gine-gine, ana amfani da ƙididdigar tushen murabba'in don samun wurare, girma, ƙididdiga da sauran mahimman bayanai don daidaitaccen tsari na tsarin. A halin yanzu, a cikin sadarwa muna samun tushen murabba'i a cikin duk abin da ke nufin daidaitawa da watsa sigina.
Matakai don lissafin tushen murabba'i a cikin Excel
Don samun tushen murabba'in lamba a cikin Excel za mu yi amfani da aikin RAIZ. Tsarinsa yana da sauƙi da gaske kuma yana iya zama ta hanyoyi biyu:
Tushen (Lambar) ko Tushen (Cell)
A wannan ma'anar, zai isa a danna sau biyu akan wani cell mara komai, shigar da alamar daidai sannan kuma aikin, buɗe baƙaƙe sannan a danna tantanin halitta wanda ke ɗauke da lambar da muke son ƙididdige tushen tushen murabba'in ta.
A ƙarshe, danna Shigar kuma za ku sami sakamakon nan da nan.
Wata hanya don samun tushen tushe a cikin Excel
Lissafi suna ba da hanyoyi daban-daban don samun mafita iri ɗaya kuma a wannan ma'anar, akwai wata hanya don samun sakamako iri ɗaya na tsarin da ya gabata, ba tare da aikin tushen tushen ba. A wannan yanayin, za mu yi amfani da aiki inda alamar wutar lantarki za ta taimaka mana mu kai ga tushen murabba'in lambar da muka nuna.
Don wannan hanyar, danna sau biyu akan tantanin halitta mara komai kuma shigar:
= (Lambar ko Tantanin halitta mai lambar da za a lissafta)+^ (1/2)
Lokacin da aka gama, danna Shigar kuma zaku sami sakamako iri ɗaya kamar mamaye aikin ROOT.
Tare da waɗannan hanyoyi guda biyu da muke gabatar muku, zaku sami damar yin aiki tare da tushen murabba'in a cikin mafi sauri kuma mafi inganci hanya daga Excel. Sanin waɗannan hanyoyin zai ba ku damar amfani da su don hanzarta lissafin da ya kamata ku aiwatar a cikin ayyukanku na yau da kullun.
Ya kamata a lura cewa, tare da hanya ta biyu, za ku iya yin lissafin ba kawai tushen murabba'i ba, har ma da tushen cube kawai ta canza lambar 2 wanda ke gaban mahaifa na ƙarshe.