Indlela yokudala uluhlu lweedatha kwi-Excel 2003

01 ngo 08

Ulawulo lweDatha kwi-Excel

Ngamanye amaxesha, kufuneka silondoloze umkhondo wolwazi. Ingaba uluhlu lwazo lweenombolo zefowuni, uluhlu loqhagamshelwano lwamalungu entlangano okanye iqela, okanye ukuqokelela kweemali, amakhadi okanye iincwadi.

Naluphi na idatha onayo, ispredishithi , njenge-Excel, yindawo enkulu yokuyigcina. I-Excel yakhele izixhobo zokukunceda ulandele idatha kunye nokufumana ulwazi oluthe ngqo xa ufuna. Kananjalo, kunye namakhulu aloo mihlathi kunye neenkulungwane zemigca, i-Excel spreadsheet inokubamba inani elikhulu leenkcukacha .

I-Excel iphinda iphinde isebenzise kunenkqubo egciniweyo yeenkcukacha ezifana ne-Microsoft Access. Idatha ingeniswa kalula kwi-spreadsheet, kwaye, ngeenkcukacha ezimbalwa ze mouse, unokukhetha ukufumana idatha yakho kwaye ufumane oko ufuna.

02 ngo 08

Ukudala iifayile kunye neeList

Ifomathi eyisiseko yokugcina idatha kwi-Excel yithebula. Kwitheyibhile, idatha ingeniswe kwimigqa. Umqolo ngamnye uyaziwa njengerekhodi .

Emva kokuba ithebula lenziwe, izixhobo zedatha ze-Excel zingasetyenziselwa ukukhangela, ukuhlunga, nokucoca iirekhodi ukuze zithole ulwazi oluthile.

Nangona kukho iindlela ezininzi ongasebenzisa ezi zixhobo zedatha kwi-Excel, indlela elula yokwenza njalo, ukudala oko kwaziwa njengoluhlu oluvela kwidatha etafileni.

03 we-08

Ukungena kwiDatha ngokuchanekileyo

Isinyathelo sokuqala ekudaleni itafile kukufaka idatha. Xa wenza njalo, kubalulekile ukuqinisekisa ukuba ungeniswe ngokuchanekileyo.

Iimpazamo zeenkcukacha, ezibangelwa ukungena kwedatha engafanelekanga, ziyimvelaphi yeengxaki ezininzi ezinxulumene nokuphathwa kwedatha. Ukuba idatha ingeniswe ngokufanelekileyo ekuqaleni, le nkqubo inokuthi ibuyisele iziphumo ozifunayo.

04 we-08

Iirekhodi Ingxelo

Njengoko kubonisiwe, imigqa yedatha iyaziwa njengeirekhodi. Xa ufaka iirekhodi zigcina ezi zikhokelo engqondweni:

• Shiya akukho miqolo engenanto etafileni ekudalweni, kungekhona naphakathi kwezihloko kunye nomqolo wokuqala wedatha.
  
• Ingxelo ingaqukatha idatha malunga nento eyodwa kuphela.
  
• Ingxelo kufuneka iqule NONKE idatha eluhlu malunga naloo nto. Ayikwazi ukuba nolwazi malunga nomnye kumqolo omnye.
  
• Ukwenza uludwe, itafile yedata kufuneka iqule ubuncinane iirekhodi ezimbini zeedatha.

05 ka 08

Imiqolo YeeNdawo

Ngoxa iimilo etafilini zibhekiswa njengeirekhodi, iikholomu zaziwa njengeziqendu. Nganye ikholomu idinga isihloko ukuchonga idatha equlethe. Ezi zihloko zibizwa ngamagama asensimini.

• Amagama omhlaba asetyenziswa ukuqinisekisa ukuqinisekisa ukuba irekhodi ngalinye lifakwe ngokulandelelana okufanayo.
  
• Qinisekisa ukuba yonke idatha ekhompyutheni ingeniswa isebenzisa ifomathi enye. Ukuba uqala ukungena manani njengamadijithi (afana no-10 okanye 20) ukugcina. Ungatshintshi inxalenye yendlela uze uqale ukungena manani njengamazwi (afana neshumi okanye amabini). Yiba njalo.
  
• Ungashiyi iikholomu ezingenanto kwitafile.
  
• Ukwenza uluhlu, itafile kufuneka ibe ubuncinane ubuncinane beekholamu ezimbini.

06 we-08

Ukudala uludwe

Xa idatha ingeniswe kwitafile, iyakwazi ukuguqulwa kuluhlu . Ukwenza njalo:

1. Khetha naluphi na iseli enye kwitafile.
   
2. Khetha Uludwe> Yakha uluhlu kwimenyu ukuvula ibhokisi yencoko yoBumba Yoluhlu.
   
3. Ibhokisi yencoko ibonisa uluhlu lweeseli ukuba lufakwe kuhlu. Ukuba itheyibhile yenziwe ngokufanelekileyo, i-Excel iya kubakhetha ukhetho olufanelekileyo.
   
4. Ukuba ukhetho loluhlu luchanekile, cofa u- OK .

07 ka 08

Ukuba uLuhlu lweeLwimi aluhambelanga

Ukuba, ngethuba elithile, uluhlu oluboniswe kwibhokisi yencoko yoLuhlu lweDawulo alungileyo luya kuyidinga ukuhlaziya uluhlu lwamaseli ukuba ulusebenzise kuloluhlu.

Ukwenza njalo:

1. Cofa kwiqhosha lokubuyela kwibhokisi yencoko Yoluhlu lokudala ukuze ubuyele kwiphepha lokusebenzela.
   
2. Ibhokisi yencoko yoLuhlu Yenza ihlehlise kwibhokisi elincinci kwaye uluhlu lwamanje lweseli luyabonakala kwiphepha lokusebenzela elijikelezwe ziindlovu zokuhamba.
   
3. Hudula ukhethe nge mouse ukuze ukhethe uluhlu oluchanekileyo lweeseli.
   
4. Cofa kwi-iqhosha lokubuyela kwibhokisi encinci yeDala Yoluhlu lokudala ukuze ubuyele kwindawo eqhelekileyo.
   
5. Cofa u- OK ukugqiba uluhlu.

08 ka 08

Uludwe

Emva kokudalwa,

• uluhlu luya kuba nomda omnyama malunga nawo.
  
• Kuza kuba phantsi-ukutsala iintolo ezisezantsi kwigama ngalinye lentsimi evula imenyu yehla xa ucofa.
  
• Amamenyu asehla aquka iindlela zokuhlungulula uluhlu ngamagama asemasimini kunye nokukhangela uluhlu lwamarekhodi afana neempawu ezithile.
  
• Umgca ongabhalwayo oqulethe i-asterisk uyongezwa phantsi kweloluhlu. Idatha eyongezelelweyo ingafakwa kwoluhlu usebenzisa lo mqolo omtsha.