Mafi sau da yawa, a tsakanin ƙungiyoyin da ake samuwa, masu amfani da Excel suna zuwa math. Tare da taimako daga gare su akwai yiwu a samar da nau'in lissafi da algebraic daban-daban. An yi amfani dashi akai-akai a tsarin tsarawa da kimiyya. Mun koyi abin da wannan rukuni na aiki ke wakiltar gaba ɗaya, kuma za mu ci gaba da ƙarin bayani a kan mafi mashahuri da su.
Aiwatar da ayyuka na lissafi
Tare da taimakon ayyuka na ilmin lissafi zaka iya yin lissafi daban-daban. Za su kasance masu amfani ga dalibai da masu makaranta, injiniyoyi, masana kimiyya, masu lissafi, masu tsarawa. Wannan kungiya ya haɗa da kimanin 80 masu aiki. Za mu tattauna dalla-dalla goma shahararrun su.
Zaka iya bude jerin lissafin lissafi a hanyoyi da dama. Hanyar mafi sauki don fara aikin aiki shi ne ta latsa maɓallin. "Saka aiki"wanda yake a gefen hagu na tsari. A wannan yanayin, dole ne ka fara zaɓin tantanin halitta inda za a nuna sakamakon aikin bayanai. Wannan hanya yana da kyau saboda ana iya aiwatarwa daga kowane shafin.
Hakanan zaka iya kaddamar da Wizard na Gashi ta zuwa shafin "Formulas". A nan akwai buƙatar danna maballin "Saka aiki"located a gefen hagu na tef a cikin akwatin kayan aiki "Gidan Kayan aiki".
Akwai hanya ta uku don kunna mayejan aikin. An yi ta ta latsa maɓallin haɗin haɗin akan keyboard. Shift + F3.
Bayan mai amfani ya yi duk wani aikin da aka sama, Wizard Wurin zai buɗe. Danna kan taga a filin "Category".
Jerin jerin zaɓuka ya buɗe. Zaɓi matsayi a ciki "Ilmin lissafi".
Bayan haka, jerin ayyukan ayyukan lissafi a Excel ya bayyana a cikin taga. Don zuwa gabatarwar muhawara, zaɓi wani takamaiman kuma danna maballin "Ok".
Akwai kuma hanyar da za a zaɓar wani ƙwararrun ilimin lissafi ba tare da bude babban taga na Wurin Sanya ba. Don yin wannan, je zuwa shafin da aka sani. "Formulas" kuma danna maballin "Ilmin lissafi"located a kan tef a cikin wani rukuni na kayayyakin aiki "Gidan Kayan aiki". Jerin jerin ya buɗe daga abin da kake buƙatar zaɓar daftarin da ake buƙatar don warware wani aiki na musamman, bayan haka za'a bude taga ta muhawara.
Duk da haka, ya kamata a lura cewa ba dukkanin siffofi na ƙungiyar lissafi ba ne aka gabatar a cikin wannan jerin, ko da yake mafi yawansu sun kasance. Idan ba ku sami afaretan da kuke buƙatar ba, sannan danna kan abu "Saka aiki ..." a cikin ƙasa na jerin, bayan haka ne Master of ayyuka, wanda ya saba da mu, zai buɗe.
Darasi: Wizard Function Wizard
SUM
Ayyukan da aka fi amfani dasu SUM. Ana buƙatar wannan afaretin don ƙarin bayani a cikin kwayoyin da yawa. Kodayake za'a iya amfani dashi don daidaitaccen lambobi. Rubutun da za'a iya amfani dashi don shigarwar manhaja kamar haka:
= SUM (lamba1; number2; ...)
A cikin muhawarar, shigar da tantanin tantanin yanar gizo ko hanyoyin haɗin kai a cikin filayen. Mai aiki yana ƙara abun ciki kuma yana nuna adadin a cikin tantanin salula.
Darasi: Yadda za a tantance adadin a Excel
Kundin
Mai sarrafawa Kundin Har ila yau yana lissafin adadin lambobi a cikin sel. Amma, ba kamar aikin da ya gabata ba, a cikin wannan afaretar zaka iya saita yanayin da zai ƙayyade wane dabi'u suna cikin lissafin, kuma abin da ba haka ba ne. A lokacin da aka kwatanta yanayin, zaka iya amfani da alamun ">" ("more"), "<" ("kasa da"), "" ("ba daidai") ba. Wato, da lambar da ba ta haɗu da yanayin da aka ƙayyade ba a ɗauke shi cikin asusu a cikin gardama na biyu idan aka lissafta adadin. Bugu da kari, akwai ƙarin bayani "Ranar Kira"amma ba lallai ba ne. Wannan aiki yana da wadannan haruɗɗa:
= SUMMESLES (Range; Criterion; Range_Summing)
ROUND
Kamar yadda za a iya fahimta daga aikin sunan ROUNDYana aiki don zagaye lambobi. Bayani na farko na wannan afaretan yana da lamba ko ƙaddamar da wani tantanin halitta wanda ya ƙunshi nau'in lambobi. Ba kamar sauran ayyukan ba, wannan tashar ba zata iya zama darajar ba. Shawara ta biyu ita ce yawan adadin ƙananan wurare da ke kewaye. Ana gudanar da zagaye bisa ga ka'idodin lissafi na asali, wato, zuwa mafi kusa da lambar modulo. Hadawa don wannan tsari shine:
= ROUND (lambar, lambobi)
Bugu da ƙari, a cikin Excel, akwai ayyuka kamar su ROUNDUP kuma CIRCLEwanda yake biye lambobi zuwa mafi girma mafi kusa da ƙarami a cikakkar darajar.
Darasi: Lambobi masu tasowa Excel
PRODUCTION
Mai gudanarwa Kira shi ne yawancin lambobi ko wadanda aka samo a cikin sel na takardar. Tambayoyi na wannan aiki sune nassoshi akan kwayoyin da ke dauke da bayanai don ƙaddarawa. Har zuwa 255 irin waɗannan alaƙa za a iya amfani. Sakamakon ninki yana nunawa a cikin tantanin salula. Rubutun ga wannan sanarwa shine:
= PRODUCTION (lamba, lambar; ...)
Darasi: Yadda za a ninka daidai a Excel
ABS
Yin amfani da matakan lissafi ABS Ya ƙididdige yawan adadin. Wannan sanarwa yana da gardama ɗaya - "Lambar"Wato, ƙaddamar da wani tantanin halitta dauke da bayanan lambobi. Hanya a cikin rawar da gardama ba zata iya aiki ba. Haɗin aikin shine:
= ABS (lambar)
Darasi: Ayyukan aiki na Excel
DEGREE
Daga sunan yana bayyane cewa aikin mai aiki DEGREE shi ne gina wani lambar zuwa digiri da aka ba da. Wannan aikin yana da muhawara guda biyu: "Lambar" kuma "Degree". Na farko za a iya ƙayyade shi azaman ƙaddamar da wani tantanin halitta wanda ya ƙunshi nau'in lambobi. Shaida ta biyu ta nuna alamar erection. Daga bayanin da ya biyo baya ya biyo bayanan cewa wannan haɗin aiki kamar haka:
= GARATARWA (lambar digiri)
Darasi: Yadda ake tayar da digiri a Excel
ROOT
Ɗawainiyar aiki ROOT yana shafewa. Wannan afaretan yana da hujja daya kawai - "Lambar". A cikin rawar da zai iya kasancewa yana nunawa ga tantanin halitta dauke da bayanai. Rubutun yana ɗaukar nau'i na gaba:
= Ginin (lambar)
Darasi: Yadda za a tantance tushen a cikin Excel
CASE
Ma'anar tana da aikin musamman. CASE. Ya ƙunshi ƙaddamarwa zuwa ƙayyadaddun tantanin halitta kowane lambar da ba a ƙira ba tsakanin lambobin da aka ba su. Daga bayanin aikin wannan afaretan ɗin yana bayyana cewa ƙididdigarsa ita ce ƙananan kuma ƙananan iyakokin lokaci. Harshensa shine:
= CASE (Lower_boundary; Upper_boundary)
PRIVATE
Mai sarrafawa PRIVATE amfani da shi don raba lambobi. Amma a sakamakon sakamakon, yana nuna kawai lambar, ƙidaya zuwa ƙarami lamba. Ƙididdigar wannan tsari shine nassoshi ga kwayoyin dake dauke da rabawa da raba. Haɗin yana kamar haka:
= SABATARWA (Kwamfuta mai rikitarwa;
Darasi: Ra'ayin daji a Excel
ROMAN
Wannan aikin yana ba ka damar canza lambobin Larabci, wanda Excel yayi amfani dashi, zuwa lambobin Romawa. Mai tafiyar da aiki ɗin yana da muhawara guda biyu: mai kula da tantanin halitta tare da lambar da za'a canza, da kuma nau'i. Shawara ta biyu ita ce zaɓi. Haɗin aikin shine:
= ROMAN (Lambar; Form)
A sama, kawai ayyukan da aka fi sani da Excel math sun bayyana. Suna taimakawa wajen sauƙaƙe yawan lissafi a cikin wannan shirin. Tare da taimakon waɗannan ƙwayoyin, za ku iya yin lissafi mai sauƙi kuma ƙididdigar ƙididdiga. Musamman ma suna taimakawa a lokuta inda ake buƙatar yin lissafi.
