Nazi ezinye ii-Indicators ze-Triangle ze-Red Excel

Kukho ezimbini iinqununu ezinobumba obomvu - obomvu kunye nobuluhlaza - ezisetyenziswe kwi-Excel ukubonisa ulwazi kumsebenzisi ngokuphathelele:

• iimpazamo ezinokwenzeka kwi-cell content
• ubukho bemibono yomsebenzisi kwiseli

Ukongezelela kumbala, unxantathu uvela kwiinkalo ezahlukeneyo zeselithi lomsebenzi :

• Uluhlu oluphezulu-oluphezulu
• I-Red-top right

IGreen Triangle

Unxantathu obomvu uvela kwiseli xa okuqukethwe kweeseli kwephula enye yephutha le-Excel yokujonga imithetho .

Le migaqo ivuliwe ngokungafi kwaye ibeka iliso kwiiphene ezifanayo ezifana:

• iiseli ezinamafomula ezibangelwa yimpazamo - njenge-#VALUE! okanye # DIV / 0!
• iifomula ezingahambelaniyo okanye ezahlukileyo kwiifomula kumaseli azungezile
• amanani afomathiweyo njengedatha yombhalo

Ukuba ucofa kwiseli elinexantathu eluhlaza, inkinobho yokukhethwa kwephutha ibonakala ngasemva kwayo.

Inkcenkca yenkcazo yempuphu isimo sedayimnyama sephuzi kunye nomgca wegreyati egciniweyo equlethe inketho yokulungisa isiphoso esicatshulwayo.

Ukuguqula i-Triangle

Iphutha lokutshekisha livuliwe ngokungagqibekanga kwi-Excel ngoko-ke ama-triangles aluhlaza avela nanini na naphi na apho i-Excel ibeka khona ukuphulwa komthetho.

Oku kungagqibekanga kungatshintshwa kwibhokisi yencoko ye - Excel .

Ukucima impazamo yokuhlola:

1. cofa Ifayile> Izinketho zokuvula ibhokisi yencoko
2. kwiCandelo loKuhlola Iphuso kwi-pane yesandla sokunene, susa uphawu lokukhangela ukusuka ku- Nika amandla impazamo yangasemgceni ukujonga inketho
3. nqakraza Kulungile ukwamkela utshintsho uze uvale ibhokisi yencoko yencoko

Ukutshintsha Iphutha lokuhlola iMigaqo

Utshintsho kwimpazamo yokuhlola imigaqo esetyenziswe kwincwadi yencwadi yenziwe kwibhokisi yencoko ye- Excel .

Ukutshintsha impazamo yokuhlola imigaqo:

1. cofa Ifayile> Khetha
2. kwiCandelo leMithetho yokuPhonononga kwephutha kwi-pane yesandla sokunene, engeza okanye ukususa amanqaku okujonga ukuvula okanye ukucima ukhetho olukhethiweyo
3. nqakraza Kulungile ukwamkela utshintsho uze uvale ibhokisi yencoko yencoko

Ukutshintsha i-Triangle & # 39; s Umbala

Umbala ongapheliyo wolu ngxantathu ungaguqulwa kwibhokisi yebhokisi yencoko ye Excel .

Ukutshintsha umbala wexantathu:

1. cofa Ifayile> Khetha
2. kwiCandelo lokuHlola i- Error ngakwesokudla, uze ukhethe umbala ohlukileyo ukusuka kumbala wepeyinti ecaleni kweSalathisi.
3. nqakraza Kulungile ukwamkela utshintsho uze uvale ibhokisi yencoko yencoko

I-Triangle Triangle

Inxantathu ebomvu ekhoneni eliphezulu lasekunene leseli ibonisa ukuba ingxelo yomsebenzisi ifakwe kwiseli.

Ukuze ufunde amazwana, gxuma isikhombisi se mouse phezu kweseli equkethe unxantathu obomvu; ibhokisi yombhalo equkethe ukuphawula kuya kuvela kwiseli.

Izinketho ezongezelelweyo zokubonisa nokubonisa izimvo zi:

• ukungabonakali namagqabaza okanye izibonakaliso-nangona xa uhamba phezu kweseli equle izimvo
• soloko ebonisa izimvo kunye nezibonakaliso kuzo zonke iiseli ezinamazwana

Utshintsho kumazwi angaguqukiyo enziwe kwibhokisi yebhokisi yencoko ye Excel .

Ukutshintsha okukhethwa kukho izimvo:

1. nqakraza ifayile> Iimpawu> Eziphambili
2. phantsi kwe> Icandelo lokubonisa kwicala lokunene, yenza utshintsho kwiiseli eziqulethe izimvo zibonisa: ukhetho
3. nqakraza Kulungile ukwamkela utshintsho uze uvale ibhokisi yencoko yencoko

Izikhetho ze-Excel zokudala, ukuhlela, ukuhamba, okanye ukususa izimvo zeseli zifumaneka phantsi kwethebhu yokuHlola kwiCandelo lamaNgxelo webhebhoni.