Izibalo eziyisisekelo ku-Excel yokufaka ukukhipha, ukuhlukanisa nokuphindaphinda
Ngezansi kukhona izixhumanisi ezibalulwe ezifundisweni ezihlanganisa imisebenzi eyisisekelo yezibalo ku-Excel.
Uma ufuna ukwazi ukwengeza, ukususa, ukwandisa, noma ukwahlukanisa izinombolo ku-Excel, izihloko ezibalwe ngezansi zizokubonisa ukuthi ungakha kanjani amafomula ukwenza kanjalo.
Indlela yokukhipha ku-Excel
Izihloko ezihlanganisiwe:
- Indlela yokukhipha izinombolo usebenzisa ifomula ;
- Isibonelo esinyathelo ngesinyathelo sokudala ifomula yokukhipha ku-Excel usebenzisa iphuzu bese uchofoza ;
- Kungani ukusebenzisa izingqikithi zeseli kuzokwenza kube lula ukubuyekeza izibalo zakho uma idatha yakho kufanele ishintshe.
Indlela yokuhlukanisa ku-Excel
Izihloko ezihlanganisiwe:
- Ukuhlukanisa izinombolo ezimbili usebenzisa ifomula;
- Isibonelo esinyathelo ngesinyathelo sokwakha ifomula yokuhlukanisa ku-Excel usebenzisa iphuzu bese uchofoza;
- Kungani ukusebenzisa izingqikithi zeseli kuzokwenza kube lula ukubuyekeza izibalo zakho uma idatha yakho kufanele ishintshe;
Indlela Yokuphindaphinda ku-Excel
Izihloko ezihlanganisiwe:
- Indlela yokwandisa izinombolo ezimbili usebenzisa ifomula;
- Isibonelo esinyathelo ngesinyathelo sokudala ifomu lokubuyabuyelela ku-Excel usebenzisa iphuzu bese uchofoza;
- Kungani ukusebenzisa izingqikithi zeseli kuzokwenza kube lula ukubuyekeza izibalo zakho uma idatha yakho kufanele ishintshe.
Ungengeza kanjani ku-Excel
Izihloko ezihlanganisiwe:
- Indlela yokwengeza izinombolo ezimbili usebenzisa ifomula;
- Isibonelo esinyathelo ngesinyathelo sokwakha ifomu lokungezelela ku-Excel usebenzisa iphuzu bese uchofoza;
- Kungani ukusebenzisa izingqikithi zeseli kuzokwenza kube lula ukubuyekeza izibalo zakho uma idatha yakho kufanele ishintshe.
Ukushintsha i-Order of Operations kumafomu e-Excel
Izihloko ezihlanganisiwe:
- I- Order of Operations lezi izinhlelo zespredishithi zilandela uma zihlola ifomula
- Ungashintsha kanjani indlela yokusebenza ngamafomula
Abaxhasi ku-Excel
Nakuba engasetshenzisiwe kancane kunezimboni zezinombolo ezibalwe ngenhla, i-Excel isebenzisa umlingisi wokunakekelwa
( ^ ) njengo-opharetha ocacile ngamafomula.
Ngezinye izikhathi abaxhasi babizwa ngokuthi ukuphindaphindiwe ngokuphindaphindiwe kusukela ekuboneni - noma amandla njengoba kuthiwa ngezinye izikhathi - kubonisa ukuthi kaningi kangakanani inombolo yocingo okufanele yande ngokwayo.
Isibonelo, i-exponent 4 ^ 2 (ama-squared amane) - inenani eliyisisekelo le-4 nelingu-2, noma kuthiwa liphakanyiswe emandleni amabili.
Noma ngabe yiphi indlela, ifomula ifomu elifushane lokuthi inombolo yocingo kufanele yande kabili (4 x 4) ukunikeza umphumela we-16.
Ngokufanayo, 5 ^ 3 (cubed ezinhlanu) kubonisa ukuthi inombolo 5 kufanele yande ndawonye inani elingu-3 (5 x 5 x 5) ukunikeza impendulo ye-125.
Imisebenzi ye-Excel Math
Ngaphandle kwamafomula ayisisekelo ezibalwe ngenhla, i-Excel inemisebenzi eminingana - amafomu okuzakhela-angasetshenziselwa ukwenza imisebenzi eminingi yezibalo.
Lemisebenzi ihlanganisa:
Umsebenzi we-SUM - wenza kube lula ukwengeza amakholomu noma imigqa yezinombolo;
Umsebenzi we-PRODUCT - ukwandisa izinombolo ezimbili noma ngaphezulu ndawonye. Uma ukwandisa izinombolo ezimbili nje, ifomu lokubuyabuyelela lilula;
Umsebenzi we-QUOTIENT - ubuyisela kuphela ukubuyisa ingxenye eningi (inombolo ephelele kuphela) yokusebenza kwesigaba;
Umsebenzi we-MOD - ubuyisela kuphela ukusebenza okusele kokusakaza.