Uma usebenzisa uhlobo olufanayo lwedatha olubekwe ematafuleni ahlukene, amashidi, noma ngisho nezincwadi, ukuze kube lula kokubona kungcono ukuqoqa ulwazi ndawonye. Ku-Microsoft Excel ungabhekana nalolu msebenzi ngosizo lwethuluzi elikhethekile elibizwa ngokuthi "Ukuhlanganiswa". Ihlinzeka ikhono lokuqoqa idatha engafani etafuleni elilodwa. Ake sithole ukuthi lokhu kwenziwa kanjani.
Imibandela yenqubo yokuhlanganiswa
Ngokwemvelo, akuwona wonke amatafula angahlanganiswa abe munye, kodwa kuphela lawo ahlangabezana nezimo ezithile:
- amakholomu kuwo wonke amatafula kufanele abe negama elifanayo (ukulungiswa kabusha kwamakholomu kuphela kuvunyelwe);
- akufanele kube khona amakholomu noma imigqa ngamanani angenalutho;
- Amaphethini wethebula kufanele abe okufanayo.
Ukudala ithebula elihlanganisiwe
Cabanga indlela yokwakha itafula elihlanganisiwe ngesibonelo samathebula amathathu anesifanekiso esifanayo nesakhiwo sedatha. Ngamunye wabo usetsheni elihlukile, nakuba usebenzisa i-algorithm efanayo ungakha itafula elihlanganisiwe lemininingwane elisezincwadini ezahlukene (amafayela).
- Vula ishidi elihlukile kwetafula elihlanganisiwe.
- Esikhathini seshidi elivulwe, phawula iseli, okuyinto ezoba iseli eliphezulu ngakwesokunxele kwetafula elisha.
- Ukuba ngaphakathi kuthebhu "Idatha" chofoza inkinobho "Ukuhlanganiswa"okuyinto itholakala ku-tape ebhodini lamathuluzi "Ukusebenza nedatha".
- Iwindi yokuhlela idatha yokuhlanganiswa ivula.
Ensimini "Umsebenzi" kuyadingeka ukusungula ukuthi yisiphi isenzo ngamaseli azokwenziwa ngokungahambi kahle kwemigqa namakholomu. Lezi zingaba okulandelayo:
- inani;
- ubungako;
- isilinganiso;
- esiphezulu;
- ubuncane;
- umsebenzi;
- inombolo yezinombolo;
- ukuphambuka kokukhipha;
- ukuphambuka okungakhethi;
- ukuhlakazeka kwe-offset;
- ukuhlakazeka okungakhethi.
Ezimweni eziningi, umsebenzi usetshenziswa "Inani".
- Ensimini "Xhumanisa" sikhombisa ububanzi bamaseli weyodwa yamatafula okuqala azohlanganiswa. Uma lolu hlu lufayili efanayo, kodwa kwelinye ishidi, cindezela inkinobho, elitholakala ngakwesokudla kwenkambu yokungena kwedatha.
- Iya ekhasini lapho ithebula likhona khona, khetha uhla olufunayo. Ngemva kokufaka idatha, chofoza futhi inkinobho ekhona ngakwesokudla kwensimu lapho ikheli leseli langena khona.
- Ukubuyela efasiteleni lesethingi lokuhlanganisa ukuze ungeze amaseli esivele akhethiwe ohlwini lwamabanga, chofoza inkinobho "Engeza".
Njengoba ungabona, ngemuva kwalolu hlu kuhlanganiswa ohlwini.
Ngokufanayo, sengeza zonke ezinye izigaba ezizobandakanyeka kwinqubo yokuhlanganiswa kwedatha.
Uma ibanga elifunayo likhona kwenye incwadi (ifayela), bese uchofoza ngokushesha inkinobho "Buyekeza ...", khetha ifayela kwi-disk eyinkimbinkimbi noma imithombo ekhishwayo, bese kamuva ukhetha ububanzi bamaseli kuleli fayela usebenzisa indlela engenhla. Ngokwemvelo, ifayela kufanele livuleke.
- Ngokufanayo, ungenza ezinye izilungiselelo zetafula elihlanganisiwe.
Ukuze wengeze ngokuzenzakalelayo igama lamakholomu esihlokweni, faka umaki eduze kwepharamitha "Izimpawu zomugqa ophezulu". Ukuze wenze ukufingqwa kwedatha kusethe uphawu eduze kwepharamitha "Izimiso zesilondolozi sesobunxele". Uma ufuna ukuvuselela yonke idatha kuthebula elihlanganisiwe kanye nokubuyekeza idatha kumatafula okuqala, kufanele uhlole ibhokisi eliseduze "Dala izixhumanisi ukuze uthole idatha yomthombo". Kodwa, kulokhu, udinga ukucabangela ukuthi uma ufuna ukwengeza imigqa emisha etafuleni langempela, kuzodingeka ukhiphe le nto futhi ubuyekeze amanani ngesandla.
Uma zonke izilungiselelo zenziwa, chofoza inkinobho. "Kulungile".
- Umbiko ohlanganisiwe usulungile. Njengoba ungabona, idatha yayo ihlelwe. Ukuze ubuke ulwazi phakathi kweqembu ngalinye, chofoza uphawu olulodwa kwesokunxele kwetafula.
Manje okuqukethwe kweqembu kuyatholakala ekubukeni. Ngendlela efanayo, ungavula noma yiliphi elinye iqembu.
Njengoba ubona, ukuhlanganiswa kwedatha ku-Excel kuyithuluzi elilula kakhulu, ngenxa yokuthi ungabeka ndawonye ulwazi olungekho kuphela kumatafula ahlukene nakwamashidi ahlukene, kodwa ngisho nokufakwa kwamanye amafayela (izincwadi). Lokhu kwenziwa ngokumane futhi ngokushesha.
