Ama-matric aguqulayo e-Excel

Lapho usebenza ngo-matric, kwesinye isikhathi udinga ukuwathola, okungukuthi, ukukhuluma ngamagama alula, kuphenduka. Vele, ungaguqula idatha ngesandla, kepha i-Excel inikeza izindlela eziningana zokwenza lula futhi ngokushesha. Ake sibahlaziye ngokuningiliziwe.

Inqubo eguqukayo

Ukuguqula i-matrix inqubo yokushintsha amakholomu nemigqa ezindaweni. Uhlelo lwe-Excel lunezici ezimbili eziguqulwayo eziguqulwayo: Usebenzisa umsebenzi we-TRAC futhi usebenzisa ithuluzi elikhethekile lokufaka. Cabanga ngakunye kwalezi zinketho ngemininingwane eminingi.

Indlela 1: I-TRRPPERPORT

Umsebenzi we-TRAC ubhekisa esigabeni se- "Links kanye ne-Arrows" opharetha. Isici ukuthi unawo, njengakweminye imisebenzi esebenza ngezakhiwo, umphumela wokukhishwa akusikho okuqukethwe kuseli, kepha kuhlu lwedatha yonke. I-syntax yomsebenzi ilula kakhulu futhi ibukeka kanjena:

= Tracp (uhlu)

Okungukuthi, okuwukuphela kwengxabano yalolu hlelo lokusebenza kubhekiselwa ku-array array, esimweni sethu i-matrix okufanele iguqulwe.

Ake sibheke ukuthi lo msebenzi ungasetshenziswa kanjani ngesibonelo esine-matrix yangempela.

1. Sigqamisa iseli elingenalutho eshidini, kuhlelwe ukwenza iseli elingenhla eliphakeme kakhulu le-matrix eguquliwe. Okulandelayo, chofoza isithonjana esithi "Insert Funct", esiseduzane nomugqa wefomula.



2. Ukugijima iWizard yemisebenzi. Vula kuyo isixhumanisi "izixhumanisi kanye nama-arrays" noma "uhlu olugcwele lwezinhlamvu". Ngemuva kokuthi igama elithi "ipheshana" litholakele, likhiqize ukwabiwa kwalo bese licindezela inkinobho ethi "KULUNGILE".



3. Iwindi le-Trace Function Reging liqala. Ukuphikisana kuphela kwalolu hlelo ohambelana nenkambu ye- "ARRAY". Kuyadingeka ukwenza izixhumanisi ze-matrix, okufanele zivulwe. Ukuze wenze lokhu, setha isikhombisi emkhakheni futhi, ngokubamba inkinobho yegundane kwesobunxele, sigqamisa lonke uhla lwe-matrix eshidini. Ngemuva kokuthi ikheli lendawo liboniswe ewindini lokuxabana, chofoza inkinobho ethi "Kulungile".



4. Kepha, njengoba sibona, esitokisini, okuhloselwe ukubonisa umphumela, inani elingalungile liboniswa njengephutha "# lisho!". Lokhu kungenxa yezici zomsebenzi we-array. Ukulungisa leli phutha, khetha uhla lwamaseli lapho inani lemigqa kufanele lilingane nenani lamakholomu we-matrix yokuqala, nenombolo yamakholomu - inani lemigqa. Umdlalo onjalo ubaluleke kakhulu ukuthi umphumela uboniswe kahle. Ngasikhathi sinye, iseli eliqukethe inkulumo ethi "# lisho!" Kufanele kube yiseli elingaphezulu kwesokunxele le-array elenziwe futhi kulokhu kufanele uqale inqubo yokukhetha ngokuvala inkinobho yegundane kwesobunxele. Ngemuva kokuthi ukhethe, setha isikhombisi entanjeni yefomula ngokushesha ngemuva kokubonakaliswa ko-opharetha we-transp, okufanele kukhonjiswe kuwo. Ngemuva kwalokho, ukwenza ukubalwa, udinga ukucindezela inkinobho ethi Faka, njengoba kuyisiko kumafomula ajwayelekile, kanye nokudayela inhlanganisela ye-CTRL + Shift + Enter.



5. Ngemuva kwalezenzo, i-matrix yaboniswa njengoba sidinga, okungukuthi, ngendlela eguqulwe. Kepha kunenye inkinga. Iqiniso ngukuthi manje i-matrix entsha iyifomula ehlobene ne-arsha Lapho uzama ukwenza noma yiluphi ushintsho nokuqukethwe matrix kuzovela iphutha. Abanye abasebenzisi isimo esinjalo sezinto anelisa kakhulu, njengoba bengeke benze izinguquko kuhlu, kodwa abanye badinga i-matrix lapho ungasebenza khona ngokugcwele.

   Ukuxazulula le nkinga, sabela lonke uhla lonke oluthengisiwe. Ngokuhamba ngethebhu "Yasekhaya", chofoza isithonjana esithi "Kopisha", esitholakala kwiribhoni eqenjini le-Clipboard. Esikhundleni sesenzo esibekiwe, ungakwazi, ngemuva kokukhethwa, yenza isethi yesinqamuleli sekhibhodi esejwayelekile ukukopisha i-CTRL + C.



