Ungayakha kanjani ifomethi yedatha yakho ku-Excel

Ifomethi yedatha ku-Microsoft Office Excel iwuhlobo lokuboniswa kwezinhlamvu kumaseli wohlu lwethebula. Uhlelo ngokwalo lunezinketho eziningi zokufometha ezijwayelekile. Nokho, ngezinye izikhathi udinga ukwakha ifomethi ngokwezifiso. Indlela yokwenza lokhu kuzoxoxwa ngayo kulesi sihloko.

Ungashintsha kanjani ifomethi yeseli ku-Excel

Ngaphambi kokuba uqale ukudala ifomethi yakho, udinga ukuzijwayeza nezimiso zokuyishintsha. Ungashintsha uhlobo olulodwa lolwazi oluboniswa kumaseli ethebula uye kolunye ngokuya ngohlelo olulandelayo:

1. Chofoza inkinobho yegundane kwesokunxele kuseli edingekayo enedatha ukuze uyikhethe.
2. Chofoza kwesokudla noma yikuphi endaweni ekhethiwe.
3. Kumenyu yokuqukethwe, chofoza umugqa "Fometha Amaseli ...".
4. Ewindini elivulayo, iya engxenyeni ethi “Inombolo” futhi “Amafomethi ezinombolo” vimba, khetha enye yezinketho ezifanele ngokuchofoza kuyo kabili nge-LMB.

5. Chofoza okuthi “KULUNGILE” ezansi kwewindi ukuze usebenzise isenzo.

Nakani! Ngemva kokushintsha ifomethi, izinombolo kumaseli wetafula zizoboniswa ngendlela ehlukile.

Ungayakha kanjani ifomethi yakho ku-Excel

Umgomo wokwengeza ifomethi yedatha yangokwezifiso ohlelweni olucutshungulwayo ungahlukaniswa ngezigaba ezimbalwa:

1. Khetha iseli engenalutho yekhasi lokusebenzela futhi, ngokohlelo olungenhla, uye efasiteleni elithi “Fometha Amaseli …”.
2. Ukuze wakhe ifomethi yakho, udinga ukubhala isethi ethile yamakhodi emugqeni. Ukuze wenze lokhu, khetha into ethi "Wonke amafomethi" bese efasiteleni elilandelayo endaweni ethi "Uhlobo" faka ifomethi yakho, wazi ukubhalwa kwayo ngekhodi ku-Excel. Kulokhu, isigaba ngasinye sekhodi sihlukaniswa nesedlule nge-semicolon.

3. Hlola ukuthi i-Microsoft Office Excel iyibhala kanjani ifomethi ethile. Ukuze wenze lokhu, khetha noma iyiphi inketho yombhalo wekhodi ohlwini olutholakala efasiteleni bese uchofoza "KULUNGILE".
4. Manje, kuseli ekhethiwe, kufanele ufake noma iyiphi inombolo, isibonelo, eyodwa.

5. Ngesifaniso, faka imenyu yefomethi yeseli bese uchofoza igama elithi “Numeric” ohlwini lwamanani ethulwe. Manje, uma uya engxenyeni ethi “Wonke amafomethi” futhi, khona-ke ukufometha kwe-“Numeric” okukhethiwe kuzobe sekuvele kuboniswe njengombhalo wekhodi ohlanganisa izigaba ezimbili: isihlukanisi kanye nesemikholoni. Izigaba zizoboniswa kunkambu ethi "Uhlobo", eyokuqala yazo ibonisa inombolo ephozithivu, kanti eyesibili isetshenziselwa amanani aphikisayo.

6. Kulesi sigaba, lapho umsebenzisi esesitholile isimiso sokubhala amakhodi, angaqala ukudala ifomethi yakhe. Ngale njongo, udinga kuqala ukuvala imenyu Yefomethi Yeseli.
7. Eshidini lokusebenzela le-Excel, dala uhlu lokuqala lwethebula eliboniswe esithombeni esingezansi. Leli thebula lithathwa njengesibonelo; ekusebenzeni, ungakha noma iyiphi enye ipuleti.

