Indlela Yokuchaza Uhlobo Olubizwa Nge-Excel

Nikeza amagama achazayo kumaseli athile noma amabanga amaseli

Ububanzi obuqanjwe , igama lebanga , noma igama elichazwe konke libhekisela entweni efanayo ku-Excel. Igama elichazayo - njenge- Jan_Sales noma i- June_Precip - elinamathele esitokisini esithile noma ububanzi bamaseli ku-worksheet noma kubhuku lokusebenzela .

Izigaba ezibizwa ngokuthi kube lula ukusebenzisa futhi ukukhomba idatha uma udala amashadi , futhi ngamafomula afana nalokhu:

= SUM (Jan_Sales)

= Juni_ Isimo + July_ Isimo + Aug_ Isimo

Futhi, njengoba uhla olubizwa ngokuthi alinguye aluguquki lapho ifomula likopishwa kwamanye amaseli , linikeza okunye ekusebenziseni izingqikithi zeseli ngokuphelele ngamafomula.

Ukuchaza igama ku-Excel

Izindlela ezintathu ezahlukene zokuchaza igama ku-Excel yizi:

• Ukusebenzisa Ibhokisi Legama (leli khasi elingezansi)
• Ukusebenzisa ibhokisi lengxoxo yegama elisha
• Ukusebenzisa uMphathi Wegama

Ukuchaza Igama ngeBhokisi Legama

Enye indlela, futhi mhlawumbe indlela elula yokuchaza amagama usebenzisa iBhokisi Legama , elitholakala ngenhla kwekholomu A ekhasini lokusebenzela.

• Sebenzisa le ndlela ukwakha amagama ayingqayizivele avunyelwe yiwo wonke amashidi ebhukwini.

Ukwakha igama usebenzisa ibhokisi legama njengoba kuboniswa esithombeni ngenhla:

1. Qinisekisa ububanzi obufunayo bamaseli ekhasini lokusebenzela.
2. Thayipha igama elifunayo kulolo hlu ebhokisini legama, njenge- Jan_Sales.
3. Cindezela ukhiye wokungena kwikhibhodi.
4. Igama likhonjiswa ebhokisini legama.

Qaphela : Igama liphinde liboniswe ebhokisini legama noma ngabe ububanzi obufanayo beseli bugqanyisiwe ekhasini lokusebenzela. Iphinde iboniswe kuMphathi Wegama.

Ukubiza imithetho nemingcele

I- syntax eyinhloko ilawula ukukhumbula lapho ukudala noma ukuhlela amagama emigqa yilezi:

1. Igama alikwazi ukuqukatha izikhala.
2. Umlingisi wokuqala wegama kufanele ube
   • incwadi
   • qinisa (_)
   • ukubuyela emuva (\)
3. izinhlamvu ezisele zikhona kuphela
   • izinhlamvu noma izinombolo
   • izinkathi
   • qinisa izinhlamvu
4. Ubude obude begama yizinhlamvu ezingu-255.
5. Amagama aphezulu namancane angeke ahlukaniswe ku-Excel, ngakho-ke uJan_Sales kanye ne- jan_sales babonakala njengegama elifanayo nge-Excel.

Imithethonqubo yokuNgeza eyengeziwe yilezi:

• Ukubhekwa kwamaseli ngeke kusetshenziswe njengamagama afana ne-A25 noma i-R1C4.
• Amagama omlingisi owodwa avunyelwe ngaphandle kwe- "C", "c", "R", noma "r" ngoba axhunyaniswe nezinkomba zekholomu nezinqolobane ezifana ne- R1C4.

01 ngo-02

Amagama ahlongozwayo nobubanzi be-Excel

Wonke amagama anesilinganiso esibhekisela ezindaweni lapho igama elithile liqashelwa yi-Excel.

Ububanzi begama lungaba:

• ama- worksheet ngabanye - abizwa ngokuthi ububanzi bezinga lomsebenzi wendawo
• ibhuku eliphelele - ibanga lokusebenzela ibanga lomsebenzi jikelele

Igama kumele libe lihlukile ngaphakathi kwendawo yalo, kodwa igama elifanayo lingasetshenziswa ezihlokweni ezahlukene.

