Tsanangudzo yakatenderera inoitika muExcel apo:
- Shanduro inosanganisira sero rinoreva sero iri rine maitiro acho pacharo. Muenzaniso wechirudzi urwu rweutenderedzwa hunoratidzwa mumufananidzo uri pamusoro apa apo fomu iri muchitokisi C1 ine chinyorwa kune iyo cell mumutsetse: = A1 + A2 + A3 + C1
- Chirevo chekufananidzira pane imwe sarudzo iyo inoguma ichitaura kumaseri inenge yakasikwa yepakutanga. Muenzaniso werudzi urwu rwusingazivikanwi sezvarunozivikanwa runoratidzwa mumuenzaniso wechipiri mumufananidzo apo miseve yebhuruu inobatanidza masero A7, B7, uye B9 inoratidza kuti mafomu mumasero ose anotarisana.
Circular Reference Warning
Sezvinoratidzwa mumufananidzo wepamusoro, kana rondedzero yerutema inowanikwa mune rimwe rekushandura chekushandura, purogiramu inoratidzira yeAlert dialog box inoratidza dambudziko.
Mharidzo iri mubhokisi rebhokisi inonyanya kutaurwa nokuti hazvisi zvose zvinyorwa zvinyorwa zvinyorwa zvisingabatsiri sezvinotsanangurwa pasi apa.
"Kunyatsocherechedza, takawana imwe kana kupfuura zvinyorwa zvinyorwa mubhuku rako rebasa rinogona kuita kuti fomu yako iverenge zvisina kururama"
Sarudzo dzeMushandisi
Mushandisi angasarudzwa kana iri bhokisi rebhokisi rinowanikwa ndeyekutora OK kana kuti Kubatsira, uye hapana iyo inogona kugadzirisa dambudziko rekutarisa denderedzwa.
Kana iwe ukaverenga shoko refu uye rinopesana naro mubhokisi rebhokisi iwe uchaona kuti:
- kunyorera paRubatsiro kunoshandiswa kushandiswa apo rondedzero isina kutarisirwa yechirungu inowanikwa; izvi zvinokutora iwe kuExcel rubatsiro rwefayili ruzivo pamusoro pezvinyorwa zvinyorwa;
- kunyorera OK kunoshandiswa kutaurira Excel kuti kutaurwa kwechiyero kwakaitwa nemaune uye kuti inofanira kuisiya panzvimbo.
Unintentional Circular References
Kana tsanangudzo yechirungu ichiitwa pasina chikonzero, ruzivo rwefaira rubatsiro ruchakuudza kuti ungaita sei nekuwana nekubvisa zvinyorwa zvitsvene.
Faira rubatsiro rinokutungamirira kushandisa shanduko yeExcel Error Checking iri pasi peFormula> Formula Auditing pabhoni.
Mazhinji akawanda asingatarisirwi masero anokwanisa kugadziriswa kunze kwekudiwa kwekanganiso kutarisa nekugadzirisa zvinyorwa zvese zvishandiswa mumutsetse. Panzvimbo pekunyora zviyero zvesekeri mumugadziro, shandisa kureva ------------------ kuchinyanya pane zvinyorwa zvinyorwa pamwe nemushonga -------------- -------- kuisa zvinyorwa mumusarudzo.
Intentional Circular References
Shanduro yechipetesa yeExcel haiti kupa kugadzirisa dambudziko rekutarisa rakatenderera nokuti hazvisi zvose zvinyorwa zvinyorwa zvikanganiso.
Kunyange zvazvo izvi zvinyorwa zvisingatauri zvinyorwa zvisinganyanyozivikanwi kupfuura zvisingatarisiri, zvinogona kushandiswa kana iwe uchida kuti Excel iitezve kana kuti ishandise maitiro akawanda kakawanda musati mava nemugumisiro.
Kubatsira Maitiro Ekutora
Excel ine sarudzo yekugonesa maverengero aya ekutarisa kana iwe uronga kuzvishandisa.
Kuti zvibatsire kuverenga kuverenga:
- Dzvanya paDhiyabhorosi tab (kana bhodhi yeHofisi muExcel 2007)
- Dzvanya Mahitamo kuti uzarure Excel Options dialog box
- Muchikamu chekuruboshwe-bhokisi rebhokisi rebhokisi, chengetai Mafomu
- Muruoko rworudyi rwebhokisi rebhokisi, sarudza Ita kuti iterative kuverenga mabhokisi chekuongorora
Pasi pemabhokisi ekutora mabhuku anowanikwa ku:
- kugadzika nhamba yakakura yekudzokorora: nhamba yenguva Excel inofanira kudzokorora chirevo
- kuisa huwandu hwekuchinja hunogamuchirwa pakati pemigumisiro yekuverenga: iduku nhamba, yakanyanya kunyatsogadzirwa
Kuratidza Zeros Mumiririri Akabatwa
Kune masero ane zvinyorwa zvitsvene, Excel inoratidza zero sezvinoratidzwa muchitokisi C1 mumuenzaniso kana wekupedzisira kuverengwa kwemu cell.
Mune zvimwe zviitiko, mafomu anogona kumhanya kubudirira vasati vaedza kuverenga kukosha kwesero renzvimbo kwavari. Kana izvozvo zvikaitika, sero rine chinyorwa chinoratidza kukosha kubva pakupedzisira kubudirira kuverenga.
Zvimwe Pamusoro peSycular Reference Chenjerera
Mushure mokutanga kwechirevo chakange chine tsanangudzo yechirungu mubhuku rebhuku , Excel haingati ichataridza shoko renyevero zvakare. Izvo zvinoenderana nemamiriro ezvinhu ekuti sei uye kupi apo zvimwe zvinyorwa zvitsvene zvinoshandiswa.
Mienzaniso yekuti bhokisi rekucherechedza riri nemashoko ekunyevera richaratidzwa kune zviitiko zvinotevera zvinyorwa zvinosanganisira:
- Chiitiko chekutanga chekutenderera kushandiswa mubhuku chero ripi zvaro rakavhurwa;
- Mushure mokubvisa zvose zvinyorwa zvinyorwa mumabhuku ose ebasa akazaruka, mutsva yekutenderera yakasikwa;
- Mushure mokuvhara mabhuku ose ebasa, chirevo chine rondedzero yechirungu chakasikwa mubhuku rebasa idzva;
- Bhuku rebhuku rine rondedzero yechirungu rinotanga.