Yadda za a toshe lamba a kan iPhone

Wani lokaci kafin masu amfani da Excel ya zama tambaya yadda za a ƙara yawan adadin yawan ginshiƙai? Ayyukan ya fi mahimmanci idan waɗannan ginshiƙai ba a cikin guda ɗaya ba, amma an warwatse. Bari mu kwatanta yadda za'a tara su a hanyoyi daban-daban.

Ƙarin shafi

Ƙididdige ginshiƙai a cikin Excel ya faru ne bisa ga ka'idodin ka'idodin ƙarin bayanai a cikin wannan shirin. Tabbas, wannan hanya tana da wasu abubuwa, amma sun kasance kawai na bin doka. Kamar sauran taƙaicewa a cikin wannan na'ura mai kwakwalwa, za'a iya yin ɗakunan ginshiƙai ta amfani da mahimman lissafi, ta yin amfani da aikin Excel mai ginawa SUM ko takalmin mota.

Darasi: Ƙidaya ƙidayar a Excel

Hanyar 1: Yi amfani da Ƙungiyar Hoto

Da farko, bari mu dubi yadda za mu daidaita ginshiƙan a cikin Excel tare da taimakon kayan aiki kamar kamfani na mota.

Alal misali, ɗauka teburin, wanda ke gabatar da kuɗin kuɗi biyar a cikin kwana bakwai. Bayanai don kowane kantin sayar da shi yana cikin wani shafi. Ayyukanmu shine mu gano cikakken kudin shiga na waɗannan kantuna don lokacin da aka nuna a sama. Saboda wannan dalili, kawai buƙatar ninka shafi.

1. Domin gano cikakken kudaden shiga na kwana bakwai na kowane ɗakin ajiya, muna amfani da jakar mota. Zaɓi siginan kwamfuta tare da maɓallin linzamin kwamfuta na hagu danna a cikin shafi "Shop 1" duk abubuwan da ke da lambobi na lambobi. Sa'an nan, zama a shafin "Gida", danna kan maɓallin "Tsarin"wanda aka samo a kan rubutun a cikin ƙungiyar saitunan Ana gyara.



2. Kamar yadda ka gani, yawan kudin shiga na kwanaki 7 a farkon fitarwa za a nuna shi a cikin tantanin halitta a ƙarƙashin shafi.



3. Muna gudanar da wannan aikin, ana amfani da ƙa'idodin mota da sauran ginshiƙan da ke dauke da bayanai akan kudaden ajiyar kuɗi.

   Idan akwai ginshiƙai masu yawa, to, yana yiwuwa kada a lissafta kowane ɗayan su adadin kuɗi daban. Muna amfani da alamar cika don kwafin dabarun da ke ƙunshi nauyin mota don farawa na farko zuwa sauran ginshiƙan. Zaži madaurar da aka samo asalin. Matsar da siginan kwamfuta zuwa kasan dama dama. Ya kamata a tuba zuwa alamar cika, wanda yayi kama da gicciye. Sa'an nan kuma mu danna maɓallin linzamin hagu na dama kuma mu jawo cikawa a layi tare da sunan shafi har zuwa ƙarshen tebur.



4. Kamar yadda kake gani, dabi'u na kudaden ajiyar kuɗi na kwana bakwai don kowane ɗayan mahimmiyar lissafi.



5. A yanzu muna buƙatar ƙara tare da sakamakon da aka samu na kowane ɗayan. Ana iya yin hakan ta hanyar wannan fanti guda. Yi zaɓi tare da siginan kwamfuta tare da maɓallin linzamin hagu ya ajiye dukkanin jikin da yawan adadin kuɗi na ɗayan keɓaɓɓun ɗakin yana samuwa, kuma baya kuma mun ɗauka wani ɓangaren maras kyau a hannun dama na su. Sa'an nan kuma danna danna kan gunkin da aka saba da mu a kan rubutun.



6. Kamar yadda ka gani, yawan kuɗin kuɗi na duk kunduna na kwanaki bakwai za a nuna a cikin ɗakin maras, wadda aka kasance a hagu na tebur.

