Umsebenzi wokubamba kwi-Excel

Enye yeempawu ezinomdla zesicelo seMicrosoft Excel ngumsebenzi wokuvumela. Umsebenzi wayo ophambili kukunxibelelanisa iziqulatho zeeseli ezimbini okanye ngaphezulu kwenye. Lo msebenzi unceda ukusombulula imisebenzi ethile engenakuqulunqwa kusetyenziswa ezinye izixhobo. Umzekelo, kufanelekile ukuvelisa inkqubo yokudibanisa iiseli ngaphandle kwelahleko. Cinga ngamathuba alo msebenzi kunye nengqondo yokusetyenziswa kwayo.

Ukubanjwa kwesicelo sokusebenza

Umsebenzi wengqekembe ubhekisa kwiqela leNgxelo ye-Excel. Owona msebenzi uphambili kukudibanisa kwiseli enye yeziqulatho zeeseli ezininzi, kunye nabalinganiswa abathile. Ukuqala ukusuka kwi-Excel 2016, endaweni yalo msebenzi, kusetyenziswa umsebenzi wekhadi. Kodwa ukuze sigcine ukubuyela umva, i-operator ishiywe, kwaye inokusetyenziswa kwibar.

I-syntax yale-Operator ijongeka ngolu hlobo:

= Ukubamba (isicatshulwa1; isicatshulwa2; ...)

Njengoko iimpikiswano zinokusebenza njengombhalo kunye neembekiselo kwiiseli eziqulathe. Inani leempikiswano zinokwahluka ukusuka kwi-1 ukuya kwi-255.

Indlela yoku-1: Idatha yokudibanisa kwiiseli

Njengoko uyazi, iiseli eziqhelekileyo zokudibanisa e-Excel zikhokelela ekulahlekelweni kwedatha. Idatha kuphela igcinwe kwindawo ephezulu yekhohlo. Ukuze udibanise okubhalwe kule seli ezimbini nangaphezulu zibe yi-Excel ngaphandle kwelahleko, ungawusebenzisa umsebenzi wokufakwa.

1. Khetha iseli apho siceba ukubeka idatha edibeneyo. Cofa kwiqhosha "Colas Fun". Ijongene nee-pictograms kwaye ibekwe ngasekhohlo kwi-formaula.



2. I-Wizard ivula. Kwinqanaba "isicatshulwa" okanye "uluhlu olupheleleyo lwe-alfabhethi" Sikhangela "ukubamba". Sibalaselisa eli gama kwaye ucofe iqhosha "Kulungile".



3. I-Window Yengcaciso yeWebhu yewindows. Njengempikiswano, iimbekiselo kwiiseli eziqulatha idatha okanye isicatshulwa esahlukileyo. Ukuba umsebenzi ubandakanya ukudibanisa imixholo yeeseli, emva koko kule meko siza kusebenza kuphela ngeembekiselo.

   Faka isikhombisi kwintsimi yokuqala yefestile. Emva koko khetha ikhonkco kwiphepha apho idatha ifunekayo kuManyano lufumaneka. Emva kokuba izihlanganisi ziboniswe efestileni, ngendlela efanayo, siyenza kwintsimi yesibini. Ngokuhambelana, sabela enye iseli. Senza umsebenzi ofanayo ngelixa i-contrinates yazo zonke iiseli ezifuna ukudityaniswa aziyi kungeniswa kwifestile yefestile. Emva koko, cofa kwiqhosha "Kulungile".



4. Njengoko ubona, imixholo yeendawo ezikhethiweyo ibonakalise kwiseli enye yangaphambi. Kodwa le ndlela inomvavanyo olubalulekileyo. Xa uyisebenzisa, ebizwa ngokuba "glit ngaphandle komthungo" yenzekile. Oko kukuthi, phakathi kwamagama akukho sithuba kwaye zifakwe kwinkcitho enye. Kwangelo xesha, akuyi kuba nakho ukongeza ngesandla ukongeza indawo, kodwa kuphela ngokuhlela kwefomula.

Isifundo: I-Wizard imisebenzi kwi-Excel

Indlela yesi-2: Ukusetyenziswa komsebenzi kunye nesithuba

Kukho amathuba okulungisa le mfihlakalo, ukufaka izithuba phakathi kwempikiswano yomqhubi.

1. Senza umsebenzi kwi-algorithm enye echazwe apha ngasentla.
2. Cofa kabini iqhosha lemouse lasekhohlo kwiseli kunye nefomula isebenze ngokuhlela.



3. Phakathi kwengxoxo nganye, bhala intetho ngohlobo lwendawo enomda kumacala amabini kunye neekowuti. Emva kokwenza ixabiso ngalinye, sibeka inqaku ngekoma. Imbono ngokubanzi yamagama ongezelelweyo kufuneka ibe zezi zilandelayo:

   " ";



4. Ukukhupha iziphumo kwisikrini, cofa kwiqhosha le-ENTER.

Njengoko ubona, kukho izahlulo phakathi kwamagama kwiseli ekufakweni kwezithuba ngezicatshulwa ezikwiseli.

Indlela 3: Yongeza indawo ngefestile yempikiswano

Ewe kunjalo, ukuba akukho maxabiso aguqulweyo aguqulweyo, emva koko inketho ye-faker igqibelele. Kodwa kuya kuba nzima ukuzisebenzisa ngokukhawuleza ukuba zininzi iiseli ezifuna ukudityaniswa. Ngakumbi ukuba ezi zeseli azikho kwinkcitho enye. Ungakhanyisa kakhulu ilungiselelo le-spacecraft usebenzisa inketho yokufakwa kwayo ngefestile yempikiswano.

