Lapho usebenza e-Excel, umsebenzi kwesinye isikhathi ubuzwa ukuthi ngemuva kokufaka usuku oluthile, usuku lwesonto oluhambelana nalo lukhonjiswa esitokisini. Ngokwemvelo, ukuxazulula le nkinga ngokusebenzisa iprosesa elinamandla yetafula njenge-Excel, mhlawumbe ngezindlela eziningi. Ake sibheke ukuthi yiziphi izinketho ezikhona ukwenza lo msebenzi.
Khombisa usuku lwesonto e-Excel
Kunezindlela eziningi zokubonisa usuku lwesonto ngosuku olungenile, kusuka ekufomeni amaseli kuya ekusebenzeni kwemisebenzi. Ake sibheke zonke izinketho ezikhona zokwenza umsebenzi ochaziwe ku-Excel, ukuze umsebenzisi akhethe okungcono kakhulu ngesimo esithile.
Indlela 1: faka ukufometha
Okokuqala, ake sibone ukuthi ukufometha kwamaseli kukuvumela kanjani ukubonisa usuku lwesonto ngosuku olungenile. Le nketho ifaka ukuguqula usuku lube kunani elishiwo, kunokuba kulondolozwe ukubonisa kwazo zombili lezi zinhlobo zedatha eshidini.
- Faka noma yiluphi usuku oluqukethe idatha enombolweni, enyangeni nonyaka, esitokisini eshidi.
- Sichofoza esitokisini inkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Khetha isikhundla kukho "Ifomethi yeseli ...".
- Ukuqalisa ukufometha kuqala. Hambisa kuthebhu "Inombolo"uma bekuvulekile kwelinye ithebhu. Ngaphezu kwalokho kuvimba lepharamitha "Amafomethi ezinombolo" setha ukushintshela esimweni "Zonke izinhlobo". Ensimini "Thayipha" ngesandla faka inani elilandelayo:
I-DDDDNgemuva kwalokho chofoza inkinobho "Kulungile" phansi kwewindi.
- Njengoba ukwazi ukubona, esikhundleni sosuku, igama eligcwele losuku lwesonto elihambelana nalo lakhonjiswa esitokisini. Ngasikhathi sinye, uma usukhethe le seli, kubha yefomula usazobona ukuboniswa kosuku.
Ensimini "Thayipha" ukufometha amawindi esikhundleni senani I-DDDD ungafaka futhi isisho esithi:
I-DDD
Kulokhu, ishidi lizobonisa igama elifinyeziwe losuku lwesonto.
Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel
Indlela 2: sebenzisa umsebenzi we-TEXT
Kepha indlela eyethulwe ngenhla ifaka ukuguqula usuku lube usuku lwesonto. Ingabe ikhona inketho yokuba womabili la maxabiso aboniswe ephepheni? Okusho ukuthi, uma sifaka usuku kuseli elilodwa, khona-ke usuku lwesonto kufanele lukhonjiswe kolunye. Yebo, inketho enjalo ikhona. Kungenziwa kusetshenziswa ifomula UMBHALO. Kulokhu, inani esilidingayo lizokhonjiswa kuseli elicacisiwe ngefomethi yombhalo.
- Sibhala usuku kunoma iyiphi into eshidi. Bese ukhetha noma isiphi iseli esingenalutho. Chofoza isithonjana. "Faka umsebenzi"etholakala eduze nomugqa wamafomula.
- Iwindows liqala ukukhuphuka. Umsebenzi Wizards. Iya esigabeni "Umbhalo" futhi ohlwini lwama-opharetha khetha igama UMBHALO.
- Iwindi lokuphikisana ngomsebenzi liyavula UMBHALO. Lo opharetha wenzelwe ukubonisa inombolo ecacisiwe enguqulweni ekhethiwe yendlela yombhalo. Ine-syntax elandelayo:
= I-TEXT (Inani; ifomethi)Ensimini "Inani" sidinga ukucacisa ikheli leseli eliqukethe usuku. Ukuze wenze lokhu, beka ikhesa enkanjini ebekiwe bese uchofoza kwesobunxele kuleseli eshidini. Ikheli liboniswa ngokushesha.
Ensimini "Ifomathi" ngokuya ngalokho esifuna ukuba nakho usuku oluphelele noma olufushanisiwe lwesonto, sethula inkulumo dddd noma ddd ngaphandle kwezingcaphuno.
Ngemuva kokufaka le datha, chofoza inkinobho "Kulungile".
- Njengoba sibona esitokisini esasikhethe ekuqaleni, ukubekwa kosuku lwesonto kukhonjiswe ngendlela yombhalo ekhethiwe. Manje ekhasini lethu usuku nosuku lwesonto kukhonjiswa ngasikhathi sinye.
Ngaphezu kwalokho, uma ushintsha inani losuku esitokisini, usuku lwesonto luzoshintsha ngokuzenzakalelayo. Ngakho-ke, uma ushintsha usuku, ungathola ukuthi luzoba luphi usuku lwesonto.
Isifundo: I-Excel Feature Wizard
Indlela 3: Sebenzisa umsebenzi WESONTO
Kunomunye opharetha ongabonisa usuku lwesonto usuku olunikeziwe. Lokhu kungumsebenzi. ILANGA. Kuliqiniso, alivezi igama losuku lwesonto, kodwa inani laso. Ngaphezu kwalokho, umsebenzisi angabeka kusukela kuluphi usuku (ngeSonto noma uMsombuluko) ukubalwa kuzobalwa.
- Khetha iseli ukukhombisa usuku lwesonto. Chofoza isithonjana "Faka umsebenzi".
- Iwindi livula futhi Umsebenzi Wizards. Kulokhu sithuthela esigabeni "Usuku nesikhathi". Khetha igama ILANGA bese uchofoza inkinobho "Kulungile".
- Iya ngewindows yezimpikiswano zenethiwekhi ILANGA. Ine-syntax elandelayo:
= USUKU (usuku_ ku_numeric_format; [uhlobo])Ensimini "Usuku ngefomethi yenombolo" faka usuku oluthile noma ikheli leseli ekhasini elikuyo.
Ensimini "Thayipha" inombolo evela 1 ngaphambili 3, enquma ukuthi izinsuku zeviki zizobalwa kanjani. Lapho usetha inombolo "1" ukubalwa kwezinombolo kuzokwenzeka kusukela ngeSonto, bese izinombolo ezilandelwayo zizonikezwa kuze kube yilolu suku lweviki "1". Lapho ubeka inani "2" izinombolo zizokwenziwa kusukela ngoMsombuluko. Lolu suku lwesonto luzonikezwa inombolo eqondile "1". Lapho ubeka inani "3" izinombolo zizokwenzeka futhi kusukela ngoMsombuluko, kepha kulokhu, uMsombuluko uzonikezwa inombolo eqondile "0".
Ukuxabana "Thayipha" akufuneki. Kepha, uma uyikhipha, kubhekwa ukuthi inani lempikiswano lilingana nalo "1"okungukuthi, isonto liqala ngeSonto. Lokhu kuyisiko emazweni akhuluma isiNgisi, kepha le ndlela ayisihambelani. Ngakho-ke enkundleni "Thayipha" setha inani "2".
Ngemuva kokwenza lezi zinyathelo, chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, inani lezinsuku zosuku lweviki elihambisana nosuku olifakiwe liboniswa kuseli ekhonjisiwe. Kithi, le nombolo "3"emelela okuphakathi.
Njengomsebenzi owedlule, lapho kuguqulwa usuku, usuku lwesonto esitokisini lapho opharetha ifakwe ngokuzenzakalelayo.
Isifundo: Usuku le-Excel nemisebenzi yesikhathi
Njengoba ubona, e-Excel kunezindlela ezintathu eziphambili zokuletha usuku njengosuku lweviki. Zonke zilula futhi azidingi ukuthi umsebenzisi abe namakhono athile. Enye yazo ukusetshenziswa kwamafomethi akhethekile, kanti eminye emibili isebenzise imisebenzi eyakhelwe ngaphakathi ukufeza lezi zinhloso. Ngokunikezwe ukuthi indlela nendlela yokubonisa idatha esimweni ngasinye esichaziwe yehluke kakhulu, umsebenzisi kufanele akhethe ukuthi yikuphi ukukhetha kuleso simo esimfanele kahle.
