Yadda ake ƙirƙirar lissafi da sauri a cikin Excel

Lokacin tattara tebur da kuma aiki akai-akai a cikin Excel, ba dade ko ba jima muna fuskantar matsalar ƙirƙirar jerin ƙididdiga. Akwai hanyoyi da yawa don ƙirƙirar, kowannensu za a tattauna dalla-dalla a cikin wannan labarin.

Hanyar lamba 1: Lissafi masu lambobi a cikin Excel don tantanin halitta ɗaya

Sau da yawa akwai yanayi lokacin da ya zama dole don dacewa da alamar alama da lissafin lissafin a cikin tantanin halitta ɗaya. Irin wannan buƙatar na iya tasowa saboda ƙarancin sarari don cike duk bayanan. Tsarin sanya harsashi ko jeri mai lamba a cikin tantanin halitta ɗaya tare da layin sanarwa:

1. Yi lissafin da za a ƙidaya. Idan an haɗa shi a baya, to, za mu ci gaba zuwa ƙarin ayyuka.

Bayanan kula daga gwani! Lalacewar wannan hanyar ita ce sanya lamba ko alamomi a cikin kowace tantanin halitta daban.

2. Kunna layin da ke buƙatar gyara kuma saita iyaka a gaban kalmar.
3. Je zuwa shafin "Saka" dake cikin taken shirin.

4. Nemo ƙungiyar kayan aiki "Alamomin" kuma ta danna kibiya, je zuwa taga da ke buɗewa. A ciki, danna kan kayan aikin "Symbol".

5. Na gaba, daga jerin da aka gabatar, kuna buƙatar zaɓar lamba ko alamar da kuke so, kunna alamar, sannan danna maɓallin "Saka".

Hanya #2: Lissafin Lambobi don Ƙungiyoyin Maɗaukaki

Irin wannan jerin za su yi kama da kwayoyin halitta, amma ya dace idan sararin samaniya a cikin tebur ya ba ka damar sanya ginshiƙai da yawa.

1. A cikin ginshiƙin farko da tantanin halitta na farko, rubuta lambar “1”.
2. Tsaya akan hannun cika kuma ja shi zuwa ƙarshen lissafin.
3. Don sauƙaƙe aikin cikawa, zaku iya danna alamar sau biyu. Zai cika ta atomatik.

4. A cikin lissafin ƙidaya, zaku iya ganin cewa alamar ta kwafi ƙimar dijital "1" a cikin duk layuka. Me za a yi a wannan yanayin? Don yin wannan, a cikin ƙananan kusurwar dama, za ku iya nemo kayan aikin Zaɓuɓɓukan Autofill. Ta danna alamar da ke kusurwar toshe, jerin zaɓuka zai buɗe, inda kake buƙatar zaɓar "Cika".

5. Sakamakon haka, jerin lambobi za a cika su ta atomatik tare da daidaitattun saitin lambobi.

Don sauƙaƙe cika lissafin ƙididdiga, kuna iya amfani da wata hanya:

1. Shigar da lambobi 1 da 2 a cikin sel biyu na farko na ginshiƙi, bi da bi.
2. Zaɓi duk sel masu alamar cika kuma sauran layuka za a cika ta atomatik.

Bayanin gwani! Kar a manta cewa lokacin shigar da lambobi, kuna buƙatar amfani da toshe lamba a gefen dama na madannai. Lambobin da ke saman ba su dace da shigarwa ba.

Hakanan zaka iya yin aikin iri ɗaya ta amfani da aikin autocomplete: = STRING(). Yi la'akari da misali na cika layuka tare da jeri da aka ba da oda ta amfani da aikin:

1. Kunna babban tantanin halitta inda jerin masu lamba zasu fara daga.
2. A cikin mashaya dabara, sanya alamar daidai "=" kuma rubuta aikin "ROW" da kanku ko nemo shi a cikin kayan aikin "Saka Aiki".
3. A ƙarshen dabarar, saita buɗaɗɗen buɗewa da rufewa don tantance kirtani ta atomatik.

4. Sanya siginan kwamfuta akan hannun cika tantanin halitta kuma ja shi ƙasa. Ko cika sel ta atomatik ta danna sau biyu. Ko da hanyar shigar da bayanai, sakamakon zai kasance iri ɗaya kuma zai cika jeri duka tare da jeri na ƙididdigewa daidai.

Hanyar lamba 3: yi amfani da ci gaba

Mafi kyawun zaɓi don cika manyan teburi tare da adadi mai ban sha'awa na layuka:

1. Don ƙididdigewa, yi amfani da toshe lambar da ke gefen dama na madannai. Shigar da ƙimar "1" a cikin tantanin halitta ta farko.

2. A cikin shafin "Gida" muna samun toshe "Editing". Danna kan triangle zai buɗe jerin zaɓuka. A can muka dakatar da zabi a kan layi "Ci gaba".
3. Wani taga zai buɗe inda, a cikin ma'aunin "Location", saita alamar zuwa matsayi "Ta ginshiƙai".
4. A cikin wannan taga, a cikin ma'aunin "Nau'in", bar alamar a matsayin "Arithmetic". Yawanci, an saita wannan matsayi ta tsohuwa.
5. A cikin filin kyauta "Mataki" mun tsara darajar "1".
6. Don ƙayyade ƙimar iyaka, kuna buƙatar saka a cikin filin da ya dace da adadin layin da ake buƙatar cika da lissafin ƙididdiga.

Bayanan kula daga gwani! Idan ba ku kammala mataki na ƙarshe ba, kuma ku bar filin "Limit Value", to, lambar atomatik ba za ta faru ba, tun da shirin ba zai san yawan layin da za a mayar da hankali ba.

Kammalawa

Labarin ya gabatar da manyan hanyoyi guda uku don ƙirƙirar jerin ƙididdiga. Hanyoyin 1 da 2 suna dauke da mafi mashahuri. A lokaci guda kuma, kowannensu ya dace don warware wasu nau'ikan ayyuka.