Omunye wemisebenzi edume kakhulu ekudaleni izibalo kumbukiso. Yinombolo ye-Euler ephakanyiselwe amandla akhethiwe. Ku-Excel kunomsebenzisi ohlukile ovumela ukuthi ubale. Ake sibone ukuthi ingasetshenziswa kanjani ekusebenzeni.
Ibala ukucaciswa ku-Excel
I-exponent iyinombolo ye-Euler ephakanyisiwe kwizinga elinikeziwe. Inombolo ye-Euler ngokwayo isilingana no-2.718281828. Ngezinye izikhathi libizwa nangokuthi inombolo yeNapier. Umsebenzi ohloniphekile ungokulandelayo:
f (x) = e ^ n,
lapho e kuyi-Euler inombolo, futhi n yiyona degree of erection.
Ukubala le nqubo ku-Excel, sebenzisa opharetha ohlukile - EXP. Ngaphezu kwalokho, lo msebenzi ungaboniswa njengegrafu. Sizokhuluma ngokuqhubekayo mayelana nokusebenza ngalawa mathuluzi.
Indlela yoku-1: Bala i-exponent ngokufaka ngesandla ngesandla
Ukuze ubale ku-Exel inani le-exponent yenani e kuya kwesilinganiso esibonisiwe, udinga ukusebenzisa opharetha okhethekile EXP. I-syntax yayo ilandelayo:
= EXP (inombolo)
Okusho ukuthi leli fomula liqukethe ukuphikisana okukodwa kuphela. Yiyona ngqo ukuthi inani le-Euler kufanele liphakanyiswe kanjani. Le mpikiswano ingaba ngesimo senani lamanani noma ingathatha ifomu lokubhekisela kwiseli equkethe isibonakaliso sezinga.
- Ngakho-ke, ukuze sibone i-exponent yezinga lesithathu, sidinga kuphela ukufaka inkulumo elandelayo kubha yamatomu noma kunoma iyiphi iseli elingenalutho kushidi:
= EXP (3)
- Ukwenza ukuchofoza kokubala ku-inkinobho. Ngena. Ingqikithi iboniswa kuseli elichazwe ngaphambilini.
Isifundo: Ezinye Imisebenzi Yezibalo ku-Excel
Indlela 2: Ukusebenzisa i-Wizard Wizard
Nakuba i-syntax yokubala ngokucacile ilula kakhulu, abanye abasebenzisi bakhetha ukusebenzisa Umsebenzi weWebhu. Cabanga ukuthi lokhu kwenziwa kanjani ngesibonelo.
- Sibeka isikhombisi esitokisini lapho umphumela wokugcina wokubala kufanele uboniswe khona. Chofoza kusithonjana ngesimo sesithonjana "Faka umsebenzi" ngakwesokunxele kwebha yefomula.
- Ifasitela ivula Amakhosi omsebenzi. Esikhathini "Isibalo" noma "Uhlu oluphelele lwe-alfabhethi" senza ukucinga igama "EXP". Khetha leli gama bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano ivuleka. Inensimu eyodwa kuphela - "Inombolo". Sishayela idijithali kulo, okusho ukuthi ubukhulu bezinga le-Euler inombolo. Sicindezela inkinobho "Kulungile".
- Ngemuva kwezinyathelo ezingenhla, umphumela wokubala uzoboniswa esitokisini okhethiwe esigabeni sokuqala sale ndlela.
Uma le mpikiswano isethenjwa leseli eliqukethe i-exponent, kuzomele ubeke isikhombisi ensimini "Inombolo" bese ukhetha lelo selinye kushidi. Izixhumanisi zayo zizovela masinyane ensimini. Ngemuva kwalokho, ukubala umphumela, chofoza inkinobho. "Kulungile".
Isifundo: Umsebenzi weWebhu ku-Microsoft Excel
Indlela 3: ukuhlela
Ngaphezu kwalokho, ku-Excel kunethuba lokukwakha igrafu, ngokusekelwe emiphumeleni etholakala ekubalweni kwe-exponent. Ukuze uhlele ishidi, amanani ebalwa we-exponent of degrees ahlukahlukene kufanele asevele ekhona. Ungakwazi ukubala ngenye yezindlela ezichazwe ngenhla.
- Khetha ibanga lapho ababukeli bemele khona. Iya kuthebhu "Faka". Ebhebheni eqenjini lezilungiselelo "Amashadi" push inkinobho "Hlela". Uhla lwamagrafu luvuleka. Khetha uhlobo ocingayo olufanele kakhulu imisebenzi ethile.
- Ngemuva kokuthi uhlobo lwegrafu lukhethiwe, lolu hlelo luzokwakha futhi lubonise eshadini elifanayo, ngokusho kombukiso ocacisiwe. Ungabe usuhlela njengamanye umdwebo we-Excel.
Isifundo: Indlela yokwenza igrafu ku-Excel
Njengoba ungabona, balala i-exponent ku-Excel usebenzisa umsebenzi EXP okuyisisekelo kulula. Le nqubo kulula ukwenza kokubili kwimodi yebhuku futhi ngokusebenzisa Amakhosi omsebenzi. Ngaphezu kwalokho, lolu hlelo luhlinzeka ngamathuluzi okuhlela igrafu ngokususelwa kulezibalo.