Nigute ushobora gukora igishushanyo muri excel

Gahunda igufasha kumenya neza kwishingikiriza kubipimo bimwe mubipimo bimwe cyangwa imbaraga zabo. Ibi bintu bikoreshwa mubikorwa bya siyansi cyangwa ubushakashatsi, kandi mubiganiro. Reka turebe uko twubaka igishushanyo muri Microsoft Excel.

Kurema ibishushanyo muri Excel

Buri mukoresha, wifuza cyane kwerekana neza amakuru yose muburyo bwabavuga, arashobora gukora gahunda. Iyi nzira iraroroshye kandi yerekana ko hari ameza azakoreshwa kuri base base. Ku bushishozi bwayo, ikintu gishobora guhinduka kugirango kimeze neza kandi gisubize ibisabwa byose. Tuzasesengura uburyo bwo gukora ubwoko butandukanye bwibishushanyo muri excel.

Kubaka gahunda isanzwe

Urashobora gushushanya gahunda muri excel gusa nyuma yuko ameza yiteguye kumakuru ashingiyeho.

1. Kuba kuri tab "shyiramo", kugenera agace kameza aho amakuru yabazwe dushaka kubona mu mbonerahamwe. Noneho kuri kaseti mugikoresho cya "Igishushanyo" cyahagaritswe ukanze kuri buto "Gahunda".
2. Nyuma yibyo, hari urutonde ubwoko burindwi bwishusho buhagarariwe:
   • Ibisanzwe;
   • Hamwe no kwigunga;
   • Kuzenguruka hamwe no kwigunga;
   • Hamwe n'ibimenyetso;
   • Hamwe n'ibimenyetso no kwegeranya;
   • Bisanzwe hamwe n'ibimenyetso no kwigurika;
   • Ingano.

   Hitamo imwe igitekerezo cyawe gikwiriye cyane kubwintego yihariye yo kubaka.



3. Ibindi bikora excel ikora mu buryo butaziguye gahunda.

Guhindura ibishushanyo

Nyuma yo kubaka igishushanyo, urashobora kubikora kugirango uhindure kugirango utange ikintu ubwoko bwerekana kandi koroshya gusobanukirwa ibikoresho byerekana.

1. Gusinya gahunda, jya kuri "imiterere" ya wizard yakazi hamwe nimbonerahamwe. Kanda kuri buto kuri lebon hamwe nizina "imbonerahamwe y'imbonerahamwe". Kurutonde rufungura, turagaragaza aho izina rizaba rizaba: Hagati cyangwa hejuru ya gahunda. Ihitamo rya kabiri mubisanzwe rikwiye, niko dukoresha "hejuru yigishushanyo" nkurugero. Nkigisubizo, izina rigaragara, rishobora gusimburwa cyangwa ryahinduwe mubushishozi bwarwo, gusa ukanze kuri yo no kwinjiramo byifuzwa muri clavier.



2. Urashobora kwerekana izina ryishoka ukanze kuri "axis izina". Mu rutonde rwamanutse, hitamo ikintu "izina rya horizontal axis", hanyuma ujye kumwanya "izina munsi ya axis".



3. Munsi ya axis hariho ifishi yizina umuntu wese ashobora gukoreshwa mubushishozi bwayo.



4. Mu buryo nk'ubwo, dusinya axis. Kanda kuri "Izina rya AXIS", ariko muri menu igaragara, hitamo "izina rya axis yingenzi". Urutonde rwibibanza bitatu byo gusinya bizafungura: kuzunguruka, guhagarikwa, horizontal. Nibyiza gukoresha izina rizunguruka, nkuko biri muriki gihe habitswe kurupapuro.



5. Ku rupapuro hafi ya Axis ihuye, umurima ugaragaramo ushobora kwinjiza izina ribereye ukurikije amakuru aherereye.



6. Niba utekereza ko kugirango wumve gahunda yumugani ntabwo ikenewe kandi ibera gusa, urashobora kuyisiba. Kanda kuri Button ya Legend, uherereye kuri kaseti, hanyuma uko uhitamo "Oya". Ako kanya, urashobora guhitamo umwanya uwo ariwo wose wumugani, niba utabisibye, ahubwo uhindure ahantu.

Kubaka ingengabihe hamwe na axle ifasha

Hariho ibibazo mugihe ukeneye gushyira ibishushanyo byinshi ku ndege imwe. Niba bafite ingamba zimwe zibara, ibi bikorwa muburyo bumwe nkuko byasobanuwe haruguru. Ariko tuvuge iki niba hari ingamba zitandukanye?

1. Kuba kuri tab "shyiramo", nkigihe cyanyuma, garagaza indangagaciro zameza. Ibikurikira, twongeyeho buto "Gahunda" hanyuma duhitemo amahitamo akwiye.



2. Nkuko tubibona, hashyizweho ibishushanyo bibiri. Kugirango werekane izina ryukuri ryibipimo byo gupima kuri buri gahunda, ukande buto yimbeba iburyo kuruhande rumwe tugiye kongeramo umurongo winyongera. Muri menu igaragara, igaragaza ikintu "imiterere yamakuru menshi".



3. Idirishya ryimodoka ryatangijwe. Mu gice cyacyo "umurongo wumurongo", ugomba gufungura kubisanzwe, ongera utegure uhindure kuri "Axiliary Axis". Kanda ahanditse "gufunga".



4. Imirongo mishya ikorwa, kandi gahunda izakumira.



5. Tugomba gusinya umurongo nizina ryigishushanyo kuri algorithm isa nurugero rwabanje. Niba hari ibishushanyo bimwe, umugani nibyiza kutazasukura.

Kubaka imikorere

Noneho reka tumenye uburyo bwo kubaka imbonerahamwe kumikorere runaka.

1. Dufate ko dufite imikorere y = x ^ 2-2. Intambwe izaba ingana na 2. Tubanza kubaka ameza. Mu gice cyibumoso, kuzuza agaciro ka x mu ntambwe ya 2, ni ukuvuga 2, 4, 4, 6, 8, 10, nibindi. Mu gice gikwiye dutwara formula.



2. Ibikurikira, tuzana indanga kuruhande rwiburyo bwiburyo bwa selile, kanda buto yimbeba yibumoso kandi "kurambura" hepfo yimeza, bityo ukoporora formula mubindi bigo.



3. Noneho jya kuri tab "shyiramo". Hitamo tablet amakuru hanyuma ukande kuri buto "yerekana igishushanyo" kuri kaseti. Kuva kurutonde rwatanzwe rwa diagrams, hitamo ingingo hamwe nimirongo yoroshye nibimenyetso, nkuko ubu bwoko bubereye inyubako.



4. Ibishushanyo bishingiye kuri.



5. Ikintu kimaze kubakwa, urashobora gukuramo umugani ugakora ibyatsi biboneka bimaze kuganirwaho hejuru.

Nkuko mubibona, Microsoft Excel itanga ubushobozi bwo kubaka ubwoko butandukanye bwibishushanyo. Imiterere nyamukuru kuri iyi ni kurema ameza namakuru. Gahunda yashizweho irashobora guhinduka no gukosorwa ukurikije intego igenewe.