Phakathi kwemisebenzi ehlukahlukene ku-Excel eyenzelwe ukusebenza ngombhalo, opharetha uphawuleka ngezici zayo ezingajwayelekile Kwesokudla. Umsebenzi wawo ukukhipha inombolo ebekiwe yezinhlamvu kuseli elicacisiwe, ukubala kusukela ekugcineni. Masifunde ngemininingwane eminingi ngamakhono ale opharetha nangama-nuances wokuyisebenzisela izinhloso ezisebenzayo nezibonelo ezithile.
Isisebenzeli PRIVSIMV
Umsebenzi Kwesokudla kukhishwa kwento ebekiwe eshidini inani lezinhlamvu ngakwesokudla libonisa umsebenzisi ngokwakhe. Ibonisa umphumela wokugcina esitokisini lapho itholakala khona. Lo msebenzi ungowesigaba sombhalo sezitatimende ze-Excel. I-syntax yayo imi ngolu hlobo:
= KULUNGILE (umbhalo; inombolo yezinhlamvu)
Njengoba ukwazi ukubona, umsebenzi unezimpikiswano ezimbili kuphela. Eyokuqala "Umbhalo" ingathatha isimo noma isitatimende sombhalo noma isixhumanisi sento yeshidi elikuyo. Esimweni sokuqala, opharetha uzokhipha inombolo ebekiwe yezinhlamvu kusukela kunkulumo yombhalo echazwe njengengxabano. Esimweni sesibili, umsebenzi "uzonciphisa" izinhlamvu embhalweni oqukethwe kuseli elicacisiwe.
Ingxabano yesibili ngukuthi "Inani lezinhlamvu" - Inani lamanani elibonisa ukuthi zingaki izinhlamvu kwisisho sombhalo, zibala ngakwesokunene, kufanele ziboniswe kuseli elitshelwe. Le ngxabano iyakhethwa. Uma uyikhipha, kubhekwe ukuthi ilingana neyodwa, okungukuthi, uphawu olulodwa kuphela olwedluzelayo lwento echaziwe lukhonjiswa esitokisini.
Isibonelo sokusebenzisa
Manje ake sibheke ukusetshenziswa komsebenzi Kwesokudla kwisibonelo sikakhonkolo.
Ukwenza isibonelo sizothatha uhlu lwabasebenzi bebhizinisi. Kwikholamu lokuqala laleli thebula kukhona amagama abasebenzi kanye nezinombolo zocingo. Sidinga lezi zinombolo sisebenzisa umsebenzi Kwesokudla faka ikholamu ehlukile, ebizwa ngokuthi Inombolo yocingo.
- Khetha iseli lokuqala elingenalutho kwikholamu. Inombolo yocingo. Chofoza isithonjana. "Faka umsebenzi", etholakala kwesobunxele sebha yefomula.
- I-Window activation Iqala Umsebenzi Wizards. Iya esigabeni "Umbhalo". Kusukela kuhlu lwezinto ezigqanyisiwe PRAVSIMV. Chofoza inkinobho. "Kulungile".
- Iwindows Opgree Window Ivula Kwesokudla. Inezinkambu ezimbili ezihambelana nokuphikisana komsebenzi oshiwo. Ensimini "Umbhalo" udinga ukucacisa isixhumanisi esitokisini sokuqala sekholamu "Igama", equkethe igama lomsebenzi kanye nenombolo yocingo. Ikheli lingacaciswa ngesandla, kepha sizokwenza ngokuhlukile. Setha isikhombisi esigangeni "Umbhalo", bese uchofoza kwesobunxele esitokisini okufanele kuhlanganiswe izixhumanisi zazo. Ngemuva kwalokho, ikheli liboniswa ewindini lokuphikisana.
Ensimini "Inani lezinhlamvu" faka inombolo kusuka kukhibhodi "5". Inombolo enamadijithi amahlanu inenombolo yocingo yomsebenzi ngamunye. Ngaphezu kwalokho, zonke izinombolo zocingo zitholakala ekugcineni kwamaseli. Ngakho-ke, ukuze sizibonakalise ngokwahlukana, sidinga ukukhipha izinhlamvu ezihlanu ngqo kulezi zinhlayiya ezingakwesokudla.
Ngemuva kokuthi idatha engenhla ifakiwe, chofoza inkinobho "Kulungile".
- Ngemuva kwalesi senzo, inombolo yocingo yesisebenzi esichaziwe ikhishwa kwiseli ebelinikezwe ngaphambilini. Vele, ukwethula ifomula ekhonjisiwe ngokwahlukana kumuntu ngamunye kuhlu kuyisifundo eside kakhulu, kepha ungakwenza ngokushesha, okuyi-kopi. Ukuze wenze lokhu, beka ikhesa ekhoneni elingezansi kweseli, esivele liqukethe ifomula Kwesokudla. Kulokhu, isikhombisi siguqulwa sibe umaka wokugcwalisa ngesiphambano esincane. Bamba phansi inkinobho yegundane kwesobunxele bese udonsela isikhombisi phansi ekugcineni kwetafula.
- Manje lonke ikholomu Inombolo yocingo kugcwele amanani ahambisanayo kusuka kukholamu "Igama".
- Kepha, uma sizama ukususa izinombolo zocingo kwikholomu "Igama"khona-ke bazoqala ukunyamalala kwikholamu Inombolo yocingo. Lokhu kungenxa yokuthi womabili la makholamu ahlobene nefomula. Ukuze ususe lobu budlelwano, khetha konke okuqukethwe ikholamu Inombolo yocingo. Bese uchofoza isithonjana Kopishaetholakala kubambo kuthebhu "Ikhaya" eqenjini lamathuluzi Ibhodi yokunamathisela. Ungathayipha nesinqamuleli sekhibhodi I-Ctrl + C.
- Ngaphezu kwalokho, ngaphandle kokususa ukukhetha kusuka kwikholamu engenhla, chofoza kuyo ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe eqenjini Faka Izinketho khetha isikhundla "Amanani".
- Ngemuva kwalokho, yonke imininingwane esekholamu Inombolo yocingo kuzokwethulwa njengabalingiswa abazimele, futhi hhayi njengomphumela wokubala ifomula. Manje, uma kufiswa, ungasusa izinombolo zocingo kwikholamu "Igama". Lokhu ngeke kuthinte okuqukethwe ikholamu. Inombolo yocingo.
Isifundo: Umsebenzi Wizard e-Excel
Njengoba ukwazi ukubona, amathuba anikezwa umsebenzi Kwesokudlaube nezinzuzo ezithile ezingokoqobo. Usebenzisa lo opharetha, ungabonisa inombolo efiselekayo yezinhlamvu ezivela kumaseli acacisiwe endaweni emakiwe, ukubala kusukela ekugcineni, okungukuthi, kuya kwesokudla. Lo opharetha uzoba wusizo ikakhulukazi uma udinga ukukhipha inani elifanayo lezinhlamvu kusukela ekugcineni ebangeni elikhulu lamaseli. Ukusebenzisa ifomula ngaphansi kwezimo ezinjalo kuzonga isikhathi esiningi somsebenzisi.
