Excel View Basa

Excel inonyanya kuve chirongwa chekugadzirisa data icho chiri patafura. Basa remaonero rinoratidza kukosha kwaunoda kubva patafura nekugadzirisa iyo yakataurwa paramende inowanikwa mumutsara mumwe chete kana mutsara. Nekudaro, semuenzaniso, mutengo wezvinhu unogona kuratidzwa muchitokisi chakaparadzana, taura zita raro. Saizvozvo, iwe unogona kuwana iyo nhamba yefoni ne surname yemunhu. Ngativerengei zvakadzama kuti maonero anoita sei basa.

Chikumbiro Operator View

Usati waenderera nekushandiswa kweshanduko yekutarisa, iwe unofanirwa kugadzira tafura iyo iyo kukosha kunoda kuwanikwa uye tsika yakatarwa ichave. Zvinoenderana neiyi paramita, kutsvaga kuchaitwa. Pane nzira mbiri dzekushandisa iyo basa: Vector chimiro uye fomu yehurongwa.

Nzira 1: Vector fomu

Iyi nzira inowanzo kuve inoshanda pakati pevashandisi kana uchishandisa iyo yekuona inoshanda.

1. Kuti zvive nyore, tinovaka tafura yechipiri nemakoramu "kukosha kwaunoda" uye "mhedzisiro". Izvi hazvisizvo, sezvo chero maseru papepa anogona kushandiswa kune izvi zvinangwa. Asi zvichave zvakanyanya nyore.



2. Sarudza iyo sero panofanira kuratidzwa mhedzisiro. Ichave iyo formula pachayo. Dzvanya pane "paste basa" icon.



3. Tenzi webasa wizard anovhura. Mune rondedzero yekutsvaga iyo "maonero" chinhu, isu tinozviratidza uye tinya pane "ok" bhatani.



4. Inotevera inovhura imwe hwindo rimwe. Vamwe vashandisi havawanzo kuwanikwa. Pano iwe unofanirwa kusarudza imwe yedata yekuumba mafomu ayo hurukuro yakaenda kumusoro: Vector kana fomu yehurongwa. Sezvo isu tave tichifunga nezvemhando dzeVector, tinosarudza yekutanga sarudzo. Dzvanya pane "OK" bhatani.



5. Iyo hwindo rekupokana rinovhura. Sezvatinoona, ichi chikamu chine nharo nhatu:
   • Kukosha kwaunoda;
   • Inotaridzwa vector;
   • Vadesera.

   Kune avo vashandisi vanoshuvira kushandisa iyi inoshanda pamurume, pasina kushandisa "tenzi mabasa", zvakakosha kuti uzive Syntax yekuinyora. Zvinotaridzika seizvi:

   = Kutarisa (kuda_station; inotaridzika_tector; vector_tedys)

   Isu tichazotarisa pane idzodzo dzinofanira kuitwa muhwindo rekupokana.

   Mu "kukosha kwechipiri" munda, tinopinda maironga echitokisi, kwatichanyora paramende iyo iyo kutsvaga kuchaitwa. Isu takadaidza kudaro cell yakaparadzana mutafura yechipiri. Semazuva ese, iyo kero yekubatanidza yakarairwa mumunda kana pamurume kubva mukhibhodi, kana nekuenzanisa nzvimbo inoenderana. Iyo yechipiri sarudzo inonyanya nyore.



6. Mu "runyorwa vector" shamba Inoronga mumunda uyu ndeiyi nzira iri nyore yekusimbisa nzvimbo iri papepa.



7. Iyo "Vector mhinduro" munda inosanganisira inoronga yemhando iyo huwandu hwatinofanira kuwana hunowanikwa.



8. Mushure mekunge data rese rapindwa, tinya "OK" bhatani.



9. Asi, sezvatinoona, kusvika pari zvino basa rinoratidza mhedzisiro isiriyo muchitokisi. Kuti izotanga kushanda, pinda paramende iwe unofanirwa kupinda munzvimbo yeiyo inotariswa vekitori yaunoda.

