Ntchito Yogwira Ntchito

Nthawi zina, wogwiritsa ntchitoyo amakumana ndi ntchitoyo kuti abweze chiwerengero cha zilembo kuchokera ku khungu lina kuchokera ku cell ina, kuyambira chizindikiro cholembedwa kumanzere. Ndi ntchitoyi, ntchito ya PSTR imagwira bwino ntchito. Ntchito zake zimawonjezeka kwambiri ngati ogwiritsa ntchito ena amagwiritsidwa ntchito kuphatikiza, monga kusaka kapena kupeza. Tiyeni tiwone zambiri mwatsatanetsatane zomwe kuthekera kwa PST ndikugwiritsa ntchito ndikuwona momwe zimagwirira ntchito pazitsanzo.

Kugwiritsa ntchito pst

Ntchito yayikulu ya wopanga PSTR ndikuchotsa gawo la pepalalo la zizindikiro zingapo za zizindikiro, kuphatikizapo malo, kuyambira komwe adawonetsedwa kumanzere kwa chizindikirocho. Izi zikutanthauza gulu la ogwiritsa ntchito malembedwe. Syntax yake imatenga fomu iyi:

= Pst (mawu; koyambirira_a; nambala_ dzina)

Monga tikuwona, njirayi imakhala ndi mikati itatu. Zonsezi ndizovomerezeka.

Mtsutsowu uli ndi adilesi ya tsamba la tsamba momwe mawu oti mawuwo ali ndi zizindikiro zochotsa.

Kukangana koyamba kwa malowa kumawonetsedwa mwa mtundu wa nambala yomwe ikuwonetsa chizindikiro cha akauntiyo, kuyambira kumanzere, kuyenera kupangidwa. Chizindikiro choyamba chimatengedwa "1", chachiwiri cha "2", ndi zina. Ngakhale mipata imakhudzidwa ndi kuwerengera.

Mfundo "Chiwerengero cha Zizindikiro" zili ndi zilembo zingapo zokha, kuyambira koyamba kuti zichotsedwe mu cell. Mukamawerengera chimodzimodzi monga mkangano wapitawu, mipata imawerengedwa.

Chitsanzo 1: Kuchotsa kamodzi

Fotokozani zitsanzo za kugwiritsa ntchito kwa astro ntchito kuti muyambe kuchokera ku chinthu chosavuta kwambiri pakafunika kuchotsa mawu amodzi. Zachidziwikire, kusankha ngati izi ndizosowa kwambiri, motero timangopereka chitsanzo ichi podziwa mfundo za wothandizirayo.

Chifukwa chake, tili ndi tebulo la ogwira ntchito mu bizinesi. Gawo loyamba likuwonetsa mayina, maina ndi asitikali a Patronymic. Tinkafunikira kugwiritsa ntchito cholembera cha PSTR kuti chithetse dzina la munthu woyamba kuchokera pamndandanda wa Peter Ivanovich Nikolaev m'chipinda chotchulidwa.

1. Sankhani gawo lomwe lidzatulutsidwa. Dinani pa batani la "Intern Act", yomwe ili pafupi ndi mawonekedwe.



2. Zenera la Wizard limayamba. Pitani ku "zolemba". Timagawa dzina "pst" ndikudina batani la "OK".



