Indlela yokuthuthukisa ukuhlonza iqembu noma block of cells
Ibanga iqembu noma block of cells kwiphepha lokusebenzela elakhethiwe noma eligqanyisiwe. Lapho amangqamuzana akhethiwe azungezwe uhlaka noma umngcele njengoba kuboniswe esithombeni kwesobunxele.
Ibanga lingabuye libe yiqembu noma livimbe izingqikithi zezingcingo ezingaba, isibonelo:
- ingene njengengxabano yomsebenzi.
- esetshenziselwa ukwakha igrafu.
- esetshenziselwa ukwakha amabhukimakhi kumininingwane ethize encwadini yokusebenzela .
Ngokuzenzakalelayo, lolu chungechunge noma umngcele uzungeza iseli elilodwa kuphela kusikripthi sokusebenza ngesikhathi, esaziwa njengeli cell esebenzayo . Izinguquko kukhasi lokusebenzela, njengokuhlela kwedatha noma ukufometha, ngokuzenzakalelayo, thinta iseli esebenzayo.
Uma uhla lwamakheli angaphezu kwesisodwa lukhethiwe, izinguquko kushidi lokusebenzela - ngezinye izinto ezifana nokufakwa kwedatha nokuhlela - kuthinta wonke amaseli ebangeni elikhethiwe.
Amathrekhi ahambisanayo futhi angelona iqiniso
Uhlu lwamangqamuzana oluthandayo luyiqoqo lamaseli aqakathekile aseduze komunye nomunye, afana nobubanzi C1 kuya eC5 oboniswe esithombeni esingenhla.
Uhlu olungelona oluhlangene luhlanganisa amabhlokhi amabili noma ngaphezulu ahlukene ngamaseli. Lezi zingqimba zingahlukaniswa ngemigqa noma amakholomu njengoba kuboniswe ngamabanga A1 kuya ku-A5 no-C1 kuya ku-C5.
Zombili izinhlangothi ezixubayo nezingezona ezithintekayo zingabandakanya amakhulu noma ngisho nezinkulungwane zamaseli kanye nokwenza ama-worksheet namabhuku okusebenzela.
Ukubiza i-Range
Imigqa ibaluleke kakhulu ku-Excel ne-Google Spreadsheets ukuthi amagama anganikezwa emaceleni athile ukuze kube lula ukusebenzisana nokusebenzisa kabusha uma ubhekisela kuzo izinto ezifana namashadi namafomula.
Ukukhetha i-Range ku-Worksheet
Kukhona izindlela eziningi zokukhetha ibanga kushidi lokusebenzela. Lokhu kufaka phakathi ukusebenzisa:
- igundane.
- ikhibhodi.
- Ibhokisi Legama ku-Excel.
- Inhlanganisela yalezi ezintathu.
Ibanga eliqukethe amaseli aseduze lingadalwa ngokuhudula ngegundane noma ngokusebenzisa inhlanganisela yeShift nezinkinobho ezine ze-Arrow ekhibhodi.
Amathanga ahlanganiswa namaseli angahambisani nawo angadalwa ngokusebenzisa igundane nekhibhodi noma nje ikhibhodi.
Ukukhetha i-Range Yokusetshenziswa ku-Formula noma Ishadi
Uma ufaka izinhlawulo zochungechunge lwezingcingo njengengxabano yomsebenzi noma uma udala ishadi, ngaphezu kokuthayipha ebangeni ngesandla, ibanga lingabuye likhethwe ngokukhomba.
Amangcele ahlonishwa yizikhombo zamaseli noma amakheli wamaseli ezingxenyeni ezingenhla ezingezansi kwesokunxele nangakwesokudla kobubanzi. Lezi zikhombisi ezimbili zihlukaniswe nge-colon (:) ezitshela i-Excel ukuthi ifake wonke amaseli phakathi kwala maphuzu okuqala nokuphela.
I-Range vs. I-Array
Ngezinye izikhathi imigomo yebala nobubanzi bubonakala sengathi busetshenziselwa ngokungafaniyo ku-Excel ne-Google Spreadsheets, ngoba kokubili imigomo ihlobene nokusetshenziswa kwamaseli amaningi ebhukwini noma ifayela.
Ukuze kuqondile, umehluko ukhona lokuthi ibanga libhekisela ekukhethweni noma ekukhonjisweni kwamaseli amaningi afana ne-A1: A5, kanti i-array ingabhekisela kumanani afakwe kulawo maseli njengokuthi {1; 2; 5; 4; ; 3}.
Ezinye imisebenzi - njenge-SUMPRODUCT kanye ne-INDEX zithatha izigaba njengezimpikiswano, kanti abanye - njengo-SUMIF no-COUNTIF bamukela amareythi kuphela wezingxabano.
Lokho akusho ukuthi uhla lwezinkomba ezingenakukwazi ukungena njengezingxabano ze-SUMPRODUCT ne-INDEX njengoba le nqubo ingakwazi ukukhipha amanani kusukela ebangeni bese ihumusha ibe yiqembu.
Isibonelo, amafomula
= SUMPRODUCT (A1: A5, C1: C5)
= SUMPRODUCT ({1; 2; 5; 4; 3}, {1; 4; 8; 2; 4})
bobabili babuyela umphumela we-69 njengoba kuboniswa emaqenjini E1 no-E2 esithombeni.
Ngakolunye uhlangothi, i-SUMIF no-COUNTIF abamukeli ama-arrays njengezingxabano. Ngakho, ngenkathi ifomula
= COUNTIF (A1: A5, "<4") kubuyisa impendulo ye-3 (iselula E3 esithombeni);
ifomula
= COUNTIF ({1; 2; 5; 4; 3}, "<4")
ayamukeliwe yi-Excel ngoba isebenzisa uhlu lwempikiswano. Ngenxa yalokho, uhlelo lubonisa uhlu lwebhokisi lomlayezo izinkinga ezikhona nezinkinga zokulungisa.