Nekuverengera nguva dzose mumatafura eExcel, mushandisi achakurumidza kana kuti gare gare kutarisana nekudiwa kwekukwevera dzimwe nhamba. Nzira yakafanana inowanzoitwa mukugadzirisa matambudziko akasiyana. - kubva kusvomhu dzakapfava kusvika kune dzakaoma engineering kuverenga. Nekudaro, kunyangwe nekushandiswa kwakakosha kweichi basa, Excel haina yakaparadzana fomula iyo iwe yaunogona kukwevera nhamba kubva kumaseru. Kuti uite izvi, iwe unofanirwa kudzidza mashandisiro akajairika fomula, iyo yakagadzirirwa kusimudza nhamba yega kana yakaoma dhijitari kukosha kune akasiyana masimba.

Nheyo yekuverenga sikweya yenhamba

Usati wafunga kuti ungasimudza sei manhamba nhamba kune yechipiri simba kuburikidza neExcel, unofanirwa kuyeuka kuti iyi masvomhu inoshanda sei. Sikweya yenhamba inhamba yakati kuti inopetwa pachayo.. Kuita ichi chiitiko chesvomhu uchishandisa Excel, unogona kushandisa imwe yenzira mbiri dzakaratidzwa:

• kushandiswa kwemasvomhu basa SIMBA;
• kushandiswa kweformula umo chiratidzo cheexponent “^” chinoratidzwa pakati pezvinokosha.

Imwe neimwe yenzira dzinofanirwa kutariswa zvakadzama mukuita.

Formula yekuverenga

Nzira iri nyore yekuverenga sikweya yedijiti kana nhamba yakapihwa ndeye formula ine chiratidzo chedhigirii. Kuonekwa kweformula: =n^ 2. N idijiti chero ipi kana kukosha kwenhamba inozowedzerwa pachayo kuti squaring. Muchiitiko ichi, kukosha kwenharo iyi kunogona kutsanangurwa kungave nesero coordinates, kana nekutaura kwenhamba.

Kuti unzwisise mashandisiro aungaita fomula kuti uwane mhedzisiro yaunoda, zvinofanirwa kufunga nezve 2 mienzaniso inoshanda. Sarudzo inoratidza kukosha kwenhamba mune fomula:

1. Sarudza sero uko mhedzisiro yekuverenga icharatidzwa. Imake neLMB.
2. Nyora fomula yesero iri mumutsara wemahara padivi pechiratidzo che "fx". Iyo yakapfava formula muenzaniso: =2^2.
3. Iwe unogona kunyora fomula musero rakasarudzwa.

4. Mushure meizvozvo, iwe unofanirwa kudzvanya "Enter" kuitira kuti mhedzisiro yekuverenga nebasa ionekwe mune yakamaka sero.

Sarudzo inoratidza kurongeka kwesero, iyo nhamba inofanira kusimudzwa kune yechipiri simba:

1. Fanonyora nhamba 2 muchitokisi chausingade, semuenzaniso B

2. Sarudza nekudzvanya LMB sero paunoda kuratidza mhedzisiro yekuverenga.
3. Nyora hunhu hwekutanga "=", mushure meizvozvo - marongerwo esero. Vanofanira kuratidza otomatiki mubhuruu.
4. Zvadaro, unofanira kuisa chiratidzo "^", nhamba yedhigirii.
5. Chekupedzisira chiitiko kudzvanya bhatani rekuti "Enter" kuti uwane mhedzisiro yaunoda.

Zvinokosha! Formula yakapihwa pamusoro ndeyepasi rose. Inogona kushandiswa kusimudza nhamba dzenhamba kune akasiyana masimba. Kuti uite izvi, ingotsiva nhamba mushure mechiratidzo "^" neinodiwa.

Iyo POWER basa uye mashandisiro ayo

