Ungayenza njani ikhonkco ukuba liphumelele. Ukudala amakhonkco ukuya kwelinye iphepha, kwenye incwadi, hyperlink

Ukudala iimbekiselo yinkqubo apho umsebenzisi ngamnye we-prosece yetafile ejongene nayo. Amakhonkco asetyenziselwa ukumilisela iirekhodi kumaphepha athile eWebhu, kunye nokufikelela kuyo nayiphi na imithombo yangaphandle okanye amaxwebhu. Kwinqaku, siza kuqwalasela ngokweenkcukacha inkqubo yokudala amakhonkco kwaye sifumanise ukuba yeyiphi na intsizana enokwenziwa kunye nabo.

Iindidi zonxibelelwano

Zimbini iintlobo eziphambili zekhonkco:

1. Izalathiso ezisetyenziswa kwiifomula ezahlukeneyo zekhompyuter, kunye neempawu ezizodwa.
2. Iireferensi ezisetyenziselwa ukubhekisa kwizinto ezithile. Babizwa ngokuba zii-hyperlinks.

Onke amakhonkco (amakhonkco) aqhagamshelwe ngeendlela ezi-2.

• Uhlobo lwangaphandle. Isetyenziselwe ukuhambisa kwakhona kwinto efakwe kwenye ixwebhu. Umzekelo, kolunye uphawu okanye iphepha le-Intanethi.
• Uhlobo lwangaphakathi. Isetyenziselwe ukuhambisa into kwincwadi enye. Basetyenziswa ngokusemgangathweni ngohlobo lwamaxabiso omqhubi okanye izinto ezincedisayo zefomula. Faka isicelo sokukhankanya izinto ezithile ngaphakathi koxwebhu. La makhonkco anokukhokelela kuzo zombini izinto zephepha elinye kunye nezinto ezinamaphepha ashiyekileyo oxwebhu olunye.

Zininzi izinto ezahlukeneyo zokudala amakhonkco. Indlela kufuneka ikhethwe, cinga ukuba luhlobo luni lweendlela ezifunekayo kwiPhepha lokuSebenza. Siza kuvavanya indlela nganye ngakumbi.

Ukwenza amakhonkco kwiphepha elinye

Ikhonkco elilula kukukhankanya iidilesi zeseli kule fomu ilandelayo: = B2.

Nye

Isimboli "=" yeyona nto iphambili kwikhonkco. Emva kokubhala olu phawu emgceni wokungena kwifomula, iprosesa ye-tabuster iya kuqala ukuqonda eli xabiso njengekhonkco. Kubaluleke kakhulu ukungenisa ngokuchanekileyo idilesi yeseli ukuze inkqubo ivelise ngokuchanekileyo inkqubo yolwazi. Kumzekelo opheleleyo, ixabiso "= B2" libonisa ukuba kwintsimi ye-D3 apho singene khona kwikhonkco esiya kubhekiswa kwiseli ye-B2.

2.

3.

Yonke le nto ivumela imisebenzi eyahlukeneyo ye-arithmetic kwiprosesa ye-tabustar. Umzekelo, sibhala le fomula ilandelayo kwicandelo le-D3: = A5 + B2. Emva kokungena kule fomula, cinezela "Ngena". Ngenxa yoko, sifumana iziphumo zongezwa kweeseli ze-B2 kunye ne-A5.

ezine

Ntlanu

Ukusebenza kweminye imisebenzi ye-arithmetic kunokuveliswa ngendlela efanayo. Kwiprosesa ye-Tabustar Kukho isitayile esiphambili:

1. Umbono oPhazulu - A1.
2. Ifomathi ye-R1C Isalathiso sokuqala sibonisa inani lomgca, kunye nenani le-2 lekholamu.

Inyathelo lenyathelo lenyathelo lokulungelelanisa iinguqu zijongeka ngolu hlobo:

1. Yiya kwicandelo "lefayile".

6.

1. Khetha i- "Parameter" Inqaku, elikwizantsi elisezantsi lasekhohlo lefestile.

7.

1. Isikrini sibonisa ifestile ngeeparameter. Sifudukela kwicandelwana elibizwa ngokuba "kwifomula". Sifumana "ukusebenza nefomula" kwaye sibeka uphawu kufutshane ne "Ikhonkco Stayitha R1C1" ". Emva kokwenza bonke ubugqwetha, cofa kwi "Kulungile".

Sibhozo

Kukho iintlobo ezi-2 zekhonkco:

• Isalathiso esigqibeleleyo kwindawo ethile, ngaphandle kwento enomxholo ochaziweyo.
• Izihlobo zibhekisa kwindawo yezinto ezihambelana neseli yokugqibela kunye nentetho erekhodiweyo.

