Kawirikawiri, mukamagwira ntchito ndi matebulo mu Microsoft Excel, m'pofunika kuwerengera ndalamazo pamtundu umodzi ndi data. Mwachitsanzo, mwa njira iyi mukhoza kuwerengera mtengo wa chizindikiro kwa masiku angapo, ngati mizera ya tebulo ndi masiku, kapena mtengo wake wonse wa mitundu yambiri ya katundu. Tiyeni tipeze njira zosiyanasiyana zomwe mungagwiritsire ntchito deta ya Microsoft Excel.
Onani ndalama zonse
Njira yosavuta yowonera chiwerengero cha deta, kuphatikizapo deta mu maselo a chigawo, ndi kungowasankha ndi chithunzithunzi mwa kuguliritsa pa batani lamanzere. Panthawi imodzimodziyo, maselo onse osankhidwa adzawonetsedwa mu bar.
Koma, nambala iyi siidzalowa mu tebulo, kapena kusungidwa kwina, ndipo imapatsidwa kwa wosuta mwachidule.
Zambiri zapadera
Ngati mukufuna kudziwa chabe chiwerengero cha deta mukhola, komanso kuti mubweretse tebulo mu selo losiyana, ndiye kuti ndi bwino kugwiritsa ntchito galimoto-sum function.
Kuti mugwiritse ntchito avtosumma, sankhani selo limene liri pansi pa gawo lofunidwa, ndipo dinani pa batani "Autosum", yoikidwa pa riboni mu tab "Home".
M'malo mokanikiza batani pa nthiti, mungathe kuphindikizira mgwirizano wapamwamba pa kibokosi ALT + =.
Microsoft Excel imadziŵa mosavuta maselo omwe ali m'kaundula yodzaza ndi chiwerengero cha mawerengedwe, ndipo amasonyeza zonse zomwe zatsirizidwa mu selo yolankhulidwa.
Kuti muwone zotsatira zomalizidwa, ingodikizani batani lolowani mukhiyo.
Ngati pazifukwa zilizonse mukuganiza kuti ndalama zamagalimoto sizinaganizire maselo onse omwe mukufunikira, kapena inu, mosiyana, muyenera kuwerengera ndalama zomwe sizili m'zigawo zonse za pamtunduwu, mutha kudziwa momwe mungakhalire. Kuti muchite izi, sankhani maselo ambirimbiri omwe mukufuna, ndi kulanda selo yoyamba yopanda kanthu yomwe ili pansi pake. Kenaka, dinani batani womwewo "Autosum".
Monga momwe mukuonera, ndalamayi ikuwonetsedwa mu selo yopanda kanthu, yomwe ili pansi pa ndimeyo.
Autosum kwa maulendo angapo
Chiwerengero cha zipilala zingapo panthawi imodzi chikhoza kuwerengedwa, komanso pa khola limodzi. Ndiko, sankhani maselo pansi pa zigawo izi, ndipo dinani pa batani "Autosum".
Koma choyenera kuchita chiyani ngati zipilala zomwe maselo ake amafunika kufotokozedwa sizili pafupi? Pankhaniyi, timasindikiza botani lolowani mu Enter, ndipo sankhani maselo opanda kanthu omwe ali pansi pa zipilala zoyenera. Kenaka, dinani pa batani "Autosum", kapena yesani chophatikizira ALT + =.
Monga njira ina, mungasankhe mtundu wonsewo m'maselo omwe mukufunikira kupeza ndalamazo, komanso maselo opanda pake pansi pawo, ndiyeno dinani pang'onopang'ono.
Monga mukuonera, chiwerengero cha ndondomeko zonse zachindunji chikuwerengedwa.
Buku lomasulira
Komanso, pali kuthekera kolemba pamasom'manja omwe ali mu tebulolo. Njirayi siyiyenela kukhala yowerengeka ngati kuwerengera kupyolera mumagalimoto, koma kumalo ena, zimakulolani kusonyeza ndalama izi osati m'maselo omwe ali pansi pa mzerewo, komanso mu selo lina liri lonse pa pepala. Ngati mukufuna, ndalama zomwe ziwerengedwera mwanjirayi zingasonyezedwe ngakhale pa tsamba lina la buku la Excel. Kuwonjezera apo, pogwiritsa ntchito njirayi, mukhoza kuwerengera kuchuluka kwa maselo osati a mzere wonsewo, koma okhawo omwe mumasankha nokha. Pa nthawi yomweyi, sizili kofunikira kuti maselowa amalire malire.
Dinani pa selo iliyonse yomwe mukufuna kusonyeza ndalamazo, ndipo ikani chizindikiro "=" mmenemo. Kenako, dinani pang'onopang'ono pa maselo a ndime imene mukufuna kufotokoza mwachidule. Mutatha kulowa selo lotsatira, muyenera kukanikiza "key". Njira yowonjezera imasonyezedwa mu selo yomwe mwasankha, ndipo mu barra ya fomu.
Mukalowa maadiresi a maselo onse, kuti muwonetse zotsatira za ndalamazo, pezani batani lolowamo.
Choncho, takambirana njira zosiyanasiyana zowerengera chiwerengero cha deta mu Microsoft Excel. Monga momwe mukuonera, pali njira zambiri zosavuta, koma zosasinthasintha zochepa, ndi zosankha zomwe zimafuna nthawi yambiri, koma nthawi yomweyo zimakulolani kuti musankhe maselo enieni a kuwerengera. Njira iti yomwe mungagwiritse ntchito ikudalira ntchito yeniyeni.