6. Ngemuva kwalokho, ngaphandle kokukhipha ukukhethwa ebangeni elihanjiwe, yenza ukuchofoza kukho ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe ku-Insert Parameter Group, chofoza isithonjana esithi "Inani", elinombono we-pictograph ngesithombe sezinombolo.

   

   Ukulandela lokhu, ifomula le-mastif le-TRAC lizosuswa, futhi kumaseli kuphela amanani angahlala nawo asebenza ngendlela efanayo ne-matrix yasekuqaleni.

Isifundo: I-Master of Imisebenzi ku-Asuka

Indlela 2: Ukuguqula i-matrix usebenzisa ukufakwa okukhethekile

Ngaphezu kwalokho, i-matrix ingadluliselwa kusetshenziswa into eyodwa yemenyu yomongo ebizwa nge- "Faka okukhethekile".

1. Khetha umthombo Matrix ngesikhombisi ngokubamba inkinobho yegundane kwesobunxele. Okulandelayo, ngokuchofoza kuthebhu ethi "Ikhaya", chofoza isithonjana esithi "Kopisha", esisezingeni elithi "Exchange Buffer" Vimber.

   

   Esikhundleni salokho, ungenza ngokuhlukile. Ukukhetha indawo ngokuchofoza kuyo inkinobho yegundane kwesokudla. Imenyu yomongo icushiwe, lapho kufanele ukhethe khona "Kopisha".

   

   Ngokwesimo senye indlela yezinketho ezimbili ezedlule zamakhophi, ungakwazi, ngemuva kokukhetha, yenza iqoqo lenhlanganisela yezinkinobho ezishisayo i-CTRL + C.

2. Sikhetha iseli elingenalutho eshidini, okufanele libe yinto esezingeni eliphezulu yesobunxele ye-matrix eguqulwe. Sichofoza ngokuchofoza kwesokudla. Ukulandela lokhu, imenyu yomongo iyasebenza. Ihamba entweni ethi "Ukufaka Okukhethekile". Enye imenyu encane iyavela. Iphinde ibe nesigaba esibizwa ngokuthi "ibhokisi elikhethekile ...". Chofoza kuyo. Ungase futhi ukhethe ukukhetha, esikhundleni sokubiza imenyu yokuqukethwe, shayela inhlanganisela ye-CTRL + ALT + V kukhibhodi.



3. Iwindi eli-Insert elikhethekile liyasebenza. Kunezindlela eziningi zokukhetha, ngqo ukuthi ungayifaka kanjani idatha ekopishelwe ngaphambili. Kuthu, udinga ukushiya cishe zonke izilungiselelo ezizenzakalelayo. Kufuze kufakwe ipharamitha yasuka kuphela. Ngemuva kwalokho udinga chofoza inkinobho ethi "Kulungile", etholakala ngaphansi kwaleli windi.



4. Ngemuva kwalezi zenzo, i-matrix eguqulwe izokhonjiswa engxenyeni ebekwe kusengaphambili yeshidi. Ngokungafani nendlela eyedlule, sesivele sithole i-matrix egcwele ngokugcwele, engashintshwa, njengoMthombo. Akukho okunye ukucwengwa noma ukuguqulwa okudingekayo.



5. Kepha uma ufisa, uma i-matrix yokuqala ungayidingi, ungayisusa. Ukuze wenze lokhu, ukugqamisa ngesikhombisi sayo ngokubamba inkinobho yegundane kwesobunxele. Bese uchofoza entweni yokuchofoza kwesokudla kwesokudla. Kumenyu yokuqukethwe, ezovula ngemuva kwalokhu, khetha into ethi "Okuqukethwe okucacile".

Ngemuva kwalezenzo, i-matrix eguquliwe kuphela ezohlala eshidini.

Lezi zindlela ezimbili, okwakudingidwa ngenhla, ungazithola ngokugqamisa umatikuletsheni, kodwa futhi namatafula agcwele. Inqubo izocishe ifane.

Isifundo: Ungayifaka kanjani itafula ekudingisweni

Ngakho-ke, sithole ukuthi ohlelweni lwe-Excel, i-matrix ingadluliswa, okungukuthi, phenduka, ukuguqula amakholomu nemigqa ngezindawo, ngezindlela ezimbili. Inketho yokuqala ifaka ukusetshenziswa komsebenzi we-TRACP, kanti okwesibili - amathuluzi okufaka okukhethekile. Ngobukhulu, umphumela wokugcina, otholakala lapho usebenzisa zombili lezi zindlela, awehlukile. Zombili izindlela zisebenza cishe kunoma yisiphi isimo. Ngakho-ke lapho ukhetha inketho yenguquko, okuthandwa ngumsebenzisi othize ngaphambili. Okungukuthi, yimiphi yalezi zindlela ezikuhle kakhulu kuwe elula ngokwengeziwe, futhi uyisebenzise.