Excel amachita mawerengero osiyanasiyana okhudzana ndi deta ya matrix. Pulogalamuyi imawazungulira ngati maselo osiyanasiyana, kuwagwiritsa ntchito m'njira zosiyanasiyana. Chimodzi mwazochita izi ndikupeza matrix osinthika. Tiyeni tiwone chomwe ma algorithm a njirayi ndi.
Kukhazikika
Kuwerengera kwa matrix mu Excel ndikotheka pokhapokha ngati matrix oyambilira ndi apakati, ndiko kuti, mizere ndi mizati m'modzi momwemo ikugwirizana. Kuphatikiza apo, kudziwa kwake sikuyenera kukhala kofanana ndi zero. Ntchitozi zosanja zimagwiritsidwa ntchito kuwerengera MOBR. Tiyeni tionenso kuwerengera komweku pogwiritsa ntchito chitsanzo chosavuta.
Kuwerengetsa kwa wotsimikiza
Choyamba, timawerengera kuti tidziwe ngati mtundu woyambira uli ndi matrix osasintha kapena ayi. Mtengo uwu amawerengedwa pogwiritsa ntchito ntchitoyo MOPANDA.
- Sankhani khungu lililonse lopanda kanthu pa pepalalo pomwe zowerengera zikuwonetsedwa. Dinani batani "Ikani ntchito"itayikidwa pafupi ndi baramu yamu formula.
- Iyamba Fotokozerani Wizard. Pa mndandanda wa mayendedwe omwe iye akuimira, tikuyang'ana MOPANDA, sankhani chinthuchi ndikudina batani "Zabwino".
- Windo la mkangano likutseguka. Ikani wolemba m'munda Menya. Sankhani maselo onse omwe masanjidwewo amapezeka. Pambuyo pomwe adilesi yake yabwera m'mundayo, dinani batani "Zabwino".
- Pulogalamuyi imawerengetsa otsimikiza. Monga mukuwonera, pankhani yathuyi ndiofanana - 59, ndiye kuti, siyofanana ndi zero. Izi zikutifikitsa kuti tinene kuti matrix awa ali ndi zosiyana.
Maweresi osokoneza
Tsopano mutha kupitirira kuwerengera mwachindunji kwa matrix osinthika.
- Sankhani khungu lomwe liyenera kukhala selo lakumanzere kwa matrix osinthika. Pitani ku Fotokozerani Wizardpodina chizindikiro kumanzere kwa barula yodula.
- Pamndandanda womwe umatsegulira, sankhani ntchito MOBR. Dinani batani "Zabwino".
- M'munda Menya, ntchito yotsutsana ndi zenera imatseguka, ikani cholozera. Gawani magulu onse oyambira. Pambuyo pakuwonekera kwa adilesi yake m'munda, dinani batani "Zabwino".
- Monga mukuwonera, mtengo wake udawoneka mu khungu limodzi lokhalo momwe zidakhalira kale. Koma tikufuna kugwiranso ntchito kwathunthu, choncho tiyenera kutengera fomuloli m'maselo ena. Sankhani malo omwe ali ofanana molunjika komanso molunjika ku makonzedwe achidziwitso choyambirira. Dinani pa batani la ntchito F2, kenako kuyimba kuphatikiza Ctrl + Shift + Lowani. Ndiye kuphatikiza komwe kumapangidwa kuti kuthana ndi arrays.
- Monga mukuwonera, zitatha izi, matrix osinthika amawerengedwa m'maselo osankhidwa.
Pa kuwerengera izi zitha kuganiziridwa kuti zatha.
Ngati mungawerenge chosankha komanso chosakanikirana chokhacho pokhapokha ndi cholembera ndi pepala, ndiye pamawerengera awa, momwe mungagwiritsire ntchito chitsanzo chovuta, mutha kulumpha kwa nthawi yayitali. Koma, monga mukuwonera, mu pulogalamu ya Excel, kuwerengera uku kumachitika mwachangu, mosasamala kanthu za zovuta za ntchitoyi. Kwa munthu amene amadziwa bwino momwe zinthu zimapangidwira pa ntchito yake, kuwerengera komwe kumachitika pongotsatira zochita.
