Ukusebenzisa umsebenzi we-CLICK ku-Microsoft Excel

Esinye sezici ezithakazelisayo ze-Microsoft Excel ngumsebenzi Ukudonsa. Umsebenzi walo oyinhloko ukuhlanganisa okuqukethwe kwamaseli amabili noma amaningana munye. Lo opharetha usiza ukuxazulula ezinye izinkinga ezingenakwenzeka ngosizo lwamanye amathuluzi. Isibonelo, ngosizo lwaso kulula ukukwenza inqubo yokuhlanganisa amangqamuzana ngaphandle kokulahlekelwa. Cabanga ngamakhono alo msebenzi kanye nama-nuances esicelo sakho.

Ukusetshenziswa komqhubi we-CLUTCH

Umsebenzi Ukudonsa kungokwaqembu labasebenzi be-Excel. Umsebenzi walo oyinhloko ukuhlanganisa okuqukethwe kwamaseli amaningana kanye nezinhlamvu ngabanye esitokisini esisodwa. Ukuqala nge-Excel 2016, esikhundleni salolu opharetha, umsebenzi usetshenziswa. STEP. Kodwa ukuze ugcine u-opharetha ohambelana nokubuyela emuva Ukudonsa futhi ishiye, futhi ingasetshenziswa kanye STEP.

I-syntax yale statement is kanje:

= CLUTCH (umbhalo1; umbhalo2; ...)

Amaphuzu angaba umbhalo noma izinkomba kumaseli aqukethe. Inombolo yezimpikiswano ingahluka kusuka ku-1 kuya ku-255 ehlanganisiwe.

Indlela 1: Hlanganisa imininingwane yeselula

Njengoba wazi, inhlangano evamile yamaseli ku-Excel iholela ekulahlekelweni kwedatha. Idatha kuphela etholakala engxenyeni engenhla kwesokunxele igcinwa. Ukuze uhlanganise okuqukethwe kwamaseli amabili noma ngaphezulu ku-Excel ngaphandle kokulahlekelwa, ungasebenzisa umsebenzi Ukudonsa.

1. Khetha iseli esilungiselela ukubeka idatha ehlangene. Chofoza inkinobho "Faka umsebenzi". Inokubuka kwesithonjana futhi itholakala ngakwesokunxele kwibha yefomula.



2. Ivula Umsebenzi weWebhu. Esikhathini "Umbhalo" noma "Uhlu oluphelele lwe-alfabhethi" ngifuna opharetha "CLICK". Khetha leli gama bese uchofoza inkinobho. "Kulungile".



3. Iwindi lempikiswano yokusebenza iqalisiwe. Izimpikiswano zingaba yizigcawu zeseli eziqukethe idatha noma umbhalo ohlukile. Uma umsebenzi ukuhlanganisa okuqukethwe kwamaseli, khona-ke kulokhu sizosebenza kuphela nezixhumanisi.

   Setha isikhombisi ensimini yokuqala yewindi. Bese ukhetha isixhumanisi eshadini equkethe idatha edingekayo yunyunyana. Ngemuva kokuthi izixhumanisi ziboniswa efasiteleni, siqhubeka ngendlela efanayo ngensimu yesibili. Ngakho-ke, khetha enye iseli. Senza umsebenzi ofanayo kuze kube yilapho izixhumanisi zazo zonke amaseli ezidinga ukuhlanganiswa zingena efasiteleni lokuphikisana lomsebenzi. Emva kwalokho, chofoza inkinobho "Kulungile".



4. Njengoba ungabona, okuqukethwe ezindaweni ezikhethiwe kubonakala kuseli elilodwa elichazwe ngaphambili. Kodwa le ndlela ine-drawback enkulu. Uma isetshenziswe, okuthiwa "ukugcoba okunamandla" kwenzeka. Okungukuthi, akukho sikhala phakathi kwamazwi futhi ahlanganiswe ndawonye endaweni eyodwa. Kulesi simo, ukwengeza ngesandla isikhala ngeke kusebenze, kodwa kuphela ngokuhlela ifomula.

Isifundo: I-Excel Function Wizard

Indlela 2: sebenzisa umsebenzi ngesikhala

Kunamathuba okulungisa lesi siphene ngokufaka izikhala phakathi kwama-opharetha opharetha.

1. Yenza lo msebenzi ngokuvumelana ne-algorithm efanayo njengoba kuchazwe ngenhla.
2. Chofoza kabili inkinobho yegundane lesokunxele efomini lefomula bese ulisebenze ukuze uhlele.



3. Phakathi kwempikiswano ngayinye sibhala inkulumo ngesimo sesikhala, siboshwe ezinhlangothini zombili ngamacaphuno. Ngemuva kokungeza inani ngalinye elinjalo, sibeka i-semicolon. Umbono jikelele wezinkulumo ezengeziwe kufanele kube kanje:

   " ";



4. Ukuze ubonise umphumela esikrinini, chofoza inkinobho. Ngena.

Njengoba ubona, endaweni yokufaka izikhala ngezikhalazo esitokisini, kukhona ukuhlukana phakathi kwamazwi.

Indlela 3: engeza isikhala ngokusebenzisa iwindi lempikiswano

Yiqiniso, uma kungekho amanani amaningi okuguquguquka, inguqulo engenhla yegebe lokugcoba iphelele. Kodwa kuyoba nzima ukuhumusha ngokushesha uma kunamaseli amaningi adinga ukuhlanganiswa. Ikakhulukazi, uma lawa maseli engekho ohlwini olulodwa. Ungakwazi kalula ukwenza lula ukubeka isikhala ngokusebenzisa inketho ukuyifaka ngokusebenzisa iwindi lempikiswano.

