Ukusebenzisa Uhlobo lwe-Order kwi-Excel Spreadsheets

Ukuhlelwa yinkqubo yokuhlela izinto ngokulandelana okuthile okanye ukuhlela umyalelo ngokwemigaqo ethile.

Kwiiprogram ze-spreadsheet ezifana ne-Excel kunye ne-Google Spreadsheets, kukho iinombolo ezahlukeneyo zezikhokelo ezifumanekayo kuxhomekeke kwindlela yolwazi oluhlelwe ngayo.

Ukunyuka kwehla kweNqanaba eliDlulileyo

Ukubhalwa kweetekisi okanye ixabiso leenombolo, iindlela ezikhethiweyo zokuhlelwa kweendlela zikhuphuka zehla .

Ngokuxhomekeke kwimiba yedatha kwibanga elikhethiweyo, la manqaku ahlalutya aya kuhlela idatha ngeendlela ezilandelayo:

Ukwenyuka kweentlobo:

• Hlunga u-A ukuya kwi-Z - yedatha yombhalo
• Hlela umncinci kunazo zonke ukuya kuwona mkhulu kunayo yonke
• Hlela endala kunazo zonke ukuya kuNewest - ngomhla wedatha okanye kwedatha

Ukuhla kweentlobo:

• Hlunga u-A ukuya kwi-Z - yedatha yombhalo
• Uhlobo olukhulu kunazo zonke ukuya kwiNcinci - idatha yeenombolo
• Hlela omtsha kunakudala kunokuba udatha okanye ixesha lwedatha

Imizila efihliweyo kunye neeKholamu kunye nokuHlulwa

Imiqolo efihliweyo kunye neentsika zedatha azifudluli ngexesha lokuhlunga, ngoko kufuneka zidibaniswe ngaphambi kokuba uhlobo lube khona.

Umzekelo, ukuba umgca 7 ufihliweyo, kwaye inxalenye yoluhlu lweedatha oluhlanjululwayo, luya kuhlala lube ngumqolo 7 kunokuba luhanjiswe kwindawo echanekileyo ngenxa yolu hlobo.

Okufanayo kuya kwiikholam zedatha. Ukuhlelwa ngemigca kubandakanya ukulungelelanisa iikholomu zeenkcukacha, kodwa ukuba ikholomu B ifihliwe phambi kohlobo, iya kuhlala njengekholomu B kwaye ingabuyiselwa kunye namanye amakholomu eluhlu oluhlelwe.

Ukuhlelwa nguMbala kunye nohlobo lweMilawulo

Ukongezelela ekuhlunguleni ngamanani, njengombhalo okanye amanani, i-Excel ineendlela zenkcubeko ezikhethiweyo ezivumela ukuhlenga ngombala we:

• umbhalo okanye umbala wefonti;
• umbala weseli ;
• iimpawu zendlela yokufomatha .

Ekubeni akukho nenyukayo okanye ehlayo imibala, umsebenzisi uchaza umbala wohlobo lwebhodi kwibhokisi yencoko yencoko .

Hlela i-Order Order

Umthombo: Uhlobo olukhethileyo lwama-oda

Uninzi lweeprogram ze-spreadsheet zisebenzisa ezi zilandelayo zikhowudi zezinto ezahlukeneyo zedatha.

Iiseli ezingenanto : Kwenkuka kokuhla kwehla kunye nokuhla kwee-oda eziqhelekileyo, iiseli ezingenanto zihlala zigcinwe ekugqibeleni.

Amanani : Amanani amaninzi ayithathwa njengamaxabiso amancinci, ngoko ke inani elikhulu elingenambi liza kuqala kuqala kwi-oda ekhuphukayo kwaye ihlala ekuhlaleni, njengale:
Ukunyuka komyalelo: -3, -2, -1,0,1,2,3
Ukuhla kweNkundla: 3.2,1,0, -1, -2, -3

Imihla : Umhla omdala uthathwa njengexabiso elincinci okanye elincinane kunomhla wokugqibela okanye omtsha.
Ukunyuka kweNkundla (endala ukuya kutshanje): 1/5/2000, 2/5/2000, 1/5/2010, 1/5/2012
Ukuhla kweNkundla (ngokusandul 'ukudala ukuya kundala): 1/5/2012, 1/5/2010, 2/5/2000, 1/5/2000

Idatha yeAlphanumeric : Udibaniso lweeleta kunye namanani, i-data ye-alphanumeric ithathwa njengedatha yombhalo kwaye umlingisi ngamnye uhlulwa ukusuka kwesobunxele ukuya kwesokudla kumgca ngohlobo lomgca.

Ukufumana iinkcukacha ze-alphanumeric, iinombolo zibhekwa njengexabiso elincinci kunabalinganiswa beleta.

Kule nkcukacha elandelayo, i-123A, A12, 12AW, kunye ne-AW12 i-oda ekhuphukayo yile ndlela:

123A 12AW A12 AW12

Ukuhla kwelolu hlobo:

AW12 A12 12AW 123A

Kwinqaku Indlela yokuchonga ngokuchanekileyo idatha ye-alphanumeric kwi-Excel , efumaneka kwiwebhusayithi yakwa-Microsoft, lo myalelo wokulandelwa olandelayo unikezelwa ngabalinganiswa abafumanekayo kwiinkcukacha ze-alphanumeric:

0 1 2 3 4 5 6 7 8 9 (indawo)! "# $% & () *,. /:; @? @ [\] ^ _` {|} ~ + <=> ABCDEFGHIJKLMNOPQRSTU VWXYZ

Idatha yeLo Logic okanye i- Boolean : IIMFUNDO ze-TRUE okanye ze-FALSE kuphela, kwaye i-FALSE ithathwa njengexabiso elincinane kune-TRUE.

Kule nkcukacha elandelayo, INQULUNKULU, EFANELE, EYIQINISEKILEYO, NOKWENZA i-oda ekhuphukayo yile ndlela:

EFALSE EFANELEYO YOKWENYANISO

Ukuhla kwelolu hlobo:

EYENYENE

EZIQHELEKILEYO