Dzidza maitiro ekukwereta nhamba muExcel

Kudzidza maitiro ekuenzanisa muExcel kwakakosha zvakanyanya, kunyanya kana iwe uchiwanzo shanda neizvi kuita masvomhu kana masvomhu. Excel yave chishandiso chinobatsira zvakanyanya, zvisinei kuti uchaita masvomhu akanyanya kana kuti uchida kuishandisa kune mamwe maverengero akaomarara pabasa rako.

Parizvino iyi chirongwa cheMicrosoft yakagamuchira zvigadziriso zvakanaka izvo zvinokutendera kuti uite macalculation. Unogona kuishandisa kuita manhamba ekuverenga kumakambani makuru. Asi kuti uite izvi, unofanirwa kuziva matanho aunofanira kutevera.

Muchinyorwa chino tinotsanangura kuti iwe unogona sei kukwira muExcel, uchitevera nzira mbiri uye matanho mashoma kuti iwe ugone kukurumidza kuita masvomhu ako.

Iyo simba basa muExcel

Iyo simba basa muExcel Inobatsira zvakanyanya pakuita masvomhu kuverenga, kana uchiishandisa inokupa mhedzisiro yekusimudza nharo yenhamba kune simba. Iyo syntax yesimba basa iri seizvi: SIMBA (nhamba; simba).

Kuti ushandise basa racho unofanirwa kunzwisisa kuti rinoshandiswa sei. Munharo "nhamba"unofanira nyora base yesimba raunoda kuverenga (iyi inofanira kunge iri nhamba chaiyo). Muchikamu "simba"iri exponent kwaunoda kukwidza nhamba iyoyo.

Excel's power function chishandiso chinobatsira kune masvomhu anowanzo kuita zviverengero zvakaomarara. Kunyanya kune avo vanosarudza kusiya kuverenga mumaoko epurogiramu. Nenzira iyi vanogona kutarisa pane mamwe maverengero akaoma mumabasa avo.

Matanho ekudzidza maitiro ekukwereta muExcel nebasa remagetsi

Kukwanisa kushandisa simba rekushanda muExcel uye nokudaro kudzidza nzira yekukwereta muExcelUnogona kutevera matanho ari pasi apa:

1. Chinhu chekutanga chaunofanirwa kuita vhura excel sheet, tinokurudzira kuti ugadzire tafura yakarongedzerwa kana paine nhamba dzakati wandei dzaunoda kuenzanisa.
2. Paunenge uchinge waronga data rako mutafura, iwe unofanirwa kutsvaga chikamu mumenyu huru mafomula.
3. Paunenge uchinge wasarudza iyo mafomula sarudzo, iwe unofanirwa kutsvaga iyo sarudzo munzvimbo yekumusoro kuruboshwe Insert basa.
4. Kuita izvi kunovhura menyu nyowani, maunogona kunyora zita rebasa rauri kutsvaga, mune iyi kesi unofanira kunyora. SIMBA.
5. Kana wangodaro, uchaona kuti unogona sarudza simba basa wobva wadzvanya bvuma.
6. Zvino iwe unoona kuti imwe menyu inovhura sei, umo vanokuudza kuti unofanira nyora nhamba kana hwaro hwesimba. Iwe unofanirwa kugara uchifunga kuti mune iyi sarudzo unogona kuwedzera sero mune iyo nhamba yaunoda kukwereta iripo.
7. Vanokupawo chikamu chaunofanirwa kunyora simba rauri kuzochisimudzira (munyaya iyi inofanira kuva 2).
8. Paunenge uchinge waisa ese ari maviri data, iwe uchaona mhedzisiro yekukwesha nhamba yawakaratidza.

Nekutevera nhanho idzi iwe unozokwanisa kukwereta chero nhamba yaunoda muExcel pasina dambudziko.

Iwe unogona zvakare kushandisa iyo yemagetsi fomula muExcel zvakananga uye nekukuchengetedza matanho mashoma. Kuti uzviwane unogona sarudza sero muExcel sheet yaunoda kuita kuverenga.

Kamwe muchitokisi iwe unongofanirwa kunyora syntax yebasa, asi sefomula “=SIMBA (nhamba; simba)”; paunofanira kutanga wanyora nhamba yaunoda kukwereta uye pamwe nenhamba 2, kuti ugone kuipeta.

Nzira yekuziva maitiro ekukwereta muExcel mumatanho mashoma

Basa resimba haisiriyo nzira chete saka unogona kusimudza mativi. Pane nzira inogona kukurumidza uye yekuverenga kuri nyore. Heano matanho aunogona kutevera:

1. Chinhu chekutanga iwe chaunofanira kuita sarudza sero yaunoda kuratidza sikweya, nhamba.
2. Iye zvino iwe unofanirwa kuisa chinyorwa chinotevera mukati mezvinyorwa "=(nhamba kana sero)^2".
3. Mukati mezvibodzwa munofanira isa nhamba Unoda kukwereta chii kana pinda muchitokisi iripi nhamba yaunoda kuita square.
4. Nekushandisa iyi formula yakananga muchitokisi, iwe unowana mhedzisiro yenhamba yaunoda kukwereta zviri nyore uye nematanho mashoma.

Aya matanho ari nyore uye anogona kubatsira zvakanyanya kana iwe uchida kuita imwe nguva kuverenga.

Chii chandinofanira kuchengeta mupfungwa kana squaring nhamba muExcel?

Paunenge uchidzidza nzira yekukwevera nhamba muExcel, iwe unofanirwa kufunga zvimwe zvakakosha, zvisinei kuti ndeipi nzira mbiri dzauri kushandisa. Pakati pezvaunofanira kufunga nezvazvo ndezvi:

• Panyaya yekushandisa basa SIMBA, kungave iwe unonyora fomula yacho zvakananga pasero kana kuita maitiro neiyo formula menyu. Unofanira kunzwisisa chii chiri hwaro hwesimba uye kuti exponent yekugarove 2, zvirinani mune iyi kesi yaunoda kugara yakaenzana.
• Paunenge uchinyora fomula zvakananga muExcel masero iwe unofanirwa kushandisa chiratidzo "+" kana "="".. Kana ukasadaro, chirongwa hachizive magadzirirwo auri kuyedza kushandisa, semuenzaniso, anofanira kunge ari: “= simba (nhamba; exponent)"Kana"+(nhamba kana sero)^2"
• Izvo zvakakosha kuti ongorora kuti ndeipi sarudzo yakanakisa paunenge uchiverenga sikweya muExcel. Sezvo kana iri kuverenga kwebasa rako, zvinokurudzirwa kuti ushandise fomula yakapihwa neExcel. Nekuti izvi zvinogona kubatsira kana iwe uchida kushandura exponent, kana iwe ukakumbirwa kuti usimudze kupfuura squared.
• Sezvinei, chengeta data rakarongeka nematafura uye uone kuti ndeapi maitiro auri kuverenga uye nekudaro unokwanisa kushandisa nzira dze squaring muExcel nenzira kwayo.

Maitiro ekuziva kukwenya nhamba muExcel haina kunetsa, chero iwe ukashandisa chero maitiro nemazvo, iwe unozokwanisa kuita kuverenga kwako pasina dambudziko.

Zvino zvawadzidza nzira yekukwevera nhamba muExcel, unogona ita masvomhu emhando iyi nekukurumidza, zvisinei nekushandiswa kupi kwauri kupa data rako.