Ngokuzenzekelayo, zonke iikhonkco ezongeziweyo zithathwa njengezinye. Cinga ngomzekelo wokubukela abanembeko. Isikhokelo senyathelo lenyathelo:

1. Sikhetha iseli kwaye singene kwikhonkco kwelinyeseli kwiseli kuyo. Umzekelo, bhala: = B1.

Thoba

1. Emva kokungena kwintetho, cofa "Faka" ukukhupha iziphumo zokugqibela.

10

1. Hambisa isikhombisi kwikona esezantsi yeseli. Isikhombisi siyakuthatha ubume be-mubs encinci emnyama. Cinezela i-LKM kwaye ulule intetho phantsi.

Shumi elinanye

1. Ifomula yakhutshelwa kwiiseli ezisezantsi.

12

1. Siphawula ukuba kwiiseli ezisezantsi, ikhonkco elingene kwikhonkco litshintshe kwisikhundla esinye kunye nenqanaba elinye. Esi siphumo sasibangelwa kukusetyenziswa kwesalathiso sesalathiso.

13

Ngoku uqwalasela umzekelo we-wimiullations kunye neendlela ezingcono zonxibelelwano. Isikhokelo senyathelo lenyathelo:

1. Sebenzisa uphawu lwedola "$" Sivelisa ukulungiswa kwedilesi yeseli phambi kwekholamu kunye nenombolo yomgca.

Shumi elinane

1. Solula, kunye nalo mzekelo ungasentla, ifomula phantsi. Siphawula ukuba iiseli ezingezantsi zihlala ziluhlobo olufanayo nakwiseli yokuqala. Ikhonkco olupheleleyo lirekhoda amaxabiso aselula, kwaye ngoku abatshintshi xa ifomula iguqukile.

Shumi elinantlanu

Yonke enye into, kwi-TABuster Proveres, unokusebenzisa ikhonkco kuluhlu lweeseli. Okokuqala, idilesi yeseli ephezulu yasekhohlo ibhaliwe, kwaye ke eyona nto iphantsi kakhulu. Phakathi kolungelelwaniso yi-Colon ":". Umzekelo, lo mfanekiso ungezantsi, uluhlu lwe-A1 luyekelelwe: c6. Isalathiso kolu luhlu yile: = A1: C6.

Shumi elinesthandathu

Ukwenza ikhonkco kwelinye iphepha

Ngoku qwalasela indlela yokwenza ireferensi kwamanye amaphepha. Apha, ukongeza kokulungelelaniswa kweseli, idilesi yephepha elithile lokusebenza longeza. Ngamanye amagama, emva kophawu "=", igama lephepha lokusebenza liyaziswa, emva koko kwabhalwa uphawu lwesikhuzo, kwaye idilesi yento efunekayo yongezwa ekugqibeleni. Umzekelo, ikhonkco kwiseli ye-C5, ekwiphepha lomsebenzi elibizwa ngokuba ngu- "Dlu Uluhlu2, ngolu hlobo lulandelayo: = Uluhlu2! C5.

17.

Isikhokelo senyathelo lenyathelo:

1. Sifudukela kwiseli eyimfuneko, faka umlinganiswa "=". Vala i-LKM egameni lephepha, elikwezantsi kwi-intanethi yenkqubo yeNkcazo.

Shumi elinesibhozo

1. Safudukela kwi-2nd yephepha lesibini loxwebhu. Ngokucinezela i-LCM, sikhetha iseli esinqwenela ukuyifumana kwifomula.

Shumi elinethoba

1. Emva kokwenza bonke ubugqwetha, cofa kwi "Ngena". Sizifumene kwiPhepha loMsebenzi, apho inani lokugqibela sele lisusiwe.

Amashumi amabini

Isalathiso sangaphandle kwenye incwadi

Cinga ngendlela yokuphumeza ikhonkco langaphandle kwenye incwadi. Umzekelo, kufuneka sisebenzise ukudalwa kwekhonkco kwiseli ye-B5, ekwiphepha lokusebenzela lencwadi evulekileyo "I-ConventsX.XELSX".

21.

Isikhokelo senyathelo lenyathelo:

1. Sikhetha iseli apho sinqwenela ukongeza ifomula. Singena kumlinganiswa "=".

22.

1. Ukuhamba kwincwadi evulekileyo apho iseli ifumaneka khona, ikhonkco esifuna ukongeza. Cofa kwigqabi elifunekayo, emva koko kwiseli oyifunayo.

23.

1. Emva kokwenza bonke ubugqwetha, cofa kwi "Ngena". Sizifumene sikwiphepha lomsebenzi loqobo apho iziphumo zokugqibela sele zisungulwe.

24.

Qhagamshela kwifayile kwiseva

Ukuba uxwebhu lukhona, umzekelo, kwifolda yasimahla yeseva edibeneyo, ke inokubhekiswa koku kulandelayo:25.

