Ungayisebenzisa kanjani i-Excel ukuhlaziya idatha? Kungumbuzo ojwayelekile esizibuza wona lapho sidinga ukusebenzisa leli thuluzi elinamandla le-Microsoft ukwenza ukuhlaziya idatha. I-Excel iwuhlelo oluguquguqukayo olusivumela ukuthi sihlele, sibale futhi sibone ngeso lengqondo idatha ngempumelelo. Kulesi sihloko, sizohlola eminye yemisebenzi ebalulekile nezici ze-Excel ezizokusiza ukuhlaziya idatha yakho kalula nangempumelelo. Zitholele ukuthi ungathola kanjani okuningi kuleli thuluzi futhi uthole imininingwane ebalulekile kumasethi wakho wedatha.

Isinyathelo ngesinyathelo ➡️ Uyisebenzisa kanjani i-Excel ukuhlaziya idatha?

• Isinyathelo se-1: Vula i-Excel kukhompyutha yakho
• Isinyathelo se-2: Dala isipredishithi esisha ngokuchofoza “Ifayela” bese “Okusha”
• Isinyathelo se-3: Qamba kabusha isipredishithi ukuze ubone isethi yedatha ozoyihlaziya
• Isinyathelo se-4: Faka idatha kusipredishithi, uqiniseke ukuthi ikholomu ngayinye imelela isigaba futhi umugqa ngamunye umele ukufakwa kwedatha.
• Isinyathelo se-5: Sebenzisa amafomula e-Excel ukwenza izibalo kudatha. Ungangeza, ukhiphe, uphindaphinde noma uhlukanise amaseli ukuze uthole imiphumela
• Isinyathelo se-6: Isebenzisa izihlungi kudatha ukuze ihlaziye kuphela ingxenye ethile yesethi yedatha. Ungahlunga ngamavelu, umbhalo noma amadethi
• Isinyathelo se-7: Sebenzisa amagrafu ukuze ubone idatha yakho ngeso lengqondo. Ungakha amashadi ebha, amashadi ophayi, noma amashadi emigqa ukuze umelele ulwazi ngokucacile.
• Isinyathelo se-8: Yenza ukuhlaziya kwezibalo usebenzisa imisebenzi eyakhelwe ngaphakathi ye-Excel. Ungakwazi ukubala isilinganiso, ukuchezuka okujwayelekile noma inani eliphakeme nelincane yedatha yakho
• Isinyathelo se-9: Gcina ifayili lakho le- Ifayela le-Excel ukuze ukwazi ukuyifinyelela esikhathini esizayo. Chofoza "Ifayela" bese "Londoloza"

Q&A

Ungayisebenzisa kanjani i-Excel ukuhlaziya idatha?

1. Ivula kanjani i-Excel kukhompyutha yami?

1. Thola isithonjana se-Excel etafuleni noma kwimenyu yokuqala.

2. Chofoza kabili isithonjana se-Excel.

2. Usenza kanjani isipredishithi esisha?

1. Vula i-Excel kukhompuyutha yakho.

2. Chofoza ithebhu 'Yefayela' phezulu kwesokunxele kwesikrini.

3. Khetha 'Okusha' kumenyu yokudonsela phansi.

4. Chofoza 'Ispredishithi Esingenalutho'.

3. Uyifaka kanjani idatha kusipredishithi se-Excel?

1. Chofoza iseli lapho ofuna ukufaka khona idatha.

2. Thayipha idatha kubha yefomula phezulu esikrinini.

3. Cindezela u-'Enter' kukhibhodi yakho ukuze uqinisekise idatha efakiwe.

4. Uzenza kanjani izibalo eziyisisekelo ku-Excel?

1. Khetha iseli lapho ofuna kuvele khona umphumela wokubala.

2. Thayipha uphawu olulinganayo (=) kubha yefomula.

3. Faka ifomula yesibalo osifunayo (isibonelo, “=A1+B1” ukuze wengeze amanani kumaseli A1 kanye no-B1).

4. Cindezela u-'Enter' kukhibhodi yakho ukuze uthole umphumela wokubala.

5. Ungafometha kanjani idatha ku-Excel?

1. Khetha amaseli ofuna ukuwafometha.

2. Chofoza kwesokudla kumaseli akhethiwe bese ukhetha 'Fometha Amaseli' kumenyu yokudonsela phansi.

3. Khetha ithebhu 'Inombolo' ebhokisini lengxoxo elithi 'Fometha Amaseli'.

4. Khetha ifomethi oyifunayo (isb. inombolo, usuku, iphesenti, njll.) bese uchofoza u-'KULUNGILE'.

6. Ungahlunga kanjani idatha ku-Excel?

1. Khetha i ububanzi beseli ofuna uku-oda.

2. Chofoza kuthebhu 'Yedatha' phezulu esikrinini.

3. Khetha 'Hlunga' eqenjini 'Hlunga & Hlunga'.

4. Cacisa ikholomu ofuna ukuhlela ngayo idatha bese ukhetha uhlobo lokuhleleka (ukwenyuka noma ukwehla).

5. Chofoza 'KULUNGILE' ukuze uhlunge idatha ngokuvumelana nezintandokazi zakho.

7. Uyihlunga kanjani idatha ku-Excel?

1. Khetha ububanzi bamaseli ofuna ukuwahlunga.

2. Chofoza kuthebhu 'Yedatha' phezulu esikrinini.

3. Khetha 'Hlunga' eqenjini 'Hlunga futhi Hlunga'.

4. Chofoza umcibisholo kunhlokweni yekholomu ofuna ukuhlunga ngayo idatha bese ukhetha indlela yokuhlunga.

5. Chofoza u-'KULUNGILE' ukuze usebenzise isihlungi futhi ubonise idatha kuphela ehlangabezana nemibandela ekhethiwe.

8. Ungawakha kanjani amashadi ku-Excel?

1. Khetha idatha ofuna ukuyifaka eshadini.

2. Chofoza ithebhu 'Faka' phezulu esikrinini.

3. Khetha uhlobo lweshadi ofuna ukulenza esigabeni 'Amashadi'.

4. Chofoza u-'KULUNGILE' ukuze ufake ishadi kusipredishithi.

9. Ungawagcina kanjani futhi uwavule kanjani amafayela e-Excel?

1. Ukugcina ifayela:

   ku. Chofoza ithebhu 'Yefayela' phezulu kwesokunxele esikrinini.

   b. Khetha okuthi 'Londoloza Njenge' kumenyu yokudonsela phansi.

   c. Khetha indawo oyifunayo negama lefayela bese uchofoza okuthi 'Londoloza'.

2. Ukuvula ifayela:

   ku. Chofoza ithebhu 'Yefayela' phezulu kwesokunxele esikrinini.

   b. Khetha okuthi 'Vula' kumenyu yokudonsela phansi.

   c. Zulazula uye endaweni yefayela bese uchofoza kabili ukuze uyivule.

10. Ungaphrinta kanjani ispredishithi se-Excel?

1. Chofoza ithebhu 'Yefayela' phezulu kwesokunxele kwesikrini.

2. Khetha 'Phrinta' kumenyu yokudonsela phansi.

3. Enza ngendlela oyifisayo izinketho zokuphrinta njengobubanzi bekhasi nokusetha kwekhasi.

4. Chofoza okuthi 'Phrinta' ukuze uphrinte isipredishithi.