Qaphela : Izinga elizenzakalelayo lamagama amasha lizinga lokusebenzela lomhlaba jikelele. Uma kuchaziwe, ububanzi begama ngeke bushintshe kalula. Ukuze ushintshe ububanzi begama, susa igama kuMphathi Wegama bese uyihlenga ngokulingana okulungile.

Izinga Lendawo Yomsebenzi Wendawo Yendawo

Igama elinesilinganiso sezinga lokusebenzela livumelekile kuphela ishidi lokusebenzela elachazwe ngalo. Uma igama le- Total_Sales linomkhawulo weshidi 1 lencwadi , i-Excel ngeke ikwazi igama ekhasini 2, i-sheet 3, nanoma iyiphi enye ishidi ebhokisini lokusebenzela.

Lokhu kwenza ukwazi ukuchaza igama elifanayo lokusetshenziswa kumashidi amaningi okusebenza - uma nje ububanzi begama ngalinye bukhawulelwe kwiphepha elithile lomsebenzi.

Ukusebenzisa igama elifanayo lamashidi ahlukene kungenziwa ukuze kuqinisekiswe ukuthi ukuqhubeka phakathi kwama-worksheet nokuqinisekisa ukuthi amafomula asebenzisa igama elithi Total_Sales njalo libhekisela ebangeni elifanayo lamaseli ezincwadini eziningi zokusebenzela ngaphakathi kwincwadi eyodwa yokusebenzela.

Ukuhlukanisa phakathi kwamagama afanayo nama-different scopes emafomulini, phambili igama ngegama lomsebenzi, njengokuthi:

I-Sheet1! Total_Sales, iSheet2! Total_Sales

Qaphela: Amagama adalwe usebenzisa iBhokisi Legama uyohlale enesilinganiso sezinga lokusebenzela lomhlaba wonke ngaphandle kokuthi igama lombili leshidi kanye negama lebanga lifakwe ebhokisini legama uma igama lichazwa.

Isibonelo:
Igama: Jan_Sales, Ububanzi - izinga lokusebenzela lomhlaba wonke
Igama: Ishidi1! Jan_Sales, Ububanzi - izinga langaphakathi lokusebenzela

I-Global Workbook Level Scope

Igama elichazwe ngenani lezinga lokusebenzela liyabonakala kuwo wonke ama-worksheets kuleyo ncwadi yokusebenzela. Ngakho-ke igama lezinga lokusebenzela lingasetshenziswa kanye kuphela ngaphakathi kwebhuku lokusebenzela, ngokungafani namagama wezinga leshidi elixoxwe ngenhla.

Igama lomsebenzi wezinga lokusebenzela alikona, noma kunjalo, eliqashelwa yinoma yimuphi omunye ibhuku lokusebenzela, ngakho amagama wezinga lomhlaba wonke angaphinda aphindwe kumafayela ahlukile e-Excel. Isibonelo, uma igama le- Jan_Sales linemibandela yomhlaba jikelele, igama elifanayo lingasetshenziswa ezincwadini zomsebenzi ezahlukahlukene ezibizwa nge-2012_Revenue, 2013_Revenue, kanye no-2014_Revenue.

Ukuphikisana kobubanzi nobubanzi bokuqala

Kungenzeka ukuthi usebenzise igama elifanayo kokubili kwekhasi leshidi lendawo kanye nezinga lokusebenzela ngoba ububanzi bobabili buyohluka.

Isimo esinjalo, noma kunjalo, singadala ukungqubuzana noma kunini lapho igama lisetshenziswa khona.

Ukuze uxazululwe izinxabano ezinjalo, ku-Excel, amagama achazwe ngezinga lokusebenza lomsebenzi wendawo ahamba phambili ngaphezu kwezinga lokusebenzela lomhlaba jikelele.

Esimweni esinjalo, igama lezinga leshidi le- 2014_Revenue lingasetshenziswa esikhundleni segama lezinga lokusebenzela le- 2014_Revenue .

Ukuze ukwedlulele ukubusa kokuqala, sebenzisa igama lezinga lezincwadi ngokubambisana negama elithile lezitifiketi elifana ne- 2014_Revenue! Ishidi1.

Okuhlukile kokungaphezu kokuqala kuqala igama lezinga lokusebenzela lomsebenzi eliphethe ububanzi beshidi 1 lencwadi yokusebenzela. Ama-Scopes ahlanganiswe neshidi 1 yanoma iyiphi incwadi yokusebenzela ayinakugqithiswa ngamagama ezingeni lezwe.

