Umsebenzi Umama e-Excel

Njengoba wazi, i-Excel inamathuluzi amaningi okusebenzisana no-matric. Enye yazo umsebenzi we-muffer. Ngalesi sisebenzisi, abasebenzisi babonakala baphinda imizila ehlukile. Ake sibheke ukuthi singasisebenzisa kanjani lesi sici ekusebenzeni, futhi yini ama-nuances asemqoka wokusebenza nawo.

Usebenzisa i-opharetha ye-muffer

Umsebenzi oyinhloko we-MUM ufika, njengoba kushiwo ngenhla, ukwandisa umatikuletsheni ezimbili. Kubhekisa esigabeni sabasebenza ezibalo.

I-syntax yalesi sici imi ngale ndlela elandelayo:

= Umama (i-array11; i-array2)

Njengoba sibona, opharetha unezimpikiswano ezimbili kuphela - "i-Array1" ne- "array". I-ARGOLY ngayinye ibhekisele komunye wama-matric, okufanele akhuphuke. Yilokhu kanye opharetha abachazwe ngenhla.

Isimo esibalulekile sokusebenzisa i-MUMS ukuthi inani lezintambo ze-matrix yokuqala kufanele lihambisane nenombolo yamakholomu wesibili. Esimweni esiphambene, kuzokhishwa iphutha ngenxa yokucutshungulwa. Futhi, ukuze ugweme iphutha, azikho izakhi zazo zombili lezi kufanele zingabi nalutho, futhi kufanele ziqukethe ngokugcwele izinombolo.

Ukuphindaphinda kwe-matrix

Manje ake sicabangele ngesibonelo esithile, njengoba ungaphindaphinda umatikuletsheni ezimbili, usebenzisa i-opharetha ye-Muffer.

1. Vula ishidi le-Excel lapho kutholakala khona umatikuletsheni ezimbili. Sigqamisa indawo yamaseli angenalutho kuwo, okuyinto eyakhiwe ngokuvundlile inani lezinhlobo zama-matric okuqala, futhi ngokuqondile inani lamakholomu we-matrix yesibili. Okulandelayo, sichofoza isithonjana esithi "Insert Function", esiseduze komugqa wamafomula.



2. Imisebenzi Wizard iyaqala. Kufanele siye esigabeni "Mathematics" noma "uhlu olugcwele lwezinhlamvu". Uhlu lwabasebenza, kuyadingeka ukuthola igama elithi "Muffer", ligqamise bese uchofoza inkinobho ethi "KULUNGILE", okutholakala ezansi kwale windi.



3. Iwindi lezimpikiswano ze-opharetha iMmpembette yethulwa. Njengoba sibona, inezinkambu ezimbili: "I-Array1" ne- "Array". Ewokuqala kufanele acacise izixhumanisi ze-matrix yokuqala, kanti okwesibili, ngokulandelana, owesibili. Ukuze wenze lokhu, beka isikhombisi emkhakheni wokuqala. Ngemuva kwalokho sikhiqiza ukuvala ngenkinobho yegundane kwesobunxele bese ukhetha indawo yamaseli aqukethe i-matrix yokuqala. Ngemuva kokwenza le nqubo elula, izixhumanisi zizokhonjiswa ensimini ekhethiwe. Isenzo esifanayo senziwa nensimu yesibili, kulokhu kuphela, ngokubamba inkinobho yegundane kwesobunxele, sigqamisa i-matrix yesibili.

   Ngemuva kokuthi amakheli womabili abhalwe phansi, ungagijimeli ukucindezela inkinobho ethi "Kulungile", ibekwe engxenyeni engezansi yewindi. Iqiniso ngukuthi sisebenzelana nomsebenzi we-array. Inikeza ukuthi umphumela awukhonjiswanga esitokisini esisodwa, njengasemisebenzini ejwayelekile, kodwa ngokushesha ebangeni lonke. Ngakho-ke, ukukhipha ukucubungula kwedatha, kusetshenziswa lo opharetha, akwanele ukucindezela ukhiye we-ENTER, ukubeka isikhombisi emugqeni wefomula, noma chofoza inkinobho ethi "KULUNGILE" ngenkathi kuvulwa okwamanje. Udinga ukufaka isicelo ngokucindezela inhlanganisela yokhiye we-CTRL + Shift + Enter. Sifeza le nqubo, futhi inkinobho ethi "Kulungile" ayithinti.



4. Njengoba singabona, ngemuva kokucindezela inhlanganisela yekhibhodi ebekiwe, izimpikiswano zezimpikiswano zabasebenzisi, i-Mumset ivaliwe, kanye nobubanzi bamaseli, esabelwe esinyathelweni sokuqala salo myalelo, sagcwaliswa imininingwane. Kungamanani lawo angumphumela wokuphindaphinda i-matrix eyodwa komunye, owenza opharetha we-muffer. Njengoba sibona, emugqeni wefomula, umsebenzi uthathwa kubakaki be-curly, okusho ukuthi okungokwama-apharetha ama-array.



5. Kepha yikho ngqo ukuthi umphumela wokucubungula umsebenzi kuma-MUMS uluhlu oluqinile, kuvimbela ushintsho lwalo oluqhubekayo uma kunesidingo. Lapho uzama ukushintsha noma yiziphi izinombolo zomphumela wokugcina womsebenzisi, kuzobe kulinde umyalezo okwazisa ukuthi akunakwenzeka ukuguqula ingxenye ye-array. Ukuqeda lokhu kuphazamiseka futhi kuguqule i-array engaguquki kuhlu olujwayelekile lwedatha ongasebenza khona, yenza lezi zinyathelo ezilandelayo.

   Sigqamisa leli banga futhi, ngenkathi sisethebhu yasekhaya, chofoza isithonjana se- "Copy", esitholakala kubha yamathuluzi "Exchange Buffer". Futhi, esikhundleni salokhu kusebenza, ungafaka isethi ye-CTRL + C.



6. Ngemuva kwalokho, ngaphandle kokususa ukukhethwa ebangeni, chofoza kuyo ngenkinobho yegundane efanele. Kumenyu evulekile yokuqukethwe ku- "Faka izilungiselelo" block, khetha into ethi "Amanani".



7. Ngemuva kokwenza lesi senzo, i-matrix yokugcina ngeke isakwethulwa njengohlu olulodwa lwe-itextic futhi ingenziwa ngokukhohlisa okuhlukahlukene.

Isifundo: Sebenza ngezandla ku-Excel

Njengoba ubona, opharetha kamama bekuvumela ukuthi usheshe futhi kalula wande kakhulu ku-Excel Matirc amabili komunye nomunye. I-syntax yalo msebenzi ilula kakhulu futhi abasebenzisi akufanele babe nezinkinga zokufaka idatha ewindini lokuxabana. Inkinga kuphela engenzeka lapho usebenza nalolu hlelo lokusebenza lilele eqinisweni lokuthi limele umsebenzi we-array, ngakho-ke inezici ezithile. Ukubonisa umphumela, kunesidingo sokukhetha kuqala uhla oluhambisanayo eshidini, bese ngemuva kokungena ezimpikiswaneni ukubala, faka inhlanganisela ekhethekile yokhiye, oklanyelwe ukusebenza ngohlobo lwedatha enjalo - I-CTRL + Shift + Enter.