Kukwidza nhamba kune simba muExcel

Imwe yeakajairika masvomhu mashandiro ari kusimudza nhamba kune imwe simba, iyo inokutendera iwe kugadzirisa huwandu hukuru hwematambudziko akasiyana (masvomhu, emari, nezvimwewo). Sezvo Excel chiri chishandiso chine simba chekushanda nenhamba data, iyo, hongu, inopa basa rakadaro rinobatsira uye rinodikanwa. Saka, ngationei kuti nhamba inosimudzwa sei kune simba muchirongwa.

Nzira 1: Kushandisa Hunhu Hunokosha

Tichatanga nenzira yakajairika, iri kushandisa fomula ine chiratidzo chakakosha “^”. 

Muzhinji, iyo formula inoita seizvi:

=Число^n

• nhamba inogona kumiririrwa senhamba chaiyo kana sereferensi kune sero rine kukosha kwenhamba.
• n isimba iro nhamba yakapihwa inosimudzwa.

muenzaniso 1

Ngatitii tinoda kusimudza nhamba 7 kune cube (kureva kune simba rechitatu). Kuti tiite izvi, tinomira mune chero sero yemahara yetafura, isa chiratidzo chakaenzana uye nyora chirevo: =7^3.

Mushure mekunge fomula yagadzirira, dzvanya kiyi pinda pane keyboard uye uwane mhedzisiro yaunoda musero rakasarudzwa.

muenzaniso 2

Exponentiation inogona kuva chikamu chekutaura kwakaoma kwemasvomhu kunosanganisira maitiro akati wandei. Ngatitii tinoda kuwedzera kune nhamba 12 nhamba inowanikwa nekusimudza nhamba 7 kune cube. Aya ndiwo maratidziro ekupedzisira achaita senge: =12+7^3.

Isu tinonyora fomuro musero remahara, uye mushure mekudzvanya pinda tinowana mhedzisiro.

muenzaniso 3

Sezvatataura pamusoro apa, panzvimbo yehukoshi chaihwo, mareferensi kumasero ane data yenhamba anogona kutora chikamu mukuverenga. Ngatitii isu tinoda kusimudza hunhu mumaseru eimwe tafura koramu kune yechishanu simba.

1. Isu tinoenda kune sero yekoramu yatinoronga kuratidza mhedzisiro uye nyora mairi fomula yekusimudza nhamba kubva kune yekutanga mbiru (mumutsara mumwechete) kune simba raunoda. Muchiitiko chedu, iyo formula inoita senge: =A2^5.
2. Dhinda kiyi pindakuwana mhedzisiro.
3. Ikozvino yasara kutambanudza fomula kune asara masero ekoramu ari pazasi. Kuti uite izvi, fambisa cursor kukona yezasi yekurudyi kwesero nemhedzisiro yakaverengerwa, kana chinongedzo chachinja kuita chitema plus chiratidzo (zadza chiratidzo), bata pasi bhatani rekuruboshwe uye woridhonzera pasi kune yekupedzisira sero iyo. tinoda kuita masvomhu akafanana.
4. Patinongoburitsa bhatani rekuruboshwe, maseru ekoramu anozadzwa otomatiki nedata, kureva, nhamba dzakasimudzwa kusvika kune yechishanu simba kubva kune yekutanga column.

Iyo yakatsanangurwa nzira iri nyore uye inoshanda zvakasiyana-siyana, ndosaka ichinyanya kufarirwa pakati pevashandisi. Asi kune dzimwe nzira kunze kwayo. Ngatimbovatarisawo.

Nzira 2: SIMBA basa

Muchikamu chino, tichatarisa pane basa SIMBA, iyo inokubvumira kusimudza nhamba kune simba rinodiwa.

Basa Formula SIMBA Sezvinotevera:

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

Heino maitiro ekushanda nayo:

1. Enda kune sero yatinoronga kuita masvomhu uye tinya bhatani "Isa basa" (fx) kuruboshwe rweformula bar.
2. Mufafitera rakavhurwa Feature inserts sarudza chikamu "Mathematics", mune runyorwa pazasi tinowana mushandisi "DEGREE", tinya pairi, ipapo pabhatani OK.
3.  Tichaona hwindo rekuzadza nharo dzebasa racho:
   • Senharo kukosha “Nhamba” Unogona kudoma zvese zviri zviviri kukosha kwenhamba uye chirevo chesero. Kero yesero inogona kuiswa nemaoko uchishandisa makiyi pa keyboard. Kana kuti unogona kudzvanya-kuruboshwe pamunda kuti uise ruzivo wobva wadzvanya pane yaunoda sero patafura.
   • Muchirevo "Degree" tinonyora nhamba, iyo, maererano nezita renharo, ndiro simba ratinoronga kusimudza kukosha kwenhamba inotsanangurwa munharo. “Nhamba”.
   • Kana data rese razadzwa mukati, tinya OK.
4. Tinowana chigumisiro chekusimudza nhamba kune simba rakatarwa.

Panyaya apo pachinzvimbo chemutengo chaiwo, kero yesero inoshandiswa:

1. Iro basa rekupokana hwindo rinotaridzika seizvi (tichifunga nezvedu data):
2. Iyo yekupedzisira formula mune iyi kesi ndeiyi inotevera: =СТЕПЕНЬ(A2;3).
3. Sezviri munzira yekutanga, mhedzisiro inogona kutambanudzwa kune asara masero ekoramu.

Panzvimbo pemutengo chaiwo mukushanda nharo "Degree", iwe unogona zvakare kushandisa cell referencezvisinei, izvi hazvinyanyi kushandiswa:

1. Iwe unogona kuzadza hwindo rekupokana nemaoko kana nekudzvanya pane yaunoda sero patafura - zvakafanana nekuzadza kupokana. “Nhamba”.
2. Muchiitiko chedu, iyo formula inoita seizvi: =СТЕПЕНЬ(A2;B2).
3. Tambanudza mhedzisiro kune mamwe mitsetse uchishandisa mubato wekuzadza.

Cherechedza: manya Basa wizard zvinogoneka neimwe nzira. Chinja kune tab "Nzira", muchikamu chezvishandiso "Function Library" tinya pane bhatani "Mathematics" uye sarudza chinhu kubva pane rondedzero "DEGREE".

Zvakare, vamwe vashandisi vanosarudza pane kushandisa hwindo Basa Wizards uye nekumisa nharo dzayo, pakarepo nyora fomula yekupedzisira yebasa iri musero rinodiwa, uchitarisa pachirevo chayo.

Zviripachena, nzira iyi yakatiomei kupfuura yekutanga. Asi mune zvimwe zviitiko, zvinova zvakakosha kana uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchingedzo mabasa panguva imwe chete.

Nzira 3: Kushandisa Square Root

Ehe, nzira iyi haina kufarirwa pakati pevashandisi, asi inoshandawo mune dzimwe nguva kana iwe uchida kusimudza nhamba kune simba re0,5 (nemamwe mazwi, verenga midzi yayo).

Ngatiti iwe unoda kukwidza nhamba 16 kune simba re0,5.

1. Enda kuchitokisi kwatinoronga kuverenga mhedzisiro. Baya bhatani "Isa basa" (fx) pedyo neformula bar.
2. Muwindo rekuisa basa, sarudza mushandisi "MUDZI", iri muchikwata "Mathematics".
3. Basa iri rine nharo imwe chete. “Nhamba”, sezvo nayo iwe unogona kuita imwe chete masvomhu kushanda - kubvisa square root yehuwandu hunotsanangurwa nhamba. Iwe unogona kutsanangura ese ari maviri nhamba chaiyo uye chinongedzo kune sero (nemaoko kana nekudzvanya nekuruboshwe bhatani). Dzvanya kana wagadzirira OK.
4. Mhedzisiro yekuverenga basa icharatidzwa musero rakasarudzwa.

Tinonyora nhamba muexponent muchitokisi

Iyi nzira haina kunangana nekuita masvomhu uye inoshandiswa kunyora pasi nhamba ine dhigirii musero retafura rakapihwa.

1. Kutanga iwe unofanirwa kushandura sero fomati kuti “Mashoko”. Kuti uite izvi, tinya-kurudyi pane chaunoda uye sarudza chinhu chiri mumenu yemukati inovhura. "Cell Format".
2. Kuve mune tab “Nhamba” tinya pane chinhu “Mashoko” mumafomati akarongwa uyezve - nekudzvanya bhatani OK.Cherechedza: iwe unogona kushandura sero fomati mune tab "Kumba" muhwindo guru repurogiramu. Kuti uite izvi, tinya pane yazvino sarudzo muchikamu chemidziyo. “Nhamba” (default - "General") uye sarudza chinhu chinodiwa kubva pane yakarongwa runyorwa.
3. Tinonyora musero rakasarudzwa kutanga nhamba, ipapo dhigirii yayo. Mushure mezvo, sarudza dhijiti yekupedzisira neruboshwe bhatani rakadzvanywa.
4. Nekudzvanya musanganiswa Ctrl + 1 Isu tinopinda muhwindo refomati yesero. Mune parameter block "Chinja" tarisa bhokisi riri pedyo nesarudzo "Superscript", ipapo chengeta OK.
5. Isu tinowana dhizaini yakaringana yenhamba mudhigirii, sezvinodiwa.
6. Dzvanya pane chero imwe sero (kana kudzvanya pinda) kupedzisa kugadzirisa.

Cherechedza: sezvo takachinja sero fomati kuita “Mashoko”, kukosha kwayo hakuchaonekwi nepurogiramu sehuwandu hwehuwandu, saka, haigoni kushandiswa mukuverenga. Nokudaro, kana iwe uchingoda kusimudza nhamba kune simba rinodiwa, unoda kushandisa nzira nhatu dzokutanga dzinotsanangurwa munyaya ino.

mhedziso

Saka, Excel inopa mushandisi sarudzo yemhando mbiri huru uye imwe ine zvimiso nzira yekusimudza nhamba kune simba. Mukuwedzera, kana iwe usingadi kuita masvomhu, asi kungonyora nhamba kune simba nokuda kwechimiro chayo chakarurama chinomiririra maererano nemitemo yekugadzirwa kwemasvomhu, purogiramu inopawo mukana wakadaro.