Hanyar Hanyar 2: Yi amfani da matakan ilimin lissafi

Yanzu bari mu ga yadda za a taƙaita ginshiƙan teburin, yin amfani da wadannan dalilai ne kawai daɗaɗɗen tsari. Alal misali, zamu yi amfani da wannan tebur wanda aka yi amfani dashi don bayyana hanyar farko.

1. Kamar lokaci na ƙarshe, da farko, muna bukatar mu kirga yawan adadin kuɗi don kwana bakwai na kowane kantin sayar da daban. Amma zamuyi wannan a cikin hanya daban daban. Zaɓi madogarar maraƙi ta farko a ƙarƙashin shafi. "Shop 1"kuma shigar da alamar a can "=". Kusa, danna maɓallin farko na wannan shafi. Kamar yadda kake gani, ana nuna adreshinsa a cikin tantanin halitta don adadin. Bayan haka mun sanya alama "+" daga keyboard. Kusa, danna maɓallin na gaba a cikin wannan shafi. Sabili da haka, nassoshi masu mahimmanci game da abubuwa na takarda tare da alamar "+", zamu sarrafa dukkan sassan kundin shafi.

   A cikin yanayinmu na musamman, mun sami wannan maƙirarin:

   = B2 + B3 + B4 + B5 + B6 + B7 + B8

   Hakika, a kowane hali zai iya bambanta dangane da wurin da teburin a kan takardar da lambar yawan kwayoyin a shafi.



2. Bayan an shigar da adiresoshin duk abubuwan da ke cikin shafi, don nuna sakamakon sakamakon kudin shiga na kwanaki 7 a farkon fitarwa, danna maballin Shigar.



3. Sa'an nan kuma za ku iya yin haka don sauran shaguna guda huɗu, amma zai zama sauƙi da sauri don tattara bayanai a wasu ginshiƙai ta amfani da alamar cika daidai daidai yadda muka yi a cikin hanyar da ta gabata.



4. Yanzu ya zama don mu sami adadin ginshiƙai. Don yin wannan, zaɓi wani nau'i maras kyau a kan takardar, wanda muke shirya don nuna sakamakon, sa'annan mu sanya alamar ta "=". Sa'an nan kuma muka ƙara sel wanda yawancin ginshiƙai, wanda muka ƙidaya a baya, ana samuwa.

   Muna da wannan maƙirarin:

   = B9 + C9 + D9 + E9 + F9

   Amma wannan mahimmanci kuma mutum ne ga kowane hali.



5. Domin samun sakamakon gaba na ƙarin ginshiƙai, danna kan maballin. Shigar a kan keyboard.

Ba zai yiwu ba a lura cewa wannan hanyar yana ɗaukan lokaci kuma yana buƙatar karin ƙoƙari fiye da baya, tun da yake yana ɗauka cewa don samar da adadin kudin shiga, zai zama wajibi don sake danna kowane tantanin halitta wanda ya buƙaci a yi masa layi. Idan akwai mai yawa layuka a teburin, to wannan hanya zai iya zama mai ban sha'awa. A lokaci guda, wannan hanya yana da amfani marar amfani: sakamakon zai iya zama fitarwa ga kowane ɗakin maras amfani a takardar da mai amfani ya zaɓa. Lokacin amfani da jakar mota, babu irin wannan yiwuwar.

A aikace, waɗannan hanyoyi guda biyu za'a iya haɗuwa. Alal misali, tamping up totals a cikin kowane shafi daban ta amfani da sumba na auto, da kuma samun cikakken darajar ta amfani da mahimman lissafi a cikin tantanin halitta akan takardar da mai amfani ya zaɓa.

Hanyar 3: Yi amfani da SUM aiki

Ana iya kawar da rashin amfani da hanyoyi biyu da suka gabata ta amfani da aikin Excel da aka gina SUM. Dalilin wannan afaretan shine ainihin ƙayyade lambobi. Yana da nau'i na ayyuka na ilmin lissafi kuma yana da hanyar daidaitawa mai sauƙi:

= SUM (lamba1; number2; ...)

Ƙididdigar, wanda yawanta zai iya zuwa 255, sune lambobi masu yawa ko adiresoshin cell, inda suke.

