Isebenzisa umsebenzi we-PSTR kuMicrosoft Excel

Kwezinye izimo, umsebenzisi ubhekene nomsebenzi wokubuyisela inani elithile lezinhlamvu esitokisini okuqondiswe kulo kusuka kwesinye iseli, kuqala ngomlingiswa ongakwesobunxele we-akhawunti. Umsebenzi wenza umsebenzi omuhle walokhu. I-PSTR. Ukusebenza kwaso kuyanda ngokwengeziwe uma abanye opharetha basebenziswa basebenzisana nakho, ngokwesibonelo SESHA noma THOLA. Ake sibhekisise ukuthi yiziphi izici zomsebenzi I-PSTR futhi ubone ukuthi isebenza kanjani kwizibonelo ezithile.

Usebenzisa i-PSTR

Umsebenzi oyinhloko we-opharetha I-PSTR Kuqukethe ukukhishwa kusukela eshinini elibonisiwe inombolo ethile yezinhlamvu eziphrintiwe, kufaka phakathi izikhala, kusukela kunhlamvu ekhonjiswe ku-akhawunti kuya kwesobunxele. Lo msebenzi ungowesigaba sabasebenzisi bemibhalo. I-syntax yayo ithatha ifomu elilandelayo:

= PSTR (umbhalo; isiqalo_isizinda; inombolo yezinhlamvu)

Njengoba ubona, le formula inezimpikiswano ezintathu. Zonke ziyadingeka.

Ukuxabana "Umbhalo" iqukethe ikheli le-sheet element lapho inkulumo yombhalo enezinhlamvu ezikhiphekayo itholakala khona.

Ukuxabana "Ukuqala isikhundla" kwethulwe ngesimo senombolo ekhombisa ukuthi yimuphi umlingiswa ku-akhawunti, kusukela kwesobunxele, udinga ukukhipha. Umlingiswa wokuqala ubala njengokuthi "1"okwesibili kwe "2" njll. Ngisho nezikhala zithathwa lapho kubalwa.

Ukuxabana "Inani lezinhlamvu" iqukethe inkomba yezinombolo yenombolo yezinhlamvu, kusukela endaweni yokuqala, okumele ikhishwe kwiseli ekhonjiwe. Ekubaleni, njengasesingxabanweni esedlule, izikhala ziyabhekwa.

Isibonelo 1: ukukhishwa okukodwa

Chaza izibonelo zomsebenzi I-PSTR qala ngecala elilula uma udinga ukukhipha inkulumo eyodwa. Vele, izinketho ezinjalo azivame ukusetshenziswa ekusetshenzisweni, ngakho-ke sinikeza lesi sibonelo kuphela njengesingeniso ezimisweni zokusebenza zalo opharetha.

Ngakho-ke, sinethebula labasebenzi bebhizinisi. Ikholamu lokuqala libonisa amagama, izibongo nokuqanjwa kwabasebenzi. Sidinga ukusebenzisa opharetha I-PSTR ukukhipha igama lomuntu wokuqala kuphela ohlwini lukaPyotr Ivanovich Nikolaev esitokisini esikhonjisiwe.

1. Khetha into eshidi lapho kuzokhishwa khona lokhu kukhishwa. Chofoza inkinobho "Faka umsebenzi"etholakala eduze nomugqa wamafomula.



2. Iwindows liqala Umsebenzi Wizards. Iya esigabeni "Umbhalo". Sikhetha igama lapho I-PSTR bese uchofoza inkinobho "Kulungile".



