Omnye wemisebenzi enokubakho ngaphambi komsebenzisi ngelixa usebenza kwi-Excel ukongezwa kwexesha. Umzekelo, lo mbuzo unokwenzeka xa ufikelela kwinkqubo yokusebenza yexesha lokusebenza. Ubunzima buhambelana nento yokuba ixesha alilinganiswanga kwinkqubo ye-decimal eyaziwayo, apho i-Excell isebenza ngokungagqibekanga. Masifumanise ukuba ungayishwankathela njani ixesha kwesi sicelo.
Ukushwankanya kwexesha
Ukuze uvelise inkqubo yexesha lokusebenza, okokuqala, zonke iiseli ezithatha inxaxheba kulo msebenzi kufuneka zibe nefomathi yexesha. Ukuba akunjalo, mababekwe ngokufanelekileyo. Ifomathi yeseli yangoku inokujongwa emva kokuba ikhethiwe kwithebhu yasekhaya kwintsimi yefomati ekhethekileyo kwiteyiphu kwi-Toolbar ye "Inombolo" yesixhobo.
- Khetha iiseli ezihambelanayo. Ukuba luluhlu, emva koko uqokelele iqhosha lemouse lasekhohlo kwaye umphumo kuyo. Kwimeko apho sisebenzisana neeseli nganye sisasazeke kwiphepha, ke ngoko ukwabiwa kwazo, phakathi kwezinye izinto, ngokubamba iqhosha le-CTRL kwikhibhodi.
- Ngokucofa iqhosha lemouse lasekunene, ngaloo ndlela ukubiza imenyu yemeko. Yiya kwi-proformart yeeseli ... ". Endaweni yoko, unokukhuphela i-CTRL + 1 indibaniselwano kwikhibhodi.
- Ifestile yokufomatha ivuliwe. Yiya kwithebhu "yenombolo" ukuba ivulwe kwenye ithebhu. Kwimidlalo ye "fomus" ye-Meritric ", sihlengahlengisa i-switch kwisikhundla" sexesha ". Kwicala lasekunene lefestile kwibhloko "yohlobo", khetha uhlobo lovelwano esiya kusebenza ngalo. Emva kokuseta kwenziwe, cofa kwiqhosha "Kulungile" emazantsi efestile.
Isifundo: Iitafile zokufomatha kwi-Excel
Indlela yoku-1: Jonga ukufunda ixesha lokuphumla
Okokuqala, makhe sibone ukuba singabala indlela iiyure ezininzi eziya kuboniswa emva kwexesha elithile, eliboniswe ngeyure, imizuzu kunye nemizuzwana. Kumzekelo osethu, kuya kufuneka wazi ukuba iyakuba njani kwiwotshi emva kweyure enye imizuzu engama-45 kunye nemizuzwana engama-51, ukuba ifakwe kubo 13: 26:06.
- Kwicandelo elifomathiweyo yephepha kwiiseli ezahlukeneyo ezisebenzisa ikhibhodi, sifaka idatha "13:26:06" kunye "1:45:51".
- Kwiseli yesithathu, apho kufakwa ixesha lexesha, faka uphawu "=". Okulandelayo, cofa kwisesi ngexesha "13:26:06", Sicofa kwikhibhodi kwaye ucofe kwixabiso "1:45:51".
- Ukuze iziphumo zokubalo ukubonisa kwiscreen, cofa iqhosha u "Ngena".
QAPHELA! Ukufaka le ndlela, unokufumanisa ukuba zingaphi iiyure eziza kuboniswa emva kwexesha elithile kuphela ngaphakathi kosuku olunye. Ukuze "xhuma" ngomgca wemihla ngemihla kwaye uyazi ukuba lingakanani ixesha lokubonisa iwotshi, qiniseka ukuba ukufota iiseli, kufuneka ukhethe uhlobo lwefomathi ene-asterisk, njengaleyo ingezantsi.
Indlela 2: Sebenzisa umsebenzi
Olunye ukhetho kwindlela edlulileyo kukusebenzisa inani lexabiso.
- Emva kwedatha eyintloko (ixesha langoku lokufunda kwewotshi kunye nexesha) lifakiwe, khetha isisele esahlukileyo. Cofa kwiqhosha "Colas Fun".
- I-Wizard ivula. Sijonge kuluhlu lwezinto ezisebenzayo " Siyibonisa kwaye sicinezela iqhosha u "Kulungile".
- I-Window Yengcaciso yeWebhu yewindows. Sisolula isikhombisi kwintsimi "yeNombolo1" kunye neqela leseli elinexesha langoku. Emva koko setha isikhombisi kwintsimi "yeNombolo2" kwaye ucofe kwiseli, apho ixesha lichazwa khona. Emva kokuba omabini amasimi azaliswe, cofa iqhosha u- "Kulungile".
- Njengoko ubona, ukubala kwenzeka kwaye iziphumo zongezwa kwexesha ziboniswe kwiseli ekhethiweyo yokuqala.
Isifundo: I-Wizard imisebenzi kwi-Excel
Indlela yesi-3: Iyonke iyongeza
Kodwa rhoqo rhoqo, kuyafuneka ukuba ukufumanisa ukufundwa kweeyure ngexesha elithile, kodwa ukusonga ixesha elipheleleyo. Umzekelo, oku kuyafuneka ukufumanisa inani lilonke leeyure ezisebenzayo. Ngezi njongo, ungasebenzisa enye yeendlela ezimbini ezazichaziwe ngaphambili: ukongezwa okulula okanye ukusetyenziswa kwenani leemali. Kodwa, ilunge ngakumbi kule meko, sebenzisa isixhobo njengemoto enjalo mosmy.
- Kodwa, okokuqala, kuya kufuneka sisekele iiseli iiseli ngendlela eyahlukileyo, hayi indlela ebikwa ngayo kwiinguqulelo zangaphambili. Khetha indawo kwaye ubize iwindow yokufomatha. Kwi-theb "yenani", sihlengahlengisa "iifomathi ze-madi" ukutshintshela kwindawo "ye-Advanced". Kwinxalenye elungileyo yefestile esiyifumana kwaye sibeke ixabiso "[h]: mm: ss". Ukugcina utshintsho, cofa kwiqhosha "Kulungile".
- Okulandelayo, kuya kufuneka ubalaselise uluhlu oluzaliswe lixesha kunye neseli enye engenanto emva kwayo. Ukuba kwithebhu yasekhaya, cofa kwi icon yexabiso, ibekwe kwiteyiphu kwi-Goolbar yokuhlela. Enye enye into, ungatsalela umnxeba "Alt + =" iqhosha kwikhibhodi.
- Emva kwezi zenzo, iziphumo zokubala ziya kuvela kwiseli ekhethiweyo engenanto.
Isifundo: INDLELA YOKUXELISA INDLELA YOKUXHASA
Njengoko ubona, zimbini iintlobo zexesha lokusongela i-Excel: Ukongezwa kwexesha kunye nokubalwa kwendawo yewotshi emva kwexesha elithile. Ukusombulula nganye yale misebenzi kukho iindlela ezininzi. Umsebenzisi ngokwakhe kufuneka abone ukuba loluphi ukhetho oluthile oluya kufaneleka kuye.