Kugwiritsa ntchito tabu mu Microsoft Excel

Kulemba ntchito ndi kuwerengera kwa ntchito yofunikira pa mfundo iliyonse yogwirizana ndi gawo linalake, m'malire omveka bwino. Njirayi ndi chida chothana ndi mavuto ambiri. Ndi thandizo lake, mutha kudziwa momwe mizu ya equation ilili, kupeza mayikidwe ndi kuchepera, ndikuthana ndi mavuto ena. Kugwiritsa ntchito Excel ndikosavuta kutulutsa kuposa kugwiritsa ntchito pepala, cholembera, komanso chowerengera. Tiyeni tiwone momwe izi zimachitikira polemba izi.

Kugwiritsa ntchito Ma Tab

Kutulutsa kumayikidwa pakapanga tebulo pomwe phindu la mkangano ndi gawo lomwe lasankhidwa lidzalembedwapo mzere umodzi, ndipo phindu lolumikizana nalo mu gawo lachiwiri. Kenako, kutengera kuwerengera, mutha kupanga graph. Onani momwe izi zimachitikira ndi chitsanzo chapadera.

Kulenga kwa tebulo

Pangani mutu wa tebulo ndi mizati xzomwe zikuwonetsa kufunikira kwa mkanganowu, ndipo f (x)momwe ntchito yofananira ikuwonetsedwa. Mwachitsanzo, tengani ntchito f (x) = x ^ 2 + 2xngakhale tabu ntchito yamtundu uliwonse ikhoza kugwiritsidwa ntchito. Khazikitsani khwerero (h) kuchuluka kwa 2. Malire ochokera -10 kale 10. Tsopano tikuyenera kudzaza mzere wotsatirana, kutsatira sitepe 2 mkati mwa malire.

1. Mu cell yoyamba ya mzati x lowetsani mtengo wake "-10". Pambuyo pake, dinani batani Lowani. Izi ndizofunikira kwambiri, chifukwa mukayesa kulakwitsa mbewa, phindu lomwe lili mu cell lidzasinthidwa, ndipo pankhaniyi sikofunikira.



2. Makhalidwe ena onse amatha kudzazidwa pamanja, kutsatira sitepe 2, koma ndikosavuta kuchita izi pogwiritsa ntchito chida chodzaza nokha. Kusankha kumeneku ndikofunikira makamaka ngati kuchuluka kwa kutsutsana kuli kwakukulu ndipo sitepe ndiyochepa.

   Sankhani khungu lomwe lili ndi phindu la mfundo yoyamba. Kukhala mu tabu "Pofikira"dinani batani Dzazani, yomwe ili pa riboni mumazenera block "Kusintha". Pamndandanda wazinthu zomwe zimawoneka, sankhani "Kupita patsogolo ...".



3. Zenera lakutsogolo limatseguka. Pamagawo "Malo" khazikitsani kusintha Column ndi safu, popeza kwa ife mfundo za mkanganowo ziikidwa m'kholamu, osati mzere. M'munda "Khwerero" mtengo wokhazikitsidwa 2. M'munda "Mtengo wochepera" lowetsani nambala 10. Pofuna kuyambitsa kupita patsogolo, dinani batani "Zabwino".



4. Monga mukuwonera, mzerewu umadzazidwa ndi mfundo ndi gawo lokhazikitsidwa komanso malire.



5. Tsopano muyenera kudzaza gawo f (x) = x ^ 2 + 2x. Kuti muchite izi, mu foni yoyamba yonse, lembani mawuwo potengera dongosolo ili:

   = x ^ 2 + 2 * x

   Komanso, m'malo mopindulitsa x timasinthanitsa magwirizano a selo loyamba kuchokera kumunsi ndi zotsutsa. Dinani batani Lowanikuwonetsa zotsatira za kuwerengera.



6. Pofuna kuwerengera ntchitoyo mzere wina, timagwiritsanso ntchito ukadaulo wokhazikika, koma pamenepa, timagwiritsa ntchito chikhomo. Ikani cholozera mu ngodya ya kumunsi kwa foni yomwe ili kale ndi fomula. Chizindikiro chodzaza, chimaperekedwa ngati mtanda wawung'ono. Gwirani pansi batani la mbewa yakumanzere ndikokani cholozera mbali yonse kuti mudzazidwe.



7. Pambuyo pa izi, gawo lonse lokhala ndi zofunikira zantchitoyi idzadzazidwa yokha.

Chifukwa chake, ntchito yosinthidwa idachitika. Kutengera ndi ichi, titha kudziwa, mwachitsanzo, kuti ntchito yocheperako (0) zopezeka ndi mfundo zotsutsana -2 ndi 0. Kutalika kwa ntchitoyo mkati mwa kusiyanasiyana kwa mkangano kuchokera -10 kale 10 ifika pamlingo wofanana ndi wotsutsana 10, ndikupanga 120.

Phunziro: Momwe mungapangire kuti zitheke mu Excel

Kupanga mapulani

Kutengera ndi magwiritsidwe ake a tebulo, mutha kulinganiza za ntchitoyo.

1. Sankhani zabwino zonse zomwe zili patebulopo ndi chowunika pomwe muli ndi batani lakumanzere. Pitani ku tabu Ikani, mu bokosi la zida Ma chart pa tepi dinani batani "Ma chart". Mndandanda wa zosankha zomwe zikupezeka pa tchati zikutsegulidwa. Sankhani mtundu womwe tikuwona kuti ndi woyenera kwambiri. Mwachitsanzo, ifeyo tili ndi ndandanda yangwiro.



2. Zitatha izi, pa worksheet, pulogalamuyo imachita ndondomeko ya zojambulidwa motengera matebulo osankhidwa.

Kuphatikiza apo, ngati angafune, wogwiritsa ntchitoyo amatha kusintha tchati momwe akuonera, pogwiritsa ntchito zida za Excel pazolinga izi. Mutha kuwonjezera maina a axel omwe amagwirizanitsa ndi graph yonseyo, chotsani kapena sinthani nthanoyo, chotsani mzere wotsutsana, etc.

Phunziro: Momwe mungapangire dongosolo mu Excel

Monga mukuwonera, kuwunika ntchito nthawi zambiri kumakhala kolunjika. Zowona, kuwerengera kumatha kutenga kanthawi. Makamaka ngati malire amatsutsano ali ochulukirapo ndipo sitepeyo ndiyochepa. Kusunga nthawi moyenera kudzathandizira zida za Excel autofill. Kuphatikiza apo, pulogalamu yomweyo, malinga ndi zotsatira zake, mutha kupanga chiwonetsero chazithunzi.