Njengoba wazi, i-Excel inamathuluzi amaningi okusebenza ngamatrices. Omunye wabo ngumsebenzi we-MUMMY. Ngalesi opharetha, abasebenzisi banethuba lokutshala amamatiridi ahlukene. Masifunde ukuthi singayisebenzisa kanjani lo msebenzi ngokuzikhandla, futhi yiziphi izici eziyinhloko zokusebenza nazo.
Sebenzisa umsebenzisi womama
Umsebenzi oyinhloko womsebenzi Umama, njengoba kushiwo ngenhla, ukuphindaphinda kwamatrices amabili. Yingxenye yesigaba sezinhlelo zokusebenza zezibalo.
I-syntax yalo msebenzi ilandelayo:
= MUMNAGE (i-array1; i-array2)
Njengoba ungabona, opharetha unezimpikiswano ezimbili kuphela - "Massive1" futhi "Massiv2". Ngenye yezingxabano ukuxhuma komunye wematrices, okufanele wande. Yilokho okushiwo isitatimende esingenhla.
Okuyimfuneko ebalulekile yesicelo Umama kungukuthi inani lemigqa ye-matrix yokuqala kufanele ifane nenani lamakholomu wesibini. Uma kungenjalo, umphumela wokucubungula uzoba iphutha. Futhi, ukuze ugweme amaphutha, ayikho enye yezingxenye zombili izigcawu ezingenalutho, kodwa kufanele ihlanganise nezinamba ngokuphelele.
Ukubuyabuyelela komthamo
Manje ake sithathe isibonelo sokhonkolo sokucabangela ukuthi ungayandisa kanjani izibalo ezimbili ngokusebenzisa opharetha Umama.
- Sivula i-Excel sheet, lapho izibalo ezimbili sezivele zikhona khona. Sakhetha kuso isifunda samangqamuzana angenalutho, okuyinto enezingqimba ezinamanani emigqa yokuqala, futhi ngokulinganisa inani lamakholomu wesibili sesibili. Okulandelayo, chofoza isithonjana "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.
- Qalisa kwenzeka Amakhosi omsebenzi. Kufanele sihambe esigabeni "Isibalo" noma "Uhlu oluphelele lwe-alfabhethi". Ohlu lwabo opharetha badinga ukuthola igama "UMUMNOZH", ukhethe bese ucindezela inkinobho "Kulungile"elitholakala phansi kule window.
- Iwindi lempikiswano ye-Operator iqala. Umama. Njengoba ungabona, inezinkambu ezimbili: "Massive1" futhi "Massiv2". Ekuqaleni udinga ukucacisa izixhumanisi zesibalo sokuqala, futhi okwesibili, ngokulandelana, okwesibili. Ukuze wenze lokhu, setha isikhangiso ensimini yokuqala. Khona-ke senza i-clamp ngekinobho lesinxele lesinxele bese ukhetha indawo yeseli equkethe i-matrix yokuqala. Ngemva kokwenza le nqubo elula, izixhumanisi zizoboniswa kwenkambu ekhethiwe. Senza isenzo esifanayo nensimu yesibili, kuphela kulokhu, ubambe inkinobho yegundane lesokunxele, khetha i-matrix yesibili.
Ngemuva kokubhaliwe amakheli womabili matrices, ungasheshi ukucindezela inkinobho "Kulungile"efakwe ngaphansi kwefasitela. Iphuzu liwukuthi sisebenzisana nomsebenzi ohlangene. Ihlinzeka ukuthi umphumela awuboniswa esitokisini esisodwa, njengemisebenzi ejwayelekile, kodwa ngokushesha kufinyelele ebangeni lonke. Ngakho-ke, ukuze ubonise ukucubungula kwedatha okuphelele usebenzisa lo opharetha, akwanele ukucindezela Ngenangokufaka isikhombisi ku-bar yefomula, noma uchofoze inkinobho "Kulungile", ekubeni efasiteleni lokuphikisana lomsebenzi okwamanje ovulekile kithi. Udinga ukusebenzisa i-keystroke Ctrl + Shift + Faka. Yenza le nqubo, futhi inkinobho "Kulungile" ungathinti.
- Njengoba ungabona, emva kokucindezela izingqikithi zenkinobho ye-opharetha yenkampani yokuphawula Umama ivaliwe, nobubanzi bamaseli, esiwabonayo esiteji sokuqala sale myalelo, sigcwele idatha. Yilezi zindinganiso eziwumphumela wokwandisa i-matrix eyodwa ngomunye, okwenziwa opharetha Umama. Njengoba ungabona, lo msebenzi uthathwa kubakaki abaphephile emgqeni wefomula, okusho ukuthi kungokwalabo abasebenza ngokulandelana.
- Kodwa ncamashi umphumela womsebenzi wokucubungula Umama iyinhlangano eqinile, ivimbela ushintsho olwengeziwe uma kunesidingo. Uma uzama ukushintsha noma yiziphi izinombolo zomphumela wokugcina, umsebenzisi uzolinda umyalezo okwazisa ukuthi awukwazi ukushintsha ingxenye yohlu. Ukuqeda lokhu kuphazamiseka nokuguqula uhlu olungaguquki kolwazi olujwayelekile olungasebenzisana nalo, yenza izinyathelo ezilandelayo.
Khetha leli hlu futhi, ekubeni kuthebhu "Ikhaya", chofoza kusithonjana "Kopisha"esitholakala kwibhulogi yamathuluzi "Ibhodi lokunamathisela". Futhi, esikhundleni salokhu kusebenza, ungasebenzisa isethi yokusinqamuleli Ctrl + C.
- Ngemuva kwalokho, ngaphandle kokukhipha ukhetho kusuka ebangeni, chofoza kukho inkinobho yegundane kwesokudla. Emenyu yemenyu evulwe ku-block "Izinketho zokufaka" khetha into "Amanani".
- Ngemuva kokwenza lesi senzo, umthamo wokugcina ngeke usabelwa njengeluhlobo olulodwa olungaxhunyiwe futhi ukuphathwa okuhlukahlukene kungenziwa nayo.
Isifundo: Sebenzisa nge-arrays ku-Excel
Njengoba ungabona, opharetha Umama ikuvumela ukuthi ukwandise ngokushesha futhi kalula amatrices amabili komunye nomunye ku-Excel. I-syntax yalo msebenzi ilula futhi abasebenzisi akufanele babe nezinkinga zokufaka idatha kwiwindi lempikiswano. Inkinga kuphela engase iphakame lapho usebenza nalolu opharetha ukuthi yinto yokusebenza, okusho ukuthi inezici ezithile. Ukuze ubonise umphumela, okokuqala kudingeka ukhethe ibanga elifanele eshadini, bese emva kokufaka izingxabano zokubala, sebenzisa inhlanganisela eyinhloko yokwakheka eklanyelwe ukusebenza nale hlobo lwedatha - Ctrl + Shift + Faka.
