PracMMM basa muExcel

Pakati pemabasa akasiyana-siyana muExcel, yakagadzirirwa kushanda nerugwaro, mushandi anogoverwa neye pracemir operator. Basa rayo ndere kuburitsa kubva sero rakataurwa reiyo nhamba yakatarwa yeavo mavara, kuverenga kubva kumagumo. Ngatidzidzei zvakawanda nezve mikana yeiyi opareta uye pane iyo nuances yekuishandisa nekuda kwezvinangwa zvakanaka pamienzaniso chaiyo.

Operator Pratseim

Iyo yekurudyi-yeruoko basa inobvisa kubva pane yakataurwa pane pepa, nhamba yeavo mavara kurudyi, iyo mushandisi pachayo icharatidzwa. Inoratidza mhedzisiro yekupedzisira muchitokisi ichocho, ipo pacho pacho. Iyi ficha inoreva chinyorwa chemavara evashandi vekare. Yayo syntax iri seinotevera:

= Precemir (zvinyorwa; nhamba_names)

Sezvatinoona, basa racho rinongova nemakirogiramu maviri chete. Chekutanga chavo "zvinyorwa" chinogona kutora fomu rezvese zvekutaura pachavo uye revo yezvinhu zvasara mairi. Muchiitiko chekutanga, mushandi anobvisa nhamba yakataurwa yemavara kubva pane zvinyorwa zvemavara zvakataurwa mune fomu yekupokana. Mune yechipiri nyaya, basa racho richazokupa "mavara kubva mune zvinyorwa zviri muchitokisi chakataurwa.

Iyo yechipiri kukakavara ndeye "nhamba yezviratidzo" - kukosha kwenhamba inoratidza iyo nhamba yevatambi mukutaura kwemavara, kuverenga kurudyi, iwe unofanirwa kuratidza muchitokisi chakanangwa. Uku kupopotedzana hakusi kwekumanikidzwa. Kana ikasiyiwa, inotendwa kuti yakaenzana neyakaenzana neyakaenzana, ndiko kuti, chete pane chimiro chakarurama chechinhu chakataurwa chinoratidzwa muchitokisi.

Muenzaniso Kushandisa

Zvino ngatitarisei kushandiswa kweiyo chaiyo-ruoko basa pane chaiyo muenzaniso.

Semuenzaniso, tora runyorwa rwevashandi vebhizinesi. Muchikamu chekutanga chetafura iyi kune mazita emhuri pamwe nenhamba dzefoni. Isu tinoda nhamba idzi tichishandisa iyo Russeem inoshanda yekubvisa imwe ikhoramu, iyo inonzi "nhamba yefoni".

1. Isu tinosimbisa iyo yekutanga sero risina chinhu ye "foni nhamba" ikhoramu. Dzvanya pane iyo "Insert basa" icon, iyo inoiswa kuruboshwe kwetambo ye formula.



2. Iyo inoshanda wizard hwindo rakamiswa. Enda kune chikamu "zvinyorwa". Kubva muzita rerondedzero yemazita, tinogovera zita rekuti "pracom". Isu tinodzvanya pane "OK" bhatani.



3. Nharo dzemushandi dzePracemm Offerator dzinovhura. Iyo ine minda miviri inoenderana nekukakavara kweiyo yakatarwa basa. Mu "zvinyorwa", iwe unofanirwa kutaura chirevo che "zita" column cell, iyo ine zita remushandi uye nhamba yefoni. Kero iyi inogona kuongororwa, asi isu tichaita zvakasiyana. Isa iyo inotuka mu "zvinyorwa" zvemavara, uye wobva wadzvanya bhatani rekuruboshwe mbeva pamwe neCell Inosangana nemabatiro. Mushure meizvozvo, kero inoratidzwa muhwindo rekupokana.

   Mu "nhamba yezviratidzo" munda, tinopinda iyo nhamba "5" kubva kukhibhodi. Izvo zvinobva kune mashanu mavara ayo nhamba yefoni yemushandi wega wega anosanganisira. Mukuwedzera, nhamba dzese dzenhare dzave kumagumo emasero. Naizvozvo, kuti uvaunze ivo zvakasiyana, isu tinofanirwa kubvisa mavara mashanu kubva pamasero aya kurudyi.

   Mushure meiyo data iri pamusoro apa, tinya pane "OK" bhatani.



4. Mushure mekuita uku, nhamba yefoni yemushandi yakataurwa inobviswa muchitokisi chisingasarudzwa. Ehezve, isa fomu rakatsanangurwa zvakasiyana kune mumwe nemumwe mune rondedzero chidzidzo chakareba kwazvo, asi iwe unogona kukurumidza, uchireva. Kuti tiite izvi, tinoisa iyo kona yekurudyi kona yekurudyi yechitokisi, iyo yatove neiyo formula ye pracom. Mune ino kesi, iyo kirevhheni inoshandurwa kusvika pakuzadza mucherechedzo sechidimbu chidiki. Dzvanya bhatani rekuruboshwe mbeva uye dhonza iyo inotuka pasi kusvika kumagumo etafura.



5. Iye zvino iyo yakazara yekoramu "nhamba yefoni" inozadzwa nehunhu hunosangana kubva ku "zita" ikholamu.



6. Asi, kana isu tichiedza kubvisa nhamba dzefoni kubva ku "zita" ikhoramu, ivo vanotanga kunyangarika kubva kufoni nhamba yefoni. Izvi zvinotsanangurwa nenyaya yekuti zvese izvi makoramu zvinoenderana nefomula. Kuti ubvise ichi kubatana, govera zvese zvirimo zve "nhamba yefoni" ikholamu. Ipapo ini ndinodzvanya pane iyo "Kopa" icon, iyo iri paRibbon muTab yeTab mu "Exchange Buffer" Toolbu. Iwe unogona zvakare kufonera ctrl + c kiyi musanganiswa.



7. Tevere, pasina kubvisa kusarudzwa kubva pamusoro wepamusoro, ini ndinodzvanya pairi kurudyi mbeva bhatani. Mukati menyu yemukati mune iyo inoisa parameter boka, sarudza "kukosha" chinzvimbo.



8. Mushure meizvozvo, iyo data rese mufoni nhamba yekoramu ichazoratidzwa semavara akazvimirira, uye kwete semhedzisiro yekuverenga kweiyo formula. Zvino, kana uchida, unogona kudzima nhamba dzefoni kubva muzita remberi. Izvi hazvizokanganisa zviri mukati me "nhamba yefoni" ikholamu.

Chidzidzo: Wizard mabasa muExcel

Sezvaunogona kuona, yaaizova kuti Pracemir dzinoti rinopa chaiwo kubatsira. Nemushandi uyu, unogona kuratidza iyo yaunoda nhamba yemavara kubva pamasero akataurwa kune iyo nzvimbo yakatarwa, ichiverengera kubva kumagumo, kureva kurudyi. Iyi inoshanda ichanyanya kubatsira kana ichikosha kubvisa iyo nhamba imwechete yevatambi kubva kumagumo mune yakakura mhando yemasero. Iko kushandiswa kwefomusi mumamiriro ezvinhu akadaro kuchawedzera kuchengetedza iyo mushandisi nguva.