Iyini Ibhokisi Legama futhi Ngingayisebenzisa Kanjani ku-Excel?
Ibhokisi Legama litholakala eduze kwebha yefomula ngaphezu kwendawo yokusebenzela njengoba kuboniswe esithombeni kwesobunxele.
Ubukhulu beBhokisi Legama lingaguqulwa ngokuchofoza ku-ellipses (amachashazi amathathu aqondile) aphakathi kweBhokisi Legama kanye nebha yefomu njengoba kuboniswa esithombeni.
Nakuba umsebenzi wayo ovamile ukubonisa iseli yeseli yeselula esebenzayo - chofoza ku-cell D15 ekhasini lokusebenzela nokuthi ukubhekisela kweseli kuboniswa eBhokisini Legama - lingasetshenziswa kakhulu kungase kube nezinye izinto ezifana nalezi:
- ukuqamba amagama nokuhlukanisa amaseli akhethiwe noma ezinye izinto;
- ukhethe eyodwa noma ngaphezulu amabanga amaseli kwiphepha lokusebenzela;
- ukuhamba kumaseli ahlukene ku-worksheet noma kubhuku lokusebenzela.
Ukuqamba amagama kanye nokukhomba ama-cell Ranges
Ukuchaza igama lwamaseli amaningi kungenza kube lula ukuyisebenzisa futhi ubheke lezo zigaba ngamafomula namashadi futhi kungenza kube lula ukukhetha lolo hlu ngeBhokisi Legama.
Ukuchaza igama lebanga usebenzisa iBhokisi Legama:
- Chofoza esitokisini kwiphepha lokusebenzela - njenge-B2;
- Thayipha igama - njenge- TaxRate;
- Cindezela ukhiye wokungena kwikhibhodi.
Iseli ye-B2 manje inegama le- TaxRate . Noma nini lapho i-cell B2 ikhethiwe kuphepha lokusebenzela , igama elithi TaxRate likhonjiswa ebhokisini legama.
Khetha uhla lwamaseli kunokuba olulodwa, futhi igama lonke lizonikwa igama elifakwe ebhokisini legama.
Amagama anamazinga angaphezu kwesisodwa, wonke uhla kufanele akhethwe ngaphambi kokuthi igama livele ebhokisini legama.
3R x 2C
Njengoba uhla lwamaseli amaningi lukhethiwe esikhwameni somsebenzi, usebenzisa i-mouse noma iShift + imicibisholo ekhibhodi, iBhokisi Legama libonisa inani lamakholomu nemigqa ekukhetheni kwamanje - njengama-3R x 2C - emigqa emithathu ngamakholomu amabili.
Uma inkinobho yegundane noma ukhiye we- Shift ukhululiwe, Ibhokisi Legama liphinde libonise ireferensi yeseli esebenzayo - okuzoba yilali yokuqala ekhethiwe ebangeni.
Ukubiza Amashadi Nezithombe
Noma nini ishadi noma ezinye izinto - njengezinkinobho noma izithombe - zengezwe ephepheni lokusebenzela, zanikeza ngokuzenzakalelayo igama ngohlelo. Ishadi lokuqala elifakiwe libizwa ngokuthi iThart 1 ngokuzenzakalelayo, nesithombe sokuqala: Isithombe 1.
Uma ishidi lokusebenzela liqukethe izinto ezinjalo, amagama avame ukuchazwa ukuba akwenze kube lula ukuwasebenzisa - futhi usebenzisa iBhokisi Legama.
Ukuqamba kabusha lezi zinto kungenziwa ngeBhokisi Legama usebenzisa izinyathelo ezifanayo ezisetshenziselwa ukuchaza igama lamaseli amaningi:
- Chofoza eshadini noma esithombeni;
- Thayipha igama egameni lebhokisi;
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela inqubo.
Ukukhetha ama-Ranges ngamagama
Ibhokisi Legama lingasetshenziselwa ukukhetha noma ukugqamisa izigaba zamaseli - usebenzisa amagama achaziwe noma ngokuthayipha ububanzi bezinkomba.
Thayipha ibanga elichazwe kwiBhokisi Legama kanye ne-Excel lizokhetha lelo banga kushidi lokusebenzela kwakho.
Ibhokisi Legama linalo uhlu olwehlisiwe oluhambisana nalo lonke ulwazi oluye lwachazwa kwiphepha lokusebenzela lamanje. Khetha igama kulolu hlu futhi i-Excel izophinde ikhethe ibanga elifanele
Lesi sici seBhokisi Legama senza kube lula ukukhetha uhla olufanele ngaphambi kokwenza imisebenzi yokuhlela noma ngaphambi kokusebenzisa imisebenzi ethile efana ne-VLOOKUP, efuna ukusetshenziswa kwebanga elikhethiwe lwedatha.
Ukukhetha ama-Ranges namaReferensi
Ukukhetha amaseli ngabanye noma ibanga elisebenzisa iBhokisi Legama ngokuvamile liyenziwa njengesinyathelo sokuqala ekuchazeni igama lobubanzi.
Iseli ngayinye ingakhethwa ngokuthayipha ireferensi yeseli yayo kwiBhokisi Legama bese ucindezela ukhiye wokungena kwikhibhodi.
Uhlu oluxubile (akukho amafulethi ebangeni) lamaseli angagcizelela ngokusebenzisa iBhokisi Legama ngu:
- Ukuchofoza esitokisini sokuqala ebangeni negundane ukwenza kube iseli elisebenzayo - njenge-B3;
- Ukuthayipha ireferensi yeselula yokugcina ebangeni ebhokisini legama - njenge-E6;
- Ucindezela okhiye be- Shift + Enter ekhibhodi
Umphumela uzoba ukuthi wonke amaseli ebangeni B3: E6 agcizelelwe.
Ranges amaningi
Izigaba eziningi zingakhethwa kuphepha lokusebenzela ngokuzifaka ebhokisini legama:
- ukuthayipha i-D1: D15, F1: F15 ebhokisini legama kuzogqamisa amaseli ayishumi nanhlanu okuqala kumakholomu D no-F;
- ukuthayipha i-A4: F4, A8: F8 izogqamisa amaseli ayisithupha okuqala emigqeni amane nesishiyagalombili;
- ukuthayipha i-D1: D15, A4: F4 izogqamisa amaseli ayishumi nanhlanu okuqala kukholomu D namaseli ayisithupha okuqala emgqeni amane.
Ama-Intersecting Ranges
Ukuhluka kokukhetha amareyimu amaningi kuzokukhetha kuphela ingxenye yamabanga amabili ahlangene. Lokhu kwenziwa ngokuhlukanisa izigaba ezikhonjisiwe eBhokisini Legama ngesikhala esikhundleni se-comma. Ngokwesibonelo,
- ukuthayipha i-D1: I-D15 A4: F12 ebhokisini legama izogqamisa ububanzi bamaseli D4: D12 - amaseli avamile kuwo wonke amabanga.
Qaphela : Uma amagama echazwe ngamabanga angenhla, lawa angase asetshenziswe esikhundleni sezingqikithi zeseli.
Isibonelo, uma uhla lwe-D1: D15 lubizwa ngokuthi yi- test kanye nobubanzi F1: F15 okuthiwa test2 , ukuthayipha:
- ukuhlolwa, test2 eBhokisini legama kuzogqamisa imigqa D1: D15 no F1: F15
Amakholomu Aphelele noma Imigqa
Amakholomu noma imigqa enhle ingabuye ikhethwe ngokusebenzisa iBhokisi Legama, uma nje liphakathi komunye nomunye:
- Ukuthayipha B: D ebhokisini legama ligcizelela zonke izingoli kumakholomu B, C, no-D,
- ukuthayipha 2: 4 ukhetha wonke amaselula kumigqa 2, 3, no-4.
Ukuzulazula Iphepha Lokusebenza
Ukushintsha kokukhethwa kwamaseli ngokuthayipha ireferensi yabo noma igama elichazwe ebhokisini legama ukusebenzisa izinyathelo ezifanayo ukuhamba esitokisini noma ibanga ekhasini lokusebenzela.
Ngokwesibonelo:
- Thayipha i-reference yeZ345 ebhokisini legama;
- Cindezela ukhiye wokungena kwikhibhodi;
futhi ukugqama kweselula okusebenzayo kuqhuma kuseli le-Z345.
Le ndlela ivame ukusebenza emafishini amakhulu njengoba igcina isikhathi sokudlula phansi noma phakathi kwamashumi noma ngisho namakhulu emigqa noma amakholomu.
Kodwa-ke, njengoba kungekho isinqamuleli sekhibhodi esizenzakalelayo sokubeka iphuzu lokufaka (umugqa okhanyayo) ngaphakathi kweBhokisi Legama, indlela esheshayo, ephumelela imiphumela efanayo ukucindezela:
F5 noma Ctrl + G ekhibhodi ukuletha ibhokisi lebhokisi le- GoTo .
Ukuthayipha ireferensi yeseli noma igama elichazwe kuleli bhokisi futhi ucindezela ukhiye wokungena kwikhibhodi kuzokuyisa endaweni oyifunayo.