02 ka 02

Ukuchaza nokuphatha amagama aneMenenja Yegama

Ukusebenzisa ibhokisi le- New Name Dialog

Indlela yesibili yokuchaza amagama ukusebenzisa ibhokisi lengxoxo yegama elisha . Leli bhokisi lebhokisi livuliwe besebenzisa inketho yegama elichaza igama eliphakathi kwethebhu yefomu yebhebhoni .

Ibhokisi le-New Name lengxoxo yenza kube lula ukuchaza amagama anezinga lezinga lokusebenzela.

Ukwakha igama usebenzisa i-New Name ibhokisi lengxoxo

1. Qinisekisa ububanzi obufunayo bamaseli ekhasini lokusebenzela.
2. Chofoza kuthebhu yefomathi yebhande.
3. Chofoza ku-Chofoza Igama Lwegama ukuvula ibhokisi lengxoxo yegama elisha.
4. Ebhokisini lengxoxo, kudingeka uhlenge:
   • Igama
   • Ububanzi
   • Uhlobo lwamagama amasha - amazwana angakhetha
5. Uma usuqedile, chofoza u-Kulungile ukuze ubuyele ekhasini lokusebenzela.
6. Igama lizoboniswa eBhokisini Legama noma nini lapho uhla oluchazwe lukhethiwe.

Umphathi Wegama

Umphathi Wegama angasetshenziswa kokubili ukuchaza nokuphatha amagama akhona. Itholakala eduze kwenketho yegama elichaza igama kwithebhu yefomu yebhebhoni.

Ukuchaza Igama usebenzisa iMenenja Yegama

Uma uchaza igama kuMphathi Wegama livula ibhokisi lengxoxo yegama elisha elichazwe ngenhla. Uhlu oluphelele lwezinyathelo:

1. Chofoza ithebhu yefomu yebhebhoni.
2. Chofoza ku-Isithonjana seMenenja Yegama phakathi kwebhebhoni ukuvula uMphathi Wegama.
3. KuMphathi Wegama, chofoza inkinobho entsha ukuvula ibhokisi lengxoxo yegama elisha.
4. Kulo bhokisi lebhokisi, kudingeka uhlenge:
   • Igama
   • Ububanzi
   • Uhlobo lwamagama amasha - amazwana angakhetha
5. Chofoza OK ukuze ubuyele kumphathi wegama lapho igama elisha lizofakwa ohlwini ewindini.
6. Chofoza Vala ukuze ubuyele ekhasini lokusebenzela.

Ukususa noma Ukuhlela Amagama

Njengoba uMphathi Wegama evulekile,

1. Ewindini equkethe uhlu lwamagama, chofoza kanye ngegama ukuze lisuswe noma lihlelwe.
2. Ukuze ususe igama, chofoza inkinobho yokususa ngenhla kwewindi lamagama.
3. Ukuze uhlele igama, chofoza inkinobho yokuhlela ukuvula ibhokisi lengxoxo ye- Hlela igama .

Ebhokisini lebhokisi le-Hlela Igama, unga:

• hlela igama.
• hlela noma ungeze amazwana mayelana negama.
• shintsha ireferensi yezinhla zegama. Lokhu kungenziwa ngokugqamisa ibanga elikhona ebhokisini lengxoxo bese ukhetha uhla olusha kuphepha lokusebenzela ukuze ulithathe esikhundleni.

Qaphela: Ububanzi begama elikhona alikwazi ukuguqulwa ngokusebenzisa izinketho zokuhlela. Ukuze ushintshe ububanzi, susa igama bese ulihlenga kabusha ngokulingana okulungile.

Ukuhlunga amagama

Inkinobho Yokuhlunga kuMphathi Wegama yenza kube lula ukuthi:

• thola amagama aneziphambeko - njengohlu olungavumelekile,
• thola ububanzi begama - kungakhathaliseki ukuthi yiliphi izinga lokusebenzela noma ibhuku lokusebenzela, futhi
• hlela futhi uhlunge amagama ohlwini - amagama achazwe (ububanzi) amagama noma amathebula.

Uhla oluhlungiwe luboniswa efasiteleni lohlu kuMphathi Wegama.