Iindlela ezi-3 zokuhlelwa nguMbala kwi-Excel

01 ka 03

Ukuhlelwa nguMgca woMgca weNgqimba kwi-Excel

Ukuhlelwa nguMbala kwi-Excel

Ukongezelela ukuhlalutya ngamanani - njengombhalo okanye iinombolo - I-Excel ineenketho zokwenza izinto ezikhethiweyo ezivumela ukuhlunga ngombala.

Ukulungiswa ngombala kunokunceda xa usebenzisa ifomati engqinelanayo , engasetyenziswa ukutshintsha umbala wangasemva okanye umbala wefonti yedatha ehlangabezana nezimo ezithile.

Njengoko kuboniswe kumfanekiso ongentla, ukuhlunga ngombala kungasetyenziselwa ukuqoqa le datha kunye ukuze uqikelele kwaye uhlalutye lula.

Olu luhlu lweengcebiso lubandakanya iindlela ezahlukeneyo zokuhlenga idatha kwi-Excel usebenzisa umbala. Ulwazi oluthe ngqo malunga nohlobo olukhethiweyo ngamanqaku ombala lunokufumaneka kula maphepha alandelayo:

1. Hlela ngomgca wesigcawu esisezantsi (eli phepha elingezansi)
2. Hlunga ngombala wefonti
3. Hlela ngeeMpawu zoFomati oluMiselweyo

Ukukhetha Idatha ukuba ihlelwe

Ngaphambi kokuba idatha ihlelwe, i-Excel kufuneka ikwazi ulwahlulo oluchanekileyo oluza kuhlonywa, kwaye ngokuqhelekileyo, i-Excel ilungile ekukhetheni iinkcukacha zedatha edibeneyo-ngokude nje xa ingenisiwe,

1. akukho miqolo okanye iikholomu ezingagqibekanga ezishiywe kwingingqi yeenkcukacha ezihambelanayo;
2. kunye nemigca kunye nekholam efihliweyo yashiywa phakathi kweendawo zedatha ehambelanayo.

I-Excel iya kuchonga, ngokuchanekileyo, ukuba indawo yedata inegama lomsebenzi kwaye ingabandakanyi lo mgca kwiirekhodi eziza kuhlanjululwa.

Ukuvumela i-Excel ukuba ukhethe uluhlu oluza kuhlonywa lungcono kwixabiso elincinci lenkcukacha elingakhangela ukujonga ngokukhawuleza ukuqinisekisa ukuba:

• ukuba uluhlu oluchanekileyo lukhethiweyo;
• ukuba akukho zithuba kwibala;
• ukuba emva kohlobo, iirekhodi zeedatha zihambelana kwaye zichanekile.

Kwiindawo ezinkulu zedata, indlela elula yokuqinisekisa ukuba uluhlu oluchanekileyo lukhethiweyo ukuluqakraza ngaphambi kokuqala uhlobo.

Ukuba udidi olufanayo luya kuhlanjululwa ngokuphindaphindiweyo, indlela efanelekileyo kukunika igama .

Ukuba igama lichazwe kwibala lokuhlulwa, thayipha igama kwiBhokisi legama , okanye ukhethe kuloluhlu oluhlawulelwayo oluchaphazelekayo kunye ne-Excel luza kugxininisa ngokuzenzekelayo uluhlu oluchanekileyo lwedatha kwiphepha lokusebenzela.

Ukuhlelwa nguMbala kunye nohlobo lwe-Order

Ukuhlunga kudinga ukusebenzisa umyalelo wohlobo .

Xa uhlalutya ngamanani, kukho ezimbini iilayiphu zohlobo - ezinyuke okanye zehla. Xa ukhetha ngemibala, kunjalo, akukho myalelo okhoyo ngoko ke ngumsebenzisi ochaza umbala wohlobo lwebhodi kwibhokisi yencoko yencoko .

Hlela ngomzekelo wombala weselula

Kulo mfanekiso ungentla, uluhlu lweeseli H2 ukuya kuL12 lufomathi olunemeko luye lwasetyenziswa ukutshintsha umbala wemibala yesangqa esekelwe kwiminyaka yabafundi.

Esikhundleni sokutshintsha umbala weseli yazo zonke iirekhodi zabafundi, kuphela loo minyaka engama-20 ubudala okanye abancinci abachaphazelekayo ngokufomathiweyo ngokomqathango kunye nabo bonke abasalayo.

