Ukufometha kweseli le-Excel: umhlahlandlela ophelele wamafomethi namaqhinga

Master the ukufometha kweseli ku-Excel Kwenza umehluko phakathi kwespredishithi esingcolile kanye nedokhumenti yobungcweti okulula ukuyiqonda ngokushesha. Akukhona nje ukuyenza ibukeke kahle: ukufometha okufanele kuqinisekisa ukuthi i-Excel ihumusha idatha ngokunembile futhi yenza izibalo ngaphandle kwamaphutha, okubalulekile emsebenzini wehhovisi, izivivinyo zokuncintisana, kanye nanoma yikuphi ukuphathwa kwedatha okungathi sína.

Uma ufaka isicelo ifomethi efanelekile Ngeseli ngayinye, ukhetha ukuthi izinombolo, izinsuku, umbhalo, uhlobo lwemali, amaphesenti, noma amakhodi akhethekile avela kanjani, ngaphandle kokushintsha inani langempela i-Excel elilisebenzisayo ekubaleni. Ngaphezu kwalokho, ngamafomethi enziwe ngokwezifiso, ungafinyelela imiphumela eqondile kakhulu: engeza amayunithi, uqokomise amanani angemahle ngombala obomvu, ubonise izinsuku ngesitayela esithile, noma ufihle amanani.

Kuyini ngempela ukufometha kweseli ku-Excel?

Ku-Excel, iseli ngalinye lifana ne- isitsha esinezendlalelo ezimbiliNgakolunye uhlangothi, kukhona inani langempela (elisetshenziselwa ukubala), kanti ngakolunye uhlangothi, ukuthi lelo nani liboniswa kanjani esikrinini. Ibhokisi lengxoxo elithi "Amaseli Okufometha" liyiphaneli yokulawula lapho unquma khona ukuthi ufuna okuqukethwe kubukeke kanjani.

Lokhu kusho ukuthi ungakwazi shintsha ngokuphelele ukubukeka yeseli (inani lezindawo zamadesimali, uphawu lwemali, umbala, ifonti, usuku, umbhalo, njll.) ngaphandle kokushintsha idatha esetshenziswa yi-Excel ukwengeza, ukususa, noma ukwenza noma iyiphi ifomula. Ngakho-ke, ukufometha akuyona nje indlela yokubukeka, kodwa kuyingxenye esebenzayo yokusebenza ngamaspredishithi.

Ukuze usebenze kahle ne-Excel, kubalulekile ukuhlukanisa i-Excel ibe yi- ifomethi efanele yobubanzi ngabunye kwamaseli: uma iseli liqukethe usuku, kufanele lifomethwe njengosuku; uma liqukethe iphesenti, kufanele lifomethwe njengephesenti; uma kuyikhodi yeposi, ungase ufune ukusebenzisa ifomethi ekhethekile ukuze ugweme ukulahlekelwa o-zero abaholayo nokuqonda imisebenzi efana umsebenzi we-ISOMITTED.

Uma ufaka izinombolo ezixutshwe nombhalo (isibonelo, "10 kg") ngaphandle kokusebenzisa ukufometha, i-Excel ngeke isakuphatha njengenombolo kodwa njenge... umucu we-alphanumericFuthi imisebenzi eminingi izobuyisa amaphutha noma imiphumela engalindelekile. Amafomethi enziwe ngokwezifiso ayasetshenziswa ukuze kugwenywe lokhu.

Indlela yokuvula ibhokisi lengxoxo lamaFomethi Amaseli

I-Excel inikeza izindlela eziningana zokufinyelela izinketho zefomethiukuze ukwazi ukusebenzisa noma iyiphi ekulungele kakhulu nganoma yisiphi isikhathi. Konke kuholela ebhokisini lengxoxo elifanayo, lapho ungakhetha khona isigaba (Inombolo, Imali, Usuku, Okwenziwe Ngokwezifiso, njll.).

