Ungayenza kanjani isixhumanisi ekudingisweni

Izixhumanisi zingenye yamathuluzi amakhulu lapho zisebenza ku-Microsoft Excel. Bayingxenye ebalulekile yamafomula asebenza kulolu hlelo. Ezinye zazo zisebenzela ukuya kwamanye amadokhumenti noma izinsizakusebenza kwi-Intanethi. Ake sibheke ukuthi ungazakhela kanjani izinhlobo ezahlukahlukene zokubhekisa izinkulumo ku-Efpelle.

Ukwakha izinhlobo ezahlukene zezixhumanisi

Masinyane, kufanele kuqashelwe ukuthi yonke imibhalo edlulisayo ingahlukaniswa izigaba ezimbili ezinkulu: inhlose ukubalwa njengengxenye yamafomula, imisebenzi, amanye amathuluzi nabasebenzi ukuze baye entweni ebekiwe. Okugcina kusabizwa ngokuthi ama-hyperlinks. Ngaphezu kwalokho, izixhumanisi (izixhumanisi) zihlukaniswe zangaphakathi nangaphandle. Ngaphakathi yizinkulumo ezibhekisa ngaphakathi kwencwadi. Imvamisa, basetshenziselwa ukubalwa, njengengxenye ebalulekile yefomula noma ukuphikisana komsebenzi, okubonisa into ethile lapho idatha ecutshungulwayo ikhona. Esigabeni esifanayo, ungabiza lezo ezibhekisele endaweni kwelinye ishidi ledokhumenti. Zonke, ngokuya ngezakhiwo zabo, zihlukaniswe ziyisihlobo futhi ziphelele.

Izixhumanisi zangaphandle zibhekisela entweni engaphandle kwencwadi yamanje. Kungaba enye incwadi ye-Excel noma indawo kuyo, idokhumenti yenye ifomethi ngisho nesayithi kwi-Intanethi.

Ukusuka kuhlobo luni lohlobo ofuna ukuludala, nendlela ekhethiwe yendalo kuya. Ake siyeke ngezindlela ezahlukahlukene ngemininingwane eminingi.

Indlela 1: Ukwakha izinkomba kumafomula ngaphakathi kweshidi elilodwa

Okokuqala, cabanga ukuthi ungazakha kanjani izinketho ezahlukahlukene zezinkomba zamafomula, imisebenzi namanye amathuluzi okubala we-Excel ngaphakathi kweshidi elilodwa. Ngemuva kwakho konke, bavame ukusetshenziswa kakhulu ekusebenzeni.

Isisho esilula kunazo zonke sibukeka kanjena:

= A1.

Isici esiphoqelekile senkulumo wuphawu "=". Kuphela lapho ufaka lolu phawu esitokisini ngaphambi kwenkulumo, luzobonwa njengokubhekisa. Imfanelo ebolayo futhi igama lekholomu (kulokhu a) nenombolo yekholomu (kulokhu 1).

Inkulumo ethi "= A1" iphakamisa ukuthi into efakwe kuyo, idatha evela entweni enezixhumanisi ze-A1 iyaqiniswa.

Uma singena esikhundleni senkulumo esitokisini, lapho umphumela uboniswa khona, ngokwesibonelo, ku- "= b5", amanani avela entweni aqukethe izixhumanisi B5 azoqiniswa.

Kusetshenziswa izixhumanisi, izenzo ezahlukahlukene zezibalo nazo zingenziwa. Isibonelo, sibhala phansi le nkulumo elandelayo:

= A1 + B5

Isigatshana enkombeni yokufaka. Manje, endaweni lapho le nkulumo itholakala khona, ukungqumba kwamanani abekwe ezintweni ezixhumanisa izixhumanisi A1 ne-B5 kuzokwenziwa.

Ngomgomo ofanayo, ukwahlukaniswa kwenziwa, ukuphindaphinda, ukususa kanye nanoma yisiphi esinye isenzo sezibalo.

Ukurekhoda isixhumanisi esihlukile noma njengengxenye yefomula, akudingekile ukuyixosha kude nekhibhodi. Kwanele ukufaka uphawu "=", bese ubeka inkinobho yegundane kwesobunxele lapho ufuna ukubhekisa khona. Ikheli lakhe lizokhonjiswa entweni lapho kufakwa khona uphawu "olulinganayo".

