Enye yezinto ezithokozisayo zeMicrosoft Excel umsebenzi QHAFA. Umsebenzi wawo omkhulu ukuhlanganisa okuqukethwe ngamaseli amabili noma amaningi kukodwa. Lo opharetha usiza ukuxazulula izinkinga ezithile ezingeke zisetshenziswe kusetshenziswa amanye amathuluzi. Isibonelo, ngosizo lwayo kuyinto elula ukwenza inqubo yokuhlanganisa amaseli ngaphandle kokulahleka. Bheka izici zalo msebenzi kanye nama-nuances wokusebenza kwawo.
Isebenzisa opharetha we-CLICK
Umsebenzi QHAFA kubhekiswa eqenjini lezitatimende zombhalo we-Excel. Umsebenzi wawo omkhulu ukuhlanganisa esitokisini esisodwa okuqukethwe amaseli amaningana, kanye nezinhlamvu ngazinye. Kusukela ku-Excel 2016, umsebenzi uyasetshenziswa esikhundleni salokhu ku-opharetha I-SCEP. Kepha ukuze kugcinwe ukuhambisana okubuyela emuva, opharetha QHAFA futhi kwesokunxele, futhi ingasetshenziswa kanye I-SCEP.
I-syntax yalesi sitatimende imi kanje:
= I-CONNECT (umbhalo1; umbhalo2; ...)
Izimpikiswano zingaba zombili imibhalo nezixhumanisi kumaseli aqukethe. Inani lokuphikisana lingahluka kusuka koku-1 kuye kwangama-255.
Indlela yoku-1: hlanganisa idatha kumaseli
Njengoba wazi, inhlanganisela ejwayelekile yamaseli ku-Excel iholela ekulahlekelweni kwedatha. Imininingwane kuphela etholakala entweni ephezulu kwesobunxele igcinwa. Ukuze uhlanganise okuqukethwe amaseli amabili noma ngaphezulu ku-Excel ngaphandle kokulahleka, ungasebenzisa umsebenzi QHAFA.
- Khetha iseli esihlela ukubeka kuyo imininingwane ehlanganisiwe. Chofoza inkinobho "Faka umsebenzi". Inesimo sesithonjana futhi itholakala kwesokunxele komugqa wamafomula.
- Iyavula Isici Wizard. Esigabeni "Umbhalo" noma "Uhlu oluphelele lwe-alfabhethi" ngifuna opharetha Xhuma. Khetha leli gama bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. Ukuphikisana kungaba izinkomba kumaseli aqukethe idatha noma umbhalo ohlukile. Uma umsebenzi ufaka ukuhlanganisa okuqukethwe amaseli, khona-ke kulokhu sizosebenza ngezixhumanisi kuphela.
Setha isikhombisi emkhakheni wokuqala wewindi. Bese ukhetha ukuxhumana ekhasini, eliqukethe idatha edingekayo yenyunyana. Ngemuva kokuthi izixhumanisi ziboniswe ewindini, senza okufanayo ngensimu yesibili. Ngokuvumelana nalokho, khetha esinye iseli. Senza umsebenzi ofanayo kuze kube lapho izixhumanisi zawo wonke amaseli adinga ukuhlanganiswa efakiwe kuwindi lokuphikisana lomsebenzi. Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, okuqukethwe kwezindawo ezikhethiwe kwaboniswa kuseli elilodwa elalichaziwe ngaphambili. Kepha le ndlela ine -backback ebalulekile. Lapho uyisebenzisa, lokho okubizwa nge- “bonding seamless bonding” kwenzeka. Okusho ukuthi, asikho isikhala phakathi kwamagama futhi afakwa kuhlu olulodwa. Kulokhu, ukufaka ngesandla isikhala ngeke kusebenze, kodwa kuphela ngokuhlela ifomula.
Isifundo: Umsebenzi Wizard e-Excel
Indlela 2: ukusebenzisa umsebenzi onendawo
Kunamathuba wokulungisa le nkinga ngokufaka izikhala phakathi kwezimpikiswano zo-opharetha.
- Senza umsebenzi sisebenzisa i-algorithm efanayo njengoba kuchaziwe ngenhla.
- Qhafaza kabili inkinobho yegundane kwesokunxele esitokisini ngefomula bese uyisebenzisa ukuze ihlelwe.
- Phakathi kwengxabano ngayinye, bhala isisho ngesimo sendawo, esiboshwe ngazo zombili izinhlangothi ngamaphuzu wokucaphuna. Ngemuva kokufaka inani ngalinye elinjalo, faka i-semicolon. Ukubuka okujwayelekile kwezinkulumo ezingeziwe kufanele kube ngale ndlela elandelayo:
" "; - Ukuze ubonise umphumela esikrinini, chofoza inkinobho Ngena.
Njengoba ubona, endaweni yokufakwa kwezikhala ngezingcaphuno esitokisini, kwavela ukuhlukana phakathi kwamagama.
Indlela 3: engeza isikhala ngewindi lokuphikisana
Vele, uma kungekho amanani amaningi aguquliwe, inketho engenhla yokuqhekeza i-gluing ndawonye iphelele. Kepha kuzoba nzima ukuyisebenzisa masishane uma kunamaseli amaningi adinga ukuhlanganiswa. Ikakhulu uma la maseli engekho kuhlu olulodwa. Yenza lula ukubekwa kwesikhala ngokubalulekile, ungasebenzisa inketho ukusifaka ngewindi lokuphikisana.
- Qhafaza kabili inkinobho yegundane kwesobunxele kunoma iyiphi iseli engenalutho eshidini. Usebenzisa ikhibhodi, setha isikhala ngaphakathi kwayo. Kungcono ukuyigcina kude ne-array main. Kubaluleke kakhulu ukuthi le seli ayikaze igcwale noma iyiphi idatha ngemuva kwalokhu.
- Senza isenzo esifanayo nasendleleni yokuqala yokusebenzisa umsebenzi QHAFA, kuze kube kuvulwa iwindi lokuphikisana komuntu. Ngeza inani leseli yokuqala nedatha enkundleni yezwindi, njengoba yayivele ichazwa ngaphambilini. Ngemuva kwalokho sibeka isikhombisi emkhakheni wesibili, bese sikhetha iseli elingenalutho elinendawo, okwaxoxwa ngalo phambilini. Isixhumanisi siyavela enkanjini yebhokisi lokuphikisana. Ukusheshisa inqubo, ungayikopisha ngokugqamisa nokucindezela inhlanganisela yokhiye I-Ctrl + C.
- Ngemuva kwalokho singeza isixhumanisi sento elandelayo esizoyengeza. Ensimini elandelayo, engeza isixhumanisi kuseli engenalutho futhi. Njengoba sikopishe ikheli lakhe, singabeka isikhombisi ensimini bese sicindezela inhlanganisela yokhiye I-Ctrl + V. Ama-Coordinates azofakwa. Ngale ndlela, saguqula izinkambu ngamakheli wezinto nezinto zeseli ezingenalutho. Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".
Njengoba ubona, emva kwalokho, kwakhiwa irekhodi elihlanganisiwe esitokisini okuhlosiwe, kufaka phakathi okuqukethwe yizo zonke izinto, kodwa ngezikhala phakathi kwegama ngalinye.
Ukunaka! Njengoba ukwazi ukubona, le ndlela engenhla isheshisa ngokushesha inqubo yokuhlanganisa idatha kumaseli. Kepha kufanele kwaziwe ukuthi le ndlela igcwele izingibe. Kubaluleke kakhulu ukuthi entweni equkethe isikhala, ngokuhamba kwesikhathi idatha ethile ingaveli noma ingashintshiwe.
Indlela 4: hlanganisa amakholomu
Kusetshenziswa umsebenzi QHAFA Ungahlanganisa ngokushesha idatha yamakholomu ambalwa abe yinye.
- Ngamaseli womugqa wokuqala wamakholomu ahlanganisiwe, sikhetha isenzo esikhonjiswe ezindleleni zesibili nezesithathu zokusebenzisa impikiswano. Kodwa-ke, uma uthatha isinqumo sokusebenzisa indlela ngeseli elingenalutho, ukuxhumeka kuyona kuzodinga ukwenziwa ngokuphelele. Ukuze wenze lokhu, beka uphawu lwedola phambi kophawu ngalunye oluqondile nolumi mpela lwalesi seli ($). Njengokulindelekile, kungcono ukukwenza lokhu ekuqaleni, ukuze kwezinye izinkambu lapho leli kheli litholakala khona, umsebenzisi angalikopisha njengoba liqukethe izixhumanisi ezingapheli. Emasimini asele, shiya izixhumanisi. Njengokuhlala njalo, ngemuva kwenqubo, chofoza inkinobho "Kulungile".
- Sifaka ikhesa ekhoneni elingezansi kwesokudla sento ngefomula. Kuvela isithonjana esibukeka njengesiphambano, esibizwa ngokuthi umaka wokugcwalisa. Bamba inkinobho yegundane kwesobunxele bese uyihudula phansi ngokufana nendawo yezakhi ezizohlanganiswa.
- Ngemuva kokuphothula le nqubo, imininingwane ekumakholamu echaziwe izohlanganiswa.
Isifundo: Ungawahlanganisa kanjani amakholomu e-Excel
Indlela yesi-5: engeza izinhlamvu ezingeziwe
Umsebenzi QHAFA futhi singasetshenziswa ukwengeza izinhlamvu ezingeziwe nezinkulumo ezazingekho kububanzi bangempela bokuhlanganyela. Ngaphezu kwalokho, ungakwazi ukusebenzisa abanye opharetha usebenzisa lo msebenzi.
- Senza isenzo ukwengeza amanani kuwindi wokuphikisana komsebenzi sisebenzisa noma yiziphi izindlela ezichazwe ngenhla. Kwenye yezinkambu (uma kunesidingo, kungahle kube nezimbalwa) engeza noma imaphi umbhalo obonwa kufanelekile ukukungeza. Lo mbhalo kumele uvalelwe kumaki wesilinganiso. Chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, ngemuva kwalesi senzo, imibhalo yombhalo yengezwe kudatha ehlanganisiwe.
Umsebenzi QHAFA - Ukuphela kwendlela yokuhlanganisa amaseli angenabala ku-Excel. Ngaphezu kwalokho, singasetshenziswa ukujoyina amakholomu wonke, engeza amanani wombhalo, futhi senze okunye ukukhohlisa. Ukwazi kwe-algorithm yokusebenza nalo msebenzi kuzokwenza kube lula ukuxazulula izinkinga eziningi kumsebenzisi wohlelo.
