Indlela yokuphucula ukuchongwa kweqela okanye ibhloko yeeseli
Uluhlu liqela okanye ibloko leeseli kwiphepha lokusebenzela elikhethiweyo okanye eligqityiweyo. Xa iiseli zikhethiweyo zijikelezwe ngumhlathi okanye umda njengoko kuboniswa kumfanekiso ngakwesobunxele.
Uluhlu lukwaba liqela okanye ibhloko yeenkcukacha ezikhoyo, ngokomzekelo:
- wangena njengengxabano yomsebenzi.
- tyenziswa ukudala igrafu.
- esetyenziselwa ukudala amabhukumaka kwiinkcukacha ezithile kwiincwadi zokusebenzela .
Ngokungagqibekanga, lo mphahla okanye umda ujikeleza iseli enye kuphela kwiphepha lokusebenzela ngexesha, elibizwa ngokuba yiseli esebenzayo . Utshintsho kwiphepha lokusebenzela, njengokuhlela kwedatha okanye ukufometha, ngokuzenzekelayo, thintela iseli esebenzayo.
Xa ukhetho lweeteksi enye lukhethiweyo, utshintsho kwiphepha lokusebenzela - ngezinye izinto ezifana nokungena kwedatha nokuhlela - zichaphazela zonke iiseli kwindawo ekhethiweyo.
IiRanges eziHlangeneyo kunye ezingekho phantsi
Uluhlu oluthile lweeseli liqela leeseli eziqakathekileyo ezikufutshane, njengoluhlu lwe C1 ukuya ku-C5 luboniswe kumfanekiso ongentla.
Ibanga elingelona luthintelo liqukethe amabhloko amabini okanye ahlukeneyo eeseli. Ezi zibhloko zingahlukaniswa ngemigca okanye iikholomu njengoko kuboniswe ngamanqanaba A1 ukuya ku-A5 no-C1 ukuya ku-C5.
Zomibini zidibanisa kunye ezingenakuzibandakanya zingabandakanya amakhulu okanye amawaka eeseli kunye nokusabalalisa ama-worksheets kunye neencwadi zokusebenzela.
Ukubiza iNqanaba
Iingcingo zibaluleke kakhulu kwi-Excel kunye ne-Google Spreadsheets ukuba amagama anikezelwa kumacandelo athile ukwenzela ukuba kube lula ukusebenza kunye nokusebenzisa kwakhona xa kubhekiselwa kuzo izinto ezifana neeshadi kunye namafomula.
Ukukhetha Uhlu kwiShishini lokuSebenza
Kukho iindlela ezininzi zokukhetha uluhlu kwiphepha lokusebenzela. Ezi ziquka ukusebenzisa:
- mouse.
- ikhibhodi.
- Ibhokisi legama kwi-Excel.
- Ukuhlanganiswa kwezi zintathu.
Uluhlu olubandakanya iiseli eziseduze lunokudalwa ngokugqithisa nge mouse okanye ngokusebenzisa umxube weShift kunye neentshini ezine ze-Arrow kwikhibhodi.
Amangqamu aqulethwe ngamaseli angaqhelekanga angadalwa ngokusebenzisa mouse kunye nekhibhodi okanye nje ikhibhodi.
Ukukhetha Uhlobo lokuSebenza kwiFomula okanye kwiTyrt
Xa ufaka uluhlu lweenkcukacha zeeseli njengengxabano yomsebenzi okanye xa udala ishati, ngaphezu kokuthayipha kwimiba ngesandla, uluhlu lungaphinda lukhethwe ngokusebenzisa ukukhomba.
Amangqa afunyenwe ngetekisi zeeseli okanye iilesi zeeseli kumacangci angentla asekunene nakwinqanaba elincinane leloluhlu. Ezi zihlandlo ezimbini zihlukaniswe ngekholoni (:) exelela i-Excel ukuba ifake onke amaseli phakathi kwezi ndawo zokuqala nezokugqibela.
Ibanga elijongene neMarray
Ngamanye amaxesha ububanzi kunye nemigangatho ibonakala iyasetyenziswa ngokungafaniyo kwi-Excel kunye ne-Google Spreadsheets, ekubeni zombini imiqathango inxulumene nokusetyenziswa kweeseli ezininzi kwincwadi okanye incwadi.
Ukuchaneka, ulwahlulo lukwimeko yokuba uluhlu lubhekiselele ekukhetheni okanye ukuchongwa kwamaseli amaninzi afana ne-A1: A5, kanti iqela liza kubhekisela kwiimpawu ezikuloo maseli ezifana {1; 2; 5; 4; ; 3}.
Eminye imisebenzi - njenge-SUMPRODUCT kunye ne-INDEX ithatha imirhumo njengeengxabano, kanti abanye-njengo-SUMIF kunye ne-COUNTIF bayamkela iindawo ezizahlukileyo kuphela.
Oko akuthethi ukuba uluhlu lweeferensi zeeseli alinakungeniswa njengeengxabano ze-SUMPRODUCT kunye ne-INDEX njengoko le misebenzi inokukhupha ixabiso kwi-range kwaye iguqulele kwi-array.
Umzekelo, iifomula
= I-SUMPRODUCT (A1: A5, C1: C5)
= I-SUMPRODUCT ({1; 2; 5; 4; 3}, {1; 4; 8; 2; 4})
Bobabini babuyela umphumo we-69 njengoko kuboniswe kwiiseli E1 no-E2 kumfanekiso.
Ngakolunye uhlangothi, i-SUMIF kunye ne-COUNTIF ayamkeli i-arrays njengeengxabano. Ngoko, ngelixa i-formula
= COUNTIF (A1: A5, "<4") ubuyisela impendulo ye-3 (iselula E3 kumfanekiso);
ifom
= COUNTIF ({1; 2; 5; 4; 3}, "<4")
ayamkelwe yi-Excel kuba isebenzisa uluhlu lweengxabano. Ngenxa yoko, le nkqubo ibonisa ibhokisi lomyalezo kubonisa iingxaki kunye nezilungiso.