Sau da yawa, lokacin aiki tare da tebur a cikin Microsoft Excel, yana da muhimmanci don lissafin adadin da aka raba tare da bayanan. Alal misali, wannan hanya zaka iya lissafin adadin mai nuna alama don kwanaki da dama, idan layuka na tebur suna da kwanaki, ko kuma yawan kuɗi na nau'o'in kaya. Bari mu gano hanyoyin da za ku iya ajiye bayanai a cikin wani shafin Microsoft Excel.
Duba yawan adadi
Hanyar mafi sauki don duba adadin bayanai, ciki har da bayanai a cikin sassan kundin, shine don zaɓar su tare da siginan kwamfuta ta latsa maɓallin linzamin hagu. A lokaci guda kuma, za a nuna jimlar Kwayoyin da aka zaɓa a cikin ma'auni.
Amma, ba za a shigar da wannan lambar ba a tebur, ko an ajiye shi a wasu wurare, kuma an ba shi mai amfani kawai ta hanyar bayanin kula.
Ƙunan kuɗi
Idan kana so ka ba kawai gano adadin bayanai a cikin wani shafi, amma kuma don kawo shi a cikin tebur a cikin tantanin tantanin halitta, to, yana da mafi dacewa don amfani da aikin haɗin kai.
Domin yin amfani da imtosumma, zaɓi tantanin da yake ƙarƙashin ginshiƙan da ake so, kuma danna maɓallin "Autosum", an sanya shi a kan rubutun a cikin shafin "Home".
Maimakon latsa maballin kan rubutun, za ka iya danna maɓallin haɗakarwa a kan ALT + = keyboard.
Microsoft Excel ta atomatik gane sel a cikin wani shafi da ke cike da bayanai don lissafin, kuma yana nuna ƙimar gamawa a cikin tantanin halitta.
Don duba sakamakon da aka gama, kawai danna maɓallin shigarwa akan keyboard.
Idan saboda kowane dalili da kake tsammanin cewa karfin mota ba ya kula da dukkan jikin da kake buƙata, ko kai, akasin haka, yana buƙatar lissafta adadin da ba a cikin dukkanin sassan kundin ba, za ka iya ƙayyade ƙayyadaddun dabi'u. Don yin wannan, zaɓi zaɓin da ake buƙata na sel a cikin shafi, sa'annan kama kododin komai na farko wanda yake ƙarƙashinsa. Sa'an nan, danna kan maɓallin iri ɗaya "Autosum".
Kamar yadda kake gani, ana nuna nauyin din a cikin ɗakin maras, wanda aka samo a ƙarƙashin shafi.
Tsallaka don ginshiƙai masu yawa
Za a iya lissafin kuɗi don ginshiƙai da yawa a lokaci ɗaya, da kuma ɗaya shafi. Wato, zaɓi sel a karkashin wadannan ginshiƙai, sa'annan danna maɓallin "Autosum".
Amma abin da za a yi idan ginshiƙai wanda sel ya buƙaci a taƙaita ba a kusa da juna ba? A wannan yanayin, za mu danna maɓallin Shigarwa, kuma zaɓin kullun da ba a cikin ƙarƙashin ginshiƙan da ake so. Sa'an nan, danna maɓallin "Autosum", ko kuma rubuta maɓallin haɗin ALT + =.
A matsayin madadin, za ka iya zaɓar dukan layi a waɗancan sassan da kake buƙatar gano adadin, kazalika da ƙwayoyin maras tabbas a ƙarƙashin su, sa'an nan kuma danna maɓallin dakatarwar mota.
Kamar yadda kake gani, ana lissafin adadin dukan ginshiƙai da aka ƙayyade.
Taron taƙaitawa
Bugu da ƙari, akwai yiwuwar haɗawa da jiki a cikin tebur. Wannan hanya ba tabbas ba ne kamar ƙidayawa ta hanyar mota na auto, amma a daya gefen, yana ba ka damar nuna waɗannan ƙididdiga ba kawai a cikin sassan dake ƙarƙashin shafi ba, amma har ma a kowane tantanin da aka samo akan takardar. Idan ana so, adadin da aka lissafa a wannan hanya za a iya nunawa ko da a wani takardar lissafin Excel. Bugu da ƙari, ta amfani da wannan hanya, zaka iya lissafin adadin ƙwayoyin ba daga dukan shafi ba, sai dai waɗanda za ka zaɓi kanka. Bugu da ƙari, ba dole ba ne waɗannan kwayoyin kan iyakance juna.
Danna kan kowane tantanin da kake so ka nuna adadin, sa'annan ka sanya "=" a ciki. Sa'an nan kuma, click alternately a kan sassan kundin da kake son takaitawa. Bayan shigar da kowane cell na gaba, kana buƙatar danna maballin "+". Daftarin shigarwa an nuna shi a tantanin salula na zaɓinku, da kuma a cikin tsari.
Lokacin da ka shiga adireshin dukkanin sel, don nuna sakamakon jimlar, danna maɓallin Shigar.
Saboda haka, munyi la'akari da hanyoyi daban-daban don lissafin adadin bayanai a ginshiƙai a Microsoft Excel. Kamar yadda kake gani, akwai hanyoyi mafi dacewa, amma rashin sauki, da kuma zaɓuɓɓukan da suke buƙatar lokaci, amma a lokaci guda ya ba ka damar zaɓi ƙayyadadden ƙwayoyin don lissafi. Wanne hanyar da za a yi amfani da shi ya dogara ne akan ayyuka na musamman.
