I-matrix eguquguqukayo ngumqondo oyinkimbinkimbi wezibalo, ukuthola ukuthi yini okudingekayo ukwenza izenzo eziningi ezinzima ephepheni. Kodwa-ke, uhlelo lwe-Excel luxazulula lo msebenzi ngesikhathi esifushane futhi ngaphandle kwemizamo eminingi. Ake sibheke ukuthi singayithola kanjani i-matrix eguqukayo ezigabeni eziningana kusibonelo esisodwa.
Sithola inani lesichasiso
Ukwenza lesi senzo, kufanele usebenzise umsebenzi we-mopred. Kwenziwa kanjani ngempela, cabanga ngesibonelo:
- Sibhala i-matrix yesikwele kunoma iyiphi indawo yamahhala.
- Khetha iseli yamahhala, ngemuva kwalokho esithola inkinobho ethi "FX" phambi kwenkinobho ("Namathisela umsebenzi") bese uqhafaza kwi-LKM.
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_1](/userfiles/22/12045_1.webp)
- Iwindi kufanele livule, lapho ku-Line "Isigaba:" Yima ku- "Mathematical", futhi ngezansi sikhetha umsebenzi we-mopred. Sivumelana nezenzo ezenziwa ngokuchofoza inkinobho ethi "KULUNGILE".
- Okulandelayo, ewindini elivula, gcwalisa izixhumanisi ze-array.
- Ngemuva kokubheka imininingwane efakwe yi-Manual noma ezenzakalelayo, cindezela u- "OK".
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_2](/userfiles/22/12045_2.webp)
- Ngemuva kwakho konke okukhohlisayo kwenziwe, iseli lamahhala kufanele liboniswe ngesinqumo se-matrix, inani lazo elizodingeka ukuthola i-matrix ebuyayo. Njengoba kungabonakala esikrinini, ngemuva kokubala kwavela inombolo 338, futhi-ke, ngoba okusobala akukulingane no-0, khona-ke i-matrix yokubuyela emuva ikhona.
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_3](/userfiles/22/12045_3.webp)
Nquma inani le-matrix yokubuya
Lapho nje ukubalwa kwesichasiso sekuqediwe, umuntu angahambisa ekuzimiseleni kwe-matrix yokubuya:
- Khetha indawo yento ephezulu ye-matrix yokubuyela emuva, vula iwindi le- "Insert Rections".
- Sikhetha isigaba esithi "Mathematics".
- Emisebenzini engezansi phezulu, bapheqa ngohlu futhi bayeke ukukhetha kuthusi. Chofoza inkinobho ethi "KULUNGILE".
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_4](/userfiles/22/12045_4.webp)
- Izenzo ezifanayo ezenziwa ngaphambili lapho amanani ahlukile alungele izixhumanisi ze-array nge-matrix yesikwele.
- Siyaqiniseka ngokunemba kwezenzo ezenziwa futhi chofoza u- "OK".
- Esitokisini esikhethiwe esikhethiwe se-matrix yesikhathi esizayo, umphumela uzovela.
- Ukukopisha ifomula ukuthola amanani kwamanye amaseli, sebenzisa ukukhethwa kwamahhala. Ukuze senze lokhu, ukuvala i-LKM, selula kuyo yonke indawo ye-matrix yangesikhathi esizayo.
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_5](/userfiles/22/12045_5.webp)
- Chofoza kukhibhodi inkinobho ye-F2 bese uya ku- "Ctrl + Shift + Enter" inhlanganisela yokuhlanganiswa. Silungele!
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_6](/userfiles/22/12045_6.webp)
![Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 12045_7](/userfiles/22/12045_7.webp)
Ukusetshenziswa kwezindawo zokuhlala nge-matrix ebuyayo
Umnotho yindawo edinga ukubalwa okuqhubekayo futhi okuyinkimbinkimbi kakhulu. Ukuze uthole impumuzo, kusetshenziswa uhlelo lokubala matrix. Ukuthola i-matrix eguquguqukayo kuyindlela esheshayo yokucubungula inani elikhulu lemininingwane yesikhathi esifushane kunazo zonke, umphumela wokuphela wokuthi uzokwethulwa ngendlela elula kakhulu yokubona.Enye indawo yohlelo lokusebenza i-3D isithombe modeling. Zonke izinhlobo zezinhlelo zinamathuluzi akhiwe ngaphakathi ngokwenza izibalo ezinjalo, ezisiza umsebenzi wabaqambi ekukhiqizweni kwezibalo. Uhlelo oludumile kakhulu phakathi kwamamodeli we-3D lubhekwa njengekhampasi-3D.
Kunezinye izindawo zomsebenzi lapho ungasebenzisa khona uhlelo lokubala matrix, kepha uhlelo oluphambili lokwenza izibalo ze-matrix kungabhekwa njengento excel.
Ukugcina
Ukuthola i-matrix eguquguqukayo ngeke ibizwe ngokuthi yimisebenzi efanayo yezibalo njengokukhipha, ukwengeza, noma ukwahlukanisa, kepha uma kunesidingo sokuyixazulula, khona-ke zonke izenzo zingakhiwa kwiprosesa lethebula le-Excel. Uma isici somuntu sithambekele ekwenzeni amaphutha, uhlelo lwekhompyutha luzonikeza umphumela onembile ayi-100%.
Umlayezo ubuyisela emuva matrix ku-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2 kwavela kuqala ubuchwepheshe bolwazi.