Ikhonkco kuluhlu olubizayo

Iprosesa ye-Tabuster ikuvumela ukuba wenze ikhonkco kudidi olunikwe igama olwenziweyo ngo "Wamakazi" wegama ". Ukwenza oku, faka igama lomgangatho kwikhonkco ngokwalo:

26.

Ukuchaza ireferensi kuluhlu olunamagama kuxwebhu lwangaphandle, kufuneka ucacisa igama layo, kunye nenkcazo yendlela:

27.

Qhagamshela kwiTafile ye-Smart okanye izinto zayo

Sebenzisa umsebenzi wehyperslob, unokusebenzisa ikhonkco kuyo nayiphi na itafile yetafile "ye-Smart" okanye kuyo yonke iplate ngokupheleleyo. Ijongeka ngolu hlobo:

28.

Sebenzisa i-DVSRL ye-Operator

Ukuphumeza imisebenzi eyahlukeneyo, ungawusebenzisa umsebenzi okhethekileyo weDVSSL. Ukujonga ngokubanzi ngomsebenzi: = I-DVSSL (ikhonkco_ yegama; i1). Siza kuhlalutya umqhubi ngakumbi kumzekelo othile. Isikhokelo senyathelo lenyathelo:

1. Sivelisa ukhetho lweseli eliyimfuneko, emva koko sicofe kwi "fanser" umsebenzi ", ubekwe ecaleni komgca wokungena kwifomula.

29.

1. Ifestile ibonisa iwindow ebizwa ngokuba yi "umsebenzi wokufakwa". Khetha udidi "Amakhonkco kunye neCorys".

Amashumi amathathu

1. Cofa kwinto yedash. Emva kokwenza bonke ubugqwetha, cofa kwi "Kulungile".

31.

1. Umboniso ubonakalisa iwindow ukuba ingene kwimpikiswano yomsebenzi. Emgceni "Qhagamshela_ Igama" ndizisa ukulungelelanisa kweseli esifuna ukubhekisa kuyo. Umgca "A1" Shiya ungenanto. Emva kwayo yonke i-wimimpal, cofa iqhosha u "Kulungile".

32.

1. Ilungile! Iziphumo zibonisa iziphumo zethu.

33.

Yintoni i-hyperlink

Ukwenza hyperlink

Ii-hyperlinks azivumelanga nje kuphela "ukukhupha ulwazi" kwiiseli, kodwa nakwiinguqu kwisalathiso. Inyathelo lesikhokelo senyathelo ukwenza i-hyperlink:

1. Ekuqaleni, kuyimfuneko ukuba ungene kwiwindows ekhethekileyo ekuvumela ukuba wenze i-hyperlink. Zininzi iindlela zokukhetha ukumilisela eli nyathelo. Eyokuqala-cinezela i-PKM kwiseli eyimfuneko kwaye kwimenyu yemeko Khetha i-ENGN "ikhonkco ...". Okwesibini - Khetha iseli enqwenelekayo, fudukela kwicandelo "Faka" kwaye ukhethe into "yekhonkco". Okwesithathu - sebenzisa umdibaniso ophambili "Ctrl + k".

34.

35.

1. Isikrini sibonisa iwindow evumela ukuba uhlengahlengise i-hyperlink. Kukho ukhetho lwezinto ezininzi. Makhe siqwalasele ukhetho ngalunye ngeendlela.

Ukwenza njani i-hyperlink kwi-Excel ukuya kolunye uxwebhu

Isikhokelo senyathelo lenyathelo:

1. Sivelisa iwindow yokuvula ukudala i-hyperlink.
2. Kumgca othi "tie", khetha "ifayile, iphepha lewebhu".
3. Kwi-"Khangela b "umgca, sikhetha ifolda apho ifayile iceba ukwenza ikhonkco.
4. Kwicandelo "lokubhaliweyo", sifaka ulwazi lokubhaliweyo, oluya kuboniswa endaweni yesalathiso.
5. Emva kwayo yonke i-wimimpal, cofa kwi "Kulungile".

36 indlela yokwenza i-hyperlink kwi-Excel kwiphepha lewebhu

Isikhokelo senyathelo lenyathelo:

1. Sivelisa iwindow yokuvula ukudala i-hyperlink.
2. Kumqolo othi "tie", khetha "ifayile, iphepha lewebhu".
3. Cofa kwiqhosha "kwi-Intanethi".
4. Kwi-"dilesi" umgca, uqhuba idilesi yephepha elikwi-intanethi.
5. Kwicandelo "lokubhaliweyo", sifaka ulwazi lokubhaliweyo, oluya kuboniswa endaweni yesalathiso.
6. Emva kwayo yonke i-wimimpal, cofa kwi "Kulungile".

