Izindlela zokushintsha amaziro ngokuqukethwe okuhlanzekile, ideshi noma umbhalo ku-Excel

Isibuyekezo sokugcina: 04/10/2024
Author: Javier Chirinos
Faka esikhundleni Uziro Ngokungenalutho, Ideshi noma Umbhalo ku-Excel

Ngokuvamile, ukuba khona kwama-zero endaweni yedatha ye-Excel kungenza ama-histogram nezinhlobo ezahlukene zamagrafu zibonakale zinganembile. Ngezansi uzothola izinyathelo zokufaka oziro esikhundleni sokuqukethwe okuhlanzekile, Ideshi noma umbhalo ku-Excel.

Izindlela zokushintsha ama-zero ngokufaka acacile ku-Excel

Ngaphambi kokulandela izinyathelo zokushintsha oziro ngamavelu afanelekile ku-Excel, kufanele wazi ukuthi ukufaka oziro ngamavelu afanelekile kuyafana nokususa ulwazi kumaseli anamanani ayiziro.

Ngemva kokukhipha oziro ku-Excel, wonke amaseli anamaqanda azolahlekelwa ulwazi futhi azophathwa njengamaseli angenalutho angenalo ulwazi.

Uma ufaka udeshi (-) esikhundleni soziro ngodwi (-) noma okuqukethwe kombhalo ku-Excel, ungase uhlangabezane namaphutha uma amaseli anodeshi noma indawo yokuqukethwe okubhaliwe ekhonjwa ekwakhiweni okuthile.

Uma lokhu sekuqondisiwe, ake sizame izinyathelo zokushintsha oziro ngendawo efanele, ideshi noma okuqukethwe kombhalo ku-Excel.

1. Shintsha oziro nabacacile ku-Excel

Landela lezi zinyathelo ezingezansi ukuze umiselele oziro ngezikhala ku-Excel.

1. Khetha Imininingwane ephelele ofuna ukufaka ama-Zero esikhundleni samaseli ahlanzekile.

2. Cindezela inkinobho Isakhamuzi ithebhu > chofoza Sesha bese ukhetha engxenyeni ethi “Ukuthuthukiswa” bese ukhetha okuthi Edita kumenyu eyehlayo.

Thola bese Ushintsha Inketho ku-Excel

3. Ebhokisini lengxoxo elithi “Zitholele futhi Uhlele”, faka 0 endaweni ethi “Thola ukuthi ini” > susa indawo ethi “Shintsha nge” vacío (ungafaki lutho kuyo) bese ucindezela Izinketho.

Vula okuthi Thola bese Ufaka esikhundleni

4. Enkambini enwetshiwe ethi "Zitholele futhi Ushintshe", khetha... Ihambisana nokuqukethwe okuphelele kwamaseli kungenzeka bese uchofoza shintsha konke inkinobho.

Shintshanisa wonke ama-zero ku-Excel ngezikhala ezingenalutho

Uma uchofoza inkinobho ethi "Shintsha Konke", wonke amaseli kudatha yakho anoziro kuwo azoba nalutho ngaso leso sikhathi.

  iperf3 ku-multi-threading ukuze uthole okuningi ku-10GbE: umhlahlandlela ophelele

2. Shintsha oziro ngeDash ku-Excel

Enye indlela yokubhekana namanani anguziro ku-Excel ukufaka oziro esikhundleni sikadeshi (-). Ungakwenza lokhu usebenzisa umsebenzi wefomethi yenani langokwezifiso elikhona ku-Excel.

1. Khetha Imininingwane ephelele ofuna ukushintsha oziro ngodeshi.

2. Cindezela inkinobho Isakhamuzi ithebhu > khetha ifomethi kungenzeka eqenjini elithi "Amaseli" > chofoza Ifomethi amaseli... kumenyu eyehlayo.

Inketho yokufometha iseli ku-Excel