Ungavula ibhokisi lengxoxo elithi Amaseli Okufometha ngokuchofoza kwesokudla: khetha ububanzi, yenza Chofoza ngakwesokudla kumaseli bese ukhetha "Fometha Amaseli". Lena mhlawumbe yindlela evame kakhulu esetshenziswa uma usuvele usebenza endaweni ethile yeshidi.

Ungayithola futhi ku-ribbon: kuthebhu InicioNgaphakathi kweqembu elithi "Amaseli", uzothola inketho ethi "Ifomethi", enikeza ukufinyelela ebhokisini lengxoxo yokufometha amaseli. Eqenjini elithi "Izinombolo" kuthebhu efanayo, ungandisa izinketho futhi ufinyelele ibhokisi lengxoxo elithuthukisiwe.

Indlela esheshayo, futhi okufanele uyikhumbule ikakhulukazi uma ulungiselela izivivinyo zokuncintisana, ishothikhathi sekhibhodi Ctrl + 1Mane ukhethe iseli noma ububanzi, cindezela leyo nhlanganisela, bese ibhokisi lengxoxo elithi "Fometha Amaseli" lizovuleka ngqo, likubeke kuthebhu ethi "Inombolo".

Uma usungaphakathi, uzobona ohlangothini lwesobunxele ifomethi yezigaba (Okuvamile, Inombolo, Imali, Ukubalwa Kwezimali, Usuku, Isikhathi, Amaphesenti, Ingxenye, Isayensi, Umbhalo, Okukhethekile, kanye Nokwezifiso). Ngakwesokudla, indawo ethi "Uhlobo" lapho kuchazwa khona ifomethi ethile kanye nesigaba esithi "Isampula", esibonisa ukuthi inani leseli lizobukeka kanjani ngefomethi ekhethiwe.

Amafomethi ezinombolo eziyisisekelo kanye nombhalo ku-Excel

Isigaba "Esijwayelekile" yilesi ifomethi ezenzakalelayo kusuka ku-Excel. Ayisebenzisi noma yikuphi ukufometha okukhethekile: ibonisa izinombolo ngendlela ejwayelekile, futhi kuye ngokuthi uthayipha ini, i-Excel inquma ukuthi izoyiphatha njengenombolo, usuku, umbhalo, njll. Iwusizo uma ungadingi ukufometha okuthile, kodwa ayisebenzi uma ufuna ngisho nokulawula okuncane.

Ifomethi ethi "Inombolo" ingenye yezisetshenziswa kakhulu ngoba ivumela chaza amadesimali kanye nabahlukanisiNgalo, ungavumela izinkulungwane zezihlukanisi, wandise noma wehlise inani lezindawo zedesimali ezibonakalayo (okuzenzakalelayo ngokuvamile ku-2), bese ukhetha ukuthi izinombolo ezingezinhle ziboniswa kanjani (zisayiniwe, zibomvu, zibekwe kubakaki, njll.). Lokhu kwenza kube lula kakhulu ukuhumusha uhlu olude lwedatha.

Ifomethi ethi "Uhlobo Lwemali" inezela kulokhu okungenhla ithuba lokukhetha uphawu lwemali Lokhu kusebenza kuzo zonke izinhlobo zemali: ama-euro, amadola, amaphawundi, nokunye okuningi. Vele uvule uhlu "lweSimboli" bese ukhetha uhlobo lwemali olufunayo. Njengoba kunjalo ngeNombolo, ungalungisa izindawo zamadesimali kanye nesitayela sezimpawu ezingezinhle.

Ifomethi ethi "Accounting" isebenza futhi nezimali, kodwa ivumelanisa izimpawu zemali kanye namanani Ngendlela ekhethekile, izimpawu zifakwa kukholomu eyodwa futhi izinombolo ziphakathi kweseli. Kuyindlela "yokubala" kakhulu kunefomethi ejabulisa ubuhle, ayisebenzi ngaso sonke isikhathi, kodwa ikhona kulabo abadinga isethulo sebhalansi noma se-ledger yakudala.

