Lapho usebenza e-Excel, abasebenzisi kwesinye isikhathi babhekene nomsebenzi wokukhetha into ethile ohlwini futhi bayinike inani elicacisiwe ngokususelwa enkombeni yalo. Umsebenzi, obizwa "UKUKHETHA". Ake sibheke ngemininingwane yokuthi usebenza kanjani nalo opharetha, nokuthi yiziphi izinkinga ezingazisingatha.
Kusetshenziswa isitatimende SOKUKHETHA
Umsebenzi Ukukhetha kungokwesigaba sabasebenzi Izinkomba kanye nokufika. Inhloso yawo ukuthola inani elithile kuseli elicacisiwe, elihambisana nenombolo yenkomba kwenye into eshidini. I-syntax yalesi sitatimende imi ngalendlela elandelayo:
= KHETHA (inkomba_inothi; inani1; inani2; ...)
Ukuxabana Inombolo ye-Index iqukethe isixhumanisi esitokisini lapho kutholakala khona inombolo ye-serial yento, lapho iqembu elilandelayo labasebenza khona linikezwe inani elithile. Le nombolo ye-serial ingahluka kusuka 1 ngaphambili 254. Uma ucacisa inkomba edlula le nombolo, opharetha uzobonisa iphutha esitokisini. Uma ngabe wethula inani eliyinhlaka njengale mpikiswano, umsebenzi uzowubona njengenani elincane kunawo wonke eliseduzane nenombolo enikeziwe. Uma ubuza Inombolo ye-Indexokungekho okuphikisana ngalo "Inani", lapho-ke opharetha ebuyisa iphutha esitokisini.
Iqembu elilandelayo lokuphikisana "Inani". Angafinyelela inani 254 izakhi. Impikiswano iyadingeka "Inani1". Kuleli qembu lokuphikisana, amanani azokhonjiswa inombolo yenkomba yengxabano edlule Lokho wukuthi, uma kungukuphikisana Inombolo ye-Index inombolo yomusa "3", khona-ke izohambisana nenani elifakiwe njengengxabano "Inani3".
Izinhlobo ezahlukahlukene zedatha zingasebenza njengamanani:
- Izinkomba
- Izinombolo
- Umbhalo
- Amafomula
- Imisebenzi, njll.
Manje ake sibheke izibonelo ezithile zohlelo lokusebenza lwale opharetha.
Isibonelo 1: ukulandelana kokuhleleka okulandelanayo
Ake sibheke ukuthi lo msebenzi usebenza kanjani esibonelweni esilula. Sinethebula elinamanani ukusuka ku 1 ngaphambili 12. Kuyadingeka ngokuya ngezinamba ezilandelwayo ezinikezwe umsebenzi Ukukhetha khombisa igama lenyanga ehambisanayo kukholamu yesibili yetafula.
- Khetha iseli lokuqala elingenalutho kwikholamu. "Igama lenyanga". Chofoza isithonjana "Faka umsebenzi" eduze komugqa wamafomula.
- Ukuqala Umsebenzi Wizards. Iya esigabeni Izinkomba kanye nokufika. Khetha igama ohlwini "UKUKHETHA" bese uchofoza inkinobho "Kulungile".
- Ukuqaliswa Kwe-Window Ye-Operator Argument Ukukhetha. Ensimini Inombolo ye-Index ikheli leseli lokuqala lobubanzi bezinyanga kufanele likhonjiswe. Le nqubo ingenziwa ngokushayela kokuxhumanisa ngesandla. Kepha sizokwenza kalula. Sibeka ikhesa endle bese sichofoza kwesobunxele esitokisini esihambisanayo eshidini. Njengoba ukwazi ukubona, izixhumanisi zikhonjiswa ngokuzenzakalela emkhakheni wewindi lokuphikisana.
Ngemuva kwalokho, kufanele sishayele ngesandla siqonde eqenjini lezinkambu "Inani" igama lezinyanga. Ngaphezu kwalokho, insimu ngayinye kufanele ihambisane nenyanga ehlukile, okungukuthi, enkundleni "Inani1" bhala phansi Janawarienkundleni "Inani2" - UFebhuwari njll.
Ngemuva kokuqeda umsebenzi obaluliwe, chofoza inkinobho "Kulungile" phansi kwewindi.
- Njengoba ubona, ngokushesha esitokisini esikuqaphele kusinyathelo sokuqala, umphumela waboniswa, okuyigama Janawariokuhambisana nenombolo yokuqala yenyanga yonyaka.
- Manje, ukuze ungafaki ngesandla ifomula yawo wonke amanye amaseli kukholamu "Igama lenyanga", kufanele sikulingise. Ukuze wenze lokhu, setha ikhesa ekhoneni elingezansi kweseli eliqukethe ifomula. Umaka wokugcwalisa uyavela. Bamba phansi inkinobho yegundane kwesobunxele bese uhudula umaki wokugcwalisa uze ufike ekugcineni kwekholomu.
- Njengoba ubona, ifomula yathunyelwa kuhlu esasiludinga. Kulokhu, wonke amagama ezinyanga ezikhonjiswa kumaseli ahambelana nenombolo yawo ye-serial kusuka kukholamu kwesobunxele.
Isifundo: I-Excel Feature Wizard
Isibonelo 2: ukuhlelwa okungahleliwe kwezinto
Esimweni esedlule, sisebenzise ifomula Ukukhethalapho onke amanani ezinombolo zezinkomba ahlelwa ngokulandelana. Kepha usebenza kanjani lo opharetha uma amanani akhonjisiwe exutshwe futhi ephindwa? Ake sibheke isibonelo seshadi lokusebenza kwabafundi. Ikholamu lokuqala letafula libonisa igama lomfundi, ibanga lesibili (kusuka 1 ngaphambili 5 amaphuzu), futhi okwesithathu kufanele sisebenzise umsebenzi Ukukhetha nikeza lolu hlolo ngesimo esifanele ("kubi kakhulu", "kubi", kuyenelisa, kuhle, kuhle kakhulu).
- Khetha iseli lokuqala kukholamu "Ukuchaza" bese udlula ngendlela ebisivele ixoxwe ngenhla, ewindini lokuphikisana lesisebenzisi Ukukhetha.
Ensimini Inombolo ye-Index chaza isixhumanisi seseli lokuqala lekholamu "Ibanga"equkethe amaphuzu.
Iqembu lenkambu "Inani" gcwalisa lokhu okulandelayo:
- "Inani1" - "Kubi kakhulu";
- "Inani2" - "Kubi";
- "Inani3" - "Anelisekile";
- "Inani4" - Kuhle;
- "Inani5" - "Muhle".
Ngemuva kokwethulwa kwemininingwane engenhla kwenziwe, chofoza inkinobho "Kulungile".
- Isikolo sento yokuqala sikhonjiswa esitokisini.
- Ukuze wenze inqubo efanayo yezakhi ezisele zekholamu, kopisha imininingwane kumaseli ayo usebenzisa umaki wokugcwalisa, njengoba kwakwenziwe ku Indlela 1. Njengoba ukwazi ukubona, kulokhu umsebenzi usebenze kahle futhi wakhombisa yonke imiphumela ngokuya nge-algorithm enikeziwe.
Isibonelo 3: sebenzisa ngokuhlanganiswa nabanye abaqhubi
Kepha opharetha ukhiqiza kakhulu Ukukhetha ingasetshenziswa ngokuhambisana neminye imisebenzi. Ake sibheke ukuthi kwenziwa kanjani lokhu kusetshenziswa opharetha njengesibonelo. Ukukhetha futhi ISUM.
Kunetafula lokuthengisa ngezitolo. Ihlukaniswe ngamakholomu amane, ngalinye lihambelana nokukhishwa okuthile. Imali engenayo ikhonjiswa ngokwahlukana komugqa othile wedethi ngomugqa. Umsebenzi wethu ukuqiniseka ukuthi ngemuva kokufaka inani lokukhishwa esitokisini esithile sephepha, inani lemali engenayo yazo zonke izinsuku esitolo elibekiwe liyaboniswa. Kulokhu sizosebenzisa inhlanganisela yezisebenzi ISUM futhi Ukukhetha.
- Khetha iseli lapho umphumela uzokhonjiswa khona njengesamba. Ngemuva kwalokho chofoza isithonjana esivele sisazi "Faka umsebenzi".
- Iwindows liyasebenza Umsebenzi Wizards. Kulokhu sithuthela esigabeni "Izibalo". Thola bese uqokomisa igama ISUM. Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. ISUM. Lo opharetha usetshenziselwa ukubala isamba sezinamba emangqamuzaneni eshidi. I-syntax yayo ilula futhi iqondile:
= SUM (inombolo1; inombolo2; ...)Okusho ukuthi, ukuphikisana kwalokhu ku-opharetha kuvame ukuthi kube izinombolo, noma, kaningi kakhulu, izixhumanisi zamaseli lapho izinombolo ezizofakwa ziqukethe. Kepha kithi, okuwukuphela kwengxabano akusiyona inombolo noma isixhumanisi, kepha okuqukethwe ngumsebenzi Ukukhetha.
Setha isikhombisi esigangeni "Inombolo1". Ngemuva kwalokho sichofoza isithonjana, esifanekiselwa njengonxantathu ohlanekezelwe. Lesi sithonjana sikumugqa ofanayo ovundlile kanye nenkinobho. "Faka umsebenzi" nomugqa wamafomula, kepha ngakwesobunxele sabo. Uhlu lwezimpawu ezisanda kusetyenziswa. Kusukela ifomula Ukukhetha esisanda kusetyenziswa yithina ngendlela eyedlule, bese kulolu hlu. Ngakho-ke, vele uchofoze kule nto ukuze uye ewindini lokuphikisana. Kepha kungenzeka ukuthi ungabi naleli gama ohlwini. Kulokhu, chofoza isikhundla "Ezinye izinto ...".
- Ukuqala Umsebenzi Wizardskuwo Izinkomba kanye nokufika kumele sithole igama "UKUKHETHA" futhi uyiqokomise. Chofoza inkinobho "Kulungile".
- Iwindi lezimpikiswano zomsebenzisi lisebenza. Ukukhetha. Ensimini Inombolo ye-Index chaza isixhumanisi seseli eshidini lapho sizofaka khona isibalo sokuphumayo ekubonisweni okulandelayo kwemali engenayo yayo.
Ensimini "Inani1" kudingeka ufake izixhumanisi zekholomu "Ukukhishwa okungu-1". Lokhu kulula ukukwenza. Setha ikhesa kwinkambu ethile. Ngemuva kwalokho, ubambe inkinobho yesinxele segundane, khetha lonke uhla lwamaseli wekholamu "Ukukhishwa okungu-1". Ikheli lizovela ngokushesha kuwindi wokuphikisana.
Ngokufanayo nasensimini "Inani2" engeza izixhumanisi zekholomu "Izitolo ezi-2"enkundleni "Inani3" - "Amaphoyinti ama-3 athengiswayo", nasensimini "Inani4" - "Izitolo ezi-4".
Ngemuva kokuqeda lezi zinyathelo, chofoza inkinobho "Kulungile".
- Kepha, njengoba sibona, ifomula ikhombisa inani eliyiphutha. Lokhu kungenxa yokuthi asikakafaki inombolo yokuphuma esitokisini esihambisanayo.
- Faka inombolo yokuphuma ebhokisini elenzelwe lezi zinhloso. Inani lemali lekholomu elihambisanayo liboniswa masinyane kutho lweshidi lapho ifomula isethwe khona.
Kubalulekile ukuqaphela ukuthi ungafaka izinombolo kuphela ukusuka ku-1 kuye ku-4, ezizohambisana nenombolo yokuphuma. Uma ufaka enye inombolo, ifomula izophinda inikeze iphutha.
Isifundo: Ungayibala kanjani inani ku-Excel
Njengoba ukwazi ukubona, umsebenzi Ukukhetha uma isetshenziswa kahle, ingaba ngumsizi omuhle kakhulu wokuqeda imisebenzi oyabelwe. Lapho isetshenziswa ngokuhlanganiswa nabanye abaqhubi, amathuba akhuphuka kakhulu.