Kepha kufanele kuqashelwe ukuthi isitayela sokuxhumanisa i-A1 akusona sodwa esingasetjenziswa kumafomula. Ngokufana, i-Excel isebenza ngesitayela se-R1c1, lapho, khona, ngokungafani nenguqulo yangaphambilini, izixhumanisi zikhonjiswa ngezinhlamvu nezinombolo, kepha kuphela ngezinombolo.

Inkulumo R1C1 ilingana ne-A1, no-R5c2 - B5. Okusho ukuthi, kulokhu, ngokungafani nesitayela se-A1, izixhumanisi zomugqa zisekuqaleni, futhi ikholomu isesibili.

Zombili lezi zitayela zomthetho ku-Excel ziyalingana, kepha isilinganiselo esizenzakalelayo sokudidiyela sinefomu A1. Ukuyishintsha ekubukweni kwe-R1C1, uyadingeka kumapharamitha we-Excel kwingxenye yefomula, hlola ibhokisi lokuhlola elibhekene nento yesitayela se-R1C1 Link.

Ngemuva kwalokho, kwiphaneli evundlile, izibalo zizovela esikhundleni sezincwadi, futhi izinkulumo efomula yomugqa zizothola ifomu R1c1. Ngaphezu kwalokho, izinkulumo zilotshwe ngokwenza izixhumanisi ngesandla, futhi ngokuchofoza entweni efanele kuzokhonjiswa njengemodyuli maqondana neseli lapho ifakwe khona. Esithombeni esingezansi kungufomula

= R [2] c [-1]

Uma ubhala isisho ngesandla, khona-ke kuzothatha ukubuka okujwayelekile u-R1c1.

Esimweni sokuqala, kwathulwa uhlobo lwesihlobo (= r [2] c [-1]), nakwesibili (= R1c1) - ngokuphelele. Izixhumanisi eziphelele zibhekisela entweni ethile, kanye nesihlobo - esimweni sento, esihlobene neseli.

Uma ubuyela esitayeleni esijwayelekile, khona-ke izixhumanisi zesihlobo zinefomu le-A1, kanye ne- $ 1. Ngokuzenzakalelayo, zonke izinkomba ezenziwe ku-Excel zihlobene. Lokhu kuvezwa ngeqiniso lokuthi lapho ukopisha ngomaka wokugcwalisa, inani labo lishintsha okuhlobene nokuhamba.

1. Ukuze ubone ukuthi kuzobukeka kanjani ukuzilolonga, uluka esitokisini A1. Sifaka kunoma iyiphi into engenalutho yeqabunga uphawu "=" nodaka entweni enezixhumanisi A1. Ngemuva kokuthi ikheli liboniswe njengengxenye yefomula, ubumba enkombeni yokungena.



2. Siletha isikhombisi esimeni esingezansi kwesokudla sento, lapho umphumela wokucubungula ifomula avele khona. Isikhombisi siguqulwa sibe uphawu lokugcwaliswa. Chofoza inkinobho yegundane kwesobunxele bese welula isipoti esifana nedatha enedatha ofuna ukuyikopisha.



3. Ngemuva kokuthi ukukopishwa sekuqediwe, siyabona ukuthi amanani ezinto ezilandelanayo ezalandela ahlukile kulokho endaweni yokuqala (ekopishiwe). Uma ukhetha noma yisiphi iseli lapho sikopishe khona imininingwane, bese ku-formula varg ungabona ukuthi isixhumanisi siguquliwe esihlobene nesihlobo. Lokhu kuwuphawu lokuhlobana kwalo.

IPorativity Propaper kwesinye isikhathi isiza okuningi lapho isebenza ngamafomula namatafula, kodwa kwezinye izikhathi udinga ukukopisha ifomula ngqo engashintshiwe. Ukuze wenze lokhu, isixhumanisi siyadingeka ukuguqula sibe ngokuphelele.