Uma ukhetha "Umbhalo" njengefomethi yeseli, uphoqa i-Excel ukuthi phatha okuqukethwe ngokoqoboNjengoba nje uthayipha. Lokhu kuwusizo kakhulu uma ufuna ukuvimbela izinto ezifana nezinsuku, amakhodi ezinombolo anama-zero ahamba phambili, izinkomba, noma izintambo ezithile ukuthi zingahunyushwa. Inkinga ukuthi, ngenkathi kusefomethi yombhalo, lokho okuqukethwe akukwazi ukusetshenziswa ngqo ekusebenzeni kwezibalo.

Amafomethi osuku nesikhathi

Ukuphathwa kwedethi kwe-Excel kuneqhinga kukho: ngaphakathi, usuku ngalunye empeleni luyi- inani lezinsuku kusukela ngo-1-1-1900Uma usebenzisa ifomethi yezinombolo osukwini, uzobona leso sibali. Yingakho kubaluleke kakhulu ukufometha usuku ngendlela efanele ukuze ubone okufunayo (usuku, inyanga, unyaka) hhayi inombolo ethile ebukeka ingajwayelekile.

Esigabeni esithi "Usuku" ungakhetha izindlela ezahlukene zokwenza usuku lombukiso: ngezinombolo kuphela, inyanga ibhalwe ngombhalo ofingqiwe noma ogcwele, unyaka omfushane (izinombolo ezimbili) noma omude (izinombolo ezine), noma inhlanganisela ehlukahlukene. Ngaphezu kwalokho, amafomethi amaningi ancike kuzilungiselelo zesifunda zesistimu yakho: ulimi, ifomethi yosuku/inyanga/unyaka, njll.

Okwamanje, isigaba esithi "Isikhathi" sinikeza izinhlobo ezahlukene zamafomethi amazinga ahlukene emininingwaneUngabonisa amahora nemizuzu kuphela, ufake imizuzwana, usebenzise ifomethi yamahora angu-24, noma ifomethi ejwayelekile yamahora angu-12 ene-AM/PM. Uzothola namafomethi anenkanyezi lapha, avumelana ngokuzenzakalelayo uma izilungiselelo zakho zesifunda se-Windows zishintsha.

Kumafomethi edethi ngokwezifiso, izinhlamvu ezibalulekile ngu-d, m, kanye no-a. d, dd, ddd noma dddd Ulawula ukuthi usuku luboniswa ngenombolo eyodwa noma ezimbili, noma njengesifinyezo noma igama eliphelele losuku lwesonto. m, mm, mmm, mmmm Unquma ukuthi inyanga ivela njengenombolo, isifinyezo, noma igama eliphelele, kanye aa noma aaaa Uchaza ukuthi unyaka ubonakala umfushane noma mude.

Uma ubheka izikhathi, sebenzisa u-h kumahora, u-m imizuzu, kanye no-s imizuzwana, ngohlamvu olulodwa noma ezimbili kuye ngokuthi ufuna inombolo eyodwa noma ezimbili. Isibonelo, hh: mm: ss Izoboniswa ngo-01:05:09, kuyilapho i-h:m:s ingase ivele njengo-1:5:9. Ngaphezu kwalokho, ungangeza i-AM/PM ukuze isebenze ngefomethi yamahora ayi-12 bese usebenzisa uhlamvu lwekholoni (:) njengesihlukanisi.

Amaphesenti, ingxenye, amanothi esayensi, kanye namafomethi akhethekile

Ifomethi ethi "Amaphesenti" ibalulekile uma usebenza isilinganiso noma izilinganisoUma isetshenziswa, i-Excel ihumusha inani elingu-0,15 njengo-15%, u-1 njengo-100%, njalo njalo, futhi ungachaza inani lezindawo zamadesimali okufanele ziboniswe. Isetshenziswa kabanzi emibikweni yezezimali, ekuhlaziyweni kwedatha, nasezivivinyweni ze-Excel.

Ifomethi ethi "Ingxenye" ​​iguqula inombolo ibe yi- ukumelwa okuyingxenye kuye ngohlobo olukhethayo: izingxenyana ezilula, eziyisishiyagalombili, ezeshumi nesithupha, njll. Kuwusizo ikakhulukazi ezimweni zezibalo, zezibalo noma zobuchwepheshe lapho kunengqondo ukukhombisa izingxenyana esikhundleni samadesimali amade.

