Akubona bonke abasebenzisi be-MS Word abaqaphela iqiniso lokuthi kulolu hlelo kungenzeka ukwenza izibalo ngokusebenzisa amafomula akhethiwe. Yiqiniso, ngaphambi kokusebenza kwamanye amahhovisi e-office, i-procel ispredishithi yepropredishithi, iZwi alikhiphi, noma kunjalo, izibalo ezilula zisengenziwa kuso.
Isifundo: Indlela yokubhala ifomula eZwini
Lesi sihloko sizoxoxa ngendlela yokubala inani eZwini. Njengoba uqonda, idatha yamanani, inani elidingekayo ukuthi litholakale, kumele libe setafuleni. Endalweni bese sisebenzisana nalezi zinsuku, sibhale ngokuphindaphindiwe. Ukuze uvuselele imininingwane enkumbulweni, sincoma ukufunda isihloko sethu.
Isifundo: Indlela yokwenza itafula eZwini
Ngakho-ke, sinetafula nedatha ekholomu eyodwa, futhi yilokho okudingeka sikwenze. Kuyaqondakala ukuthi ucabange ukuthi inani kufanele libe selokugcina (elingaphansi) ikholomu yeseli, elingenalutho manje. Uma kungekho mgqeni etafuleni lakho lapho kuzotholakala khona inani lemininingwane, yilale usebenzisa imfundo yethu.
Isifundo: Kanjani eZwini ukwengeza umugqa etafuleni
1. Chofoza ku-engenalutho (ngezansi) ikholi yekholomu, idatha ofuna ukuyifinyelela kuyo.
Chofoza ithebhu "Ukuhlelwa"esitholakala esigabeni esiyinhloko "Ukusebenzisana namatafula".
3. eqenjini "Idatha"etholakala kuleli tbhu, chofoza inkinobho "Ifomula".
4. ebhokisini lebhokisi elivula esigabeni "Faka umsebenzi"Khetha "SUM"lokho kusho "sum".
5. Khetha noma ucacise amaseli njengoba kungenziwa ku-Excel, eZwini ngeke isebenze. Ngakho-ke, indawo yamaseli adinga ukufingqwa kufanele kuvezwe ngokuhlukile.
Ngemuva kwalokho "= SUM" emgqeni "Ifomula" faka "(OKUKHULU)" ngaphandle izingcaphuno kanye nezikhala. Lokhu kusho ukuthi sidinga ukwengeza idatha kusuka kuwo wonke amaseli ngenhla.
6. Ngemva kokushaya "Kulungile" ukuvala ibhokisi lengxoxo "Ifomula", iseli olikhethayo lizobonisa inani lemininingwane kusuka emgqeni ogqamile.
Okudingayo ukwazi nge-avtosummy yomsebenzi eZwini
Uma wenza izibalo etafuleni ezidalwe eZwini, kufanele uqaphele ambalwa ama-nuances abalulekile:
1. Uma ushintshe okuqukethwe kwamaseli ahlanganisiwe, inani lawo ngeke libuyekezwe ngokuzenzekelayo. Ukuze uthole imiphumela efanele, chofoza ngakwesokudla kweseli yefomula bese ukhetha into "Hlela Ibanga".
2. Ukubalwa kwefomula kwenziwa kuphela ngamaseli aqukethe idatha yezinombolo. Uma kukhona amangqamuzana angenalutho ekholomu ofuna ukuyifinyelela, uhlelo luzobonisa kuphela inani laleyo ngxenye yamaseli asondelene nefomula, engazinaki wonke lawo maseli angaphezu kwezingenalutho.
Lapha, empeleni, nakho konke, manje uyazi ukuthi ungabala kanjani isibalo eZwini. Ukusebenzisa isigaba se- "Formula", ungenza futhi ezinye izibalo eziningi ezilula.
