Kusetshenziswa umsebenzi we-V View kuMicrosoft Excel

I-Excel ngokuyinhloko uhlelo lokucubungula idatha esetafuleni. Umsebenzi we-BROWSE ukhombisa inani elifunekayo kusuka etafuleni ngokucubungula ipharamitha ethile eyaziwayo etholakala kumugqa noma ikholomu efanayo. Ngakho-ke, ngokwesibonelo, ungabonisa intengo yomkhiqizo esitokisini esihlukile ngokuchaza igama laso. Ngokufanayo, ungathola inombolo yocingo ngegama lomuntu. Ake sibheke ngemininingwane yokuthi umsebenzi we-V View usebenza kanjani.

Bheka opharetha

Ngaphambi kokuthi uqale usebenzise ithuluzi le-V View, kuzodingeka ukuthi wakhe itafula lapho kuzoba khona amanani adinga ukutholakala namanani anikezwe. Ngokusho kwale mikhawulo, usesho luzokwenziwa. Kunezindlela ezimbili zokusebenzisa umsebenzi: ukwakheka kwevektha nokwakheka kwamalungu afanayo.

Indlela yoku-1: Ifomu le-Vector

Le ndlela isetshenziswa kakhulu phakathi kwabasebenzisi lapho kusetshenziswa opharetha weVV.

1. Ukuze kube lula, sakha itafula lesibili elinamakholamu "Ukufuna inani" futhi "Umphumela". Lokhu akudingekile, ngoba ngalezi zinhloso ungasebenzisa noma yimaphi amaseli eshidi. Kepha kuzoba lula kakhulu.



2. Khetha iseli lapho kuzoboniswa khona umphumela wokugcina. Ifomula uqobo lizoba kuyo. Chofoza isithonjana "Faka umsebenzi".



3. Iwindi le-Function Wizard liyavula. Kuluhlu sifuna into "BUKA" khetha bese uchofoza inkinobho "Kulungile".



4. Okulandelayo, kuvulwa iwindi elengeziwe. Abanye opharetha akuvamile ukukubona. Lapha udinga ukukhetha eyodwa yezindlela zokucubungula idatha okuxoxwe ngayo ngenhla: ifektha noma ifomu lokuhlela. Njengoba manje sesibheka nje ukubuka i-vector, sikhetha inketho yokuqala. Chofoza inkinobho "Kulungile".



5. Iwindi lokuphikisana liyavula. Njengoba ukwazi ukubona, lo msebenzi unezimpikiswano ezintathu:
   • Inani elifunekayo;
   • Isithangami sokuqokelelwa;
   • Imiphumela ye-Vector.

   Kulabo basebenzisi abafisa ukusebenzisa lo opharetha ngesandla, ngaphandle kokusebenzisa "Amakhosi wemisebenzi", kubalulekile ukwazi i-syntax yokubhala kwayo. Kubukeka kanjena:

   = V View (search_value; buka_vector; Umphumela_vector)

   Sizohlala kulawo manani okufanele afakwe kuwindi lokuphikisana.

   Ensimini "Ukufuna inani" faka izixhumanisi zeseli lapho sizoqopha khona ipharamitha lapho ucwaningo luzokwenziwa khona. Etafuleni lesibili, sibize lokhu ngokuthi iseli elihlukile. Njengokujwayelekile, ikheli lokuxhumanisa lifakwa emkhakheni kungaba ngesandla kusukela kukhibhodi, noma ngokugqamisa indawo ehambelana nayo. Inketho yesibili ilula kakhulu.



6. Ensimini Ibuke i-Vector khombisa uhla lwamaseli, kuthi thina kithi ikholomu lapho kukhona khona amagama, elinye lawo esizobhala esitokisini "Ukufuna inani". Ukufaka izixhumanisi kulo mkhakha nako kulula ngokukhetha indawo eshidini.



7. Ensimini "Ukwahluka kwemiphumela" izixhumanisi zobubanzi zifakiwe, aphi amagugu esidinga ukuwathola.



8. Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".



9. Kepha, njengoba ubona, kuze kube manje umsebenzi ukhombisa umphumela ongalungile esitokisini. Ukuze iqale ukusebenza, kuyadingeka ukufaka ipharamitha esiyidingayo kusuka ku-vector ebukwayo esifundeni senani olifunayo.

