Nigute wubaka igishushanyo muri excel

Igikorwa kimwe gisanzwe cyimibare nukubaka gahunda yo guterwa. Yerekana kwishingikiriza kumikorere ihinduka impaka. Ku mpapuro, ubu buryo ntabwo buri gihe bworoshye. Ariko ibikoresho bitandukanye, niba dufite umutekano kubimenya, bikagufasha gukora neza uyu murimo kandi byihuse. Reka tumenye uburyo ibi bishobora gukorwa ukoresheje amakuru atandukanye.

Gushushanya Uburyo bwo kurema

Kwishingikiriza kumikorere yimpaka ni ukwishingikiriza kuri algebraic. Kenshi na kenshi, gutongana hamwe n'agaciro k'imirimo bikorwa kugirango yerekane ibimenyetso: muburyo, "x" na "y". Akenshi, birakenewe kwerekana amashusho yimpaka nimikorere yanditswe mumeza, cyangwa yerekanwe nkigice cya formula. Reka dusesengure ingero zihariye zo kubaka igishushanyo nkiki (igishushanyo) mubihe bitandukanye.

Uburyo 1: Gushiraho imbonerahamwe ishingiye kuri ecran

Mbere ya byose, tuzasesengura uburyo bwo gukora igishushanyo gishingiye kumakuru ashingiye kumeza array. Dukoresha imbonerahamwe yo kwishingikiriza inzira yagenze (Y) ku gihe (x).

1. Twerekana ameza tujya kuri tab "shyiramo". Kanda kuri buto "Gahunda", ifata imenyekanisha mu itsinda ry'imbogamizi ku kibaho. Guhitamo ubwoko butandukanye bwibishushanyo bifungura. Kubwintego zacu, hitamo byoroshye. Iherereye mbere kurutonde. Ibumba kuri yo.



2. Porogaramu ikora igishushanyo. Ariko, nkuko tubibona, imirongo ibiri irerekanwa ahantu hatubakwa, mugihe dukeneye kimwe gusa: yerekana kwishingikiriza kure buri gihe. Kubwibyo, tugenera buto yimbeba yibumoso hamwe numurongo wubururu ("igihe"), nkuko bidahuye ninshingano, hanyuma ukande urufunguzo rwo gusiba.



3. Umurongo watoranijwe uzasibwa.

Mubyukuri, kuriyi, kubaka gahunda yoroshye birashobora gusuzumwa byuzuye. Niba ubishaka, urashobora kandi guhindura amazina yimbonerahamwe, ishoka yayo, ikureho umugani kandi utange izindi mpinduka. Ibi byasobanuwe muburyo burambuye mumasomo yihariye.

Isomo: Nigute wakora gahunda muri Excel

Uburyo 2: Gukora ibikorwa bifite imirongo myinshi

Ikigereranyo kigoye cyo kwishingikiriza ni urubanza mugihe impaka imwe zihuye n'imikorere ibiri icyarimwe. Muri iki gihe, uzakenera kubaka imirongo ibiri. Kurugero, fata ameza aho amafaranga rusange yimihango hamwe ninyungu zayo zirashushanyije.

1. Turagaragaza ameza yose hamwe na cap.



2. Nko mu rubanza rwabanje, tukanda kuri buto "gahunda" mugice c'imbogamiye. Na none, hitamo amahitamo yambere yerekanwe kurutonde rufungura.



3. Porogaramu itanga ibitekerezo bishushanyije ukurikije amakuru yabonetse. Ariko, nkuko tubibona, muriki gihe, ntabwo twavuga gusa umurongo wa gatatu urenze, ahubwo twandika kuri axis ya horizontal ya horiates ntabwo ihuye nabasabwa, aribyo gahunda yumwaka.

   Guhita usiba umurongo urenze. Niwe mu buryo bwonyine kuri iki gishushanyo - "umwaka." Nko muburyo bwabanje, turagaragaza gukanda kuri yo hamwe nimbeba hanyuma ukande kuri buto yo gusiba.



4. Umurongo wakuweho kandi hamwe nawo, nkuko ubibona, indangagaciro kumurongo uhagaze uhagaze. Barushijeho kuba barasobanutse. Ariko ikibazo cyo kwerekana nabi cya horizontal ya horizontal yo guhuza ibisigaye. Kugirango ukemure iki kibazo, kanda kumurima wo kubaka buto yimbeba iburyo. Muri menu, ugomba guhagarika guhitamo "Hitamo amakuru ...".



5. Idirishya ryo gutoranya inkomoko rifungura. Muri "Umukono wa Axis ya Horizontal" blok, kanda buto "Hindura".



6. Idirishya rifungura ndetse no munsi ya mbere. Muri yo, ugomba kwerekana agahuza kumeza yizo ndangagaciro zigomba kugaragara kuri axis. Kuri ibyo, shiraho indanga kumurima wonyine wiyi idirishya. Noneho mfashe buto yimbeba yibumoso hanyuma ntoranya ibintu byose byinkingi yumwaka, usibye izina ryayo. Aderesi izahita igira ingaruka kumurima, kanda "OK".