3. "PST. Monga mukuwonera, pawindo ili kuchuluka kwa minda kumafanana ndi kuchuluka kwa zotsutsana za ntchitoyi.

   Mumunda "Zolemba" timayambitsa mgwirizano wa khungu, womwe umakhala ndi mayina a ogwira ntchito. Pofuna kuti musayendetse adilesiyo pamanja, timangokhazikitsa cholembera m'munda ndikudina batani lakumanzere pa element pa pepala lomwe lomwe limafunikira limapezeka.

   Mu "gawo loyambira", muyenera kutchula nambalayo, kuwerengera kumanzere, komwe dzina lake lantchito limayamba. Mukamawerengera, timaganiziranso malo. Kalata "H", yomwe dzina la wogwira ntchito wa Nikolaev limayamba, ndiye chizindikiro cha khumi ndi chisanu. Chifukwa chake m'munda, takhazikitsa chiwerengero "15".

   Mu "chiwerengero cha zizindikiritso", muyenera kunena kuchuluka kwa zilembo zomwe dzina limakhala. Ili ndi zilembo zisanu ndi zitatu. Koma mwapatsidwa kuti pambuyo pa dzina lake, palibenso zilembo m'chipindacho, titha kuwonetsa kuchuluka kwakukulu kwa otchulidwa. Zimenezo zili choncho, mutha kuyika nambala iliyonse yomwe ili yofanana kapena yochulukirapo isanu ndi itatu. Timalankhula mwachitsanzo, chiwerengerocho "10" 10 ". Koma ngati itatha, ikhala mawu ambiri, manambala kapena otchulidwa ena mu khungu, ndiye kuti tiyenera kukhazikitsa kuchuluka kwa zizindikiro ("8").

   Pambuyo pa zonse zomwe zalembedwa, dinani batani la "OK".



4. Monga tikuwonera, zitachitika izi, dzina la wogwira ntchitoyo lidawonetsedwa pachitsanzo 1 chotchulidwa mu gawo loyamba.

Phunziro: Mwini ntchito ku Excel

Chitsanzo 2: Kuyambitsa Gulu

Koma, zoona, pa zolinga ndizosavuta kuyendetsa galimoto imodzi kuposa kulembetsa formula iyi. Koma kusamutsa gulu la data, kugwiritsa ntchito ntchito kudzakhala koyenera.

Tili ndi mndandanda wamafoni. Chisanachitike dzina lililonse ndi mawu oti "smartphone". Tiyenera kupanga mzere wosiyana ndi mayina a zitsanzo popanda mawu awa.

1. Tikuwonetsa chinthu choyambirira cha chopanda kanthu cha chotsatira chomwe chidzawonetsedwa, ndikuyimbira foni zenera la PSSR chimodzimodzi monga momwe zidaliri.

   Mu "gawo la" limatchulapo adilesi ya gawo loyamba la mzere ndi gwero.

   Mu "gawo loyambira", tiyenera kunena kuti nambala yoyambira kuchokera pomwe deta idzatengedwanso. Kwa ife, mu khungu lililonse musanatchule mtunduwo, mawu oti "smartphone" ndi danga. Chifukwa chake, mawu omwe akuyenera kubweretsedwa mu foni yosiyana kulikonse kumayamba kuchokera ku zilembo khumi. Ikani nambala ya "10" mu gawo ili.

   Mu "chiwerengero cha zizindikiritso", muyenera kukhazikitsa chiwerengero chomwe chili ndi mawu otuluka. Monga tikuwona, m'dzina la mtundu uliwonse, ambiri otchulidwa. Koma zinthu zimapulumutsa mfundo yoti pambuyo pa dzina la mtunduwo, lembalo m'maselo limatha. Chifukwa chake, titha kukhazikitsa nambala iliyonse mu gawo ili lomwe ndilofanana kapena kuposa kuchuluka kwa zilembo zomwe zili mndandandandawo mndandanda uno. Timakhazikitsa zizindikiro za "50". Dzinalo Palibe mwa ma extphones omwe sanadulidwewo sakupitilira zilembo 50, ndiye kuti njira yotsimikizikayo ili yoyenera kwa ife.

   Pambuyo pa zomwe zalembedwazo zitatha, dinani batani la "OK".



2. Pambuyo pake, dzina la mtundu woyamba wa Smartphone limawonetsedwa mu khungu lokonzedweratu la tebulo.



3. Pofuna kuti musalowe mu cell selo iliyonse pa selo iliyonse payokha, zimapangitsa kuti ziwonekere podzaza chizindikiro. Kuti muchite izi, ikani cholozera ku ngoma yakumanja kwa cell ndi mawonekedwe. Cursor amasinthidwa kukhala chizindikiro chodzaza ndi mtanda wamng'ono. Dinani batani lakumanzere ndikukoka mpaka kumapeto kwa mzati.



