Lokacin aiki a cikin Excel, masu amfani sukan gamsu da aiki na zaɓar daga lissafin wani takamaiman sashi kuma suna sanya ƙimar da aka ƙayyade bisa ga fassarar. Wannan aikin ya dace da shi ta hanyar aikin da ake kira "SELECT". Bari mu koyi dalla-dalla yadda za mu yi aiki tare da wannan afaretan, da kuma matsalolin da zai iya magance.
Mai amfani yayi amfani da SELECT
Yanayi Zaba yana cikin nau'in masu aiki "Hanyoyin sadarwa da zane-zane". Manufarta ita ce ta samo wani adadi mai mahimmanci a cikin tantanin halitta wanda aka ƙayyade, wanda ya dace da lambar index a wani ɓangaren a kan takardar. Maganar wannan bayani shine kamar haka:
= SELECT (index_number; value1; value2; ...)
Magana "Halin lambar" yana dauke da tunani akan tantanin halitta inda aka saita lambar tsararren kashi, wanda aka tsara wa ɗayan ƙungiyoyinsu na musamman. Wannan nau'in jerin zai iya bambanta daga 1 har zuwa 254. Idan ka ƙayyade index mafi girma daga wannan lambar, mai nuna aiki yana nuna kuskure a tantanin halitta. Idan an shigar da ƙimar ƙwararri a matsayin shaida mai ba da shawara, aikin zai gane shi a matsayin adadin lamba mafi kusa da lambar da aka ba su. Idan an saita "Halin lambar"wanda babu wata hujja da ta dace "Darajar", mai aiki zai dawo kuskure zuwa tantanin halitta.
Ƙungiyar muhawara ta gaba "Darajar". Ta iya kai yawan 254 abubuwa. Ana buƙatar hujja. "Value1". A cikin wannan rukuni, ƙayyade dabi'un da za su dace da lambar index na gardamar da ta gabata. Wato, idan a matsayin hujja "Halin lambar" faranta lambar "3", to, zai dace da darajar da aka shigar a matsayin hujja "Value3".
Ƙididdiga na iya zama daban-daban iri bayanai:
- Links;
- Lambobi;
- Rubutu;
- Formulas;
- Ayyuka, da dai sauransu.
Yanzu bari mu dubi wasu misalai na amfani da wannan afaretan.
Misali na 1: tsarin zane na abubuwa
Bari mu ga yadda wannan aikin yake aiki a mafi misali. Muna da tebur tare da lambobi daga 1 har zuwa 12. Ya zama dole bisa ga lambobin lambobi ta amfani da aikin Zaba nuna sunan watan daidai a shafi na biyu na tebur.
- Zaɓi maɓallin sakonni na farko. "Sunan watan". Danna kan gunkin "Saka aiki" kusa da wannan tsari.
- Kaddamarwa Ma'aikata masu aiki. Je zuwa category "Hanyoyin sadarwa da zane-zane". Mun zaɓa daga jerin sunayen "SELECT" kuma danna maballin "Ok".
- Maƙallin bayanin mai aiki ya fara. Zaba. A cikin filin "Halin lambar" Dole ne a nuna adireshin farkon tantanin halitta a cikin jerin lambobi. Wannan hanya za a iya aikata ta shigar da hannu ta hanyar hannu. Amma za mu yi mafi dacewa. Sanya siginan kwamfuta a filin kuma danna maballin hagu na hagu a kan tantanin salula a kan takardar. Kamar yadda kake gani, ana nuna adreshin ta atomatik a filin filin kwance.
Bayan haka, zamu buƙaɗa hannu cikin rukunin filayen "Darajar" sunan watanni. Bugu da ƙari, kowane filin dole ne ya dace da wata na dabam, wato, a filin "Value1" Rubuta "Janairu"a cikin filin "Value2" - "Fabrairu" da sauransu
Bayan kammala wannan aiki, danna maballin. "Ok" a kasan taga.
- Kamar yadda kake gani, nan da nan a cikin tantanin halitta da muka lura a farkon aikin, an nuna sakamakon, wato sunan "Janairu"daidai da lambar farko ta watan shekara.
- Yanzu, ba tare da hannu shigar da samfurin ga dukan sauran Kwayoyin na shafi "Sunan watan", dole mu kwafi shi. Don yin wannan, shigar da siginan kwamfuta a kusurwar dama na cell dauke da wannan tsari. Alamar cika alama ta bayyana. Riƙe maɓallin linzamin hagu kuma ja mai cikawa har zuwa ƙarshen shafi.
- Kamar yadda kake gani, an tsara wannan maƙala zuwa layin da ake so. A wannan yanayin, dukan sunayen watanni da suka bayyana a cikin sel sunyi daidai da lambar su daga shafi zuwa hagu.
Darasi: Maɓallin aiki na Excel
Misali 2: Tsarin tsaka-tsaki na abubuwa
A cikin akwati na baya, mun yi amfani da wannan tsari Zabalokacin da aka shirya dukkan lambobin lissafi domin. Amma ta yaya wannan bayanin ya yi aiki idan an haɗu da dabi'un da aka ƙayyade? Bari mu dubi wannan a kan misali na teburin tare da aikin yara. Shafin farko na teburin ya nuna sunan mai suna na karshe, na biyu (daga 1 har zuwa 5 maki), kuma a cikin na uku dole muyi amfani da aikin Zaba bayar da wannan kwarewa mai dacewa halayyar ("muni sosai", "mugun", "mai gamsarwa", "mai kyau", "mai kyau").
- Zaɓi sel na farko a shafi. "Bayani" kuma tafi tare da taimakon hanyar, wadda aka riga aka tattauna a sama, a cikin taga na muhawarar ma'aikata Zaba.
A cikin filin "Halin lambar" saka mahaɗin zuwa maɓallin farko na shafi "Bincike"wanda ya ƙunshi ci.
Ƙungiyar filin "Darajar" cika hanyar da ake biyowa:
- "Value1" - "Ba daidai ba";
- "Value2" - "Mara kyau";
- "Value3" - "Gaskiya";
- "Value4" - "Mai kyau";
- "Value5" - "Mai kyau".
Bayan gabatarwar bayanan da aka sama, danna kan maballin "Ok".
- Dalili na farko an nuna shi a cikin tantanin halitta.
- Domin yin irin wannan hanya don sauran abubuwan da aka rage a cikin shafi, zamu kwafi bayanai a jikinta ta amfani da alamar cika, kamar yadda aka yi a Hanyar 1. Kamar yadda ka gani, wannan lokaci aikin ya yi daidai da fitarwa duk sakamakon sakamakon daidai algorithm.
Misali 3: amfani da haɗin tare da wasu masu aiki
Amma mafi yawan masu aiki mai yawa Zaba za a iya amfani dashi tare da sauran ayyuka. Bari mu ga yadda aka yi wannan misali ta hanyar amfani da masu aiki Zaba kuma SUM.
Akwai tebur na tallace-tallace na samfurori ta wurin kantuna. An raba shi zuwa ginshiƙai huɗu, kowannensu ya dace da takamaiman bayani. Ana nuna alamun kuɗi daban don wani kwanan wata ta layi. Ayyukanmu shine tabbatar da cewa bayan shigar da lambar fitarwa a cikin wani tantanin halitta na takardar, yawan adadin kuɗi na duk kwanakin aiki na kantin da aka kayyade yana nunawa. Don wannan za mu yi amfani da haɗin masu aiki SUM kuma Zaba.
- Zaɓi tantanin halitta wanda za'a nuna sakamakon a matsayin jimla. Bayan haka, danna kan gunkin da ya saba da mu. "Saka aiki".
- Window aiki Ma'aikata masu aiki. A wannan lokacin muna matsawa zuwa rukunin "Ilmin lissafi". Nemi kuma zaɓi sunan "SUMM". Bayan wannan latsa maɓallin "Ok".
- Maganin muhawarar aiki ta fara. SUM. Ana amfani da wannan afaretan don ƙididdige yawan adadin lambobi a cikin takaddun jumloli. Ƙaƙidarta tana da sauki kuma mai sauƙi:
= SUM (lamba1; number2; ...)Wato, muhawarar wannan afaretan yana yawanci lambobi, ko, mafi sau da yawa, nassoshi akan sel inda za'a tara lambobi. Amma a yanayinmu, hujjar kawai bata da lamba ko hanyar haɗi ba, amma abinda ke cikin aikin. Zaba.
Saita siginan kwamfuta a filin "Number1". Sa'an nan kuma danna kan gunkin, wanda aka nuna a matsayin alamar inverted. Wannan icon yana samuwa a cikin jeri na kwance a matsayin maɓallin. "Saka aiki" da kuma maɓallin tsari, amma zuwa hagu daga gare su. Jerin ayyukan amfani da kwanan nan ya buɗe. Tun da dabara Zaba kwanan nan muka yi amfani da ita a hanyar da ta gabata, yana a kan wannan jerin. Saboda haka, ya isa ya danna kan wannan sunan don zuwa jigon gardama. Amma mafi kusantar cewa ba za ku sami wannan suna cikin jerin ba. A wannan yanayin, kana buƙatar danna kan matsayin "Sauran fasali ...".
- Kaddamarwa Ma'aikata masu aikiwanda a cikin sashe "Hanyoyin sadarwa da zane-zane" dole ne mu sami sunan "SELECT" da kuma haskaka shi. Danna maballin "Ok".
- An kunna maɓallin ƙwaƙwalwar mai aiki. Zaba. A cikin filin "Halin lambar" saka hanyar haɗi zuwa tantanin halitta na takardar, wanda za mu shigar da adadin maɓallin don nunawa na gaba game da adadin kudaden shiga.
A cikin filin "Value1" Dole ne ku shigar da daidaitattun shafi "1 aya na sayarwa". Yi shi mai sauki. Saita siginan kwamfuta a filin da aka kayyade. Sa'an nan kuma, riƙe da maballin hagu na hagu, zaɓi dukan sakin layi na shafi "1 aya na sayarwa". Adireshin yana nan da nan a nuna a cikin muhawarar muhawara.
Hakazalika a filin "Value2" Ƙara haɗin shafi "Maki 2 na sayarwa"a cikin filin "Value3" - "3 batu na sayarwa"da kuma a filin "Value4" - "Maki 4 na sayarwa".
Bayan yin waɗannan ayyuka, danna kan maballin "Ok".
- Amma, kamar yadda muka gani, wannan tsari yana nuna darajan kuskure. Wannan shi ne saboda gaskiyar cewa ba mu riga mun shiga adadin shigarwa a cikin cell da ya dace ba.
- Shigar da lambar adadin a cikin wayar da aka sanya. Adadin kudaden shiga ga shafi na daidai zai bayyana a cikin takardar shaidar da aka tsara ta.
Yana da muhimmanci a lura cewa za ku iya shigar da lambobi daga 1 zuwa 4, wanda zai dace da lambar fitarwa. Idan ka shigar da wani lambar, ma'anar ta sake bada kuskure.
Darasi: Yadda za a tantance adadin a Excel
Kamar yadda kake gani, aikin Zaba idan aka yi amfani dashi, zai iya zama mai taimako mai kyau ga ayyuka. Idan aka yi amfani da shi tare da wasu masu aiki, ana iya karuwa sosai.
