Kwesinye isikhathi kuba nesidingo sokuthola ukuthi zingaki izinhlamvu eziqukethwe esitokisini esithile. Vele, ungamane ubalwe ngesandla, kepha kuthiwani uma kunezakhi eziningi nokubalwa okufanele kwenziwe ngokushintsha okuqukethwe njalo ngezinjongo ezithile? Ake sibheke ukuthi singabala kanjani inani lezinhlamvu ezise-Excel.
Ukubalwa kwezinhlamvu
Ukubalwa kwezinhlamvu ku-Excel kunomsebenzi okhethekile obizwa I-DLSTR. Ngosizo lwayo ukuthi ungafingqa izinhlamvu entweni ethile yeshidi. Kunezindlela eziningana zokuyisebenzisa.
Indlela yoku-1: Ukubala Abalingiswa
Ukuze ubale zonke izinhlamvu ezitholakala esitokisini, sisebenzisa umsebenzi I-DLSTRukukhuluma, "ngesimo esimsulwa."
- Khetha into eshidi lapho umphumela wokubala uzokhonjiswa khona. Chofoza inkinobho "Faka umsebenzi"phezulu kwesiwindi kwesobunxele sebha yefomula.
- Umsebenzi wizard uqala. Sifuna igama kulo I-DLSTR bese uchofoza inkinobho "Kulungile".
- Ukulandela lokhu, iwindi lokuphikisana liyavula. Lo msebenzi unempikiswano eyodwa kuphela - ikheli leseli elithile. Ngaphezu kwalokho, kufanele kuphawulwe ukuthi, ngokungafani nabanye opharetha abaningi, lokhu akusekeli ukungena kwezixhumanisi kumaseli amaningana noma kumalungu afanayo. Ensimini "Umbhalo" ngesandla faka ikheli lezinto ofuna ukubala kuzo izinhlamvu. Kungenziwa ngokuhlukile, okuzoba lula kubasebenzisi. Sibeka isikhombisi enkundleni yezimpikiswano bese simane sichofoza endaweni oyifunayo ekhasini. Ngemuva kwalokho, ikheli lakhe lizovela enkundleni. Lapho idatha ifakiwe, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalokhu, umphumela wokubala inani lezinhlamvu uboniswa esikrinini.
Indlela 2: bala izinhlamvu kwikholamu
Ukuze ubale inani lezinhlamvu kwikholamu noma kunoma yiluphi olunye uhla lwedatha, akudingekile ukunquma ifomula yeseli ngalinye ngokwehlukana.
- Singena ekhoneni elingezansi kweseli ngefomula. Umaka wokukhethwa uyavela. Bamba inkinobho yegundane kwesobunxele bese uyihudula ngokufana nendawo lapho sifuna ukubala khona inani lezinhlamvu.
- Ifomula ikopishelwa kulo lonke uhla. Umphumela ubonakala ngokushesha kweshidi.
Isifundo: Ungayenza kanjani ngokuzenzakalela i-Excel
Indlela 3: ukubalwa kwezinhlamvu kumaseli amaningi kusetshenziswa amanani azenzakalelayo
Njengoba kushiwo ngenhla, impikiswano yenethiwekhi I-DLSTR izixhumanisi zodwa zeseli eyodwa zingavela. Kepha kuthiwani uma udinga ukubala inani eliphelele lezinhlamvu kweziningana zazo? Kulokhu, kulula kakhulu ukusebenzisa umsebenzi we-auto-sum.
- Sibala inani lezinhlamvu zeseli ngalinye, njengoba kuchaziwe kuhlobo lwangaphambilini.
- Khetha ibanga lapho inani lezinhlamvu likhonjisiwe, bese uchofoza inkinobho "Inani"etholakala kuthebhu "Ikhaya" kwibhlokhi yezilungiselelo "Ukuhlela".
- Ngemuva kwalokho, inani eliphelele lezinhlamvu kuzo zonke izinto lizoboniswa kuseli elihlukile eceleni kobubanzi bokukhetha.
Isifundo: Ungayibala kanjani inani ku-Excel
Indlela 4: bala izinhlamvu kumaseli amaningi usebenzisa umsebenzi
Ngendlela engenhla, udinga ukubala masinyane into ngayinye ngokwehlukile bese ubala inani eliphelele lezinhlamvu kuwo wonke amaseli. Kepha kukhona futhi inketho lapho kuzobalwa khona konke kuzibalo zazo. Kulokhu, udinga ukufaka ifomula eyinkimbinkimbi usebenzisa opharetha ISUM.
- Khetha into eshidi lapho umphumela uzokhonjiswa khona. Sifaka ifomula kuyo ngokuya ngesifanekiso:
= SUM (DLSTR (cell_address1); DLSTR (cell_address2); ...) - Ngemuva komsebenzi namakheli awo wonke amaseli, kufakwa inombolo yezinhlamvu ofuna ukuzibala, chofoza inkinobho ENTER. Ingqikithi yezinhlamvu ibonisiwe.
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokubala inani lezinhlamvu eziseleni ngalinye, kanye nenombolo ephelele yezinhlamvu kuzo zonke izakhi zobubanzi. Kulelo nalezi ongakhetha kuzo, lo msebenzi wenziwa kusetshenziswa umsebenzi I-DLSTR.
