Indlela yokunciphisa usayizi wevidiyo ku-Sony Vegas

Lapho usebenza ngamatrices, ngezinye izikhathi udinga ukuwahambisa, okungukuthi, ngamazwi alula, uwaphendule. Yiqiniso, ungaphazamisa idatha ngesandla, kodwa i-Excel inikeza izindlela eziningana zokwenza kube lula futhi ngokushesha. Ake siwaphule phansi ngokuningiliziwe.

Inqubo yokuguqula

Ukudlulisa i-matrix kuyinkqubo yokushintsha amakholomu nemigqa ezindaweni. Ku-Excel, kunamathuba amabili okudlulisa: usebenzisa umsebenzi IZITHUTHUKO bese usebenzisa ithuluzi lokufaka. Cabangela ngayinye yalezi zindlela ngokuningiliziwe.

Indlela 1: UMSEBENZI WEZITHUTHI

Umsebenzi IZITHUTHUKO kungokwesigaba se-opharetha "Izixhumanisi nezigaba". Okuyingqayizivele ukuthi, njengeminye imisebenzi esebenza ngemigqa, umphumela wokukhipha akuyona okuqukethwe kweli cell, kodwa yonke idatha ehlukahlukene. I-syntax yomsebenzi ilula futhi ibukeka kanje:

= TRANSPORT (i-array)

Lokhu kungukuthi, ukuphikisana okuphela kwalokhu opharetha kuyinkomba yohlu lwamalungu, kulokhu kuthiwa i-matrix okufanele iguqulwe.

Ake sibone ukuthi lo msebenzi ungasetshenziswa kanjani usebenzisa isibonelo se-matrix yangempela.

1. Khetha isilawuli esingenalutho kushidi, sihlela ukwenza i-matrix eguquliwe esitokisini phezulu kwesokunxele. Okulandelayo, chofoza isithonjana "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.



2. Qalisa Amakhosi omsebenzi. Vula isigaba kuso "Izixhumanisi nezigaba" noma "Uhlu oluphelele lwe-alfabhethi". Ngemva kokuthola igama "IZITHUTHUKO"ukhethe futhi ukhethe inkinobho "Kulungile".



3. I-window ye-arguments function iqala. IZITHUTHUKO. Ukuphikisana okuphela kwalokhu opharetha kufana nendawo "Uhlu". Kulo mkhakha udinga ukufaka izixhumanisi ze-matrix, okufanele iphendulwe. Ukuze wenze lokhu, setha isikhangiso ensimini futhi, ubambe inkinobho yegundane lesokunxele, ukhethe lonke uhla lwe-matrix kushidi. Ngemuva kokuthi ikheli lendawo liboniswe efasiteleni lezingxoxo, chofoza inkinobho "Kulungile".



4. Kodwa, njengoba sibona, esitokisini, eklanyelwe ukubonisa umphumela, inani elingalungile likhonjiswa njengephutha "#VALUE!". Lokhu kungenxa yokuzikhethela komsebenzi we-opharetha abahleliwe. Ukuze ulungise leli phutha, khetha uhla lwamaseli lapho inani lezinhlu kufanele lilingane nenamba yamakholomu we-matrix yangempela, nenani lamakholomu enombolweni yemigqa. Umdlalo onjalo kubaluleke kakhulu ukuze umphumela uboniswe ngendlela efanele. Ngesikhathi esifanayo, iseli eliqukethe inkulumo "#VALUE!" Kufanele kube iseli eliphezulu ngakwesobunxele lendawo ekhethiwe futhi livela lapho ukuthi inqubo yokukhetha iqalwe ngokubamba phansi inkinobho yegundane lesokunxele. Ngemuva kokuba ukhethe, hlela isikhombisi kubha yefomula ngokushesha ngemuva kwesitatimende IZITHUTHUKOokuyinto okufanele ivele kuyo. Ngemuva kwalokho, ukwenza isibalo, akudingeki uchofoze inkinobho Ngena, njengokwezifiso emafomeni avamile, bese udayela inhlanganisela Ctrl + Shift + Faka.



5. Emva kwalezi zenzo, i-matrix iboniswa njengoba sidinga, okungukuthi, efomini elithuthukisiwe. Kodwa kukhona enye inkinga. Iqiniso liwukuthi manje i-matrix entsha iyingxenye ehlanganiswe ifomula elingenakuguqulwa. Uma uzama ukwenza noma yiziphi izinguquko kokuqukethwe kwe-matrix, iphutha lizovela. Abanye abasebenzisi baneliseke ngokuphelele ngalesi simo, ngoba ngeke benze izinguquko ohlwini, kuyilapho abanye badinga umthamo ongasebenza ngawo ngokugcwele.

   Ukuxazulula le nkinga, khetha yonke ibanga elidlulisiwe. Ukuhambisa kuthebhu "Ikhaya" chofoza kusithonjana "Kopisha"okuyinto itholakala kule tape eqenjini "Ibhodi lokunamathisela". Esikhundleni sesenzo esicacisiwe, kungenzeka ngemuva kokukhethwa ukwenza isethi yamakhi okunciphisa okujwayelekile okukopisha. Ctrl + C.



