Phakathi kwemisebenzi ehlukahlukene e-Excel, okuhloswe ukuthi isebenze ngombhalo, opharetha uphumelela ngamathuba awo angavamile. Kwesokudla. Umsebenti wayo ukukhipha inombolo ecacisiwe yabalingiswa kusuka kuseli elichaziwe, ukubala kusukela ekupheleni. Masifunde kabanzi mayelana namathuba alo mqhubi futhi mayelana nama-nuances wokuwasebenzisa ngezinhloso ezithile ngezibonelo ezithile.
Opharetha ulungile
Umsebenzi Kwesokudla ithola kusuka kulesici esicacisiwe kushidi inani lezinhlamvu ezilungile ukuthi umsebenzisi ngokwakhe ubonisa. Ibonisa imiphumela yokugcina esitokisini lapho itholakala khona. Lo msebenzi ungokwesigaba sombhalo se-Excel opharetha. I-syntax yayo ilandelayo:
= KUPHELA (umbhalo; inombolo yabalingiswa)
Njengoba ungabona, umsebenzi unemibono emibili kuphela. Okokuqala kulawa "Umbhalo" Kungathatha ifomu kokubili ukukhuluma kombhalo kanye nezinkomba ezibhekene nesici seshidi lapho sitholakala khona. Esikhathini sokuqala, opharetha uzokhipha inombolo ecacisiwe yezinhlamvu kusuka enkulumweni yombhalo echazwe njengengxabano. Esimweni sesibili, lo msebenzi uzoba "uphonsa" izinhlamvu ezivela embhalweni oqukethwe kwiseli ecacisiwe.
Iphikisana yesibili liyi "Inombolo yabalingiswa" - iyinani lezinombolo elikhombisa kahle ukuthi zingaki izinhlamvu ezenzakalweni zombhalo, ukubala ukusuka kwesokudla, kufanele ziboniswe esitokisini esilitshe. Le mpikiswano iyakhethwa. Uma uyishiya, kubhekwa ukuthi lilingana nomunye, okungukuthi, kuphela uhlamvu oluqondile kakhulu lwento ecacisiwe luboniswa esitokisini.
Isibonelo sohlelo lokusebenza
Manje ake sicabange ukusetshenziswa komsebenzi Kwesokudla ngesibonelo esithile.
Isibonelo, thatha uhlu lwabasebenzi benkampani. Kukholomu yokuqala yaletafula kukhona amagama abasebenzi, kanye nezinombolo zocingo. Sidinga lezi zinombolo besebenzisa lo msebenzi Kwesokudla ufake ikholomu ehlukile, ebizwa ngokuthi "Inombolo Yefoni".
- Khetha i-cell column yokuqala engenalutho. "Inombolo Yefoni". Chofoza kusithonjana "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula.
- Ukusebenza kwe-window kwenzeka Amakhosi omsebenzi. Iya kusigaba "Umbhalo". Kusukela kuhlu lwamagama, khetha igama "VULA". Chofoza inkinobho. "Kulungile".
- Iwindi lempikiswano ye-Operator ivuleka Kwesokudla. Iqukethe amasimu amabili ahambisana nemibono yomsebenzi ocacisiwe. Ensimini "Umbhalo" kufanele ucacise isixhumanisi esitokisini sokuqala sekholomu "Igama"eliqukethe igama lokugcina lomsebenzi nenombolo yocingo. Ikheli lingachazwa ngesandla, kodwa sizokwenza ngokuhlukile. Setha isikhombisi emkhakheni "Umbhalo"bese uchofoza inkinobho yegundane lesokunxele esitokisini okufanele kuhlanganiswe izixhumanisi. Emva kwalokho, ikheli liboniswa efasiteleni lezingxoxo.
Ensimini "Inombolo yabalingiswa" faka inombolo kusuka kukhibhodi "5". Iqukethe izinhlamvu ezinhlanu inombolo yocingo yesisebenzi ngasinye. Ngaphezu kwalokho, zonke izinombolo zocingo zikhona ekupheleni kwamaseli. Ngakho-ke, ukuze sibonise ngokuhlukile, sidinga ukukhipha kulawa maseli ngokuqondile izinhlamvu ezinhlanu ngakwesokudla.
Ngemuva kokuthi idatha engenhla ifakiwe, chofoza inkinobho "Kulungile".
- Ngemuva kwalesi senzo, inamba yocingo yesisebenzi esicacisiwe ikhishwa kuseli elikhethiwe. Yiqiniso, ukufaka ifomula ecacisiwe ngokwehlukana kumuntu ngamunye ohlwini kuwuvivinyo olude kakhulu, kodwa ungakwenza ngokushesha, okungukuthi, ulikopishe. Ukuze wenze lokhu, faka isikhombisi ekhoneni elingaphansi lesokudla leseli, elivele liqukethe ifomula Kwesokudla. Kulesi simo, isikhombisi siguqulwa sibe uphawu lokugcwalisa ngendlela yesiphambano esincanyana. Bamba inkinobho yesinxele yesinxele bese uhudula isikhombisi phansi kuze kube sekupheleni kwethebula.
- Manje ikholomu yonke "Inombolo Yefoni" igcwele amanani afanayo avela kukholomu "Igama".
- Kodwa, uma sizama ukususa izinombolo zocingo kusuka kukholomu "Igama"khona-ke bazoqala ukuphela nokuvela kukholomu "Inombolo Yefoni". Lokhu kungenxa yokuthi zombili lezi kholomu zihlobene nefomula. Ukuze ususe lesi sixhumanisi, sikhetha konke okuqukethwe kukholomu. "Inombolo Yefoni". Bese uchofoza isithonjana "Kopisha"okuyinto ekhonobheni kuthebhu "Ikhaya" eqenjini lamathuluzi "Ibhodi lokunamathisela". Ungaphinda uthayiphe isinqamuleli Ctrl + C.
- Khona-ke, ngaphandle kokukhipha ukhetho kusuka kukholomu elingenhla, chofoza kuso ngenkinobho yegundane kwesokudla. Emenyu yomongo eqenjini "Izinketho zokufaka" khetha isikhundla "Amanani".
- Emva kwalokho, yonke idatha ekholomu "Inombolo Yefoni" izoboniswa njengezinhlamvu ezizimele, hhayi njengomphumela wamanani wefomula. Manje, uma ufisa, ungasusa izinombolo zocingo kusuka kukholomu "Igama". Lokhu ngeke kuthinte okuqukethwe kwekholomu. "Inombolo Yefoni".
Isifundo: I-Excel Function Wizard
Njengoba ungabona, izici ezinikezwa umsebenzi Kwesokudla, yiba nezinzuzo eziphathekayo zokukhonkolo. Ngesizo salokhu opharetha, ungabonisa endaweni ekhonjiwe inombolo edingekayo yabalingiswa kusuka kumaseli akhethiwe, ubala kusukela ekupheleni, okungukuthi, ngakwesokudla. Lo opharetha uyasiza kakhulu uma ufuna ukukhipha inombolo efanayo yabalingiswa kusukela ekupheleni kuluhlu olubanzi lwamaseli. Ukusebenzisa ifomula ezimweni ezinjalo kuzosindisa kakhulu isikhathi somsebenzisi.