37 Ungayenza njani i-hyperlink kwi-Excel kwindawo ethile kuxwebhu lwangoku

Isikhokelo senyathelo lenyathelo:

1. Sivelisa iwindow yokuvula ukudala i-hyperlink.
2. Kumgca othi "tie", khetha "ifayile, iphepha lewebhu".
3. Cofa kwi "TAB ..." kwaye ukhethe iSoftware yokwakha ikhonkco.
4. Emva kwayo yonke i-wimimpal, cofa kwi "Kulungile".

38 indlela yokudala i-hyperlink kwi-Excel kwincwadi yomsebenzi entsha

Isikhokelo senyathelo lenyathelo:

1. Sivelisa iwindow yokuvula ukudala i-hyperlink.
2. Kumgca "obophe", khetha inqaku elitsha ".
3. Kwicandelo "lokubhaliweyo", sifaka ulwazi lokubhaliweyo, oluya kuboniswa endaweni yesalathiso.
4. Kwigama elitsha elithi "intambo, faka igama loxwebhu olutsha lwe-tabemu.
5. Kwindlela "yendlela", bonisa indawo ukugcina uxwebhu olutsha.
6. Emgceni "xa uhlela kubhalo olutsha", khetha eyona iphambili ngokwakho.
7. Emva kwayo yonke i-wimimpal, cofa kwi "Kulungile".

39 indlela yokwenza i-hyperlink kwi-Excel ukwenza i-imeyile

Isikhokelo senyathelo lenyathelo:

1. Sivelisa iwindow yokuvula ukudala i-hyperlink.
2. Kumqolo othi "TIE", khetha eyona nto i-imeyile.
3. Kwicandelo "lokubhaliweyo", sifaka ulwazi lokubhaliweyo, oluya kuboniswa endaweni yesalathiso.
4. Emgceni "el. Imeyile "bonisa i-imeyile yomamkeli.
5. Kwindlela "yomxholo", faka igama leleta
6. Emva kwayo yonke i-wimimpal, cofa kwi "Kulungile".

40.

Ungahlela njani i-hyperlink in Excel

Ihlala yenzeka rhoqo ukuba i-hyperlink hyperlink kufuneka ihlelwe. Yenza kube lula kakhulu. Isikhokelo senyathelo lenyathelo:

1. Sifumana iseli nge-hyperlink egqityiweyo.
2. Cofa kwi-PKM. Imenyu yemeko ityhiliwe, apho ukhetha inqaku elithi "tshintsha i-hyperlink ...".
3. Kwifestile evelayo, sivelisa lonke uhlengahlengiso oluyimfuneko.

41.

Indlela yokufomatha i-hyperlink kwi-Excel

Ngokubanzi, zonke iingqinisiso kwi-prosesa letafile ziboniswa njengombhalo okrwelelwe umgca we-Blue. Ifomathi inokutshintshwa. Isikhokelo senyathelo lenyathelo:

1. Siqhubela phambili "ekhaya" kwaye sikhethe into "yendlela yeseli".

42.

1. Cofa kumbhalo "Hyperlink" yi-PKM kwaye ucofe "" utshintsho ".
2. Kwifestile ebonisiweyo, cinezela iqhosha "ifomathi".

43.

1. Kwifonti "kunye" nokulisa ", unokutshintsha ukufomatha.

44.

Ungayisusa njani i-hyperlink kwi-Excel

Isikhokelo senyathelo lenyathelo lokususa ii-hyperlinks:

1. Cofa i-PCM kwiseli, apho ikhoyo.
2. Kwimenyu yokucima umxholo, khetha eyona nto "cima i-hyperlink". Ilungile!

45.

Sebenzisa iisimboli ezingekho mgangathweni

Kukho iimeko apho i-hyperlink hyperlink inokudityaniswa kunye nomsebenzi wokuphuma kwabalinganiswa abangaqhelekanga. Inkqubo iphumeza ukutshintshwa kwekhonkco lesicatshulwa esiqhelekileyo kulo naluphi na uphawu olungelulo oluqhelekileyo.46.

Ukuqukumbela

Sifumanise ukuba kwitheyibhile ye-proser egqwesileyo kukho inani elikhulu leendlela ezikuvumela ukuba wenze ikhonkco. Ukongeza, saqhelana nendlela yokwenza i-hyperlink ekhokelela kwizinto ezahlukeneyo. Kufanelekile ukuba uqaphele ukuba kuxhomekeke kwimbono ekhethiweyo yesalathiso, inkqubo yokuphunyezwa kotshintsho lwekhonkco olufunekayo.

Umyalezo kanjani ukwenza ikhonkco ukuba liphumelele. Ukudala izingqinisiso zokugqwesa kwelinye igqabi, kwelinye incwadi, i-hyperlink ivele kuqala kwitekhnoloji yolwazi.