Kupanga tsamba laulemu mu chikalata cha Microsoft Word.

Nthawi zina, wogwiritsa ntchitoyo akukumana ndi ntchito yobwereranso ku selo lolunjika kuchokera ku selo lina chiwerengero china cha anthu, kuyambira ndi chizindikiro chomwe chikuwonetsedwa pa akaunti kumanzere. Ntchitoyi ikugwira ntchito yaikulu ndi ntchitoyi. PSTR. Zomwe zimagwira ntchito zimakula mochulukirapo ngati ena ogwiritsira ntchito akugwiritsidwa ntchito motsutsana nawo, mwachitsanzo FUNSANI kapena FUNANI. Tiyeni tiwone bwinobwino momwe mbali za ntchitoyi zilili. PSTR ndipo onani momwe zimagwirira ntchito ndi zitsanzo zenizeni.

Kugwiritsa ntchito PSTR

Ntchito yaikulu ya wogwira ntchito PSTR ndi kuchotsa pa chiganizo china pa pepala nambala yina yosindikizidwa, kuphatikizapo malo, kuyambira ndi khalidwe lomwe likuwonetsedwa kumanzere kwa chizindikiro. Ntchitoyi ndi ya gulu la olemba mauthenga. Mawu ake omasulira ndi awa:

= PSTR (malemba; initial_position; chiwerengero cha zilembo)

Monga mukuonera, ndondomekoyi ili ndi zifukwa zitatu. Zonse zimafunika.

Kutsutsana "Malembo" lili ndi adiresi ya zigawo za pepala zomwe zili ndi mawu omveka ndi zilembo zochotsedwazo.

Kutsutsana "Kuyamba Udindo" amaperekedwa mwa mawonekedwe a nambala, yomwe imasonyeza kuchokera chizindikiro chomwe chili pa akaunti, kuyambira kumanzere, nkofunika kuchotsa. Chikhalidwe choyamba chimawerengera monga "1"chachiwiri "2" ndi zina zotero Ngakhale malo akuwerengedwa mu mawerengedwe.

Kutsutsana "Number of characters" lili ndi chiwerengero cha chiwerengero cha chiwerengero cha zilembo, kuyambira pa malo oyambirira kuti apitsidwe ku selo lolunjika. Powerengera chimodzimodzi ndi kutsutsana koyambirira, mipata imatengedwa mu akaunti.

Chitsanzo 1: Mzere umodzi

Fotokozani zitsanzo za kugwiritsa ntchito ntchitoyi. PSTR Tiyeni tiyambe ndi vuto losavuta pamene mukufuna kutulutsa mawu amodzi. Zoonadi, zosankha zoterezi sizikugwiritsidwa ntchito nthawi zambiri, kotero timapereka chitsanzo ichi monga chiyambi cha mfundo zoyendetsera ntchito yomwe watchulidwayo.

Kotero, tiri ndi tebulo la antchito. Chigawo choyamba chili ndi mayina a antchito. Tiyenera kugwiritsa ntchito wogwiritsa ntchito PSTR Tengerani kokha dzina la munthu woyamba kuchokera pa mndandandanda wa Peter Ivanovich Nikolayev mu selo losankhidwa.

1. Sankhani zomwe zimapangidwa pa pepalalo zomwe zidzatengedwa. Dinani pa batani "Ikani ntchito"yomwe ili pafupi ndi bar.



2. Zenera likuyamba. Oyang'anira ntchito. Pitani ku gawo "Malembo". Sankhanipo dzina "PSTR" ndipo dinani pa batani "Chabwino".



