I-Excel, isebenzisa ithuluzi elifana namafomula, ikuvumela ukuthi wenze imisebenzi ehlukahlukene ye-arithmetic phakathi kwedatha kumaseli. Ukuzikhipha kuyasebenza nakwizenzo ezinjalo. Ake sihlolisise izindlela okungenziwa ngazo lesi sibalo e-Excel.
Ukufaka isicelo
Ukukhishwa ku-Excel kungasebenza kuzo zombili izinombolo namakheli amaseli lapho idatha itholakala khona. Lesi senzo senziwa ngokubonga amafomula akhethekile. Njengakwezinye izibalo ezibandayo kulolu hlelo, ngaphambi kwendlela yokususa, udinga ukusetha isibonakaliso esilinganayo (=). Bese ngokulandelana kuncishisiwe (ngesimo senombolo noma ikheli leselula), uphawu lokususa (-), okutholwayo kokuqala (ngesimo senombolo noma ikheli), kwezinye izimo ukunqatshwa okulandelayo.
Ake sibheke izibonelo ezithile zendlela lo msebenzi wokubala okwenziwa ngayo e-Excel.
Indlela yoku-1: Ukukhipha izinombolo
Isibonelo esilula kunazo zonke ukukhipha izinombolo. Kulokhu, zonke izenzo zenziwa phakathi kwezinombolo ezithile, njengokwokubala okujwayelekile, hhayi phakathi kwamaseli.
- Khetha noma isiphi iseli noma faka isikhombisi kubha yefomula. Sibeka isibonakaliso okulinganayo. Siphrinta ukusebenza kwe-arithmetic ngokususa, njengoba nje sikwenza ephepheni. Isibonelo, bhala ifomula elandelayo:
=895-45-69 - Ukuze wenze inqubo yokubala, chofoza inkinobho Ngena kwikhibhodi.
Ngemuva kokuthi lezi zenzo zenziwe, umphumela ukhonjiswa kuseli elikhethiwe. Esimweni sethu, lokhu kungu-781. Uma usebenzise enye idatha ukubala, khona-ke, uzothola umphumela ohlukile.
Indlela 2: khipha izinombolo kusuka kumaseli
Kodwa, njengoba wazi, i-Excel, okokuqala, uhlelo lokusebenza ngamatafula. Ngakho-ke, ukusebenza ngamaseli kubaluleke kakhulu kuyo. Ikakhulu, zingasetshenziselwa nokukhipha.
- Khetha iseli lapho kuzobekwa khona ifomula yokususa. Sibeka isibonakaliso "=". Chofoza kuseli equkethe imininingwane. Njengoba ukwazi ukubona, ngemuva kwalesi senzo, ikheli laso lifakwa kubha yefomula futhi liyangezwa ngemuva kwesibonakaliso okulinganayo. Siphrinta inamba ukuthi isuswe.
- Njengasesimweni esedlule, ukuthola imiphumela yokubala, cindezela ukhiye Ngena.
Indlela 3: khipha iseli esitokisini
Ungenza imisebenzi yokususa ngaphandle kwezinombolo nhlobo, usebenzisa amakheli wamaseli wedatha kuphela. Isimiso sokusebenza sinye.
- Sikhetha iseli ukubonisa imiphumela yokubala bese sifaka uphawu kuyo okulinganayo. Chofoza kuseli equkethe inciphile. Sibeka isibonakaliso "-". Chofoza kuseli eliqukethe okususwe. Uma ukuhlinzwa kudinga ukwenziwa ngenkani, bese sibeka uphawu Susa futhi wenze izenzo ngendlela efanayo.
- Ngemuva kokuthi yonke imininingwane ifakiwe, ukubonisa umphumela, chofoza inkinobho Ngena.
Isifundo: Ukusebenza namafomula ku-Excel
Indlela 4: ukucubungula ngobuningi ukusebenza kokususa
Kaningi, lapho usebenza ne-Excel, kwenzeka ukuthi udinga ukubala ukukhipha yonke ikholomu yamaseli kwelinye ikholomu yamaseli. Vele, ungabhala ifomula ehlukile yesenzo ngasinye ngesandla, kepha lokhu kuzothatha isikhathi esibalulekile. Ngenhlanhla, ukusebenza kohlelo lokusebenza kuyakwazi ukushintshanisa ukubala okunjalo, ngenxa yomsebenzi we-autocomplete.
Isibonelo, sibala inzuzo yebhizinisi ezindaweni ezahlukene, sazi imali engenayo nezindleko zokukhiqizwa. Ukuze wenze lokhu, kusuka imali oyidingayo ukuthatha izindleko.
- Khetha iseli ephezulu yokubala inzuzo. Sibeka isibonakaliso "=". Chofoza kuseli equkethe usayizi weholo lemali kulayini ofanayo. Sibeka isibonakaliso "-". Khetha iseli nezindleko.
- Ukuze ubonise imiphumela yenzuzo yalayini kulayini, chofoza inkinobho Ngena.
- Manje sidinga ukukopisha le formula ebangeni eliphansi ukuze sibalole lapho. Ukuze wenze lokhu, beka ikhesa onqenqemeni olungakwesokudla lweseli eliqukethe ifomula. Umaka wokugcwalisa uyavela. Sicindezela inkinobho yegundane kwesobunxele futhi sisesimweni esigoqekile sidonsa isikhombisi phansi ekugcineni kwetafula.
- Njengoba ubona, ngemuva kwalezi zenzo, ifomula yathunyelwa kulo lonke uhla olungezansi. Ngasikhathi sinye, ngenxa yesakhiwo esinjengobuhlakani bekheli, lokhu kukopisha kwenzeka ngomshini, okwenze kwaba lula ukubala ukukhipha kumaseli aseduze.
Isifundo: Ungayenza kanjani ngokuzenzakalela i-Excel
Indlela yesi-5: ukususa okuningi kwemininingwane yeseli elilodwa kusuka ebangeni
Kepha kwesinye isikhathi udinga ukwenza okuphambene nalokho, okungukuthi, ukuze ikheli lingashintshi ngesikhathi sokukopisha, kodwa lihlale linjalo, libhekisele kuseli elithile. Ungakwenza kanjani lokhu?
- Singena kuseli lokuqala ukubonisa umphumela wokubaliswa kwebanga. Sibeka isibonakaliso okulinganayo. Sichofoza kuseli lapho kuncishiswa khona. Setha isibonakaliso Susa. Sichofoza kuseli elinikezelwe, ikheli lakhona okungafanele liguqulwe.
- Futhi manje siphendukela umehluko obaluleke kakhulu phakathi kwale ndlela nowedlule. Yisenzo esilandelayo esikuvumela ukuthi uguqule isixhumanisi kusuka kusihlobo kuye ngokuphelele. Sibeka uphawu lwedola phambi kwezixhumanisi ezime mpo nezingqimba zeseli ikheli lakhe okungafanele lishintshe.
- Sichofoza kwikhibhodi kukhiye Ngena, okuvumela ukuthi ubonise ukubalwa kwalayini kulayini.
- Ukuze wenze ukubala kweminye imigqa, ngendlela efanayo nesibonelo esedlule, shayela umaki wokugcwalisa bese udonsa phansi.
- Njengoba ukwazi ukubona, inqubo yokususa ukwenziwa yenziwa njengoba sasidingida. Okusho ukuthi, lapho behamba phansi, amakheli wedatha encishisiwe aguquliwe, kepha asuswe engashintshiwe.
Isibonelo esingenhla siyimeko ekhethekile kuphela. Ngendlela efanayo, kungenziwa ngenye indlela ezungezile ukuze okutholwayo kuhlale kungasasebenzi futhi okutholwayo kuhlobene futhi kube nezinguquko.
Isifundo: Izixhumanisi ezingaphelele nezihlobene ku-Excel
Njengoba ubona, akukho lutho oluyinkimbinkimbi ekuqondeni inqubo yokususa e-Excel. Kwenziwa ngokuya ngemithetho efanayo nezinye izibalo ze-arithmetic kulolu hlelo lokusebenza. Ukwazi ama-nuances athile athakazelayo kuzovumela umsebenzisi ukuthi acubungula kahle imininingwane enkulu ngalesi senzo sezibalo, esizokonga isikhathi sakhe kakhulu.
