Ungawenza njani unobumba wokuqala we-capital kwi-Excel

Kwiimeko ezininzi, kuyafuneka ukuba ileta yokuqala kwitheyibhile yetafile yathunyelwa (ikomkhulu). Ukuba umsebenzisi ekuqaleni afake iileta ezisezantsi okanye ekoyikishe idatha evela komnye umthombo we-Excel, apho onke amagama aqala ngeleta encinci, unokuchitha ixesha elininzi kunye nexesha lokuzisa itafile yetafile kwi I-State ofunekayo. Kodwa, mhlawumbi, i-Excel inezixhobo ezikhethekileyo onokuyenza le nkqubo? Ewe, le nkqubo inomsebenzi wokutshintsha oonobumba abancinci ukuya kwikomkhulu. Makhe sijonge ukuba isebenza njani.

Inkqubo yenguqu yeleta yokuqala eya kwisihloko

Akufanelanga ukuba ulindele ukuba kwi-Excel kukho iqhosha elahlukileyo ngokunqakraza apho, ungayijika ngokuzenzekelayo ileta yomtya kwisihloko. Ukwenza oku, kuya kufuneka usebenzise imisebenzi, kwaye aliqela kwaoko. Nangona kunjalo, nangayiphi na imeko, le ndlela enenzala iya kuhlawula iindleko zethutyana eziya kufunwa ukutshintsha kwedatha.

Indlela yoku-1: Ukutshintsha ileta yokuqala kwiseli kwisihloko

Ukusombulula lo msebenzi, umsebenzi ophambili usetyenziselwa ukutshintsha, kunye nemisebenzi yotyalo-mali yomyalelo wokuqala kunye wesibini ubhalisiwe kwaye iLevimimv.

• Umsebenzi wokuTshintshela indawo yokuhlala okanye inxalenye yomgca kwabanye, ngokweengxoxo ezichaziweyo;
• Ibhalisiwe-yenza iileta ngemali enkulu, oko kukuthi, ikomkhulu, esiyifunayo;
• ILevimv-ibuyisela inani elichaziweyo labalinganiswa besicatshulwa esithile kwiseli.

Oko kukuthi, ngokusekwe kule seti yemisebenzi, ngoncedo lukaLevimv, siya kubuyisela ileta yokuqala kwiseli echaziweyo, usebenzisa i-operator, siya kuyibuyisela i-inderbast, kwaye emva koko sibuyisele ileta esezantsi i-ephezulu.

Itemplate yakule ntlawulo iya kujongeka ngolu hlobo:

= Faka endaweni yakudala (endala: i-nach_post; inombolo_ yophawu;

Kodwa kungcono ukuyijonga yonke umzekelo. Ke, sinetafile egcwalisiweyo apho onke amagama abhaliwe ngeleta encinci. Sinophawu lokuqala kwiseli nganye ngamagama ukwenza isihloko. Iseli yokuqala enefani inxibelelanise i-B4.

1. Kuyo nayiphi na indawo yasimahla yeli phepha okanye kwelinye iphepha, bhala le fomula elandelayo:

   = Faka endaweni ye (B4; 1; 1; ichanekileyo (B4; 1)))



2. Ukuqhubela idatha kwaye ubone iziphumo, cofa iqhosha lokungena kwikhibhodi. Njengoko ubona, ngoku kwiseli, igama lokuqala liqala ngoonobumba abakhulu.



3. Siba sisikhombisi kwikona esezantsi esekhohlo yeseli kunye nefomula kwaye kusebenzise i-forker yokugcwalisa kwifomula kwiiseli ezisezantsi. Kufuneka sikopeyinge ngokuchanekileyo kangangokuba zingaphi iiseli ezinefani yetafile yomthombo wayo.



4. Njengoko ubona, unikwe ezo ngxolelo kwifomula, kwaye hayi ngokupheleleyo, ikopi yenzekile ngokutshintsha. Ke ngoko, imixholo yesikhundla esenziwa ngokomyalelo wezikhundla ziboniswa kwiiseli ezisezantsi, kodwa kunye nonobumba omkhulu. Ngoku kufuneka siyifake iziphumo kwitafile yomthombo. Khetha uluhlu lwefomula. Ndicofa kwiqhosha lasekunene lemouse kwaye ukhethe "Khuphela" kwimenyu yemeko.



5. Emva koko, sibalaselisa iiseli zantlandlolo ngamagama etafileni. Tsalela umnxeba kwimenyu yemeko ngokucofa iqhosha lemouse lasekunene. Kwi-parameter "faka i-parameter" ibhloko, khetha eyona nto "amaxabiso", amelwe njengeecon ngeenombolo.



