Mai sarrafawa Asusu yana nufin ayyuka na lissafi na Excel. Babban aikinsa shi ne ƙidaya a kan iyakan da ke tattare da kwayoyin halitta wanda ya ƙunshi bayanan lambobi. Bari mu kara koyo game da bangarori daban-daban na yin amfani da wannan tsari.
Yi aiki tare da mai kula da asusun
Yanayi Asusu yana nufin babban rukuni na masu aikin kididdiga, wanda ya haɗa da mutum ɗari sunaye. Aikin yana kusa da shi a cikin ayyuka. COUNT. Amma, ba kamar batun batunmu ba, yana ɗaukan lambobin da aka cika da cikakkun bayanai. Mai sarrafawa Asusugame da abin da zamu sami cikakken zance, yana ƙidaya kawai kwayoyin da aka cika da bayanai a cikin tsarin lambobi.
Wadanne bayanai ke nufi zuwa mahimmanci? Wannan yana nufin ainihin lambar, da kuma kwanan wata da lokaci. Boolean dabi'u ("Gaskiya", "FALSE" da dai sauransu.) aiki Asusu suna la'akari kawai idan sun kasance ainihin jayayya ta gaba. Idan suna tsaye ne kawai a fannin takardar shaidar da ake magana a kai, to, mai aiki ba ya kula da su. Halin halin da ake ciki tare da rubutun rubutu na lambobi, wato, lokacin da aka rubuta lambobi a rubuce-rubuce ko kewaye da wasu haruffa. Haka kuma, idan sun kasance jayayya ta yau da kullum, sun shiga cikin lissafin, kuma idan sun kasance a kan takarda, to, basuyi.
Amma dangane da rubutu mai tsarki, wanda babu lambobi, ko maganganun ɓarna ("#DEL / 0!", #VALUE! Etc.) lamarin ya bambanta. Irin waɗannan ayyuka na ayyuka Asusu ba ya lissafi a kowace hanya.
Baya ga ayyuka Asusu kuma COUNT, ƙidaya yawan adadin Kwayoyin da suka haɗa da masu aiki COUNTES kuma COUNTERSILN. Tare da taimakon waɗannan ƙididdiga, za ka iya yin lissafi don la'akari da ƙarin yanayi. Wannan rukuni na masu amfani da ilimin lissafi sun kebanta da batun.
Darasi: Yadda za a lissafta yawan adadin da aka cika a cikin Excel
Darasi: Ayyukan ƙididdigar Excel
Hanyar 1: Wizard aikin
Ga mai amfani mara amfani, hanya mafi sauki don ƙidaya Kwayoyin dake dauke da lambobi suna amfani da tsari Asusu tare da taimakon Ma'aikata masu aiki.
- Muna danna kan tamanin maras amfani a kan takardar, wanda za'a nuna sakamakon sakamakon lissafi. Muna danna maɓallin "Saka aiki".
Akwai wani zaɓi na sake farawa. Ma'aikata masu aiki. Don yin wannan, bayan zaɓar cell, je zuwa shafin "Formulas". A tef a cikin asalin kayan aiki "Gidan Kayan aiki" danna maballin "Saka aiki".
Akwai wani zaɓi, mai yiwuwa mafi sauki, amma a lokaci guda yana buƙatar ƙwaƙwalwa mai kyau. Zaɓi tantanin halitta akan takardar kuma latsa maɓallin haɗin haɗin akan keyboard Shift + F3.
- A duk lokuta uku, taga zai fara. Ma'aikata masu aiki. Don zuwa jerin sassan jayayya "Labari"ko "Jerin jerin jerin sunayen" neman abu "Asusun". Zaɓi shi kuma danna maballin. "Ok".
Har ila yau, za'a iya kaddamar da taga ta wata hanya ta wata hanya. Zaɓi tantanin halitta don nuna sakamakon kuma je zuwa shafin "Formulas". A rubutun a cikin ƙungiyar saitunan "Gidan Kayan aiki" danna maballin "Sauran Ayyuka". Daga jerin da ke bayyana, motsa siginan kwamfuta zuwa matsayi "Labarin lissafi". A cikin menu da ya buɗe, zaɓi abu "Asusun".
- Gabatarwa ta fara farawa. Ƙwararren gardama na wannan ƙira zai iya zama darajar da aka wakilta a matsayin mahaɗi ko kuma kawai an rubuta shi a filin daidai. Duk da haka, fara da version na Excel 2007, waɗannan dabi'u zasu iya zama har zuwa 255. A cikin sassan farko akwai 30 kawai daga cikinsu.
Za'a iya shigar da bayanai a cikin filayen ta yin amfani da ƙayyadaddun dabi'u ko haɓakawa na sel daga cikin keyboard. Amma a tsarin daidaitawa yana da sauƙin sauƙaƙe siginan kwamfuta a cikin filin kuma zaɓi tantanin halitta mai dacewa ko layi a kan takardar. Idan akwai jeri da yawa, za'a iya shigar da adireshin na biyu a filin "Value2" da sauransu Bayan an shigar da dabi'u, danna kan maballin. "Ok".
- Sakamakon kirgawa kwayoyin da ke dauke da dabi'un lambobi a cikin zaɓin da aka zaɓa za a nuna a cikin wuri da aka ƙayyade a kan takardar.
Darasi: Wizard Function Wizard
Hanyar 2: Kira tare da Magana ta Ƙari
A cikin misalin da ke sama, mun dubi fitowar inda hujjojin ke nuna jigon fannoni. Yanzu bari mu yi la'akari da zabin lokacin amfani da dabi'un da aka shiga cikin kai tsaye a filin gwaji.
- Tare da kowane daga cikin zaɓuɓɓuka da aka bayyana a farkon hanya, gudanar da maƙallin bayanin aiki Asusu. A cikin filin "Value1" saka adreshin kewayon tare da bayanan, kuma a cikin filin "Value2" shigar da maganganun ma'ana "Gaskiya". Muna danna maɓallin "Ok"don yin lissafi.
- An nuna sakamakon a cikin yankin da aka zaɓa. Kamar yadda kake gani, shirin ya ƙididdige yawan adadin kwayoyin da lambobi na lambobi kuma ya kara da wani darajar adadin, wanda muka rubuta tare da kalma "Gaskiya" a cikin jayayya. Idan aka rubuta wannan magana a cikin tantanin halitta, kuma a cikin filin zai zama hanyar haɗi zuwa gare shi, to, baza a kara da shi ba.
Hanyar 3: Samfurin Magana Kan Gabatarwa
Baya ga yin amfani da Ma'aikata masu aiki da kuma jayayya, mai amfani zai iya shigar da magana da hannu a hannu a kowace takarda a cikin takardar ko a cikin tsari. Amma saboda wannan kana buƙatar sanin haɗin wannan afaretan. Ba abin wuya ba ne:
= SUM (Value1; Value2; ...)
- Shigar da dabara magana a cikin tantanin halitta. Asusu bisa ga fassararsa.
- Don ƙididdige sakamakon kuma nuna shi akan allon, danna maballin. Shigarsanya a kan keyboard.
Kamar yadda kake gani, bayan wadannan ayyuka, sakamakon lissafi yana nunawa a cikin cell da aka zaɓa. Ga masu amfani da gogaggen, wannan hanya zai iya zama mafi dacewa da sauri. Fiye da waɗanda suka gabata tare da kira Ma'aikata masu aiki da windows windows.
Akwai hanyoyi da dama don amfani da aikin. Asusuwanda babban aikinsa shine ƙidaya kwayoyin da ke dauke da bayanan lambobi. Amfani da wannan tsari, zaka iya shigar da ƙarin bayanan don lissafin kai tsaye a cikin maƙallin bayanin jigilar ko ta rubuta su kai tsaye zuwa tantanin halitta bisa ga haɗin aikin wannan afaretan. Bugu da ƙari, a cikin masu aiki na lissafi akwai wasu ƙwayoyin da ke cikin ƙididdige ƙwayoyin da aka cika a cikin zaɓin da aka zaba.
