How kuvaka nhamba kunaka dhigirii - mienzaniso achirondedzera muna Excel

Kubva kuchikoro tose kuziva mutemo pamusoro Exponentiation: chero nhamba pamwe exponent N mugumisiro anowedzera nhamba iyi roga N-Noa kanoverengeka. Nemamwe mashoko, simba 3 7 - 7 zvikawanda ne katatu, i.e. 343. Chimwe utongi - kuvaka chero kunokosha kuti simba Unit anopa 0, uye kuvakwa zvakaipa ukoshi mugumisiro kwakajairika Exponentiation kana kunyange, uye zvakafanana mugumisiro ane "kubvisa" chiratidzo, kana zviri shamisa.

Mitemo uyewo kupa mhinduro sezvo kuvaka kuwanda zvakaipa simba. Kuti aite izvi, unofanira kuvaka kwakajairika nenzira achida kukosha kuna module indekisi, uye ipapo zviparadzanise mugumisiro chikwata.

Kubva mitemo izvi zvinova pachena kuti mabasa chaiwo mabasa kubata yakawanda zvaizoda Kuwanikwa michina nzira. Manual achaita kuzviwanzira vaifanira siyana nhamba anosvika makumi maviri kana matatu, uye kuti haana kupfuura matatu kana mana nguva. Izvi tisingatauri chokwadi kuti mumwe uye imwe, kugovera mugumisiro. Naizvozvo, avo vasina paruoko masayendisiti karukureta chaiyo, tinenge kukuratidza sei kuvaka nhamba kunaka dhigirii Excel.

The Kugadzirisa matambudziko mu Excel

Nokuti matambudziko pakuvaka mvumo muna Excel dhigirii unokubvumira kushandisa rimwe maviri zvokusarudza.

Chokutanga - ndiko kushandisa nzira yemaitiro ne mwero chiratidzo "chivharo." Pinda zvinotevera mashoko ari pepa:

Saizvozvowo munhu anogona kuvaka imwe aida ukoshi kuti dhigirii upi - kunaka, fractional. Tinotevedzera matanho pazasi wopindura mubvunzo sei kurera nhamba munhu asina simba. muenzaniso:

Unogona tauriranai mune zvakarurama payakavakirwa = B2 ^ -C2.

The Ipfungwa rechipiri - kushandisa makagadzirira akagadzirwa mabasa "dhigirii", kugamuchira mbiri madikanwa nharo - nhamba uye mwero. Kutanga kurishandisa, zvakakwana muchitokisi chero akasununguka akaisa chiratidzo "vakaenzana" (=), zvichiratidza kutanga nzira, uye kupinda apa mashoko. Zvazvinosarira kusarudza masero maviri, izvo zvinobatanidzwa mukushanda (kana kutaridzwa chaiyo nhamba manually), uye tigoshingairira Enter. Ngatimboonai mienzaniso iri nyore.

Sezvaunogona kuona, hapana kuoma sei kuvaka uwandu zvakaipa simba, uye yemanyorero kushandisa Excel. Pashure pezvose, nokuti chikumbiro ichi chinogona kushandiswa senguva pamusoro chiratidzo "chivharo" uye zvakakunakira achengetere chirongwa pakuvara. Iri chaicho ndinoiitawo!

Kutamira kune mienzaniso yakawanda kunzwisisa. Yeuka kutonga pamusoro kuvaka kuona kuti dambudziko iri nyore chaizvo kugadzirisa muna Excel kuti nhamba iri akaipa nesimba fractional hunhu, uye.

fractional exponents

Muchidimbu, algorithm nokuti pakuverenga nhamba fractional indekisi inotevera.

1. Kutendeutsa fractional pakuderedza mune dzose kana kutadza hacho.
2. Kuvaka nhamba vedu numerator pamusoro hacho vakachiwana akachinja.
3. Zvibereko mundima yapfuura nhamba kuverenga mudzi, pamwe proviso kuti indekisi pamudzi ndiwo dhinomineta ari chikamu chiduku kuwanikwa mune yokutanga danho.

Uchabvuma kuti kunyange kana uchishanda zviduku nhamba uye zvakakodzera zvikamu zviduku Masvomhu akadaro kunogona kutora nguva yakareba. Zvakanaka, kuti Excel spreadsheet hazvina basa vangani uye mune dhigirii erect. Edza kusarudza iri Excel pepa, muenzaniso zvinotevera:

Uchishandisa pamusoro mitemo, unogona kutarisa uye nechokwadi chokuti kukarukureta unoitwa nemazvo.

Panoperera ino ratinoparidza muchimiro matafura vane Masvomhu, uye migumisiro mienzaniso inoverengeka sei kuvaka inhamba kunaka simba, uyewo mienzaniso mishomanana kubata pamwe fractional nhamba uye madhigirii.

Table mienzaniso

Check ive Excel workbook inotevera mienzaniso pepa. Kuti zvinhu kushanda zvakanaka, unofanira kushandisa yakavenganiswa kubatana kana kutevedzera mafungiro okuda fomura. Batanidza Mbiru nhamba ine chakavakwa nhamba uye mutsetse nhamba chine chikamu. fomura Your zvinofanira kutarira akafanana zvinotevera chimiro :. «= $ B4 ^ C $ 3"

Ona kuti zvakanaka nhamba (kunyange vasiri integer) pasina zvinetso zvose dzaona zviratidzo. Hapana nezvinetso erection upi nhamba yose unongotaura. Asi rokuvaka zvakaipa nhamba kuti simba fractional zvakachengeterwa iwe wakanganisa, nokuti hazvibviri kuti zvinoenderana nemitemo raanotaura pakutanga nyaya yedu pamusoro kuvakwa kunaka nhamba, nokuti parity - maitire chete ane integer.