1. Ukwenza ushintsho, kwanele ngokuxhumanisa ngokuvundlile nangokuthe mpo faka uphawu lwedola ($).



2. Ngemuva kokuthi sisebenzise umaki ogcwalisiwe, ungabona ukuthi inani kuwo wonke amaseli alandelayo lapho ukukopisha kukhonjiswa ngokufanayo nakulokuqala. Ngaphezu kwalokho, lapho uzulazula kunoma iyiphi into ebangeni elisezingeni eliphansi entanjeni yefomula, kungaphawulwa ukuthi izixhumanisi zihlala zingashintshi ngokuphelele.

Ngaphezu kokuphelele nesihlobo, kusenezixhumanisi ezixubile. Amamaki we-Dollar Sign noma ngabe izixhumanisi zekholamu kuphela (Isibonelo: $ A1),

kungaba kuphela izixhumanisi zentambo (isibonelo: A $ 1).

Isiginali yedola ingenziwa ngesandla ngokuchofoza uphawu olufanele kwikhibhodi ($). Kuzoqokonyiswa uma kusakhiwo sekhibhodi yesiNgisi ecaleni eliphezulu chofoza kukhiye we- "4".

Kepha kunendlela elula yokwengeza uphawu olubekiwe. Udinga nje ukugqamisa isisho sereferensi bese ucindezela ukhiye we-F4. Emva kwalokho, isibonakaliso sedola sizovela ngasikhathi sinye kuzo zonke izixhumanisi ezivundlile nangokuqondile. Ngemuva kokucindezela kabusha ku-F4, isixhumanisi siguqulwa saba ngxubelelwa: Isibonakaliso sedola siyohlala kuphela kwizixhumanisi zomugqa, futhi izixhumanisi zekholomu zizonyamalala. Okunye ukucindezela i-F4 kuzoholela emphumeleni ophambene: Isibonakaliso sedola sizovela ezixhumanisi zekholomu, kepha ukuxhumanisa komugqa kuzonyamalala. Ngaphezu kwalokho, lapho ucindezela i-F4, isixhumanisi siguqulwa sibe yisihlobo ngaphandle kwamadola. Ukucindezela okulandelayo kuguqula kube ngokuphelele. Kanjalo nombuthano omusha.

Ku-Excel, ungabhekisa hhayi kuphela kwiseli ethile, kodwa futhi nalo lonke uhla. Ikheli lobubanzi libukeka njengezixhumanisi zento engenhla yangakwesobunxele kanye nesokudla esingezansi, ehlukaniswe yisibonakaliso sekoloni (:). Isibonelo, ibanga elabiwe esithombeni esingezansi lixhumanisa i-A1: C5.

Ngokuvumelana nalokhu, isixhumanisi esikulolu hlelo sizobukeka sithi:

= A1: C5

Isifundo: Izixhumanisi eziphelele nezihlobo zeMicrosoft Excel

Indlela 2: Ukwakha izinkomba kumafomula kwamanye amashidi nezincwadi

Ngaphambi kwalapho, sabheka izenzo kuphela ngaphakathi kweshidi elilodwa. Manje ake sibheke ukuthi ungabhekisa kanjani endaweni kwelinye ishidi noma ngisho nencwadi. Endabeni yokugcina, ngeke kube ngaphakathi, kepha isixhumanisi sangaphandle.

Imigomo yendalo ifana ncamashi nalokho besibheka ngaphezulu lapho izenzo eshidi elilodwa. Kulesi simo kuphela okuzodinga ukucacisa ikheli elingeziwe leqabunga noma incwadi lapho iseli noma uhla ludingeka ukubhekisa kulo.

Ukuze ubheke inani kwelinye ishidi, udinga ukucacisa igama laso phakathi kwesibonakaliso se- "=" kanye nezixhumanisi zeseli, bese ufaka uphawu lokubekisa.

Ngakho-ke isixhumanisi esisesitokisini eshidini 2 ngezixhumanisi ze-B4 sizobukeka kanjena:

= Uhlu2! B4

Inkulumo ingaqhutshwa ngesandla kusuka kukhibhodi, kepha ilula kakhulu ukwenza okulandelayo.

