Yadda ake cire tushen a cikin Excel. Umarni tare da hotunan kariyar kwamfuta don cire tushen a cikin Excel

A cikin maƙunsar bayanai, ban da daidaitattun ayyukan ƙididdiga, kuna iya aiwatar da cire tushen. Daga labarin za ku koyi daidai yadda ake yin irin waɗannan ƙididdiga na lissafi a cikin ma'auni.

Hanya ta farko: ta amfani da ROOT afareta

Akwai nau'ikan masu aiki iri-iri a cikin maƙunsar bayanai na Excel. Cire tushen yana ɗaya daga cikin siffofi masu amfani. Babban tsarin aikin yayi kama da haka: = Tushen (lamba). Gabatarwa:

1. Don aiwatar da lissafi, dole ne ka shigar da dabara a cikin tantanin halitta mara komai. Wani zaɓi shine shigar da ma'aunin dabara, tun da farko an zaɓi sashin da ake buƙata.
2. A cikin brackets, dole ne ku shigar da alamar lambobi, tushen abin da za mu samu.

3. Bayan aiwatar da duk magudi, danna maɓallin "Shigar" da ke kan madannai.
4. Shirya! Ana nuna sakamakon da ake so a ɓangaren da aka riga aka zaɓa.

Kula! Maimakon alamar lambobi, zaku iya shigar da masu gudanar da tantanin halitta inda lambar kanta take.

Saka dabara ta amfani da Wizard Aiki

Yana yiwuwa a yi amfani da dabarar da ke aiwatar da cirewar tushen ta taga na musamman da ake kira "Saka aikin". Tafiya:

1. Muna zaɓar sashin da muke shirin aiwatar da duk lissafin da muke buƙata.
2. Danna maɓallin "Saka Aiki", wanda ke kusa da layin don shigar da tsarin, kuma yayi kama da "fx".

3. An nuna ƙaramin taga mai suna "Saka Aiki" akan allon. Mun bayyana babban jeri kusa da rubutun "Kategori:". A cikin jerin zaɓuka, zaɓi kashi “Mathematics”. A cikin taga "Zaɓi aiki:" mun sami aikin "ROOT" kuma zaɓi shi ta latsa LMB. Bayan aiwatar da duk manipulations, danna kan "Ok".

4. An nuna sabon taga mai suna "Ayyukan Hujja" akan allon, wanda dole ne a cika da bayanai. A cikin filin "Lambar", kuna buƙatar shigar da alamar lambobi ko kuma kawai nuna haɗin gwiwar sashin da ake adana mahimman bayanan lambobi.

5. Bayan aiwatar da duk magudi, danna maɓallin "Ok".
6. Shirya! A cikin ɓangaren da aka riga aka zaɓa, an nuna sakamakon canjin mu.

Saka aiki ta sashin "Formulas".

Koyarwar mataki-mataki tayi kama da haka:

1. Muna zaɓar tantanin halitta inda muke shirin yin duk lissafin da muke buƙata.
2. Mun matsa zuwa sashin "Formulas", wanda yake a saman maƙunsar bayanai. Mun sami wani toshe da ake kira "Laburare Ayyuka" kuma danna kan "Math" kashi.

3. An bayyana dogon jerin kowane nau'in ayyukan lissafi. Mun sami ma'aikacin mai suna "ROOT" sai a danna LMB.

4. Tagan "Hujjar Aiki" yana bayyana akan nuni. A cikin filin "Lambar", dole ne ka shigar da alamar lambobi ta amfani da madannai, ko kawai nuna ma'amalar tantanin halitta inda ake adana mahimman bayanan lambobi.
5. Bayan aiwatar da duk manipulations, danna kan "Ok".

6. Shirya! A cikin ɓangaren da aka riga aka zaɓa, an nuna sakamakon canjin mu.

Hanya ta biyu: gano tushen ta hanyar haɓakawa zuwa iko

Hanyar da ke sama tana taimakawa cikin sauƙi cire tushen murabba'in kowace ƙima na lamba. Hanyar yana dacewa da sauƙi, amma ba zai iya yin aiki tare da maganganun cubic ba. Don magance wannan matsala, wajibi ne a ɗaga alamar lambobi zuwa ƙarfin juzu'i, inda mai ƙididdigewa zai zama ɗaya, kuma ma'auni zai zama darajar da ke nuna digiri. Gabaɗayan sigar wannan ƙimar ita ce kamar haka: =(Lambar)^(1/n).

Babban fa'idar wannan hanyar ita ce, mai amfani zai iya cire tushen cikakken kowane digiri ta hanyar canza "n" a cikin ma'auni zuwa lambar da yake buƙata.

Da farko, la'akari da yadda dabarar cire tushen murabba'in yayi kama: (Lambar)^(1/2). Yana da sauƙi a gane cewa to dabarar lissafin tushen cube shine kamar haka: = (Lambar) ^ (1/3) da sauransu. Bari mu bincika wannan tsari tare da takamaiman misali. Tafiya tayi kama da haka:

1. Misali, dole ne a cire tushen cube na ƙimar lamba 27. Don yin wannan, za mu zaɓi tantanin halitta kyauta, danna shi tare da LMB kuma shigar da ƙimar mai zuwa: =27^(1/3).

2. Bayan aiwatar da duk magudi, danna maɓallin "Shigar".

3. Shirya! A cikin tantanin halitta da aka riga aka zaɓa, an nuna sakamakon canjin mu.

Ya kamata a lura cewa a nan, kamar yadda lokacin aiki tare da ROOT afareta, maimakon wani takamaiman ƙima, za ka iya shigar da daidaitawa na cell da ake bukata.

Kammalawa

A cikin maƙunsar rubutu na Excel, ba tare da wata wahala ba, zaku iya aiwatar da aikin cire tushen daga kowane ƙimar ƙima. Abubuwan da ke cikin na'ura mai kwakwalwa suna ba ka damar yin lissafi don cire tushen digiri daban-daban (square, cubic, da sauransu). Akwai hanyoyi da yawa na aiwatarwa, don haka kowane mai amfani zai iya zaɓar mafi dacewa da kansa.