3. Ukuqaliswa Kwe-Window Ye-Operator Argument I-PSTR. Njengoba ukwazi ukubona, kule windi inani lezinkambu lifana nenombolo yezimpikiswano zalo msebenzi.

   Ensimini "Umbhalo" faka izixhumanisi zeseli equkethe igama lezisebenzi. Ukuze ungashayeli ikheli ngesandla, simane nje sibeke isikhombisi ensimini bese sichofoza kwesobunxele entweni eshidi equkethe imininingwane esiyidingayo.

   Ensimini "Ukuqala isikhundla" kufanele uchaze inombolo yesimboli, ubala kusukela kwesobunxele, okuqalwa kuso isibongo somsebenzi. Uma sibala, futhi sinaka izikhala. Incwadi "N"okuqala ngalo isibongo somsebenzi wakwaNikolaev, ungumlingiswa weshumi nanhlanu ulandelana. Ngakho-ke, sibeka inombolo enkundleni "15".

   Ensimini "Inani lezinhlamvu" Kufanele uchaze inani lezinhlamvu ezakha igama lokugcina. Inezinhlamvu eziyisishiyagalombili. Kepha uma sibheka ukuthi azisekho izinhlamvu esitokisini ngemuva kwegama lokugcina, singakhombisa nezinhlamvu eziningi. Lokho wukuthi, kithi, ungabeka noma iyiphi inombolo elingana noma enkulu kuneyisishiyagalombili. Sifaka, ngokwesibonelo, inombolo "10". Kepha uma ngabe kunamagama amaningi, izinombolo noma ezinye izimpawu kuseli ngemuva kwegama lokugcina, khona-ke bekuzofanela sibeke inani eliqondile lezinhlamvu ("8").

   Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".



4. Njengoba ubona, ngemuva kwalesi senzo, igama lesisebenzi laboniswa kusinyathelo sokuqala esisichazile Isibonelo 1 iseli.

Isifundo: I-Excel Feature Wizard

Isibonelo 2: ukukhishwa kwe-batch

Kepha, ngeqiniso, ngezinhloso ezisebenzayo kulula ukuhambisa ngemoto ngesibongo esisodwa kunokusebenzisa ifomula kulokhu. Kepha ukudlulisa iqembu ledatha usebenzisa umsebenzi kuzofanela impela.

Sinohlu lwama-Smartphones. Igama ngalinye lesibonelo landulelwa igama I-Smartphone. Sidinga ukubeka kuphela amagama amamodeli ngaphandle kwaleli gama kwikholamu ehlukile.

1. Khetha into yokuqala engenalutho yekholamu lapho umphumela uzokhonjiswa khona, bese ushayela iwindi lokuphikisana ngopharetha I-PSTR ngendlela efanayo nakwisibonelo esedlule.

   Ensimini "Umbhalo" chaza ikheli lezinto zokuqala zekholomu nedatha yomthombo.

   Ensimini "Ukuqala isikhundla" sidinga ukucacisa inombolo yezinhlamvu eziqala lapho imininingwane izokhishwa kuyo. Esimweni sethu, esitokisini ngasinye, igama lemodeli linalo igama I-Smartphone nesikhala. Ngakho-ke, ibinzana ofuna ukulibonisa esitokisini esihlukile yonke indawo liqala ngomlingiswa weshumi. Setha inombolo "10" kulo mkhakha.

   Ensimini "Inani lezinhlamvu" udinga ukusetha inani lezinhlamvu eziqukethe ibinzana elibonisiwe. Njengoba ukwazi ukubona, igama lemodeli ngayinye linenombolo ehlukile yezinhlamvu. Kepha iqiniso lokuthi ngemuva kwegama eliyimodeli, umbhalo osesitokisini uphela usindisa lesi simo. Ngakho-ke, singabeka kule nsimu noma iyiphi inombolo elingana noma enkulu kunenani lezinhlamvu ebizweni elide kunazo zonke kulolu hlu. Setha noma iyiphi inombolo yezinhlamvu "50". Igama lalezi Smartphones alidluli 50 abalingiswa, ngakho-ke le ndlela isifanele.

   Ngemuva kokuthi idatha ifakiwe, chofoza inkinobho "Kulungile".



2. Ngemuva kwalokho, igama lemodeli yokuqala ye-smartphone iboniswa kuseli elimiselwe ngaphambili etafuleni.



3. Ukuze singafaki ifomula ngokwehlukana kuseli ngayinye yekholamu, siyikopisha sisebenzisa umaki wokugcwalisa. Ukuze wenze lokhu, beka ikhesa ekhoneni elingezansi kweseli ngefomula. Isikhombisi siguqulwa sibe umaka wokugcwalisa ngendlela yesiphambano esincane. Bamba inkinobho yegundane kwesobunxele uyidonsele ekugcineni kwekholomu.



4. Njengoba ukwazi ukubona, ikholamu yonke ngemuva kwalokho izogcwaliswa imininingwane esiyidingayo. Imfihlo ukuthi ingxabano "Umbhalo" imele ireferensi yesihlobo futhi ibuye ishintshe njengoba isikhundla samaseli kwelitshe sishintsha.



