Monga mukudziwa, Excel ali ndi zida zambiri zogwirira ntchito ndi matrices. Chimodzi mwa izo ndi ntchito ya MUMNOSE. Pogwiritsa ntchito opaleshoni iyi, ogwiritsa ntchito ali ndi mwayi ochulukitsa matric osiyanasiyana. Tiyeni tiwone momwe mungagwiritsire ntchito ntchitoyi, ndipo ndimagulu ati omwe amagwira nawo ntchito.
Pogwiritsa ntchito opanga MUMNOZH
Cholinga chachikulu cha ntchitoyo MLUNGUmonga tafotokozera pamwambapa, ndikuchulukitsa kwa matric awiri. Ili m'gulu la ochita masamu.
Syntax yantchitoyi ndi motere:
= MABWINO (mndandanda1; mndandanda2)
Monga mukuwonera, wogulitsayo ali ndi mfundo ziwiri zokha - "Pantan1" ndi Array2. Iliyonse mwamaganizidwewo amatanthauza imodzi ya matrices, omwe ayenera kuchulukitsidwa. Izi ndizomwe amachita opanga pamwambapa amachita.
Mkhalidwe wofunikira pakugwiritsira ntchito MLUNGU ndikuti kuchuluka kwa mizere mu matrix yoyamba kuyenera kufanana ndi kuchuluka kwa mizati yachiwiri. Kupanda kutero, cholakwika chidzapangitsidwa chifukwa chofufuzira. Komanso, kupewa zophophonya, palibe chilichonse mwazinthu zonse ziwiri zomwe ziyenera kukhala zopanda kanthu, ndipo ziyenera kukhala zochuluka.
Kuchulukitsa kwa Matrix
Tsopano tiyeni tiwone chitsanzo china cha momwe mungachulukitsire matric awiri pogwiritsa ntchito opereshoni MLUNGU.
- Tsegulani pepala la Excel, pomwe matriculo awiri apezeka kale. Timasankha masera opanda maselo, ophatikizira kuchuluka kwa mizere yoyambirira, ndipo mokhazikika chiwerengero cha mizati yachiwiri. Chotsatira, dinani pazizindikiro "Ikani ntchito"yomwe imayikidwa pafupi ndi mzere wa fomula.
- Kuyambira Ogwira Ntchito. Tiyenera kupita pagululi "Masamu" kapena "Mndandanda wathunthu wa zilembo". Pa mndandanda wa ogwiritsira ntchito muyenera kupeza dzinalo MUMNOZH, sankhani ndikudina batani "Zabwino", yomwe ili pansi pazenera ili.
- Woyendetsa Window Window Woyambitsa MLUNGU. Monga mukuwonera, ili ndi magawo awiri: "Pantan1" ndi Array2. Poyamba, muyenera kufotokoza maumbidwe oyang'anira matrix oyambira, ndipo chachiwiri, motsatana, chachiwiri. Kuti muchite izi, ikani cholozera m'munda woyamba. Kenako timapanga chidutswa ndi batani lakumanzere ndikusankha dera lomwe lili ndi matrix oyamba. Mukatha kuchita njirayi yosavuta, yolumikizira iwonetsedwa pamunda wosankhidwa. Timachita zofanana ndi gawo lachiwiri, pokhapokha, titanyamula batani lakumanzere, sankhani matrix yachiwiri.
Ma adilesi a matric onse atalembedwa, musathamangire kukanikiza batani "Zabwino"ili pansi pazenera. Chowonadi ndichakuti, tikuchita ndi gulu lambiri. Zimapereka kuti zotsatirazo sizikuwonetsedwa mu khungu limodzi, monga ntchito wamba, koma nthawi yomweyo mumulu wonse. Chifukwa chake, kuwonetsa zotsatira za kukonza kwa data pogwiritsa ntchito opaleshoni iyi, sikokwanira kukanikiza kiyi Lowanipoika chidziwitso mu barula yokhazikika, kapena podina batani "Zabwino", kukhala m'mazenera otsutsana a ntchito yomwe idatitsegulira pakadali pano. Muyenera kuyika pang'onopang'ono Ctrl + Shift + Lowani. Timachita njirayi, ndi batani "Zabwino" osakhudza.
- Monga mukuwonera, mutatha kukanikiza kuphatikiza kogwirizanitsa kiyi, wothandizira akutsutsana MLUNGU chatsekedwa, ndipo maselo osiyanasiyana omwe tidasankha mu gawo loyamba la malangizowa adadzaza ndi chidziwitso. Ndi mfundo izi zomwe zimachitika chifukwa chochulukitsa matrix amodzi ndi ena, omwe wothandizirawo adachita MLUNGU. Monga mukuwonera, pamzere wazinthu zimayendetsedwa m'malingaliro, zomwe zikutanthauza kuti ndi gawo la ochita kupanga.
- Koma ndizomwe zotsatira za kukonza ntchito MLUNGU Ndi gulu lofunikira, limalepheretsa kusintha kwake kopitilira ngati kuli kotheka. Mukamayesa kusintha nambala iliyonse yazotsatira zomaliza, wogwiritsa ntchito adikirira uthenga womwe umadziwitse kuti sizingatheke kusintha gawo lawolo. Kuti tichotse kusokonekera uku ndikusintha makina osasinthika kukhala amtundu wokhazikika omwe mungagwire nawo ntchito, timachita zotsatirazi.
Sankhani izi ndipo, kukhala "Pofikira"dinani pachizindikiro Copyyomwe ili mgululi Clipboard. M'malo mogwira ntchitoyi, mutha kuyika njira zazifupi Ctrl + C.
- Pambuyo pake, osachotsa masankhidwewo pamtunduwo, dinani ndi batani labwino la mbewa. Pazosankha zomwe zimatsegulira, mu block Ikani Zosankha sankhani "Makhalidwe".
- Pambuyo pochita izi, matrix omwe adayambikayo sangatchulidwenso ngati mtundu umodzi wosawerengeka ndipo mawonekedwe osiyanasiyana akhoza kuchitika nawo.
Phunziro: Kugwira ntchito ndi gulu la anthu ku Excel
Monga mukuwonera, wothandizira MLUNGU imakulolani kuti muwonjezere mwachangu komanso mosavuta mu Excel matrices awiri pamwamba pa wina ndi mnzake. Kuphatikizika kwa ntchitoyi ndikosavuta ndipo ogwiritsa ntchito sayenera kukhala ndi mavuto kulowa idatha muwindo la mkangano. Vuto lokhalo lomwe lingakhalepo mukamagwira ntchito ndi opangirawo ndi loti limagwira ntchito zosiyanasiyana, zomwe zikutanthauza kuti zimakhala ndi zina. Kuti muwonetse zotsatira, muyenera kusankha magawo oyenera pa pepalalo, kenako mutalowetsa zowerengera, gwiritsani ntchito kiyi yapadera yopangidwira ndi mtundu wamtunduwu - Ctrl + Shift + Lowani.