Inketho ethi "Isayensi" ibonisa amanani ku-exponential notation yohlobo I-1,23E + 06Okusho ukuthi, 1,23 × 10 emandleni ka-6. Kuyifomethi ewusizo kakhulu lapho usebenza ngezinombolo ezinkulu kakhulu noma ezincane kakhulu, njengedatha yesayensi, izilinganiso, izibalo zobunjiniyela, noma izibalo ezithuthukisiwe.

Ngaphakathi kokuthi "Okukhethekile" uzothola amafomethi alungiselelwe ngokuqinisekile amakhodi ajwayelekilenjengezinombolo zocingo, amakhodi eposi, noma izinombolo zokuphepha komphakathi (kuye ngolimi/isifunda). Umsebenzi wayo ukubonisa le datha ngendlela efanele, ukuhlonipha o-zero abaphambili noma izakhiwo ezithile, ngaphandle kokuthi udale ifomethi ngesandla.

Ngaphandle kwalezi zigaba, i-Excel ifaka isigaba esithi "Esingokwezifiso", lapho ungakha khona imaski yakho ngokuxuba izimpawu nombhalo. Lesi sigaba yisona esivame ukuvela ezivivinyweni. I-IT yezivivinyo zokuncintisanangoba ivumela ukwakheka kwanoma yiluphi uhlobo lokwethula olungacatshangwa yizinkantolo.

Yiziphi izinhlobo zefomethi ezenziwe ngokwezifiso ku-Excel?

Ifomethi eyenziwe ngokwezifiso ngumthetho onquma ukuthi kufanele ibe kanjani bonisa okuqukethwe kusuka kuseli, ngaphandle kokushintsha inani langaphakathi elisetshenziswa yi-Excel ekubaleni. Ngale ndlela, ungangeza amayunithi (kg, amayunithi, €), umbhalo ochazayo, noma imibala, kodwa amafomula aqhubeka nokusebenza kuphela ngezinombolo.

Cabanga ngethebula elinobuningi, intengo yeyunithi, isisindo seyunithi, isisindo esiphelele, inani eliphelele, kanye nentengo emaphakathi. Uma uthayipha "10 kg" ngqo kuseli kukholomu, lelo nani liyayeka ukuba yinombolo, futhi amafomula azama ukuliphindaphinda azobuyisa amanani angalungile. iphuthaKodwa-ke, uma uthayipha u-10 kuphela bese usebenzisa ifomethi yangokwezifiso ekhombisa "10 kg", i-Excel isengakwazi ukuphinda lelo nani ngaphandle kwezinkinga.

Amafomethi enziwe ngokwezifiso achazwa esigabeni esithi "Enziwe ngokwezifiso" ngaphakathi kwebhokisi lengxoxo yokufometha kweseli. Uzobona uhlu olunezinketho eziningana. amafomethi achazwe ngaphambilini Ungayisebenzisa njengoba injalo, uyishintshe, noma uyisebenzise njengesisekelo ukuze udale eyakho. Ebhokisini elithi "Uhlobo", ubhala ikhodi yokufometha, bese kuthi elithi "Isampula" ubona ukubuka kuqala okusetshenziswa kokuqukethwe kweseli kwamanje.

Isakhiwo sefomethi eyenziwe ngokwezifiso sihlukaniswe saba izigaba ezine kuhlukaniswe ngamakholoni amancane (;):
Ifomethi yezinto ezinhle; Ifomethi yezinto ezimbi; Ifomethi yezinsila; Ifomethi yemibhalo.

Ukuchaza zonke izingxenye ezine akuphoqelekile. Uma ufuna ukufometha kuphela, isibonelo, izinombolo ezingezinhle, ungasebenzisa into efana ;-0.000;;Ushiya izingxenye ezithi positive, zero, kanye nombhalo zingenalutho, futhi uchaza kuphela ukuthi amanani angemahle azovela kanjani (izindawo ezintathu zedesimali ezinesibonakaliso se-minus). I-Excel izosebenzisa ifomethi ejwayelekile noma ibonise amasimu angenalutho ezigabeni ezingachazwanga.

