Buyisela matrix e-Excel. Ungasithola kanjani i-matrix eguqukayo ukuze udlule ezigabeni ezi-2

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:

1. Sibhala i-matrix yesikwele kunoma iyiphi indawo yamahhala.
2. Khetha iseli yamahhala, ngemuva kwalokho esithola inkinobho ethi "FX" phambi kwenkinobho ("Namathisela umsebenzi") bese uqhafaza kwi-LKM.

okukodwa

1. Iwindi kufanele livule, lapho ku-Line "Isigaba:" Yima ku- "Mathematical", futhi ngezansi sikhetha umsebenzi we-mopred. Sivumelana nezenzo ezenziwa ngokuchofoza inkinobho ethi "KULUNGILE".
2. Okulandelayo, ewindini elivula, gcwalisa izixhumanisi ze-array.

1. Ngemuva kokubheka imininingwane efakwe yi-Manual noma ezenzakalelayo, cindezela u- "OK".

2.

1. 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.

3.

Nquma inani le-matrix yokubuya

Lapho nje ukubalwa kwesichasiso sekuqediwe, umuntu angahambisa ekuzimiseleni kwe-matrix yokubuya:

1. Khetha indawo yento ephezulu ye-matrix yokubuyela emuva, vula iwindi le- "Insert Rections".
2. Sikhetha isigaba esithi "Mathematics".
3. Emisebenzini engezansi phezulu, bapheqa ngohlu futhi bayeke ukukhetha kuthusi. Chofoza inkinobho ethi "KULUNGILE".

okune

1. Izenzo ezifanayo ezenziwa ngaphambili lapho amanani ahlukile alungele izixhumanisi ze-array nge-matrix yesikwele.
2. Siyaqiniseka ngokunemba kwezenzo ezenziwa futhi chofoza u- "OK".
3. Esitokisini esikhethiwe esikhethiwe se-matrix yesikhathi esizayo, umphumela uzovela.
4. Ukukopisha ifomula ukuthola amanani kwamanye amaseli, sebenzisa ukukhethwa kwamahhala. Ukuze senze lokhu, ukuvala i-LKM, selula kuyo yonke indawo ye-matrix yangesikhathi esizayo.

isihlanu

1. Chofoza kukhibhodi inkinobho ye-F2 bese uya ku- "Ctrl + Shift + Enter" inhlanganisela yokuhlanganiswa. Silungele!

6.

7.

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.