3. Wowonjezera zotsutsana zenera akuyambitsidwa. "PSTR". Monga mukuonera, pawindo ili chiwerengero cha minda chikufanana ndi chiwerengero cha zifukwa za ntchitoyi.

   Kumunda "Malembo" lowetsani makonzedwe a selo, omwe ali ndi dzina la antchito. Kuti musayendetsere ku adiresi pamanja, ingoikani mtolo m'munda ndikusindikiza batani lamanzere pa chinthucho pa pepala, chomwe chiri ndi deta yomwe tikusowa.

   Kumunda "Kuyamba Udindo" muyenera kufotokoza nambala yophiphiritsa, kuwerengera kuchokera kumanzere, kumene dzina lomaliza la antchito likuyamba. Timaganiziranso malo pamene tikuwerengera. Tsamba "H", omwe dzina lake la Nikolaev akuyambira, ndilo chizindikiro cha khumi ndi zisanu. Choncho, m'munda muike nambalayi "15".

   Kumunda "Number of characters" Muyenera kufotokoza nambala ya malemba omwe ali ndi dzina lomaliza. Ilo liri ndi anthu asanu ndi atatu. Koma kulingalira kuti pambuyo pa dzina lomaliza kulibenso maonekedwe mu selo, tikhoza kusonyeza chiwerengero chachikulu cha anthu. Izi zikutanthauza kuti mungathe kuyika chiwerengero chilichonse chofanana kapena chachikulu kuposa zisanu ndi zitatu. Timayika, mwachitsanzo, nambala "10". Koma ngati dzina lachidziwitso mu selo lili ndi mawu ambiri, nambala kapena zilembo zina, ndiye kuti tifunika kukhazikitsa nambala yeniyeni ya malemba ("8").

   Deta yonse italowa, dinani pa batani "Chabwino".



4. Monga mukuonera, patatha izi, dzina la wogwira ntchitoyo likuwonetsedwa mu chimodzi chomwe chikuwonetsedwa pa sitepe yoyamba. Chitsanzo 1 selo

Phunziro: Excel ntchito wizara

Chitsanzo 2: Kuchotsa gulu

Koma, ndithudi, kuti zikhale zothandiza, ndi kosavuta kuti mumalowetse dzina limodzi lomaliza kusiyana ndi kugwiritsa ntchito fomu ya izi. Koma kutumiza gulu la deta pogwiritsa ntchito ntchitoyi liyenera kukhala loyenera.

Tili ndi mndandanda wa mafoni a m'manja. Pamaso pa dzina la chitsanzo chilichonse ndi mawu "Mafonifoni". Tifunika kuyika muzomwe timagwiritsa ntchito malemba opanda mawu awa.

1. Sankhani choyamba chopanda kanthu chapadera chomwe zotsatiracho chiwonetsedwere, ndi kuitanitsa zenera la wotsutsa PSTR mofananamo ndi chitsanzo choyambirira.

   Kumunda "Malembo" tchulani adiresi ya gawo loyamba la chigawocho ndi deta yapachiyambi.

   Kumunda "Kuyamba Udindo" Tiyenera kufotokoza nambala yophiphiritsira yomwe deta idzatulutsidwa. Kwa ife, mu selo iliyonse isanafike dzina la chitsanzo ndilo mawu "Mafonifoni" ndi malo. Choncho, mawu omwe mukufuna kuika mu selo losiyana kulikonse amayamba ndi khalidwe la khumi. Ikani nambalayi "10" m'munda uno.

   Kumunda "Number of characters" muyenera kuyika chiwerengero cha zilembo zomwe zili ndi mawu owonetsedwa. Monga mukuonera, m'dzina la chitsanzo chilichonse ndi nambala yosiyana ya anthu. Koma mfundo yakuti pambuyo pa dzina lachitsanzo, malemba mumaselo akutsiriza akupulumutsa mkhalidwewo. Choncho, tikhoza kuyika mu chiwerengerochi nambala iliyonse yomwe ili yofanana kapena yayikulu kusiyana ndi chiwerengero cha anthu omwe ali ndi dzina lalitali kwambiri mndandandawu. Ikani chiwerengero cha zilembo zosawerengeka. "50". Dzina la matelefoni aliwonse omwe asatchulidwa salipitirira 50 olemba, kotero njira iyi imatikakamiza.

   Deta itatha, dinani pakani "Chabwino".



2. Pambuyo pake, dzina la chitsanzo choyambirira cha foni yamakonoyi likuwonetsedwa mu selo yapaderalo lomwe latchulidwa.



3. Kuti tisalowe mu selo iliyonse ya mndandanda mosiyana, timapanga kukopera kwake pogwiritsa ntchito chizindikiro chodzaza. Kuti muchite izi, ikani cholozeracho kumbali ya kumanja ya selo ndi ndondomekoyi. Mtolowo umatembenuzidwa kukhala chizindikiro chodzaza mwa mawonekedwe a mtanda wawung'ono. Lembani batani lakumanzere la mouse ndi kukokera mpaka kumapeto kwa chigawocho.



