Enye yezinto ezithokozisayo zeMicrosoft Excel NAMUHLA. Usebenzisa lo opharetha, usuku lwamanje lufakwa esitokisini. Kepha lungasetshenziswa namanye amafomula ngokuhlanganiswa. Bheka izici eziyinhloko zomsebenzi NAMUHLA, ama-nuances womsebenzi wayo nokusebenzisana nabanye abaqhubi.
Usebenzisa i-Operator NAMUHLA
Umsebenzi NAMUHLA kukhipha umphumela kuseli elicacisiwe losuku olufakiwe kwikhompyutha. Kungokweqembu labasebenza "Usuku nesikhathi".
Kepha udinga ukuqonda ukuthi le formula kuphela ngeke ibuyekeze amanani asesitokisini. Okusho ukuthi, uma uvula uhlelo ezinsukwini ezimbalwa futhi ungalandisi amafomula akulo (ngesandla noma ngokuzenzakalelayo), kuzobe sekufakwa usuku olufanayo esitokisini, kepha hhayi olwamanje.
Ukuze ubheke ukuthi ngabe ukulandisa okuzenzakalelayo kusethwe kudokhumenti ethile, udinga ukwenza uchungechunge lwezenzo ezilandelanayo.
- Ukuba kuthebhu Ifayelahamba uyokhomba "Izinketho" ohlangothini lwesobunxele lwewindi.
- Ngemuva kokuthi iwindi lemingcele lisebenze, iya esigabeni Amafomula. Sizodinga ibhulokhi yezilungiselelo ezihamba phambili Ukubalwa kwamapharamitha. Ukushintsha kwepharamitha "Izibalo encwadini" kufanele isethwe ku "Ngokuzenzakalelayo". Uma isisesimweni esihlukile, kufanele ifakwe njengoba kuchaziwe ngenhla. Ngemuva kokushintsha izilungiselelo, chofoza inkinobho "Kulungile".
Manje, nganoma yiluphi ushintsho kudokhumenti, luzolandiswa ngokuzenzakalelayo.
Uma ngesizathu esithile ungafuni ukusetha ukulandisa okuzenzakalelayo, khona-ke ukuze ubuyekeze okuqukethwe kuseli equkethe umsebenzi wosuku lwamanje NAMUHLA, udinga ukuyikhetha, faka isikhombisi emugqeni wamafomula bese ucindezela inkinobho Ngena.
Kulokhu, uma ukubalwa okuzenzakalelayo kukhutshaziwe, kuzokwenziwa kuphela maqondana nalesi seli, hhayi kulo lonke idokhumenti.
Indlela 1: ukwethula umsebenzi
Lo opharetha akanangxabano. I-syntax yayo ilula futhi ibukeka kanjena:
= NAMUHLA ()
- Ukuze usebenzise lo msebenzi, mane nje ufake le nkulumo esitokisini ofuna ukubona kuso isithombe sosuku lwanamuhla.
- Ukuze ubale futhi ubonise umphumela esikrinini, chofoza inkinobho Ngena.
Isifundo: Usuku le-Excel nemisebenzi yesikhathi
Indlela 2: Sebenzisa Umsebenzi Wizard
Ngaphezu kwalokho, ungasebenzisa Isici Wizard. Le nketho ilungele ikakhulukazi abasebenzisi be-novice Excel abasadidekile amagama emisebenzi nemisebenzi yabo, yize kuleli cala kulula ngangokunokwenzeka.
- Khetha iseli eshidini okuzokhonjiswa ngalo usuku. Chofoza isithonjana "Faka umsebenzi"etholakala kubha yefomula.
- Umsebenzi Wizard uqala. Esigabeni "Usuku nesikhathi" noma "Uhlu oluphelele lwe-alfabhethi" ngifuna into "NAMUHLA". Khetha bese uchofoza inkinobho. "Kulungile" phansi kwewindi.
- Kuvulwa iwindi lemininingwane elincane, elibika ngenhloso yalomsebenzi, futhi libuye lisho ukuthi alinaziphikiso. Chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, usuku olufakwe kwikhompyutha yomsebenzisi manje luzokhonjiswa kuseli elicacisiwe ngaphambili.
Isifundo: Umsebenzi Wizard e-Excel
Indlela 3: shintsha ifomethi yeseli
Uma ngaphambi kokufaka umsebenzi NAMUHLA iseli lalinefomethi ejwayelekile, lizoguqulwa ngokuzenzakalela lifomethi. Kepha, uma ububanzi sebevele busetshenzisiwe ngenani elihlukile, khona-ke ngeke kushintshe, okusho ukuthi ifomula izokhiqiza imiphumela engalungile.
Ukuze ubone inani lefomethi yeseli ngalinye noma isifunda eshidini, udinga ukukhetha ibanga olifunayo futhi, ngoba kuthebhu "Ikhaya", bheka ukuthi iliphi inani elisethwe ngefomu elikhethekile iribhoni kubhulashi lamathuluzi "Inombolo".
Uma ngemuva kokufaka ifomula NAMUHLA ifomathi lalingahleliwe ngokuzenzakalela esitokisini Usuku, khona-ke umsebenzi ngeke ubonise imiphumela kahle. Kulokhu, kufanele uguqule ifomethi ngesandla.
- Qhafaza kwesokudla kuseli ofuna ukuguqula ngalo ifomethi. Kumenyu evela, khetha isikhundla Uhlobo Lweseli.
- Iwindi lokufometha liyavula. Iya kuthebhu "Inombolo" uma kungenzeka ivulwe kwenye indawo. Ebhlokini "Amafomethi ezinombolo" khetha into Usuku bese uchofoza inkinobho "Kulungile".
- Manje iseli lifomethwe kahle futhi libonisa usuku lwanamuhla.
Ngaphezu kwalokho, ewindini lokufometha, ungashintsha futhi isethulo sosuku lwanamuhla. Ifomathi ezenzakalelayo yethempulethi "dd.mm.yyyy". Ukugqamisa izinketho ezahlukahlukene zamanani enkambu "Thayipha", ebekwe ohlangothini lokunene lwefasitela lokufomatha, ungashintsha ukubukeka kwesibonisi sosuku esitokisini. Ngemuva kwezinguquko ungakhohlwa ukucindezela inkinobho "Kulungile".
Indlela 4: Sebenzisa NAMUHLA ngokuhambisana namanye amafomula
Futhi usebenze NAMUHLA lungasetshenziswa njengengxenye ebalulekile yamafomula ayinkimbinkimbi. Kule khwalithi, lo opharetha ukuvumela ukuthi uxazulule izinkinga eziningi kakhulu kunokusebenzisa okuzimele.
Umsebenzi NAMUHLA Kuyinto elula kakhulu ukuyisebenzisa ukubala isikhathi ngezikhathi, ngokwesibonelo, lapho ukhombisa ubudala bomuntu. Ukuze wenze lokhu, sibhala isichasiselo salolu hlobo esitokisini:
= UNYAKA (NAMUHLA ()) - 1965
Ukufaka ifomula, chofoza inkinobho ENTER.
Manje, esitokisini ngezilungiselelo ezilungile zokuphinda kufakazelwe amafomula wedokhumenti, iminyaka yamanje yomuntu owazalwa ngo-1965 izokhonjiswa njalo. Isisho esifanayo singasebenza kunoma yimuphi omunye unyaka wokuzalwa noma ukubala usuku lomcimbi.
Kukhona ifomula ebonisa amanani ezinsukwini ezimbalwa ngaphambi kweseli. Isibonelo, ukubonisa usuku ngemuva kwezinsuku ezintathu, kuzobukeka kanjena:
= NAMUHLA () + 3
Uma udinga ukukhumbula usuku okwedlule ezinsukwini ezintathu ezedlule, khona-ke ifomula izobukeka kanjena:
= NAMUHLA () - 3
Uma ufuna ukubonisa esitokisini kuphela inani losuku lwamanje enyangeni, hhayi usuku oluphelele, bese kusetshenziswa le nkulumo:
= USUKU (NAMUHLA ())
Ukusebenza okufanayo ukubonisa inombolo yenyanga yamanje kuzobukeka kanjena:
= INYANGA (NAMUHLA ())
Okusho ukuthi, ngoFebhuwari inani 2 lizoba esitokisini, ngoMashi - 3, njll.
Usebenzisa ifomula eyinkimbinkimbi ngokwengeziwe, ungakwazi ukubala ukuthi zingakanani izinsuku ezizodlula kusukela namuhla ziye ngosuku oluthile. Uma ulungiselela ukulandisa kahle, khona-ke ngale ndlela ungakha uhlobo lwe-redowndowndown timer ngosuku olunikeziwe. Ithempulethi lefomula enamakhono afanayo yile elandelayo:
= DATEVALUE ("set_date") - NAMUHLA ()
Esikhundleni senani "Beka usuku" Cacisa usuku oluthile kwifomethi "dd.mm.yyyy", lapho udinga ukuhlela ukubala phansi.
Qiniseka ukuthi ufometha iseli lapho lokhu kubalwa kuzokhonjiswa khona ngefomethi ejwayelekile, ngaphandle kwalokho ukuboniswa komphumela kuzobe kungalungile.
Kukhona ithuba lokuhlanganiswa neminye imisebenzi ye-Excel.
Njengoba ukwazi ukubona, usebenzisa umsebenzi NAMUHLA Awukwazi ukubonisa kuphela usuku lwamanje losuku lwamanje, kodwa futhi ungenza ezinye izibalo eziningi. Ukwazi i-syntax yalokhu namanye amafomula kuzosiza ukukhombisa inhlanganisela ehlukahlukene yokusetshenziswa kwalowo opharetha. Uma ulungiselela kahle ukubalwa kabusha kwamafomula kudokhumenti, inani layo lizovuselelwa ngokuzenzakalelayo.
