Nigute wakora ikizamini cya Excel: uburyo 3 bwerekana

Akenshi kugirango ugerageze ireme ry'ubumenyi ryifashishwa no gukoresha ibizamini. Bakoreshwa kandi mu mitekerereze n'ubundi bwoko bwo kwipimisha. Kuri PC hagamijwe kwandika ibizamini, porogaramu zitandukanye zikoreshwa kenshi. Ariko ndetse na gahunda isanzwe ya Microsoft Excel irashobora guhangana ninshingano, ziboneka kuri mudasobwa zabakoresha bose. Ukoresheje igitabo cyiki cyifuzo, urashobora kwandika ikizamini kidahagije kugirango imikorere yo kwemererwe ibisubizo byatanzwe ukoresheje software yihariye. Reka tumenye uburyo bwo gukora iki gikorwa hamwe na excel.

Kwipimisha

Ikizamini icyo aricyo cyose kirimo guhitamo kimwe mubisubizo byinshi byamahitamo kubibazo. Nkingingo, hariho benshi muribo. Ibyifuzwa ko nyuma yo kurangiza ikizamini umukoresha yamaze kubona, yaba yahanganye no kwipimisha cyangwa atari. Urashobora gukora iki gikorwa mubuhungiro muburyo butandukanye. Reka dusobanure algorithm muburyo butandukanye bwo kubikora.

Uburyo 1: Imirima yinjiza

Mbere ya byose, tuzasesengura amahitamo yoroshye. Isobanura urutonde rwibisubizo bitangwa. Umukoresha agomba kwerekana urwego rwihariye rwigisubizo abona ko ari abizerwa.

1. Twanditse ikibazo ubwacyo. Reka dukoreshe imibare muri ubu bushobozi bworoshye, kandi nkibisubizo - imibare ifite imibare kubisubizo byabyo.



2. Akagari gatandukanye kagenewe kugirango umukoresha ashobore kwinjira mu mubare w'igisubizo abona ko ari abizerwa. Kuburyo bisobanutse neza.



3. Noneho twimukira ku rupapuro rwa kabiri rwinyandiko. Ni kuri yo ko ibisubizo nyabyo bizaba biherereye, aho gahunda izakorera umukoresha. Mu kagari kamwe twandika imvugo "ikibazo 1", no gushiramo imikorere mumikorere ituranye niba, mubyukuri, bizagenzura ukuri kubikorwa byumukoresha. Guhamagara iki gikorwa, tugaragaza akagari kagenewe hanyuma ukande kuri "Shyiramo imikorere", uherereye hafi yumurongo wa formula.



4. Idirishya risanzwe Wizard Idirishya ritangira. Jya mucyiciro "logique" kandi turashaka izina "niba". Gushakisha ntibigomba kuba birebire, kubera ko iri zina ryashyizwe imbere kurutonde rwabakora neza. Nyuma yibyo, tugenera iyi miterere hanyuma ukande kuri buto "OK".



5. Idirishya ryabakozi rikora niba. Umukoresha wagenwe afite imirima itatu ihuye numubare wimpaka zayo. Syntax yiyi mikorere ifata urupapuro rukurikira:

   = Niba (log_section; agaciro_inshuti; agaciro_if_NT)

   Muri "imvugo yumvikana", ugomba kwinjiza imirongo ya selire aho umukoresha yunguka igisubizo. Mubyongeyeho, mumurima umwe ukeneye kwerekana amahitamo akwiye. Kugirango dukore imirongo ya selile igenewe, shyira indanga mumurima. Ibikurikira, dusubira kurupapuro 1 tukaranga ikintu twashakaga kwandika umubare wamahitamo. Umuhuza wacyo uzahita agaragara mumurima widirishya ryimpaka. Byongeye, kugirango ugaragaze igisubizo cyukuri mumurima umwe nyuma ya aderesi ya selire, andika imvugo idafite amagambo "= 3". Noneho, niba uyikoresha mubyifuzo byambere yashyize "3", igisubizo kizafatwa nkicyayo, kandi mubindi bihe byose - atari byo.

   Muri "Ibisobanuro niba ukuri", shyira umubare "1", kandi muri "agaciro niba umurima wabanyoma washyizeho umubare" 0 ". Noneho, niba umukoresha ahisemo amahitamo akwiye, azakira amanota 1, kandi niba atari byo noneho amanota 0. Kugirango uzigame amakuru yinjiye, kanda kuri buto "OK" hepfo yidirishya ryimpaka.