8. Faka ikholomu eyengeziwe phakathi kokubili koqobo.

Kubalulekile! Ukuze udale ikholomu engenalutho, udinga ukuchofoza kwesokudla kunoma iyiphi ikholomu yohlu lwethebula bese uchofoza umugqa othi "Faka" efasiteleni lomongo.

9. Kukholomu edalwe ngesandla kusuka kukhibhodi ye-PC, kufanele ufake idatha esuka kukholomu yokuqala yethebula.

10. Khetha ikholomu eyengeziwe bese uchofoza kwesokudla kuyo. Iya efasiteleni lefomethi yeseli ngokuya ngohlelo okukhulunywe ngalo ngenhla.
11. Yiya kuthebhu "Wonke amafomethi". Ekuqaleni, igama elithi "Okuyinhloko" lizobhalwa kulayini "Uhlobo". Izodinga ukushintshwa ivelu yayo.
12. Indawo yokuqala kukhodi yefomethi kufanele ibe inani eliphozithivu. Lapha sibeka igama elithi ""Not negative"". Zonke izinkulumo kumele zifakwe ezicashuniwe.
13. Ngemuva kwenani lokuqala, faka isemicolon bese ubhala ""hhayi uziro".
14. Siphinde sibeke i-semicolon bese sibhala inhlanganisela "" ngaphandle kwe-hyphen "".
15. Ekuqaleni komugqa, uzodinga futhi ukuthi ubhale "I-Akhawunti Cha.", bese usetha ifomethi yakho, isibonelo, "00-000 ″".

16. Londoloza izinguquko ngokuchofoza ku-"KULUNGILE" ngaphansi kwewindi futhi wandise ikholomu engezwe ngaphambili ukuze ubone amanani athile esikhundleni sezinhlamvu "####". Imisho evela kufomethi edaliwe izobhalwa lapho.

Ulwazi Olwengeziwe! Uma ulwazi kumaseli lungaboniswa, umsebenzisi wenza iphutha lapho edala ifomethi yakhe. Ukuze ulungise isimo, uzodinga ukuthi ubuyele efasiteleni lezilungiselelo zokufometha kwento ye-tabular bese uhlola ukulunga kwedatha efakiwe.

Ungayisusa kanjani ifomethi yedatha engafuneki ku-Microsoft Office Excel

Uma umuntu engafuni ukusebenzisa ifomethi yohlelo eyodwa noma enye ejwayelekile, angakwazi ukuyikhipha ohlwini lwamanani atholakalayo. Ukuze ubhekane nomsebenzi ngesikhathi esifushane kakhulu, ungasebenzisa i-algorithm elandelayo:

1. Chofoza ngenkinobho yegundane engakwesokunxele kunoma iyiphi iseli yohlu lwethebula. Ungavele uchofoze engxenyeni yekhasi lokusebenzela elingenalutho.
2. Ebhokisini lohlobo lomongo, chofoza umugqa othi “Fometha Amaseli”.
3. Hambisa esigabeni "Inombolo" kubha yamathuluzi ephezulu yemenyu evulayo.
4. Khetha ifomethi yenombolo efanele ohlwini lwamabhokisi angakwesokunxele bese uyikhetha ngokuchofoza i-LMB.
5. Chofoza inkinobho ethi “Susa”, etholakala ekhoneni elingezansi kwesokudla sewindi elithi “Fometha Amaseli”.
6. Vumelana nesexwayiso sesistimu bese uchofoza okuthi KULUNGILE ukuze uvale iwindi. Ifomethi ekhethiwe evamile noma yangokwezifiso kufanele isuswe ku-MS Excel ngaphandle kokuba nokwenzeka kokululama ngokuzayo.

Isiphetho

Ngakho-ke, ukwengeza amafomethi angokwezifiso ku-Microsoft Office Excel kuyinqubo elula ongayiphatha ngokwakho. Ukuze wonge isikhathi futhi wenze lula umsebenzi, kutuswa ukusebenzisa le miyalo engenhla.