Kunezinhlanzi ezimbili eziyinhloko ezintathu ezibomvu - ezibomvu neziluhlaza - ezisetshenziswa ku-Excel ukuze zibonise ulwazi kumsebenzisi mayelana nalokhu:
- amaphutha kungenzeka emininingwaneni yeseli
- ukuba khona kwamazwana womsebenzisi esitokisini
Ngaphezu kombala, unxantathu uvela emaqenjini ahlukene weseli lokusebenzela :
- I-Green - phezulu kwesokunxele
- Okubomvu - phezulu ngakwesokudla
I-Green Triangle
Unxantathu obuluhlaza uvela esitokisini lapho okuqukethwe kweli cell kuphula enye yephutha lokuhlola i- Excel.
Le mithetho ivuliwe ngokuzenzakalelayo futhi iqapha amaphutha avamile afana nalokhu:
- amaseli aqukethe amafomula abangela iphutha - njenge- #VALUE! noma # DIV / 0!
- amafomula ahambisanayo noma ahlukile kumafomula amangqamuzana azungezile
- izinombolo ezifakwe njengedatha yombhalo
Uma uchofoza esitokisini esinexantathu eluhlaza, inkinobho yokukhethwa kukho iphutha ibonakala eceleni kwayo.
Inkinobho yokukhethwa kukho iphutha yindlela yokuma idayimani ephuzi enemuva yesikwele esiphezulu equkethe izinketho zokulungisa iphutha elibonwe.
Ukuvula i-Triangle
Iphutha lokuhlola livuliwe ngokuzenzakalelayo ku-Excel ngakho-ke ama-triangles aluhlaza avela noma nini nanoma yikuphi lapho i-Excel inquma ukuthi kube khona ukwephulwa komthetho.
Lokhu okuzenzakalelayo kungashintshwa ebhokisini lezingxoxo ze- Excel .
Ukuvala iphutha lokuhlola:
- chofoza Ifayela> Izinketho zokuvula ibhokisi lengxoxo
- kusigaba sokuhlola ukuphutha kwesokudla ngakwesokunxele, susa uphawu lokuhlola kusuka kuVumela ukukhethwa kokuphutha kwangemuva
- chofoza u-OK ukwamukela ushintsho bese uvale ibhokisi lengxoxo yezinketho
Ukushintsha Iphutha Lokuhlola Imithetho
Izinguquko ekubhekeni kwephutha imithetho esetshenzisiwe encwadini yokusebenzela zenziwe ebhokisini lengxoxo ye- Excel .
Ukushintsha iphutha lokuhlola imithetho:
- chofoza Ifayela> Izinketho
- kuNgxenye Yezimiso Zokuhlola Iphutha ekhoneni lesokudla, engeza noma ususe amamaki wokuhlola ukuvula noma ukuvala izinketho ezihlukahlukene
- chofoza u-OK ukwamukela ushintsho bese uvale ibhokisi lengxoxo yezinketho
Ukushintsha Umbala we-Triangle & # 39; s
Umbala ozenzakalelayo oluhlaza walolonxantathu ungashintshwa ebhokisini lezingxoxo ze- Excel .
Ukushintsha umbala wendantshana:
- chofoza Ifayela> Izinketho
- kusigaba sokuhlola ukuphutha kwesokudla ngakwesokudla, khetha umbala ohlukile kumdwebo wemibala eceleni kwe- Khombisa amaphutha usebenzisa lo khetho lombala
- chofoza u-OK ukwamukela ushintsho bese uvale ibhokisi lengxoxo yezinketho
I-Red Triangle
Unxantathu obomvu ekhoneni elingakwesokudla kweseli kubonisa ukuthi ukuphawula komsebenzisi kungeziwe esitokisini.
Ukuze ufunde amazwana, hlela isikhombisi segundane phezu kweseli equkethe unxantathu obomvu; ibhokisi lombhalo equkethe ukuphawula kuzovela eceleni kweseli.
Izinketho ezengeziwe zokukhombisa nokubonisa amazwana yizi:
- engabonisi amazwana noma izinkomba - ngisho nalapho ehamba phezu kweseli equkethe amazwana
- njalo ubonisa imibono nezinkomba zazo zonke amaseli aqukethe ukuphawula
Izinguquko ekubekeni kwamazwana zenziwe ebhokisini lengxoxo ye- Excel .
Ukushintsha izinketho zokuphawula:
- chofoza Ifayela> Izinketho> Kuthuthukile
- ngaphansi kwesigaba> Ukubonisa ngakwesokudla kwesokunxele, yenza ushintsho ku- Amaseli anamazwana abonisa: inketho
- chofoza u-OK ukwamukela ushintsho bese uvale ibhokisi lengxoxo yezinketho
Izinketho ze-Excel zokudala, ukuhlela, ukuhamba, noma ukususa amazwana weselula atholakala ngaphansi kwethebhu yokubuyekeza kusigaba samazwana sebhebhoni.