Usuku lweveki ngomhla wokugqibela

Xa usebenza kwi-Excel, umsebenzi ngamanye amaxesha uphakanyisiwe ukuze emva kokungena kumhla othile kwiseli, umhla weveki, ehambelana nayo. Ngokwemvelo, kunokwenzeka ukusombulula lo msebenzi nge-prosesa enamandla njengokuthinjwa, mhlawumbi ngeendlela ezininzi. Masibone ukuba loluphi ukhetho olukhoyo ukwenza lo msebenzi.

Ukubonisa uSuku lweveki kwi-Excele

Zininzi iindlela zokubonisa umhla weveki yomhla otshiweyo, ukusukela ekufometini kweeseli kunye nokuphela kokusetyenziswa kwemisebenzi. Makhe siqwalasele zonke iinketho ezikhoyo zokwenza umsebenzi ochaziweyo kwi-Presele ukuze umsebenzisi angazikhetha ezona zinto zibalulekileyo.

Indlela yoku-1: Ukufomatha isicelo

Okokuqala, makhe sibone ukuba kungaboniswa njani ukuba ifomati yeseli ibonakalise njani iveki yeveki. Olu khetho lubonisa umhla wokuguqulwa kwixabiso elichaziweyo, kwaye ungagcinwanga ukubonisa zombini ezi ntlobo zedatha ephepheni.

1. Singenise nawuphi na umhla oqukethe idatha kwinani, inyanga nenyanga, kwiseli kwiphepha.



2. Cofa kwindawo yendawo yeqhosha lemouse lasekunene. Imenyu yemeko isunguliwe. Sikhetha kuyo isikhundla "iiseli zefomathi ...".



3. Ifestile ekufomeli iqalile. Yiya kwi-"yenombolo" ithebhu ukuba ivuliwe kwenye ithebhu. Emva koko, kwiiforamitha "zamanani", sibeka i-switch kwi "Zonke iifomati". Kwintsimi ethi "Chwetheza" Ngena kwixabiso elilandelayo:

   Dddd

   Emva koko, cofa kwiqhosha "Kulungile" emazantsi efestile.



4. Njengoko ubona, kwiseli endaweni yomhla, igama elipheleleyo losuku lweveki kufanelekile. Kwangelo xesha, khetha leseli, kwifomula yoMlawuli uya kubona umboniso.

Kwindawo "yohlobo" lwefestile yokufomatha, endaweni yexabiso le-DDMD, ungafaka intetho:

Ddd

Kule meko, uluhlu luya kubonisa igama elifinyeziweyo losuku lweveki.

Isifundo: Indlela yokutshintsha ifomathi yeseli

Indlela 2: Sebenzisa itekisi yomsebenzi

Kodwa le ndlela ingeniswe ngaphezulu ibonelela ngomhla wenguqu ngomhla weveki. Ngaba kukho ukhetho ukuze zombini ezi nqobo luboniswa kwiphepha? Oko kukuthi, ukuba kwiseli enye esingena kumhla, emva koko usuku lweveki kufuneka luboniswe. Ewe, olu khetho lukhona. Inokwenziwa kusetyenziswa ifomula yokubhaliweyo. Kule meko, ixabiso olifunayo liya kuboniswa kwiseli echaziweyo kwifomathi yokubhaliweyo.

1. Rekhoda umhla ngalo naliphi na ixesha. Emva koko ukhethe nasiphi na isisele esingenanto. Cofa kwindawo ethi "Faka umsebenzi" i-icon, ethathwa kufutshane nefomula.



2. Iwindows yeWizard yeWizard iqala ukusebenza. Yiya kwicandelo "isicatshulwa" kunye noluhlu lwabaqhubi, khetha igama "isicatshulwa".



3. I-windows yokungqinelana ivuliwe. Lo msebenzi ubizwa ukuba ukhuphele inombolo echaziweyo kwinguqulelo ekhethiweyo yefomathi yokubhaliweyo. Inayo le syntax ilandelayo:

   = Isicatshulwa (ixabiso; ifomathi)

   Kwintsimi ethi "Ixabiso", kufuneka sikhankanye idilesi yeseli equlathe umhla. Ukwenza oku, setha isikhombisi kwicandelo elichaziweyo kunye neqhosha lasekhohlo iqhosha nqakraza kwesi sisele kwiphepha. Idilesi iya kuvela kwangoko.

   Kwintsimi "Ifomathi" Kuxhomekeke koko sifuna ukuba nembono epheleleyo yosuku lweveki igcwele okanye sivunyiwe, sazisa ibinzana elithi "DDMD" ngaphandle kweekowuti.

   Emva kokungena kule datha, cinezela iqhosha u "Kulungile".



