Eminye yemisebenzi edume kakhulu ye-exponential ku-mathematics yisakhi. Yinombolo ye-Euler ephakanyiselwe izinga elikhonjisiwe. E-Excel kune-opharetha ehlukile evumela ukuthi wena ukuyibala. Ake sibheke ukuthi ingasetshenziswa kanjani ekuzijwayezeni.
Ukubalwa kombukiso ku-Excel
Isikhiphi inombolo ye-Euler ephakanyiselwe ezingeni elithile. Inombolo ye-Euler uqobo icishe ibe ngu-2.718281828. Kwesinye isikhathi kubizwa nangokuthi inani leNapier. Umsebenzi wokukhipha umi kanje:
f (x) = e ^ n,
lapho u-Inombolo ye-Euler futhi u-n i-degree of erection.
Ukubala le nkomba ku-Excel, kusetshenziswa isisetshenziswa esihlukile - I-EXP. Ngaphezu kwalokho, lo msebenzi ungakhonjiswa ngefomethi yegrafu. Sizokhuluma ngokusebenza nala mathuluzi ngokuhamba kwesikhathi.
Indlela yoku-1: ukubala okufakayo ngokungenisa umsebenzi
Ukuze ukubala inani lomkhiphi ku-Excel e kuze kube manje, udinga ukusebenzisa i-opharetha ekhethekile I-EXP. I-syntax yayo imi ngolu hlobo:
= EXP (inombolo)
Lokho wukuthi, le formula iqukethe impikiswano eyodwa kuphela. Imelela nje izinga okudingeka uphakamise inombolo ye-Euler. Le ngxabano ingaba ngedlela yenani lokubala, noma uthathe isimo sesixhumanisi seseli equkethe inkomba ye-degree.
- Ngakho-ke, ukuze ukubala okhipha isisekelo se-degree yesithathu, kwanele ngathi ukuthi sifake le nkulumo elandelayo kubha yefomula noma kunoma yisiphi iseli elingenalutho eshidini:
= EXP (3)
- Ukuze wenze ukubala, chofoza inkinobho Ngena. Isamba sikhonjiswa kuseli elichaziwe.
Isifundo: Eminye imisebenzi yezibalo ku-Excel
Indlela 2: Sebenzisa Umsebenzi Wizard
Yize i-syntax yokubala okhipha impahla ilula kakhulu, abanye abasebenzisi bathanda ukuyisebenzisa Isici Wizard. Cabanga ukuthi lokhu kwenziwa kanjani ngokwesibonelo.
- Sibeka ikhesa esitokisini lapho kuzoboniswa khona umphumela wokugcina wokubala. Chofoza isithonjana ngendlela yesithonjana. "Faka umsebenzi" ngakwesokunxele sebha yefomula.
- Kuvulwa iwindi Umsebenzi Wizards. Esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi" sifuna igama "EXP". Khetha leli gama bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana liyavula. Inenkambu eyodwa kuphela - "Inombolo". Sishayela isibalo kulo, okuyosho ubukhulu besilinganiso senombolo ye-Euler. Chofoza inkinobho "Kulungile".
- Ngemuva kwezenzo ezingenhla, umphumela wokubala uzokhonjiswa kuseli eliqokonyiswe esigabeni sokuqala sale ndlela.
Uma impikiswano iyireferensi yeseli equkethe okhipha impahla, lapho-ke udinga ukufaka isikhombisi kuyo "Inombolo" bese ukhetha lelo seli ekhasini. Izixhumanisi zayo zikhonjiswa ngokushesha emkhakheni. Ngemuva kwalokho, ukubala umphumela, chofoza inkinobho KULUNGILE.
Isifundo: Isici Wizard ku Microsoft Excel
Indlela 3: ugobe
Ngaphezu kwalokho, ku-Excel kunethuba lokwakha igrafu, kuthatha njengesisekelo imiphumela etholakele njengomphumela wokubala okhipha impahla. Ukwakha igrafu, ishidi kufanele ngabe selibalile amanani wokukhishwa wamadigri ahlukahlukene. Ungazibala usebenzisa enye yezindlela ezichazwe ngenhla.
- Sikhetha ibanga lapho ababoniswa khona. Iya kuthebhu Faka. Kubambo obeseqoqweni lezilungiselelo Amashadi chofoza inkinobho Ishadi. Uhlu lwamagrafu luyavula. Khetha uhlobo ocabanga ukuthi lufanelekele imisebenzi ethile.
- Ngemuva kokuba uhlobo lwegrafu selukhethiwe, uhlelo luzokwakha futhi luvezwe ephepheni elifanayo, ngokusho kombukiso obekiwe. Ngaphezu kwalokho kuzokwenzeka ukuhlela, njenganoma yimuphi omunye umdwebo we-Excel.
Isifundo: Ungayenza kanjani ishadi ku-Excel
Njengoba ukwazi ukubona, bala okokukhipha ku-Excel usebenzisa umsebenzi I-EXP okuyisisekelo okulula. Le nqubo kulula ukuyenza ngemodi yezandla nange Umsebenzi Wizards. Ngaphezu kwalokho, uhlelo luhlinzeka ngamathuluzi wokuhlela ngokusekelwe kulezi zibalo.