Kulembedwa kwa ntchitoyo ku Excel: Malangizo atsatanetsatane

Anonim

Kugwira ntchito ku Microsoft Excel

Ntchito yovuta ndikuwerengera kwa mtengo wa ntchito pamikangano iliyonse yovomerezeka yomwe ili ndi gawo linalo mwa malire okhazikika. Njirayi ndi chida chothetsera ntchito zosiyanasiyana. Ndi thandizo lake, mutha kupangira mizu ya equation, kupeza zokwezeka ndi Minima, kuthetsa ntchito zina. Ndi pulogalamu yapamwamba kwambiri, kuchepa kwake kumakhala kosavuta kuchita kuposa kugwiritsa ntchito pepala, chogwirizira ndi zowerengera. Tiyeni tiwone momwe izi zimachitikira mu ntchito iyi.

Kugwiritsa ntchito kugwiritsa ntchito

Tsitsi umagwiritsidwa ntchito popanga tebulo pomwe mtengo wa mfundo ndi gawo limodzi, ndipo wachiwiri - ntchito yolingana ndi iyo. Kenako, pamaziko a kuwerengera, mutha kupanga ndandanda. Onani momwe izi zimachitikira mwachitsanzo.

Kupanga tebulo

Pangani tebulo ndi tebulo ndi mzati X, momwe mtengo wa mikangano udzawonekere, ndipo f (x), komwe ntchito yofananira ikuwonetsedwa. Mwachitsanzo, tengani ntchito f (x) = x ^ 2 + 2 + 2. Ngakhale ntchito zamtundu uliwonse zitha kugwiritsidwa ntchito potengera njira yolowerera. Timakhazikitsa gawo (H) mu kuchuluka kwa 2. 1 mpaka 10 mpaka 10. Tsopano tiyenera kudzaza mzere, kumamatira pagawo 2 pamalire.

  1. Mu selo loyamba la mzati "X" Lowani mtengo "-10". Pambuyo pake timadina batani la Enter. Izi ndizofunikira kwambiri, chifukwa ngati mukuyesa kuwongolera mbewa, mtengo womwe uli mu khungu umasandulika kukhala njira, ndipo pankhaniyi sikofunikira.
  2. Mtengo woyamba wamikangano mu Microsoft Excel

  3. Makhalidwe ena onse atha kudzazidwa ndi dzanja, kumamatira mpaka pa Gawo 2, koma ndizosavuta kuchita izi pogwiritsa ntchito chida cha autofill. Makamaka njirayi ndiyofunikira ngati mikangano ndi yayikulu, ndipo sitepe yocheperako.

    Sankhani khungu lomwe lili ndi phindu la mkangano woyamba. Tili mu "Home", dinani batani "Dzazani", yomwe ili pa tepi mu "kusintha" malo. Pamndandanda wazomwe zimawonekera, ndimasankha "gawo la" ".

  4. Kusintha Kumalo Omwe Akukhala Ku Microsoft Excel

  5. Kukhazikitsa kwawindo kumatseguka. Mu "malo" timasinthiratu kukhala "mwa mizamu", kuyambira pamene tikulingalira pamfundoyi, osati mu chingwe. Mu "gawo", khazikitsani mtengo 2. Mu "malire a '
  6. Kukhazikitsa zopitilira mu Microsoft Excel

  7. Monga mukuwonera, mzatiyo wadzazidwa ndi mfundo ndi phula ndi malire.
  8. Chingwe cha mkanganowu chimadzaza microsoft Excel

  9. Tsopano muyenera kudzaza mzere wa ntchito f (x) = x ^ 2 + 2x. Kuti muchite izi, m'chipinda choyambirira cha mzere wofanana, lembani mawuwo pa template yotsatirayi:

    = x ^ 2 + 2 * x

    Nthawi yomweyo, m'malo mwa mtengo wa x timaloweza magwiridwe a foni yoyamba kuchokera pachipinda chokhala ndi mikangano. Timadina batani la Enter kuti muwonetse zotsatira za kuwerengera pazenera.

  10. Mtengo woyamba wa ntchito mu Microsoft Excel

  11. Pofuna kuwerengera ntchitoyo komanso m'mizere ina, tidzagwiritsanso ntchito ukadaulo wa autocompte, koma titayika chizindikiro cholemba. Timakhazikitsa cholozera ku ngodya yakumanja kwa selo pomwe mawonekedwe ali kale. Chizindikiro chodzaza chikuwoneka, choperekedwa ngati chaching'ono kukula kwa mtanda. Clement batani lakumanzere ndikutambasulira cholembera m'mbali yonsewo kukwaniritsidwa.
  12. Kudzaza chikhomo ku Microsoft Excel

  13. Pambuyo pa izi, gawo lonse lokhala ndi mfundo za ntchitoyo lidzadzaza.

Ntchito ku Microsoft Excel

Chifukwa chake, ntchito ya tabu idachitika. Pamaziko ake, titha kudziwa, mwachitsanzo, kuti ntchitoyo (0) imakwaniritsidwa ndi mfundo za mkangano-ndi 0 kupezeka pa mfundo yolingana ndi kutsutsana 10, ndipo ndi 120.

Phunziro: Momwe mungapangire kuzengereza

Zithunzi Zomanga

Kutengera tabu yofikiridwa pagome, mutha kupanga dongosolo la ntchito.

  1. Sankhani zonse zomwe zili patebulopo ndi cholembera ndi batani lakumanzere. Tiyeni titsegule tati "kuyika", mu chinsinsi cha tchati pa tepi timakanikiza batani la "graphs". Mndandanda wazosankha zithunzi za zithunzi zilipo. Sankhani mtundu womwe timaganizira zabwino kwambiri. Kwa ife, ndi bwino, mwachitsanzo, dongosolo losavuta.
  2. Kusintha Kumanga Kwa Graph ku Microsoft Excel

  3. Pambuyo pake, pulogalamu ya pulogalamuyi imachita njira yopanga zojambula zochokera patebulo.

Ndandandayi imamangidwa mu Microsoft Excel

Kupitilira apo, ngati angafune, wogwiritsa ntchitoyo amatha kusintha tchati monga momwe zikuwonekera pogwiritsa ntchito zida zapamwamba pa zolinga izi. Mutha kuwonjezera mayina a axes a magwiridwe antchito ndi zithunzi zonse, chotsani kapena kuwunikiranso nthanoyo, chotsani mzere, etc.

Phunziro: Momwe Mungapangire Ndondomeko Yapamwamba

Monga tikuwona, ntchito ya tibblatch, yonse, njirayi ndi yosavuta. Zowona, kuwerengera kungatenge nthawi yayitali. Makamaka ngati malire a mikangano ndiotamba kwambiri, ndipo sitepe yocheperako. Adasunga nthawi kuti athandizire zida zopambana. Kuphatikiza apo, mu pulogalamu yomweyo, pamaziko a zotsatira zake, mutha kupanga chithunzithunzi chowoneka.

Werengani zambiri