Hezvino Ndezvipi Zvisikwa Zvitsvuku Zvitsvuku NeGreen Triangle Zvinoreva

Iko kune mavara maviri makuru mavara matatu-mutsvuku uye mashizha - anoshandiswa muExcel kuratidza ruzivo kumunhu maererano ne:

• zvikanganiso zvinokwanisika muchitini zviri mukati
• kuvapo kwevashandi kunotaura muchitokisi

Mukuwedzera kune ruvara, denderedzwa inowanikwa mumakona akasiyana esero re worksheet :

• Green - kumusoro kuruboshwe
• Dzvuku-kumusoro kurudyi

Green Triangle

Ikoko hutatu hunoonekwa muchitokisi apo sero riri mukati rinoputsa chimwe chekukanganisa kwe Excel yekuongorora mitemo .

Iyi mitemo inoshandurwa nekutadza uye inotarisa zvikanganiso zvakafanana zvakadai se:

• masero ane zvinyorwa zvinokonzera kukanganisa - zvakadai se #VALUE! kana # DIV / 0!
• mazano asina kukwana kana akasiyana nemaitiro mumasero akapoteredza
• nhamba dzakarongwa semashoko ekunyora

Kana iwe ukananga pane seki rine rutsvuku rwepasitani, bhokisi rinosarudzwa rinosangana naro.

Nzira yekukanganisa mapikicha inonzi yellow diamond mufananidzo we gray gray background iyo ine zvingasarudzwa zvekugadzirisa kukanganisa kwakaonekwa.

Kuvhara Mbiru Triangle

Kukanganisa kutarisa kunoshandiswa nekusara kuExcel kuitira kuti zvitatu zvitatu zvitatu zvioneke pose pose uye pane chero nzvimbo iyo Excel inosarudza kune kutyora kwepamutemo.

Izvi zvisingagoneki zvingashandurwa muExcel Options dialog box .

Kugadzirisa kukanganisa kutarisa:

1. clika File> Options kuti uzarure bhokisi rebhokisi
2. mune chikamu Chekuongorora Cheki chikamu chiri kurudyi-pane pane, bvisa checkmark kubva Kubvumira kutadza kukanganisa kutarisa kusarudza
3. tora OK kuti ubvume kuchinja uye tivhare Options Options box

Kuchinja Mhosva Kuongorora Mitemo

Kuchinja kune kukanganisa kutarisa mitemo inoshandiswa mubhuku rebhuku rinoitwa muExcel Options dialog box.

Kuchinja kukanganisa kutarisa mitemo:

1. clika Faira> Zvimwe
2. mune yekutadza Kuongorora chikamu chikamu chiri muruoko rworudyi, pane kana kuwedzera kana kubvisa maranho ekucherechedza kuti uende kana kuti usiye zvimwe zvisarudzo
3. tora OK kuti ubvume kuchinja uye tivhare Options Options box

Kushandura Triangle & # 39; s Ratidza

Iko ruvara rwemavara rwakasvibiswa rwetatu katatu rungashandurwa muExcel Options dialog box.

Kuti uchinje ruvara rwekatatu:

1. clika Faira> Zvimwe
2. mune chikamu Chekuona Checking chikamu chiri kurudyi-pane pane, sarudza mufananidzo wakasiyana kubva pavara palette pakatarisana neRatidza zvikanganiso uchishandisa muvara
3. tora OK kuti ubvume kuchinja uye tivhare Options Options box

The Red Triangle

Tsamba ine tsvuku yakakona pakona yepamusoro yekamuri inoratidza kuti mufananidzo wevashandi akawedzerwa kusero.

Kuti uverenge rondedzero yacho, funga hovha yekanda pamusoro peyero ine tsvuku yakakosha; pane bhokisi bhokisi rine mazwi achatarisana pedyo nesero.

Zvimwe zvingasarudzwa zvekuratidza nekuratidzira zvinyorwa ndezvi:

• kusaratidza mitsara kana zviratidzo-kunyange kana uchifamba pamusoro pekero rine mazwi
• nguva dzose kuratidza zvinyorwa uye zviratidzo zvese masero ane mibvunzo

Kushandurwa kwenyaya kunodzokorodzwa kunoitwa muExcel Options dialog box.

Kuti uchinje mararamiro emashoko:

1. clika Faira> Zvimwe> Zvakawedzerwa
2. pasi pe> Ongororo chikamu chiri kurudyi-pane pane, ita shanduko kuIkuda masero ane mibvunzo anoratidza: sarudzo
3. tora OK kuti ubvume kuchinja uye tivhare Options Options box

Excel zvigadziro zvekusika, kugadzirisa, kufamba, kana kubvisa zvinyorwa zvemasero zviri pasi peTabhori rebhu muChikamu cheMashoko ebhebhoni.