Ezi ngxelo ziye zahlanjululwa ngumbala weeseli ukuba zidibanise iirekodi zolomdla kwi-top of the range ukuze kuthelekiswe lula nokuhlalutya.

Amanyathelo alandelayo alandelwe ukuhlenga idatha ngombala wesiqalo seseli.

1. Phakamisa uluhlu lweeseli ezizohlulwa - H2 ukuya ku-L12
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwiCode & Uhlu lwefayile kwi-Ribbon ukuvula uluhlu lokuhla
4. Cofa kwiMeko yoLuntu kuluhlu oluhla-phantsi ukuze uvelise ibhokisi yencoko yencoko
5. Ngaphantsi kohlobo olujoliswe kwibhokisi yencoko, khetha i- Cell Color ukusuka kuhlu lwehla
6. Xa i-Excel ifumana imibala eyahlukileyo yemvelaphi yedatha kwi-data ekhethiweyo yongeza loo mibala kwiinketho ezidweliswe phantsi kwe- oda ehamba kwibhokisi yencoko
7. Ngaphantsi kolawulo lwe-Order, khetha umbala obomvu ukusuka kuluhlu lokuhla
8. Ukuba kuyimfuneko, khetha i- Top kwi-order order ukuze i-red color-colored data ibe phezulu kwoluhlu
9. Cofa u-OK ukuhlela idatha kunye nokuvala ibhokisi yencoko
10. Iirekhodi ezine kunye nombala wesibomvu obomvu kufuneka ziqokelelwe kunye phezulu kwinqanaba leenkcukacha

02 ka 03

Hlunga idatha ngohlobo lwemibala kwi-Excel

Hlunga ngombala wefonti

Efana kakhulu nokuhlelwa ngumbala weselfowuni, ukuhlunga ngombala wefonti kungasetyenziswa ukukhawuleza ukuhlela idatha kunye neetekisi ezahlukeneyo.

Utshintsho kumbala wefonti lunokwenziwa ngokusebenzisa ukufomathika kwemiqathango okanye ngenxa yesakhiwo sokufometha - njengokuba ubonisa iinombolo ezingenayo ebomvu ukwenzela ukuba kube lula ukuzifumana.

Hlela ngomzekelo weMbala yoBume

Kulo mfanekiso ungentla, uluhlu lweeseli H2 ukuya kuL12 lufomathi olunemeko luyasetyenziswa ukutshintsha umbala wefonti weirekhodi zabafundi ngokusekelwe kwinkqubo yokufunda:

• Abafundi abomvu abafundi ababhalise kwinkqubo yokunesi
• Ubunjani beBlue - abafundi ababhalise kwinkqubo yesayensi

Ezi ngxelo ziye zahlanjululwa ngumbala wefonti ukuba ziqokelele iirekhodi zolomdla kwi-top of the range ukuze kuthelekiswe lula kunye nohlalutyo.

Uhlobo lohlobo lombala lubomvu lulandelwa luhlaza okwesibhakabhaka. Iirekhodi kunye nombala wefonti omnyama ayilungiswanga.

Amanyathelo alandelayo alandelwe ukuhlenga idatha ngombala wefonti.

1. Phakamisa uluhlu lweeseli ezizohlulwa - H2 ukuya ku-L12
2. Cofa kwiThebhu yasekhaya yerbhoni .
3. Cofa kwiCode & Uhlu lwefayile kwi-Ribbon ukuvula uluhlu lokuhla.
4. Cofa kwiMeko yoLuntu kuluhlu oluhla-phantsi ukuze uvelise ibhokisi yencoko yencoko
5. Ngaphansi kohlobo oluya kwibhokisi yencoko, khetha Umbala wefonti ukusuka kuluhlu lokuhla
6. Xa i-Excel ifumana imibala eyahlukeneyo yefayili kwidatha ekhethiweyo yongeza loo mibala kwizinto ezikhethwe phantsi kwe- Oyili ejongene nebhokisi yencoko
7. Ngaphantsi kolawulo lwe-Order, khetha umbala obomvu ukusuka kuluhlu lokuhla
8. Ukuba kuyimfuneko, khetha i- Top kwi-order order ukuze i-red color-colored data ibe phezulu kwoluhlu
9. Kuphezulu kwibhokisi yencoko, nqakraza kwiQinisekiso leNqanaba lokuThengeza ukongeza isigaba sesibili sohlobo
10. Kwinqanaba lesibini, phantsi kwesihloko soMyalelo, khetha umbala okwesibhakabhaka ukusuka kuluhlu lokuhla
11. Ukukhethwa Phezulu ngaphantsi komyalelo wokuhlela ukuze idatha yebala elibomvu ibe ngaphezu kwale rekhodi ngefonti ebomnyama
12. Cofa u-OK ukuhlela idatha kunye nokuvala ibhokisi yencoko
13. Iirekhodi ezimbini kunye nombala obomvu bombala kufuneka ziqokelelwe kunye phezulu kwinqanaba leenkcukacha elilandelwa ngamarekhodi amabini anombala obomvu