Izimpawu ezibalulekile namakhadi asendle ngamafomethi enziwe ngokwezifiso

Ukuze amafomethi enziwe ngokwezifiso asebenze ngomlingo wawo, udinga ukwazi ukuthi izinhlamvu zamagama ezimpawuUmlingiswa ngamunye unendlela yakhe yokuziphatha, futhi ngokuhlanganisa naye ufinyelela isethulo esiqondile esidingekayo ekuzilolongeni, emibikweni, noma ezivivinyweni.

Izimpawu eziyisisekelo zezinombolo zintathu: 0, # kanye no-?U-zero (0) uphoqa ukuboniswa kwenombolo, noma ngabe kungu-zero ongangezi inani, uhlanganisa o-zero ngakwesobunxele noma kwesokudla njengoba kudingeka. Uphawu # lubonisa "inombolo ebalulekile": uma inombolo ingenazo ezinye izinombolo, ayihlanganiswa o-zero. Uphawu lombuzo (?) lugcina izikhala zezinombolo ezingabalulekile, kodwa luzishiya zingenalutho, okusiza ukuvumelanisa izinombolo ngesihlukanisi sedesimali.

Isibonelo, ifomethi 0 Lokhu kuzokwenza inani elifana no-16,817 liboniswe njengo-17, noma ngabe ngaphakathi lihlala lingu-16,817. Ifomethi # Izobonisa izinombolo ezibalulekile kuphela ngaphandle kokuphoqa o-zero abengeziwe. Ngezinhlanganisela ezifana no-0,0; 0,00; #,##0 noma #,##0,00 unquma ukuthi ufuna izindawo ezingaki zamadesimali nokuthi uzofaka yini isihlukanisi sezinkulungwane.

Inkathi (.) kanye ne-comma (,) zinezindlela zokuziphatha ezahlukene kuye ngokuthi ukucushwa kwesifundaNoma kunjalo, ngokuvamile zisetshenziswa njengesihlukanisi sedesimali kanye nesihlukanisi sezinkulungwane ngaphakathi kwefomethi. Isibonelo esijwayelekile: #.##0,00 ukubonisa inombolo enezindawo zedesimali eziyizinkulungwane nezimbili, ukuze u-1234 abukeke njengo-1.234,00.

Uphawu lwephesenti % lufaka uphawu lwe-% bese ulungisa inani ngokufanele. Izinhlamvu u-E noma u-e zilandelwa ngu-+ noma – (E+, E-, e+, e-) zivuselela amanothi esayensi. Ezinye izimpawu ezifana no-+, -, /, abakaki, uphawu lwedola u-$, uphawu lwe-euro u-€, noma yiluphi uhlamvu olungokoqobo lungaboniswa ngokufaka uhlamvu njengoba lunjalo noma ngokulufaka emamaki okucaphuna uma kungumbhalo.

Uma udinga ukuphinda uhlamvu ukuze ugcwalise ububanzi beseli, sebenzisa inkanyezi (*). Isibonelo, ngefomethi 0,00 * Izogcwaliswa ngohlamvu lokugcina olucacisiwe kuze kube yilapho isikhala esitholakalayo sigcwalisiwe; uma uyibhala njengo *.0,00Lokhu kuzophinda uhlamvu ngaphambi kwenombolo. Lokhu kuyasiza ekudaleni imiphumela ebonakalayo, imigqa enamachashazi, noma "ukugcwalisa" okuzenzakalelayo.

Ukusetshenziswa kwemaski yombhalo, imibala, kanye nokuqukethwe

Ukuhlanganisa izinombolo nombhalo oqinile ngaphakathi kwefomethi, kusetshenziswa okulandelayo: izingcaphuno eziphindwe kabiliKonke okungaphakathi kwezimpawu zokucaphuna kuzoboniswa ngokoqobo, kuyilapho yonke enye ikhodi ihunyushwa njengengxenye yokufometha. Isibonelo, ifomethi 0,00″ kg» Kuzokwenza inani elingu-12,5 livele njengo-12,50 kg ngaphandle kokuthi uthayiphe u-"kg" esitokisini.

