Chimodzi mwa ntchito zomwe zimagwiritsidwa ntchito nthawi zambiri pamene mukugwira ntchito ndi matrices ndi kuchulukitsa kwa wina ndi mnzake. Pulogalamu ya Excel ndi pulosesa yamphamvu, yomwe yapangidwa, kuphatikizapo kugwira ntchito pa matrices. Choncho, ali ndi zipangizo zomwe zimakulolani kuti muzipitile pamodzi. Tiyeni tione momwe izi zingachitire m'njira zosiyanasiyana.
Njira Yowonjezera Matrix
Nthawi yomweyo ndikuyenera kunena kuti si matrices onse omwe angathe kuchulukitsana wina ndi mzake, koma okhawo omwe ali ndi vuto linalake: chiwerengero cha zipilala za matrix imodzi chiyenera kukhala chofanana ndi nambala ya mzere wina ndi mosiyana. Kuonjezerapo, kukhalapo kwa zinthu zopanda kanthu m'matrices sikunatchulidwe. Pankhaniyi, inunso, chitani ntchito yofunikira sikugwira ntchito.
Palibe njira zambiri zowonjezera matrices ku Excel - awiri okha. Ndipo zonsezi zikugwirizana ndi ntchito ya Excel yomwe inamangidwa. Tiyeni tione mwatsatanetsatane njira iliyonseyi.
Njira 1: ntchito MUMMY
Chosavuta komanso chotchuka kwambiri pakati pa ogwiritsa ntchito ndi kugwiritsa ntchito ntchito. Mayi. Woyendetsa Mayi amatanthauza gulu la masamu la ntchito. Ntchito yake yomweyo ndi kupeza zomwe zimagwiritsidwa ntchito pazigawo ziwiri. Syntax Mayi ali ndi mawonekedwe otsatirawa:
= MUMNAGE (array1; array2)
Choncho, ochita izi ali ndi zifukwa ziwiri, zomwe zikutchulidwa pa mzere wa matrices awiri kuti azichulukitsidwa.
Tsopano tiyeni tiwone momwe ntchitoyo imagwiritsidwira ntchito. Mayi pachitsanzo chapadera. Pali ma matrices awiri, chiwerengero cha mizera ya chimodzi chimene chikufanana ndi chiwerengero cha zipilala mumzake ndi mosiyana. Tiyenera kuchulukitsa zinthu ziwiri izi.
- Sankhani mtundu umene zotsatira za kuchulukitsa ziwonetsedwe, kuyambira pa selo lakumanzere lakumanzere. Kukula kwa mtunduwu kumayenera kulumikizana ndi nambala ya mizera yoyamba mzere ndi chiwerengero cha zikhomo chachiwiri. Timakani pa chithunzi "Ikani ntchito".
- Yathandiza Mlaliki Wachipangizo. Sungani kuti musiye "Masamu", dinani pa dzina "MUMNOZH" ndipo dinani pa batani "Chabwino" pansi pazenera.
- Fenera lamatsutso la ntchito yofunikira lidzayambitsidwa. Pawindo ili pali madera awiri olowera ma adiresi omwe ali ndi matrix. Ikani cholozera mmunda "Array1"Ndipo, mutagwiritsa ntchito batani lamanzere, sankhani malo onse oyamba pamasamba. Pambuyo pake, makonzedwe ake adzawonetsedwa mmunda. "Massiv2" ndipo mofananamo sankhani zamtundu wachiwiri.
Pambuyo pazitsutso zonsezi, musafulumize kukanikiza batani "Chabwino"popeza tikulimbana ndi ntchito, zomwe zikutanthauza kuti kuti tipeze zotsatira zoyenera, njira yodalirika yomaliza ntchito ndi wogwira ntchito sizingagwire ntchito. Wogwiritsira ntchitoyi sali cholinga chowonetsera zotsatira mu selo limodzi, popeza ilo likuwonetsera lonse pa pepala. Choncho m'malo mokanikiza batani "Chabwino" Sakanizani kuphatikiza kwa batani Ctrl + Shift + Lowani.
- Monga mukuonera, patatha chisankho ichi chisanadze chidadzazidwa ndi deta. Izi ndi zotsatira za kuchulukitsa zida za matrix. Ngati muyang'ana pazenera zamatabwa, mutasankha mbali iliyonse yazomwezi, tidzatha kuona kuti mawonekedwe omwewo aphimbidwa m'makono ozungulira. Ichi ndi mbali ya ntchito yowonjezera, yomwe imaphatikizidwa pambuyo polimbikitsana Ctrl + Shift + Lowani asanatulutse zotsatira zake ku pepala.
PHUNZIRO: Ntchito ya MUMNAGE ku Excel
Njira 2: Kugwiritsira ntchito Pulogalamu ya Pakompyuta
Komanso, pali njira ina yowonjezera matrices awiri. Zili zovuta kwambiri kuposa kale, koma zimayenera kutchulidwa ngati njira ina. Njira imeneyi ikuphatikizapo kugwiritsa ntchito njira yowonjezera, yomwe idzakhala ndi ntchito SUMPRODUCT ndipo atsekedwa mmenemo ngati mtsutso wa woyendetsa TRANSPORT.
- Panthawi ino, timasankha kokha pamwamba pa maselo opanda kanthu pa pepala, zomwe tikuyembekeza kuzigwiritsa ntchito kusonyeza zotsatira. Dinani pazithunzi "Ikani ntchito".
- Mlaliki Wachipangizo ayamba Kusamukira ku malo osungirako ntchito "Masamu"koma nthawi ino timasankha dzina SUMPRODUCT. Timasankha pa batani "Chabwino".
- Kutsegula kwawindo lazitsulo la ntchitoyi ilipo. Wogwiritsira ntchitoyi akukonzekera kuti azichulukitsa zigawo zosiyana wina ndi mzake. Mawu ake omasulira ndi awa:
= SUMPRODUCT (array1; array2; ...)Monga zifukwa za gulu "Mzere" Kuwongolera kuyeso yowonjezera ikugwiritsidwa ntchito. Zonse ziwiri mpaka 255 zoterezi zingagwiritsidwe ntchito. Koma kwa ife, popeza tikulimbana ndi matrices awiri, tidzakhala ndi zifukwa ziwiri zokha.
Ikani cholozera mmunda "Massive1". Pano ife tifunika kulowa ku adiresi ya mzere woyamba wa masewera oyambirira. Kuti muchite izi, mutagwira batani lamanzere, muyenera kungoisankha pa pepala ndi ndemanga. Pano mipikisano ya mndandanda umenewu idzawonetsedwa pamtunda woyenera pazenera. Pambuyo pake, muyenera kukonza mgwirizano wa zotsatirazi pazitsulo, ndiko kuti, makonzedwe awa ayenera kukhala omveka. Kuti muchite izi, musanakhale makalata omwe ali m'mawu omwe alowa m'munda, ikani chizindikiro cha dola ($). Pamaso a makonzedwe omwe asonyezedwa mu ziwerengero (mizere), izi siziyenera kuchitika. Mwinanso, mungasankhe mawu onse mmunda mmalo mwake ndi kukanikiza fungulo la ntchito katatu F4. Pachifukwa ichi, makonzedwe okha a zigawo adzakhala otheradi.
- Pambuyo pake ikani cholozera kumunda "Massiv2". Pogwirizana ndi nkhaniyi zidzakhala zovuta kwambiri, chifukwa malinga ndi malamulo a kuchuluka kwa matrix, chiwerengero chachiwiri chiyenera kukhala "chowombedwa". Kuti muchite izi, gwiritsani ntchito chisa chake TRANSPORT.
Kuti mupite kwa iyo, dinani pachithunzicho mwa mawonekedwe a katatu, motsogoleredwa ndi mpweya wotsika, umene uli kumanzere kwa bar. Mndandanda wa mafomu atsopano omwe amagwiritsidwa ntchito. Ngati mutapeza dzinali "TRANSPORT"ndiye dinani pa izo. Ngati mwagwiritsa ntchito wotereyi kwa nthawi yayitali kapena simunagwiritse ntchitopo konse, ndiye kuti simudzapeza dzina lolembedwa pamndandandawu. Pankhaniyi, dinani pa chinthu. "Zina ...".
- Fenera yodziwika kale imatsegulidwa. Oyang'anira ntchito. Nthawi ino timasunthira ku gululo "Zolumikizana ndi zolemba" ndi kusankha dzina "TRANSPORT". Dinani pa batani "Chabwino".
- Ntchito yotsutsana zenera ikuyambitsidwa. TRANSPORT. Wogwiritsira ntchitoyi akukonzekera kumasulira matebulo. Ndikutanthauza kuti, kuzinena mwachidule, zimasintha nsonga ndi mizere. Izi ndi zomwe tifunika kuchita pazokambirana kachiwiri kwa woyendetsa. SUMPRODUCT. Ntchito yomasulira TRANSPORT zosavuta kwambiri:
= TRANSPORT (gulu)Ndicho, kukangana kokha kwa ochita izi ndikutanthauzira ku mzere umene uyenera "kuwombedwa". M'malo mwake, ifeyo, ngakhale mndandanda wonse, koma pa chigawo chake choyamba.
Choncho, ikani chotsekeramo kumunda "Mzere" ndipo sankhani ndime yoyamba ya chigawo chachiwiri pa pepala ndi batani lamanzere lomwe liri pansi. Adilesi idzawonekera m'munda. Monga momwe zinalili kale, apa, inunso muyenera kupanga mgwirizano wodalirika, koma nthawi ino sizowunikira mazenera, koma maadiresi a mizere. Choncho, timayika chizindikiro cha dola kutsogolo kwa chiwerengero chomwe chikugwiritsidwa ntchito kumunda. Mukhozanso kusankha mawu onse ndi dinani kawiri F4. Pambuyo pazinthu zofunika zidayamba kukhala ndi katundu weniweni, musati mukanikize batani "Chabwino", komanso mu njira yapitayi, gwiritsani ntchito mgwirizano Ctrl + Shift + Lowani.
- Koma nthawi ino, sitinadzazapo ndondomeko, koma selo limodzi lokha, limene tinapatsidwa kale pamene titaitana Oyang'anira ntchito.
- Tifunika kudzaza detayi ndi kukula kofanana ndi njira yoyamba. Kuti muchite izi, lembani fomu yomwe imapezeka mu selo kuti ikhale yofanana, yomwe idzakhala yofanana ndi mizere ya mizere yoyamba ndi chiwerengero cha mizere yachiwiri. Mulimonsemo, timapeza mizere itatu ndi zigawo zitatu.
Polemba, tiyeni tigwiritse ntchito chikhomo chodzaza. Sungani chithunzithunzi kupita ku ngodya ya kumanja ya selo kumene mpangidwe ulipo. Mtolowo umasandulika ku mtanda wakuda. Ichi ndi chilemba chodzaza. Gwiritsani batani lamanzere la mchenga ndi kukokera chithunzithunzi pazomwe zili pamwambazi. Selo yoyamba ndi ndondomekoyi iyenera kukhala mbali yakum'mwamba yowonjezera.
- Monga mukuonera, mtundu wosankhidwa uli ndi deta. Ngati tiwayerekeza ndi zotsatira zomwe tinapeza pogwiritsira ntchito wogwiritsira ntchito Mayi, ndiye tidzawona kuti zikhalidwezo ndizofanana. Izi zikutanthauza kuti kuchulukitsa kwa matrices awiri ndi kolondola.
PHUNZIRO: Kugwira ntchito ndi zojambula mu Excel
Monga mukuonera, ngakhale kuti zotsatira zofanana zinapezedwa, gwiritsani ntchito ntchitoyi kuti muchulukitse matrices Mayi chophweka kwambiri kusiyana ndi kugwiritsa ntchito njira yogwiritsira ntchito yogwiritsira ntchito cholinga chomwecho SUMPRODUCT ndi TRANSPORT. Komabe, njirayi imakhalanso yosayang'anitsitsa pofufuza zonse zomwe zingatheke pochulukitsa matrices ku Microsoft Excel.