6. Mu buryo nk'ubwo, dukora imirimo ibiri (cyangwa umubare uwo ari wo wose ukeneye) ku mukoresha ugaragara kubakoresha.



7. Kurupapuro 2 ukoresheje imikorere, niba tugaragaje amahitamo meza, nkuko twabikoze mugihe cyambere.



8. Noneho dutegura kubara ingingo. Irashobora gukorwa ukoresheje Autosummy yoroshye. Kugirango ukore ibi, hitamo ibintu byose birimo niba ukanze kuri autosumma agashusho, iherereye kuri rubbon muri tab yo murugo mu gice cyo guhindura.



9. Nkuko tubibona, igihe cyose umubare ni amanota ya zeru, kubera ko tutashubije ingingo yikizamini. Umubare munini wibitekerezo muriki kibazo birashobora guhamagara umukoresha - 3, niba bigizwe neza nibibazo byose.



10. Niba ubishaka, birashobora gukorwa kugirango umubare wamanota uzerekanwa kurupapuro rwumukoresha. Ni ukuvuga, umukoresha azahita abona uko yahanganye nakazi. Kugira ngo dukore ibi, tugaragaza selile itandukanye kurupapuro 1, yitwa "ibisubizo" (cyangwa izindi izina ryoroshye). Kugirango tutavunika umutwe igihe kirekire, shyira gusa imvugo "= urutonde2!", Nyuma winjiza aderesi yicyo kintu kurupapuro rwa 2, aho hari amanota menshi.



11. Reba uburyo ikizamini cyacu, cyemerera nkana ikosa rimwe. Nkuko tubibona, ibisubizo byiki kizamini 2 ikizamini, gihuye nikosa rimwe ryakozwe. Ikizamini gikora neza.

Isomo: Imikorere niba muri Excele

Uburyo 2: Urutonde-hasi

Urashobora kandi gutunganya ikizamini mubuhungiro ukoresheje urutonde rwamanutse. Reka turebe uko twabikora mubikorwa.

1. Kora ameza. Mu gice cyibumoso cyacyo bizaba imirimo, igice cyo hagati - ibisubizo umukoresha agomba guhitamo kuva mubutezimbere bwurutonde rutonyanga. Igisubizo kizerekanwa ibisubizo byafashwe mu buryo bwikora ukurikije ukuri kw'ibisubizo byatoranijwe n'umukoresha. Noneho, kubitangira, tuzubaka ikadiri kandi tugatangiza ibibazo. Koresha imirimo imwe ikoreshwa muburyo bwambere.



2. Noneho tugomba gukora urutonde rwibisubizo bihari. Kugirango ukore ibi, hitamo ikintu cya mbere muri "Igisubizo". Nyuma yibyo, jya kuri tab "data". Ibikurikira, kanda kuri "Kugenzura amakuru", uherereye muri "gukorana na datanch Toolbar.



3. Nyuma yo gukora izi ntambwe, indangagaciro zigaragara Kugenzura Idirishya rirakorwa. Himura muri tab "parameter", niba yakoraga mubindi bitabo. Ibikurikira mumwanya wa "data Ubwoko" uhereye kurutonde rwamanutse, hitamo "urutonde" agaciro. Mu murima "inkomoko", hejuru ya koma, ugomba kwandika ibisubizo kugirango uhitemo kugirango uhitemo kurutonde rwacu kumanuka. Noneho kanda kuri buto ya "ok" hepfo yidirishya rikora.



4. Nyuma yibi bikorwa, pictografiya muburyo bwa mpandeshatu hamwe ningugu iyobowe iburyo bwa selire hamwe nindangagaciro zigaragara. Iyo ukanze kuriyo, urutonde hamwe nuburyo bwinjijwe mbere buzafungurwa, bumwe murimwe bugomba gutoranywa.