4. Njengoko sibona kwiseli, esiye sanyula kwasekuqaleni, ukuchongwa kwemini yeveki kwaboniswa kwifomathi yesicatshulwa esikhethiweyo. Ngoku sinomhla kwiphepha kunye nomhla, kunye nomhla weveki ngexesha elinye.

Ngapha koko, ukuba kwiseli ukutshintsha ixabiso lomhla, emva koko utshintsha ngokuzenzekelayo usuku lweveki. Ke, ukutshintsha umhla ungafumanisa ukuba loluphi usuku lweveki.

Isifundo: Inkosi yeMisebenzi kwi-Excele

Indlela yesi-3: Ukusetyenziswa komsebenzi wosuku

Kukho omnye umqhubi onokuthi azise usuku lweveki umhla onikiweyo. Lo ngumsebenzi wosuku. Kuyinyani, ubonakalisa igama losuku lweveki, kodwa inombolo yakhe. Kwangelo xesha, umsebenzisi unokufakwa ukuba loluphi usuku (ukusuka ngeCawa okanye ngoMvulo) kuya kubalwa.

1. Sibonisa iseli yokuphumeza komhla weveki. Cofa kwindawo ethi "Faka umsebenzi" icon.



2. Iwizard yeWizard Wizard ivula kwakhona. Ngeli xesha siya kudidi "Umhla kunye nexesha". Khetha igama elithi "Denate" kwaye ucofe iqhosha u "Kulungile".



3. Inguqu kwimpikiswano yeempikiswano zomqhubi yenziwe. Inayo le syntax ilandelayo:

   = Venote (Umhla_oother_format; [uhlobo])

   Kwikota yefomathi efanayo ", sifaka umhla othile okanye idilesi yeseli kwiphepha elinelo.

   Kwintsimi "yohlobo", inani libekwe ukusuka kwi-1 kuye kwi-3, eligqiba ngokuthe ngqo ukuba iintsuku zeveki ziya kubalwa njani. Xa ufaka inombolo "1", inani liya kwenzeka ukusukela ngeCawa, kwaye olu suku lweveki luya kwabelwa inani "1". Xa ufaka ixabiso "2", izabelo ziya kwenziwa, ukuqala ngoMvulo. Olu suku lweveki luyakunikwa inombolo yokulandelelana "1". Xa ufaka ixabiso "3", amanani aya kwenzeka ngoMvulo, kodwa kule meko ngoMvulo uya kwabelwa inombolo yokulandelelana "0".

   "Uhlobo" Impikiswano ayinyanzelekanga. Kodwa, ukuba ishiyiwe, kukholelwa ukuba ixabiso lempikiswano ngu "1", oko kukuthi, iveki iqala ngeCawa. Wamkelekile kumazwe athetha isiNgesi, kodwa olu khetho aluchaphazeli kuthi. Ke ngoko, "uhlobo", sibeke ixabiso "2".

   Emva kokuphumeza ezi zenzo, cofa kwiqhosha "Kulungile".



4. Njengoko sibona, inani lako lweveki yeveki iboniswa kwiseli echaziweyo, ehambelana nomhla ofakiweyo. Kwimeko yethu, eli linani "3", elithetha ngoLwesithathu.

Njengakwimisebenzi yangaphambili, umhla womhla weveki utshintsha ngokuzenzekelayo xa itshintshwe emva komhla kwiseli efakiweyo.

Isifundo: Umhla kunye neXesha imisebenzi ye-Excele

Njengoko ubona, zintathu eziphambili eziphambili zomhla weveki egqwesileyo. Zonke zilula kwaye azifuni nezakhono ezithile zomsebenzisi. Omnye wabo kukusebenzisa iifomati ezikhethekileyo, kwaye abanye babini basebenzise imisebenzi ethunzini ukufezekisa le njongo. Ukujonga ukuba indlela kunye nendlela yokubonisa idatha kwityala ngalinye lakhiwe kakhulu, umsebenzisi kufuneka akhethe ukuba yeyiphi ukhetho oluthile kwimeko ethile ilungele konke.