Bari mu ga yadda ake amfani da wannan aikin Excel ta hanyar yin amfani da misali na ɗakin kudin shiga guda biyar a cikin kwanaki bakwai.

1. Mun yi alama akan wani nau'i a kan takardar da za a nuna adadin kudin shiga a shafi na farko. Danna kan gunkin "Saka aiki"wanda yake a gefen hagu na tsari.



2. An yi kunnawa Ma'aikata masu aiki. Kasance a cikin rukuni "Ilmin lissafi"neman sunan "SUMM"Yi zabinsa kuma danna maballin "Ok" a kasan wannan taga.



3. Ƙaddamarwa da ginin gwajin aiki. Zai iya samun har zuwa 255 filayen da sunan "Lambar". Wadannan wurare suna dauke da muhawarar aiki. Amma saboda yanayinmu daya filin zai isa.

   A cikin filin "Number1" kana so ka sanya daidaitattun layin da ke dauke da sassan jikin "Shop 1". An yi haka ne sosai. Sanya siginan kwamfuta a filin filin muhawara. Kusa, ta latsa maɓallin linzamin hagu, zaɓi dukkanin sel a cikin shafi. "Shop 1"wanda ya ƙunshi lambobi na lambobi. An gabatar da adireshin nan da nan a cikin akwatin jigilarwa kamar yadda ake gudanarwa. Danna maballin "Ok" a kasan taga.



4. Za a nuna darajar abin da aka samu na kwana bakwai don kantin sayar da farko a cikin tantanin salula da ke dauke da aikin.



5. Sa'an nan kuma za ka iya yin irin waɗannan ayyukan tare da aikin SUM da kuma sauran ginshiƙan teburin, tare da ƙidaya yawan adadin kuɗi na kwana bakwai don tsararru daban-daban. Ayyukan algorithm na aiki zasu kasance daidai kamar yadda aka bayyana a sama.

   Amma akwai wani zaɓi don sauƙaƙe aikin. Don yin wannan, muna amfani da wannan alamar cika. Zaɓi tantanin halitta wanda ya riga ya ƙunshi aikin. SUM, da kuma shimfiɗa alamar alama a layi daya zuwa ginshiƙan ginshiƙai zuwa ƙarshen tebur. Kamar yadda kake gani, a wannan yanayin, aikin SUM kofe su a cikin hanyar da muka buga a cikin wani nau'i mai ilimin lissafi.



6. Bayan haka, zaɓar wayar da ba'awa a kan takardar, wanda muke ɗauka don nuna sakamakon jimlar lissafi ga dukan ɗakunan ajiya. Kamar yadda a cikin hanyar da ta riga ta gabata, zai iya zama wani takarda na kyauta. Bayan haka, a hanyar da aka sani, muna kira Wizard aikin da kuma motsawa a cikin maƙallin gwajin aiki SUM. Dole mu cika filin "Number1". Kamar yadda a cikin akwati na baya, mun saita siginan kwamfuta a fagen, amma a wannan lokaci tare da maɓallin linzamin hagu ɗin da aka ajiye, zaɓi dukkanin jimlar kuɗin da aka samu don ɗakin ɗakin. Bayan adireshin wannan kirtani a matsayin mai amfani da tsararraki an shigar da shi a filin filin bayani, danna maballin. "Ok".



7. Kamar yadda ka gani, yawan adadin kudin shiga ga dukan shaguna saboda aikin SUM An nuna shi a cikin takardar tantancewar cell.

Amma wani lokacin lokuta akwai lokuta idan kana buƙatar nuna sakamakon gaba ga duk kantunan ba tare da ƙaddamar da ɗakunan ajiya na ɗakunan mutum ba. Kamar yadda ya fito, mai aiki SUM kuma yana iya, kuma maganin wannan matsala ta fi sauƙi fiye da amfani da wannan ɓangaren na wannan hanya.

1. Kamar kullum, zaɓi tantanin salula akan takardar da za'a nuna sakamakon karshe. Kira Wizard aikin danna kan gunkin "Saka aiki".



