Asusun mai aiki yana nufin ayyukan ƙididdigar ƙididdiga. Babban aikinta shine yin lissafi a kan kewayon ƙayyadaddun sel da aka ƙayyade a cikin bayanan adadi ya ƙunshi. Bari mu kara koya daki daki daban-daban fannoni na aikace-aikacen wannan tsari.
Aiki tare da asusun mai aiki
Asusun aikin yana nufin babban rukuni na masu aiki na ƙididdiga, wanda ya haɗa da daruruwan abubuwa. Yana da kusanci da shi a cikin ayyukanku aikin asusun. Amma, ya bambanta da batun tattaunawarmu, ana ɗauka ne cikin sel na lissafi cike da kowane bayanai. Asusun mai aiki wanda zamu nuna cikakken tattaunawa yana haifar da sel kawai tare da bayanai a cikin lambobi mai lamba.Wadanne data dangantaka da lamba? Tabbas wannan yana cikin ainihin lambobin, kazalika da tsarin lokaci. Daliban dabaru ("Gaskiya", "Lie", da sauransu) Asusun aikin yana la'akari ne kawai lokacin da suke daidai da hujja kai tsaye. Idan suna cikin fannonin takardar, wanda aka ambata ta hanyar muhawara, to, a wannan yanayin mai aikin ba ya ɗaukar su cikin lissafi. A cikin wannan yanayin tare da wakilcin matakai, wato, lokacin da aka rubuta lambobin a cikin kwatancen ko kewaye da sauran alamun. Anan, kuma, idan suna kai tsaye hujja, suna shiga cikin kirga, kuma idan suke kan takarda kawai, ba su yarda ba.
Amma dangane da rubutu mai tsabta wanda lambobin ba su ne, ko ga irensious maganganu ("# na shari'o'in / 0!" Halin da ake ciki. Irin waɗannan dabi'u asusun ba la'akari a kowane nau'i.
Baya ga ayyukan, asusun da asusun da ke lissafin yawan adadin sel har yanzu yana da hannu a cikin masu aiki mita da kuma ƙididdigar aiki. Yin amfani da waɗannan dabarun, zaku iya ƙidaya ƙarin yanayi. Wannan rukunin masu aiki na ƙididdiga sun sadaukar da su zuwa wani darasi daban.
Darasi: Yadda ake kirawo adadin ciyawar da aka cika a eccele
Darasi: Ayyukan ƙididdiga a fice
Hanyar 1: Jagora na Ayyuka
Don mai amfani da ƙwarewa, yana da sauƙi a lissafa ƙwayoyin da ke ɗauke da lambobi ta amfani da hanyar amfani da maye.
- Danna kan tantanin wofi a kan takardar wanda sakamakon lissafin za a nuna shi. Danna kan "Manna Active".
Akwai wani zaɓi don fara maye na ayyuka. Don yin wannan, bayan zaɓi na tantanin halitta, kuna buƙatar zuwa shafin "tsari". A kan tef a cikin "Aikin Library" kayan aiki, danna aikin manna "maɓallin".
Akwai wani zaɓi, tabbas mafi sauƙi, amma a lokaci guda yana buƙatar kyakkyawan ƙwaƙwalwa. Muna haskaka tantanin a kan takardar kuma latsa hadewar maɓallin a kan juyawa + F3 Myboard.
- A cikin dukkanin shari'o'in guda uku, taga mai aiki zai fara. Don zuwa ta taga muhawara a cikin rukunin "ƙididdiga" ko "cikakken jerin haruffa" Muna neman kashi ". Muna haskaka shi kuma danna maɓallin "Ok".
Hakanan, za'a iya ƙaddamar da taga taga ta wata hanya. Muna haskaka tantanin halitta don nuna sakamakon kuma je zuwa shafin "tsari" shafin. A kan kintinkiri a cikin "aikin ɗakin aiki" Saubediti na "Sauran ayyuka". Daga jeri wanda ya bayyana, zaku kawo siginan zuwa matsayin "ƙididdiga". A cikin menu wanda ya buɗe, zaɓi abu "Account".
- GWAMNATIN GWAMNATAR. Magana kawai game da wannan dabara na iya zama darajar da aka gabatar a matsayin hanyar haɗi ko kawai rikodi a filin da ya dace. Gaskiya ne, fara daga Excel 2007, irin waɗannan dabi'u na iya zama har zuwa 255 haɗa. A farkon sigogin akwai kawai 30.
Kuna iya sanya bayanai a cikin saura ta hanyar buga takamaiman dabi'u ko daidaitawar kwayar halitta daga keyboard. Amma idan saita tsari ya fi sauƙi a shigar da siginan kwamfuta a cikin filin kuma zaɓi sel mai dacewa ko kewayon akan takardar. Idan cikin kewayon suna ɗan lokaci ne, adireshin na biyu ana iya amfani dashi a cikin filin "darajar" ", da sauransu. Bayan an jera dabi'un, danna maɓallin "Ok".
- Sakamakon kirtani na sel dauke da ƙimar adadi a cikin bangarancin da aka keɓe a cikin yankin na asali akan takardar.
Darasi: Ayyukan Wizard a Excel
Hanyar 2: Lissafi ta amfani da ƙarin muhawara
A cikin misalin da ke sama, munyi la'akari da batun lokacin da muhawara ke nasaba da takardar naúrar. Yanzu bari mu kalli zabin lokacin da dabi'un da aka rubuta kai tsaye a cikin filin muhawara ana kuma amfani.
- A kowane ɗayan zaɓuɓɓukan da aka bayyana a farkon hanyar, gudanar da taga game da aikin asusun. A cikin filin "darajar", saka adireshin kewayon kewayawa, kuma a cikin "darajar2" filin dace da magana mai ma'ana "gaskiya". Latsa maɓallin "Ok" don aiwatar da lissafin.
- An nuna sakamakon a yankin da aka zaɓa. Kamar yadda muke gani, shirin ya lissafta adadin sel tare da ƙimar lambobi kuma a cikin jimlar adadin da muka haɗa a gare su "gaskiya" a cikin gardamar lambu. Idan an yi wannan furci kai tsaye cikin sel, kuma a filin kawai za a iya zama hanyar haɗi zuwa gare ta, to, ba za a ƙara shi zuwa adadin ba.
Hanyar 3: GABATARWA GABATARWA
Baya ga amfani da Windows da Windows ta gardama, mai amfani zai iya shigar da magana game da kansa da hannu ga takarda ko a cikin kirtani. Amma ga wannan kuna buƙatar sanin syntax na wannan ma'aikacin. Ba shi da rikitarwa:
= Suff (darajar1; darajar2; ...)
- Mun gabatar da shi cikin sel bayyana na dabara bisa ga tsarin sa.
- Don ƙidaya sakamakon da fitarwa akan allon, danna maɓallin Shigar, sanya shi a kan keyboard.
Kamar yadda kake gani, bayan waɗannan ayyukan, ana nuna sakamakon lissafin akan allon a cikin tantanin da aka zaɓa. Don goguwa masu amfani, wannan hanyar na iya zama mafi dacewa da sauri. Fiye da na baya tare da kiran maye na ayyuka da taga muhawara.
Akwai hanyoyi da yawa don amfani da aikin asusun, babban aikin wanda yake kirga ƙwayoyin da ke ɗauke da lambobi. Tare da taimakon wannan dabara, ana iya yin ƙarin bayanai don yin lissafi a cikin filin gargajiya ko yin rikodin su kai tsaye cikin tantanin wannan ma'aikacin. Bugu da kari, a tsakanin masu aiki na ƙididdiga akwai wasu dabarun da aka tsara a cikin kayyadar sel a cikin kewayon da aka keɓe.