Kubvisa nhamba mbiri kana kupfuura kuExcel ine fomu
Kuti ubvise nhamba mbiri kana kupfuura muExcel unoda kugadzira fomu .
Pfungwa dzinokosha yekuyeuka pamusoro peExcel mazita dzinosanganisira:
- Mifananidzo iri muExcel inotanga nguva dzose nechiratidzo chakaenzana ( = );
- Chirevo chacho chinogara chichiiswa mujeri apo iwe unoda kuti mhinduro ioneke;
- Chiratidzo chokubvisa mu Excel ndiro dash (-);
- Icho chinyorwa chinopedzerwa nekudhinda Enter key pane keyboard.
Achishandisa Cell References muFormulas
Kunyange zvazvo zvichikwanisika kuisa nhamba zvakananga mumushonga (sezvakaratidzwa mumutsara wechipiri wemuenzaniso), kazhinji zviri nani kupinda mu data mumashandisi ekushanda uye zvino shandisa maateri kana zvinyorwa zvemasero aya mumutsetse (mutsara 3 zvemuenzaniso).
Nekushandisa sero zvinyorwa panzvimbo yezviri chaiyo yedhimwe mumusarudzo, gare gare, kana zvichizodikanwa kuchinja data , iyo nyaya yakanyanyisa yekutsvaga data mumasero pane kunyorazve maitiro.
Zvigumisiro zvemugadziro zvichavandudza kamwe chete kana data ichichinja.
Imwe nzira ndeyekubatanidza zvikamu zvinyorwa uye data chaiye (mutsara 4 wemuenzaniso).
Kuwedzera Parenthesis
Excel ine chirongwa chekushanda iyo inotevera kana kuongorora kuti masvomhu inoshandiswa kuita sei pakutanga mumutemo.
Sezvakaitwa mumatunhu echikwata, urongwa hwekushanda hunogona kuchinjwa nekushandura mazera semuenzaniso unoratidzwa mumitsara mashanu nematanhatu pamusoro apa.
Kubvisa Maitiro Emuenzaniso
Sezvakaratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unogadzira fomu muchitokisi D3 iyo inobvisa deta iri muchitsetse A3 kubva pane data iri muB3.
Iyo yakagadzirwa mazai muchitokisi D3 ichava:
= A3 - B3
Point and Click on Cell References
Kunyange zvazvo zvichikwanisika kungonyora fomu iri pamusoro apa muchikamu cheD3 uye kuti mhinduro yakarurama ioneke, zviri nani kushandisa pfungwa uye chengeta kuti uwedzere sero zvinyorwa zvemafomu kuitira kuti kuderedza zvinganganisa zvikanganiso zvakagadzirwa nekunyora mune imwe sero isina kunaka tsanangudzo.
Point nechokuita zvinosanganisira kuvhara masero ane deta pamwe ne mouse pointer kuwedzera sero rinotaridzirwa.
- Tora mufananidzo wakaenzana ( = ) muchitokisi D3 kuti utange fomu.
- Dzvanya pane sero A3 ine mouse pointer kuti uwedzere kuti sero rinotarisa kumushure mushure mekuona kwechiratidzo.
- Tora imwe minus ( - ) mushure memasekurefeta.
- Dzvanya pane sero B3 kuti uwedzere kuti sero rinotarisa mushure mushure mechiratidzo chisina kukodzera.
- Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
- Mhinduro 10 inofanira kuva iri muchitokisi E3.
- Kunyange zvazvo mhinduro kumanyorerwo inoratidzwa muchitokisi E3, kuvhara paiyo seni kucharatidza fomu iri mubhadharo yepamusoro pane pepa pepaji.
Kuchinja Data Formula
Kuti uedze kukosha kwekushandisa masero ekufambisa mune fomu, ita shanduko kune nhamba muchitokisi B3 (zvakadai sokuenda kubva ku5 kusvika ku4) uye divhai muIno yeKuisa pane keyboard. Mhinduro yacho muchitokisi D3 inofanira kuongororwa patsva kuti iratidze kuchinja kwe data muchitokisi B3.
Kuumba Zvimwe Zvinyorwa Zvakawanda
Kuwedzera huwandu hunoita kuti uwedzere mamwe maitiro (zvakadai sokuparadzanisa kana kuwedzera) sezvinoratidzwa mumutsara wechinomwe, ramba uchiwedzera kuwedzera yakakodzera mashematical operator inoteverwa nesero rinenge rine data itsva.
Kuti uite tsika, edza muenzaniso uyu wedanho nechikamu chekunyanya kwakaoma .