Ungashintsha kanjani ifomethi yeseli ku-Excel

Ifomethi iseli uhlelo Excel icacisa nje ukubukeka isibonisi idatha, kodwa futhi sibonisa hlelo ngokwalo, kahle indlela ukucubungula kubo: efana umbhalo, efana nezinombolo, njengoba usuku, njll Ngakho-ke, kubaluleke kakhulu ukusungula kahle lesi sici sesihlahla ububanzi lapho idatha zizokwenziwa. Endabeni okuphambene, zonke izibalo Bayomane ayilungile. Ake sithole ukuthi kwakungani kanjani ukushintsha ifomethi iseli-Microsoft Excel.

Isifundo: Umbhalo ukufometha e-Microsoft Word

izinhlobo ezinkulu ukufometha nokushintsha kubo

Ngokushesha ukuthi yimaphi ama cell nezakhiwo ezikhona. Uhlelo luphakamisa ukuba ukhethe omunye eyisisekelo ukufomatha zinhlobo ezilandelayo:

• Okuvamile;
• Imali;
• lenombolo;
• Kwezezimali;
• Imibhalo;
• Usuku;
• isikhathi;
• Ingxaka;
• Amaphesenti;
• Engeziwe.

Ngaphezu kwalokho, kukhona ukwahlukana phakathi ezincane isakhi kulolu khetho ngenhla. Ngokwesibonelo, usuku kanye nesikhathi nezakhiwo babe zenyathi eziningana (DD.MM.YG., DD.Mytz.gg, DD.M, Ch.MM PM, CC.MM, njll).

Ungashintsha ukufometha lamaseli e-Excel ngezindlela eziningana. Sizokwenza ukukhuluma kubo ngokuningiliziwe ngezansi.

IMenyu 1: Imenyu yokuqukethwe

Kakhulu ngendlela ethandwa ukushintsha ifomethi idatha lebanga ukusebenzisa imenyu yengqikithi.

1. Khetha amaseli ezidinga ihlelwe ngendlela efanele. Uyenzele chofoza inkinobho yegundane kwesokudla. Ngenxa yalokho, uhlu zesimo yezenzo liyavuleka. Kuyadingeka ukuba ukukhethwa ngesikhathi Point Cell Ifomethi ayeke.



2. Iwindi lokufometha alisebenzi. Sifeza kwathatha "Inombolo" ithebhu uma iwindi kwaba kwenye indawo evulekile. Kungenxa ipharamitha block "ifomethi yezinombolo" kukhona labo ongakhetha ekushintsheni izici ukuthi ingxoxo ngenhla konke. Khetha intwana ukuthi oluhambisana idatha ku esikhethiwe. Uma kudingeka, ohlangothini kwesokudla sewindi, siluthola zenyathi idatha. Chofoza inkinobho ethi "KULUNGILE".

Ngemva lezi zenzo, ifomethi kweselula washintsha.

Indlela 2: "Inani" ithuluzi block on umdweshu

Ukufometha kungabuye washintsha usebenzisa amathuluzi tape. Le ndlela kwenziwa ngisho ngokushesha kwalowo odlule.

1. Iya kuthebhu "Yasekhaya". Ngesikhathi esifanayo, kudingeka ukugqamisa amaseli elihambisana eshidini, futhi "Inombolo" block on the iribhoni ukuvula Ukukhetha ensimini.



2. Thina nje wenze kukhethwa nokhetho olufunekayo. Ububanzi ngokushesha ngemva kwalokho zizoshintsha ukufomatha yayo.



3. Kodwa eshiwo uhlu izipho kuphela ngetakhiwo main. Uma ufuna ucacise kahle ufometha, bese ukhetha "Okunye yezinombolo Izakhiwo".



4. Ngemuva kwalezi zenzo, iwindi lokufometha ububanzi lizovula, elivele lihambe le ngxoxo ngenhla. Umsebenzisi angakhetha noma yiziphi ezakhe amafomethi wedatha noma angeziwe.

Indlela 3: I-Cell Tools Block

Enye inketho Ukubeka le ndlela yobubanzi ukusetshenziselwa ithuluzi ku-Inkundla Yezilungiselelo "Yeseli".

1. Sigqamisa ububanzi eshidini ukuze ifomethi. Itholakala kuthebhu "Yasekhaya", chofoza isithonjana se- "format", okuseqenjini "Amathuluzi we-Cell". Uhlu lwesenzo esivula, khetha into "amaseli efomathi ...".



2. Ngemuva kwalokho, iwindi lokufometha selivele lisebenze. Zonke ezinye izenzo zifana ncamashi nesivele zichaziwe ngenhla.

Indlela 4: Izinkinobho ezishisayo

Ekugcineni, iwindi lokufometha ububanzi lingadalwa yilokho okubizwa ngokuthi izinkinobho ezishisayo. Ukuze wenze lokhu, kuyadingeka ukugqamisa kuqala indawo eguquguqukayo eshidini, bese uthayipha inhlanganisela ye-CTRL + 1 kwikhibhodi. Ngemuva kwalokho, iwindi lokufomatha elijwayelekile livula. Siguqula izici njengoba nje sezivele zishiwo ngenhla.

Ngaphezu kwalokho, inhlanganisela yomuntu ngamunye yezinkinobho ezishisayo ikuvumela ukuthi ushintshe ifomethi yeseli ngemuva kokukhetha ububanzi noma ngaphandle kokubiza iwindi elikhethekile:

• I-Ctrl + Shift + - - ifomethi ejwayelekile;
• I-Ctrl + Shift + 1 - inombolo enosabelo;
• I-Ctrl + Shift + - isikhathi (amahora. Amaminithi);
• I-Ctrl + Shift + 3 - Izinsuku (dd.mm.yg);
• I-Ctrl + Shift + 4 - imali;
• I-Ctrl + Shift + 5 - Amaphesenti;
• I-Ctrl + Shift + 6 - format O.OD + 00.

Isifundo: Okhiye abashisayo ku-evelela

Njengoba ubona, kunezindlela eziningana zokufometha indawo yeshidi ye-Excel ngasikhathi sinye. Le nqubo ingenziwa ngokusebenzisa amathuluzi we-tepi, ibiza iwindi lokufomatha noma okhiye abashisayo. Umsebenzisi ngamunye uqobo unquma ukuthi iyiphi inketho yokuthi ilula kakhulu ekuxazululeni imisebenzi ethe xaxa, ngoba kwezinye izikhathi kwanele ukusebenzisa amafomethi ajwayelekile, kanti kwabanye - inkomba enembile yezimpawu ze-subspecies iyadingeka.