Lokacin aiki a cikin Excel, masu amfani a wasu lokuta suna fuskantar aikin zaɓi wani abu daga jerin kuma sanya shi ƙimar da aka ƙididdige bisa jigon shi. Aiki, wanda ake kira "CHEICE". Bari mu gano dalla-dalla yadda ake aiki da wannan ma'aikacin, da kuma matsalolin da zai iya magance ta.
Yin amfani da sanarwa na SELECT
Aiki KYAUTA ɓangare na masu aiki Tunani da Arrays. Manufarta ita ce samun wata ƙimar takamaiman a cikin ƙayyadadden tantanin halitta, wanda ya dace da lambar ƙididdiga a cikin wani ɓangaren akan takardar. Gaskiyar magana wannan bayanin ita ce:
= Zabi (index_number; darajar1; darajar2; ...)
Hujja Lambar Manuniya ya ƙunshi hanyar haɗi zuwa sel inda lambar serial ɗin take, wanda aka sanya rukuni na gaba na masu aiki da ƙima. Wannan lambar serial na iya bambanta daga 1 a da 254. Idan ka ƙididdige wani ɗan littafin da ya zarce wannan lambar, mai aiki zai nuna kuskure a cikin tantanin. Idan muka gabatar da darajar darajar jujjuyawar kamar wannan hujja, aikin zai gan shi a matsayin karamar lamba mafi kusanci da lambar da aka bayar. Idan ka tambaya Lambar Manuniyawanda babu wata hujja mai dacewa "Darajar", to, mai aiki zai dawo da kuskure zuwa tantanin.
Kungiyar rukuni na gaba "Darajar". Tana iya kaiwa da yawa 254 abubuwa. Ana buƙatar hujja "Darajar1". A cikin wannan rukunin muhawara, an nuna abubuwan da adadi wanda adadin jigon hujja na baya zai dace. Wannan shine, idan azaman hujja Lambar Manuniya lambar yabo "3", sannan zai dace da darajar da aka shigar a matsayin hujja "Darajar 3".
Daban-daban nau'ikan bayanan zasu iya yin aiki azaman dabi'u:
- Tunani
- Lissafi
- Rubutu
- Tsarin tsari
- Ayyuka, da sauransu.
Yanzu bari mu bincika takamaiman misalai na aikace-aikacen wannan mai aiki.
Misali na 1: jerin abubuwa masu aiki
Bari mu ga yadda wannan aikin ke aiki a cikin mafi kyawun misali. Muna da tebur da lamba daga 1 a da 12. Ya zama dole bisa ga lambobin serial da aka bayar ta amfani da aikin KYAUTA nuna sunan daidai watan a shafi na biyu na tebur.
- Zaɓi wayar farko da aka ɓoye a cikin shafi. "Sunan watan". Danna alamar "Saka aikin" kusa da layin tsari.
- Farawa Wizards na Aiki. Je zuwa rukuni Tunani da Arrays. Zaɓi suna daga jerin "CHEICE" kuma danna maballin "Ok".
- Shafin Hujja Mai Furewa Mai Aiki KYAUTA. A fagen Lambar Manuniya adireshin farkon sel na lambar lambobi ya kamata a nuna. Za'a iya yin wannan hanyar ta hanyar tuki a cikin masu gudanarwa da hannu. Amma zamuyi yadda yakamata. Mun sanya siginan kwamfuta a cikin filin kuma danna-danna hagu a kan sel mai dacewa a kan takardar. Kamar yadda kake gani, daidaitawa ana nunawa ta atomatik a fagen taga gardamar.
Bayan haka, dole ne muyi amfani da hannu zuwa cikin rukuni na filayen "Darajar" sunan watanni. Haka kuma, kowane filin dole ne ya yi daidai da wata na daban, wato a fagen "Darajar1" rubuta Janairua fagen "Darajar2" - Fabrairu da sauransu
Bayan kammala aikin da aka ƙayyade, danna kan maɓallin "Ok" a kasan taga.
- Kamar yadda kake gani, nan da nan a cikin tantanin da muka lura a farkon matakin, an nuna sakamakon, sunan Janairum zuwa ga lambar farko na watan shekara.
- Yanzu, don kada ku ringa shigar da dabara tare da sauran ƙwayoyin sel a cikin shafi "Sunan watan", dole ne mu kwafa shi. Don yin wannan, saita siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin halitta yana ɗauke da tsari. Alamar cike take bayyana. Riƙe maɓallin linzamin kwamfuta na hagu ka ja mai alamar mai ƙasa zuwa ƙarshen shafi.
- Kamar yadda kake gani, an kwafa dabarar zuwa kewayon da muke buƙata. A wannan yanayin, duk sunayen watannin da aka nuna a wayoyin sun dace da lambar sirrin su daga layin hagu.
Darasi: Mayan Maɗaukaki
Misali 2: bazuwar tsarin abubuwa
A magana ta daya, munyi amfani da tsari KYAUTAlokacin da aka tsara duk ƙididdigar lambobin ƙira zuwa tsari. Amma ta yaya wannan mai aikin zai yi aiki idan alamu na nuni sun hade kuma an maimaita su? Bari muyi la’akari da kwatancen tsarin aikin ɗalibi. Shafin farko na tebur yana nuna sunan ɗalibi, aji na biyu (daga 1 a da 5 maki), kuma a na uku dole ne muyi amfani da aikin KYAUTA ba da wannan ƙimar dace yanayin ("sharri sosai", "sharri", mai gamsarwa, kyau, kyau kwarai).
- Zaɓi sel na farko a cikin shafi "Bayanin" sannan ku bi hanyar da aka riga aka tattauna a sama, zuwa taga mai muhawara na mai aiki KYAUTA.
A fagen Lambar Manuniya saka hanyar haɗi zuwa allon farko na shafi "Grade"wanda ya theauke da ci.
Rukunin Field "Darajar" cika kamar haka:
- "Darajar1" - "Yayi sharri sosai";
- "Darajar2" - "Bad";
- "Darajar 3" - "Gamsuwa";
- "Darajar4" - Da kyau;
- "Darajar5" - "Madalla da gaske".
Bayan an gabatar da bayanan da ke sama, danna kan maɓallin "Ok".
- An nuna alamar ta farkon abu a cikin tantanin halitta.
- Don aiwatar da irin wannan hanya don ragowar abubuwan da ke cikin shafin, kwafa bayanai a cikin sel ta amfani da alamar cikewa, kamar yadda aka yi a Hanyar 1. Kamar yadda kake gani, wannan lokacin aikin yayi aiki daidai kuma yana nuna duk sakamakon daidai da algorithm ɗin da aka bayar.
Misali 3: amfani a hade tare da sauran masu gudanar da aiki
Amma ma'aikaci ya fi wadata KYAUTA za'a iya amfani dashi a hade tare da wasu ayyukan. Bari mu ga yadda ake yin wannan ta amfani da masu aiki azaman misali. KYAUTA da SAURARA.
Akwai tebur na siyarwa ta hanyar kantuna. An kasu gida biyu, kowane ɗayansu yayi dai-dai da takamaiman tsari. Ana nuna kudaden shiga daban don wani layin kwanan wata ta layi. Aikinmu shi ne tabbatar cewa bayan shigar da adadin kanti a cikin wani takarda na takardar, an nuna adadin kudaden shiga ga duk kwanakin shagon da aka ƙayyade. Don wannan zamu yi amfani da haɗin mahaɗan SAURARA da KYAUTA.
- Zaɓi wayar wanda sakamakon zai nuna a matsayin jimla. Bayan haka, danna kan gunkin da muka riga muka sani "Saka aikin".
- Ana kunna taga Wizards na Aiki. Wannan lokacin mun koma ga rukuni "Ilmin lissafi". Nemo ka kuma haskaka sunan SAURARA. Bayan haka, danna maɓallin "Ok".
- Farashin muhawara na aiki fara. SAURARA. Ana amfani da wannan ma'aikacin don ƙididdige adadin lambobin da ke cikin sel. Syntax mai sauki ce kuma madaidaiciya:
= SUM (lamba1; lamba2; ...)Wannan shine, muhawara ta wannan mai aikin yawanci lambobi ne, ko kuma, koda yaushe, hanyoyin shiga sel ne inda lambobin da za'a ƙara. Amma a cikin yanayinmu, hujja kawai ba lamba ce ba ce, ba mahaɗi ba ne, amma abubuwan da ke cikin aikin KYAUTA.
Sanya siginan kwamfuta a cikin filin "Lambar1". Sannan mun danna maballin, wanda aka nuna a matsayin alwati mai juyawa. Wannan gunkin yana cikin layi guda a sama kamar maɓallin. "Saka aikin" da layin tsari, amma zuwa hagun hagu. Lissafin kayan aikin da aka yi amfani da su kwanan nan ya buɗe. Tun da dabara KYAUTA kwanan nan wanda muke amfani da shi a cikin hanyar da ta gabata, to, yana kan wannan jerin. Saboda haka, kawai danna wannan abun don zuwa taga muhawara. Amma ya fi yiwuwa cewa ba za ku sami wannan suna a cikin jerin ba. A wannan yanayin, danna kan matsayin "Sauran sifofin ...".
- Farawa Wizards na Aikia cikin abin da Tunani da Arrays dole ne mu nemo sunan "CHEICE" da kuma nuna shi. Latsa maballin "Ok".
- Ana kunna yanayin bayanan muhawara na mai aiki. KYAUTA. A fagen Lambar Manuniya saka hanyar haɗi zuwa tantanin da ke cikin takardar wanda za mu shigar da adadin kanti don abin da ya biyo baya game da kuɗin shiga na gaba.
A fagen "Darajar1" buƙatar shigar da daidaitawar shafi "Mafita 1". Wannan abu ne mai sauki. Saita siginan kwamfuta zuwa filin da aka ambata. Bayan haka, riƙe maɓallin linzamin kwamfuta na hagu, zaɓi duk kewayon ƙwayoyin shafi "Mafita 1". Adireshin zai bayyana nan da nan a cikin taga muhawara.
Hakanan a fagen "Darajar2" columnara masu daidaita shafi "Kanti 2"a fagen "Darajar 3" - "Maki 3 na siyarwa", kuma a cikin filin "Darajar4" - "Kantuna 4".
Bayan kammala wadannan matakan, danna maballin "Ok".
- Amma, kamar yadda muke gani, tsarin yana nuna ƙimar kuskure. Wannan saboda gaskiyar cewa har yanzu ba mu shigar da adadin mashigar ba a cikin sel mai daidai.
- Shigar da lambar mashigar a cikin kwalin da aka yi niyyar waɗannan dalilai. Adadin kudaden shiga na shafi mai dacewa ana nuna shi nan da nan a cikin sashin takardar abin da aka saita.
Yana da mahimmanci a lura cewa zaka iya shigar da lambobi kawai daga 1 zuwa 4, wanda zai dace da yawan mashigar. Idan ka shigar da wani lamba daban, dabara zai sake ba da kuskure.
Darasi: Yadda za'a kirkiri adadin a Excel
Kamar yadda kake gani, aikin KYAUTA lokacin da aka yi amfani da shi daidai, zai iya zama mataimaki mai kyau sosai don kammala ayyukan da aka tsara. Lokacin da aka yi amfani dashi a hade tare da sauran masu gudanar da aikin, damar ta ƙara ƙaruwa.