3. Ebhokisini lengxoxo lamaseli efomethi, chofoza inkinobho Inani futhi kukhethiwe Isiko kuphaneli yesokunxele. Kuphaneli engakwesokudla, faka 0;-0 ;»-« kunkambu ethi "Uhlobo".

Shintshanisa ama-zero ngamakhonco ku-Excel

4. Qhafaza OK ukonga okuningi nokusebenzisa lolu shintsho.

Uma uchofoza okuthi KULUNGILE, amaseli anamanani angu-0 azoboniswa ngodeshi (-). Futhi, uma kwenzeka ufake uziro kuseli, cishe uzoshintshwa ube udeshi (-).

3. Shintsha ama-zero abe okuqukethwe okubhaliwe ku-Excel

Ungakwazi futhi ukushintsha oziro nganoma iyiphi inkambu yokuqukethwe kombhalo ku-Excel. Isibonelo, ungashintsha oziro baye ku-"NA", "Cha" nanoma yikuphi okunye okuqukethwe kombhalo.

1. Khetha Imininingwane ephelele uma ufuna ukushintsha oziro bokuqukethwe kombhalo.

2. Cindezela inkinobho Isakhamuzi ithebhu > khetha ifomethi kungenzeka eqenjini elithi "Amaseli" > chofoza Fometha amaseli... kumenyu eyehlayo.

Inketho yokufometha iseli ku-Excel

3. Ebhokisini lengxoxo lamaseli efomethi, chofoza inkinobho Inani futhi kukhethiwe Isiko kuphaneli yesokunxele. Kuphaneli engakwesokudla, faka 0;-0 ;[Inethiwekhi]»ND» kunkambu ethi "Uhlobo".

Shintshanisa amaziro ngombhalo ku-Excel

4. Qhafaza OK ukonga okuningi nokusebenzisa lolu shintsho.

Uma uchofoza okuthi KULUNGILE, wonke amaseli anamanani angu-0 azobonisa umbhalo othi “NA” ngokunsomi.

Izwi: Uma ufuna ukukhombisa "NA" emthunzini ovamile, kufanele nje u-oda 0;-0; "NA.

  Ungafometha kanjani amadokhumenti e-Word usebenzisa isitayela se-APA isinyathelo ngesinyathelo

4. Thola oziro ku-Excel

Uma ungadingi ukususa oziro ngokushesha, ungaqala ngokuthola oziro endaweni yolwazi, ukhethe bonke oziro, bese ubakhipha uma kudingeka.

1. Khetha isethi ephelele Ulwazi ngamavelu angenalutho

2. Cindezela inkinobho Isakhamuzi ithebhu > chofoza Sesha bese ukhetha engxenyeni ethi “Ukuthuthukiswa” bese ukhetha okuthi Edita kumenyu eyehlayo.

Thola bese Ushintsha Inketho ku-Excel

3. Ebhokisini lengxoxo elithi “Zitholele futhi Uhlele”, faka 0 endaweni ethi “Thola ukuthi ini” > susa indawo ethi “Shintsha nge” vacío (ungafaki lutho kuyo) bese ucindezela Izinketho.

Vula okuthi Thola bese Ufaka esikhundleni

4. Enkambini enwetshiwe ethi "Zitholele futhi Ushintshe", khetha... Ihambisana nokuqukethwe okuphelele kwamaseli kungenzeka bese uchofoza Ulwazi oluningi inkinobho.

Thola wonke ama-zero ku-Excel

5. Uma uchofoza okuthi Veza Konke, amaseli anamanani anguziro ayagqanyiswa.

6. Gcina i- Ukhiye wokuphatha bese ucindezela inkinobho Ukhiye A ukuze ukhethe wonke amaseli aqukethe u-0.

Manje njengoba usukhethe wonke amaseli anamanani angu-0, ungakwazi ukususa oziro, ubeke oziro esikhundleni sanoma yiluphi uhlamvu, noma ugqamise amaseli ngoziro.

  • Izindlela zokuthola izimpinda ku-Excel usebenzisa ukufometha okunemibandela
  • Izindlela zokudala ithebula le-pivot ku-Excel