Lapho usebenza namatafula e-Excel, kuvame ukubhekana nawo wonke amabanga wemininingwane. Ngasikhathi sinye, eminye imisebenzi isho ukuthi lonke iqembu lamaseli kumele liguqulwe ngokoqobo ngokuchofoza okukodwa. I-Excel inamathuluzi akuvumela ukuba wenze imisebenzi enjalo. Ake sibheke ukuthi ungawaphatha kanjani ama-datha wedatha kulolu hlelo.
Imisebenzi ye-Array
Amalungu afanayo yiqembu ledatha etholakala ephepheni kumaseli aseduze. Ngokubanzi, noma yiliphi ithebula lingabhekwa njengamalungu afanayo amaningi, kepha hhayi kwalunye kuwo yitafula, ngoba lingaba nje ububanzi. Ngamafuphi, izifunda ezinjengalezi zingaba ntathu noma zibe ntathu (matrices). Esimweni sokuqala, yonke idatha itholakala kukholamu eyodwa noma umugqa kuphela.
Kwesibili - eminingana ngasikhathi sinye.
Ngaphezu kwalokho, izinhlobo ezivundlile futhi mpo zihlukaniswa phakathi kwama-array akweleteni elilodwa, kuye ngokuthi angumugqa noma ikholomu.
Kufanele kuqashelwe ukuthi i-algorithm yokusebenza ngamabanga afanayo ihlukile ngokuthile okujwayelekile ekusebenzeni ngamaseli angashadile, yize kunokufana okuningi phakathi kwawo. Ake sibheke ubuciko bemisebenzi enjalo.
Dala IFomula
Ifomula yamalungu afanayo iyinkulumo lapho uhla lucubungulwa ngalo ukuthola umphumela wokugcina oboniswe njengamalungu afanayo onke noma esitokisini esisodwa. Isibonelo, ukuze ngandise uhla olulodwa ngesibili, faka ifomula ngokuya ngephethini elandelayo:
= array_address1 * arr__ddress2
Ungase futhi wenze ukwengeza, ukususa, ukwahlukanisa, neminye imisebenzi ye-arithmetic kumabanga wedatha.
Izixhumanisi zamalungu afanayo zikwindlela yamakheli weseli lakhe lokuqala nelokugcina, ahlukaniswe yikholoni. Uma uhla lunezinhlangothi ezimbili, khona-ke amaseli okuqala nawokugcina atholakala ngokusobala komunye nomunye. Isibonelo, ikheli lehlu elilodwa-elifanayo lingaba kanjena: A2: A7.
Futhi isibonelo sekheli lezinhlangothi ezimbili ezinobukhulu yile ndlela elandelayo: A2: D7.
- Ukubala ifomula efanayo, udinga ukukhetha ephepheni indawo lapho umphumela uzokhonjiswa khona, bese ufaka isisho sokubalwa emugqeni wefomula.
- Ngemuva kokungena, chofoza inkinobho Ngenanjengokujwayelekile, bese uthayipha inhlanganisela yokhiye I-Ctrl + Shift + Faka. Ngemuva kwalokho, isabizwana esisebhomeni yefomula sizothathwa ngokuzenzakalela kubakaki abangama-curly, futhi amaseli aseshidi ayogcwaliswa ngemininingwane etholakele ngenxa yokubala, kulo lonke uhla olukhethiwe.
Ukushintsha okuqukethwe afanayo
Uma ngokuzayo uzama ukususa okuqukethwe noma ushintshe noma yimaphi amaseli akhiwe ebangeni lapho umphumela ukhonjiswe khona, isenzo sakho siyohluleka. Futhi, akukho lutho oluzosebenza uma uzama ukuhlela imininingwane emgqeni wokusebenza. Kuzovela umlayezo wolwazi lapho kuzothiwa akunakwenzeka ukushintsha ingxenye yamalungu afanayo. Lo mlayezo uzovela noma ngabe awunanhloso yokwenza ushintsho, futhi uchofoze kabili ngephutha kuseli ebangeni.
Uma uvala, lo mlayezo ngokuchofoza inkinobho "Kulungile", bese uzama ukuhambisa isikhombisi ngegundane, noma mane ucindezele inkinobho "Ngena", bese umlayezo wolwazi uzovela futhi. Futhi izokwehluleka ukuvala iwindi lohlelo noma igcine idokhumenti. Lo mlayezo ocasulayo uzovela ngaso sonke isikhathi, ovimba noma yiziphi izenzo. Kepha kunendlela yokuphuma kulesi simo futhi ilula
- Vala iwindi lolwazi ngokuchofoza inkinobho "Kulungile".
- Bese uchofoza inkinobho Khansela, etholakala kwiqembu lezithombe ngakwesokunxele komugqa wamafomula, futhi oyisithonjana esesimweni sesiphambano. Ungachofoza inkinobho. I-Esc kwikhibhodi. Ngemuva kwanoma yikuphi kwalokhu kusebenza, isenzo sizokhanselwa, futhi uzokwazi ukusebenza ngeshidi njengangaphambili.
Kepha kuthiwani uma udinga ngempela ukususa noma ukushintsha ifomula yamalungu afanayo? Kulokhu, yenza okulandelayo:
- Ukushintsha ifomula, khetha ngesikhombisi, ukubamba inkinobho yegundane kwesobunxele, lonke uhla kushidi lapho kuboniswa khona umphumela. Lokhu kubaluleke kakhulu, ngoba uma ukhetha iseli elilodwa kuphela ku-array, ngakho-ke akukho okusebenzayo. Ngemuva kwalokho, kubha yefomula, yenza ushintsho oludingekayo.
- Ngemuva kokuthi izinguquko zenziwe, shayela inhlanganisela I-Ctrl + Shift + Esc. Ifomula lizoguqulwa.
- Ukususa ifomula yamalungu afanayo, njengasesimweni esedlule, khetha lonke uhla lwamaseli lapho akhona nesikhombisi. Bese uchofoza inkinobho Susa kwikhibhodi.
- Ngemuva kwalokho, ifomula izosuswa kuyo yonke indawo. Manje kuzokwazi ukufaka noma iyiphi idatha kukho.
Imisebenzi ye-Array
Kulula kakhulu ukusebenzisa imisebenzi eyenziwe nge-Excel eyenziwe ngefomula. Ungawafinyelela Isici Wizardngokucindezela inkinobho "Faka umsebenzi" ngakwesokunxele sebha yefomula. Noma kuthebhu Amafomula Kubambo, ungakhetha esisodwa sezigaba lapho opharetha wenzalo etholakala khona.
Ngemuva kokuthi umsebenzisi ungene Umsebenzi wizadi noma khetha igama le-opharetha ethile kubha yamathuluzi, iwindi lezimpikiswano zomsebenzi liyavula lapho ungafaka khona idatha yokuqala yesibalo.
Imithetho yokungena nokuhlela imisebenzi, uma ikhombisa umphumela kumaseli amaningana ngasikhathi sinye, kufana nakwifomula ejwayelekile yama-array. Okusho ukuthi, ngemuva kokufaka inani, kufanele ubeke isikhombisi kubha yefomula bese uthayipha inhlanganisela yokhiye I-Ctrl + Shift + Faka.
Isifundo: Umsebenzi Wizard e-Excel
Isisebenzisi se-SUM
Enye yezinto eceliwe kakhulu ku-Excel ISUM. Ingasetshenziswa zombili ukufingqa okuqukethwe amaseli ngamanye, nokuthola isamba semidwebo ephelele. I-syntax yalesi sitatimende samalungu afakelwe ngokulandelayo:
= SUM (uhlu1; uhlu2; ...)
Lo opharetha ukhombisa umphumela kuseli elilodwa, futhi ngenxa yalokho, ukuze enze ukubala, ngemuva kokufaka idatha yokufaka, kwanele ukucindezela inkinobho "Kulungile" ewindini lokuphikisana ngomsebenzi noma ukhiye Ngenauma okokufaka bekuyincwadi ebhaliwe.
Isifundo: Ungayibala kanjani inani ku-Excel
ISIVIVINYO SE-TRANSPOSE
Umsebenzi UKUTHENGA ungumsebenzisi ojwayelekile wamalungu afanayo. Ikuvumela ukuthi uguqule amatafula noma umatikuletsheni, okungukuthi, shintsha imigqa namakholomu ezindaweni. Ngaso leso sikhathi, sisebenzisa kuphela ukukhipha umphumela kububanzi beseli, ngakho-ke, ngemuva kokwethula lo opharetha, kubalulekile ukufaka inhlanganisela I-Ctrl + Shift + Faka. Kufanele futhi kuqashelwe ukuthi ngaphambi kokwethula inkulumo uqobo, kuyadingeka ukukhetha ephepheni indawo lapho inani lamaseli kukholamu lizolingana nenani lamaseli emugqeni wethebula lokuqala (matrix) futhi, ngakolunye uhlangothi, inani lamaseli emugqeni kufanele alingane nenombolo yawo kukholamu yomthombo. I-syntax yokusebenza kanjengale elandelayo:
= TRANSPOSE (uhlu)
Isifundo: Khipha amatrixes e-Excel
Isifundo: Ungaphendulela kanjani itafula ku-Excel
Isisebenzeli MOBR
Umsebenzi MOBR ikuvumela ukubala i-matrix ephambene. Yonke imithetho yokufaka yalowo opharetha iyefana ncamashi neyokuqala. Kepha kubalulekile ukwazi ukuthi ukubalwa kwe-matrix okungafani kungenzeka kuphela uma iqukethe inani elilinganayo lemigqa namakholomu, futhi uma isibonakaliso sayo singalingani no-zero. Uma usebenzisa lo msebenzi endaweni enenombolo ehlukile yemigqa namakholomu, esikhundleni somphumela ofanele, umphumela uzokhombisa inani "#VALUE!". I-syntax yale formula yile:
= MOBR (uhlu)
Ukuze ukubala okucacayo, umsebenzi usetshenziswa nge-syntax elandelayo:
= MOPRED (uhlu)
Isifundo: I-matrix ehlukile ku-Excel
Njengoba ukwazi ukubona, ukusebenza ngezinhla kusiza ukonga isikhathi ngesikhathi sokubala, kanye nendawo yamahhala eshidi, ngoba awudingi ukwengeza ngamafuphi imininingwane ehlanganiswe ibanga ukuze uqhubeke nokusebenza nabo. Konke lokhu kwenziwa epheshaneni. Futhi imisebenzi yamatafula namalungu afanayo kuphela afanele ukuguqula amatafula namatikuletsheni, ngoba amafomula ajwayelekile awakwazi ukubhekana nemisebenzi efanayo. Kepha ngasikhathi sinye, udinga ukuthi ubheke ukuthi imithetho eyengeziwe yokufaka nokuhlela isebenza kuzinkulumo ezinjalo.
