Ntchito yomanga parabola ndi imodzi mwamisonkhano yodziwika bwino ya masamu. Nthawi zambiri zimagwira ntchito chabe chifukwa cha sayansi, komanso mothandiza. Tiyeni tiwone momwe mungapangire njirayi pogwiritsa ntchito Chida cha Excel Product.
Kulengedwa kwa Parabola
Parabola ndi chithunzi cha njira yotsatira ya mtundu wotsatira f (x) = nkhwangwa ... 2 + BX + C . Chimodzi mwazinthu zodziwika bwino ndikuti parabola ali ndi mawonekedwe a chithunzi chofanana ndi mfundo zofananira ndi wotsogolera. Kupitilira, ntchito yomanga parabola mu chilengedwe cha Excel siyosiyana kwambiri ndi kumanga gawo lina lililonse lomwe likuchitika mu pulogalamuyi.Kupanga tebulo
Choyamba, musanayambe kumanga parabola, muyenera kupanga tebulo pamaziko omwe idzapangidwa. Mwachitsanzo, tengani chithunzi cha ntchito ya ntchito f (x) = 2x ^ 2 + 7.
- Dzazani tebulo ndi mfundo za X mpaka 10 mu Gawo 1. Izi zitha kuchitika pamanja, koma zosavuta kuti zolinga izi zizigwiritsa ntchito zida zotsatila. Kuti muchite izi, m'chipinda choyambirira cha mzati "X" timalowa mtengo "-10". Kenako, popanda kuchotsa kusankha kwa chipinda ichi, pitani ku "kunyumba". Dinani batani la "Kudutsa", komwe kwalembedwa m'gulu la Kukonza. M'ndandanda wokhazikitsidwa, sankhani malo oti "Kupita patsogolo ...".
- Kuyambitsa pawindo lazolowera kumathandizira. Mu "Malo" block, batani liyenera kukhazikitsidwanso ndi udindo ", chifukwa mndandanda wake" X "umasankhidwa kukhala wosinthira ku" mizere " udindo. Mu "Mtundu" block, siyani kusinthaku ku Arithmetic.
Mu "gawo", timalowa chiwerengerocho "1". Mu "malire mtengo", sonyezani nambala yakuti "10", monga momwe timaganizira za x kuchokera ku -10 mpaka 10. Kenako dinani batani la "OK".
- Pambuyo pa izi, mzati wonse "X" idzadzaza ndi zomwe tikufuna, ndizachiwerengerocho, ziwerengerozizo kuchokera -10 mpaka 10 zikuwonjezera 1.
- Tsopano tiyenera kudzaza nambala ya "F (x)". Kuti muchite izi, kutengera equation (F (x) = 2x ^ 2 + 7), tiyenera kulowa m'mawu pa mtundu wotsatira wa mzerewu
= 2 * x ^ 2 + 7
M'malo mwa mtengo wa X timaloweza adilesi ya selo yoyamba ya "X", yomwe tangodza. Chifukwa chake, kwa ife, mawuwo adzapanga mawonekedwe:
= 2 * A2 ^ 2 + 7
- Tsopano tikufunika kukopera formula ndi gawo lonse lamphepete. Popeza malo owonjezera a Excel, potengera njira zonse x adzaperekedwa ku cell column ya v (F (x) "zokha. Kuti tichite izi, timayika cholembera kumanzere kwa khungu, momwe formula yaikidwa kale, yolembedwa ndi ife kale. Cursor iyenera kusinthidwa kukhala cholembera, ndikuwoneka kwa mtanda waung'ono. Kutembenuka kwachitika, kutsitsa batani lamanzere la mbewa ndikukoka cholembera mpaka kumapeto kwa tebulo, ndiye kuti musunge batani.
- Monga mukuwonera, zitatha izi, mzatiyo "F (X)" adzazidwanso.
Pa mapangidwe awa, tebulo limatha kuganiziridwa kuti litamalizidwa ndikuyenda mwachindunji pantchito yomanga dongosolo.
Phunziro: Momwe Mungapangire Autocomple
Zithunzi Zomanga
Monga tafotokozera kale pamwambapa, tsopano tiyenera kupanga dongosolo.
- Sankhani tebulo ndi chotemberera pogwira batani lakumanzere. Lowani mu "kuyika" tabu. Pa tepi mu "Tchati Chotseka" dinani batani la "Spot", chifukwa ndi chithunzi choyenera kwambiri pakumanga parabola. Koma si zonse. Pambuyo podina batani pamwambapa, mndandanda wa ma cookigrams otseguka. Sankhani chithunzi cholembera ndi zikwangwani.
- Monga momwe tikuonera izi, parabola amangidwa.
Phunziro: Momwe Mungapangire tchati
Kusintha tchati
Tsopano mutha kusintha ndandanda yotsatira.
- Ngati simukufuna parabolala kuti muwonetsedwe m'njira, ndipo panali malo odziwika bwino a mzerewo, womwe umalumikiza mfundozi, dinani pa aliyense wa iwo akunja. Mndandanda wa nkhaniyo umatseguka. M'malo mwake muyenera kusankha chinthucho "Sinthani mtundu wa chithunzi cha mzere ...".
- Zenera losankha zenera limatseguka. Sankhani dzinalo "malo okhala ndi ma curves osalala komanso olemba." Pambuyo kusankha kupangidwa, dinani batani la "OK".
- Tsopano tchati cha parabolala limakhala lodziwika bwino.
Kuphatikiza apo, mutha kupanga mitundu ina iliyonse yosinthira Parabola, kuphatikizapo kusintha m'matchulidwe ake ndi mayina a nkhwangwa. Olandila awa sadutsa malire azomwe amagwira ntchito ku Excel ndi zojambula zamtundu wina.
Phunziro: Momwe mungasainire axis ya tchati mu Excel
Monga mukuwonera, kupanga parabola ku Excel si kosiyana kwenikweni si kosiyana ndi mtundu wina wa graph kapena tcha mu pulogalamu yomweyo. Zochita zonse zimapangidwa kutengera tebulo lokonzedweratu. Kuphatikiza apo, ndikofunikira kulingalira kuti tchati cha tchati ndichoyenera kwambiri kumanga parabola.