Kukweza nambala kukhala mphamvu mu Excel

Chimodzi mwazinthu zodziwika bwino zamasamu ndikukweza nambala ku mphamvu, zomwe zimakupatsani mwayi wothana ndi mavuto ambiri osiyanasiyana (masamu, ndalama, ndi zina). Popeza Excel ndi chida champhamvu chogwirira ntchito ndi manambala, izo, ndithudi, zimapereka ntchito yothandiza komanso yofunikira. Chifukwa chake, tiyeni tiwone momwe nambala imakwezera mphamvu mu pulogalamu.

Njira 1: Kugwiritsa Ntchito Khalidwe Lapadera

Tiyamba ndi njira yodziwika kwambiri, yomwe ndiyo kugwiritsa ntchito chilinganizo chokhala ndi chizindikiro chapadera "^". 

Kawirikawiri, fomula imawoneka motere:

=Число^n

• Number ikhoza kuimiridwa ngati nambala yeniyeni kapena ngati cholozera ku selo lomwe lili ndi nambala.
• n ndi mphamvu yomwe nambala yoperekedwa yakwezedwa.

Mwachitsanzo 1

Tiyerekeze kuti tiyenera kukweza nambala 7 ku kyubu (ie ku mphamvu yachitatu). Kuti tichite izi, timayima mu selo iliyonse yaulere ya tebulo, ikani chizindikiro chofanana ndikulemba mawuwa: =7^3.

Fomuyo ikakonzeka, dinani batani Lowani pa kiyibodi ndikupeza zotsatira zomwe mukufuna mu cell yosankhidwa.

Mwachitsanzo 2

Kufotokozera kungakhale gawo la mawu ovuta kwambiri a masamu okhala ndi ntchito zingapo. Tiyerekeze kuti tifunika kuwonjezera pa nambala 12 chiwerengero chomwe tinapeza pokweza nambala 7 ku kyubu. Umu ndi momwe mawu omaliza adzawonekera: =12+7^3.

Timalemba chilinganizo mu cell yaulere, ndipo titatha kuwonekera Lowani timapeza zotsatira.

Mwachitsanzo 3

Monga tafotokozera pamwambapa, m'malo mwa zikhalidwe zenizeni, maumboni a maselo omwe ali ndi chiwerengero cha nambala akhoza kutenga nawo mbali powerengera. Tinene kuti tiyenera kukweza zikhalidwe m'maselo a tebulo linalake ku mphamvu yachisanu.

1. Timapita ku selo la ndime kumene tikukonzekera kusonyeza zotsatira ndikulembamo ndondomeko yokweza nambala kuchokera pamzere woyambirira (mu mzere womwewo) kupita ku mphamvu yomwe tikufuna. Kwa ife, ndondomekoyi ikuwoneka motere: =A2^5.
2. Dinani fungulo Lowanikuti apeze zotsatira.
3. Tsopano yatsala kutambasula chilinganizo ku maselo otsala a ndime ili pansipa. Kuti muchite izi, sunthani cholozera kukona yakumanja kwa selo ndi zotsatira zomwe zawerengedwa, cholozera chikasintha kukhala chizindikiro chakuda chophatikiza (lembani cholembera), gwirani batani lakumanzere ndikulikokera ku cell yomaliza yomwe. tikufuna kuchita mawerengedwe ofanana.
4. Tikangomasula batani lakumanzere la mbewa, maselo a mzerewo amadzazidwa ndi deta, mwachitsanzo, manambala omwe amakwezedwa ku mphamvu yachisanu kuchokera pamzati wapachiyambi.

Njira yofotokozedwayo ndiyosavuta komanso yosunthika, chifukwa chake ndiyotchuka kwambiri pakati pa ogwiritsa ntchito. Koma pali njira zina pambali pa izo. Tiyeni tionenso iwo.

Njira 2: Ntchito ya MPHAMVU

M'chigawo chino, tikambirana za ntchitoyi MPHAMVU, zomwe zimakulolani kukweza manambala ku mphamvu yomwe mukufuna.

Ntchito Formula MPHAMVU motere:

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

Momwe mungagwirire ntchito ndi izi:

1. Pitani ku selo lomwe tikukonzekera kuwerengera ndikudina batani "Ikani ntchito" (fx) kumanzere kwa formula bar.
2. Pa zenera lotseguka Zoyikapo sankhani gulu "Mathematics", pamndandanda womwe uli pansipa timapeza woyendetsa "DEGREE", dinani pa izo, kenako pa batani OK.
3.  Tiwona zenera lodzaza mikangano ya ntchitoyi:
   • Monga mtengo wotsutsana "Nambala" Mutha kutchula nambala yeniyeni komanso mawu okhudza selo. Adilesi ya selo ikhoza kulembedwa pamanja pogwiritsa ntchito makiyi pa kiyibodi. Kapena mutha kudina kumanzere kumunda kuti mulowetse zambiri ndikudina pa cell yomwe mukufuna patebulo.
   • Mutanthauzo "Digiri" timalemba nambala, yomwe, molingana ndi dzina la mkangano, ndi mphamvu yomwe tikukonzekera kukweza chiwerengero cha chiwerengero chomwe chafotokozedwa mkangano. "Nambala".
   • Deta yonse ikadzazidwa, dinani OK.
4. Timapeza zotsatira za kukweza chiwerengero ku mphamvu yotchulidwa.

Pankhani pamene m'malo mwa mtengo wake, adilesi ya cell imagwiritsidwa ntchito:

1. Zenera lamakambirano a ntchito likuwoneka motere (poganizira za data yathu):
2. Njira yomaliza pankhaniyi ndi motere: =СТЕПЕНЬ(A2;3).
3. Monga njira yoyamba, zotsatira zake zimatha kutambasulidwa ku maselo otsala a mzati.

M'malo mwa mtengo weniweni mu kukangana kwa ntchito "Digiri", mutha kugwiritsanso ntchito kalozera wa foniKomabe, izi sizimagwiritsidwa ntchito kawirikawiri:

1. Mutha kudzaza zenera la mikangano pamanja kapena podina pa cell yomwe mukufuna patebulo - mofanana ndi kudzaza mkangano. "Nambala".
2. Kwa ife, ndondomekoyi ikuwoneka motere: =СТЕПЕНЬ(A2;B2).
3. Tambasulani zotsatira ku mizere ina pogwiritsa ntchito chogwirira chodzaza.

Zindikirani: amathamanga Wizard ntchito ndizotheka mwanjira ina. Sinthani ku tabu "Mitundu", mu gawo la zida "Function Library" dinani batani "Mathematics" ndikusankha chinthu kuchokera pamndandanda "DEGREE".

Komanso, ena ogwiritsa ntchito amakonda m'malo mogwiritsa ntchito zenera Ntchito Wizards ndikukhazikitsa mfundo zake, nthawi yomweyo lembani chilinganizo chomaliza cha ntchitoyo mu cell yomwe mukufuna, ndikulunjika pa syntax yake.

Mwachionekere, njirayi ndi yovuta kwambiri kuposa yoyamba. Koma nthawi zina, zimakhala zofunika kwambiri mukakumana ndi zovuta zomwe zimaphatikizapo ogwiritsira ntchito angapo nthawi imodzi.

Njira 3: Kugwiritsa Ntchito Square Root

Zachidziwikire, njirayi siyodziwika kwambiri pakati pa ogwiritsa ntchito, koma imagwiranso ntchito nthawi zina mukafuna kukweza nambala ku mphamvu ya 0,5 (mwanjira ina, kuwerengera mizu yake yayikulu).

Tiyerekeze kuti mukufuna kukweza nambala 16 ku mphamvu ya 0,5.

1. Pitani ku selo komwe tikukonzekera kuwerengera zotsatira. Dinani batani "Ikani ntchito" (fx) pafupi ndi formula bar.
2. Pazenera loyikirapo, sankhani woyendetsa "MIZIMU", yomwe ili m'gulu "Mathematics".
3. Ntchitoyi ili ndi mkangano umodzi wokha. "Nambala", popeza ndi iyo mutha kuchita ntchito imodzi yokha ya masamu - kuchotsa muzu wa sikweya wa mtengo womwe watchulidwa. Mutha kutchula nambala yeniyeni ndi ulalo wa cell (pamanja kapena podina batani lakumanzere). Dinani mukakonzeka OK.
4. Zotsatira za kuwerengetsera ntchito zidzawonetsedwa mu selo losankhidwa.

Timalemba nambala mu exponent mu selo

Njirayi sicholinga chowerengera ndipo imagwiritsidwa ntchito polemba nambala yokhala ndi digiri mu cell yatebulo yoperekedwa.

1. Choyamba muyenera kusintha mawonekedwe a cell kuti "Mawu". Kuti muchite izi, dinani kumanja pa chinthu chomwe mukufuna ndikusankha chinthucho mumenyu yomwe imatsegulidwa. "Cell Format".
2. Kukhala mu tabu "Nambala" dinani chinthucho "Mawu" m'mawonekedwe omwe akufunsidwa ndiyeno - podina batani OK.Zindikirani: mutha kusintha mawonekedwe a cell mu tabu "Pofikira" mu chachikulu pulogalamu zenera. Kuti muchite izi, dinani pazosankha zomwe zili mugawo la zida. "Nambala" (zosakhazikika - "General") ndikusankha chinthu chofunikira pamndandanda womwe waperekedwa.
3. Timalemba mu selo losankhidwa poyamba nambala, ndiye digiri yake. Pambuyo pake, sankhani nambala yomaliza ndikukanikiza batani lakumanzere.
4. Mwa kukanikiza kuphatikiza Ctrl + 1 Timalowa muwindo la mtundu wa cell. Mu parameter block "Sinthani" chongani bokosi pafupi njira "Superscript", kenako dinani OK.
5. Timapeza mawonekedwe olondola a chiwerengero mu digiri, monga momwe amafunikira.
6. Dinani pa selo ina iliyonse (kapena dinani Lowani) kuti amalize kukonza.

Zindikirani: popeza tidasintha mawonekedwe a cell kukhala "Mawu", mtengo wake sudziwikanso ndi pulogalamu ngati mtengo wa nambala, choncho, sungagwiritsidwe ntchito powerengera. Choncho, ngati mukungofunika kukweza chiwerengero ku mphamvu yofunikira, muyenera kugwiritsa ntchito njira zitatu zoyambirira zomwe zafotokozedwa m'nkhaniyi.

Kutsiliza

Chifukwa chake, Excel imapatsa wogwiritsa ntchito kusankha kwa njira ziwiri zazikulu ndi imodzi zolimbikitsira kuti akweze nambala ku mphamvu. Kuonjezera apo, pamene simukusowa kuwerengera, koma ingolembani nambala ku mphamvu kuti muyimire bwino molingana ndi malamulo a masamu, pulogalamuyi imaperekanso mwayi wotero.