Excel Reba Imikorere

Excel ni porogaramu itunganya amakuru iri mumeza. Ibitekerezo byerekana agaciro wifuza kuva kumeza mugutunganya ibipimo bizwi byagenwe biri kumurongo umwe cyangwa inkingi. Rero, kurugero, igiciro cyibicuruzwa gishobora kugaragara mu kagari kitandukanye, gasobanura izina ryayo. Mu buryo nk'ubwo, urashobora kubona numero ya terefone ukoresheje izina ryumuntu. Reka tubimenye birambuye uburyo ibiranga bikora.

Gukoresha porogaramu

Mbere yo gukomeza gukoresha igikoresho cyo kureba, ugomba gukora ameza aho indangagaciro zigomba kuboneka hamwe nindangagaciro zagaragaye. Ukurikije ibi birori, ubushakashatsi buzashyirwa mubikorwa. Hariho inzira ebyiri zo gukoresha imikorere: imiterere ya Vector hamwe nuburyo bwa array.

Uburyo 1: Ifishi ya Vector

Ubu buryo akenshi bukoreshwa mubakoresha mugihe ukoresheje uwubaze.

1. Kugirango woroshye, twubaka ameza ya kabiri hamwe ninkingi "agaciro wifuza" na "ibisubizo". Ibi ntabwo byanze bikunze, kuva selile zose ziri ku rupapuro zirashobora gukoreshwa kuri izi ntego. Ariko bizaba byoroshye.



2. Hitamo Akagari aho ibisubizo byanyuma bizerekanwa. Bizaba formula ubwayo. Kanda ahanditse "Paste.



3. Umuyobozi wimyitozo ya Wizard arakingura. Kurutonde rwo gushakisha ibintu "kureba", turabigaragaza no gukanda kuri buto "OK".



4. Ubukurikira bufungura idirishya ryibindi. Abandi bakoraga ntibakunze kuboneka. Hano ukeneye guhitamo kimwe mu makuru yo gushiraho amakuru yinjiza hejuru: vector cyangwa uburyo bwa array. Kubera ko ubu dusuzumye amoko ya Vector, duhitamo inzira yambere. Kanda kuri buto ya "OK".



5. Idirishya ry'impaka rifungura. Nkuko tubibona, iyi mikorere ifite impaka eshatu:
   • Agaciro kafuzwa;
   • Reba Vector;
   • Ibisubizo bya Vector.

   Kuri abo bakoresha bifuza gukurikiza uyu mukoresha intoki, badakoresheje "umutware wimikorere", ni ngombwa kumenya syntax yo kubyandika. Birasa nkibi:

   = Kureba (kwifuzwa_ibyifuzo; kureba_tector; vector_abisanzwe)

   Tuzibanda kuri izo ndangagaciro zigomba gukorwa mu idirishya ry'impaka.

   Muri "Agaciro ka kabiri", twinjije imirongo ya selire, aho tuzandika ibipimo bizabera gushakisha bizakorwa. Twahamagaye selile itandukanye kumeza ya kabiri. Nkibisanzwe, aderesi imwe yagenwe mumurima cyangwa intoki kuva clavier, cyangwa mugutanga agace gahuye. Ihitamo rya kabiri rirushijeho kuba byoroshye.



6. Muri "urutonde rwa Vector", sobanura urwego rwa selile, kandi kuri twe, inkingi aho amazina aherereye, imwe muri zo izandikwa mu kagari ka "Fogike". Guhuza muriki murima kandi nuburyo bworoshye bwo kwerekana agace kurupapuro.



7. "Vector Ingaruka" Umwanya urimo guhuza intera aho indangagaciro dukeneye kubona.



8. Nyuma yamakuru yose yinjiye, kanda buto "OK".



9. Ariko, nkuko tubibona, kugeza ubu imikorere itagaragaza ibisubizo bitari byo mu Kagari. Kugirango igabanye gukora, andika ibipimo ukeneye kugirango winjire ahantu hareba vector ireba.

Nyuma yamakuru yatangijwe, akagari aho imikorere iherereye ihita yuzuyemo ibimenyetso bihuye nibisubizo.

Niba twinjiye mutandukanye mu Kagari kagaciro keza, noneho ibisubizo, byombi bizahinduka.

Ibitekerezo birasa cyane na prd. Ariko mu nkingi igaragara yintwaro igomba byanze bikunze gusiganwa bikabije. Kureba uku kubuza ntabwo bigiranye nurugero hejuru.

Isomo: Umukozi wa Wizard muri Excel

Uburyo 2: Umurongo rusange

Bitandukanye nuburyo bwambere, iyi fomu ikora hamwe na array yose, ihita ikubiyemo urwego rugaragara kandi ibisubizo. Mugihe kimwe, inzitizi igomba kuba iy'inkingi zikabije za array.

1. Nyuma yuko selile yatoranijwe, aho ibisubizo bizerekanwa, wizard wizard ikora kandi ihinduka ryikinyobwa rikora, idirishya rifungura guhitamo ifishi ya Operator. Muri iki kibazo, hitamo ubwoko bwumukoresha wa Array, ni ukuvuga umwanya wa kabiri murutonde. Kanda "OK".



2. Idirishya ry'impaka rifungura. Nkuko mubibona, iyi subtype yimikorere ifite impaka ebyiri gusa - "ibisobanuro byifuzwa" na "array". Kubwibyo, syntax yayo niyi ikurikira:

   = Kureba (kwifuzwa) array)

   Mu murima "utari", kimwe nuburyo bwabanje, andika imirongo yingirabuzimafatizo zizinjira.



3. Ariko muri "array", ugomba kwerekana imirongo yose ya array, aho urufatiro rureruye kandi rwibisubizo biherereye. Muri iki kibazo, urwego rwarebye ntigomba kuba byanze bikunze kuba inkingi ihatiwe ikabije ya array, bitabaye ibyo, formula izakora nabi.



4. Nyuma yamakuru yihariye yinjiye, kanda buto "OK".



5. Noneho, nkigihe cyanyuma, kugirango ukoreshe iyi miterere, muri kasho kubera agaciro wifuza, twinjije rimwe mumazina yurugero rurebwa.

Nkuko mubibona, nyuma yibyo, ibisubizo birahita bisohoka mukarere gahuye.

Icyitonderwa! Twabibutsa ko formula ibona missif itagikoreshwa. Muburyo bushya bwa Excel, birahari, ariko gusigara gusa kugirango bahuze ninyandiko zakozwe muri verisiyo zabanjirije. Nubwo bishoboka gukoresha kubumbarikori muri gahunda ya none ya gahunda, birasabwa gukoresha imirimo mishya ya PRD intera). Ntabwo batanga inzira yimikorere ya formula yo gushakisha ibintu bya arrays, ariko bakora neza. Ariko icyerekezo cya Ovector cyerekana ni ngombwa kugeza ubu.

Isomo: Ingero zimikorere ya RFD muri Excel

Nkuko mubibona, umukoresha ureba numufasha mwiza mugihe ushakisha amakuru kubiciro byifuzwa. Iyi mikorere ni ingirakamaro cyane mumeza maremare. Twabibutsa kandi ko hari uburyo bubiri bwiki gikorwa - Vector no kuri Arrays. Uwanyuma arenze. Nubwo abakoresha bamwe baracyakurikizwa.