4. Monga mukuwonera, mzati wonse wofuna utadzazidwa ndi zomwe tikufuna. Chinsinsi chake ndichakuti, mawu oti "mawu akuti" ndi ophunzirira maselo a zomwe akufuna kusinthanso.



5. Koma vuto ndilakuti ngati tasankha kusintha mwadzidzidzi kapena kuchotsa mzere wokhala ndi data yoyambirira, ndiye kuti deta yomwe ikuwoneka molakwika, chifukwa zimalumikizidwa ndi mtundu wina uliwonse.

   

   Kuti "kumasula" zotsatira kuyambira mzere woyamba, kupanga zoterezi. Sankhani mzere womwe uli ndi formula. Kenako, pitani ku "kunyumba" ndikudina chithunzi cha "kope", komwe kuli "Buffer" pa tepi.

   

   Monga chochita china, mutha kutsitsa ctrl + c kic cource pambuyo posankha.

6. Kenako, popanda kuchotsa kusankha, dinani pagombe ndi mbewa yoyenera. Mndandanda wa nkhaniyo umatseguka. Mu "nenani magawo" block, dinani pa chithunzi cha "mtengo".



7. Pambuyo pake, m'malo mwa njira, mfundo zimayikidwa mu mzere wosankhidwa. Tsopano mutha kusintha kapena kuchotsa gwero lamphamvu popanda mantha. Sizikhudza zotsatira zake.

Chitsanzo 3: Kugwiritsa ntchito kuphatikiza kwa ogwiritsa ntchito

Komabe, chitsanzo pamwambapa chimangodziwa kuti mawu oyamba mu ma cell onse akuyenera kukhala ndi zilembo zofanana. Gwiritsani ntchito limodzi ndi ntchito ya ogwiritsa ntchito a PSTR, kusaka kapena kupeza kumakupatsani mwayi wokulitsa mwayi wogwiritsa ntchito njirayi.

Ogwiritsa ntchito ogwiritsa ntchito amasaka ndikupezanso malo omwe ali pachiwonetsero chomwe chimawonedwa.

Syntax Caving Prost:

= Kusaka (kufuna_xt; zolemba_poe; koyambirira_ komwe

Syntax ya wothandizirayo imawoneka kuti:

= Pezani (kufuna_); amawonedwa_TTet; Nach_ostis)

Kupitilira ndi lalikulu, malingaliro a ntchito ziwirizi ndi ofanana. Kusiyana kwawo ndikuti wochita kusaka panthawi yokonza deta saganizira zilembo zolembetsa, ndikupeza kuti zikugwirizana.

Tiyeni tiwone momwe mungagwiritsire ntchito ntchito yosaka mgwirizano ndi ntchito ya PTS. Tili ndi tebulo lomwe mayina a mitundu yosiyanasiyana ya zida zamakompyuta ndi dzina lakale lalembedwa. Monga nthawi yotsiriza, tiyenera kuchotsa dzina la mitundu popanda dzina lodziwika. Zovuta zake ndizakuti ngati m'mbuyomu, dzina lodziwika bwino la maudindo onse linali lofanana ("Smartphone"), ndiye kuti mu mndandanda wamasiku ano), "kuwunikira", "ndi zina) manambala osiyanasiyana a zilembo. Kuti athane ndi vutoli, tifunikira wogwiritsa ntchito, zomwe tikhala mu PSSS ntchito.

1. Timapanga kusankha kwa khungu loyamba la khola lomwe lomwe lidzawonetsedwa, komanso njira yodziwika kale, itanani zenera la PTS.

   Mu "gawo la", mwachizolowezi, tengani khungu loyamba la mzati ndi gwero. Chilichonse sichisintha apa.