1. Faka uphawu lwe- "=" entweni ezoqukatha isisho. Ngemuva kwalokho, usebenzisa isinqamuleli ngaphezulu kwebha yesimo, iya kuleyo phepha lapho into itholakala khona.



2. Ngemuva kokushintshwa, khetha le nto (iseli noma ibanga) bese uqhafaza inkinobho ethi Enter.



3. Ngemuva kwalokho, kuzoba nokubuyela okuzenzakalelayo eshidini langaphambilini, kepha kubhekiswe kwireferensi esikudingayo izokwakhiwa.

Manje ake sibheke ukuthi ungabhekisa kanjani entweni etholakala kwenye incwadi. Okokuqala, kufanele wazi ukuthi imigomo yokusebenza kwemisebenzi ehlukahlukene namathuluzi we-Excel nezinye izincwadi ezihlukile. Abanye babo basebenza namanye amafayela e-Excel, noma ngabe bavaliwe, kanti abanye badinga ukwethulwa okuphoqelekile kwalawa mafayili.

Mayelana nalezi zici, uhlobo lokuxhumanisa kwezinye izincwadi luhlukile. Uma wethula ithuluzi elisebenza kuphela ngamafayela wokugijima, khona-ke kulokhu ungavele ucacise igama lencwadi obhekisa kuyo. Uma uhlose ukusebenza ngefayela elingasondelanga, khona-ke kulokhu udinga ukucacisa indlela ephelele kuyo. Uma ungazi, iyiphi imodi ozosebenza ngayo nefayela noma ungaqiniseki ukuthi ithuluzi elithile lingasebenza kanjani ngalo, khona-ke kulokhu, kungcono ukucacisa indlela ephelele. Ngisho nakanjani ngeke kube njalo.

Uma udinga ukubhekisa entweni enekheli C9, ephepheni 2 encwadini egijimayo ebizwa nge- "Excel.xlsx", khona-ke kufanele uqophe le nkamba elandelayo lapho inani lizokhonjiswa:

= [Excel.xlsx] Uhlu2! C9

Uma uhlela ukusebenza ngedokhumenti evaliwe, khona-ke, phakathi kwezinye izinto, udinga ukucacisa indlela yendawo yayo. Ngokwesibonelo:

= 'D: \ Folder entsha \ [Excel.xlsx] Ishidi2'! C9

Njengasendabeni yokwakha isisho esibhekiselwe kwelinye ishidi, lapho kudala isixhumanisi esiya entweni enye incwadi, ungakwazi, ukuyifaka ngesandla, futhi ukwenze ngokukhetha iseli elihambisanayo noma elisemaphethelweni kwelinye ifayela.

1. Sibeka umlingiswa "=" esitokisini lapho isisho esibhekisa khona sizotholakala khona.



2. Ngemuva kwalokho vula incwadi lapho ufuna ukubhekisa khona uma ingasebenzi. Ubumba ephepheni lakhe endaweni ofuna ukubhekisa kuyo. Ngemuva kwalokho, chofoza ku-ENTER.



3. Kukhona ukubuyela okuzenzakalelayo encwadini edlule. Njengoba ubona, sekuvele kahle isixhumanisi esiya kwinto yalelo fayela, esichofoze ngalo esinyathelweni esedlule. Inegama kuphela ngaphandle kwendlela.



4. Kepha uma sivala ifayela ukubhekisa kulo, isixhumanisi sizoguqula ngokushesha. Izokwethula indlela ephelele efayilini. Ngakho-ke, uma ifomula, umsebenzi noma ithuluzi lisekela umsebenzi ngezincwadi ezivaliwe, manje, ngenxa yokuguqulwa kwenkulumo yereferensi, kuzokwazi ukuthatha leli thuba.

Njengoba ubona, isixhumanisi esikhuthazayo esicabheni esinye ifayela elisebenzisa chofoza akukho lula kakhulu ukwedlula indlela ebiyelwe lelo kheli ngesandla, kodwa futhi kuleso sikhathi isixhumanisi uqobo siguqulwa ngokuya ngokuthi Incwadi ivaliwe lapho kubhekwa khona, noma ukuvula.

Indlela 3: Umsebenzi wesibili

