Lokacin aiki tare da tebur, yana da yawa wajibi ne don ƙididdige ginshiƙai. Hakika, ana iya yin haka da hannu, ta hanyar shigar da lambar don kowane shafi daga keyboard. Idan akwai ginshiƙai masu yawa a teburin, zai dauki lokaci mai yawa. A cikin Excel akwai kayan aikin musamman waɗanda ke ba da dama don ƙidayawa da sauri. Bari mu ga yadda suke aiki.
Hanyar ƙidaya
Akwai zaɓuɓɓuka masu yawa don lissafi na atomatik a Excel. Wasu daga cikinsu suna da sauƙi da bayyana, wasu suna da wuyar fahimta. Bari mu dubi kowane ɗayan su daki-daki don ƙayyade wane zaɓi don amfani da ƙwarewa a cikin wani akwati.
Hanyar 1: Cika Alamar
Hanyar da ta fi dacewa a kan ginshiƙan lambobi ta atomatik shine, ba shakka, yin amfani da alamar cikawa.
- Bude tebur. Ƙara wani layi zuwa gare shi, wanda za'a sanya adadin ginshiƙai. Don yin wannan, zaɓi kowane ɓangaren jere wanda zai kasance a ƙasa da lambar lambobi, dama-dama, don haka kiran wuri na mahallin. A cikin wannan jerin, zaɓi abu "Manna ...".
- Ƙaramar shigarwa ta buɗe. Matsar da canjin zuwa matsayi "Ƙara layi". Muna danna maɓallin "Ok".
- Saka lambar a cikin tantanin farko na layin da aka kara "1". Sa'an nan kuma motsa siginan kwamfuta zuwa kusurwar dama na wannan tantanin halitta. Mai siginan kwamfuta ya juya zuwa gicciye. An kira shi alamar cika. A lokaci guda riƙe da maɓallin linzamin hagu kuma maɓallin Ctrl a kan keyboard. Jawo mai cikawa zuwa dama zuwa ƙarshen tebur.
- Kamar yadda kake gani, layin da muke bukata yana cike da lambobi domin. Wato, an ƙidaya ginshiƙai.
Zaka kuma iya yin wani abu dabam. Cika jimloli na biyu na jigon da aka haɗa tare da lambobi. "1" kuma "2". Zaɓi duka Kwayoyin. Saita siginan kwamfuta a kusurwar dama na kusurwar dama. Tare da maɓallin linzamin linzamin kwamfuta da aka ajiye a ƙasa, zamu jawo makaman cikawa zuwa ƙarshen tebur, amma wannan lokaci akan maɓallin Ctrl babu buƙatar latsa. Sakamakon zai zama daidai.
Kodayake tsarin farko na wannan hanya ya fi sauƙi, amma, duk da haka, masu amfani da yawa sun fi son amfani da na biyu.
Akwai wani zaɓi don amfani da alamar cika.
- A cikin wayar farko, rubuta lamba "1". Amfani da alamar mažallacin abun ciki zuwa dama. A lokaci guda kuma maɓallin Ctrl babu buƙatar matsawa.
- Bayan an gama kwafin, mun ga cewa dukan layin ya cika da lambar "1". Amma muna buƙatar adadi domin. Danna kan gunkin da ya bayyana kusa da tantanin sallar da aka fi kwanan nan. Jerin ayyukan ya bayyana. Mun shigar da canjin zuwa matsayin "Cika".
Bayan haka, dukkanin jinsunan da aka zaɓa za su cika da lambobi domin.
Darasi: Yadda za a yi ba da kyauta a Excel
Hanyar 2: Ƙidaya tare da maɓallin "Cika" a kan rubutun
Wata hanya zuwa ginshiƙai lambobi a Microsoft Excel ya shafi yin amfani da maballin "Cika" a kan tef.
- Bayan an ƙara jere a lambar ginshiƙai, shigar da lambar a cikin wayar farko "1". Zaɓi dukan jere na tebur. Duk da yake a cikin shafin "Home", danna maballin akan rubutun. "Cika"wanda aka samo a cikin kayan aiki Ana gyara. Kayan menu mai saukewa ya bayyana. A ciki, zaɓi abu "Ci gaba ...".
- Maɓallin saitin ci gaba ya buɗe. Duk sigogi da ya kamata a riga an saita shi ta atomatik kamar yadda muke bukata. Duk da haka, ba zai zama da komai ba don duba matsayin su. A cikin toshe "Location" dole ne a saita canza zuwa matsayi "A cikin layuka". A cikin saiti "Rubuta" dole ne a zaɓa "Arithmetic". Dole ne a kashe maɓallin saurar atomatik. Wato, ba wajibi ne a sanya kasan a kusa da sunan saitin daidai ba. A cikin filin "Mataki" duba cewa lambar ta kasance "1". Field "Ƙimar ƙimar" dole ne komai. Idan kowane sigogi ba daidai ba ne tare da wurare da aka buga a sama, to, kuyi saitin bisa ga shawarwarin. Bayan ka tabbatar cewa duk sigogi sun cika a daidai, danna maɓallin. "Ok".
Bayan haka, za a ƙidaya ginshiƙan teburin.
Ba za ku iya zaɓar dukan jeri ba, amma kawai saka lambar a cikin wayar farko "1". Sa'an nan kuma kira maɓallin saitin ci gaba a daidai wannan hanya kamar yadda aka bayyana a sama. Duk sigogi dole ne ya dace da waɗanda muka yi magana game da baya, sai dai filin "Ƙimar ƙimar". Ya kamata sanya lambar ginshiƙai a cikin tebur. Sa'an nan kuma danna maballin "Ok".
Ciko za a yi. Zaɓin na ƙarshe shine mai kyau ga Tables tare da babban adadin ginshiƙai, tun lokacin amfani da shi, ba'a buƙatar mai siginan kwamfuta a ko'ina.
Hanyar 3: COLUMN aiki
Hakanan zaka iya lissafin ginshiƙai ta amfani da aikin musamman, wanda ake kira COLUMN.
- Zaɓi tantanin halitta wanda lambar ya kamata "1" a cikin shafi na lamba. Danna maballin "Saka aiki"sanya a hagu na dabarun bar.
- Yana buɗe Wizard aikin. Ya ƙunshi jerin ayyuka daban-daban na Excel. Muna neman sunan "STOLBETS"zaɓi shi kuma danna maballin "Ok".
- Ƙungiyar shawara ta buɗewa ta buɗe. A cikin filin "Laya" Dole ne ku bayar da hanyar haɗi zuwa kowace tantanin halitta a cikin shafi na farko na takardar. A wannan mahimmanci, yana da mahimmanci a kula, musamman idan takaddun farko na teburin ba shine shafi na farko na takardar ba. Adireshin mahaɗin zai iya shiga da hannu Amma yana da sauƙin yin wannan ta hanyar kafa siginan kwamfuta a filin. "Laya"sannan kuma danna kan tantanin da aka so. Kamar yadda ka gani, bayan haka, ana nuna alamunta a fagen. Muna danna maɓallin "Ok".
- Bayan waɗannan ayyukan, adadin yana bayyana a cikin cell da aka zaɓa. "1". Don karanta dukan ginshiƙan, mun zama a cikin kusurwar dama na dama da kuma kira alamar cika. Kamar yadda a cikin lokuta na baya, zamu ja shi zuwa dama ta ƙarshen tebur. Latsa maɓallin Ctrl Babu buƙatar, kawai danna maɓallin linzamin linzamin dama.
Bayan yin duk ayyukan da aka sama, duk ginshiƙan teburin za a iya ƙidaya.
Darasi: Wizard Function Wizard
Kamar yadda kake gani, ana iya lissafin ginshiƙai a cikin Excel a hanyoyi da dama. Mafi shahararrun wadannan shine amfani da alamar cika. A cikin ɗakuna masu yawa, yana da ma'ana don amfani da maballin. "Cika" tare da sauyawa zuwa saitunan ci gaba. Wannan hanya ba ya haɗa da yin amfani da mai siginan kwamfuta ta hanyar dukkanin takardar. Bugu da ƙari, akwai aikin musamman COLUMN. Amma saboda ƙwarewar amfani da basira, wannan zaɓi ba shi da kyau har ma a tsakanin masu amfani. Ee, kuma wannan hanya yana daukar lokaci fiye da yadda ake amfani da alamar cikawa.