1. Chofoza kabili inkinobho yegundane lesokunxele ukuze ukhethe noma yiliphi iseli elingenalutho kushidi. Ukusebenzisa ikhibhodi ukubeka isikhala ngaphakathi kwayo. Kuyinto efiselekayo ukuthi wayengekho ohlwini oluyinhloko. Kubalulekile ukuthi le seli lingakaze ligcwaliswe nanoma iyiphi idatha emva kwalokho.



2. Yenza izinyathelo ezifanayo njengendlela yokuqala yokusebenzisa umsebenzi. Ukudonsa, kuze kuvule iwindi yokuphikisana yomqhubi. Engeza inani leseli yokuqala nedatha emkhakheni wewindi, njengoba kuchaziwe ekuqaleni. Bese usetha isikhombisi ensimini yesibili, bese ukhetha iseli elingenalutho ngesikhala, esixoxwe ngaphambili. Isixhumanisi sivela ensimini ye-argument box. Ukusheshisa inqubo, ungakwazi ukuyikopisha ngokukhetha nokucindezela inhlanganisela yokhiye Ctrl + C.



3. Bese ungeza isixhumanisi entweni elandelayo ongayengeza. Esikhathini esilandelayo, faka futhi isixhumanisi esitokisini esingenalutho. Njengoba sinekopishe ikheli layo, ungasetha isikhangiso endle bese ucindezela inhlanganisela yokhiye Ctrl + V. Ukuqondisa kuzofakwa. Ngalendlela sidlulisela amasimu ngamakheli ezakhi kanye namaseli angenalutho. Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".

Njengoba ungabona, emva kwalokhu, irekhodi elihlanganisiwe lakhiwa esitokisini esilitshe, okufaka okuqukethwe kuzo zonke izakhi, kodwa ngezikhala phakathi kwegama ngalinye.

Qaphela! Njengoba ungabona, indlela engenhla iqhubekela phambili ngokuphumelelayo ngenqubo yokuhlanganisa ngokuqondile idatha kumaseli. Kodwa kufanele kuqashelwe ukuthi le nketho igcwele "imfucumfucu". Kubaluleke kakhulu ukuthi kulesi sici esinekhala, ngokuhamba kwesikhathi idatha ethile ayiveli noma ayishintshi.

Indlela 4: Ikholomu Ukuhlanganisa

Ukusebenzisa lo msebenzi Ukudonsa Ungakwazi ukuhlanganisa ngokushesha idatha kusuka kumakholomu amaningi ube munye.

1. Ngamaseli womugqa wokuqala wekholomu ehlanganisiwe, senza ukhetho lwezenzo ezichazwe ngezindlela zesibili nezesithathu zokusebenzisa ukuphikisana. Kuyiqiniso, uma unquma ukusebenzisa le ndlela ngeseli elingenalutho, khona-ke isixhumanisi kuso kuyodingeka senziwe ngokuphelele. Ukuze senze lokhu, sibeka isibonakaliso se-dollar phambi kwe-coordination ngayinye yokuxhumanisa ngokuzenzekelayo nangaphandle kwalesi sisele. ($). Ngokwemvelo, kungcono ukwenza lokhu ekuqaleni, ukuze umsebenzisi akwazi ukukukopisha kwezinye izindawo eziqukethe leli kheli, njengoba liqukethe izixhumanisi ezihlala njalo. Emasimini asele ashiye izixhumanisi ezihlobene. Njengoba njalo, ngemuva kokusebenzisa inqubo, chofoza inkinobho. "Kulungile".



2. Setha isikhombisi ekhoneni elingezansi elingakwesokudla se-element ngefomula. Isithonjana sibonakala ngesimo sesiphambano, esibizwa ngokuthi uphawu lokugcwalisa. Bamba inkinobho yegundane ngakwesokunxele bese uyidonsa phansi ngokuhambisana nelungiselelo lezici ezizohlanganiswa.



3. Ngemva kokwenza le nqubo, idatha kumakholomu akhethiwe izohlanganiswa kukholomu eyodwa.

Isifundo: Ungahlanganisa kanjani amakholomu ku-Excel

Indlela 5: engeza abalingiswa abengeziwe

Umsebenzi Ukudonsa ingasetshenziswa futhi ukwengeza izinhlamvu ezengeziwe nezinkulumo ezazingekho ebangeni lobuhlanganisi bokuqala. Ngaphezu kwalokho, usebenzisa lo msebenzi, ungashumeka amanye ama-opharetha.

1. Yenza izinyathelo zokwengeza amanani efenjini lokuphikisana lomsebenzi usebenzisa noma iyiphi yezindlela ezichazwe ngenhla. Kweminye yamasimu (uma kunesidingo, kungenzeka kube neziningana zazo) sengeza noma yikuphi okuqukethwe kombhalo umsebenzisi okubheka okudingekayo ukwengeza. Le mibhalo kumele ifakwe emacaphuni. Sicindezela inkinobho "Kulungile".



2. Njengoba ubona, ngemuva kwalesi senzo, izinto zombhalo zengeziwe kudatha ehlanganisiwe.

I-Operator Ukudonsa - indlela kuphela yokuhlanganisa amaseli ngaphandle kokulahlekelwa ku-Excel. Ngaphezu kwalokho, ingasetshenziswa ukuxhuma wonke amakholomu, engeza izindinganiso zombhalo, wenze ezinye izindlela zokusebenzisa. Ulwazi lwe-algorithm yokusebenza nalo msebenzi kuzokwenza kube lula kubasebenzisi abaningi ukuxazulula izinkinga eziningi.