5. Mu buryo nk'ubwo, dukora urutonde rw'indi selile z'inkingi "Igisubizo".



6. Noneho tugomba kubikora kugirango turere twinkingi yinkingi "ibisubizo" byerekanaga ukuri gukosorwa nigisubizo cyibikorwa cyangwa ntabwo. Nko muburyo bwambere, ibi birashobora gukorwa hakoreshejwe umukoresha niba. Turagaragaza selire ya mbere ya "Igisubizo" no guhamagara imikorere wizard ukanda igishushanyo cya "Shyiramo".



7. Ibikurikira, ukurikije imikorere yimikorere ukoresheje itandukaniro ryasobanuwe muburyo bwambere, jya kumurimo wimikorere niba. Dufite idirishya rimwe twabonye mugihe cyabanjirije. Muri "imvugo yumvikana", yerekana aderesi yingirabuzimafatizo uhitamo igisubizo. Ibikurikira, shyira ikimenyetso "=" hanyuma wandike igisubizo cyukuri. Ku bitureba, bizaba umubare 113. Mu busobanuro "muri" bisobanura niba ukuri ", twashizeho umubare w'ingingo dushaka kwishyurwa kubakoresha dufite icyemezo gikwiye. Reka, nkuko byahozeho, bizaba umubare "1". Muri "ibisobanuro niba ikinyoma" shyira, shiraho umubare wingingo. Mugihe habaye igisubizo kitari cyo, reka bibe zeru. Nyuma ya Manipulation yavuzwe haruguru ikorwa, kanda buto "OK".



8. Muri ubwo buryo, tuzashyira mubikorwa imikorere niba "ibisubizo" inkingi yinkingi. Mubisanzwe, muri buri kibazo, muri "imvugo yumvikana", hazabaho verisiyo yawe yo gukemura neza ihuye nikibazo muri uyu murongo.
9. Nyuma yibyo, dukora umurongo wanyuma aho umubare wamanota uzagurwa. Tugenera selile zose zinkingi "ibisubizo" hanyuma ukande umaze kumenyera igishushanyo cya AutoSumma muri tab "murugo".



10. Nyuma yibyo, ukoresheje urutonde rwamanutse muri "Subisha" inkingi, tugerageza kwerekana ibyemezo byukuri kubikorwa. Nko mu rubanza rwabanje, ahantu hamwe twemerera nkana. Nkuko mubibona, ubu tuzitegereza ingaruka rusange gusa, ahubwo tunakibazo cyihariye, mu gisubizo cyacyo ari ikosa.

Uburyo 3: Gukoresha Igenzura

Urashobora kandi kugerageza ibizamini ukoresheje ibintu bigenzura muburyo bwa buto kugirango uhitemo igisubizo.

1. Kugirango ubashe gukoresha uburyo bwo kugenzura ibintu, mbere ya byose, ugomba gushoboza tab yiterambere. Mburabuzi, birahagarikwa. Kubwibyo, niba muburyo bwawe bwa excel ntabwo aribwo ukora, noneho manipuline zimwe igomba gukorwa. Mbere ya byose, twimukira muri tab "dosiye". Turakora inzibacyuho kuri "ibipimo".



2. Idirishya rya Parameter rikora. Igomba kwimuka mugice cya "kaseti". Ibikurikira, mugice gikwiye cyidirishya, twashizeho agasanduku kegereye "abatezimbere". Kugirango impinduka zinjire mu gaciro, kanda buto "OK" hepfo yidirishya. Nyuma yibi bikorwa, tab yiterambere izagaragara kuri kaseti.



3. Mbere ya byose, andika umurimo. Iyo ukoresheje ubu buryo, buriwese azashyirwa kurupapuro rwihariye.



4. Nyuma yibyo, jya kuri tab nshya yabatezimbere tuherutse gukora. Kanda kuri "Paste", iherereye muburyo bwa Toolbar. Mu itsinda rya Undirimbo "Ifishi igenzura ibintu", hitamo ikintu cyitwa "Hindura". Ifite buto.



5. Kanda ahanditse inyandiko aho twifuza kohereza ibisubizo. Niho hagaragaramo ko ikintu cyo kugenzura kizagaragara.



