Kulemba kwa ntchito kumagwira ntchito ku Microsoft Excel

Kujambula ntchito ndi chiwerengero cha kufunika kwa ntchito pa mtsutso uliwonse wofanana, woperekedwa ndi sitepe yina, mkati mwa malire ofotokozedwa bwino. Njirayi ndi chida chothandizira kuthetsa ntchito zosiyanasiyana. Ndi chithandizo chake, mukhoza kupeza mizu ya equation, kupeza maxima ndi minima, kuthetsa mavuto ena. Kugwiritsira ntchito Excel kumapangitsa kuwerenga kukhala kosavuta kusiyana ndi kugwiritsa ntchito pepala, pensulo, ndi chowerengera. Tiyeni tione momwe izi zikugwirira ntchitoyi.

Gwiritsani ntchito malemba

Kuwonetseratu kumagwiritsidwa ntchito popanga tebulo komwe mtengo wa mkangano ndi sitepe yosankhidwa idzalembedwera mu ndandanda imodzi, ndi momwe ntchitoyo ikuyendera mu yachiwiri. Ndiye, kuchokera pa kuwerengera, mukhoza kumanga grafu. Taganizirani momwe izi zakhalira ndi chitsanzo chapadera.

Kulengedwa kwazithunzi

Pangani mutu wa tebulo ndi ndondomeko xchomwe chidzakhala mtengo wa kukangana, ndi f (x)kumene ntchito yofananayo ikuwonetsedwa. Mwachitsanzo, tengani ntchitoyo f (x) = x ^ 2 + 2x, ngakhale ntchito yamtundu uliwonse ikhoza kugwiritsidwa ntchito pa njirayi. Ikani sitepe (h) mu kuchuluka kwa 2. Malire kuchokera -10 mpaka 10. Tsopano tifunika kudzaza ndemanga yotsutsana, kutsata sitepe 2 mu malire opatsidwa.

1. Mu selo yoyamba ya chigawocho "x" lowetsani mtengo "-10". Pambuyo pake, dinani pa batani Lowani. Izi ndizofunikira kwambiri, chifukwa ngati mutayesa kugwiritsira ntchito mbewa, mtengo mu selo udzasanduka ndondomeko, koma panopa sikofunikira.



2. Zotsatira zina zonse zingathe kudzazidwa mwatsatanetsatane, kutsatira ndondomeko 2koma ndizovuta kwambiri kuchita izi mothandizidwa ndi chida chodzaza galimoto. Makamaka njirayi ndi yofunika ngati zifukwa zambiri ndizokulu, ndipo sitepe ndi yaing'ono.

   Sankhani selo yomwe ili ndi mtengo wa mtsutso woyamba. Kukhala mu tab "Kunyumba", dinani pa batani "Lembani"yomwe imayikidwa pa kaboni mu bokosi lokhalamo Kusintha. Mundandanda wa zinthu zomwe zikuwonekera, sankhani chinthucho "Kupita patsogolo ...".



3. Mawindo owonetsera mapulogalamu akuyamba. Muyeso "Malo" ikani kasinthasintha kuti muyime "Ndi ndondomeko", popeza mwa ife, zifukwa zazitsutso zidzaikidwa muzamu, osati mzere. Kumunda "Khwerero" ikani mtengo 2. Kumunda "Pezani mtengo" lowetsani nambalayi 10. Kuti muyambe kuyenda, dinani pa batani "Chabwino".



4. Monga momwe mukuonera, gawoli liri ndi zikhulupiliro ndi mayendedwe okhazikika ndi malire.



5. Tsopano tikuyenera kudzaza gawo la ntchito. f (x) = x ^ 2 + 2x. Kuti tichite izi, mu selo yoyamba ya ndime yofananayo timalembera malingana ndi ndondomeko yotsatirayi:

   = x ^ 2 + 2 * x

   Pankhaniyi, mmalo mwa mtengo x kulowetsani makonzedwe a selo yoyamba kuchokera ku ndimeyo ndi zifukwa. Timakanikiza batani Lowani, kuti asonyeze zotsatira za mawerengedwe pawindo.



6. Kuti tichite chiwerengero cha ntchitoyi mu mizere ina, tidzakhalanso kugwiritsa ntchito teknoloji yokwanira yopanga galimoto, koma pakadali pano timagwiritsa ntchito chikhomo chodzaza. Ikani cholozera kumbali ya kumanja kwa selo, yomwe ili ndi kalembedwe. Chizindikiro chodzaza chikuwoneka, chikuyimiridwa ngati mtanda wawung'ono. Gwiritsani botani lamanzere la mchenga ndi kukokera chithunzithunzi pambali yonse yodzaza mzere.



7. Pambuyo pachithunzichi, mzere wonse ndi ntchito zogwirira ntchito zidzasinthidwa.

Choncho, ntchito yolembayi inkachitika. Malingana ndi izo, ife tingakhoze kupeza, mwachitsanzo, kuti kusachepera kwa ntchitoyi (0) Zomwe zinapindula ndi malingaliro -2 ndi 0. Ntchito yaikulu mkati mwa kusiyana kwa mkangano wochokera -10 mpaka 10 anafika pamfundo yomwe ikugwirizana ndi kutsutsana 10ndipo amapanga 120.

Phunziro: Momwe mungapangire autocomplete mu Excel

Plotting

Pogwiritsa ntchito ma tebulo opangidwa mu tebulo, mukhoza kukonza ntchitoyi.

1. Sankhani malingaliro onse mu tebulo ndi chithunzithunzi ndi batani lamanzere lomwe liri pansi. Pitani ku tabu "Ikani"mu chidutswa cha zipangizo "Zolemba" pa tepicho dinani batani "Zolemba". Mndandanda wa zojambula zotsalira zomwe zilipo zikuwonetsedwa. Sankhani mtundu umene timaganiza kuti ndi woyenera kwambiri. Mwa ife, mwachitsanzo, pulogalamu yosavuta ndi yangwiro.



2. Pambuyo pake, pa pepala, pulojekitiyi ikuchita ndondomeko yowonongeka pogwiritsa ntchito ma tebulo omwe asankhidwa.

Komanso, ngati mukufuna, wogwiritsa ntchito akhoza kusintha ndondomeko momwe akuonera, pogwiritsira ntchito zida za Excel cholinga chimenechi. Mukhoza kuwonjezera maina a miyala yothandizira pamodzi ndi grafu lonse, kuchotsa kapena kutchula mbiriyo, kuchotsani mzere wotsutsana, ndi zina zotero.

Phunziro: Mungamange bwanji graph mu Excel

Monga mukuonera, malembawa amagwira ntchito, mwachidule, ndondomekoyi ndi yosavuta. Zoona, ziwerengero zingatenge nthawi yaitali. Makamaka ngati malire a zifukwa ali ochuluka kwambiri, ndipo sitepeyo ndi yochepa. Zida zamakonzedwe a Excel zidzakuthandizani kusunga nthawi. Kuonjezerapo, pulogalamu yomweyi potsatira zotsatira zomwe mwapeza, mukhoza kumanga graph kuti muwonetsere zithunzi.