1. Sibonisa ukucofa kabini kweqhosha lasekhohlo iqhosha lesisele esingenanto ephepheni. Sebenzisa ikhibhodi, faka indawo ngaphakathi kuyo. Kuyimfuneko ukuba kude ne-massif enkulu. Kubaluleke kakhulu ukuba esi selfowuni ayikaze emva koko izele nayiphi na idatha.



2. Senza izenzo ezifanayo njengakwindlela yokuqala yokusebenzisa umsebenzi ukwenza umsebenzi, ukuya kuvulwa kwifestile ye-operator yefestile. Yongeza ixabiso lesisele sokuqala ngedatha kwintsimi yewindows, njengoko sele ichaziwe ngaphambili. Emva koko setha isikhombisi kwicandelo lesibini, uze ukhethe iseli engenanto enendawo exutyushwe ngaphambili. Ikhonkco liyavela kwintsimi yewindows. Ukukhawulezisa le nkqubo, ungayikhuphela ngokuqaqambisa kunye nokucinezela ukudityaniswa kwe-CTRL + C.



3. Emva koko yongeza ikhonkco kwinto elandelayo ofuna ukongeza kuyo. Kwicandelo elilandelayo, yongeza ikhonkco kwiseli engenanto. Ekubeni sikopa idilesi yaso, unokuseta isikhombisi ebaleni kwaye ucinezele i-CTRL + V. Izinxibelelanisi ziya kufakwa. Ngale ndlela, sitshintshiselana ngezinto ngeedilesi zezinto ezingenanto. Emva kwayo yonke idatha yenziwe, cofa kwiqhosha "Kulungile".

Njengoko ubona, emva koko, irekhodi edibeneyo eyenziwe kwiseli ekugxilwe kuyo, ebandakanya imixholo yazo zonke izinto, kodwa ngezithuba phakathi kwegama ngalinye.

QAPHELA! Njengoko sibona, le ndlela ingentla imkhawulezisa inkqubo yokudibanisa ngokuchanekileyo kwiiseli. Kodwa kuyafuneka ukuba uqwalasele ukuba olu khetho luqobo kwaye "zimbi". Kubaluleke kakhulu ukuba kwinto equlathe indawo ayinayo idatha okanye ayitshintshwa.

Indlela 4: Ikholamu Yamanyano

Sebenzisa umsebenzi wokumisela, unokuphinda udibanise ezi kholamu kwenye.

1. Ngeeseli zomgca wokuqala weekholamu ezidibeneyo, siye safumana ukhetho lwesenzo esichazwe kwindawo yesibini neyesithathu yokusebenzisa ingxoxo. Kuyinyani, ukuba uthatha isigqibo sokusebenzisa indlela eneseli engenanto, emva koko ikhonkco kuyo iya kufuna ukwenza ngokupheleleyo. Kule, ngaphambi kophawu ngalunye oququzelela ngokuthe tye kunye nokuthe nkqo kweseli ebeka uphawu lwedola ($). Ngokwemvelo, kungcono ukwenza oku ekuqaleni kwamanye amasimi apho le dilesi iqulethe khona, umsebenzisi unokukukopa njengeendlela eziqhubekayo. Kumasimi aseleyo, sishiya amakhonkco esihambelana. Njengamaxesha onke, emva kokwenza le nkqubo, cofa kwiqhosha "Kulungile".



2. Sisomeleza isikhombisi kwi-engile esezantsi yendawo enesifo sefomula. I-icon ivela, enombono onqamlezileyo, obizwa ngokuba ngumphawu ophawulekayo. Cofa iqhosha lemouse lasekhohlo kwaye ulitsale phantsi elifanayo kwindawo yezinto ezidibeneyo.



3. Emva kokwenza le nkqubo, idatha kwiikholamu ezichaziweyo ziya kudityaniswa kwikholamu enye.

Isifundo: Ungayidibanisa njani iikholamu ekuthinjweni

Indlela yesi-5: Yongeza oonobumba abongezelelweyo

Unokunyanzela umsebenzi ukongeza oonobumba kunye neenkcazo ezingekho kumgangatho wokuqala ohlanganisiweyo. Ngapha koko, unokuphumeza abanye abaqhubi besebenzisa eli nqaku.

1. Yenza izenzo ukongeza amaxabiso kwifestile yempikiswano yomsebenzi ngayo nayiphi na indlela enikezwe apha ngasentla. Kwenye yamasimi (ukuba kukho imfuneko, kunokubakho ezinye ezininzi)) nayiphi na into ebhaliweyo ethathelwe ingqalelo ukuba iyongeza. Esi sicatshulwa kufuneka sivalelwe kwiikowuti. Cofa kwiqhosha "Kulungile".



2. Njengoko sibona, emva kweli nkuthazo kwidatha edityanisiweyo, yongezwa umbhalo wesicatshulwa.

Ukubanjwa komqhubi-ekuphela kwendlela yokudibanisa iiseli ngaphandle kwelahleko kwi-Excel. Ukongeza, nayo, ungaqhagamshela iikholamu zonke, Yongeza amaxabiso okubhaliweyo, qhuba ezinye izinto eziguqukayo. Ulwazi malunga ne-algorithm yomsebenzi kunye eli nqaku liya kwenza kube lula ukusombulula imiba emininzi yenkqubo yenkqubo.