6. Noneho andika kimwe mubisubizo Byoroheje aho kuba izina rya buto.



7. Nyuma yibyo, tugaragaza ikintu hanyuma ukande kuri buto yimbeba iburyo. Uhereye kumahitamo aboneka, hitamo "kopi".



8. Hitamo Akagari hepfo. Hanyuma ukande iburyo-Kanda kuri Guhitamo. Kurutonde rugaragara, hitamo umwanya wa "Paste".



9. Ibikurikira, dutanga ibice inshuro ebyiri, kubera ko twahisemo ko hazabaho ibisubizo bine, nubwo muri buri kibazo runaka umubare wabo ushobora gutandukana.



10. Noneho duhindura izina buri buryo kugirango badahuje hamwe. Ariko ntiwibagirwe ko bumwe muburyo bwo guhitamo bugomba kuba bukwiye.



11. Ibikurikira, dushushanya ikintu kugirango tujye kubikorwa bikurikira, kandi muritwe Bisobanura inzibacyuho kurupapuro rukurikira. Na none, kanda ahanditse "Shyiramo", uherereye muri tab yiterambere. Iki gihe tujya guhitamo ibintu mubitsinda "Activex. Hitamo ikintu "buto", gifite urukiramende.



12. Kanda ahabigenewe inyandiko, iherereye munsi yamakuru yinjiye mbere. Nyuma yibyo, bizagaragara kuri yo ikintu dukeneye.



13. Noneho dukeneye guhindura imitungo ya buto yashizweho. Ndakanda kuri buto iburyo kandi muri menu zifungura, hitamo umwanya "imiterere".



14. Idirishya ryo kugenzura rifungura. Mu murima "izina", duhindura izina kumuntu uzarushaho kuba ingirakamaro kuri iki kintu, murugero rwacu kizaba izina "ubutaha. Menya ko nta mwanya uri muri uyu murima. Muri "caption", andika ikibazo "gikurikira". Hano harakwiriye icyuho, kandi iri zina rizerekanwa kuri buto yacu. Muri "umugongo", hitamo ibara ikintu ikintu kizagira. Nyuma yibyo, urashobora gufunga idirishya ryimiterere ukanze kuri stature isanzwe mugice cyo hejuru cyiburyo.



15. Noneho kanda Kanda iburyo-mwizina ryurupapuro ruriho. Muri menu ifungura, hitamo "guhindura izina".



16. Nyuma yibyo, izina ryurupapuro rikora, kandi tuzihuze hano izina rishya "Ikibazo 1".



17. Na none, kanda kuri buto yimbeba iburyo, ariko ubu muri menu, uhagarike guhitamo kuri "kwimuka cyangwa kopi cyangwa kopi."



18. Gukoporora idirishya byatangijwe. Twashizeho amatikubiri hafi ya "Kora kopi" hanyuma ukande kuri buto "OK".



19. Nyuma yibyo, duhindura izina ryurupapuro kugirango "ikibazo 2" muburyo bumwe nkuko byakozwe. Uru rupapuro ruracyari rurimo ibikubiyemo rwose nkimpapuro zabanjirije.



20. Duhindura nimero yakazi, inyandiko, kimwe nibisubizo kuriyi mpapuro kubo dusuzuma ibikenewe.



21. Mu buryo nk'ubwo, kora no guhindura ibiri mu rupapuro "ikibazo cya 3". Gusa muri yo, kubera ko iki aricyo gikorwa cyanyuma, aho kuba izina rya "Ikibazo gikurikira", urashobora gushyira izina "kwipimisha byuzuye". Nigute wabikora bimaze kuganirwaho mbere.



22. Noneho turasubira kuri "ikibazo 1". Tugomba guhambira kuri selile yihariye. Kugirango ukore ibi, kanda iburyo-kanda kuri buri kintu. Muri menu ifungura, hitamo ikintu "imiterere yikintu ...".



23. Idirishya rishinzwe kugenzura rirakorwa. Kwimukira muri tab "kugenzura". Muri "itumanaho hamwe na Akagari", washyizeho aderesi yikintu cyose cyubusa. Umubare uzerekanwa muriyo ukurikije ibyo guhinduranya bizagira akamaro.



