Njengoba e "Eksele" wenze itafula esiyinhlanganisela uhlobo

Isifinyezo amatafula isibonisi exhumana kolwazi evumela abasebenzisi ukuhlaziya amaqembu kanye amanani enkulu idatha ku emfushane, ifomu tabular yokubika lula futhi ukuhlaziywa. Enye inzuzo yokuhlinza lo msebenzi Excel ukuthi ikuvumela ukuhlela, fihla futhi ubonise izigaba ezahlukene uhele ukunikeza umbono enye idatha. Kulesi sihloko ungase ufunde imiyalelo mayelana nendlela "Eksele" wenze itafula.

Isinyathelo 1 kwezingu-3: Ilungiselela kusuka ekuqaleni

Qala-Microsoft Excel.

Chofoza imenyu kwento "Idatha" bese ukhetha etafuleni isifinyezo (inothi: ezinguqulweni Excel 2007/2010, enze "Faka"> ithebula isifinyezo).

Cacisa ukuthola idatha uze uhlose kuvame. Uma lolu lwazi ku-Excel uhlu ukuthi okwamanje evulekile, isofthiwe ekhetha ngokuzenzakalelayo ibanga lamaseli. Chofoza "Next".

Qiniseka ukuthi okukhethwa kukho okuthi "Uhlu olusha" kukhethiwe emva ngokuchofoza "Okulandelayo" kusukela isinyathelo odlule. Uma usukwenzile lokho, chofoza "Qedile".

Isinyathelo 2 kwezingu-3: Indlela ukwakha etafuleni "Eksele"

Uma kunesidingo, ulungise uhla ibhokisi lombhalo. Lezi izimfanelo zitholakala ngaphansi imenyu kwento "Khetha etafuleni." Uma umthombo ulwazi etafuleni kuyinto zangaphandle, ezidalwe uhlelo ehlukile (isibonelo, Finyelela), chofoza "Sebenzisa yangaphandle data imithombo." Ngemva kwalokho, thola imenyu kwento "Khetha Uxhumano" bese uchofoza ku- ebhokisini lengxoxo onesihloko esithi "Connections akhona".

Yenza kukhethwa indawo ukudala weThebula. Ngokuzenzakalelayo, imodi Excel kudala ke njengoba ikhasi elisha ukuba kwanezela incwadi. Ukukhuluma mayelana nendlela "Eksele" ukwenza etafuleni ukuze uvele on ishidi unikezwa, kudingeka uchofoze ukukhethwa inkinobho "Ekhona ohlwini", abese ucacise indawo cell kuqala ibhokisi lombhalo "Indawo" e.

Chofoza u- "KULUNGILE". Khona-ke, engeza igridi entsha engenalutho ngenxa weThebula, bese kudingeka sibonise ifasitelana umsebenzi "Field ohlwini weThebula." Lokhu panel ihlukaniswe yaba izingxenye ezimbili.

Vula imenyu kwento 'Khetha izindima ukwengeza kombiko "futhi ugcwalise yonke amagama okusendimeni idatha engumthombo.

ukugcwaliswa

Njengoba e "Eksele" wenze itafula? Ukuqhubeka ukuze afeze imiyalo, kufanele uthole ibhokisi esikrinini, ihlukaniswe yaba izindawo ezine emsebenzini, okumele ucacise isihlungi, ikholomu amalebula, imigqa kanye namagugu.

Yabela inkambu umsebenzi "okungavezwa lapho kushicilelwa Field ohlwini" e kwezingxenye zalo ezihlukahlukene. Hudula igama emkhakheni imenyu kwento 'Khetha izindima ukwengeza kombiko "ngamunye izingxenye ezine.

Yenza izinguquko uma kudingeka uze ubone imiphumela yakho enhle.

Isinyathelo 3 kwezingu-3: Ukuqonda imigomo yokuqala, noma indlela yokwenza itafula "Eksele" kulula

Okokuqala zama ukuqonda izincazelo ukhiye. Kukhona imigomo eziningana ezingase, Uma unganakile, sengathi ayicacile.

Kuyini isihlungi? Le ndawo iqukethe izinkundla ukucinga ulwazi olushiwo etafuleni isifinyezo, okufika kubo yinoma yimuphi uphawu. Bakhonza njengabashumayeli nakomaka ngombiko. Ngokwesibonelo, uma uzibekela ngokuthi "Unyaka" njengendlela lemifanekiso, ungakwazi ukubonisa idatha isifinyezo ethebuleni isikhathi esithile noma yonke iminyaka.

amakholomu isignesha - kule ndawo unenkambu ngokuchaza indawo idatha ebalulwe etafuleni isifinyezo amakholomu.

Kusayina imigqa - wathi Isifunda sinezindawo inkambu ngokuchaza indawo idatha kufakwe umugqa.

Fields aqukethe amanani ukuthi ucacise ukuthi iyiphi idatha emelelwa emangqamuzaneni weThebula. Ngamanye amazwi, kuba ukwaziswa ifingqwe ikholomu yokugcina (ihlanganiswe ngokuzenzakalela).

Field kusukela idatha yomthombo oyinikeza ikhasi (noma ukuhlunga) siboniswa umbiko weThebula.

Ukuqonda amagugu ngenhla, kanye namanye izilungiselelo kuzokuvumela ukuze uqonde kangcono indlela "Eksele" wenze itafula. Khumbula ukuthi izinguqulo ezihlukene isimiso, ezinye izinto imenyu ingehluka.