Monga mukudziwa, Excel ili ndi zida zambiri zogwirira ntchito ndi matrices. Mmodzi wa iwo ndi ntchito ya MUMMY. Ndi ogwiritsira ntchitoyi, ogwiritsa ntchito ali ndi mwayi wochulukitsa matrices osiyanasiyana. Tiyeni tiphunzire momwe tingagwiritsire ntchito ntchitoyi pakuchita, ndipo ndi zinthu ziti zomwe zimagwira ntchito ndizo.
Gwiritsani ntchito mzimayi
Ntchito yaikulu ya ntchitoyo Mayi, monga tafotokozera pamwambapa, ndi kuchulukitsa kwa matrices awiri. Ndilo gawo la olemba masamu.
Chidule cha ntchitoyi ndi ichi:
= MUMNAGE (array1; array2)
Monga mukuonera, wogwiritsa ntchito ali ndi zifukwa ziwiri zokha - "Massive1" ndi "Massiv2". Zonsezi zimagwirizana ndi imodzi mwa matrices, yomwe iyenera kuchulukitsidwa. Izi ndi zomwe ndemanga yapamwamba imanena.
Chofunikira chofunika kuti ntchitoyi ikhale Mayi ndi kuti nambala ya mizere yoyamba iyenera kufanana ndi chiwerengero cha zigawo zachiwiri. Apo ayi, zotsatira za kukonza zidzakhala zolakwika. Ndiponso, kuti tipewe zolakwa, palibe chinthu chimodzi mwazigawo ziwiri ziyenera kukhala chopanda kanthu, koma ziyenera kukhala ndi nambala zonse.
Kuwonjezeka kwa matrix
Tsopano tiyeni titenge chitsanzo cha konkire kuti tiganizire momwe mungachulukitsire matrices awiri pogwiritsira ntchito wogwiritsira ntchito Mayi.
- Timatsegula pepala la Excel, limene matrices awiri ali kale. Timasankha dera lokhala ndi maselo opanda kanthu, omwe ali ndi chiwerengero cha mizere ya chiyero choyambirira, ndikuwunikira chiwerengero cha zipilala za chiwiri chachiwiri. Kenako, dinani pazithunzi "Ikani ntchito"yomwe ili pafupi ndi bar.
- Kuyamba kumapezeka Oyang'anira ntchito. Tiyenera kupita ku gululo "Masamu" kapena "Mndandanda wathunthu wa alfabeti". Pa mndandanda wa ogwira ntchito ayenera kupeza dzina "MUMNOZH", sankhani ndipo pezani batani "Chabwino"yomwe ili pansi pazenera ili.
- Fesito yotsutsana ndi otsogolera imayambira. Mayi. Monga mukuonera, ili ndi minda iwiri: "Massive1" ndi "Massiv2". Poyambirira muyenera kufotokoza zochitika za chiyero choyambirira, ndipo chachiwiri, mwachiwiri, chachiwiri. Kuti muthe kuchita izi, khalani ndondomeko yoyamba. Kenaka timapanga chofufumitsa ndi batani lamanzere ndikusankha selo yomwe ili ndi matrix yoyamba. Pambuyo pokonza njira yosavutayi, makonzedwewa adzawonetsedwa m'munda wosankhidwa. Timachita chimodzimodzi ndi gawo lachiwiri, nthawi ino yokha, ndikugwira batani lamanzere, kusankha mzere wachiwiri.
Pambuyo pa maadiresi onse awiriwa, musafulumire kukanikiza batani "Chabwino"anaika pansi pazenera. Mfundo ndikuti tikuchita ntchito zosiyanasiyana. Zimapereka kuti zotsatira zake sizisonyezedwa mu selo limodzi, monga muzinthu zowonongeka, koma nthawi yomweyo. Choncho, kuti muwonetsere chiwerengero chonse cha deta pogwiritsa ntchito operekera, sikokwanira kukanikiza Lowanipoika cholozera mu bar bar, kapena dinani pa batani "Chabwino", pokhala pazenera zogwirizana ndi ntchito yomwe tsopano yatseguka kwa ife. Muyenera kugwiritsa ntchito keystroke Ctrl + Shift + Lowani. Chitani izi, ndi batani "Chabwino" musakhudze.
- Monga mukuonera, mutatha kukanikiza mndandanda wachindunji wothandizira zenera zowonjezera Mayi kutsekedwa, ndi maselo osiyanasiyana, omwe tawapeza mu sitepe yoyamba ya malangizo awa, anadzazidwa ndi deta. Ndizofunika izi zomwe zimakhalapo chifukwa cha kuchulukitsa matrix ndi wina, omwe ochita opanga amachita Mayi. Monga mukuonera, ntchitoyi imatengedwa ndi mabotolo ophatikizana mu barre yazenera, zomwe zikutanthauza kuti ndizoyendetsa olemba ntchito.
- Koma ndendende zomwe zotsatira za ntchito yothandizira Mayi ndizolimba, zimaletsa kusintha kwina ngati kuli kofunikira. Ngati mutayesa kusintha chiwerengero cha zotsatira zake zomaliza, wogwiritsa ntchito akuyembekezera uthenga womwe umakuuzani kuti simungasinthe mbali zina. Pofuna kuthetsa vutoli ndikusintha zinthu zosayerekezereka zomwe mungagwiritse ntchito, chitani zotsatirazi.
Sankhani zamtundu uwu komanso, pokhala pa tabu "Kunyumba", dinani pazithunzi "Kopani"yomwe ili mu chida chogwiritsa ntchito "Zokongoletsera". Ndiponso, mmalo mwa opaleshoni iyi, mungagwiritse ntchito njira yadule Ctrl + C.
- Pambuyo pake, popanda kuchotsa zosankhidwazo kuchokera pamtunduwu, dinani ndibokosi lakumanja la mouse. Muzitsegulidwe zotseguka m'mabwalo "Njira Zowonjezera" sankhani chinthu "Makhalidwe".
- Pambuyo pochita izi, matrix omaliza sichidzawonetsedweratu ngati njira imodzi yosasunthika ndipo njira zosiyanasiyana zingagwiritsidwe ntchito.
Phunziro: Gwiritsani ntchito zojambula mu Excel
Monga mukuonera, woyendetsa Mayi zimakupatsani inu mwamsanga ndi mosavuta kuchulukitsa matrices awiri mwa wina ndi mnzake mu Excel. Chidule cha ntchitoyi ndi chophweka ndipo ogwiritsa ntchito sayenera kukhala ndi vuto lolowera deta muwindo lamatsutso. Vuto lokhalo limene lingakhalepo pamene tigwira ntchito ndi woyendetsa ntchitoyi ndilo ntchito yowonjezera, zomwe zikutanthauza kuti zili ndi mbali zina. Kuti mutulutse zotsatirazo, choyamba muyenera kusankha zofunikira pa pepala, ndiyeno mutatha kukambirana zogwiritsa ntchito makiyi apadera omwe agwiritsidwa ntchito kugwira ntchito ndi deta iyi - Ctrl + Shift + Lowani.
