Kwezinye izimo, umsebenzisi ubhekene nomsebenzi wokubuyela esitokisini esitshelwe kusuka kwelinye iseli inombolo ethile yabalingiswa, kuqala ngesibonakaliso esiboniswe ku-akhawunti ngakwesobunxele. Umsebenzi wenza umsebenzi omkhulu ngalolu msebenzi. I-PSTR. Ukusebenza kwalo kwanda nakakhulu uma amanye ama-opharetha asetshenziselwa ngokuhambisana nalo, isibonelo SEARCH noma FUNDA. Ake sihlolisise ukuthi yiziphi izici zomsebenzi. I-PSTR futhi ubone ukuthi isebenza kanjani nezibonelo ezithile.
Usebenzisa i-PSTR
Umsebenzi oyinhloko womqhubi I-PSTR ukukhipha isici esicacisiwe seshidi inamba ethile yabalingiswa abashicilelwe, kufaka phakathi izikhala, ukuqala nomlingisi oboniswe ngakwesobunxele besimboli. Lo msebenzi ungokwesigaba sama-opharetha wombhalo. I-syntax yayo ilandelayo:
= PSTR (umbhalo; okokuqala_kuthunyelwe; inombolo yabalingiswa)
Njengoba ubona, leli fomula linamaphuzu amathathu. Konke kuyadingeka.
Ukuphikisana "Umbhalo" iqukethe ikheli lesici sephepha eliqukethe umbhalo wezinhlamvu nezinhlamvu ezikhishwe.
Ukuphikisana "Ukuqala Isikhundla" enikezwe ngesimo senombolo, ekhombisa ukuthi yisiphi isibonakaliso ku-akhawunti, kusukela kwesobunxele, kubalulekile ukukhipha. Umlingiswa wokuqala ubala njengokuthi "1"okwesibili "2" nokunye Ngisho nezikhala zibalwa ekubalweni.
Ukuphikisana "Inombolo yabalingiswa" iqukethe inkomba yenombolo yenani labalingiswa, kusukela esendaweni sokuqala okufanele ikhishwe kuseli elitsheliwe. Ekubaleni okufana nokuphikisana kwangaphambilini, izikhala zicatshangelwa.
Isibonelo 1: ukukhipha okukodwa
Chaza izibonelo zokusetshenziswa komsebenzi. I-PSTR Ake siqale ngecala elilula uma udinga ukukhipha inkulumo eyodwa. Yiqiniso, okukhethwa kukho okunjalo ekusebenzeni akuvamile ukusetshenziswa, ngakho-ke sinikeza lesi sibonelo kuphela njengesingeniso kwimigomo yokusebenza komqhubi ocacisiwe.
Ngakho, sinetafula labasebenzi. Ikholomu yokuqala iqukethe amagama abasebenzi. Sidinga ukusebenzisa i-opharetha I-PSTR khipha isibongo somuntu wokuqala ohlwini lukaPeter Ivanovich Nikolayev esitokisini esicacisiwe.
- Khetha isici seshidi lapho lesi sakhiwo sizokwenziwa khona. Chofoza inkinobho "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.
- Ifasitela iqala. Amakhosi omsebenzi. Iya kusigaba "Umbhalo". Khetha igama "PSTR" bese uchofoza inkinobho "Kulungile".
- Ifasitelana lokuphikisana lomqhubi liqalisiwe. "PSTR". Njengoba ungabona, kule festile inani lamasimu lihambisana nenombolo yezimpikiswano zalolu msebenzi.
Ensimini "Umbhalo" faka izixhumanisi zeseli, equkethe igama labasebenzi. Ukuze ungadluliseli ekhelini ngesandla, vele ubeke isikhangiso endle bese uchofoza inkinobho yesinxele yesinxele kwisici eshadini, equkethe idatha esiyidingayo.
Ensimini "Ukuqala Isikhundla" kufanele ucacise inombolo yezinombolo, ubale kusukela kwesobunxele, lapho igama lokugcina lomsebenzi liqala khona. Siphinde sicabange izikhala lapho sibalwa. Incwadi "H", okuyinto isibongo somsebenzi uNikolaev eqalayo, uphawu lweshumi nanhlanu. Ngakho-ke, ensimini ubeke inombolo "15".
Ensimini "Inombolo yabalingiswa" Kumelwe ucacise inani labalingiswa abakha igama lokugcina. Iqukethe izinhlamvu ezingu-8. Kodwa ucabanga ukuthi emva kwegama lokugcina azikho izinhlamvu eziseli cell, singabonisa inombolo enkulu yabalingiswa. Okungukuthi, kithi, ungabeka noma iyiphi inombolo elingana noma ngaphezulu kunezingu-8. Sibeka, isibonelo, inombolo "10". Kodwa uma ngemuva kwesibongo esitokisini kwakukhona amagama amaningi, izinombolo noma ezinye izinhlamvu, khona-ke kufanele sibeke inani eliqondile labalingiswa ("8").
Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalesi senzo, igama lomsebenzi liboniswe kulowo oboniswe esiteji sokuqala. Isibonelo 1 iseli
Isifundo: I-Excel umsebenzi wizard
Isibonelo sesibili: isiqephu seqembu
Kodwa, yebo, ngenhloso ewusizo, kulula ukufaka igama elilodwa lokugcina ngaphandle kokusebenzisa ifomula yalokhu. Kodwa ukudlulisa iqembu lemininingwane usebenzisa umsebenzi kuyoba kufanelekile.
Sine uhlu lwe-Smartphones. Ngaphambi kwegama lemodeli ngayinye yigama "I-smartphone". Sidinga ukufaka kukholomu ehlukile kuphela amagama wamamodeli ngaphandle kwaleli gama.
- Khetha isici sekholomu sokuqala esingenalutho lapho umphumela uzoboniswa khona, bese ufonela iwindi le-argument ye-opharetha I-PSTR ngendlela efanayo nesibonelo sangaphambilini.
Ensimini "Umbhalo" ucacise ikheli lento yokuqala yekholomu nedatha yangempela.
Ensimini "Ukuqala Isikhundla" sidinga ukucacisa inombolo yephawu lapho idatha izokhipha khona. Esikhathini sethu, esitokisini ngasinye ngaphambi kokuthi igama le-model liyizwi "I-smartphone" futhi isikhala. Ngakho, inkulumo ofuna ukuyifaka eseceleni ehlukile yonke indawo iqala ngesimo seshumi. Setha inombolo "10" kule nsimu.
Ensimini "Inombolo yabalingiswa" udinga ukusetha inamba yezinhlamvu eziqukethe ibinzana elibonisiwe. Njengoba ubona, egameni le-model ngayinye kunenani elihlukile labalingiswa. Kodwa iqiniso lokuthi ngemuva kwegama lomhlahlandlela, umbhalo kulowo maseli uphela ukonga isimo. Ngakho-ke, singasetha kule nsimu noma iyiphi inombolo elingana noma enkulu kunale namba yabalingiswa egameni elide kakhulu kulolu hlu. Setha inani elingenamkhawulo labalingiswa. "50". Igama lenye ye-Smartphones ehlisiwe ayidluli 50 abalingiswa, ngakho-ke lokhu kukhetho kusithandela.
Ngemuva kwedatha efakiwe, chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, igama lemodeli yokuqala ye-smartphone iboniswa esitokisini esedlule esithebula.
- Ukuze ungangeni kufomula ngayinye ngayinye yekholomu ngokwehlukana, senza ukukopisha kwayo ngokusebenzisa uphawu lokugcwalisa. Ukuze wenze lokhu, faka isikhombisi ekhoneni elingaphansi kwesokudla leseli ngefomula. I-cursor ishintshelwa kumakaki okugcwalisa ngesimo se-cross encane. Cindezela inkinobho yesinxele yesinxele bese uyihudula kuze kube sekupheleni kwekholomu.
- Njengoba ungabona, ikholomu yonke emva kwalokhu izogcwaliswa nedatha esiyidingayo. Imfihlo yukuthi ingxabano "Umbhalo" kuyinto reference reference futhi futhi ushintsho njengoba isikhundla samaseli kwelitshe sishintsha.
- Kodwa inkinga ukuthi uma senza isinqumo ngokuzumayo ukushintsha noma ukususa ikholomu ngemininingwane yangempela, idatha ekholomu eqondisiwe ngeke ikhonjiswe ngendlela efanele, ngoba ihlobene nomunye ifomula.
Ukuze 'ukhulule' umphumela kusuka kukholomu yokuqala, senza okulandelayo. Khetha ikholomu equkethe ifomula. Okulandelayo, iya kuthebhu "Ikhaya" bese uchofoza isithonjana "Kopisha"esithombeni "Ibhodi lokunamathisela" kwi-tape.
Njengesinye isenzo, ungacindezela inhlanganisela yekhiye ngemuva kokukhethwa Ctrl + C.
- Khona-ke, ngaphandle kokukhipha ukhetho, chofoza ngakwesokudla kukholomu. Imenyu yomongo ivulwa. Ku-block "Izinketho zokufaka" chofoza kusithonjana "Amanani".
- Ngemva kwalokho, esikhundleni samafomula, amanani azofakwa kukholomu ekhethiwe. Manje ungashintsha ngokuphepha noma ususe ikholomu yangempela. Ngeke kuthinte umphumela nganoma iyiphi indlela.
Isibonelo sesi-3: usebenzisa inhlanganisela yama-opharetha
Noma kunjalo, isibonelo esingenhla sinqunyelwe ukuthi igama lokuqala kuwo wonke amaseli omthombo kufanele libe nenani elilinganayo lezinhlamvu. Sebenzisa ngomsebenzi I-PSTR opharetha SEARCH noma FUNDA kuzokwenza kakhulu ukwandisa amathuba okusebenzisa ifomula.
Ama-operators ombhalo SEARCH futhi FUNDA ubuyisela isikhundla somlingiswa ocacisiwe kulo mbhalo okubukwayo.
Umsebenzi we-syntax SEARCH okulandelayo:
= SEARCH (search_text; text_for_search; initial_position)
I-syntax ye-Operator FUNDA kubukeka kanje:
= FIND (ukusesha_text; view_text; kuqala_kuthunyelwe)
Ngokubanzi, izimpikiswano zale mibini emibili zifana. Umehluko wabo omkhulu wukuthi opharetha SEARCH lapho ukucubungula idatha kungacabangi icala lezinhlamvu, futhi FUNDA - ucabangela.
Ake sibone ukuthi singasebenzisa kanjani opharetha SEARCH kuhlangene nomsebenzi I-PSTR. Sinetafula lapho amagama amamodeli ahlukahlukene wemishini yekhompiyutha enegama elijwayelekile efakiwe. Njengesikhathi sokugcina, sidinga ukuthola igama lezithombe ngaphandle kwegama elijwayelekile. Ubunzima ukuthi uma kusibonelo esandulele igama elivamile lazo zonke izikhundla lalifanayo ("smartphone"), ke kulolu hlu kuhluke ("ikhomputha", "ukuqapha", "izikhulumi", njll.) ngenani elihlukile labalingiswa. Ukuxazulula le nkinga, sidinga opharetha SEARCHokuyinto esihlala kuyo emsebenzini I-PSTR.
- Senza ukukhethwa kweseli yokuqala yekholomu lapho idatha izokhipha khona, futhi ngendlela ejwayelekile shayela ifonti yokusebenza I-PSTR.
Ensimini "Umbhalo"njengokujwayelekile, sichaza iseli lokuqala lekholomu ngemininingwane yangempela. Konke kuqinisiwe.
- Kodwa inani lensimu "Ukuqala Isikhundla" izobeka ukuphikisana ukuthi umsebenzi ufometha SEARCH. Njengoba ungabona, yonke idatha ohlwini ihlangene iqiniso lokuthi kukhona isikhala ngaphambi kwegama lomfanekiso. Ngakho-ke, opharetha SEARCH izosesha isikhala sokuqala esitokisini sobubanzi bomthombo bese ibika inombolo yalesi simboli somsebenzi I-PSTR.
Ukuvula iwindi lempikiswano ye-opharetha SEARCH, setha isikhangiso ensimini "Ukuqala Isikhundla". Okulandelayo, chofoza isithonjana ngendlela yesonxantathu, eqondiswa phansi. Lesi sithonjana sisezingeni elifanayo elilinganayo lewindi lapho kunenkinobho khona. "Faka umsebenzi" futhi ibha yefomula, kodwa ngakwesobunxele babo. Uhlu lwabasebenzisi bokugcina oluvuliwe oluvuliwe. Njengoba akekho igama phakathi kwabo "SEARCH", bese uchofoza into "Ezinye izici ...".
- Iwindi ivula Amakhosi omsebenzi. Esikhathini "Umbhalo" khetha igama "SEARCH" bese uchofoza inkinobho "Kulungile".
- Iwindi lempikiswano ye-Operator iqala. SEARCH. Njengoba sibheke isikhala, bese sisensimini "Sesha umbhalo" faka isikhala ngokubeka isikhombisi lapho bese ucindezela ukhiye ohambelana kwikhibhodi.
Ensimini "Sesha umbhalo" ucacise isixhumanisi esitokisini sokuqala sekholomu nedatha yangempela. Lesi sixhumanisi sizofana nalokho esikubonise ngaphambili ensimini "Umbhalo" efasiteleni lokuphikisana lomsebenzisi I-PSTR.
Ingxabano yasensimini "Ukuqala Isikhundla" akudingeki. Esimweni sethu, akudingekile ukuyigcwalisa, noma ungabeka inombolo "1". Kuzo zonke izinketho, ukusesha kuzokwenziwa kusukela ekuqaleni kombhalo.
Ngemuva kwedatha efakiwe, ungasheshi ukucindezela inkinobho "Kulungile"njengoba umsebenzi SEARCH isidleke. Vele uchofoze igama I-PSTR kubha yefomula.
- Ngemuva kokukhishwa kwesenzo sokugcina esicacisiwe, sibuyela ngokuzenzakalelayo ewindini lezimpendulo ze-opharetha. I-PSTR. Njengoba ungabona, insimu "Ukuqala Isikhundla" kakade igcwele ifomula SEARCH. Kodwa le fomula ibonisa isikhala, futhi sidinga umlingisi olandelayo ngemuva kwesikhala, okuvela kulo igama lesibonelo. Ngakho-ke, idatha ekhona ensimini "Ukuqala Isikhundla" siqedile ukukhuluma "+1" ngaphandle izingcaphuno.
Ensimini "Inombolo yabalingiswa"njengalesi sibonelo esandulele, bhala noma iyiphi inombolo ekulu kunaleyo noma elingana nenani labalingiswa ekuboniseni isikhathi eside kwekholomu yokuqala. Isibonelo, faka inombolo "50". Esikhathini sethu, lokhu kuwanele.
Ngemuva kokusebenza okucacisiwe, chofoza inkinobho "Kulungile" phansi kwefasitela.
- Njengoba ungabona, emva kwalokhu, igama le-model model likhonjisiwe kuseli elithile.
- Manje, usebenzisa i-Wizard Yokugcwalisa, njengendlela yangaphambilini, ukopisha ifomula emafenjini atholakala ngezansi kule kholomu.
- Amagama azo zonke izinhlobo zedivayisi aboniswa kumaseli athile. Manje, uma kunesidingo, ungaphula isixhumanisi kulezi zakhi ngekholomu yedatha yomthombo, njengangesikhathi esidlule, ngokulandelana ngokulandelana kokusebenzisa ukukopisha nokulinganisa amanani. Noma kunjalo, lesi senzo akudingeki ngaso sonke isikhathi.
Umsebenzi FUNDA esetshenziswa ngokuhambisana nefomula I-PSTR ngendlela efanayo nomqhubi SEARCH.
Njengoba ungabona, umsebenzi I-PSTR Kuyithuluzi elilula kakhulu lokubonisa idatha edingekayo kuseli elichazwe ngaphambilini. Iqiniso lokuthi alithandwayo kakhulu phakathi kwabasebenzisi kungenxa yokuthi abasebenzisi abaningi, besebenzisa i-Excel, bakhokhela kakhulu imisebenzi yemathemikhali, kunokuba babhale amagama. Uma usebenzisa le fomu ngokuhlanganiswa namanye ama-opharetha, ukusebenza kwayo kwanda nakakhulu.