6. Khona-ke, ngaphandle kokukhipha ukhetho kusuka ebangeni elidlulisiwe, chofoza kukho inkinobho yegundane efanele. Emenyu yomongo eqenjini "Izinketho zokufaka" chofoza kusithonjana "Amanani", esinesimo sesithonjana esinomfanekiso wezinombolo.

   

   Ukulandela lokhu kuyindlela yokuhlela IZITHUTHUKO izosuswa, futhi inani elilodwa kuphela lizohlala emaseli, ongasebenzisa ngendlela efanayo ne-matrix yangempela.

Isifundo: I-Excel umsebenzi wizard

Indlela 2: thumela umthamo usebenzisa i-ekhethekile

Ngaphezu kwalokho, i-matrix ingashintshwa ngokusebenzisa into eyodwa yemenyu yemongo, ebizwa ngokuthi "Namathisela Okukhethekile".

1. Khetha i-matrix yangempela ne-cursor, ubambe inkinobho yegundane lesokunxele. Okulandelayo, iya kuthebhu "Ikhaya", chofoza kusithonjana "Kopisha"efakwe kuzilungiselelo zezilungiselelo "Ibhodi lokunamathisela".

   

   Kunalokho, ungakwenza ngokuhlukile. Khetha indawo, chofoza kuso ngenkinobho yegundane kwesokudla. Iqalisa imenyu yokuqukethwe lapho ukhetha khona into "Kopisha".

   

   Njengokunye kokukhethwa kukho kokubili kokukopisha kwangaphambilini, ungenza ukhetho lwenhlanganisela yamakhi ashisayo ngemuva kokukhetha Ctrl + C.

2. Sikhetha kushidi ilinalutho elingenalutho, okufanele libe yinto ephezulu kakhulu kwesokunxele ye-matrix eguquliwe. Chofoza kuso nge inkinobho yegundane kwesokudla. Ukulandela lokhu, imenyu yenkathi ivuliwe. Kuyo senza ukuhambisa kuleyo nto "Namathisela Okukhethekile". Enye imenyu encane ibonakala. Ibuye ibe nesigatshana esibizwa ngokuthi "Faka okukhethekile ...". Chofoza kuso. Futhi, uma ukhethe, esikhundleni sokubiza imenyu yokuqukethwe, thayipha inhlanganisela kwikhibhodi I-Ctrl + Alt + V.



3. Ifasitela efakiwe ekhethekile ivuliwe. Kunezinketho eziningi ongakhetha kuzo, ukuthi ungabamba kanjani ncamashi idatha ekopishwe ngaphambilini. Esimweni sethu, udinga ukushiya cishe zonke izilungiselelo ezizenzakalelayo. Kuphela eduze kwepharamitha "Ukuthutha" kufanele uphawule. Bese uchofoza inkinobho. "Kulungile"elitholakala phansi kule window.



4. Emva kwalezi zenzo, i-matrix eguquliwe izoboniswa engxenyeni ekhethiwe yeshidi. Ngokungafani nendlela eyedlule, sesivele sithole i-matrix egcwele, engashintshwa, kanye nomthombo. Akukho ukulungiswa okuqhubekayo noma ushintsho oludingekayo.



5. Kodwa uma ufuna, uma ungadingi i-matrix yangempela, ungayisusa. Ukuze wenze lokhu, ukhethe nge-cursor, ubambe inkinobho yegundane lesokunxele. Bese uchofoza into ekhethiwe nge inkinobho efanele. Emenyu yomongo evulwa ngemva kwalokhu, khetha into "Sula okuqukethwe".

Emva kwalezi zenzo, kuphela i-matrix eguquliwe izohlala eshadini.

Ngezindlela ezimbili ezifanayo okukhulunywe ngazo ngenhla, kungenzeka ukuba uthumele ku-Excel hhayi kuphela amatrices, kodwa futhi namatafula aphelele. Inqubo izoba cishe efana.

Isifundo: Ungafake kanjani itafula ku-Excel

Ngakho, sithole ukuthi ku-Excel i-matrix ingashintshwa, okungukuthi, iguqulwe ngokushintsha amakholomu nemigqa ngezindlela ezimbili. Okokuqala ukukhetha ukusebenza IZITHUTHUKOkanti eyesibili ngamathuluzi okufaka okukhethekile. Ngokubanzi, umphumela wokuphela, otholakala ngokusebenzisa kokubili lezi zindlela, awufani. Zombili izindlela zisebenza cishe noma yisiphi isimo. Ngakho uma ukhetha ukukhetha kokuguqulwa, izintandokazi zakho zomsebenzisi othize ziza kuqala. Okusho ukuthi yiyiphi yalezi zindlela elula kakhulu kuwe, futhi usebenzise lowo.