Pamene mukugwira ntchito ku Microsoft Excel, kawirikawiri amafunikanso kufotokozera mndandanda muzitsulo ndi mizere ya matebulo, komanso kumangodziwa kuti pali maselo osiyanasiyana. Pulogalamuyi imapereka zida zingapo zothetsera vutoli. Tiyeni tiwone momwe tingawerengere maselo a Excel.
Zambiri zapadera
Chinthu chodziŵika bwino komanso chophweka chodziŵira kuchuluka kwa deta m'ma selo mu Microsoft Excel ndi autosum.
Kuti muwerenge ndalamazo mwanjira iyi, dinani selo yopanda kanthu ya mndandanda kapena mzere, ndipo pokhala pakhomo la Pakhomo, dinani pa batani la AutoSum.
Pulogalamuyi ikuwonetsa ndondomeko mu selo.
Kuti muwone zotsatira, muyenera kuyika batani lolowani mukhiyo.
Inu mukhoza kuchita pang'ono mosiyana. Ngati tikufuna kupuntha maselo osakhala mzere wonse kapena ndime, koma ndi mtundu wina, ndiye kuti timasankha mtunduwu. Kenaka dinani pa batani "AutoSum", limene talidziwa kale.
Zotsatira zimapezeka nthawi yomweyo pazenera.
Chosavuta chachikulu chowerengera pogwiritsa ntchito autosum ndi chakuti zimakulolani kuwerengetsa deta yambiri yomwe ili mu mzere umodzi kapena mu khola. Koma mndandanda wa deta uli muzitsulo ndi mizere ingapo, njira iyi silingathe kuwerengedwa. Komanso, sungagwiritsidwe ntchito kuwerengera kuchuluka kwa maselo angapo omwe ali kutali kwambiri.
Mwachitsanzo, timasankha maselo osiyanasiyana, ndipo dinani "batani".
Koma chinsalu sichiwonetsera mndandanda wa maselo onsewa, koma ndalama pa mzere uliwonse kapena mzere pawokha.
Ntchito SUM
Kuti muwone chiwerengero cha gulu lonse, kapena ma deta angapo mu Microsoft Excel, pali ntchito "SUMM".
Sankhani selo limene tikufuna kuti liwonetsedwe. Dinani pa batani "Yesani ntchito" yomwe ili kumanzere kwa bar.
Fayilo la Function Wizard likuyamba. Mundandanda wa ntchito tikuyang'ana ntchito "SUMM". Sankhani, ndipo dinani "Bwino".
Muzenera zowonjezera zowonjezera zowonjezera, lowetsani makonzedwe a maselo, chiwerengero cha zomwe titi tiwerenge. Inde, ndizosokoneza kuti mulowetse malumikizidwe, kotero dinani pakani yomwe ili kumanja kwa gawo lolowera deta.
Pambuyo pake, ntchito yotsutsana zenera ikuchepetsedwa, ndipo tikhoza kusankha maselo, kapena maselo osungira maselo, chiwerengero cha miyezo yomwe tikufuna kuwerengera. Pambuyo pasankhidwa, ndipo adiresi yake ikupezeka kumadera apadera, dinani pa batani kumanja kwa munda uno.
Timabwereranso ku zenera zotsutsana. Ngati mukufuna kuwonjezeranso chiwerengero chimodzi cha deta, mubwereze zomwezo zatchulidwa pamwambapa, koma m'munda ndi parameter ya "Number 2". Ngati ndi kotheka, mwa njira iyi mukhoza kulowa maadiresi a ziwerengero zopanda malire. Pambuyo pazitsulo zonse za ntchitoyi, dinani pa batani "OK".
Pambuyo pake, mu selo yomwe timayika zotsatira za zotsatira, chiwerengero chonse cha maselo omwe adalongosola chidzawonetsedwa.
Gwiritsani ntchito njirayi
Chiwerengero cha deta mu maselo a Microsoft Excel chikhoza kuwerengedwanso pogwiritsa ntchito njira yowonjezera yowonjezera. Kuti muchite izi, sankhani selo limene ndalamazo ziyenera kukhala, ndipo ikani chizindikiro "=". Pambuyo pake, dinani pang'onopang'ono pa selo lirilonse, la iwo omwe muli ndi mfundo zomwe muyenera kuziwerenga. Pambuyo pa adiresi yowonjezera yowonjezeredwa ku bar, perekani chizindikiro "+" kuchokera ku kibokosilo, ndipo mutatha kulowa m'zigawo za selo iliyonse.
Pamene maadiresi a maselo onse alowa, dinani batani lolowani mukibokosi. Pambuyo pake, chiwerengero chonse cha deta chatsegulidwa chikuwonetsedwa mu selo lotchulidwa.
Chosavuta chachikulu cha njirayi ndi chakuti adiresi ya selo iliyonse ayenera kulowa mosiyana, ndipo simungathe kusankha maselo ambirimbiri kamodzi.
Onani ndalama mu Microsoft Excel
Ndiponso, mu Microsoft Excel n'zotheka kuwona maselo osankhidwa popanda kuchotsa ndalamayi mu selo losiyana. Chinthu chokhacho ndi chakuti maselo onse, chiwerengero cha zomwe ayenera kuwerengedwa, ayenera kukhala pafupi, mwadongosolo limodzi.
Sankhani maselo angapo, kuchuluka kwa deta yomwe muyenera kudziwa, ndipo yang'anani zotsatira muzitsulo za Microsoft Excel.
Monga mukuonera, pali njira zambiri zofotokozera deta mu Microsoft Excel. Njira iliyonseyi imakhala yovuta komanso yosinthasintha. Monga lamulo, chosavuta kusankha, osasinthasintha ndizochepa. Mwachitsanzo, pozindikira kuchuluka kwa ndalama pogwiritsa ntchito autosum, mungathe kugwira ntchito ndi deta yokhazikika. Choncho, pazifukwa zina, wosuta mwiniyo ayenera kusankha njira yabwino kwambiri.
