Ƙara lamba zuwa ƙarfi a cikin Excel

Ɗaya daga cikin ayyukan lissafi na yau da kullum shine haɓaka lamba zuwa iko, wanda ke ba ka damar magance matsaloli masu yawa (ilimin lissafi, kudi, da dai sauransu). Tun da Excel kayan aiki ne mai ƙarfi don aiki tare da bayanan lambobi, ba shakka, yana ba da irin wannan aiki mai amfani da mahimmanci. Don haka, bari mu ga yadda ake ɗaga lamba zuwa wuta a cikin shirin.

Hanyar 1: Amfani da Hali na Musamman

Za mu fara da hanyar da aka fi sani, wato yin amfani da dabara mai alama ta musamman "^". 

Gabaɗaya, dabarar tana kama da haka:

=Число^n

• Number ana iya wakilta azaman takamaiman lamba ko azaman nuni ga tantanin halitta mai ɗauke da ƙimar lamba.
• n shine ikon da aka ɗaga lambar da aka bayar.

Misali 1

Bari mu ce muna buƙatar ɗaga lamba 7 zuwa cube (watau zuwa iko na uku). Don yin wannan, muna tsayawa a kowane tantanin halitta na tebur, sanya alamar daidai kuma rubuta magana: =7^3.

Bayan an shirya dabarar, danna maɓallin Shigar akan madannai kuma sami sakamakon da ake so a cikin tantanin halitta da aka zaɓa.

Misali 2

Ƙaddamarwa na iya zama wani ɓangare na ƙarin hadaddun maganganun lissafi wanda ya ƙunshi ayyuka da yawa. A ce muna buƙatar ƙara zuwa lamba 12 lambar da aka samu ta hanyar ɗaga lamba 7 zuwa cube. Wannan shine yadda magana ta ƙarshe zata kasance kamar haka: =12+7^3.

Muna rubuta dabarar a cikin tantanin halitta kyauta, kuma bayan dannawa Shigar muna samun sakamako.

Misali 3

Kamar yadda muka ambata a sama, maimakon takamaiman ƙididdiga, nassoshi ga sel tare da bayanan lambobi na iya shiga cikin lissafin. Bari mu ce muna buƙatar haɓaka dabi'u a cikin sel na wani ginshiƙin tebur zuwa iko na biyar.

1. Muna zuwa tantanin halitta na ginshiƙi inda muke shirin nuna sakamakon kuma mu rubuta a cikinsa dabarar haɓaka lamba daga ginshiƙi na asali (a cikin layi ɗaya) zuwa ikon da ake so. A cikin yanayinmu, dabarar ta yi kama da: =A2^5.
2. Latsa madannin Shigardon samun sakamako.
3. Yanzu ya rage don shimfiɗa dabarar zuwa ragowar sel na ginshiƙi da ke ƙasa. Don yin wannan, matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta tare da ƙididdige sakamakon, lokacin da mai nuni ya canza zuwa alamar daɗaɗɗen baki (cika alama), riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi ƙasa zuwa tantanin halitta na ƙarshe don haka. muna so mu yi irin wannan lissafin.
4. Da zaran mun saki maɓallin linzamin kwamfuta na hagu, ƙwayoyin ginshiƙan suna cika ta atomatik da bayanai, wato, lambobi waɗanda aka ɗaga zuwa ƙarfi na biyar daga asalin ginshiƙi.

Hanyar da aka bayyana tana da sauƙi kuma mai sauƙi, wanda shine dalilin da ya sa ya fi shahara tsakanin masu amfani. Amma akwai wasu hanyoyi banda shi. Mu duba su ma.

Hanyar 2: Aikin WUTA

A cikin wannan sashe, za mu mai da hankali kan aikin WUTA, wanda ke ba ka damar haɓaka lambobi zuwa ikon da ake so.

Tsarin Aiki WUTA mai bi:

=СТЕПЕНЬ(Число;Степень)

Ga yadda ake aiki da shi:

1. Je zuwa tantanin halitta wanda muke shirin yin lissafin kuma danna maɓallin "Saka aikin" (fx) zuwa hagu na mashayin dabara.
2. A cikin taga bude Abubuwan da ake sakawa zabi nau'i "Mathematical", a cikin jerin da ke ƙasa mun sami mai aiki "DEGREE", danna shi, sannan a kan maballin OK.
3.  Za mu ga taga don cika hukunce-hukuncen aikin:
   • A matsayin hujja darajar "Lambar" Kuna iya ƙididdige ƙayyadaddun ƙima na lamba biyu da kuma nuni ga tantanin halitta. Ana iya shigar da adireshin tantanin halitta da hannu ta amfani da maɓallan da ke kan madannai. Ko kuma za ku iya danna hagu a filin don shigar da bayanai sannan ku danna tantanin da ake so a cikin tebur.
   • Ma'ana "Digiri" muna rubuta lambar, wanda, bisa ga sunan gardama, shine ikon da muke shirin ɗaga ƙimar lambobi da aka ƙayyade a cikin gardama. "Lambar".
   • Lokacin da aka cika duk bayanan, danna OK.
4. Muna samun sakamakon haɓaka lambar zuwa ƙayyadadden iko.

A cikin yanayin lokacin maimakon takamaiman ƙima, ana amfani da adireshin tantanin halitta:

1. Tagan gardamar aiki yayi kama da haka (la'akari da bayananmu):
2. Tsarin ƙarshe a wannan yanayin shine kamar haka: =СТЕПЕНЬ(A2;3).
3. Kamar yadda a cikin hanyar farko, sakamakon za a iya mika shi zuwa ragowar sel na ginshiƙi.

Maimakon takamaiman ƙima a cikin hujjar aiki "Digiri", Hakanan zaka iya amfani da bayanin tantanin halittaduk da haka, wannan ba kasafai ake amfani da shi ba:

1. Kuna iya cika taga gardama ko dai da hannu ko ta danna kan tantanin halitta da ake so a cikin tebur - kama da cika gardamar. "Lambar".
2. A wajenmu, dabarar ta yi kama da haka: =СТЕПЕНЬ(A2;B2).
3. Mika sakamakon zuwa wasu layi ta amfani da rikon cika.

lura: gudu Mayen aiki yana yiwuwa ta wata hanya dabam. Canja zuwa shafin "Formulas", a cikin sashin kayan aiki "Labarun Ayyuka" danna maballin "Mathematical" kuma zaɓi abu daga lissafin "DEGREE".

Hakanan, wasu masu amfani sun fi son amfani da taga Mayukan Ayyuka da kafa hujjojinsa, nan da nan ya rubuta tsarin ƙarshe na aikin a cikin tantanin halitta da ake so, yana mai da hankali kan ma'anarsa.

Babu shakka, wannan hanya ta ɗan fi rikitarwa fiye da ta farko. Amma a wasu lokuta, yana zama ba makawa idan dole ne ka yi hulɗa da hadaddun ayyuka waɗanda suka haɗa da masu aiki da yawa a lokaci guda.

Hanyar 3: Amfani da Tushen Square

Tabbas, wannan hanyar ba ta shahara tsakanin masu amfani ba, amma kuma ana amfani da ita a wasu lokuta lokacin da kuke buƙatar haɓaka lamba zuwa ikon 0,5 (a wasu kalmomi, ƙididdige tushen murabba'in sa).

A ce kana so ka ɗaga lamba 16 zuwa ikon 0,5.

1. Jeka tantanin halitta inda muke shirin lissafin sakamakon. Danna maɓallin "Saka aikin" (fx) kusa da mashayin dabara.
2. A cikin taga aikin sakawa, zaɓi afareta "Tushen", wanda ke cikin rukuni "Mathematical".
3. Wannan aikin yana da hujja ɗaya kawai. "Lambar", Tun da shi tare da shi za ku iya yin aikin lissafi ɗaya kawai - cire tushen murabba'in ƙayyadadden ƙima. Kuna iya ƙayyade takamaiman lamba da hanyar haɗi zuwa tantanin halitta (da hannu ko ta danna maɓallin linzamin kwamfuta na hagu). Danna lokacin da aka shirya OK.
4. Za a nuna sakamakon lissafin aikin a cikin tantanin halitta da aka zaɓa.

Muna rubuta lambar a cikin mai magana a cikin tantanin halitta

Wannan hanyar ba ta nufin yin lissafin lissafi kuma ana amfani da ita don rubuta lamba tare da digiri a cikin tantanin halitta da aka bayar.

1. Da farko kuna buƙatar canza tsarin tantanin halitta zuwa "Rubutu". Don yin wannan, danna-dama akan abin da ake so kuma zaɓi abu a cikin menu na mahallin da ya buɗe. "Format Cell".
2. Kasancewa a cikin shafin "Lambar" danna abu "Rubutu" a cikin tsarin da aka tsara sannan kuma - ta danna maɓallin OK.lura: zaka iya canza tsarin tantanin halitta a cikin shafin "Gida" a cikin babban shirin taga. Don yin wannan, danna kan zaɓi na yanzu a cikin sashin kayan aikin. "Lambar" (default - "Janar") kuma zaɓi abin da ake buƙata daga lissafin da aka tsara.
3. Mun fara rubuta lambar a cikin tantanin halitta da farko, sannan digirinsa. Bayan haka, zaɓi lambobi na ƙarshe tare da maɓallin linzamin kwamfuta na hagu.
4. Ta danna hade Ctrl + 1 Muna shiga cikin taga tsarin salula. A cikin toshe siga "canji" duba akwatin kusa da zabin "Superscript", sannan danna OK.
5. Muna samun daidaitaccen tsari na gani na lamba a cikin digiri, kamar yadda ake buƙata.
6. Danna kowane tantanin halitta (ko ko danna Shigar) don kammala gyarawa.

lura: tunda mun canza tsarin tantanin halitta zuwa "Rubutu", shirin ba ya ganin darajarsa a matsayin ƙima na lambobi, saboda haka, ba za a iya amfani da shi a cikin lissafi ba. Don haka, idan kawai kuna buƙatar haɓaka lamba zuwa ikon da ake buƙata, kuna buƙatar amfani da hanyoyin uku na farko da aka bayyana a cikin wannan labarin.

Kammalawa

Don haka, Excel yana ba wa mai amfani zaɓi na manyan hanyoyi guda biyu da hanyar sharadi ɗaya don haɓaka lamba zuwa iko. Bugu da kari, a lokacin da ba ka bukatar yin lissafi, amma kawai rubuta lamba zuwa wani iko domin ta na gani daidai wakilci daidai da ka'idojin ƙira na lissafi, shirin kuma yana ba da irin wannan damar.