Pangani mawonekedwe mu Microsoft Excel

Ntchito yomanga ndi imodzi mwa machitidwe odziwa masamu. Kaŵirikaŵiri amagwiritsidwa ntchito osati pazinthu za sayansi, komanso chifukwa cha zenizeni. Tiyeni tiphunzire momwe tingachitire njirayi pogwiritsira ntchito bukhuli la Excel.

Kupanga Parabola

Parabola ndi graph ya quadratic ntchito ya mtundu wotsatira f (x) = nkhonya ^ 2 + bx + c. Chimodzi mwa zida zake zodabwitsa ndizokuti pulogalamuyo ili ndi mawonekedwe ofanana kwambiri omwe ali ndi mfundo zofanana ndi mutu wa mutu. Kawirikawiri, kumanga chiwonetsero ku Excel chilengedwe sikunali kosiyana kwambiri ndi zomangamanga zina zilizonse pulogalamuyi.

Kulengedwa kwazithunzi

Choyamba, musanayambe kupanga fanizo, muyenera kumanga tebulo pamaziko omwe adzalengedwera. Mwachitsanzo, tiyeni titenge ntchito yolinganiza f (x) = 2x ^ 2 + 7.

1. Lembani tebulo ndi mfundo x kuchokera -10 mpaka 10 mu masitepe 1. Izi zikhoza kuchitidwa pamanja, koma ndi zophweka kuti zolingazi zigwiritse ntchito zipangizo zowonjezera. Kuti muchite izi, mu selo yoyamba ya chigawocho "X" lowetsani mtengo "-10". Ndiye, popanda kuchotsa kusankha mu selo ili, pitani ku tab "Kunyumba". Kumeneko timangodutsa pa batani "Kupitirira"zomwe zimagwidwa mu gulu Kusintha. Mu mndandanda wochitidwa, sankhani malo "Kupita patsogolo ...".



2. Imathandizira zowonjezera zowonjezera zenera. Mu chipika "Malo" ayenera kusuntha batani ku malo "Ndi ndondomeko"monga mzere "X" Ili pambaliyi, ngakhale kuti nthawi zina zingakhale zofunikira kuyika kasinthasintha "M'mizere". Mu chipika Lembani " musiye kusinthana pa malo "Masamu".

   Kumunda "Khwerero" lowetsani nambalayi "1". Kumunda "Pezani mtengo" tchulani nambalayi "10"popeza tikuwona zosiyana x kuchokera -10 mpaka 10 kuphatikizapo. Kenaka dinani pa batani. "Chabwino".



3. Zitatha izi, mzere wonsewo "X" tidzadzazidwa ndi deta yomwe tikusowa, yomwe ndi nambalayi -10 mpaka 10 mu masitepe 1.



4. Tsopano tikuyenera kudzaza gawo la deta "f (x)". Kuti muchite izi, pogwiritsa ntchito equation (f (x) = 2x ^ 2 + 7), tifunika kuika mawu mu selo yoyamba ya ndimeyi molingana ndi ndondomeko zotsatirazi:

   = 2 * x ^ 2 + 7

   Kokha mmalo mwa mtengo x lowetsani adiresi ya selo yoyamba ya chigawocho "X"zomwe tangomaliza kumene. Choncho, kwa ife, mawuwa akutenga mawonekedwe:

   = 2 * A2 ^ 2 + 7



5. Tsopano tifunika kufotokoza ndondomekoyi ndizomwe zili m'munsimu. Chifukwa cha zofunikira za Excel, pamene mukujambula zonse x adzaikidwa m'maselo oyenera a m'mbali "f (x)" mwadzidzidzi. Kuti muchite izi, ikani cholozeracho kumbali ya kumanja ya selo, momwe malemba omwe talembera kale kale adayikidwa kale. Chotsegulacho chiyenera kutembenuzidwa kukhala chizindikiro chodzaza chomwe chikuwoneka ngati mtanda wawung'ono. Pambuyo kusinthika kwachitika, timagwiritsa ntchito batani lamanzere ndikukweza thumba mpaka kumapeto kwa tebulo, kenako kumasula batani.



6. Monga mukuonera, mutatha gawoli "f (x)" adzadzadwanso.

Pogwiritsa ntchito tebuloyi mukhoza kulingalira mozama ndikupitiriza kukonza dongosolo.

Phunziro: Momwe mungapangire autocomplete mu Excel

Plotting

Monga tanena kale, tsopano tikuyenera kumanga ndandanda yokha.

1. Sankhani tebulo ndi chithunzithunzi mwa kugwira batani lamanzere. Pitani ku tabu "Ikani". Pa tepi mu chipika "Zolemba" dinani pa batani "Malo", chifukwa ndi mtundu uwu wa graph umene umathandiza kwambiri kupanga chithunzi. Koma sizo zonse. Pambuyo pakakani pa batani pamwambapa, mndandanda wa mitundu yobalalitsira yawotchi imatsegulidwa. Sankhani tchati chobalalika ndi zizindikiro.



2. Monga mukuonera, pambuyo pa zochitikazi, fanizoli lakumangidwa.

Phunziro: Momwe mungapangire chithunzi mu Excel

Kusintha kwa Tchati

Tsopano mukhoza kusintha pang'ono graph.

1. Ngati simukufuna kuti pulogalamuyi iwonetsedwe ngati zizindikiro, koma kuti mukhale ndi maonekedwe odziwika bwino a mzere wokhotakhota womwe umagwirizanitsa mfundo izi, dinani pa aliyense wa iwo ndi batani labwino la mouse. Mndandanda wamakono umatsegulidwa. Muli, muyenera kusankha chinthucho "Sinthani mtundu wa chithunzi cha mzere ...".



2. Mndandanda wa tchati wosankha mawindo umatsegulira. Sankhani dzina "Dot ndi miyala yosalala ndi makina". Mutatha kusankha, dinani pa batani. "Chabwino".



3. Tsopano tchati yowonetsera ili ndi mawonekedwe odziwika bwino.

Kuphatikizanso apo, mukhoza kupanga mitundu ina yosinthira zotsatirazi, kuphatikizapo kusintha dzina lake ndi mayina ake. Njira zosinthira izi sizidutsa malire a zochita zogwira ntchito ku Excel ndi zithunzi za mitundu ina.

Phunziro: Momwe mungasayire tchati chachitsulo mu Excel

Monga mukuonera, zomangamanga za Excel sizisiyana kwenikweni ndi kumanga mtundu wina wa graph kapena chithunzi pulogalamu yomweyo. Zochita zonse zimapangidwa pamaziko a tebulo lisanayambe. Kuonjezerapo, tiyenera kukumbukira kuti malingaliro a chithunzichi ndi abwino kwambiri pomanga fanizo.