Umgca okanye Umbhalo Uluhlu lweNkcazo kunye nokuSebenza kwi-Excel

Umtya wesicatshulwa, owaziwa ngokuba ngumtya okanye umyalezo njengelinye iqela labalinganiswa asetyenziswa njengedatha kwiprogram yespredishithi.

Nangona iifayile zetekisi zihlala ziqulethwe ngamagama, zingabandakanywa nabalinganiswa njengale:

• iileta
• manani
• iimpawu ezikhethekileyo ezifana nezikhathi (.), isimboli sedash ( - ), okanye uphawu lweenombolo ( # )

Ngokungagqibekanga, imitshini yombhalo ishiywe idibene kwiselfowuni ngelixa idatha yeenombolo ihambelana ngakwesokudla.

Ukufomatha idatha njengombhalo

Nangona iifayile zetekisi zivame ukuqala ngeleta yealfabhethi, nayiphi na ukungena kwedatha efomathiweyo njengombhalo ochazwa njengomtya.

Ukuguqula amanani kunye namafomula ekubhaliseni i-Apostrophe

Umtya wesicatshulwa unokudalwa kwi-Excel kunye ne-Google Spreadsheets ngokufaka i-apostrophe ( ' ) njengomlingisi wokuqala weedatha.

I-apostrophe ayibonakali kwiseli kodwa yenza ukuba inkqubo iguqule nayiphi na inamba okanye iimpawu ezifakwe emva kokuba i-apostrophe ibe yombhalo.

Umzekelo, ukungena kwifom efana ne- = A1 + B2 njengomtya wesicatshulwa, thayipha:

'= A1 + B2

I-apostrophe, ngoxa ingabonakali, inqanda inkqubo yespredishithi ekuguquleleni ukungena njengefomula.

Ukuguqula izixhobo zombhalo kwiNombolo yedatha kwi-Excel

Ngamanye amaxesha, amanani akopiweyo okanye angeniswe kwi-spreadsheet aya kutshintshwa kwi-data yombhalo. Oku kungabangela iingxaki ukuba idatha isetyenziselwa ingxabano kwezinye zeenkqubo ezakhelwe ngaphakathi njenge- SUM okanye ISIGABA .

Izinketho zokulungisa le ngxaki ziquka:

Ikhetho 1: Namathisela okhethekileyo kwi-Excel

Ukusebenzisa ugugu olukhethekileyo ukuguqula idatha yombhalo kumanani kunzima kwaye njengokuba inzuzo yokuba idatha eguqukileyo ihlala kwindawo yayo yangaphambili - ngokungafani nomsebenzi we-VALUE ofuna ukuba idata eguqulelwe ukuba ihlale kwindawo eyahlukileyo ukusuka kwidata yenkcazelo yangaphambili.

Inketho yesi-2: Sebenzisa i-Button Button kwi-Excel

Njengoko kuboniswe kumfanekiso ongentla, I-Button Error okanye I-Button Yokujonga I-Button kwi-Excel yinto emfutshane yecatter ebonakalayo ecaleni kweeseli eziqulethe iimpazamo zedatha-njengokuba ngaba ifomathi yedatha ifomathiwe njengetekisi isetyenziswe kwifomu. Ukusebenzisa ibhokhwe yephutha ukuguqula idatha yombhalo kumanani:

1. Khetha iseli (s) eziqukethe idatha engalunganga
2. Cofa iqhosha lephulo ecaleni kweseli ukuvula imenyu yemeko yokukhetha
3. Cofa kwi- Convert to Number kwimenyu

Idata kwiiseli ezikhethiweyo kufuneka iguqulwe ibe ngamanani.

Ukuqhagamshelana neziTyikitya zombhalo kwi-Excel kunye ne-Google Spreadsheets

Kwi-Excel kunye ne-Google Spreadsheets, umlingisi we-ampersand (&) ungasetyenziselwa ukudibanisa kunye okanye ukunciphisa izixhobo zombhalo ezikhoyo kwiiseli ezahlukeneyo kwindawo entsha. Umzekelo, ukuba ikholomu A iqulethe amagama okuqala kunye nekholomu B amagama okugqibela ngabanye, iiseli ezimbini zedatha zingadibaniswa ndawonye kwikholamu C.

Ifom eza kwenza oku = = (A1 & "" & B1).

Qaphela: umqhubi we-ampersand akayi kubeka ngokuzenzekelayo izikhala phakathi kwamacatshulwa athile okubhaliweyo kwaye kufuneka afakwe kwifom ngesandla ngesandla. Oku kwenziwa ngokujikeleza umgca wendawo (wangena usebenzisa ibha yendawo kwikhibhodi) ngamanqaku okucaphuna njengoko kuboniswe kule fom apha ngasentla.

Enye inketho yokujoyina imicatshulwa yombhalo kukusebenzisa umsebenzi OQHENZISAYO .

Ukuchithwa kwedata yenkcazelo kwiiseli ezininzi kunye nombhalo kwiikholam

Ukwenza okuphambene nokuqhathaniswa - ukwahlula iseli enye yedatha kwiiseli ezimbini okanye ezihlukeneyo - I-Excel inombhalo weeNqakrazo . Amanyathelo okufeza lo msebenzi:

1. Khetha ikholamu yeeseli equle idatha yombhalo odibeneyo.
2. Cofa kwiMenu yedatha yemenyu yebhondi .
3. Cofa kwi- Text kuya kwiikholam ukuvula i- Convert Text ukuya kwiWilumns wizard.
4. Ngaphantsi kohlobo lwangokuqala lweedatha lwesinyathelo sokuqala, nqakraza umkhawulo-mali , uze uklikha Okulandelayo.
5. Ngaphantsi kweNyathelo 2, khetha i-separate separator text or delimiter kwi-data yakho, njengeThabhu okanye isikhala, uze uklikhe Ilandelayo.
6. Ngaphantsi kweNqanaba lesi-3, khetha ifomathi efanelekileyo phantsi kwefomathi yedata ye-Column , njengeGenerari.
7. Ngaphantsi kwekhefu elikhethiweyo, khetha ezinye iindlela zesahluli se- Decimal kunye ne- Separator separator , ukuba i-default-time and comma ngokulandelanayo-ayilunganga.
8. Cofa Qhawula ukuvala idilesi uze ubuyele kwiphepha lokusebenzela.
9. Isicatshulwa kwikhothi ekhethiweyo ngoku kufuneka ihlukaniswe zibe ezimbini okanye ngaphezulu iikholomu.