Ɗaya daga cikin shahararren ayyuka masu mahimmanci a lissafin lissafi shine mai gabatarwa. Wannan lambar Euler da aka haɓaka zuwa ikon da aka ƙayyade. A cikin Excel akwai mai aiki na raba wanda ya ba ka damar lissafta shi. Bari mu ga yadda za a iya amfani da shi a aikace.
Ana ƙayyade ƙaddara a Excel
Mai bayyana shi ne lambar Euler da aka ba da digiri. Lambar Euler kanta ita ce kusan 2.718281828. Wani lokaci ma ana kiran shi lambar Napier. Ayyukan mai bayarwa shine kamar haka:
f (x) = e ^ n,
inda akwai lambar Euler, kuma n shine mataki na erection.
Don lissafta wannan alamar a Excel, yi amfani da afareta na dabam - EXP. Bugu da ƙari, wannan aikin za a iya nuna shi azaman hoto. Za mu yi magana game da aiki tare da waɗannan kayan aikin.
Hanyar 1: Yi ƙididdigar mai bayarwa ta shigar da aikin hannu
Don yin lissafin a cikin Exel darajar mai bayyana don darajar e har zuwa nuna, kana buƙatar yin amfani da afareta na musamman EXP. Sakamakonsa kamar haka:
= EXP (lambar)
Wato, wannan tsari ya ƙunshi kawai gardama. Daidai ne daidai da lambar Euler dole a tashe shi. Wannan jayayya na iya zama ko dai a matsayin nau'i na lamba ko kuma zai iya ɗaukar nau'i na ƙirar wani cell dauke da alamar alamar.
- Saboda haka, don yin lissafin mai gabatarwa don digiri na uku, muna buƙatar shigar da maganganun nan a cikin ƙirar tsari ko a cikin kowane ɗakin maras amfani a kan takardar:
= EXP (3) - Don yin lissafi a latsa maɓallin. Shigar. An nuna jimlar a cikin tantanin da aka riga aka ƙayyade.
Darasi: Sauran Ayyukan Ƙira a cikin Excel
Hanyar 2: Yin amfani da Wizard na Magana
Kodayake mai ƙididdigar lissafi yana da sauƙi, wasu masu amfani sun fi so su yi amfani da su Wizard aikin. Yi la'akari da yadda aka aikata wannan ta misali.
- Mun sanya siginan kwamfuta akan tantanin halitta inda za'a nuna sakamakon karshe na lissafi. Danna kan gunkin a cikin hanyar gunki "Saka aiki" zuwa hagu na dabarun tsari.
- Wurin yana buɗe Ma'aikata masu aiki. A cikin rukunin "Ilmin lissafi" ko "Jerin jerin jerin sunayen" muna yin bincike kan sunan "EXP". Zaɓi wannan suna kuma danna maballin. "Ok".
- Maganin gardama ya buɗe. Yana da filin daya kawai - "Lambar". Muna fitar da lambar a ciki, wanda zai ma'anar digiri na lambar Euler. Muna danna maɓallin "Ok".
- Bayan ayyukan da aka sama, za a nuna sakamakon sakamakon lissafi a tantanin salula wanda aka zaba a cikin sakin farko na wannan hanya.
Idan hujjar ita ce batun tantance halitta wanda ya ƙunshi mai bayyane, to, kana buƙatar saka siginan kwamfuta a filin "Lambar" kuma kawai zaɓi wannan tantanin halitta akan takardar. Hannunta zasu bayyana a fili. Bayan haka, don lissafta sakamakon, danna maballin. "Ok".
Darasi: Wizard aiki a Microsoft Excel
Hanyar 3: yin mãkirci
Bugu da ƙari, a cikin Excel akwai damar da za a gina zane, bisa ga sakamakon da aka samo daga lissafin mai magana. Don yin mãkirci takarda, dole ne ƙididdigar ƙwararrun malami na digiri daban-daban ya kasance. Zaka iya lissafta su a daya daga cikin hanyoyin da aka bayyana a sama.
- Zaži kewayon wanda aka wakilta masu gabatarwa. Jeka shafin "Saka". A rubutun a cikin ƙungiyar saitunan "Sharuɗɗa" tura maɓallin "Jadawalin". Jerin haruffa ya buɗe. Zaɓi nau'in da kake tsammani ya fi dacewa da ayyuka na musamman.
- Bayan an zaɓi nau'in hoto, shirin zai gina kuma ya nuna shi a kan takarda, bisa ga masu gabatarwa da aka ƙayyade. Kuna iya gyara shi kamar kowane zane na Excel.
Darasi: Yadda ake yin jadawali a Excel
Kamar yadda kake gani, lissafta mai gabatarwa a Excel ta amfani da aikin EXP na farko shine mai sauki. Wannan hanya yana da sauƙi don yin duka a cikin yanayin jagora kuma ta hanyar Ma'aikata masu aiki. Bugu da ƙari, wannan shirin yana samar da kayan aiki don ƙaddamar da hoto wanda ya danganci waɗannan lissafin.
