Uhlobo lweseli kuhlelo lwe-Excel alugcini ngokuquma ukubonakala kwesibonisi sedatha, kodwa futhi litshela uhlelo ukuthi lufanele lucutshungulwe kanjani: njengombhalo, ngezinombolo, njengosuku, njll. Ngakho-ke, kubaluleke kakhulu ukusetha lesi sici sobubanzi lapho idatha izofakwa khona. Ngaphandle kwalokho, zonke izibalo zizomane zingalungile. Ake sibheke ukuthi singashintsha kanjani amafomethi amaseli kuMicrosoft Excel.
Isifundo: Ukufometha umbhalo ku-Microsoft Word
Izinhlobo eziphambili zokufometha nokushintshwa kwazo
Masheshe unqume ukuthi iyiphi amafomethi weseli akhona. Uhlelo luveza ukuthi kukhethwe eyodwa yezinhlobo ezilandelayo zokufomatha:
- Okujwayelekile;
- Imali;
- Inombolo
- Kwezezimali;
- Umbhalo
- Usuku
- Isikhathi;
- Fractional;
- Intshisakalo;
- Ongakukhetha.
Ngaphezu kwalokho, kukhona ukwahlukana kube amayunithi amancane wesakhiwo wezinketho ezingenhla. Isibonelo, amafomethi wedethi nesikhathi ane-subspecies eminingana (DD.MM.YY., DD.months. YY, DD.M, Ch.MM PM, HH.MM, njll.).
Ungashintsha ukufomathwa kwamaseli ku-Excel ngezindlela eziningi. Sizokhuluma ngabo ngemininingwane engezansi.
Indlela yoku-1: imenyu yokuqukethwe
Indlela ethandwa kakhulu yokushintsha amafomethi ebanga ledatha ukusebenzisa imenyu yokuqukethwe.
- Khetha amaseli adinga ukufomethwa ngendlela efanele. Qhafaza kwesokudla. Njengomphumela, uhlu lwezenzo luyavuleka. Udinga ukumisa ukukhetha lapho "Ifomethi yeseli ...".
- Iwindi lokufomatha liyasebenza. Iya kuthebhu "Inombolo"uma iwindi livulwe kwenye indawo. Kukubhlokhi lepharamitha "Amafomethi ezinombolo" kukhona zonke lezo zinketho zokushintsha izimfanelo obekuxoxwa ngazo ngenhla. Khetha into ehambelana nedatha ebangeni elikhethiwe. Uma kunesidingo, engxenyeni efanele yewindows sinquma okubhaliselwe idatha. Chofoza inkinobho "Kulungile".
Ngemuva kwalezi zinyathelo, ukuguqulwa kwamaseli kuguquliwe.
Indlela 2: ibha yamathuluzi enambeni
Ukufometha nakho kungashintshwa kusetshenziswa amathuluzi akweteyipu. Le ndlela ishesha kakhulu ukwedlula eyedlule.
- Iya kuthebhu "Ikhaya". Kulokhu, udinga ukukhetha amaseli afanele eshidini, nasebhulokhi lezilungiselelo "Inombolo" vula ibhokisi lokukhetha kubambo.
- Vele wenze ukukhetha kwenketho oyifunayo. Ibanga ngokushesha ngemuva kwalokho lizoshintsha ukufomatha kwalo.
- Kepha kuhlu olubekiwe kuphela amafomethi amakhulu avezwayo. Uma ufuna ukucacisa ukufometha kahle, khetha "Ezinye izinombolo zezinombolo".
- Ngemuva kwalezi zenzo, iwindi lokufometha ibanga lizovuleka, ebelivele lixoxwa ngenhla. Umsebenzisi angakhetha lapha noma iyiphi ifomethi yedatha eyengeziwe noma eyengeziwe.
Indlela yesi-3: Amathuluzi Ebhokisi Lamathuluzi
Enye inketho yokusetha lolu hlobo lobubanzi ukusebenzisa ithuluzi ebhlokini lezilungiselelo "Amaseli".
- Khetha ibanga eshidini elizolifakwa. Itholakala kuthebhu "Ikhaya"chofoza isithonjana "Ifomathi"eliseqenjini lamathuluzi "Amaseli". Uhlu lwezenzo ezivulayo, khetha "Ifomethi yeseli ...".
- Ngemuva kwalokho, iwindows esevele lifomeziwe lasebenza. Zonke ezinye izinyathelo ziyafana njengoba kuchaziwe ngenhla.
Indlela 4: Abashisi
Ekugcineni, iwindi lokufometha kwebanga lingabizwa kusetshenziswa okhiye abizwa ngokuthi abashisayo. Ukuze wenze lokhu, qala ukhethe indawo eguquguqukayo eshidini, bese uthayipha inhlanganisela kukhibhodi I-Ctrl + 1. Ngemuva kwalokho, iwindows evamile yokufometha izovuleka. Sishintsha izici ngendlela efanayo naleyo eshiwo ngenhla.
Ngaphezu kwalokho, inhlanganisela ye-hotkey yomuntu ngamunye ikuvumela ukuthi uguqule ifomethi yamaseli ngemuva kokukhetha uhla ngisho nangaphandle kokubiza iwindi elikhethekile:
- I-Ctrl + Shift + - - Uhlobo olujwayelekile;
- I-Ctrl + Shift + 1 - izinombolo ezinomhlukanisi;
- I-Ctrl + Shift + 2 - Isikhathi (amahora. imizuzu);
- I-Ctrl + Shift + 3 - izinsuku (DD.MM.YY);
- I-Ctrl + Shift + 4 - imali;
- I-Ctrl + Shift + 5 - Inzalo;
- I-Ctrl + Shift + 6 - ukufometha O.OOE + 00.
Isifundo: Izitolo ezishisayo
Njengoba ukwazi ukubona, kunezindlela eziningi zokufomatha izindawo zekhasi lokusebenzela i-Excel ngasikhathi sinye. Le nqubo ingenziwa kusetshenziswa amathuluzi esetheyipini, ngokubiza iwindi lokufometha, noma usebenzisa okhiye abashisayo. Umsebenzisi ngamunye uzinqumela ukuthi iyiphi inketho elula kakhulu kuye ekuxazululeni imisebenzi ethile, ngoba kwezinye izikhathi ukusetshenziswa kwamafomethi ajwayelekile kwanele, nakwabanye, inkomba eqondile yezimpawu ngohlobo lwangaphansi oludingekayo.