7. Gusubira mumadirishya yo gutoranya amakuru, nawe kanda "OK".



8. Nyuma yibyo, ibishushanyo byombi byashyizwe ku rupapuro birerekanwa neza.

Uburyo 3: Kubaka ibishushanyo mugihe ukoresheje ibice bitandukanye byo gupima

Mu buryo bwabanje, twasuzumye kubaka igishushanyo n'imirongo myinshi ku ndege imwe, ariko imirimo yose yari ifite ibice bimwe (ingano ibihumbi). Nakora iki niba ukeneye gukora gahunda yo kwishingikiriza ukurikije ameza imwe, aho ibice byurwego rupima gitandukanye? Excel ifite ibisohoka no guhera kuriyi myanya.

Dufite ameza, atanga amakuru ku bwinshi bwo kugurisha ibicuruzwa bimwe na bimwe muri toni no kwinjiza mu bikorwa byacyo mu bihumbi.

1. Nko mubihe byabanjirije, tugenera amakuru yose yimbonerahamwe hamwe na cap.



2. Ibumba kuri buto "Gahunda". Twongeye guhitamo uburyo bwa mbere bwo kubaka kurutonde.



3. Urutonde rwibintu bishushanyije bishyirwaho ahantu zubakwa. Muri ubwo buryo, bwasobanuwe muri verisiyo zabanjirije iyi, dukuraho umwaka umwe "umwaka.



4. Nko mu buryo bwabanje, dukwiye kwerekana umwaka kuri horizontal ya horizontal. Kanda ahabigenewe no kurutonde rwibikorwa, hitamo Ihitamo "Hitamo amakuru ...".



5. Mu idirishya rishya, utanga gukanda kuri buto "Hindura" muri "Umukono" wa horizontal axis.



6. Mu idirishya ritaha, ritanga ibikorwa bimwe byasobanuwe muburyo burambuye muburyo bwambere, tumenyekanisha imirongo yumurwa winkingi mukarere ka Axis Umukono. Kanda kuri "OK".



7. Iyo ugarutse kumadirishya yabanjirije, nawe ukora kanda kuri buto ya "OK".