Ngemuva kokuthi idatha ifakiwe, iseli lapho kusebenza khona lo msebenzi ngokuzenzakalelayo igcwaliswa yinkomba ehambisanayo evela kwivoli yomphumela.

Uma sifaka elinye igama esitokisini senani olifunayo, khona-ke umphumela, ngokulandelana, uzoshintsha.

Umsebenzi we-V View ufana kakhulu ne-VLOOKUP. Kepha ku-VLOOKUP, ikholamu ebukwayo kufanele ishiywe kunene. I-VIEW ayinawo lo mkhawulo, esiwubona kwisibonelo esingenhla.

Isifundo: Umsebenzi Wizard e-Excel

Indlela 2: ifomu lokuhlela

Ngokungafani nendlela yangaphambilini, leli fomu lisebenza ngamalungu afanayo amaningi, okubandakanya ngokushesha ibanga lokubuka kanye nohla lwemiphumela. Kulokhu, ibanga elibukwayo kumele ngabe liyikholamu kwesokunxele kakhulu le-array.

1. Ngemuva kokuba iseli likhethiwe lapho umphumela uzokhonjiswa khona, i-Function Wizard yethulwa bese kwenziwa ushintsho kumsebenzisi we-VIEW, iwindi lokukhetha ifomu le-opharetha liyavuleka. Kulokhu, sikhetha uhlobo lomhlinzeki weqoqo, okungukuthi, isikhundla sesibili ohlwini. Qhafaza KULUNGILE.



2. Iwindi lokuphikisana liyavula. Njengoba ukwazi ukubona, lo msebenzi omncane unezimpikiswano ezimbili kuphela - "Ukufuna inani" futhi Array. Ngakho-ke, isichazamazwi simi ngokulandelayo:

   = V View (usesho_olwesibili; uhlu)

   Ensimini "Ukufuna inani", njengendlela yangaphambilini, faka izixhumanisi zeseli lapho kuzofakwa khona isicelo.



3. Kepha enkundleni Array udinga ukucacisa izixhumanisi zawo wonke amalungu afanayo, aqukethe bobabili ububanzi obukwa kanye nobubanzi bemiphumela. Ngasikhathi sinye, ibanga elibukwayo kumele libe yikholomu yesokunxele yomugqa, kungenjalo ifomula ngeke lisebenze kahle.



4. Ngemuva kokuthi idatha efakiwe ifakiwe, chofoza inkinobho "Kulungile".



5. Manje, njengesikhathi sokugcina, ukuze usebenzise lo msebenzi, esitokisini ngenani olifunayo, faka elinye lamagama ebanga elibukwayo.

Njengoba ukwazi ukubona, emva kwalokho umphumela ukhonjiswa ngokuzenzakalela endaweni ehambisanayo.

Ukunaka! Kufanele kuqashelwe ukuthi ukubuka kwefomula ye-VIEW yokuhlanza akusasebenzi. Ezinguqulweni ezintsha ze-Excel, ikhona, kodwa ishiyelwa kuphela ukuze ihambisane namadokhumenti enziwe ezinguqulweni ezedlule. Noma kungenzeka ukusebenzisa uhlobo lwamalungu afanayo ezimeni zesimanje sohlelo, kuyanconywa esikhundleni salokho ukusebenzisa imisebenzi emisha, esezingeni eliphezulu ye-VLOOKUP (yokusesha kukholamu yokuqala yebanga) ne-GPR (yokusesha emugqeni wokuqala wobubanzi). Aziphansi ngandlela-thile ekusebenzeni kwefomula ye-VIEW yamalungu afanayo, kodwa zisebenza ngokunembe kakhudlwana. Kepha i-VV eyi-opharetha yasesitolo isasebenza.

Isifundo: Izibonelo zomsebenzi we-VLOOKUP ku-Excel

Njengoba ukwazi ukubona, opharetha we-V View bangabasizi abahle kakhulu lapho besesha idatha ngenani olifunayo. Lesi sici sisiza kakhulu kumatafula amade. Kufanele futhi kuqashelwe ukuthi kunezindlela ezimbili zalo msebenzi - i-vector kanye nama-arrays. Eyokugcina isivele isiphelelwe isikhathi. Yize abanye abasebenzisi besasebenza.