Kusintha matrix ku Excel. Momwe mungapezere matrix osinthika kuti muwonjezere magawo awiri

Zosintha matrix ndi lingaliro la masamu, kuti lipeze chomwe chingafunikire kuchita zinthu zambiri zovuta papepala. Komabe, pulogalamu ya Excel imathetsa ntchitoyi nthawi yochepa komanso osayesayesa. Tiyeni tiwone momwe mungapezere kusinthasintha kwa matrix m'mbali zingapo.

Timapeza phindu la otsimikiza

Kuti muchite izi, muyenera kugwiritsa ntchito ntchitoyo. Zikuchitika bwanji ndendende, lingalirani za:

1. Timalemba matrix pamtunda uliwonse.
2. Sankhani foni yaulere, yomwe timapeza batani la "FX" kutsogolo kwa mzere ("Ikani batani") ndikudina LKM.

chimodzi

1. Windo la pawindo liyenera kutseguka, komwe muli mu gawo "gulu:" Imani pa "masamu", ndipo pansipa timasankha ntchito yopukutira. Tikugwirizana ndi zomwe zachitika podina batani la "OK".
2. Kenako, pawindo lomwe limatsegula, dzazani mgwirizano wa mndandanda.

1. Pambuyo poyang'ana data yomwe idalowetsedwa ndi buku kapena zotokha, dinani "Chabwino".

2.

1. Pambuyo pamavuto onse omwe adachitidwa, khungu laulere liyenera kuwonetsedwa ndi matrix otsimikiza, mtengo womwe ungafunike kuti apeze matrix obwerera. Monga tikuwonera pachithunzi, mutatha kuwerengetsa zindikirani nambala ya 338, ndipo motero, chifukwa chotsimikizika sichikhala ndi 0, ndiye kuti matrix amakhalapo.

3.

Dziwani mtengo wobwereketsa

Mukangowerengera zomwe zimakwaniritsidwa, munthu amatha kusamukira ku matrix obwerera:

1. Sankhani malo omwe ali pamwamba pa matrix yosinthira, tsegulani "Ikani Ntchito" Zenera.
2. Timasankha "masamu".
3. Mu ntchito pansi, amasuntha pamndandanda ndikuyimitsa kusankha pa mkuwa. Dinani pa batani la "OK".

zinai

1. Zofananazo ndi zomwe zidachitidwa kale zomwe zimachitika kale zikakhala zogwirizana zimagwirizana ndi mgwirizano wa mndandanda wa matrix.
2. Tikukhulupirira kuti kulondola kwa zomwe adachitazi ndikudina "Chabwino".
3. M'maselo osankhidwa apamwamba a matrix amtsogolo, zotsatira zake zidzawonekera.
4. Kutengera mawonekedwe a kupeza miyambo m'maselo ena, gwiritsani ntchito kusankha kwaulere. Kuti tichite izi, kutseka Lkm, timatambasula kudera lonse la matrix amtsogolo.

zisanu

1. Dinani pa kiyibodi ya F2 ndikupita ku "Ctrl + Shift + Swit" Takonzeka!

6.

7.

Kugwiritsa ntchito malo okhala ndi matrix obwerera

Chuma ndi dera lomwe limafunikira kuwerengera kosalekeza komanso kovuta kwambiri. Kuti mupeze mpumulo, makina owerengera matrix amagwiritsidwa ntchito. Kupeza matrix yosinthira ndi njira yothamangitsira zambiri za chidziwitso cha nthawi yayitali, zotsatira zake zidzaperekedwa m'njira yosavuta kwambiri kuti muzindikire.

Gawo lina la ntchito ndi chithunzi cha 3d. Mapulogalamu onse omwe amapanga zida zomangira zomwe zimapangitsa kuwerengetsa, zomwe zimathandizira ntchito ya opanga kupanga. Pulogalamu yotchuka kwambiri pakati pa mitundu ya 3d imawerengedwa ngati kampasi-3d.

Pali mbali zina za ntchito komwe mungagwiritse ntchito dongosolo la kuwerengetsa matrix, koma pulogalamu yayikulu yogwiritsira ntchito matrix itha kuganiziridwa bwino.

Mapeto

Kupeza matrix yosinthira sikungatchedwa pa ntchito imodzimodzi ya masamu monga kuchotsa, koma ngati kuli kofunikira kuti mupange purosesa ya tebulo labwino. Ngati munthu wamunthu amakonda kulakwitsa, pulogalamu ya kompyuta ipereka zotsatira zolondola 100%.

Mauthenga osinthika matrix pa Excel. Momwe Mungapezere Zosinthasintha matrix kuti muwonjezere m'magawo awiri omwe adayambitsidwa koyamba ku ukadaulo.