5. Kepha inkinga ukuthi uma kungazelelwe sinquma ukushintsha noma ukususa ikholamu nedatha yasekuqaleni, imininingwane esekholini okuqondisiwe ngeke ikhonjiswe kahle, ngoba zihlobene nefomula.

   

   Ukuze "ukhulule" umphumela kusuka kukholamu yasekuqaleni, senza okukhohlisa okulandelayo. Khetha ikholomu equkethe ifomula. Okulandelayo, iya kuthebhu "Ikhaya" bese uchofoza isithonjana Kopishaetholakala ebhlokini Ibhodi yokunamathisela ekhasethini.

   

   Njengesinye isenzo, ungacindezela inhlanganisela yokhiye ngemuva kokugqamisa I-Ctrl + C.

6. Okulandelayo, ngaphandle kokususa ukukhetha, chofoza ngakwesokudla kwikholamu. Imenyu yokuqukethwe iyavula. Ebhlokini Faka Izinketho chofoza isithonjana "Amanani".



7. Ngemuva kwalokho, esikhundleni semifomula, amanani azofakwa kwikholamu ekhethiwe. Manje usungashintsha ngokuphepha noma ususe ikholomu yoqobo. Lokhu ngeke kuwuthinte umphumela.

Isibonelo 3: ukusebenzisa inhlanganisela yabasebenza

Kepha noma kunjalo, lesi sibonelo esingenhla silinganiselwe ngoba igama lokuqala kuwo wonke amaseli omthombo kumele libe nenombolo efanayo yezinhlamvu. Isicelo ngomsebenzi I-PSTR opharetha SESHA noma THOLA izokwandisa kakhulu amathuba okusebenzisa ifomula.

Abasebenza ngombhalo SESHA futhi THOLA buyisela isikhundla sohlamvu oluchaziwe kumbhalo obukiwe.

Umsebenzi Syntax SESHA okulandelayo:

= SEARCH (search_ Umxholo; umbhalo_to_search; qala_indawo)

ISyntax yokusebenza THOLA kubukeka kanjena:

= THOLA (search_ Umxholo; kubukwa_umongo; isiqalo_isizinda)

Kakhulu, ukuphikisana kwale misebenzi emibili kuyafana. Umehluko wabo oyinhloko ukuthi opharetha SESHA lapho ukucubungulwa kwedatha kungazwelani, kepha THOLA - Uyakhumbula.

Ake sibheke ukuthi ungayisebenzisa kanjani i-opharetha SESHA kuhlanganiswe nomsebenzi I-PSTR. Sinethebula lapho kufakwa khona amagama ezinhlobo ezahlukahlukene zemishini yamakhompyutha enegama elijwayelekile. Njengokugcina, sidinga ukukhipha igama lamamodeli ngaphandle kwegama elijwayelekile. Ubunzima ngukuthi uma ngokwesibonelo esedlule igama elijwayelekile lazo zonke izinto lalifana ("i-smartphone"), khona-ke ohlwini olukhona luhlukile ("ikhompyutha", "qapha", "izikhulumi", njll.) ngenombolo ehlukile yezinhlamvu. Ukuxazulula le nkinga, sidinga opharetha SESHAesizokubeka kuwo umsebenzi I-PSTR.

1. Sikhetha iseli lokuqala lekholamu lapho idatha izokhishwa khona, futhi ngendlela ejwayelekile esiyibiza ngayo iwindi lokuphikisana komsebenzi I-PSTR.

   Ensimini "Umbhalo", njengenjwayelo, sibonisa iseli lokuqala lekholamu nedatha yomthombo. Konke akuguquki.



2. Nanti inani lenkambu "Ukuqala isikhundla" izosetha ukuphikisana kokuthi amafomu wokusebenza SESHA. Njengoba ukwazi ukubona, yonke imininingwane ekulu yohlu ihlanganiswa yiqiniso lokuthi igama lemodeli landulelwa isikhala. Ngakho-ke, opharetha SESHA izosesha isikhala sokuqala kuseli lobubanzi bomthombo futhi ibike nenombolo yalesi sibonakaliso somsebenzi I-PSTR.

   Ukuze uvule iwindi lokuphikisana nomsebenzi SESHA, setha ikhesa enkundleni "Ukuqala isikhundla". Okulandelayo, chofoza isithonjana ngesimo sikunxantathu, esiqondiswe phansi. Lesi sithonjana sisezingeni elilinganayo lewindi njengenkinobho. "Faka umsebenzi" nomugqa wamafomula, kepha ngakwesobunxele sabo. Uhlu lwabasebenza kakhulu muva nje luyavula. Njengoba kungekho gama phakathi kwabo SESHA, bese uqhafaza entweni "Ezinye izinto ...".