Enye inketho yokubhekisa entweni e-Excel ukusetshenziswa komsebenzi wedeshi. Leli thuluzi lihlose ukudala izinkulumo zesethenjwa ngendlela yombhalo. Izikhombo ezenziwe ngaleyo ndlela zibizwa nangokuthi "Super", ngoba zixhunywe kwiseli elichaziwe kuzo ziqinile kakhulu kunezinto ezijwayelekile eziphelele. I-syntax yalolu hlelo lokusebenza:

= DVSSL (isixhumanisi; A1)

"Isixhumanisi" yingxabano ebhekisa esitokisini kwifomu lombhalo (elisongwe ngezingcaphuno);

I- "A1" iyimpikiswano yokuzikhethela enquma ukuthi yiziphi izixhumanisi zesitayela ezisetshenziswayo: A1 noma R1C1. Uma inani lale ngxabano "iqiniso", inketho yokuqala isetshenziswa uma "amanga" eyesibili. Uma le ngxabano ivaliwe, khona-ke ngokuzenzakalela kukholakala ukuthi ukulungiswa kohlobo A1 kuyasetshenziswa.

1. Sibona into yephepha lapho ifomula izoba khona. Ubumba kwisithonjana se- "Insert Function".



2. E-Wizard yemisebenzi ku- "Links kanye nama-Arrays" Vimba, sigubha i- "DVSSL". Chofoza u- "Kulungile".



3. I-agumenti iwindi lokhu opharetha liyavuleka. Esikhathini "Xhumanisa iseli" ensimini, setha isikhombisi futhi ukugqamisa ucindezela inkinobho ukuthi ingxenye ishidi lapho sifuna ubheke. Ngemva ikheli uboniswa emkhakheni, "Ukugoqa" nge izingcaphuno yayo. Eyesibili ensimini ( "A1") kushiywa kungenalutho. Chofoza ku- "Kulungile".



4. Waba yini umphumela wesibindi ekucubunguleni lo msebenzi siboniswa kuseli elikhethiwe.

Kabanzi, izinzuzo kanye ezicashile umsebenzi DVRSL zidingidwa isifundo ehlukile.

Isifundo: Umsebenzi Dultnsil e-Microsoft Excel

Indlela 4: Ukudala oxhumano

I izixhumanisi zehluke uhlobo link ukuthi sixoxe ngenhla. Abanaso ukukhonza ukuba "ukudonsa" idatha kusuka nezinye izindawo kuleyo seli, ukuthi zikuphi, futhi ukuze wenze ukushintshela uma ngokuchofoza endaweni lapho kubhekisela.

1. Kukhona ezintathu okukhethwa kukho ukushintsha ewindini yokudala hyperlink ukuphi. Ngokusho wokuqala babo, udinga ukugqamisa cell kulo oxhumano uzobe ifakwe, futhi chofoza kukho inkinobho yegundane kwesokudla. Esikhathini imenyu yengqikithi, ukhethe "Isixhumanisi ...".

   

   Kunalokho, ungakwazi, ngemuva kokukhetha into lapho oxhumano sifakwe, ukuya "Faka" ithebhu. Kube ku-Ribbon udinga uchofoze inkinobho "Isixhumanisi".

   

   Futhi, ngemva kokukhetha iseli, ungakwazi ukusebenzisa Ctrl K okhiye.

2. Ngemuva kokufaka isicelo yimiphi ezintathu lezi ongakhetha, iwindi Isixhumanisi Creation liyavuleka. Engxenyeni esinxeleni sewindi, kukhona kukhethwa, ngawo into kuyadingeka contact:
   • Nge endaweni encwadini zamanje;
   • Nge incwadi entsha;
   • Nge iwebhusayithi noma ifayela;
   • Nge-e-mail.