Yechipiri nzira, iyo inoonekwa seyakaomesesa maererano nesquaring imwe nhamba, ndeye kuburikidza neSIMBA basa. Inodiwa kuitira kuti usimudze nhamba dzakasiyana-siyana mumasero etafura yeExcel kune masimba anodiwa. Kuonekwa kweiyo yese yemasvomhu formula ine chekuita nemushandisi uyu: =SIMBA(nhamba inodiwa, simba). Tsanangudzo:

1. Dhigirii ndiyo nharo yechipiri yebasa racho. Inoreva imwe dhigirii yekuwedzera kuverenga kwemhedzisiro kubva padhijitari yekutanga kana kukosha kwenhamba. Kana iwe uchida kudhinda sikweya yenhamba, iwe unofanirwa kunyora nhamba 2 munzvimbo ino.
2. Nhamba ndiyo nharo yekutanga yebasa. Inomiririra kukosha kwenhamba inodiwa iyo iyo mathematical squaring process ichashandiswa. Inogona kunyorwa sero kubatanidza nenhamba kana digit chaiyo.

Maitiro ekusimudza nhamba kune yechipiri simba kuburikidza neSIMBA basa:

1. Sarudza sero retafura umo mhedzisiro icharatidzwa mushure mekuverenga.
2. Dzvanya pachiratidzo chekuwedzera basa - "fx".
3. Iwindo re "Function Wizard" rinofanira kuoneka pamberi pemushandisi. Pano iwe unofanirwa kuvhura chikamu chagara chiripo, sarudza "Mathematics" kubva pane iyo rondedzero inovhura.

4. Kubva pane yakarongwa runyorwa rwevashandisi, unofanirwa kusarudza "DEGREE". Simbisa sarudzo nekudzvanya bhatani re "OK".
5. Tevere, iwe unofanirwa kuseta maviri emabasa nharo. Mumunda wakasununguka "Nhamba" iwe unoda kuisa nhamba kana kukosha kunosimudzwa kune simba. Mumunda wemahara "Degree" unofanirwa kutsanangura dhigirii rinodiwa (kana iri squaring - 2).
6. Nhanho yekupedzisira ndeyekupedzisa kuverenga nekudzvanya bhatani rekuti OK. Kana zvinhu zvose zvikaitwa nemazvo, kukosha kwakagadzirirwa kuchaonekwa muchitokisi chakasarudzwa kare.

Maitiro ekusimudza nhamba kune simba uchishandisa maseru coordinates:

1. Mune imwe sero, isa nhamba ichaitwa squared.
2. Tevere, isa basa mune imwe sero kuburikidza ne "Function Wizard". Sarudza "Mathematics" kubva pane rondedzero, tinya pane "DEGREE" basa.
3. Muhwindo rinovhura, apo nharo dzebasa dzinofanira kutsanangurwa, unofanira kuisa mamwe maitiro, kusiyana neyokutanga nzira. Mumunda wemahara "Nhamba" iwe unofanirwa kutsanangura marongero esero umo nhamba yenhamba yakasimudzwa kune simba iripo. Nhamba 2 inopindirwa muchikamu chechipiri chemahara.

4. Inosara kudzvanya bhatani re "OK" uye uwane mhedzisiro yapera musero yakamaka.

Hatifanire kukanganwa kuti iyo SIMBA basa rakajairika, rakakodzera kusimudza nhamba kune akasiyana masimba.

mhedziso

Zvinoenderana nenhamba dzepamutemo, pakati pemamwe mashandiro emasvomhu, vashandisi vanoshanda muExcel maspredishiti anokwereta akasiyana nhamba dzenhamba kakawanda kupfuura zvavanoita mamwe maitiro kubva muboka iri. Nekudaro, nekuda kwekuti hapana rakaparadzana basa reichi chiitiko muchirongwa, unogona kushandisa yakaparadzana formula inotsiviwa nhamba inodiwa, kana iwe unogona kushandisa yakaparadzana SIMBA opareta, inowanikwa kusarudza kubva Basa Wizard.