3. Kuvulwa iwindi Umsebenzi Wizards. Esigabeni "Umbhalo" khetha igama SESHA bese uchofoza inkinobho "Kulungile".



4. Ukuqaliswa Kwe-Window Ye-Operator Argument SESHA. Njengoba sifuna isikhala, enkundleni "Umbhalo oseshwayo" beka isikhala ngokubeka isikhombisi lapho futhi ucindezela ukhiye ohambelana nawo kukhibhodi.

   Ensimini Umbhalo Wokusesha chaza isixhumanisi seseli lokuqala lekholamu nedatha yomthombo. Lesi sixhumanisi sizofana naleso esivele sikhombise inkambu ngaphambili "Umbhalo" ewindini lokuphikisana ng opharetha I-PSTR.

   Ingxabano yensimu "Ukuqala isikhundla" akufuneki. Esimweni sethu, akudingekile ukugcwalisa noma ungabeka inombolo "1". Nganoma ikuphi kwalokhu okukhethiwe, usesho luzokwenziwa kusukela ekuqaleni kombhalo.

   Ngemuva kokuthi idatha ifakiwe, musa ukujaha ukucindezela inkinobho "Kulungile", selokhu kusebenze SESHA isidleke. Vele uchofoze igama I-PSTR emugqeni wefomula.



5. Ngemuva kokwenza isenzo esibekiwe sokugcina, sibuyela ngokuzenzakalelayo kuwindi wokuphikisana nomsebenzi I-PSTR. Njengoba ubona, insimu "Ukuqala isikhundla" sekugcwalisiwe ifomula SESHA. Kepha le formula ikhombisa isikhala, futhi sidinga umlingiswa olandelayo ngemuva kwendawo, lapho igama lemodeli liqala khona. Ngakho-ke, kudatha ekhona enkundleni "Ukuqala isikhundla" engeza isisho "+1" ngaphandle kwezingcaphuno.

   Ensimini "Inani lezinhlamvu"njengasesibonelweni esedlule, sibhala noma iyiphi inombolo enkulu kunaleyo noma elilingana nenombolo yezinhlamvu ezwini olude kakhulu kukholamu yomthombo. Isibonelo, sibeka inombolo "50". Kithi, lokhu kwanele.

   Ngemuva kokwenza konke lokhu kukhwabanisa, chofoza inkinobho "Kulungile" phansi kwewindi.



6. Njengoba ubona, ngemuva kwalokhu igama lemodeli yedivayisi lavezwa esitokisini esihlukile.



7. Manje, usebenzisa i-Fill Wizard, njengasekuqaleni kwendlela, kopisha ifomula kumaseli akhiwe ngezansi kwale kholamu.



8. Amagama wazo zonke izinhlobo zamadivayisi akhonjiswa kumaseli okuqondiwe. Manje, uma kunesidingo, ungaphula ukuxhumana kulezi zinto ngekholamu yedatha yomthombo, njengasesikhathini esedlule, ngokukopisha nokunamathisela amanani ngokulandelana. Noma kunjalo, lesi senzo asidingeki njalo.

Umsebenzi THOLA isetshenziswe ngokuhambisana nefomula I-PSTR ngemigomo efanayo ne-opharetha SESHA.

Njengoba ukwazi ukubona, umsebenzi I-PSTR iyithuluzi elilula kakhulu lokubonisa idatha edingekayo kuseli elicacisiwe ngaphambili. Iqiniso lokuthi alithandwa kangako phakathi kwabasebenzisi liyachazwa iqiniso lokuthi abasebenzisi abaningi, besebenzisa i-Excel, banaka kakhulu imisebenzi yezibalo, kunombhalo. Uma usebenzisa le formula ihlangana nabanye abaqhubi, ukusebenza kwayo kuyathuthukiswa.