Nigute wubaka igishushanyo cyimikorere muri excel

Ihitamo 1: imikorere igishushanyo x ^ 2

Nkurugero rwambere kuri excel, dusuzuma imikorere izwi cyane f (x) = x ^ 2. Ingengabihe kuva muri iki gikorwa mubihe byinshi igomba kuba ikubiyemo ingingo tuyishyira mubikorwa mugihe zakozwe mugihe kizaza, ariko kuri ubu tuzasesengura ibice byingenzi.

1. Kora umurongo x, aho ugaragaza urwego rwifuzwa kubishushanyo mbonera.



2. Hasi kora kimwe na Y, ariko urashobora gukora utabaze intoki indangagaciro zose, usibye ko bizaba byoroshye niba bitagaragara niba bikenewe.



3. Kanda kuri selile ya mbere hanyuma winjire = B1 ^ 2, bivuze ko ubwuzuzanya bwikora bwa selile yerekanwe.



4. Rambura imikorere ufashe iburyo bwo hepfo ya selire, hanyuma uhe ameza kubwoko bwerekanwe mumashusho akurikira.



5. Urutonde rwamakuru yo kubaka imikorere yimikorere irasobanuwe, bivuze ko ushobora kubigaragaza ukajya kumurongo wa "Shyiramo".



6. Kuri yo guhita ukande kuri buto "isabwa.



7. Mu idirishya rishya, jya kuri "imbonerahamwe zose" hanyuma ubone "ahantu" kurutonde.



8. Ihitamo "Ahantu hamwe n'imirongo yoroshye n'ibimenyetso" birakwiriye.



9. Nyuma yo gushiramo kumeza, nyamuneka menya ko yongeyeho indangagaciro zingana kandi nziza kugirango uhagararire parabola.



10. Noneho urashobora guhindura izina ryigishushanyo hanyuma urebe neza ko ibimenyetso byindangagaciro bigaragazwa kuko bikenewe kugirango ibindi bisobanuro niyi gahunda.



11. Y'ibintu byinyongera, tubona ko kwanduka no kwimura gahunda kubanditsi bose banditse. Kugirango ukore ibi, kanda ahabigenewe PCM kandi uhereye kuri menu, hitamo "kopi".



12. Fungura urupapuro mumyandikire yakoreshejwe hanyuma ushiremo igishushanyo ukoresheje menu imwe cyangwa ukoreshe Ctrl + v urufunguzo rushyushye.

Niba gahunda igomba kuba ingingo, ariko imikorere ntabwo ihuye neza, kora neza muburyo bumwe ushiraho ibisabwa mumeza kugirango woroshye kandi byoroshya inzira yose yo gukorana namakuru.

IHitamo 2: Imikorere ya Y = Icyaha (x)

Imikorere ni nyinshi kandi iseswa mu rwego rw'iyi ngingo ntizishoboka, ku buryo ubundi buryo bwo kuri verisiyo ibanza, turasaba kuguma ku bundi bukunzwe, ariko igoye - y = icyaha (x). Ni ukuvuga, ubanza hariho indangagaciro x, ni ngombwa kubara sinus, zizabana na Y. Ibi kandi bizafasha kandi kumeza yakorewe, uhereye nyuma kandi wubake gahunda yimikorere.

1. Kugirango byoroshye, vuga amakuru yose akenewe kurupapuro muri Excel. Bizaba icyaha (x) ubwabwo, intera yindangagaciro kuva -1 kugeza 5 nintambwe yabo iraremereye kuri 0.25.



2. Kora inkingi ebyiri icyarimwe - x na y, aho uzandika amakuru.



3. Andika indangagaciro ebyiri cyangwa eshatu nintambwe yagenwe.



4. Ibikurikira, kurambura inkingi hamwe na x nkuko bisanzwe urambura imikorere kugirango utuzuze buri ntambwe.



5. Jya kuri Y inkingi hanyuma utangaze The = imikorere yicyaha (, na numero, vuga agaciro ka mbere x.
6. Imikorere ubwayo ihita ibarura sinus yumubare wagenwe.
7. Rambura inkingi kimwe nkuko bigaragara mbere.



8. Niba umubare nyuma yuko koma ari ndende cyane, mugabanye gato, ukanda buto ijyanye inshuro nyinshi.



9. Hitamo inkingi hamwe na y hanyuma ujye kuri tab "shyiramo".



10. Kora gahunda isanzwe uhindura ibimanuka.



11. Igishushanyo cyimikorere kuva Y = Icyaha (x) cyubatswe neza kandi kigaragara neza. Hindura izina ryayo kandi ugaragaze intambwe zoroshye yo gusobanukirwa.