Sau da yawa, lokacin aiki tare da tebur a Microsoft Excel, kuna buƙatar lissafta adadin don keɓaɓɓen shafi tare da bayanai. Misali, ta wannan hanyar zaka iya kirga jimlar adadin mai nuna alama na kwanaki da yawa, idan layuka na tebur din kwana ne, ko jimlar adadin kayayyaki da yawa. Bari mu bincika hanyoyi da yawa waɗanda zaka iya ƙara bayanan shafi akan shirin Microsoft Excel.
Duba jimlar
Hanya mafi sauki don duba yawan adadin bayanai, gami da bayanai a cikin sel, a zabi kawai tare da siginan kwamfuta ta danna maɓallin linzamin kwamfuta na hagu. A lokaci guda, jimlar ƙwayoyin da aka zaɓa an nuna su a sandar matsayin.
Amma, wannan lambar ba za ta shiga cikin tebur ba, ko a adana ta wani wuri, kuma an ba wa mai amfani kawai don bayani.
AutoSum
Idan kana son ba kawai gano jimlar bayanan shafin ba, har ma shigar da shi a cikin tebur a cikin wata sel daban, to, ya fi dacewa don amfani da aikin tara kuɗi.
Don amfani da adadin atomatik, zaɓi wayar da ke ƙarƙashin shafin da ake so, sannan danna maɓallin "AutoSum" wanda ke kan ribbon a cikin "Gidan".
Maimakon danna maɓallin a kan kintinkiri, zaku iya danna maɓallin keyboard ALT + =.
Microsoft Excel ta atomatik gane ƙwayoyin ɗakin da ke cike da bayanai don ƙididdigewa kuma yana nuna sakamakon ƙare a cikin tantanin da aka ƙayyade.
Don ganin sakamakon ƙarshe, danna maɓallin Shigar da maballin.
Idan saboda wasu dalilai kun yi imani da cewa auto-sum ba su yin la'akari da dukkanin ƙwayoyin da kuke buƙata, ko kuma, akasin haka, kuna buƙatar lissafin jimlar ba a cikin duk ƙwayoyin shafin ba, to kuna iya sanin hannu da ƙimar kuɗin. Don yin wannan, zaɓi kewayon ƙwayoyin da ake so a cikin shafi, sannan an ɗora sel na farko da ke ƙasa da shi. Bayan haka, danna kan dukkan maɓallin "AutoSum".
Kamar yadda kake gani, adadin yana nunawa a cikin sel mara komai, wanda ke ƙarƙashin ƙarƙashin shafi.
AutoSum don layuka da yawa
Za a iya yin lissafin adadin lambobi da yawa a lokaci guda, da kuma ɗaya shafi. Wato, zaɓi ƙwayoyin da ke ƙarƙashin waɗannan layuka, kuma danna maɓallin "AutoSum".
Amma abin da za a yi idan ginshiƙan waɗanda ƙwayoyin da kuke son tara su ba su kasance kusa da juna ba? A wannan yanayin, riƙe maɓallin Shigar, kuma zaɓi ƙwayoyin marasa komai da ke ƙarƙashin umnsungiyoyin da ake so. To, danna kan maɓallin "AutoSum", ko buga a cikin haɗin maɓallin ALT + =.
A matsayin madadin, zaku iya zaɓar duk kewayon a cikin waɗancan sel waɗanda kuke buƙatar gano adadin, daidai da ƙwayoyin komai a ƙarƙashinsu, sannan danna maɓallin auto-sum.
Kamar yadda kake gani, jimlar duk waɗannan ginshiƙan ana lasafta su.
Taron littafi
Hakanan, yana yiwuwa a ringa tara sel a allon tebur. Wannan hanyar, hakika, ba ta dace ba kamar ƙididdigar ta hanyar atomatik, amma a gefe guda, yana ba ku damar nuna bayanan jimlar ba kawai a cikin ƙwayoyin da ke ƙarƙashin shafin ba, har ma a duk wata tantanin halitta da ke kan takardar. Idan ana so, adadin da aka lasafta ta wannan hanyar za'a iya nuna shi a wata takaddar littafin karatun aikin Excel. Bugu da kari, ta wannan hanyar, zaku iya yin lissafin jimlar sel ba na gaba daya ba, amma kawai wadanda kuka zabi kanku. Haka kuma, ba lallai ba ne wadannan sel su yi iyaka da juna.
Mun danna kowane tantanin halitta da kake son nuna adadin, saika sanya alamar "=" a ciki. Sannan, daya bayan daya mun danna waɗancan sel ɗin da kake son taƙaitawa. Bayan shigar kowace sel na gaba, kuna buƙatar danna maɓallin "+". Ana nuna tsarin shigarwar a cikin tantanin da kuka zabi, kuma a cikin masarar dabara.
Lokacin da ka shigar da adireshin duk sel, don nuna sakamakon jimlar, latsa maɓallin Shigar.
Don haka, mun bincika hanyoyi daban-daban na ƙididdige yawan adadin bayanai a cikin ginshiƙai a cikin Microsoft Excel. Kamar yadda kake gani, akwai duka hanyoyin da suka fi dacewa, amma akwai ƙananan hanyoyin sassauƙa, haka kuma zaɓuɓɓuka waɗanda ke buƙatar ƙarin lokaci, amma a lokaci guda ƙyale zaɓi na takamaiman ƙwayoyin don lissafi. Wanne hanyar yin amfani da shi ya dogara da takamaiman ayyuka.
