Ngaphakathi kumandla okusebenzisa i-Excel, akufuneki sinikele ingqalelo kuphela kwizibalo njengendawo ephambili yesixhobo, kodwa nakwifomathi. Ifomathi yencwadi yethu iya kusivumela ukuba siyenze ibe nomtsalane ngakumbi, kulula ukuyifunda kunye nokuhlalutya, oko, ngokuqinisekileyo, kuphumela kwiphepha eliluncedo kakhulu kunelinye elicacileyo. Phakathi kwemisebenzi esiyenzayo kulo mba, kukudibanisa iiseli ezimbini okanye ngaphezulu kwi-Excel, into eya kusivumela ukuba sandise indawo yazo ukuze sibonise kakuhle ulwazi oluqulethweyo.. Ngokukwanjalo, iya kusinika ithuba lokongeza izihloko kunye neeheda, zizenze zibukeke zingcono kakhulu kunokuba ngaphandle kokudibanisa iiseli.
Ukuba unomdla kolu khetho, ke qhubeka ufunda kuba apha ngezantsi siza kukubonisa yonke into oyifunayo ukuze usebenzise olu khetho ukuze uphucule ukubonakala kunye nokuhanjiswa kolwazi kwiiseli zespredishithi sakho.
Kuthetha ukuthini ukudibanisa iiseli ezimbini okanye ngaphezulu kwi-Excel?
Xa sivula uxwebhu lwe-Excel sibona ukuba lwenziwe ngeeseli, oko kukuthi, izithuba ngaphakathi kwephepha apho sinokongeza ulwazi. Ezi seli, zona, zenza imiqolo kunye neentanga zazo ngokuthe tye kunye nezahlulo ezo zimi ngokuthe nkqo. Dibanisa iiseli lukhetho olunikezelwa yinkqubo ngenjongo yokudibanisa izithuba zeeseli ezimbini kwenye. Nangona kunjalo, kufuneka sigxininise ukuba oku kunokwenzeka kuphela ngemigca, oko kukuthi, iiseli ezikufutshane.
Uncedo lwalo msebenzi lulele kwinto yokuba inikezela ngokupheleleyo naluphi na ulwazi olungajongeki lungcono kwiseli enye.. Umzekelo, ukuba ufuna ukongeza isihloko kwidatha ekwiphepha lakho, ngokuqinisekileyo ukwandiswa kwayo akuyi kungena kwiseli, ngoko ke ukuyidibanisa noku kulandelayo kuya kusinika ithuba lokubonisa isicatshulwa esipheleleyo.
Amanyathelo okudibanisa iiseli
Inkqubo yokudibanisa iiseli kwi-Excel ilula kakhulu kwaye zonke iinketho ezinxulumeneyo zibekwe kwimenyu efanayo. Ngaloo ndlela, kuya kuba ngokwaneleyo ukuya kuyo ukwenza umanyano lweeseli ezimbini okanye ngaphezulu kwimizuzwana.
Ukudibanisa naliphi na inani leeseli, kufuneka silandele amanyathelo esiwabonisa apha ngezantsi:
- Khetha iiseli ekuthethwa ngazo.
- Nqakraza kwinketho yesithubaHlanganisa kunye neziko»ukusuka kwimenyu yokuqala.
Oku kuya kubonisa iinketho ezi-4:
- Hlanganisa kunye neziko: Ngolu khetho ungadibanisa iiseli ozifunayo kwaye unike ulungelelwaniso olusembindini kumxholo owuvezayo.
- Dibanisa ngokuthe tye: Idibanisa iiseli ezikhethiweyo kumqolo omnye kwiseli enye enkulu.
- Hlanganisa iiseli: Lukhetho olungagqibekanga kwaye inoxanduva lokudibanisa iiseli ozikhethe ngaphambili.
- Iiseli ezahlukeneyo: ngolu khetho ungahlehlisa naluphi na umanyano lweeseli ngonqakrazo olunye.
Kwelinye icala, kubalulekile ukuqaqambisa ukuba kukho enye indlela enokuba lula kubasebenzisi abaninzi. Oku akukho nto ngaphandle kokukhetha iiseli ofuna ukuzidibanisa, ukucofa ekunene kwaye ngoko nangoko imenyu yemeko kunye nemenyu ekhawulezayo yefomathi iya kuvela apho uya kubona i icon "Hlanganisa kunye neziko«. Ukuyinqakraza kuzakudibanisa iiseli ezikhethiweyo.
Isiphelo
Ngale ndlela, unokuqalisa ukunika usasazo olungcono kwidatha ekwispredishithi sakho kwaye wongeze izihloko okanye idatha egqityiweyo kwaye ibekwe kakuhle ngaphakathi kwiseli.. Ukudibanisa iiseli ngomnye wale misebenzi yemihla ngemihla ekufuneka wonke umsebenzisi we-Excel ayazi kwaye eya kukuvumela ukuba uphucule iziphumo zakho ngendlela elula.
Ukukwazi ukudibanisa iiseli kwi-Excel sisixhobo esibalulekileyo kuye nabani na osebenza ngedatha kwaye kufuneka afomethe kwaye ahlele ulwazi ngokucacileyo nangempumelelo.. Nangona kungumsebenzi olula ngokufanelekileyo, ukudityaniswa kweeseli kunokuphucula kakhulu unikezelo lwedatha yakho, iyenze ifundeke ngakumbi kwaye kulula ukuyiqonda. Lo ngumba osisiseko wempumelelo yayo nayiphi na ingxelo esiyinikezelayo sisebenzisa i-Excel njengesixhobo esiphambili.
Kubalulekile ukuqwalasela ukuba, xa udibanisa iiseli, ulwazi oluqulethwe ekuqaleni lulahlekile, ngoko sincoma ukusebenzisa lo msebenzi, ngokuqaphela malunga nedatha.. Kwakhona, kubalulekile ukukhetha uhlobo olululo lokudityaniswa kwimeko nganye, ngokuxhomekeke kubume be-spreadsheet kunye nento esifuna ukuyenza ngeeseli esizikhethayo.
Njengoko sele sibonile, i-Excel ibonelela ngeendlela ezahlukeneyo ukusuka ku-"Dibanisa kunye neZiko" umsebenzi kwaye nganye ijolise ekunikezeni iziphumo ezihlengahlengisiweyo kwimeko nganye. Nangona kunjalo, kuyaphawuleka ukuba le nkqubo ibonelela ngeendlela ezahlukeneyo zokufikelela kwinjongo efanayo kwaye kunokwenzeka ukwenza oku ngeefomula. Nangona kunjalo, eyona ndlela ilula nefikelelekayo esinayo yile siyibone apha.