Ukuhlaziywa kokuhlangana ku-Excel: 2 Izinketho zomsebenzi

Ukuhlaziywa kokuhlangana kuyindlela ethandwayo yocwaningo lwezibalo, olusetshenziselwa ukukhomba isilinganiso sokuncika kwenkomba eyodwa kusuka kolunye. I-Microsoft Excel inethuluzi elikhethekile elenzelwe ukwenza lolu hlobo lokuhlaziywa. Ake sibheke ukuthi singawusebenzisa kanjani lo msebenzi.

Umongo wokuhlaziywa kokuhlangana

Inhloso yokuhlaziywa kokuhlangana kuncishiswa ukukhombisa ukuncika phakathi kwezinto ezahlukene. Lokho wukuthi, kunqunywe ukuthi ngabe ukwehla kuthonywa noma kukhuphuke enkombeni eyodwa eshintsheni kwenye.

Uma ukuncika kusunguliwe, ukuhlanganiswa kokuhlangana kunqunywa. Ngokungafani nokuhlaziywa kabusha kokubuyiselwa emuva, lokhu kungukuphela kwenkombabala le ndlela yokucwaninga kwezibalo. Ukuhlanganiswa kokuhlanganiswa kwemali kuyehlukahluka kusuka ku-RACE kusuka ku- +1 kuya ku -1. Uma kunokuhlobana okuhle, ukwanda kwenkomba eyodwa kunomthelela ekwandeni kwesibili. Ngokuhlangana okungalungile, ukwanda kwenkomba eyodwa kufaka ukwehla kwenye. Uma kukhuliswa imodyuli yokuxhumanisa, ushintsho olubonakala kakhulu kwinkomba eyodwa luboniswa ocwaningweni lwesibili. Ngomsebenzi olingana no-0, ukuncika phakathi kwawo akukho ngokuphelele.

Ukubalwa kokuhlanganiswa kokuhlangana

Manje ake sizame ukubala ukuhlanganiswa kokuhlangana kwesibonelo esithile. Sinetafula lapho kupendwe njalo ngenyanga ezihlatshelweni ezihlukile zezindleko zokukhangisa nokuthengisa. Kufanele sithole ukuncika kokuncika kwenani lokuthengisa kusuka kwinani lemali, elichithwe ekukhangiseni.

Indlela 1: Ukunquma ukuxhumeka nge-Master of Exctions

Enye indlela ukuhlaziywa kokuhlangana kungenziwa lapho kuqhutshwa khona ukusebenzisa umsebenzi wokuhlangana. Umsebenzi ngokwawo unombono ojwayelekile we-corneal (i-array1; i-array2).

1. Khetha iseli lapho umphumela wokubalwa kufanele ukhishwe khona. Chofoza inkinobho ethi "Insert Function", ebekwe ngakwesobunxele ngentambo yefomula.



2. Kuluhlu, olwethulwa eWizard Wizard, sibheka futhi sabela umsebenzi we-cornel. Chofoza inkinobho ethi "KULUNGILE".



3. Ukuphikisana nomsebenzi kuyavuleka. Ensimini ethi "Massveive1", sethula izixhumanisi zebanga lamaseli kwelinye lamanani, ukuncika kwalo kufanele kunqunywe. Endabeni yethu, lokhu kuzoba amanani ekholomu "yokuthengisa". Ukuze ungeze ikheli lama-array emkhakheni, mane unikeze wonke amaseli ngedatha kwikholomu engenhla.

   Ensimini "Massive2" udinga ukwenza izixhumanisi zekholomu yesibili. Sinezindleko zokukhangisa. Njengasesimweni esedlule, sangena kwimininingwane esensimini.

   Chofoza inkinobho ethi "KULUNGILE".

Njengoba sibona, i-coefficient efanelekile ngesimo senombolo ivela esitokisini esikhethe. Kulokhu, kulingana no-0.97, okuyisici esiphezulu kakhulu sokuncika kwenani elilodwa kusuka kwenye.

Indlela 2: Ukubala ukuhlangana kusetshenziswa iphakethe lokuhlaziywa

Ngaphezu kwalokho, ukuhlangana kungabalwa kusetshenziswa elinye lamathuluzi, elimelelwe kwiphakethe lokuhlaziya. Kepha ngaphambi kokuba sidinge leli thuluzi ukuze lisebenze.

1. Iya kuthebhu ethi "File".



2. Efasiteleni elivula, lithuthele esigabeni se- "Parameters".



3. Okulandelayo, yiya ku- "Engeza-In".



4. Ngezansi kwewindi elilandelayo esigabeni se- "Management", sihlele kabusha ukushintshela esimweni esithi "Excel Add-In", uma kungenye isikhundla. Chofoza inkinobho ethi "KULUNGILE".



5. Efasiteleni lezengezo, sifaka umkhaza eduze kwento "yokuhlaziya iphakethe". Chofoza inkinobho ethi "KULUNGILE".



6. Ngemuva kwalokho, iphakethe lokuhlaziya liyasebenza. Iya kuthebhu "yedatha". Njengoba ubona, kuvela ibhlokhi entsha yamathuluzi ku-Ribbon - "Ukuhlaziywa". Chofoza inkinobho ethi "Ukuhlaziywa Kwedatha", okutholakala kuyo.



7. Uhlu olunezinketho ezahlukahlukene zokuhlaziywa kwedatha. Khetha iphuzu "ukuxhumeka". Chofoza inkinobho ethi "KULUNGILE".



8. Iwindi livula ngamapharamitha wokuhlaziya izixhumanisi. Ngokuphikisana nendlela edlule, enkundleni "Isikhashana Sokufaka" Sethula isikhawu sekholomu ngayinye ngokwehlukana, kepha wonke amakholomu ahilelekile ekuhlaziyweni. Kuthu, le yidatha kumakholomu "izindleko zokukhangisa" kanye "nenani lokuthengisa".

   Ipharamitha "yokugaya" ishiywe ingashintshiwe - "kumakholomu", ngoba sineqembu ledatha liphukile libe amakholomu amabili. Uma bebephukile, khona-ke kufanele bahlelwe kabusha lapho kushintshwa khona lapho "emigqeni".

   Kumapharamitha azenzakalelayo okukhishwa, "Into entsha yomsebenzi" isethwe, okungukuthi, imininingwane izokhonjiswa kwelinye ishidi. Ungashintsha indawo ngokususa inkinobho. Kungaba ishidi lamanje (khona-ke uzodinga ukucacisa izixhumanisi zamaseli okukhipha ulwazi) noma incwadi entsha yokusebenza (ifayela).

   Lapho zonke izilungiselelo zisethwe, chofoza inkinobho ethi "Kulungile".

Kusukela kuhlaziywe kwemiphumela yokuhlaziywa kwesokunxele ngokuzenzakalelayo, sithuthela eshidini elisha. Njengoba ubona, ukuhlanganiswa kokuhlangana kukhonjisiwe. Ngokwemvelo, uyefana nalapho usebenzisa indlela yokuqala - 0.97. Lokhu kuchazwa yiqiniso lokuthi zombili izinketho zenza izibalo ezifanayo, zimane zikhiqize ngezindlela ezihlukile.

Njengoba ubona, uhlelo lokusebenza lwe-Excel lunikeza izindlela ezimbili zokuhlaziywa kokuhlangana ngasikhathi sinye. Umphumela wokubalwa, uma wenza konke kahle, kuzofana ngokuphelele. Kepha, umsebenzisi ngamunye angakhetha isichasiselo esikahle ngakho.