Imodzi mwa ntchito zotchuka kwambiri zowonetsera masamu ndi exhibitor. Ndiyo Euler nambala yomwe inakwezedwa ku mphamvu yeniyeni. Mu Excel pali operekera osiyana omwe amakulolani kuti muwerenge. Tiyeni tiwone momwe zingagwiritsidwe ntchito pakuchita.
Kuwerengera zofotokozera mu Excel
The exponent ndi Euler chiwerengero chokwera ku digiti. Euler chiwerengero chake pafupifupi pafupifupi 2.718281828. Nthawi zina imatchedwanso nambala ya Napier. Ntchito yowonongeka ili motere:
f (x) = e ^ n,
kumene e ndi nambala ya Euler, ndipo n ndi digiri ya erection.
Kuti muwerenge chizindikiro ichi ku Excel, gwiritsani ntchito osiyana - EXP. Kuwonjezera apo, ntchitoyi ikhoza kuwonetsedwa monga graph. Tidzakambirana zambiri za kugwira ntchito ndi zipangizozi.
Njira 1: Yerengani zolembera polowera mwatsatanetsatane
Kuti muwerenge ku Exel mtengo wa exponent kwa mtengo e mpaka momwe mukuwonetsera, muyenera kugwiritsa ntchito wapadera EXP. Mawu ake omasulira ndi awa:
= EXP (nambala)
Ndiko kuti, chidule ichi chili ndi mtsutso umodzi wokha. Ndizofunikira kwambiri kuti chiwerengero cha Euler chikule. Mtsutso uwu ukhoza kukhala mwa mawonekedwe a nambala yamtengo kapena angatenge mawonekedwe a kutanthauzira selo okhala ndi digiri ya digiri.
- Potero, kuti tiwerenge chiwonetsero cha digiri yachitatu, tikungoyenera kufotokozera mawu otsatirawa mu bar barolo kapena mu selo iliyonse yopanda kanthu pa pepala:
= EXP (3) - Kuchita chiwerengerocho dinani pa batani. Lowani. Chiwonetserocho chikuwonetsedwa mu selo yapaderatu.
Phunziro: Ntchito zina za Math mu Excel
Njira 2: Kugwiritsa Ntchito Wopanga Ntchito
Ngakhale kuti mawu ovomerezeka a chiwerengero ndi ophweka kwambiri, ena amagwiritsa ntchito Mlaliki Wachipangizo. Taganizirani momwe izi zikuchitidwira mwachitsanzo.
- Timayika selolo mu selo komwe zotsatira zomaliza za mawerengedwe ziyenera kuwonetsedwa. Dinani pa chithunzi mu mawonekedwe a chizindikiro "Ikani ntchito" kumanzere kwa bar.
- Zenera likuyamba Oyang'anira ntchito. M'gululi "Masamu" kapena "Mndandanda wathunthu wa alfabeti" timayesetsa kufufuza dzina "EXP". Sankhani dzina ili ndipo dinani pa batani. "Chabwino".
- Fesholo yotsutsana ikutsegula. Ali ndi munda umodzi wokha - "Nambala". Timayendetsa chiwerengero chake, zomwe zikutanthauza kukula kwa digiri ya Euler nambala. Timakanikiza batani "Chabwino".
- Zitatha zotsatirazi, zotsatira za chiwerengero zidzawonetsedwa mu selo yomwe yasankhidwa mu ndime yoyamba ya njira iyi.
Ngati kukangana ndikutanthauzira kwa selo komwe kuli ndi mawu, ndiye kuti mufunika kuyika cholozeracho kumunda "Nambala" ndipo ingosankha selolo pa pepala. Zolumikizana zake zidzawonekera mwamsanga kumunda. Pambuyo pake, kuti muone zotsatira, dinani pa batani. "Chabwino".
Phunziro: Wachipangizo Wachipangizo mu Microsoft Excel
Njira 3: Chiwembu
Kuonjezerapo, mu Excel pali mwayi womanga grafu, kuchokera pa zotsatira zomwe zapezeka ku mawerengedwe a ovomerezeka. Pofuna kukonza pepala, ziwerengero zowerengedwa za madigiri osiyanasiyana ziyenera kukhalapo kale. Mukhoza kuziwerengera mwa njira imodzi yomwe tatchulidwa pamwambapa.
- Sankhani mtundu umene owonetsawo akuyimira. Pitani ku tabu "Ikani". Pa kavalo mu gulu la machitidwe "Zolemba" sankani batani "Ndondomeko". Mndandanda wa ma grafu akutsegulidwa. Sankhani mtundu womwe mukuganiza kuti ndi woyenera ntchito zina.
- Pambuyo pa mtundu wa graph wasankhidwa, pulogalamuyi idzaimanga ndi kuiwonetsera pa pepala limodzi, malingana ndi owonetsera omwe akuwonetsedwa. Mutha kuzikonza ngati chithunzi chilichonse cha Excel.
Phunziro: Momwe mungapangire grafu ku Excel
Monga momwe mungathe kuwonera, muwerenge zomwe zili mu Excel pogwiritsa ntchito ntchitoyi EXP pulayimale ndi yosavuta. Ndondomekoyi ndi yosavuta kuchita zonse muzolowera komanso kudzera Oyang'anira ntchito. Kuphatikiza apo, purogalamuyi imapereka zida zogwiritsira ntchito graph malinga ndi izi.