2. Yana buɗe Wizard aikin. Zaka iya motsa zuwa category "Ilmin lissafi"amma idan kayi kwanan nan ya yi amfani da afareta SUMkamar yadda muka yi, to, za ku iya zama a cikin category "10 Kwanan nan Amfani" kuma zaɓi sunan da ake so. Dole ne a can. Danna maballin "Ok".



3. Maganar gardama ta sake farawa. Sa siginan kwamfuta a filin "Number1". Amma a wannan lokacin muna riƙe da maɓallin linzamin hagu kuma zaɓi dukan jerin tsararren, wanda ya ƙunshi kudaden shiga ga duk ɗakunan gaba ɗaya. Saboda haka, filin ya kamata a sami adireshin dukkanin teburin. A cikin yanayinmu, yana da nau'i mai biyowa:

   B2: F8

   Amma, hakika, a kowane hali adireshin zai zama daban. Abinda aka tsara shi ne cewa haɗin ginin cibiyar hagu na tsararren zai zama na farko a cikin wannan adireshin, kuma maɓallin dama na ƙasa zai kasance na karshe. Za'a rabu da waɗannan haɓaka ta hanyar haɗin (:).

   Bayan an shigar da adreshin adireshin, danna kan maballin "Ok".



4. Bayan wadannan ayyukan, sakamakon sakamakon ƙarin bayanai za a nuna a cikin tantanin salula.

Idan muka yi la'akari da wannan hanyar daga ra'ayi na gaskiya, ba zamu kwance ginshiƙai ba, amma duk tsararru. Amma sakamakon ya zama daidai, kamar dai an ɗora kowane shafi a daban.

Amma akwai yanayi lokacin da kake buƙatar ƙara duk ginshiƙai na tebur, amma wasu kawai. Ayyukan ya zama mafi mahimmanci idan basu da iyaka juna. Bari mu dubi irin yadda ake amfani da irin wannan bugu ta yin amfani da SUM mai amfani ta misali da wannan tebur. Ƙila za mu buƙatar kawai mu ƙara halayen ginshiƙai "Shop 1", "Shop 3" kuma "Shop 5". Wannan yana buƙatar cewa an ƙididdige sakamakon ba tare da cire ginshiƙan subtotals ba.

1. Saita siginan kwamfuta a tantanin halitta inda za'a nuna sakamakon. Kira da maɓallin muhawarar aikin SUM kamar yadda aka yi kafin.

   A bude taga a filin "Number1" shigar da adreshin ɗakin bayanai a shafi "Shop 1". Munyi shi a cikin hanyar kamar yadda: kafa siginan kwamfuta a cikin filin kuma zaɓi wurin da ke dacewa da teburin. A cikin filayen "Number2" kuma "Number3" saboda haka, muna shigar da adireshin bayanan bayanai a cikin ginshiƙai "Shop 3" kuma "Shop 5". A cikin yanayinmu, shigar da takaddun sunaye kamar haka:

   B2: B8
D2: D8
F2: F8

   Sa'an nan, kamar yadda kullum, danna maballin. "Ok".



2. Bayan kammala ayyukan nan, za a nuna sakamakon adadin kuɗi daga uku daga cikin biyar daga cikin biyar a cikin manufa.

Darasi: Aiwatar da Wizard na Magana a cikin Microsoft Excel

Kamar yadda kake gani, akwai hanyoyi guda uku don ƙara ginshikan a cikin Excel: yin amfani da ƙa'idar mota, ka'idar lissafi da aiki SUM. Zaɓin mafi sauƙi kuma mafi sauri shi ne amfani da kuɗin mota. Amma wannan shi ne mafi ƙanƙantar m kuma ba zai yi aiki a duk lokuta ba. Mafi mahimmanci zaɓi shine amfani da matakan lissafi, amma ƙananan sarrafa kansa kuma a wasu lokuta, tare da adadin bayanai, aiwatarwa a aikace na iya ɗaukar lokaci mai yawa. Yi amfani da aikin SUM za a iya kiransa da "zinariya" tsakiyar tsakanin hanyoyi biyu. Wannan zabin yana da inganci da sauri.