Uphawu lwe-at (@) lusetshenziselwa ukumela okuqukethwe kombhalo yeseli ngamafomethi enziwe ngokwezifiso. Uma uchaza ifomethi yesigaba sesine (esombhalo) sesitayela "Qaphela: "@Uma iseli liqukethe umbhalo, kuzovezwa okuthi "Qaphela:" kulandelwe inani lokuqala. Lokhu kuvame ukusetshenziselwa ukulebula ngokuzenzakalelayo izinkambu ezithile ngaphandle kokuphinda ulwazi.

Esinye isici esinamandla yikhono lokusebenzisa imibala evela kufomethi uqoboLokhu kwenziwa ngokubhala igama lombala kubakaki abayisikwele ekuqaleni kwesigaba: , , , , , , . Ungasebenzisa futhi u-n, lapho u-n eyinombolo ephakathi kuka-0 no-56 ebhekisela kuphalethi yombala yangaphakathi ye-Excel.

Isibonelo esijwayelekile kungaba into efana nale: 0,00;-0,00;»-«;»Ukunakwa: «@Leyo fomethi izobonisa izinombolo ezinhle ngombala oluhlaza okwesibhakabhaka ezinezindawo ezimbili zedesimali, izinombolo ezimbi ngombala obomvu ezinophawu lokususa, o-zero njengedeshibhodi elula, kanye nombhalo oluhlaza olandelwa igama elithi Attention:.

Ngaphezu kwalokho, amafomethi enziwe ngokwezifiso avumela amanani emaskiOkusho ukuthi, ukuzifihla ngaphandle kokuzisusa. Uma ushiya noma yiziphi izingxenye zingenalutho (isibonelo, ukusebenzisa ama-semicolon ukuze uthole izinombolo ezinhle nezimbi, o-zero, nombhalo), i-Excel igcina inani kodwa ayilibonisi. Lokhu kungahlanganiswa nemibala noma izinhlamvu ezikhethekile ukuze kudalwe imibiko ecacile.

Izibonelo ezijwayelekile zamafomethi enziwe ngokwezifiso

Esinye sezifanekiso ezivame kakhulu yifomethi #.##0,00Le fomethi ibonisa izinombolo ezinesihlukanisi sezinkulungwane kanye nezindawo ezimbili zamadesimali. Inani elingu-1234 lizovela njengo-1.234,00; u-12,3 lizovela njengo-12,30; kanti u-0 uvela njengo-0,00. Lesi isitayela sakudala samanani noma amanani kumadokhumenti ochwepheshe.

Uma ufuna ukwengeza uphawu lwe-euro futhi uqokomise amanani angemahle ngombala obomvu, ungasebenzisa into efana nale #.##0 €;-#.##0 €Kulesi simo, ingxenye yokuqala ihlela amanani amahle ngophawu lwe-€, kanti ingxenye yesibili yenza okufanayo kodwa ngombala obomvu nophawu olubi. Kuyindlela esheshayo yokubona ukulahlekelwa noma izindleko ngokushesha.

Ikhadi le-wildmark (?) liphinde lisetshenziswe ukuphatha izikhala. Ifomethi # ?? Lokhu kwenza, isibonelo, inombolo engu-1234 ivele njengo-"12 34", igcine izikhala engxenyeni yedesimali noma ngabe azizona amanani abalulekile. Ngokulungisa inani lamamaki emibuzo, ungalawula ukuthi zingaki izikhala ezisele nokuthi izinombolo ziqondaniswe kanjani kumakholomu.

Ezimweni zokuhlolwa kokuncintisana, kuvamile ukuthi bacele amafomethi anephethini ethile, njengokuthi «ISITOKELO «#.###0,00% noma okufanayo. Kulezi zivivinyo, mane uthayiphe izinhlamvu eziboniswe emiyalweni ebhokisini elithi "Uhlobo" lefomethi eyenziwe ngokwezifiso, uhlanganise izinombolo, izimpawu, kanye nezimpawu zokucaphuna njengoba kuboniswe embuzweni.

