Excel imachita mawerengedwe osiyanasiyana okhudzana ndi deta yamatauni. Pulogalamuyo imawapanga iwo ngati maselo osiyanasiyana, kugwiritsa ntchito mafomu osiyanasiyana kwa iwo. Chimodzi mwa zochitikazi ndikupeza matrix. Tiyeni tiwone kuti ndi njira yanji yotsatilayi.
Kuchita mawerengedwe
Kuwerengedwa kwa chiwerengero choyendera mu Excel n'kotheka kokha ngati chiwerengero choyambirira chikhale chokwanira, ndiko kuti, nambala ya mizere ndi mizere mkati mwake ndi yofanana. Kuonjezera apo, zizindikiro zake siziyenera kukhala zero. Ntchito yambiri imagwiritsidwa ntchito powerengera. MOBR. Tiyeni tione kuwerengera komweko pogwiritsa ntchito chitsanzo chosavuta.
Kuwerengera kwa determinant
Choyamba, tiyeni tiwerenge chodziwika kuti tidziwe ngati mtundu woyamba uli ndi matrix kapena ayi. Mtengo umenewu ukuwerengedwa pogwiritsa ntchito ntchitoyi MEPRED.
- Sankhani selo iliyonse yopanda kanthu pa pepala, komwe zotsatira za mawerengedwe zidzawonetsedwa. Timakanikiza batani "Ikani ntchito"adayikidwa pafupi ndi bar.
- Iyamba Mlaliki Wachipangizo. Mndandanda wa zolemba zomwe akuyimira, tikuzifuna YAM'MBUYOsankhani chinthu ichi ndipo dinani pa batani "Chabwino".
- Fesholo yotsutsana ikutsegula. Ikani cholozera mmunda "Mzere". Sankhani maselo osiyanasiyana omwe mliriwu ulipo. Pambuyo pa adiresi yake ataonekera kumunda, dinani pa batani "Chabwino".
- Pulogalamuyi ikulingalira chokhazikitsidwa. Monga momwe tikuonera, chifukwa chake ndi zofanana ndi - 59, ndiko kuti, sizili zofanana ndi zero. Izi zimakulolani kuti muzinene kuti matrix awa ali ndi zotsutsana.
Kuwerengera koyambirira kwa masamu
Tsopano ife tikhoza kupita ku chiwerengero chachindunji cha matrix oyendayenda.
- Sankhani selo, yomwe iyenera kukhala pamwamba pa selo selo la masanjidwe amkati. Pitani ku Mlaliki Wachipangizopotsegula chithunzi kumanzere kwa bar.
- M'ndandanda yomwe imatsegulira, sankhani ntchitoyo MOBR. Timakanikiza batani "Chabwino".
- Kumunda "Mzere", ndondomeko yotsutsana ndiwindo yomwe imatsegula, ikani ndondomeko. Sankhani zonse zoyambira. Pambuyo pokhala adiresi yake kumunda, dinani pa batani "Chabwino".
- Monga mukuonera, mtengowo unkaonekera kokha mu selo imodzi momwe munali njira. Koma tikufunikira ntchito yotsitsimutsa, choncho tiyenera kufotokozera fomuyi kwa maselo ena. Sankhani mtundu umene uli wofanana mozungulira ndikuwonekera kumalo oyamba a deta. Ife tikulimbikira pa fungulo la ntchito F2kenaka tekanitsani kuphatikiza Ctrl + Shift + Lowani. Ndikumagwirizanitsa kwachiwiri komwe kumagwiritsidwa ntchito pokonza zinthu.
- Monga momwe mukuonera, pambuyo pa zochitikazi, chiwerengero choyendetsera chiwerengero chimawerengedwa m'maselo osankhidwa.
Izi zikhoza kuonedwa kuti zangwiro.
Ngati muwerengera chilembo chokhazikika komanso chotsutsana ndi pepala ndi pepala, ndiye mutha kulingalira za chiwerengero ichi, ngati mumagwiritsa ntchito chitsanzo chovuta, kwa nthawi yaitali kwambiri. Koma, monga momwe tikuonera, mu pulogalamu ya Excel, mawerengero awa akuchitidwa mofulumira, mosasamala kanthu kovuta kwa ntchitoyi. Kwa munthu yemwe amadziŵa bwino kuwerengera kwa mawerengero oterewa m'kugwiritsira ntchito, kuwerengera konse kwafupika kukhala zochita zokha.
