Mafi sau da yawa, a cikin wadatattun rukunin ayyuka, masu amfani da Excel suna juyawa ga masu lissafi. Amfani da su, zaku iya yin ayyukan ilmin lissafi da algebraic daban-daban. Ana amfani dasu galibi a cikin tsari da lissafin kimiyya. Zamu gano menene wannan rukunin rukunin masu gudanar da aiki gaba ɗaya, kuma mu more cikakkun bayanai kan shahararrun su.
Amfani da ayyukan lissafi
Yin amfani da ayyukan lissafi, zaku iya yin lissafin da yawa. Za su kasance da amfani ga ɗalibai da childrenan makaranta, injiniya, masana kimiyya, masu lissafi, masu tsara shirye-shirye. Wannan rukunin ya hada da kusan masu aiki 80. Zamu zauna daki-daki kan shahararrun guda goma daga cikinsu.
Kuna iya buɗe jerin dabarun lissafi ta hanyoyi da yawa. Hanya mafi sauki don fara Mayen Aiki ita ce ta danna maɓallin. "Saka aikin", wanda yake gefen hagu na masarar dabara. A wannan yanayin, dole ne ka fara zaɓar tantanin inda za a nuna sakamakon sarrafa bayanai. Wannan hanyar tana da kyau a cikin cewa ana iya aiwatar da shi daga kowane shafin.
Hakanan zaka iya ƙaddamar da Wurin Aiki ta hanyar zuwa shafin Tsarin tsari. A can kuna buƙatar danna maballin "Saka aikin"located a gefen hagu na gefen tef a toshe kayan aiki Laburaren Ma’aikata.
Akwai hanya ta uku don kunna Mai kunna Aiki. Ana aiwatar dashi ta danna maɓallan maɓallan akan maballin Canji + F3.
Bayan mai amfani ya aiwatar da kowane ɗayan ayyukan da ke sama, Mai kunna Wurin ya buɗe. Danna kan taga a filin Nau'i.
Lissafin faɗakarwa yana buɗewa. Zabi wani matsayi a ciki "Ilmin lissafi".
Bayan haka, jerin duk ayyukan lissafi a cikin Excel sun bayyana a taga. Don ci gaba zuwa gabatarwar muhawara, zaɓi takamaiman kuma danna maɓallin "Ok".
Hakanan akwai wata hanya don zaɓar takamaiman mai aiki da lissafi ba tare da buɗe babbar taga Wizard ɗin ba. Don yin wannan, je zuwa shafin da muka riga muka saba da shi Tsarin tsari kuma danna maballin "Ilmin lissafi"located a kan kintinkiri a cikin kayan aiki kungiyar Laburaren Ma’aikata. Jerin yana buɗewa, daga wanda kake buƙatar zaɓar tsarin da ake buƙata don warware takamaiman matsala, bayan wannan sai taga kwalliyarsa zata buɗe.
Gaskiya ne, ya kamata a sani cewa ba duk tsari ne na ƙungiyar lissafi da aka gabatar a cikin wannan jeri ba, kodayake yawancinsu suna. Idan baku sami mai aiki da ake so ba, to danna kan abin "Sanya aikin ..." a kasan kasan jerin, bayan wannan wanda ya saba aiki zai iya budewa.
Darasi: Wizard ɗin Aiki a cikin Excel
SAURARA
Mafi yawan amfani da aikin SAURARA. An tsara wannan ma'aikacin don ƙara bayanai a cikin sel da yawa. Kodayake ana iya amfani dashi don tara lambobin da aka saba. Ginin kalma wanda za'a iya amfani dashi tare da shigarwar littafi kamar haka:
= SUM (lamba1; lamba2; ...)
A cikin taga muhawara, ya kamata ka shigar da hanyoyin haɗi zuwa sel tare da bayanai ko jeri a cikin filayen. Mai aiki yana ƙara abun ciki kuma yana nuna jimlar adadin a cikin sel daban.
Darasi: Yadda za'a kirkiri adadin a Excel
ZAMU CIGABA
Mai aiki ZAMU CIGABA Hakanan yana lissafin adadin adadin lambobi a sel. Amma, ba kamar aikin da ya gabata ba, a cikin wannan mai ba da izini za ku iya saita yanayin da zai tantance waɗanne dabi'u ne ke cikin lissafin kuma wanene ba. Lokacin da aka ƙayyade wani yanayi, zaku iya amfani da alamun ">" ("ƙari"), "<" ("ƙasa"), "" ("ba daidai bane"). Wannan shine, lambar da ba ta dace da yanayin da aka ƙayyade ba a la'akari da shi a cikin hujja na biyu lokacin ƙididdige adadin. Bugu da kari, akwai karin gardama "Takaitaccen Tarihi"amma ba na tilas bane. Wannan aikin yana da salon magana kamar haka:
= LABARI (Range; Yanke; Sum_range)
RANAR
Kamar yadda za'a iya fahimta daga sunan aikin RANAR, yana ba da zagaye da lambobi. Hujja ta farko ta wannan mai aiki lamba ce ko kuma batun tantanin halitta wanda ya kunshi adadin adadi. Ba kamar yawancin sauran ayyukan ba, wannan kewayon ba zai iya zama darajar ba. Hujja ta biyu ita ce yawan wuraren adadi waɗanda kuke son zagayewa. Ana yin zagaye ne bisa ka'idodin lissafi na gaba ɗaya, wato, zuwa lambar mafi kusa. Sanarwar wannan dabara ita ce:
= ROUND (lamba; lamba_digits)
Bugu da kari, Excel yana da fasali kamar FITOWA da ROUNDDOWN, wanda ke zagaye lambobin kusa da mafi girma da ƙarami.
Darasi: Lambobin gama-gari
FASAHA
Aikin mai aiki Kira shine lambar lambobi na mutum ɗaya ko waɗanda ke cikin sel ɗin takardar. Muhawara kan wannan aikin nassoshi ne na sel waɗanda ke ɗauke da bayanai don ƙari. A cikin duka, ana iya amfani da waɗannan hanyar haɗin 255. Sakamakon yawaitar ana nuna shi a cikin sel daban. Gaskiyar magana wannan bayanin ita ce:
= GAGARAWA (lamba; lamba; ...)
Darasi: Yadda ake ninkawa daidai a Excel
ABS
Amfani da tsarin lissafi ABS ana lasafta lambar Wannan ma'aikacin yana da hujja ɗaya - "Lambar", wato, magana game da tantanin halitta mai ɗauke da lambobi. Wurin bazai iya zama azaman hujja ba. Gaskiyar magana kamar haka:
= ABS (lamba)
Darasi: Aikin kayan aiki a cikin Excel
DEGREE
Daga sunan ya bayyana karara cewa aikin mai aiki DEGREE yana haɓaka lamba zuwa matsayin da aka bayar. Wannan aikin yana da mahawara biyu: "Lambar" da "Digiri". Na farkonsu za'a iya nuna shi azaman hanyar haɗi zuwa tantanin da ke ɗauke da ƙimar lamba. Hujja ta biyu ta nuna alamar tsawa. Daga abin da aka ambata, yana bibiyar cewa asalin ma'anar wannan mai aiki kamar haka:
= DEGREE (lamba; digiri)
Darasi: Yadda ake yin kwalliya a cikin Excel
TAFIYA
Kalubale na aiki TAFIYA shine hakar tushe mai tushe. Wannan ma'aikacin yana da hujja ɗaya kawai - "Lambar". Matsayinta na iya kasancewa hanyar haɗi zuwa tantanin da ke ɗauke da bayanai. Ginin kalma yana ɗaukar wannan fom:
= GUDA (lamba)
Darasi: Yadda ake lissafin tushen a Excel
CIGABA DA KYAUTA
A takamaiman takamaiman aiki don dabara CIGABA DA KYAUTA. Ya ƙunshi nuna kowane lambar bazuwar tsakanin lambobi biyu da aka bayar a cikin tantanin da aka ƙayyade. Daga bayanin aikin wannan ma'aikaci a sarari yake cewa muhawararsa ita ce babba da ƙananan iyakokin tazara. Maganganun sa shine:
= CIGABA DA KYAUTA (ƙananan_Bound; babba_Bound)
ADDU'A
Mai aiki ADDU'A An yi amfani da rarraba lambobi. Amma a cikin sakamakon rarrabuwa, yana nuna lamba ko da lamba, an zagaye shi zuwa ga ƙaramin modan tsira. Hujjojin wannan dabara sune nassoshi ga sel wadanda ke dauke da rarrabuwa da rarrabuwa. Gaskiyar magana kamar haka:
= ADALCI (Lissafi; Denominator)
Darasi: Tsarin rabo na Excel
ROMAN
Wannan aikin yana ba ku damar canza lambobin larabci, wanda Excel ke aiki ta tsohuwa, zuwa Roman. Wannan ma'aikacin yana da hujjoji guda biyu: tunani game da tantanin halitta tare da lambar canzawa da nau'i. Hujja ta biyu ba na tilas bane. Gaskiyar magana kamar haka:
= ROMAN (lamba; tsari)
Abubuwan shahararrun ayyukan lissafi ne kawai aka bayyana a sama. Suna taimaka wajan rage sauƙaƙan lissafin abubuwa a cikin wannan shirin. Amfani da waɗannan dabarun, zaku iya yin ayyuka biyu mafi sauƙi na lissafi da ƙididdigar lissafi masu rikitarwa. Musamman suna taimaka a lokuta inda kuna buƙatar yin ƙauyuka masu yawa.
