Shandisai zvinyorwa zvinyorwa uye urevere kuti uwedzere ku Excel
Sezvo nehuse hwemasvomhu maitiro muExcel, kuwedzera maviri kana akawanda kunosanganisira kugadzira chirevo.
Pfungwa dzinokosha kuti uyeuke nezveExcel formula:
- Zvimwe muExcel zvinotanga nguva dzose nechiratidzo chakaenzana ( = ).
- Chiratidzo chakafanana nguva dzose chinopinda muchitokisi umo unoda kuti mhinduro ionekwe.
- Chiratidzo chekuwedzera kana kuti chinoshandiswa mu Excel mazano ndiyo asterisk ( * ) chiratidzo.
Achishandisa Cell References muFormulas
Kunyange zvazvo zvichikwanisika kuisa nhamba zvakananga mumutsetse, zviri nani chaizvo kupinda mu data mumashandisi ekushanda uye usingashandisi maateri kana zvinyorwa zvemasero aya mumutambo.
Kubatsira kukuru kushandisa sero zvinyorwa mune chirevo, pane kuti chaiyo data, ndeyokuti, kana pane imwe nguva inotevera, inenge yakakodzera kuchinja data, iyo nyaya yakanyanyisa yekutsvaga deta iri mumasero ekutsva pane kunyorazve the formula.
Zvigumisiro zvemugadziro zvichazovandudza kamwe chete kana data iri mumasero ekushanduka ichichinja.
Kupinda Maferensi emunzvimbo Kushandisa Kujekesa
Uyezve, kunyange zvazvo zvichikwanisika kungongoridza zvinyorwa zvinoshandiswa kuti zvishandiswe mumutsetse, nzira iri nani ndeyokushandisa kuratidza kuwedzera zvinyorwa zvese.
Kutaura kunosanganisira kusarudza masero ekutsvaga ane deta nemushonga we mouse kuti uwedzere kushandiswa kwekero kumutsetse. Zvakanakira kushandisa iyi nzira ndeyokuti inoderedza kusanganisa kwezvikanganiso zvakagadzirwa nekunyora mune zvisina kururama sekutsanangurwa.
Kuwandisa Formula Example
Sezvinoratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unobatanidza fomu muchitokisi C1 iyo inowedzera deta iri muchitokisi A1 nedheta iri muA2.
Iyo yakagadzirwa mazai muchitokisi E1 ichava:
= A1 * A2
Kupinda Data
- Tora iyo nhamba 10 mumusasa A1 uye shandisai Enter key pane keyboard,
- Tora iyo nhamba 20 muchikamu cheA2 uye tapinda muIndeni ,
Kupinda Muforomo
- Dzvanya pachitokisi C1 kuti uite iyo inoshanda masero - iyi ndiyo iyo migumisiro yechirongwa icharatidzwa.
- Tanga = (an equal equal ) muchitokisi C1.
- Dzvanya pane sero A1 ine mouse pointer kuti uise iyo seferensi iri mumutsetse.
- Ita * * ( asterisk symbol ) mushure meA1.
- Dzvanya pane sero A2 ine mouse pointer kuti uise iyo cell reference.
- Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
- Mhinduro 200 inofanira kunge iri muchitokisi C1.
- Kunyange zvazvo mhinduro yacho inoratidzwa muchitokisi C1, kuvhara pachitoro ichocho kucharatidza rondedzero chaiyo = A1 * A2 mubhadha yepamusoro pane pepa pepaji.
Kuchinja Data Formula
Kuti uedze kukosha kwekushandisa sero zvinyorwa mumutsara:
- Shandura nhamba iri muchitokisi A2 kubva pa20 kusvika ku5 uye shandisa pikicha inopinda mubhokisi.
Mhinduro yacho muchitokisi C1 inofanira kuenderera mberi kusvika ku 50 kuti iratidze kuchinja kwe data muchitokisi A2.
Kuchinja Mutemo
Kana zvichizodiwa kugadzirisa kana kushandura chirevo, zviviri zvezvakanakisisa zvinosarudzwa ndezvi:
- Tora kaviri chirevo chacho mubasa rekushanda kuti uise Excel muHarimi mode uye ugoita shanduko kumutsetse. Izvi zvinoshanda zvakanakisisa nokuda kwekuchinja kuduku.
- Dzvidza kamwechete pane sero rine chinyorwa uye wodzokorora fomu yose. Iyi nzira yakanakisisa pakuchinja kukuru.
Kuumba Zvimwe Zvinyorwa Zvakawanda
Kunyora mazano akawanda akaoma anosanganisira mabasa akawanda - akadai sokubvisa, kuwedzera, nokuparadzanisa, uyewo kuwedzera - kungowedzera masaiti chaiwo emasvomhu nenzira yakarurama yakateverwa nesero zvinyorwa zvine data.
Pamberi kusanganisa mahedheni akasiyana-siyana kushanda pamwe chete mumurairo, zvakadaro, zvakakosha kunzwisisa mutemo wekushanda iyo Excel inotevera kana uchitarisa fomu.
Kuti uite tsika, edza muenzaniso uyu wedanho nechikamu chekunyanya kwakaoma .