8. Noneho dukwiye gukemura ikibazo batuyeho mubihe byabanjirije kubaka, aribyo, ikibazo cyo kudahuza ibice. N'ubundi kandi, uzemeranya, ntibashobora kuba mu gice kimwe cyo guhuza igice, icyarimwe cyerekana umubare w'amafaranga (ingano y'ibihumbi) na misa (toni). Kugira ngo iki kibazo gikemuke, tuzakenera kubaka inyongera yinyongera ya coordinate.

   Kuri twe, kugena amafaranga yinjira, tuzasiga umurongo uhagaze umaze kubaho, kandi kubusambanyi "bizakora ubumuga. Ibumba kuri uyu murongo iburyo wimbeba hanyuma uhitemo kurutonde "imiterere yamakuru menshi ...".



9. Idirishya ryimodoka ryatangijwe. Tugomba kwimukira mu gice cya "Ibipimo", niba byafunguye mu kindi gice. Kuruhande rwiburyo bwidirishya hari inkomoko "yubaka umurongo". Ugomba kwinjiza kumwanya "ukoresheje AXILS AXIS". Ibumba ryizina "hafi".



10. Nyuma yibyo, umurongo uhagaritse uhagaritse, kandi umurongo wo kugurisha uzashyirwa mubikorwa. Rero, kora kumurimo urangiye.

Uburyo 4: Gukora igishushanyo mbonera gishingiye kumikorere ya algebraic

Noneho reka dusuzume uburyo bwo kubaka gahunda yo guterwa izashyirwaho nimikorere ya algebraic.

Dufite imikorere ikurikira: Y = 3x ^ 2 + 2x-15. Ukurikije, birakenewe kubaka igishushanyo cyo kwishingikiriza ku ndangagaciro za Y kuva X.

1. Mbere yo gukomeza kubaka igishushanyo, tuzakenera gukora imbonerahamwe ishingiye kumikorere yagenwe. Indangagaciro zimpaka (x) mumeza yacu zizashyirwa kurutonde kuva -15 kugeza kuri + 30 kugeza kuri + inzira yo gutangiza amakuru, kwihutisha ikoreshwa ryigikoresho cya "Iterambere".

   Twerekana muri selire ya mbere yinkingi "x" agaciro "-15" no kugenera. Muri tab "urugo", ibumba kuri buto "ryuzuye" riri mu gice cyo guhindura. Kurutonde, hitamo "Iterambere ...".



2. Gukora idirishya "Iterambere" rirakorwa. Muri "Ahantu", andika izina "ku nkingi", kubera ko dukeneye kuzuza neza inkingi. Mu itsinda rya "Ubwoko", va Agaciro "imibare", bishyirwaho nibisanzwe. Mu gace "intambwe", shyira agaciro "3". Mu gaciro ntarengwa, twashizeho umubare "30". Kora gukanda kuri "ok".



3. Nyuma yo gukora iyi algorithm yibikorwa, inkingi yose "X" izaba yuzuye indangagaciro ukurikije gahunda yerekanwe.



4. Noneho dukeneye gushyira indangagaciro za Y byahuye nindangagaciro zimwe na rimwe X. Noneho, twibuka ko dufite formula y = 3x ^ 2 + 2x-15. Birakenewe kuyihindura extl formula, aho x indangagaciro zizasimburwa nibisobanuro bigana ingirabuzimafatizo zirimo ingingo zijyanye.

   Hitamo selile yambere muri "y". Urebye ko kuri twe, aderesi yimpaka za mbere X ihagarariwe na A2 ihuriro rya A2, noneho aho kuba formula hejuru, tubona imvugo nkiyi:

   = 3 * (a2 ^ 2) + 2 * A2-15

   Twanditse iyi mvugo muri selire ya mbere ya "Y". Kugirango ubone ibisubizo byo kubara, kanda urufunguzo rwa Enter.



5. Igisubizo cyimikorere kubwimpaka yambere ya formula yateguwe. Ariko dukeneye kubara indangagaciro zayo kubindi bitekerezo. Injira formula kuri buri gaciro y umwuga muremure kandi muremure. Byihuta cyane kandi byoroshye kuyigana. Iki gikorwa kirashobora gukemurwa ukoresheje ikimenyetso cyuzuye kandi ukabikesha uyu mutungo wibisobanuro byoroshye, nkubwinshi bwabo. Iyo ukoporora formula mubindi r iringaniza y, x indangagaciro za x zizahita zihindura ugereranije nabami bakomeye.

   Twitwaje indanga kuruhande rwiburyo bwiburyo bwibintu formula yanditswe. Muri icyo gihe, guhinduka bigomba kubaho kuri indanga. Bizahinduka umusaraba wumukara utwara izina ryuzuye ikimenyetso. Kanda buto yimbeba hanyuma ufate iki kimenyetso kumupaka wo hasi wimeza muri "Y".



6. Igikorwa cyavuzwe haruguru cyateje ukuri ko "y" yuzuyemo rwose ibisubizo byo kubara formula y = 3x ^ 2 + 2x-15.



7. Noneho igihe kirageze cyo kubaka igishushanyo ubwacyo. Hitamo amakuru yose. Na none muri "Shyiramo", kanda ahanditse "imbonerahamwe" yitsinda ". Muri iki kibazo, reka duhite kurutonde rwamahitamo "gahunda hamwe nibimenyetso".



8. Imbonerahamwe n'ibimenyetso bizerekanwa ahantu zubakwa. Ariko, nko mu manza zibanziriza iki, tuzakenera kugira icyo mpindura kugirango tubone isura iboneye.



9. Mbere ya byose, turasiba umurongo "X", uherereye mu buryo butambitse kuri salakeri 0. Turimo gutanga iki kintu hanyuma ukande kuri buto yo gusiba.



10. Ntabwo dukeneye kandi umugani, kubera ko dufite umurongo umwe gusa ("y"). Kubwibyo, duharanira umugani kandi ukande urufunguzo rwo gusiba.



11. Noneho dukeneye gusimburwa muri horinental ihuriweho na horizontal ya horizontal kubandi bahuye na "x" inkingi yinkingi.

    Buto yimbeba iburyo yerekana umurongo wigishushanyo. Himura "Hitamo amakuru ..." muri menu.



12. Mu idirishya rikora ryisanduku yo gutoranya inkomoko, "Guhindura" bimaze kumenyera, giherereye mu "Umukono wa Horizontal".



13. Idirishya ryashyizwe ahagaragara "Idirishya ryatangijwe. Mubuso bwurwego rwumukono wa Axis, twerekana umurongo uhuza amakuru ya "X". Dushyira indanga mu muriro wo mu murima, hanyuma tukabyara clamp isabwa na buto y'imbeba y'ibumoso, hitamo indangagaciro zose z'inkingi y'imbonerahamwe, ukuyemo izina ryayo gusa. Imirongo imaze kugaragara mumurima, ibumba ryibumba "OK".



14. Gusubira kuri Data Guhitamo Inkomoko yindege, ibumba kuri buto "OK" muri yo, nkaba mbere yuko bakora mumadirishya yabanjirije.



15. Nyuma yibyo, porogaramu izahindura imbonerahamwe yubatswe ukurikije impinduka zakozwe mu igenamiterere. Igishushanyo cyo kwishingikiriza hashingiwe kumirimo ya algebraic irashobora gufatwa nkiherezo.

Isomo: Nigute ushobora gukora Autoplete muri Microsoft Excel

Nkuko mubibona, ukoresheje gahunda ya Excel, uburyo bwo kubaka uruzinduko bworoheje ugereranije no kurema kumpapuro. Ibisubizo byubwubatsi birashobora gukoreshwa haba mumahugurwa kandi muburyo bufatika. Igereranya ryihariye riterwa niki gishingiye ku gishushanyo: indangagaciro cyangwa imikorere. Mu rubanza rwa kabiri, mbere yo kubaka igishushanyo, ugomba gukora ameza hamwe n'impaka n'indangagaciro z'imikorere. Byongeye kandi, gahunda irashobora kubakwa nkuko ishingiye kumikorere imwe na byinshi.