4. Monga mukuonera, mzere wonse pambuyo pake udzadza ndi deta yomwe tikusowa. Chinsinsi ndicho kuti mkangano "Malembo" ndilofotokozera mwachidule komanso limasintha ngati malo a maselo omwe akuwamasulira amasintha.



5. Koma vuto ndilo kuti ngati mwadzidzidzi tisintha kusintha kapena kuchotsa chikhomo ndi deta yapachiyambi, deta yanuyi siidzasonyezedwe molondola, chifukwa imayenderana ndi chiganizocho.

   

   Pofuna "kumasula" zotsatira kuchokera ku chiyambi chapachiyambi, timapanga njira zotsatirazi. Sankhani ndime yomwe ili ndi ndondomekoyi. Chotsatira, pitani ku tabu "Kunyumba" ndipo dinani pazithunzi "Kopani"ili pambali "Zokongoletsera" pa tepi.

   

   Monga njira yina, mukhoza kusindikizira mgwirizano wachinsinsi pambuyo pa kusankha Ctrl + C.

6. Ndiye, popanda kuchotsa kusankha, dinani pomwepo pazomwelo. Mndandanda wamakono umatsegulidwa. Mu chipika "Njira Zowonjezera" dinani pazithunzi "Makhalidwe".



7. Pambuyo pake, mmalo mwa mayendedwe, malingaliro adzalowetsedwa mu gawo losankhidwa. Tsopano mukhoza kusintha mosamala kapena kuchotsa gawo loyambirira. Izo sizidzakhudza zotsatirapo mwa njira iliyonse.

Chitsanzo chachitatu: pogwiritsa ntchito ogwira ntchito

Komabe, chitsanzo chapamwambachi ndi chochepa chifukwa chakuti mawu oyambirira m'maselo onse opatsirana ayenera kukhala nawo ofanana nambala. Gwiritsani ntchito PSTR oyendetsa FUNSANI kapena FUNANI adzakuthandizani kwambiri kugwiritsa ntchito njirayi.

Olemba malemba FUNSANI ndi FUNANI imabwezeretsa malo a chikhalidwe chodziwika bwino m'malemba omwe akuwonedwa.

Ntchito yomasulira FUNSANI lotsatira:

= SEARCH (kufufuza_text; text_for_search; koyamba_kufotokozera)

Opaleshoni yamagetsi FUNANI zikuwoneka ngati izi:

= Pezani (fufuzani_text; view_text; kuyamba_kuyimira)

Kawirikawiri, zifukwa za ntchito ziwirizi zikufanana. Kusiyana kwawo kwakukulu ndi kuti woyendetsa FUNSANI pamene deta yosinthira silingaganizire nkhani ya makalata, ndi FUNANI - amalingalira.

Tiyeni tiwone momwe tingagwiritsire ntchito woyendetsa FUNSANI kuphatikiza ndi ntchito PSTR. Tili ndi tebulo limene mayina a mitundu yosiyanasiyana ya zipangizo zamakinala omwe ali ndi dzina lokhala ndi maina onse adalowa. Monga nthawi yotsiriza, tifunika kupeza dzina la zitsanzo popanda dzina lachibadwa. Vuto ndiloti ngati mu chitsanzo choyambirira, dzina lachikhalidwe la malo onse linali lofanana ("smartphone"), ndiye mndandanda uwu ndi wosiyana ("kompyuta", "monitor", "okamba", etc.) ndi nambala yosiyana ya malemba. Kuti tithetse vutoli, tifunika woyendetsa FUNSANIzomwe ife timakhala mu ntchito PSTR.

1. Timapanga chisankho cha selo yoyamba ya chigawo kumene deta idzaperekedwe, ndipo mwa njira yowonjezera imatchula ntchito zowonjezera zenera PSTR.

   Kumunda "Malembo"monga mwachizolowezi, timatchula selo yoyamba ya chigawocho ndi deta yapachiyambi. Zonse zatha.



