Ukuphakamisa inombolo emandleni ku-Excel

Omunye wemisebenzi yezibalo ovame kakhulu ukukhuphula inombolo emandleni, okuvumela ukuthi uxazulule inani elikhulu lezinkinga ezahlukahlukene (izibalo, ezezimali, njll.). Njengoba i-Excel iyithuluzi elinamandla lokusebenza nedatha yezinombolo, vele, inikeza umsebenzi owusizo nodingekayo. Ngakho-ke, ake sibone ukuthi inombolo iphakanyiswa kanjani ibe namandla ohlelweni.

Indlela 1: Ukusebenzisa Umlingiswa Okhethekile

Sizoqala ngendlela ejwayeleke kakhulu, okuwukusebenzisa ifomula enophawu olukhethekile “^”. 

Ngokuvamile, ifomula ibonakala kanje:

=Число^n

• Inombolo ingamelwa njengenombolo ethile noma njengereferensi yeseli eliqukethe inani lenombolo.
• n amandla lapho inombolo enikeziwe iphakanyiswa khona.

Isibonelo se-1

Ake sithi sidinga ukuphakamisa inombolo 7 ku-cube (okungukuthi emandleni wesithathu). Ukwenza lokhu, sima kunoma iyiphi iseli yamahhala yetafula, faka uphawu olulinganayo bese ubhala inkulumo: =7^3.

Ngemva kokuba ifomula isilungile, cindezela inkinobho Faka kukhibhodi bese uthola umphumela oyifunayo kuseli ekhethiwe.

Isibonelo se-2

I-Exponentiation ingaba yingxenye yenkulumo yezibalo eyinkimbinkimbi ehlanganisa imisebenzi embalwa. Ake sithi sidinga ukwengeza enombolweni 12 inombolo etholwe ngokuphakamisa inombolo 7 ku-cube. Yile ndlela isisho sokugcina sizobukeka kanjena: =12+7^3.

Sibhala ifomula esitokisini samahhala, nangemva kokuchofoza Faka sithola umphumela.

Isibonelo se-3

Njengoba sishilo ngenhla, esikhundleni samanani athile, izinkomba zamaseli anedatha yezinombolo zingabamba iqhaza ekubalweni. Ake sithi sidinga ukuphakamisa amanani kumaseli wekholomu yethebula elithile ukuya emandleni esihlanu.

1. Siya esitokisini sekholomu lapho sihlela ukubonisa imiphumela futhi sibhale kuyo ifomula yokukhulisa inombolo kusuka kukholomu yokuqala (emgqeni ofanayo) kuya emandleni afunayo. Esimweni sethu, ifomula ibukeka kanje: =A2^5.
2. Cindezela inkinobho Fakaukuthola umphumela.
3. Manje kusasele ukwelula ifomula kumaseli asele wekholomu atholakala ngezansi. Ukuze wenze lokhu, hambisa ikhesa ekhoneni elingezansi kwesokudla seseli ngemiphumela ebaliwe, lapho isikhombi sishintsha sibe uphawu olumnyama lokuhlanganisa (umaka wokugcwalisa), cindezela inkinobho yegundane engakwesobunxele bese usihudulela phansi kuseli lokugcina olibekele lona. sifuna ukwenza izibalo ezifanayo.
4. Lapho nje sikhulula inkinobho yegundane kwesokunxele, amaseli ekholomu agcwaliswa ngokuzenzakalela ngedatha, okungukuthi, izinombolo eziphakanyiswe emandleni esihlanu ukusuka kukholomu yokuqala.

Indlela echazwe ilula futhi iguquguquka, yingakho ithandwa kakhulu phakathi kwabasebenzisi. Kodwa zikhona ezinye izindlela ngaphandle kwayo. Ake sizibheke futhi.

Indlela yesi-2: Ukusebenza kwamandla

Kulesi sigaba, sizogxila emsebenzini AMANDLA, okuvumela ukuthi ukhuphule izinombolo emandleni oyifunayo.

Ifomula Yomsebenzi AMANDLA Ngokulandelayo:

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

Nansi indlela yokusebenza ngayo:

1. Iya kuseli lapho sihlela ukwenza izibalo bese uchofoza inkinobho "Faka umsebenzi" (fx) kwesokunxele sebha yefomula.
2. Efasiteleni elivuliwe Ukufakwa kwesici khetha isigaba "Izibalo", ohlwini olungezansi sithola u-opharetha "DIGREE", chofoza kukho, bese uchofoza inkinobho OK.
3.  Sizobona iwindi lokugcwalisa izimpikiswano zomsebenzi:
   • Njengenani lempikiswano "Inombolo" Ungacacisa kokubili inani elithile lenombolo kanye nereferensi yeseli. Ikheli leseli lingafakwa ngesandla kusetshenziswa okhiye abakukhibhodi. Noma ungachofoza kwesokunxele endaweni ukuze ufake ulwazi bese uchofoza kuseli oyifunayo kuthebula.
   • Ngencazelo "Iziqu" sibhala inombolo, leyo, ngokwegama lempikiswano, okungamandla esihlela ukukhuphula ngawo inani lenombolo elishiwo ku-agumenti. "Inombolo".
   • Uma yonke idatha isigcwalisiwe, chofoza OK.
4. Sithola umphumela wokuphakamisa inombolo emandleni ashiwo.

Esimeni lapho esikhundleni senani elithile, ikheli leseli liyasetshenziswa:

1. Iwindi lezimpikiswano zomsebenzi libukeka kanje (kucatshangelwa idatha yethu):
2. Ifomula yokugcina kuleli cala imi kanje: =СТЕПЕНЬ(A2;3).
3. Njengendlela yokuqala, umphumela unganwetshwa kumaseli asele wekholomu.

Esikhundleni senani elithile ku-agumenti yomsebenzi "Iziqu", ungasebenzisa futhi ireferensi yeseliNokho, lokhu akuvamile ukusetshenziswa:

1. Ungagcwalisa iwindi le-agumenti ngokwenza ngesandla noma ngokuchofoza iseli oyifunayo kuthebula - okufana nokugcwalisa impikiswano "Inombolo".
2. Esimweni sethu, ifomula ibonakala kanje: =СТЕПЕНЬ(A2;B2).
3. Yelula umphumela kweminye imigqa usebenzisa isibambo sokugcwalisa.

Qaphela: run Isilekeleli somsebenzi kungenzeka ngendlela ehlukile. Shintshela kuthebhu "Amafomula", esigabeni samathuluzi "Ilabhulali Yomsebenzi" chofoza inkinobho "Izibalo" bese ukhetha into ohlwini "DIGREE".

Futhi, abanye abasebenzisi bakhetha esikhundleni sokusebenzisa iwindi Umsebenzi Wizards futhi ubeka izimpikiswano zayo, ngokushesha bhala ifomula yokugcina yomsebenzi kuseli oyifunayo, ugxile ku-syntax yayo.

Ngokusobala, le ndlela ithi inkimbinkimbi kuneyokuqala. Kodwa ezimweni ezithile, kuba kudingekile uma kufanele ubhekane nemisebenzi eyinkimbinkimbi ehlanganisa opharetha abaningana ngesikhathi esisodwa.

Indlela yesi-3: Ukusebenzisa i-Square Root

Yiqiniso, le ndlela ayithandwa kakhulu phakathi kwabasebenzisi, kodwa futhi iyasebenza kwezinye izimo lapho udinga ukuphakamisa inombolo emandleni ka-0,5 (ngamanye amazwi, bala impande yayo yesikwele).

Ake sithi ufuna ukuphakamisa inombolo 16 emandleni ka-0,5.

1. Iya kuseli lapho sihlela ukubala umphumela. Chofoza inkinobho "Faka umsebenzi" (fx) eduze kwebha yefomula.
2. Ewindini lokufaka umsebenzi, khetha u-opharetha "IZimpande", etholakala esigabeni "Izibalo".
3. Lo msebenzi unokuphikisana okukodwa kuphela. "Inombolo", njengoba ngayo ungenza umsebenzi wezibalo owodwa kuphela - ukukhipha impande yesikwele yenani lenombolo eshiwo. Ungacacisa kokubili inombolo ethile kanye nesixhumanisi seseli (mathupha noma ngokuchofoza inkinobho yegundane kwesokunxele). Chofoza uma usulungile OK.
4. Umphumela wokubala komsebenzi uzovezwa kuseli ekhethiwe.

Sibhala inombolo ku-eksponenti kuseli

Le ndlela ayihloselwe ukwenza izibalo futhi isetshenziselwa ukubhala phansi inombolo eneziqu kuseli yethebula elinikeziwe.

1. Okokuqala udinga ukuguqulela ifomethi yeseli "Umbhalo". Ukuze wenze lokhu, chofoza kwesokudla entweni oyifunayo bese ukhetha into kumenyu yokuqukethwe evulayo. "Ifomethi Yeseli".
2. Ukuba kuthebhu "Inombolo" chofoza entweni "Umbhalo" kumafomethi ahlongozwayo bese – ngokuchofoza inkinobho OK.Qaphela: ungashintsha ifomethi yeseli kuthebhu "Ikhaya" efasiteleni lohlelo olukhulu. Ukuze wenze lokhu, chofoza inketho yamanje esigabeni samathuluzi. "Inombolo" (okuzenzakalelayo - "Okuvamile") bese ukhetha into edingekayo ohlwini oluhlongozwayo.
3. Sibhala kuseli elikhethiwe kuqala inombolo, bese kulandela idigri yayo. Ngemva kwalokho, khetha idijithi yokugcina ngokucindezela inkinobho yegundane kwesokunxele.
4. Ngokucindezela inhlanganisela Ctrl + 1 Singena efasiteleni lefomethi yeseli. Kubhulokhi yepharamitha "Shintsha" maka ibhokisi eduze kwenketho "I-Superscript", bese uchofoza OK.
5. Sithola idizayini efanele ngokubukeka kwenombolo kudigri, njengoba kudingeka.
6. Chofoza kunoma iyiphi enye iseli (noma chofoza Faka) ukuqedela ukuhlela.

Qaphela: njengoba siguqule ifomethi yeseli yaba "Umbhalo", inani layo alisabonwa uhlelo njengenani lezinombolo, ngakho-ke, alikwazi ukusetshenziswa ekubalweni. Ngakho-ke, uma nje udinga ukuphakamisa inombolo emandleni adingekayo, udinga ukusebenzisa izindlela ezintathu zokuqala ezichazwe kulesi sihloko.

Isiphetho

Ngakho, i-Excel inikeza umsebenzisi ukukhetha kwezindlela ezimbili eziyinhloko kanye neyodwa enemibandela yokukhulisa inombolo emandleni. Ngaphezu kwalokho, lapho ungadingi ukwenza izibalo, kodwa umane ubhale inombolo emandleni ngokumelela kwayo okulungile ngokuhambisana nemithetho yokuklama kwezibalo, uhlelo lunikeza ithuba elinjalo.