Uhlelo lwe-Excel ngosizo lwethuluzi elifana namafomula likuvumela ukuba wenze imisebenzi ehlukahlukene yezibalo phakathi kwedatha emafetheni. Izenzo ezinjalo zifaka ukukhipha. Ake sihlolisise ukuthi ungayenza kanjani lokhu kubalwa ku-Excel.
Ukukhishwa kwesicelo
Ukususwa kwe-Excel kungasetshenziswa ezinombolo ezithile kanye namakheli amaseli lapho idatha ikhona khona. Lesi senzo senziwa ngenxa yamafomula akhethekile. Njengazinye izibalo ze-arithmetic kulolu hlelo, ngaphambi kwefomula yokukhipha udinga ukusetha uphawu olulingana nalo (=). Khona-ke, isibonakaliso sokunciphisa sinqunywe (ngesimo senombolo noma ikheli leseli). (-), i-deductible yokuqala (ngesimo senombolo noma ikheli), futhi kwezinye izimo, i-deductible elandelayo.
Ake sihlole izibonelo ezithile zendlela lokhu kusebenza kwe-arithmetic kwenziwa ngayo ku-Excel.
Indlela 1: Khipha izinombolo
Isibonelo esilula ukukhipha izinombolo. Kulesi simo, zonke izenzo zenziwa phakathi kwezinombolo ezithile, njengokubala okuvamile, hhayi phakathi kwamaseli.
- Khetha noma iyiphi iseli noma usethe isikhombisi kubha yefomula. Sabeka uphawu kufana. Siphrinta umsebenzi we-arithmetic ngokukhipha, njengoba nje senza ephepheni. Isibonelo, bhala ifomula elilandelayo:
=895-45-69 - Ukwenza inqubo yokubala, chofoza inkinobho. Ngena kwikhibhodi.
Ngemuva kokuba lezi zenzo zenziwe, umphumela uboniswa kuseli elikhethiwe. Esimweni sethu, le nombolo ingu-781. Uma usebenzisa enye idatha yokubala, ke, ngokufanele, umphumela wakho uzohluka.
Indlela 2: Khipha izinombolo kumaseli
Kodwa, njengoba wazi, i-Excel, ngaphezu kwakho konke, uhlelo lokusebenzisana namatafula. Ngakho-ke, imisebenzi yamaseli ibaluleke kakhulu kuyo. Ngokuyinhloko, angasetshenziselwa ukususa.
- Khetha iseli lapho ifomula lokukhipha izotholakala khona. Sabeka uphawu "=". Chofoza kuseli equkethe idatha. Njengoba ubona, ngemuva kwalesi senzo, ikheli layo lifakwe kwibha yefomula futhi lengezwe emva kwesibonakaliso kufana. Siphrinta leyo nombolo edinga ukususwa.
- Njengokwesikhashana esidlule, ukuthola imiphumela yokubala, cindezela ukhiye Ngena.
Indlela 3: Ukukhipha iselula kusuka kumakhalekhukhwini
Ungenza imisebenzi yokukhipha futhi ngokuvamile ngaphandle kwezinombolo, ukuphatha kuphela amakheli amaseli nedatha. Inqubo iyafana.
- Khetha iseli ukubonisa imiphumela yokubala bese ufaka kuso isibonakaliso kufana. Sichofoza esitokisini esine-decremented. Sabeka uphawu "-". Chofoza kuseli eline-deductible. Uma ukuhlinzwa kudingeke kwenziwe nge-deductible eminingana, bese sibeka uphawu "susa" futhi usebenze ngezindlela ezifanayo.
- Ngemuva kokuthi yonke idatha ingenwe, ukubonisa umphumela, chofoza inkinobho Ngena.
Isifundo: Sebenzisa ngamafomula ku-Excel
Indlela 4: Ukucubungula ngamasethingi kokusebenza kokukhipha
Ngokuvamile, uma usebenza ne-Excel, kwenzeka ukuthi udinga ukubala ukususwa kwekholomu yonke yamaseli kwenye ikholomu yamaseli. Yiqiniso, ungabhala ifomula ehlukile yesenzo ngasinye ngesandla, kodwa lokhu kuzothatha isikhathi esiningi. Ngenhlanhla, ukusebenza kwesicelo kukwazi ukwenza ngokuzenzakalelayo izibalo ezinjalo, ngenxa yomsebenzi ophelile ngokuzenzakalelayo.
Isibonelo, sibala inzuzo yebhizinisi ezindaweni ezihlukene, ukwazi isamba semali engenayo kanye nezindleko zokukhiqiza. Ukuze wenze lokhu, udinga ukuthatha izindleko zemali engenayo.
- Khetha iseli eliphezulu kunazo zonke zokulinganisa inzuzo. Sabeka uphawu "=". Chofoza kuseli eliqukethe inani lemali engenayo emgqeni ofanayo. Sabeka uphawu "-". Khetha iseli ngezindleko.
- Ukuze ubonise imiphumela yenzuzo yalo mkhakha esibukweni, chofoza inkinobho Ngena.
- Manje sidinga ukukopisha leli fomula ebangeni eliphansi ukuze wenze izibalo ezidingekayo lapho. Ukuze wenze lokhu, faka isikhombisi emkhawulweni ongezansi ongakwesokunxele weseli equkethe ifomula. Uphawu lokugcwalisa luvela. Chofoza inkinobho yesinxele segundane nasesimweni sokuphoqa, donsela isikhombisi kuze kube sekupheleni kwetafula.
- Njengoba ubona, ngemuva kwalezi zenzo, ifomula likopishwe kuwo wonke uhla olungezansi. Ngesikhathi esifanayo, ngenxa yendawo yokuhleleka kwekheli, lokhu kukopishwa kwenzeke nge-offset, okwenza kube lula ukubala ukususa kumaseli aseduze.
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Indlela 5: Ukukhipha okukhulu kwemininingwane yeselula eyodwa kusuka ebangeni
Kodwa ngezinye izikhathi kuyadingeka ukwenza okuphambene nalokho, okungukuthi, ikheli alishintshi uma ukopisha, kodwa lihlala liqhubeka, libhekisela esitokisini esithile. Ungakwenza kanjani?
- Siba yileli cell yokuqala ukubonisa umphumela wamanani okubala. Sabeka uphawu kufana. Chofoza kuseli lapho kunqunywe khona. Setha uphawu "susa". Sichofoza esitokisini se-deductible, ikheli lakhe akufanele lishintshwe.
- Futhi manje sifike embuthweni obaluleke kunazo zonke kule ndlela kusuka owedlule. Yisenzo esilandelayo esikuvumela ukuthi uguqule isixhumanisi kusuka ekuhlotsheni kuya ngokuphelele. Beka isibonakaliso se-dollar phambi kwezixhumanisi eziqondile nezingqimba zeseli ikheli lawo akufanele lishintshe.
- Sichofoza ikhibhodi Ngenaevumela ukuthi wena ubonise izibalo zalo mzila kusikrini.
- Ukuze wenze izibalo kwamanye imigqa, ngendlela efanayo nesibonelo sangaphambilini, sidinga isibambo sokugcwalisa bese sihudula phansi.
- Njengoba ubona, inqubo yokukhipha yenziwa ngendlela esiyidingayo. Okusho ukuthi, lapho uhamba phansi, amakheli wedatha encishisiwe ashintshiwe, kodwa i-deductible yahlala ingashintshi.
Lesi sibonelo esingenhla siyisimo esikhethekile kuphela. Ngokufanayo, ungenza okuphambene nalokho, ukuze i-deductible ihlale ihlala njalo, kanti i-deductible ihlobene futhi ishintshiwe.
Isifundo: Ukuxhumanisa okuphelele nokuhlobene ku-Excel
Njengoba ubona, ekuqapheliseni inqubo yokukhipha ku-Excel akukho lutho olulukhuni. Yenziwa ngokuvumelana nemithetho efanayo nezinye izibalo zezibalo kulolu hlelo lokusebenza. Ukukwazi okunye okuthakazelisayo kuzokuvumela umsebenzisi ukuthi asebenze kahle idatha enkulu ngalesi senzo sesibalo, esizosindisa isikhathi sakhe kakhulu.
