Cire tushen daga lamba wani mataki ne na yau da kullun na lissafi. Hakanan ana amfani dashi don lissafin iri-iri a cikin allunan. A Microsoft Excel, akwai hanyoyi da yawa don yin ƙididdigar wannan ƙimar. Bari muyi zurfin bincike kan zabin da za ayi don aiwatar da irin wannan lissafin a cikin wannan shirin.
Hanyoyin cirewa
Akwai manyan hanyoyi guda biyu don yin lissafin wannan alamar. Ofayansu ya dace kawai don lissafin tushen murabba'i, kuma na biyu za a iya amfani da shi don ƙididdige dabi'u na kowane digiri.
Hanyar 1: Aiwatar da Aiki
Don cire tushen square, ana amfani da aiki, wanda ake kira ROOT. Syntax kamar haka:
= GUDA (lamba)
Don amfani da wannan zaɓi, ya isa a rubuta wannan magana a cikin tantanin halitta ko a layin aikin shirin, maye gurbin kalmar "lamba" tare da takamaiman lamba ko adireshin tantanin da yake inda yake.
Don aiwatar da lissafin kuma nuna sakamakon akan allo, danna maɓallin Shiga.
Bugu da kari, zaku iya amfani da wannan dabarar ta hanyar mayewar aikin.
- Mun danna kan sel akan takardar inda za a nuna sakamakon lissafin. Je zuwa maɓallin "Saka aikin"sanya kusa da layin aikin.
- Cikin jeri dake buɗe, zaɓi TAFIYA. Latsa maballin "Ok".
- Tattaunawa ta buɗe tana buɗewa. A cikin kawai filin wannan taga, dole ne a shigar ko dai takamaiman darajar daga inda hakar zai gudana, ko kuma daidaitawar tantanin da ke inda yake. Ya isa ya danna wannan gidan domin adireshinsa ya shiga filin. Bayan shigar da bayanai, danna maballin "Ok".
A sakamakon haka, sakamakon lissafin za a nuna shi a cikin tantanin da aka nuna.
Hakanan zaka iya kiran aikin ta hanyar shafin Tsarin tsari.
- Zaɓi waya don nuna sakamakon lissafin. Je zuwa shafin "Dabaru".
- A cikin toolbar "Aikin Makaranta" akan kintinkiri, danna maballin "Ilmin lissafi". A lissafin da ya bayyana, zaɓi ƙimar TAFIYA.
- Tattaunawa ta buɗe tana buɗewa. Dukkanin abubuwan gaba gaba daya daidai suke yayin amfani da maɓallin "Saka aikin".
Hanyar 2: exponentiation
Yin amfani da wannan zaɓi ɗin da ke sama ba zai taimaka wajen ƙididdige tushen mai siffar sukari ba. A wannan yanayin, dole ne a ɗaga darajar zuwa gaɓarƙashin iko. Babban tsari na lissafin tsari shine kamar haka:
= (lamba) ^ 1/3
Wannan shine, bisa ga ƙa'idar wannan ba ma hakar ba, amma ɗaga darajar zuwa ikon 1/3. Amma wannan digiri shine tushen mai siffar sukari, don haka shine ainihin wannan matakin a cikin Excel wanda ake amfani dashi don samarwa. Madadin wata takamaiman lamba, Hakanan zaka iya shigar da daidaitawar sel tare da lambobi a cikin wannan dabara. Ana yin rikodin a kowane yanki na takarda ko a cikin layin tsari.
Kada kayi tunanin cewa wannan hanyar za'a iya amfani dashi don cire tushen mai siffar sukari daga lamba. Ta wannan hanyar, zaku iya lissafin murabba'in da kowane tushe. Amma a wannan yanayin ne kawai zaka yi amfani da wannan dabarar:
= (lamba) ^ 1 / n
n digiri ne na ƙonewa.
Don haka, wannan zaɓi yafi duniya duka amfani da hanyar farko.
Kamar yadda kake gani, duk da cewa Excel bata da aikin musamman don cire tushen zubin, ana iya aiwatar da wannan lissafin ta amfani da haɓakawa zuwa gaɓoɓin iko, wato 1/3. Kuna iya amfani da aiki na musamman don cire tushen murabba'in, amma kuma kuna iya yin wannan ta ɗaga lambar zuwa wuta. Wannan lokacin zai zama dole don daukaka zuwa ikon 1/2. Mai amfani da kansa dole ne ya ƙayyade wace hanya ta lissafi wanda yafi dacewa a gare shi.