03 ka 03

Hlunga Iinkcukacha ngeefomati zokufometha komqathango kwi-Excel

Hlela ngeeMpawu zoFomati oluMiselweyo

Enye inketho yokuhlenga umbala kukusebenzisa iifayile zendlela yokwenza ifom yokulungiselela umyalelo .

Ezi setekethi zeekhonkco zinika enye indlela yokukhetha ifomathi ekhoyo rhoqo egxininisa kwiifom kunye neenguqu zokufometha kweeseli.

Njengoko ngokucwangcisa ngombala weselfowuni, xa ukhetha umbala we-icon umsebenzisi usetha umyalelo wohlobo kwibhokisi yencoko yebhokisi.

Hlela nge-Icon Umbala Umzekelo

Kulo mfanekiso ungentla, uluhlu lweeseli eziqulethwe ngedatha lokushisa eParis, eFransi lufomathiwe ngokomzimba kunye nekhefu lokumisa ukukhanya ngokusekelwe kwimihla ngemihla ephezulu yokushisa ngoJulayi 2014.

Ezi zixhobo zisebenzisiwe ukuhlenga idatha kunye neirekhodi ezibonisa iifoto eziluhlaza ezixutywe kuqala zilandelwa ziimpawu ze-amber, kwaye zibomvu.

Amanyathelo alandelayo alandelwe ukuhlenga idatha ngebala lomfanekiso.

1. Phakamisa uluhlu lweeseli ezizohlulwa - I3 ukuya kwi-J27
2. Cofa kwiThebhu yasekhaya yerbhoni .
3. Cofa kwiCode & Uhlu lwefayile kwi-Ribbon ukuvula uluhlu lokuhla.
4. Cofa kwiMeko yoLuntu kuluhlu oluhla-phantsi ukuze uvelise ibhokisi yencoko yencoko
5. Ngaphantsi kohlobo olujoliswe kwibhokisi yencoko, khetha i- Icon ye-Icon ukusuka kuhlu lwe-down-down
6. Xa i-Excel ifumana iimpawu zeseli kwidatha ekhethiweyo yongeza ezo icon kwiindlela ezidweliswe phantsi kwe- oda ehamba kwibhokisi yencoko
7. Ngaphantsi kwesihloko soMyalelo, khetha uphawu oluhlaza oluvela kwiluhlu lokuhla
8. Ukuba kuyimfuneko, khetha i- Top kwi-order order ukuze idatha enezithonjana eziluhlaza ibe phezulu kwoluhlu
9. Kuphezulu kwibhokisi yencoko, nqakraza kwiQinisekiso leNqanaba lokuThengeza ukongeza isigaba sesibili sohlobo
10. Kwinqanaba lesibini, phantsi kwesihloko soMyalelo, khetha uphawu lwe-amber okanye oluphuzi ukusuka kuluhlu lokuhla
11. Kwakhona, ukhethe Ophezulu kwi-oda lohlobo ukuba kuyimfuneko - oku kuza kufaka iqela lesibini lala marekhodi ngaphantsi kwalabo abaneempawu eziluhlaza, kodwa ngaphezu kwazo zonke ezinye iirekhodi ezihlelwe
12. Ekubeni kunemifanekiso emithathu yokhetho kule miselo, akukho mfuneko yokongeza isigaba sesithathu ukuhlela iirekhodi ngeempawu ezibomvu, kuba ziphela iirekhodi ezishiyekileyo kwaye ziya kufumaneka phantsi kwebala
13. Cofa u-OK ukuhlela idatha kunye nokuvala ibhokisi yencoko
14. Iirekhodi ezinomfanekiso obomvu kufuneka ziqokelelwe ndawonye phezulu kwoluhlu lweenkcukacha ezilandelwa ngamarekhodi nge icon icon, kwaye ke abo banomfanekiso obomvu