Mai aiki LABARI yana nufin ayyukan ƙididdiga na Excel. Babban aikinta shine a ƙididdige yawan takamaiman sel waɗanda ke ɗauke da bayanan lambobi. Bari mu ƙara koyo game da fannoni daban-daban na amfani da wannan dabara.
Aiki tare da mai ba da aiki ACCOUNT
Aiki LABARI yana nufin babban rukuni na manajan ƙididdiga, wanda ya haɗa da abubuwa kusan ɗari. Aikin yana da kusanci da shi a cikin ayyukansa LATSA. Amma, ba kamar batun tattaunawarmu ba, yana la'akari da ƙwayoyin sel cike da kowane irin bayanai. Mai aiki LABARI, wanda zamu gudanar da cikakkiyar tattaunawa game da shi, yana ƙididdige sel kawai cike da bayanai ta hanyar lambobi.
Wani irin bayanai suke adadi? Wannan ya hada da ainihin lambar, da kuma tsarin kwanan wata da lokaci. Boolean dabi'u ("GASKIYA", KARYA da sauransu) aiki LABARI la'akari da kawai lokacin da suke daidai da hujja ta kai tsaye. Idan suna cikin yankin takarda ne kawai wanda ake magana a kai, to, dillalai bai yi la'akari da su ba. Yanayi mai kama da wannan yana tare da wakiltar matani na lambobi, watau lokacin da aka rubuta lambobi cikin alamun zance ko wasu haruffa suka kewaye shi. Anan, kuma, idan sun kasance wata hujja ta kai tsaye, suna shiga cikin lissafin, kuma idan sun kasance a kan takardar, ba su.
Amma game da rubutu mai tsabta wanda babu lambobi, ko don maganganu marasa kuskure ("#DEL / 0!", #VALUE! Da sauransu) yanayin ya bambanta. Irin waɗannan dabi'un suna aiki LABARI ba ya lissafi ta kowace hanya.
Baya ga ayyuka LABARI da LATSA, kirga yawan adadin ƙwayoyin da aka cika har yanzu ana yin su ta hanyar masu aiki TAMBAYA da COUNTIMO. Ta amfani da waɗannan dabarun, zaku iya lissafin yin la'akari da ƙarin yanayi. Ana keɓance batun daban ga wannan rukunin masu aikin ƙididdiga.
Darasi: Yadda za'a kirkiri adadin cike sel a cikin Excel
Darasi: Ayyukan ƙididdiga a cikin Excel
Hanyar 1: Mayen aiki
Ga mai amfani da ƙwarewa, yana da sauƙi a ƙidaya sel da ke ɗauke da lambobi ta amfani da dabara LABARI tare da taimakon Wizards na Aiki.
- Mun danna wani faifan sel akan takarda wanda za'a nuna sakamakon lissafin. Latsa maballin "Saka aikin".
Akwai wani zaɓi na ƙaddamar. Wizards na Aiki. Don yin wannan, bayan zaɓar tantanin, je zuwa shafin Tsarin tsari. A kan kintinkiri a cikin akwatin kayan aiki Laburaren Ma’aikata danna maballin "Saka aikin".
Akwai wani zaɓi, mai yiwuwa mafi sauƙi, amma a lokaci guda yana buƙatar ƙuƙwalwa mai kyau. Zaɓi sel a kan takardar kuma danna maɓallin maɓallan akan maballin Canji + F3.
- A cikin duk ukun, taga zai fara Wizards na Aiki. Don zuwa taga muhawara a cikin rukuni "Kididdiga"ko "Cikakken jerin haruffa" neman kashi "LATSA". Zaɓi shi kuma danna maballin. "Ok".
Hakanan, za a iya buɗe taga hujja ta wata hanya. Zaɓi wayar don nuna sakamakon kuma je zuwa shafin Tsarin tsari. A kan kintinkiri a cikin rukunin saiti Laburaren Ma’aikata danna maballin "Sauran ayyukan". Daga lissafin da ya bayyana, matsar da siginan kwamfuta zuwa matsayi "Na lissafi". A menu na buɗe, zaɓi "LATSA".
- Daga nan sai taga gardamar ta fara. Hujjar kawai na wannan dabara na iya zama darajar da aka gabatar a matsayin hanyar haɗi ko a rubuce kawai a cikin filin da ya dace. Gaskiya ne, fara daga nau'in Excel 2007, irin waɗannan ƙimar na iya zama har zuwa 255 m. A farkon jujjuyawar akwai guda 30 kawai.
Kuna iya shigar da bayanai a cikin filayen ta hanyar buga takamaiman ƙimar ko abubuwan haɗin wayar daga cikin keyboard. Amma lokacin bugawa a cikin daidaitawa, yana da sauƙin sauƙaƙe saita siginan kwamfuta a cikin zaɓi kuma zaɓi tantanin da ya dace ko zangon akan takardar. Idan akwai lambobi da yawa, to adireshin na farkon su za'a iya shiga cikin filin "Darajar2" da sauransu Bayan an shigar da dabi'u, danna maballin "Ok".
- Sakamakon ƙidaya sel waɗanda ke da lambobi masu lamba a cikin zaɓin da aka zaɓa za a nuna su a cikin farkon yankin da aka ƙaddara akan takardar.
Darasi: Wizard ɗin Aiki a cikin Excel
Hanyar 2: Yi Amfani da Hujjar zaɓi zaɓi
A misalin da ke sama, mun bincika shari'ar lokacin da jayayya takamaiman nassi ne na jumlar takardar. Yanzu bari mu bincika wani zaɓi inda dabi'un suka shiga kai tsaye zuwa filin jayayya kuma ana amfani da su.
- Ta amfani da ɗayan zaɓuɓɓuka waɗanda aka bayyana a cikin hanyar farko, muna ƙaddamar da taga gardamar aikin LABARI. A fagen "Darajar1" nuna adireshin kewayon tare da bayanai, da kuma cikin filin "Darajar2" shigar da ma'ana "GASKIYA". Latsa maballin "Ok"don yin lissafin.
- Sakamakon yana bayyana a yankin da aka zaɓa. Kamar yadda kake gani, shirin ya kirkiri adadin sel tare da lambobi masu lamba kuma a cikin adadin da aka kara musu wani darajar, wanda muka yi rikodin tare da kalmar "GASKIYA" a cikin filin muhawara. Idan da aka rubuta wannan magana kai tsaye ga tantanin halitta, kuma hanyar haɗi kawai ce ta tsaya a filin, to ba za a ƙara yawan jimlar ba.
Hanyar 3: gabatarwar jagorar dabara
Baya ga amfani Wizards na Aiki kuma taga gardamar, mai amfani zai iya shigar da magana da hannu cikin kowace tantanin halitta a jikin takarda ko a mashin dabara. Amma saboda wannan kuna buƙatar sanin yadda ake sarrafa wannan mai aiki. Ba ya rikitarwa:
= SUM (Darajar1; Darajar2; ...)
- Shigar da magana da dabara a cikin tantanin halitta LABARI gwargwadon yadda yake magana.
- Don lissafta sakamakon kuma nuna shi akan allo, danna maɓallin Shigarsanya a kan keyboard.
Kamar yadda kake gani, bayan waɗannan ayyuka, sakamakon ƙididdigar ya nuna akan allon a cikin tantanin da aka zaɓa. Ga masu amfani da gogaggen, wannan hanyar na iya zama mafi dacewa da sauri. Fiye da waɗanda suka gabata tare da ƙalubalen Wizards na Aiki da kuma windows windows.
Akwai hanyoyi da yawa don amfani da aikin. LABARIwanda babban aikinsa shine kirgawa sel dauke da bayanan lambobi. Ta amfani da wannan tsari, zaku iya shigar da ƙarin bayanai don yin lissafi kai tsaye a fagen muhawara ta dabarar ko ta rubuta su kai tsaye zuwa cikin tantanin halitta daidai da yadda ake aiki da wannan mai aiki. Bugu da kari, tsakanin masu aikin ƙididdigar akwai wasu dabaru waɗanda ke ƙunshe cikin ƙididdigar ƙwayoyin da ke cike a cikin zaɓin da aka zaɓa.