2. Koma mtengo wa "malo oyambira" adzakhazikitsa mkangano womwe umapanga ntchito yosakira. Monga mukuwonera, zonse zomwe zili mundandanda zimaphatikiza kuti dzina lachitsanzo lisanakhale malo. Chifukwa chake, wofufuza wosaka adzasaka kusiyana koyamba mu gwero ndikufotokozera kuchuluka kwa chizindikiro cha PTS.

   Kuti mutsegule zenera la wothandizirayo, khazikitsani cholozera mu "gawo loyambira". Kenako, dinani pa chithunzi mu mawonekedwe a makona atatu otsogozedwa ndi ngodya. Chizindikiro ichi chimapezeka pazenera lomwelo, komwe "intern Apple" ili ndi chingwe, koma kumanzere kwa iwo. Mndandanda wa ogwiritsa ntchito aposachedwa amagwiritsidwa ntchito. Popeza pakati pawo palibe dzina "Sakani", kenako dinani chinthucho "ntchito zina ...".



3. Mtsogoleri wa ntchito ya neizard. Mu gulu la "Lemberani dzina la" Sakani "ndikudina batani la" Ok ".



4. Kusaka kwa Windows kutsutsana kumayamba. Popeza tikuyang'ana danga, ndiye kuthengo "mawu a sukulu" Ikani malowo, ndikukhazikitsa cholozera ndikukanikiza kiyi yoyenera pa kiyibodi.

   Mu "zolemba kuti mufufuze" gawo, tchulani ulalo wa selo loyambirira la gwero la gwero la gwero. Ulalo uwu udzakhala wofanana ndi womwe tidawonetsa m'munda wa "mawu" pawindo la PSTR.

   Mfundo ya "malo oyambira" siyofunika kudzaza. Kwa ife, sizifunikira kudzazidwa kapena kuyika nambala "1" 1 ". Ndi zina mwazosankhazi, kusaka kudzachitika kuyambira pachiyambi cha lembalo.

   Pambuyo pa zomwe zalembedwazo zitatha, musathamangire batani la "Ok", popeza ntchito yosaka imayesedwa. Ingodinani dzina la PSTR mu formula.



5. Nditamaliza kuchitapo kanthu komaliza, timangobwereranso ku zotsutsana za wochita zotsutsana za Psr. Monga mukuwonera, "malo oyambira" adadzazidwa kale ndi njira yosakira. Koma njirayi imaloza kumbali, ndipo tikufuna chizindikiro chotsatira pambuyo pa malo osungira, pomwe dzina lachitsanzo limayamba. Chifukwa chake, ku malo omwe alipo mu gawo la "Poyambira", timawonjezera mawu akuti "+1" popanda mawu.

   Mu "ziwerengero za zizindikiro" munda, monga momwe zalembedwera, lembani nambala iliyonse yomwe ili yayikulu kuposa kapena yofanana ndi nambala ya otchulidwa pamtundu wankhani. Mwachitsanzo, timakhazikitsa nambala "50". Kwa ife, izi ndizokwanira.

   Pambuyo pochita zonsezi, kanikizani batani la "OK" pansi pazenera.



6. Monga tikuonera, zitachitika izi, dzina la chipangizocho linawonetsedwa mu chipinda chosiyana.



7. Tsopano, pogwiritsa ntchito wizard yodzaza, monga momwe yapita kale, kopetsani formula maselo, omwe ali pansipa.



8. Mayina a mitundu yonse ya zida amawonetsedwa m'maselo aja. Tsopano, ngati kuli kotheka, mutha kuthyola ulalo mu zinthu izi ndi gwero lazomwe, monga nthawi yapita, ndikugwiritsanso ntchito kukopera ndikuyika mfundo. Komabe, zomwe zafotokozedwazo sizikuvomerezeka nthawi zonse.

Ntchito yopezeka imagwiritsidwa ntchito limodzi ndi njira yam'mbuyomu, monga mfundo yomweyo monga woyang'anira wosaka.

Monga mukuwonera, ntchito ya pstr ndi chida chosavuta kwambiri chosinthira deta yomwe mukufuna kukhala selo lokonzedweratu. Popeza kuti si wotchuka pakati pa ogwiritsa ntchito amafotokozedwa chifukwa choti ogwiritsa ntchito ambiri omwe amagwiritsa ntchito Excel amasamalira kwambiri masamu, osati zolemba. Mukamagwiritsa ntchito njirayi, kuphatikiza ndi ogwiritsa ntchito ena, magwiridwe antchito amawonjezeka kwambiri.