Mushure meiyo data yakaunzwa, sero mune iyo basa iri inozadzwa neyakagadziriswa neiyo chiratidzo chinoenderana kubva kumhedzisiro vector.

Kana isu tikapinda muzita rakasiyana muchitokisi chekukosha kwaunoda, saka mhedzisiro, zvichiteerana, zvichachinja.

Iyo maonero ekuona yakafanana chaizvo ne prd. Asi muhofisi inotarisa-tarisa inofanira kunge yakanyanyisa kuruboshwe. Kuona uku kurambidzwa hakune kuti tione pane iyo muenzaniso pamusoro.

Chidzidzo: Wizard mabasa muExcel

Nzira 2: Misa Line

Mukupesana nenzira yekare, fomu iri rinoshanda nehurongwa hwese, iro rinobva rasanganisira iyo inozivikanwa mhando uye mhedzisiro yemhedzisiro. Panguva imwecheteyo, huwandu hwakaonekwa hunofanirwa kuve hwekuruboshwe rakanyanyisa renji.

1. Pashure pokunge chitokosha chacho chasarudzwa, uko mhedzisiro yacho icharatidzwa, iyo wizard wizard iri kumhanya uye shanduko kune iyo maonero anoitwa, hwindo rinovhura sarudza fomu yeanoshanda. Mune ino kesi, sarudza mhando yeanoshanda kune yakarongeka, ndiyo, iyo yechipiri chinzvimbo mune rondedzero. Dzvanya "Zvakanaka".



2. Iyo hwindo rekupokana rinovhura. Sezvauri kuona, iyi subtype yebasa iri chete nharo mbiri - "iyo inoreva" uye "kurongedza". Saizvozvo, syntax yayo iri seinotevera:

   = Kutarisa (Kunodiwa) Array)

   Mu "Bhaivhe" Yakaipa, sekutanga kwenzira yapfuura, pinda izvo zvinongedzo zvechitokisi umo chikumbiro chacho chichapinda.



3. Asi mu "rurongwa" munda, iwe unofanirwa kutsanangura iwo marongero ehurongwa hwese, umo mapopu gadziriro dzinoonekwa uye huwandu hwemhedzisiro. Mune ino kesi, huwandu hwakaonekwa hunofanirwa kuve hwakanyanyisa kuruboshwe rumbidzo, neimwe nzira iyo formula ichashanda zvisiri izvo.



4. Mushure meiyo data yakatarwa yapinda, tinya iyo "OK" bhatani.



5. Zvino, sepakutanga, kuti ushandise chinhu ichi, muchitokisi nekuda kwekukosha kwaunoda, tinopinda rimwe remazita eiyo nzvimbo yaionekwa.

Sezvauri kuona, mushure meizvozvo, mhedzisiro yacho inozvibvisa kunzvimbo inoenderana.

Tarisa! Inofanira kucherechedzwa kuti iyo formula maonero emassif ndeyekuchemesa. Mune shanduro dzitsva dzeBudiriro, iripo, asi inosara chete yekuwirirana negwaro dzakagadzirwa mune dzakapfuura shanduro. Kunyangwe zvichiita kuti ushandise iyo kuumbwa kwehurongwa hwechirongwa chazvino, zvinokurudzirwa kushandisa matsva ePRD masero prd panzvimbo (yekutsvaga iyo yekutanga yerudzi) uye GPR (yekutsvaga mumutsara wekutanga we ranga). Ivo havapi nzira yekushanda kweiyo formula yekutsvaga artays, asi ivo vanoshanda zvakanyanya nenzira kwayo. Asi iyo vector Operator maonero akakodzera kusvika zvino.

Chidzidzo: Mienzaniso yeRFD basa muExcel

Sezvauri kuona, iyo yekuona inoshanda mubatsiri akanaka kana uchitsvaga data pane kukosha kwaunoda. Iyi ficha inonyanya kubatsira mumatafura marefu. Izvo zvinofanirwawo kucherechedzwa kuti kune marudzi maviri ebasa iri - vector uye kune arrays. Yekupedzisira yatove yatove isingadzoreki. Kunyangwe vamwe vashandisi vachiri kushandiswa.