2. Koma mtengo wa munda "Kuyamba Udindo" adzatsutsa kuti ntchitoyi imapanga FUNSANI. Monga momwe mukuonera, deta yonse m'ndandanda imagwirizanitsidwa ndi kuti pali danga lisanayambe dzina lachitsanzo. Kotero, woyendetsa FUNSANI adzafufuza malo oyambirira mu selo la gwero lapakati ndikufotokozera chiwerengero cha chizindikiro cha ntchitoyi PSTR.

   Kutsegula zenera zotsutsana FUNSANI, ikani malonda mmunda "Kuyamba Udindo". Kenaka, dinani pa chithunzicho mwa mawonekedwe a katatu, otsika pansi. Chizindikiro ichi chili pawindo lofanana lawindo pamene batani ili. "Ikani ntchito" ndi bar yokupangira, koma kumanzere kwa iwo. Mndandanda wa ogwiritsira ntchito omalizira otsegulidwa. Popeza palibe dzina pakati pawo "Fufuzani", kenako dinani pa chinthu "Zina ...".



3. Window ikutsegula Oyang'anira ntchito. M'gululi "Malembo" sankhani dzina "Fufuzani" ndipo dinani pa batani "Chabwino".



4. Fesito yotsutsana ndi otsogolera imayambira. FUNSANI. Popeza tikuyembekezera danga, ndiye kumunda "Fufuzani mawu" ikani danga poika chithunzithunzi pamenepo ndikukankhira mzere wofananayo pa makiyi.

   Kumunda "Fufuzani mawu" onetsani kulumikiza kwa selo yoyamba ya chigawocho ndi deta yapachiyambi. Chiyanjano ichi chidzakhala chofanana ndi chimene tachiwonetsa kale mmunda "Malembo" muwindo wotsutsana PSTR.

   Mtsutso wamunda "Kuyamba Udindo" sizinayesedwe. Kwa ife, sikoyenera kuti tilembe, kapena mukhoza kuyika nambala "1". Pazomwe mwasankhazi, kufufuza kudzachitika kuchokera kumayambiriro kwa nkhaniyi.

   Deta itatha, musafulumire kukanikiza batani "Chabwino"monga ntchito FUNSANI ndi chisa. Ingolani pa dzina PSTR mu bar.



5. Pambuyo pomaliza ntchito yotsimikiziridwa yomaliza, tibwereranso kuwindo lawongolera. PSTR. Monga mukuonera, munda "Kuyamba Udindo" kale wodzaza ndi chilinganizocho FUNSANI. Koma chiwerengerochi chikuwonetsa danga, ndipo tikusowa khalidwe lotsatira pambuyo pa danga, kuchokera pamene dzina lachitsanzo likuyamba. Choncho, ku deta yomwe ilipo kale "Kuyamba Udindo" timatha kutanthauzira "+1" popanda ndemanga.

   Kumunda "Number of characters"monga mu chitsanzo choyambirira, lembani nambala iliyonse yomwe imaposa kapena yofanana ndi chiwerengero cha anthu omwe akuyimira motalika kwambiri pambali yoyamba. Mwachitsanzo, ikani nambalayi "50". Kwa ife, izi ndi zokwanira.

   Pambuyo pazochitika zonsezi, dinani pa batani "Chabwino" pansi pazenera.



6. Monga mukuonera, patapita izi, dzina la foni yamagetsi liwonetsedwa mu selo losiyana.



7. Tsopano, pogwiritsa ntchito Fill Wizard, monga mwa njira yapitayi, lembani fomuyi ku maselo omwe ali pansipa m'mbali iyi.



8. Maina a mitundu yonse ya mafoni amawonetsedwa m'maselo omwe akuwongolera. Tsopano, ngati kuli kotheka, mutha kusokoneza chiyanjano muzinthu izi ndi deta yopezera deta, monga nthawi yapitayi, ndi sequentially kugwiritsa ntchito kukopera ndi kudula ziyeso. Komabe, izi sizitanthauza nthawi zonse.

Ntchito FUNANI amagwiritsidwa ntchito motsatira ndondomekoyi PSTR mofanana ndi wogwiritsira ntchito FUNSANI.

Monga mukuonera, ntchitoyi PSTR Ndi chida chabwino kwambiri chowonetsera deta zofunika mu selo yoyambirira. Mfundo yakuti sizitchuka kwambiri pakati pa ogwiritsa ntchito ndi chifukwa chakuti ambiri ogwiritsa ntchito, pogwiritsira ntchito Excel, amanyalanyaza kwambiri masamu, osati malemba. Mukamagwiritsa ntchito njirayi kuphatikizapo ena ogwira ntchito, ntchito yake imakula kwambiri.