Chimodzi mwazinthu zodziwika kwambiri mu masamu ndichochokera. Ndi nambala ya Euler yomwe idakwezedwa pamlingo womwe wawonetsedwa. Ku Excel pali othandizira ena omwe amakupatsani mwayi wowerengera. Tiyeni tiwone momwe angagwiritsidwire ntchito pochita.
Kuwerengeredwa kwa wowonetsa ku Excel
Chotulukacho ndi nambala ya Euler yomwe idakwezedwa pamlingo wina. Nambala ya Euler palokha ndi pafupifupi 2.718281828. Nthawi zina amatchedwanso nambala ya Napier. Ntchito yotulutsa ili motere:
f (x) = e ^ n,
kumene e ndi nambala ya Euler ndipo n ndi digiri ya erection.
Kuwerengera chizindikiro ichi ku Excel, wogwiritsa ntchito payekha amagwiritsidwa ntchito - Kutulutsa. Kuphatikiza apo, ntchitoyi ikhoza kuwonetsedwa mu mawonekedwe a graph. Tilankhula za kugwiritsa ntchito zida izi mtsogolo.
Njira 1: kuwerengetsani kuti zingatheke bwanji kuti zitheke pang'onopang'ono potumiza ntchito
Pofuna kuwerengera zamtengo wopezeka mu Excel e Kufikira pano, muyenera kugwiritsa ntchito katswiri Kutulutsa. Matchulidwe ake ndi awa:
= EXP (chiwerengero)
Ndiye kuti, fomuloli ili ndi mfundo imodzi yokha. Zimangoyimira kuchuluka komwe muyenera kukweza chiwerengero cha Euler. Kutsutsana uku kumatha kukhala kwa mtengo wamanambala, kapena kutenga mawonekedwe olumikizana ndi foni yomwe ili ndi cholembera cha digirii.
- Chifukwa chake, kuti titha kuwerengera chamtunduwu gawo lachitatu, ndikokwanira kuti tiloze mawu otsatirawa mu mzere wazolowera kapena mu cell iliyonse yopanda papepala:
= EXP (3) - Kuti muwerengere, dinani batani Lowani. Zokwanira zikuwonetsedwa m'chipinda cholongosoleredwa.
Phunziro: Ntchito zina zamasamu ku Excel
Njira 2: gwiritsani ntchito Wizard wa Ntchito
Ngakhale syntax yowerengera katunduyo ndiosavuta kwambiri, ogwiritsa ntchito ena amakonda kugwiritsa ntchito Fotokozerani Wizard. Ganizirani momwe izi zimachitidwira mwachitsanzo.
- Tikuyika cholozera pafoni momwe zotsatira zowerengera zidzawonetsedwere. Dinani pazithunzi mu mawonekedwe a chithunzi. "Ikani ntchito" kumanzere kwa baramu yamu formula.
- Zenera limatseguka Ogwira Ntchito. Gulu "Masamu" kapena "Mndandanda wathunthu wa zilembo" timafunafuna dzinalo "EXP". Sankhani dzinali ndikudina batani. "Zabwino".
- Windo la mkangano likutseguka. Ili ndi gawo limodzi lokha - "Chiwerengero". Timayendetsa manambala mwa iwo, zomwe zingatanthauze kufunikira kwa chiwerengero cha Euler. Dinani batani "Zabwino".
- Pambuyo pazomwe zatchulidwa pamwambapa, kuwerengera kumawonetsedwa mu foni yomwe idatsimikiziridwa mu gawo loyamba la njirayi.
Ngati mkanganowo ukuimira foni yomwe ili ndi wotuluka, ndiye kuti muyenera kuyika otsogolera "Chiwerengero" ndikungosankha cholembacho. Ogwirizanitsa ake amawonetsedwa nthawi yomweyo m'munda. Pambuyo pake, kuti muwerenge zotsatira, dinani batani Chabwino.
Phunziro: Fotokozerani Wizard mu Microsoft Excel
Njira 3: Kuganizira chiwembu
Kuphatikiza apo, ku Excel pali mwayi wopanga graph, potenga maziko pazotsatira zomwe zimapezeka chifukwa chowerengetsa zomwe zimatuluka. Kuti mupange chithunzi, pepalali liyenera kuti linakhala litawerengera kale kuchuluka kwa magawo osiyanasiyana. Mutha kuwerengera pogwiritsa ntchito imodzi mwanjira zomwe tafotokozazi.
- Timasankha magulu omwe oimirawa akuimira. Pitani ku tabu Ikani. Pa riboni m'makonzedwe magulu Ma chart dinani batani Tchati. Mndandanda wazithunzi umatsegulidwa. Sankhani mtundu womwe mukuganiza kuti ndi woyenera kugwira ntchito zinazake.
- Mtundu wa graph utasankhidwa, pulogalamuyo imanga ndikuwonetsa patsamba lomwelo, malinga ndi owonetsa omwe akuwonetsedwa. Komanso ndizotheka kusintha, monga chithunzi china chilichonse cha Excel.
Phunziro: Momwe mungapangire tchati ku Excel
Monga mukuwonera, werengani zomwe zimatuluka mu Excel pogwiritsa ntchito ntchitoyo Kutulutsa zoyambira zosavuta. Njirayi ndiosavuta kuchita machitidwe amawu ndi Ogwira Ntchito. Kuphatikiza apo, pulogalamuyi imapereka zida zoyenera kutengera ziwerengerozi.