Esinye isimo esivamile ezivivinyweni sihilela izinsuku ezikhethekile. Isibonelo, ungase ucelwe ukuthi ususe izinsuku ezingu-75 osukwini bese ubonisa umphumela ngendlela efanele. Unyaka.Inyanga.Usuku lapho unyaka unezinombolo ezine, inyanga yesibili, kanti usuku lungaba neyodwa noma ezimbili. Ifomethi efanele yangokwezifiso ingaba yinto efana nale aaaa.mm.dukuze usuku lwesine luboniswe njengo-"4" hhayi njengo-"04".

Ukusetshenziswa okusebenzayo kwe-Excel ezivivinyweni zokuncintisana

Ezivivinyweni zoMsizi Wokuphatha noma Wokuphatha, amafomethi ngokwezifiso Ziwumthombo ovamile wemibuzo. Zivame ukubuza izivivinyo lapho ifomethi ezenzakalelayo ye-Excel ingahambisani ncamashi nalokho inkinga ekufunayo, ngakho-ke kufanele usebenzise ithempulethi elenziwe ngokwezifiso.

Isibonelo esivamile: unikezwa usuku oluseseli, ucelwe ukuba ukhiphe inani lezinsuku, bese ubonisa umphumela ngefomethi ethile (isibonelo, unyaka onezinombolo ezine, inyanga enezimbili, kanye nosuku oluneyodwa noma ezimbili). Ifomula yokususa izinsuku yenziwa ngqo (isibonelo, =D2-75), kanti okunye ukuchaza ifomethi yosuku ngokwezifiso, ukuhlanganisa a, myd ngama-perids noma ama-dash njengoba kubonisiwe.

Olunye uhlobo lokuhlola luhilela ukufometha amakholomu amabili ezinombolo ngokwezincazelo eziqondile. Isibonelo, ikholomu eyodwa ingaboniswa njenge #.###0,00% kanti enye inephethini ehlukile, ngokuvamile enezimpawu eziqinile ezihlanganisiwe. Isihluthulelo lapha ukubhala ikhodi ebhokisini elithi "Uhlobo" ngaphandle kwamaphutha, ukuhlonipha amakhoma, ongqimba, izikhala, izimpawu zamaphesenti, njll.

Uma uqonda izimpawu (0, #, ?, «, «;”, imibala ekubakekeni, njll.) futhi uqonda ukuthi inani eliyisisekelo alishintshi, le mibuzo yilena ezithengekayo impelaUbunzima bangempela buvame ukuba sekukhumbuleni i-syntax ngokunembile nokungadideki lapho uthayipha ifomethi edingekayo.

Ukusebenza ngamafomethi enziwe ngokwezifiso akugcini nje ngokukusiza ukuthi uphumelele izivivinyo, kodwa futhi kunikeza amaphepha akho okusebenzela isiphetho sobungcweti, anamakholomu aqondile, amayunithi ahlelwe kahle, kanye nedatha elungele ukuhunyushwa ngokushesha.

Ukwazi ukufometha amaseli ku-Excel, kokubili okuyisisekelo nokwenziwe ngokwezifiso, kukuvumela ukuthi ulawule ngokunembile ukuthi izinombolo, izinsuku, umbhalo, namakhodi akhethekile aboniswa kanjani, ngaphandle kokubeka engcupheni izibalo. Ngokuzijwayeza, izinqamuleli ezifana Ctrl + 1 Futhi ngokuphathwa kahle kwezimpawu (0, #, ?, izimpawu zokucaphuna, imibala kanye nezigaba ezihlukaniswe ngama-semicolon), amaspredishithi akho ashintsha ekubeni amathebula alula abe amathuluzi acacile nanembile alungele noma yikuphi ukubuyekezwa kobuchwepheshe noma ukuhlolwa okunzima.