Hindura matrix muri excel. Nigute Wabona Matrix ya Revever kuri Excel mubyiciro 2

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:

1. Twanditse matrix kare ahantu hose kubuntu.
2. Hitamo selile yubusa, nyuma yo kubona buto ya "FX" imbere yumurongo ("andika imikorere" hanyuma ukande kuri LKM.

imwe

1. Idirishya rigomba gufungura, aho mumurongo "icyiciro:" ihagarare "imibare", na hepfo duhitamo imikorere yambaye. Twumvikanye nibikorwa byakozwe ukanze kuri buto "OK".
2. Ibikurikira, mwidirishya rifungura, uzuza imirongo ya array.

1. Nyuma yo kugenzura amakuru yinjiye mubitabo cyangwa byikora, kanda "OK".

2.

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

3.

Menya AGACIRO AGACIRO PATRIX

Mugihe cyo kubara uwubahiriza irangiye, umuntu arashobora kwimukira mubyemezo byo kugaruka matrix:

1. Hitamo aho ibintu byo hejuru bya matrix, fungura "shyiramo imikorere" idirishya.
2. Duhitamo icyiciro "imibare".
3. Mubikorwa-hasi-hejuru, bazunguruka binyuze kurutonde hanyuma uhagarike amahitamo kumuringa. Kanda kuri buto ya "OK".

Bane

1. Bisa na mbere byakozwe mubikorwa iyo indangagaciro zabigenewe zihuye na coiornis ya array hamwe na matrix kare.
2. Twizeye neza ko ibikorwa byakozwe hanyuma ukande "OK".
3. Mu kagari katoranijwe hejuru yibumoso k'ejo hazaza hazagaragara matrix, ibisubizo bizagaragara.
4. 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.

bitanu

1. Kanda kuri clavier ya F2 hanyuma ujye kuri "Ctrl + shift + andika" guhuza. YITEGUYE!

6.

7.

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.