Nika amagama achaza kumaseli athile okanye kumacandelo eeseli
Uluhlu olukhethiweyo , igama legama , okanye igama elichaziweyo libhekisela kwinto enye kwi-Excel. Igama elichazayo - elinjengeJan_Sales okanye uJuni_Precip - eliqhotyoshelwe kwiseli ethile okanye uluhlu lweeseli kwiphepha lokusebenzela okanye incwadi yokusebenzela .
Amanqanaba aqingqiweyo akwenza kube lula ukuyisebenzisa nokuchonga idatha xa udala iitshathi , kunye namafomula afana ne:
= SUM (Jan_Sales)
= June_ Nciphisa + July_ Nciphisa + Aug_ Isiqwenga
Kwakhona, ekubeni udidi olukhethiweyo alutshintshi xa ifomula ikopishwa kwezinye iiseli , inika enye indlela yokusebenzisa iiferensi zeseli ngokupheleleyo kwiifomula.
Ukuchaza igama kwi-Excel
Iindlela ezahlukeneyo ezintathu zokuchaza igama kwi-Excel zi:
- Ukusebenzisa iBhokisi legama (eli phepha elingezansi)
- Ukusebenzisa ibhokisi yencoko yegama elitsha
- Ukusebenzisa uMlawuli wegama
Ukuchaza igama ngeBhokisi legama
Enye indlela, kwaye mhlawumbi indlela elula yokuchaza amagama usebenzisa iBhokisi legama , elisezantsi kwikholamu A kwiphepha lokusebenzela.
- Sebenzisa le ndlela ukudala amagama ayingqayizivele eyaziwayo ngamaphepha onke kwincwadi yokusebenzela.
Ukwakha igama usebenzisa iBhokisi legama njengoko kuboniswe kumfanekiso ongentla:
- Phakamisa uluhlu olufunwayo lweeseli kwiphepha lokusebenzela.
- Thayipha igama elifunayo kuloluhlu kwibhokisi legama, njengeJan_Sales.
- Cinezela ukhiye wokungena kwikhibhodi.
- Igama liboniswa kwibhokisi legama.
Qaphela : Igama liyaboniswa kwibhokisi yegama xa kukho uluhlu olufanayo lweeseli lugqitywa kwiphepha lokusebenzela. Kwakhona kuboniswe kuMphathi wegama.
Ukuqamba iMithetho kunye neziThibelo
I- syntax eyintloko ilawula ukukhumbula xa ukudala okanye ukuhlela amagama emigangatho:
- Igama alikwazi ukuba neendawo.
- Umlingisi wokuqala wegama kufuneka ube
- ileta
- phawula (_)
- ukubuyela emuva (\)
- iimboli ezisele zikhona kuphela
- iileta okanye iinombolo
- maxesha
- gxi ninisa
- Ubuninzi begama lobude bungamahlamvu angama-255.
- Iileyibrari kunye neephasicase zingabonakali kwi-Excel, ngoko i- Jan_Sales kunye ne- jan_sales zibonwa njengegama elifanayo nge-Excel.
IMigaqo yoLungelelaniso yongezelelweyo yile:
- I-reference reference yeselula ayikwazi ukusetyenziswa njengamagama afana ne-A25 okanye i-R1C4.
- Amagama angamaqabane angabodwa avunyelwe ngaphandle kwe "C", "c", "R", okanye "r" kuba adibene neenkcukacha zekholomu kunye neefowuni ezilandelelweyo ezifana ne- R1C4.
01 ka 02
Amagama achaziweyo kunye nobubanzi kwi-Excel
Wonke amagama aneendawo ezibhekisela kwiindawo apho igama elithile libonwa yi-Excel.
Ububanzi begama lungaba:
- iifom zabasebenzi ngabanye - ezibhekiselwe kuyo njengendawo yokusebenza kwinqanaba lomsebenzi
- incwadi yonke yomsebenzi - inqanaba lomsebenzi wehlabathi jikelele
Igama kufuneka libe liyingqayizivele kwindawo yalo, kodwa igama elifanayo linokusetyenziswa kwiimpawu ezahlukileyo.
Qaphela : Ubume obungapheliyo bamagama amatsha lizinga leencwadi zokusebenzela. Xa kuchaziwe, ububanzi begama alinakuguqulwa lula. Ukutshintsha ububanzi begama, cima igama kwiMenenja yegama uze uyihlaziye ngokufanelekileyo.
Uluhlu lweNqanaba loPhulo lomsebenzi
Igama elisezantsi lomgangatho wephepha lokusebenzela livumelekile kuphela kwiphepha lokusebenzela elichazwe ngalo. Ukuba igama le- Total_Sales linomlinganiselo wephepha le-1 kwincwadi yokusebenzela, i-Excel ayiyi kuqaphela igama kwifayile yesi-2, iphepha le-3, okanye nayiphi na ifayile kwincwadi yokusebenzela.
Oku kwenza ukuba kunokwenzeka ukuchaza igama elifanayo ukusetyenziswa kwiifayile ezininzi zokusebenzela - nje ngokuba ububanzi begama ngalinye likhawulelwe kwiphepha elithile lomsebenzi.
Ukusebenzisa igama elifanayo kumaphepha ahlukeneyo kunokukwenziwa ukuqinisekisa ukuqhubeka phakathi kwama-worksheet kwaye uqinisekise ukuba amafomula asebenzisa igama elithi Total_Sales lihlala libhekisela kwinqanaba leelinye elifanayo kwiifayile ezisebenzayo ezininzi kwincwadi yokusebenzela enye.
Ukuhlukanisa phakathi kwamagama afanayo kunye neendlela ezahlukileyo kwiifomula, ulandele igama ngegama lomsebenzi, njengale:
I-Sheet1! I-Total_Sales, iSheet2! I-Total_Sales
Qaphela: Amagama adalwe esebenzisa iBhokisi legama liya kuhlala enomgangatho wenqanaba lomsebenzi wehlabathi jikelele ngaphandle kokuba igama lamagama kunye negama legama lifakwa kwibhokisi legama xa igama lichazwa.
Umzekelo:
Igama: Jan_Sales, Ububanzi - inqanaba lomsebenzi wehlabathi jikelele
Igama: I-Sheet1! Jan_Sales, Ubume - inqanaba lomsebenzi wendawo
Inqanaba lomsebenzi wehlabathi jikelele
Igama elichazwe kwinqanaba lebala lokusebenzela liyaqatshelwa kuzo zonke iifom zephepha kule ncwadi yokusebenzela. Igama leelwimi lomsebenzi lingasetyenziselwa kuphela kwincwadi yencwadi, ngokungafani namanqanaba eqondo lephepha elixutyushwa ngasentla.
Igama lomsebenzi wezinga lokusebenzela alikho, nangona kunjalo, eliqatshelwa nayiphi na enye incwadi yokusebenzela, ngoko amagama angamazinga ehlabathi angaphinda aphindwe kwiifayile ezahlukeneyo ze-Excel. Ngokomzekelo, ukuba igama likaJan_Sales linomhlaba wonke, igama elifanayo lingasetyenzwa kwiincwadi ezahlukeneyo ezibizwa nge-2012_Revenue, 2013_Revenue, kunye ne-2014_Revenue.
Ingxabano kunye nobubanzi bokuqala
Kungenzeka ukusebenzisa igama elifanayo kwinqanaba lekhasi leendawo kunye nenqanaba lokusebenzela kuba ububanzi bezo zibini ziyahluka.
Loo nto, nangona kunjalo, yayiza kubangela ingxabano nanini na igama lisetyenziswa.
Ukuxazulula ezo mpizo, kwi-Excel, amagama achazwe kwinqanaba lephepha lokusebenzela liza kuqala ngaphezu kwenqanaba lomsebenzi wehlabathi.
Kwimeko enjalo, igama le-sheet ye- 2014_Revenue luza kusetyenziswa endaweni yegama lomgangatho wencwadi ka- 2014_Revenue .
Ukugqithisa ukubaluleka kokuqala, sebenzisa igama lenqanaba lomsebenzi ngokubambisana negama elithile lamanqanaba afana ne- 2014_Revenue! Iphepha 1.
Ukwahlula okunye ukugqwesa phambili kwinqanaba lezinga lokusebenzela lomsebenzi elisezantsi kwiphepha 1 leencwadi. Iimpawu ezixhunywe kwiphepha 1 kwiphina incwadi yokusebenzela ayinakugqithiswa ngamagama eqondo lehlabathi.
02 we 02
Ukuchaza nokuLawula amagama ngeMphathi wegama
Ukusebenzisa iBhokisi leNgcaciso yegama elitsha
Indlela yesibini yokuchaza amagama kukusebenzisa ibhokisi yencoko yegama elitsha . Le bhokisi yencoko ivuliwe usebenzisa i- Define Name option ephakathi kwefomula ithebhu yerbhoni .
Ibhokisi yencoko yencoko yegama elitsha yenza kube lula ukuchaza amagama anesithuba sephepha lokusebenzela.
Ukwakha igama usebenzisa Ibhokisi yencoko yencoko yegama elitsha
- Phakamisa uluhlu olufunwayo lweeseli kwiphepha lokusebenzela.
- Cofa kwiThebhu yefomula yerbhoni.
- Cofa kwiKhowudi yokuchaza igama ukuvula ibhokisi yencoko yababini.
- Kwibhokisi yencoko, kufuneka ukuba uchaze:
- Igama
- Ububanzi
- Ububanzi begama elitsha-izimvo zikhethiweyo
- Xa ugqityiwe, qhosha u-OK ukubuyela kwiphepha lokusebenzela.
- Igama liya kuboniswa kwiBhokisi leNkcukacha xa kukho uluhlu oluchaziweyo olukhethiweyo.
Umphathi wegama
Umphathi wegama angasetyenziselwa kokubili ukuchaza nokulawula amagama akhoyo. Itholakala ecaleni kwendlela yokuchaza igama kwifom yefomula yerbhoni.
Ukuchaza igama ngokusebenzisa uMlawuli wegama
Xa uchaza igama kuMphathi wegama livula ibhokisi yencoko yegama elitsha echazwe ngasentla. Uluhlu olupheleleyo lwamanyathelo:
- Cofa kwiThebhu yefomula yerbhoni.
- Cofa kwi icon yoMphathi wegama phakathi kwerbhoni ukuvula uMphathi wegama.
- KuMphathi wegama, nqakraza kwiqhosha elitsha ukuvula ibhokisi yencoko yegama elitsha.
- Kule bhokisi yencoko, kufuneka ukuba uchaze:
- Igama
- Ububanzi
- Ububanzi begama elitsha-izimvo zikhethiweyo
- Cofa ku- OK ukubuyela kuMlawuli wegama apho igama elitsha liza kubalwa kwifestile.
- Cofa Vala ukuze ubuyele kwiphepha lokusebenzela.
UkuCima okanye ukuGcina amagama
Ngomphathi wegama ovulekile,
- Kwifestile equle uluhlu lwamagama, nqakraza kanye ngeli gama ukuba lisuswe okanye lihlelwe.
- Ukucima igama, nqakraza kwi Cima iqhosha ngaphaya kwoluhlu lwewindow.
- Ukuhlela igama, nqakraza kwi Hlaziya iqhosha ukuvula ibhokisi yencoko yegama lokuHlela.
Kwibhokisi yencoko yebinki yeHlelo, unga:
- hlaziya igama.
- uhlele okanye ungeze ingxelo malunga negama.
- utshintshe ireferensi yebala lokufumana igama. Oku kunokwenziwa ngokugqamisa uluhlu olukhoyo kwibhokisi yencoko kwaye ukhetha uluhlu olutsha kwiphepha lokusebenzela ukuze litshintshe.
Qaphela: Ubuninzi begama elikhoyo alikwazi ukutshintshwa ngokusebenzisa iindlela zokuhlela. Ukutshintsha ububanzi, cima igama uze ulihlalutye ngokufanelekileyo.
Amagama okucoca
Inkinobho yokuhlunga kuMlawuli wegama yenza kube lula ukuba:
- fumana amagama ngamaphutha - njengoluhlu olungavumelekanga,
- misela ubungakanani begama-nokuba ngaba liphepha lomsebenzi okanye ibhuku lokusebenzela, kunye
- ukuhlunga kunye nokuhlunga izihlomelo zamagama ezichaziweyo (amanani) okanye amagama etafile.
Uluhlu olucacisiweyo luboniswa kwilisti yoluhlu kwiMenenja yegama.