Tare da ƙididdige ƙididdiga akai-akai a cikin tebur na Excel, mai amfani zai fuskanci buƙatar ƙima wasu lambobi. Ana yin irin wannan hanya sau da yawa wajen magance matsaloli daban-daban. - daga lissafi mai sauki zuwa hadadden lissafin injiniya. Koyaya, duk da mahimmancin amfani da wannan aikin, Excel ba shi da wata dabara ta daban wacce zaku iya yin ƙima daga sel. Don yin wannan, kuna buƙatar koyon yadda ake amfani da tsarin gaba ɗaya, wanda aka tsara don haɓaka lambobi ɗaya ko hadaddun ƙimar dijital zuwa iko daban-daban.

Ka'idar lissafin murabba'in lamba

Kafin ka gano yadda ake haɓaka ƙimar lambobi daidai zuwa iko na biyu ta hanyar Excel, kuna buƙatar tuna yadda wannan aikin lissafin ke aiki. Madaidaicin lamba wata takamaiman lamba ce wacce aka ninka ta kanta.. Don aiwatar da wannan aikin lissafi ta amfani da Excel, zaku iya amfani da ɗayan hanyoyin tabbatarwa guda biyu:

• amfani da aikin lissafi WUTA;
• aikace-aikacen dabarar da aka nuna alamar ma'anar "^" tsakanin dabi'u.

Kowane ɗayan hanyoyin dole ne a yi la'akari dalla-dalla a aikace.

Formula don ƙididdigewa

Hanya mafi sauƙi don ƙididdige murabba'in adadin lambobi da aka bayar ita ce ta wata dabara mai alamar digiri. Siffar dabarar: =n^2 ku. N shine kowace lamba ko ƙima wacce za'a ninka ta da kanta don squaring. A wannan yanayin, ana iya ƙayyade ƙimar wannan hujja ko dai ta hanyar haɗin gwiwar salula, ko kuma ta takamaiman bayanin lamba.

Don fahimtar yadda za a yi amfani da dabara daidai don samun sakamakon da ake so, ya zama dole a yi la'akari da misalai masu amfani guda 2. Zaɓin yana nuna ƙayyadaddun ƙima a cikin dabara:

1. Zaɓi tantanin halitta inda za a nuna sakamakon lissafin. Yi alama da LMB.
2. Rubuta dabarar wannan tantanin halitta a cikin layi na kyauta kusa da alamar "fx". Misali mafi sauƙin tsari: =2^2.
3. Kuna iya rubuta dabarar a cikin tantanin halitta da aka zaɓa.

4. Bayan haka, dole ne ka danna "Enter" saboda sakamakon lissafin da aikin ya bayyana a cikin tantanin halitta mai alama.

Zaɓin da ke nuna daidaitawar tantanin halitta, adadin wanda dole ne a ɗaga shi zuwa ƙarfi na biyu:

1. Kafin rubuta lamba 2 a cikin tantanin halitta sabani, misali B

2. Zaɓi ta latsa LMB tantanin halitta inda kake son nuna sakamakon lissafin.
3. Rubuta harafin farko "=", bayan haka - daidaitawar tantanin halitta. Ya kamata su haskaka ta atomatik cikin shuɗi.
4. Bayan haka, kuna buƙatar shigar da alamar “^”, lambar digiri.
5. Mataki na ƙarshe shine danna maɓallin "Shigar" don samun sakamakon da ake so.

Muhimmin! Tsarin da aka gabatar a sama shine na duniya. Ana iya amfani da shi don haɓaka ƙimar lambobi zuwa iko daban-daban. Don yin wannan, kawai maye gurbin lambar bayan alamar "^" tare da abin da ake buƙata.

Aikin POWER da aikace-aikacen sa

Hanya ta biyu, wacce ake ganin ta fi rikitarwa ta fuskar squaring wani lamba, ta hanyar aikin POWER. Ana buƙatar don ɗaga ƙima daban-daban a cikin sel na teburin Excel zuwa ikon da ake buƙata. Bayyanar gabaɗayan dabarar lissafi mai alaƙa da wannan ma'aikaci: = WUTA (lambar da ake buƙata, iko). Ƙarin bayani:

1. Matsayin shine hujja na biyu na aikin. Yana nuna takamaiman mataki don ƙarin ƙididdige sakamakon daga lambobi na farko ko ƙimar lambobi. Idan kana buƙatar buga murabba'in lamba, kana buƙatar rubuta lamba 2 a wannan wuri.
2. Lambar ita ce hujja ta farko na aikin. Yana wakiltar ƙimar lambobi da ake so wanda za'a yi amfani da tsarin squaring na lissafi. Ana iya rubuta shi azaman daidaitawar tantanin halitta tare da lamba ko takamaiman lambobi.

Hanyar haɓaka lamba zuwa wuta ta biyu ta aikin POWER:

1. Zaɓi tantanin halitta na tebur wanda za a nuna sakamakon bayan lissafin.
2. Danna alamar don ƙara aiki - "fx".
3. Ya kamata taga “Wizard Aiki” ya bayyana a gaban mai amfani. Anan kana buƙatar buɗe nau'in da ya riga ya kasance, zaɓi "Mathematics" daga lissafin da ke buɗewa.

4. Daga jerin masu aiki da aka tsara, kuna buƙatar zaɓar "DEGREE". Tabbatar da zaɓi ta danna maɓallin "Ok".
5. Na gaba, kuna buƙatar kafa hujjar ayyuka guda biyu. A cikin filin kyauta "Lambar" kuna buƙatar shigar da lamba ko ƙimar da za a ɗaga zuwa wuta. A cikin filin kyauta "Degree" dole ne ku ƙayyade digirin da ake buƙata (idan wannan squaring - 2).
6. Mataki na ƙarshe shine kammala lissafin ta latsa maɓallin Ok. Idan an yi komai daidai, ƙimar da aka shirya za ta bayyana a cikin tantanin halitta da aka zaɓa a gaba.

Yadda ake ɗaga lamba zuwa wuta ta amfani da haɗin gwiwar salula:

1. A cikin tantanin halitta daban, shigar da lambar da za a yi murabba'i.
2. Na gaba, saka aiki a cikin wani tantanin halitta ta hanyar "Mayen Aiki". Zaɓi "Mathematics" daga lissafin, danna kan aikin "DEGREE".
3. A cikin taga da ke buɗe, inda ya kamata a ƙayyade gardamar aikin, dole ne ku shigar da wasu ƙima, sabanin hanyar farko. A cikin filin kyauta "Lambar" dole ne ka ƙayyade ma'auni na tantanin halitta wanda ƙimar lambobi ya tashi zuwa ikon yana samuwa. An shigar da lamba 2 a filin kyauta na biyu.

4. Ya rage don danna maɓallin "Ok" kuma samun sakamakon da aka gama a cikin tantanin halitta mai alama.

Kada mu manta cewa aikin WUTA gabaɗaya ne, ya dace da haɓaka lambobi zuwa iko daban-daban.

Kammalawa

Dangane da kididdigar hukuma, a tsakanin sauran ayyukan lissafi, masu amfani da ke aiki a cikin maƙunsar bayanai na Excel suna da ƙimar ƙima daban-daban sau da yawa fiye da yadda suke aiwatar da wasu hanyoyin daga wannan rukunin. Koyaya, saboda gaskiyar cewa babu wani aiki daban don wannan aikin a cikin shirin, zaku iya amfani da wata dabarar daban wacce aka maye gurbin lambar da ake buƙata a ciki, ko kuma kuna iya amfani da ma'aikacin POWER daban, wanda ke akwai don zaɓar daga cikin Mayen Aiki.