6. Njengoko ubona, emva koko, idatha esiyifunayo ifakwe kwizikhundla zetafile. Kwangelo xesha, oonobumba abancinci kumagama okuqala eeseli batshintshwa nge-ephezulu. Ngoku, hayi ukonakalisa inkangeleko yephepha, kufuneka ususe iiseli ngefomula. Kubaluleke kakhulu ukucima ukuba wenza ukuba uguqukile kwiphepha elinye. Sibonisa uluhlu oluchaziweyo, cofa ekunene-Cofa kwaye kwimenyu yemeko, yeka ukukhetha "Cima ..." into.



7. Kwibhokisi yencoko yababini ebonakalayo, useta iswitshi kwisikhundla "somtya". Cofa kwiqhosha "Kulungile".

Emva koko, idatha eyongezelelweyo iya kucocwa, kwaye siya kufumana iziphumo ezifezekisiweyo: kwitafile nganye yeseli, igama lokuqala liqala ngoonobumba abakhulu.

Indlela yesi-2: Ilizwi ngalinye elinonobumba omkhulu

Kodwa kukho iimeko apho kufuneka ukuba ungazenzi igama lokuqala kuphela kwiseli, ukuqala ngoonobumba abakhulu, kodwa ngokubanzi, ngamazwi onke. Kule nto, kukho umsebenzi owahlukileyo, kwaye kulula kakhulu kuneyangaphambili. Eli nqaku libizwa ngokuba yi-propnant. I-syntax yayo ilula kakhulu:

= Lungiselela (intetho ye-dilesi)

Umzekelo, ukusebenzisa kwayo, ukusebenzisa kwayo kuya kujonga ngolu hlobo lulandelayo.

1. Khetha indawo yasimahla yephepha. Cofa kwindawo ethi "Faka umsebenzi" icon.



2. KwiWizard eSebenzayo yemisebenzi, sikhangela "iRaknach". Sifumene eli gama, siyayibalisa kwaye icofe iqhosha "Kulungile".



3. Iwindow yempikiswano ivula. Sibeka isikhombisi kwintsimi ye- "versing". Khetha iseli yokuqala kunye nefani kwitafile yomthombo. Emva kokuba idilesi yakhe ibetha iwindows yempikiswano, cofa kwiqhosha le-Ok.

   

   Kukho olunye ukhetho lwesenzo ngaphandle kokuqalisa iWizard yeMisebenzi. Ukwenza oku, kufuneka, njengakwindlela yangaphambili, faka umsebenzi ngesandla kwiseli ngokurekhodwa kwedatha yemithombo. Kule meko, lo mnikelo uza kuba neyona ndlela ilandelayo:

   = Lungiselela (B4)

   Emva koko kuya kufuneka ucinezele iqhosha lokungena.

   Ukukhetha ukhetho oluthile kuxhomekeke ngokupheleleyo kumsebenzisi. Kuba abo basebenzisi abangasetyenziselwanga ukugcina iifomula ezahlukeneyo entloko, ngokwemvelo, kulula ukwenza ngoncedo lwe-wizard yemisebenzi. Kwangelo xesha, abanye bakholelwa ukuba ngokukhawuleza kunokungena kwi-operator.

4. Nokuba yeyiphi na ukhetho olukhethiweyo, kwisisele esasifumana isiphumo esifunekayo. Ngoku lonke igama elitsha kwiseli liqala ngoonobumba abakhulu. Okokugqibela, Khuphela ifomula kwiiseli ezingezantsi.



5. Emva koko Khuphela iziphumo usebenzisa imenyu yemeko.



6. Faka idatha nge "Ixabiso" lezinto ezifaka iiparamitha kwitafile yomthombo.



7. Susa iinqobo eziphakathi ngemenyu yemeko.



8. Kwifestile entsha, qinisekisa ukususwa kwemiqolo ngokumisela ukutshintshela kwisikhundla esifanelekileyo. Cofa iqhosha "Kulungile".

Emva koko, siya kufumana itafile engaguqukiyo engaguqukiyo, kodwa ngamagama onke kwiiseli eziphathwayo ngoku abhalwe ngoonobumba abakhulu.

Njengoko ubona, ngaphandle kwento yokuba utshintsho oluninzi lweeleta ezisezantsi eziya kwi-Excel kwi-Excel, nangona kunjalo, kulula kakhulu kunokutshintsha abalinganiswa, ngakumbi xa kuninzi yabo. Ezi algorithms ezingasentla zikhusela kuphela amandla omsebenzisi, kodwa ixesha elixabisekileyo lixesha. Ke ngoko, kunqweneleka ukuba umsebenzisi osisigxina uphume e-Explil anokusebenzisa ezi zixhobo emsebenzini wawo.