24. Uburyo busa bukorwa kumpapuro hamwe nindi mirimo. Kugirango byoroshye, birafuzwa ko selile ifitanye isano iri ahantu hamwe, ahubwo ni kumpapuro zitandukanye. Nyuma yibyo, tugaruka ku rupapuro "ikibazo 1" na none. Kanda iburyo kuri "Ikibazo gikurikira". Muri menu, hitamo "inkomoko yinyandiko".



25. Umuyobozi watanzwe. Hagati y "sub sp" na "iherezo rya", tugomba kwandika kode yinzibacyuho kuri tab ikurikira. Mu rubanza rwagenwe, bizasa n'iki:

    Urupapuro rwakazi ("Ikibazo 2"). Kora

    Nyuma yibyo, funga umwanditsi w'idirishya.



26. Gukoresha kimwe hamwe na buto ihuye dukora kuri "ikibazo 2". Gusa hariho itegeko rikurikira:

    Urupapuro rwakazi ("Ikibazo 3"). Kora



27. Mu gitabo cyatanzwe, "ikibazo 3" buto ya buto gukora ibyinjira bikurikira:

    Urupapuro rwakazi ("ibisubizo"). Kora



28. Nyuma yibyo, dukora urupapuro rushya rwitwa "ibisubizo". Bizerekana ibisubizo by'ibizamini. Kuri izo ntego, dukora imbonerahamwe y'inkingi enye: "Inomero y'ibibazo", "igisubizo nyacyo", "intangiriro yo gutangiza igisubizo" na "ibisubizo". Mu nkingi ya mbere ikwiranye no gutumiza umubare wimirimo "1", "2" na "3". Mu nkingi ya kabiri, ahateganye na buri murimo, andika umubare wa switch numero ijyanye nigisubizo cyukuri.



29. Muri selire ya mbere muri "Intangiriro Igisubizo" umurima, dushyira ikimenyetso "=" no kwerekana umurongo uhuza selile twahujwe na switch kuri "Ikibazo 1". Ibisanzwe bikozwe hamwe na selile hepfo, gusa kugirango bagaragaze ibisobanuro bivuga selile zijyanye na "ikibazo 2" na "ikibazo 3" impapuro.



30. Nyuma yibyo, tugaragaza ikintu cyambere cyinkingi "ibisubizo" no guhamagara imikorere yimpaka niba hariya twavuze haruguru. Muri "imvugo yumvikana", yerekana aderesi ya "yinjiye" selire yumurongo uhuye. Noneho dushyira ikimenyetso "=" hanyuma werekane ikintu gihuza inkingi "iburyo" inkingi yumurongo umwe. Mu murima "bisobanura niba ukuri" na "bisobanura niba bibeshya" andika umubare "1" na "0". Nyuma yibyo, kanda kuri buto "OK".



31. Kugirango dukoporore iyi formula kurugero hepfo, dushyira indanga kuruhande rwiburyo bwiburyo bwikintu kirimo. Muri icyo gihe, ikimenyetso cyo kuzuza uburyo bwumusaraba. Kanda kuri buto yimbeba yibumoso hanyuma ukure ikimenyetso kugeza kumpera yimeza.



32. Nyuma yibyo, kuvuga muri make ibisubizo byuzuye, dukoresha Autosumum, nkuko byari bimaze gukorwa inshuro zirenze imwe.

Kuri iki kizamini, ikizamini gishobora gufatwa nkuzuzwa. Yiteguye rwose kunyura.

Twahagaritse muburyo butandukanye kugirango dukore ikizamini ukoresheje ibikoresho byoroshye. Nibyo, iyi ntabwo ari urutonde rwuzuye rwiburyo bushoboka bwo gukora ibizamini muriyi porogaramu. Guhuza ibikoresho bitandukanye nibintu, urashobora gukora ibizamini rwose bitandukanye ukurikije imikorere. Muri icyo gihe, ntibishoboka kumenya ko mubihe byose, mugihe cyo gukora ibizamini, imikorere yumvikana ikoreshwa niba.