Matrix revers ni igitekerezo kitoroshye cyimibare, kugirango ubone ari ngombwa gukora ibikorwa byinshi bigoye kurupapuro. Ariko, gahunda ya Excel ikemura iki gikorwa mugihe gito kandi nta mbaraga nyinshi. Reka tumenye uburyo bwo kubona matrix itandukanye mubyiciro byinshi kurugero rumwe.
Turabona agaciro k'ubigena
Gukora iki gikorwa, ugomba gukoresha imikorere yambaye. UKO BIKORWA, tekereza kurugero:
- Twanditse matrix kare ahantu hose kubuntu.
- Hitamo selile yubusa, nyuma yo kubona buto ya "FX" imbere yumurongo ("andika imikorere" hanyuma ukande kuri LKM.
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_1](/userfiles/22/12045_1.webp)
- Idirishya rigomba gufungura, aho mumurongo "icyiciro:" ihagarare "imibare", na hepfo duhitamo imikorere yambaye. Twumvikanye nibikorwa byakozwe ukanze kuri buto "OK".
- Ibikurikira, mwidirishya rifungura, uzuza imirongo ya array.
- Nyuma yo kugenzura amakuru yinjiye mubitabo cyangwa byikora, kanda "OK".
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_2](/userfiles/22/12045_2.webp)
- Nyuma ya Manipulations zose zakozwe, selile yubusa igomba kwerekanwa na matrix ugena, agaciro kazakenerwa kugirango tubone tatrix. Nkuko bigaragara muri ecran, nyuma yo kubara byagaragaye nimero 338, hanyuma rero, kubera ko ugena kuri 0, noneho matrix itandukanye irahari.
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_3](/userfiles/22/12045_3.webp)
Menya AGACIRO AGACIRO PATRIX
Mugihe cyo kubara uwubahiriza irangiye, umuntu arashobora kwimukira mubyemezo byo kugaruka matrix:
- Hitamo aho ibintu byo hejuru bya matrix, fungura "shyiramo imikorere" idirishya.
- Duhitamo icyiciro "imibare".
- Mubikorwa-hasi-hejuru, bazunguruka binyuze kurutonde hanyuma uhagarike amahitamo kumuringa. Kanda kuri buto ya "OK".
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_4](/userfiles/22/12045_4.webp)
- Bisa na mbere byakozwe mubikorwa iyo indangagaciro zabigenewe zihuye na coiornis ya array hamwe na matrix kare.
- Twizeye neza ko ibikorwa byakozwe hanyuma ukande "OK".
- Mu kagari katoranijwe hejuru yibumoso k'ejo hazaza hazagaragara matrix, ibisubizo bizagaragara.
- Gukoporora formula yo gushakisha indangagaciro mu zindi selile, koresha guhitamo kubuntu. Kugira ngo ukore ibi, usoze LKM, turambuye ahantu hose h'ejo hazaza hinsse matrix.
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_5](/userfiles/22/12045_5.webp)
- Kanda kuri clavier ya F2 hanyuma ujye kuri "Ctrl + shift + andika" guhuza. YITEGUYE!
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_6](/userfiles/22/12045_6.webp)
![Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2 12045_7](/userfiles/22/12045_7.webp)
Ikoreshwa ryimidugudu hamwe na matrix
Ubukungu ni agace gasaba guhoraho kandi bigoye kubara. Kubutabazi, sisitemu yo kubara matrix ikoreshwa. Kubona matrix revers nuburyo bwihuse bwo gutunganya amakuru menshi mugihe gito gishoboka, ibisubizo byanyuma bizatangwa muburyo bworoshye bwo kwiyumvisha.Ikindi gice cyo gusaba ni 3D ishusho yerekana. Gahunda zose za porogaramu zubatswe-ibikoresho byo gukora nkibyo kubara, ahanini byorohereza umurimo wabashushanya mumusaruro. Gahunda ikunzwe cyane mumideli ya 3d ifatwa na compas-3d.
Hariho ibindi bikoresho byibikorwa ushobora gukoresha sisitemu yo kubara matrix, ariko gahunda nyamukuru yo gukora imibare ya Matrix irashobora gufatwa nkicyiciro.
Umwanzuro
Kubona Matrix revers ntishobora kwitwa imibare imwe isanzwe nko gukumira, kongerwaho, cyangwa kugabana, ariko niba ari ngombwa kubikemura, noneho ibikorwa byose birashobora gukorwa mubyo ushinzwe imbonerahamwe ya Excel. Niba ibintu byabantu bifuza gukora amakosa, porogaramu ya mudasobwa izatanga ibisubizo 100%.
Ubutumwa bwahinduye matrix muri excel. Nigute ushobora kubona matrix ya revers kuri excel mumikino 2 yagaragaye mbere yikoranabuhanga.