3. Ngokuzenzakalelayo, iwindi iqala zokuxhumana mode ngekhasi ifayela noma iwebhu. Ukuze uhlobanise i-elementi ifayela, abahlala engxenyeni ephakathi ewindini usebenzisa amathuluzi Ukuqondiswa kwemikhumbi, kudingeka wena ukuya ukuthi lwemibhalo idrayivu kanzima lapho ifayela oyifunayo itholakala futhi usikhethe. Kungaba kokubili incwadi Excel ne ifayela iyiphi enye ifomethi. Ngemva kwalokho, izixhumanisi azoboniswa ku "Ikheli" field. Ngokulandelayo, ukuqedela operation, qhafaza inkinobho ethi "KULUNGILE".

   

   Uma kukhona isidingo ukuxhumana website ke kulesi simo, esigabeni esifanayo ewindini ekudalweni imenyu "Ikheli" field udinga nje ucacise ikheli oyifunayo web isisetshenziswa bese uchofoze "KULUNGILE" inkinobho.

   

   Uma ufuna ukucacisa i-hyperlink endaweni encwadini yamanje, kufanele uye kwi- "tie nendawo engxenyeni ethi" Guqula Isigaba. Okulandelayo, engxenyeni ephakathi yewindi, udinga ukucacisa ishidi nekheli leseli lapho ukuxhumana kufanele kwenziwe khona. Chofoza ku- "Kulungile".

   

   Uma udinga ukudala idokhumenti entsha ye-Excel futhi ulibophezele usebenzisa i-hyperlink encwadini yamanje, kufanele uye esigabeni esithi "hlangana nedokhumenti elisha". Okulandelayo, endaweni ephakathi kwewindi, yinike igama bese ucacisa indawo yalo kwi-disk. Bese uchofoza ku- "Kulungile".

   

   Uma ufisa, ungaxhuma into yamaqabunga nge-hyperlink ngisho ne-imeyili. Ukuze wenze lokhu, sithuthela engxenyeni ethi "Tie nge-imeyili" nasensimini "ekhelini" ikhombisa i-imeyili. Ubumba ku- "Kulungile".



4. Ngemuva kokuthi i-hyperlink ifakiwe, umbhalo esitokisini lapho etholakala khona, okuzenzakalelayo kuba luhlaza okwesibhakabhaka. Lokhu kusho ukuthi i-hyperlink iyasebenza. Ukuya entweni exhunywe kuyo, kwanele ukuchofoza kabili kuyo ngenkinobho yegundane kwesobunxele.

Ngaphezu kwalokho, i-hyperlink ingenziwa kukhiqizwa kusetshenziswa umsebenzi oshumekiwe onegama elikhulumayo uqobo - "hyperlink".

Lo opharetha une-syntax:

= Hyperlink (ikheli; igama)

"Ikheli" - Ingxabano ekhombisa ikheli lewebhusayithi kwi-Intanethi noma kwifayela kwi-hard drive, lapho udinga ukuthola ukuxhumana.

"Igama" - Ingxabano ngendlela yombhalo, ezokhonjiswa endaweni eshidi equkethe i-hyperlink. Le ngxabano ayiphoqelekile. Uma kungekho, ikheli lento lizokhonjiswa ekhasini lephepha lapho umsebenzi ubhekisela khona.

1. Siqokomisa iseli lapho i-hyperlink izotholakala khona, futhi ubumba kwisithonjana se- "Insert Function".



2. Emisebenzini Wizard, iya ku "Izixhumanisi kanye Nezindawo Zokuhlaziya". Sibona igama elithi "hyperlink" bese uqhafaza ku- "Kulungile".



3. Ewindini lokuphikisana endizeni ethi "ikheli", chaza ikheli kuwebhusayithi noma kwifayela kwi-Winchester. Ensimini ethi "NAME" Sibhala umbhalo ozoboniswa ekhasini leshidi. Ubumba ku- "Kulungile".



4. Ngemuva kwalokho, i-hyperlink izokwakhiwa.

Isifundo: Ungayenza kanjani noma ususe ama-hyperlinks ku-Excel

Sithole ukuthi kunamaqembu amabili axhumanisa amatafula ama-Excel: asetshenziswa kumafomula kanye nabasebenzi ku-Transition (Hyperlink). Ngaphezu kwalokho, la maqembu amabili ahlukaniswe izinhlobo eziningi ezincane. Kusuka kuhlobo oluthile lwezinga futhi kuya nge-algorithm yenqubo yokudala.