Mukugwira ntchito Microsoft Excel, nthawi zambiri mumayenera kugwetsa ngongolezo m'mizere ndi mizere ya matebulawo, ndikungodziwitsa kuchuluka kwa maselo osiyanasiyana. Pulogalamuyi imapereka zida zingapo kuthetsa nkhaniyi. Tiyeni tiwone momwe mungasungire maselo ku Excel.
AutoSum
Chida chodziwika kwambiri komanso chosavuta kugwiritsa ntchito kudziwa kuchuluka kwa data m'maselo mu Microsoft Excel ndi avtosum.
Kuti muwerengere kuchuluka mwanjira iyi, timadina foni yomaliza yopanda mzere kapena mzere, ndipo, pokhala "tabu" la tsamba, dinani batani la "AutoSum".
Pulogalamuyi ikuwonetsa chinsinsi mu cell.
Kuti muwone zotsatira, muyenera kukanikiza batani Lowani pa kiyibodi.
Itha kuchitika mosiyana. Ngati tikufuna kuwonjezera maselo a mzere wonse kapena mzere, koma kungosankha mtundu wina, ndiye kuti sankhani mtundu uwu. Kenako timadina batani "Autosum" omwe akutidziwa kale.
Zotsatira zake zimawonetsedwa nthawi yomweyo pazenera.
Choyipa chachikulu pakuwerengera mothandizidwa ndi auto-sum ndikuti chimakuthandizani kuwerengetsa kuchuluka kwa deta yomwe ili pamzere umodzi kapena mzere. Koma zosankha zingapo zomwe zimakhala m'makola angapo ndi mizere sizingatheke kuwerengedwa motere. Komanso, ndi chithandizo chake ndizosatheka kuwerengetsa maselo angapo omwe ali kutali ndi mzake.
Mwachitsanzo, timasankha maselo osiyanasiyana, ndikudina batani la "AutoSum".
Koma osati kuchuluka kwa maselo onse awa kukuwonekera pazenera, koma zochulukitsa za gawo lililonse kapena mzere payokha.
Ntchito ya SUM
Kuti muwone kuchuluka konse, kapena zingapo zosanjidwa, ntchito ya "SUM" ilipo mu Microsoft Excel.
Sankhani khungu lomwe tikufuna kuti chiwonetserocho chiwongoleredwe. Dinani pa batani la "Insert Function" lomwe lili kumanzere kwa barula ya fomula.
Windo la Ntchito Wizard limatsegulidwa. Mndandanda wazinthu zomwe tikufuna ntchito "SUM". Sankhani, ndikudina batani "Chabwino".
Pazenera lotseguka lazotsutsana, gwiritsani ntchito zigwirizano za maselo, zomwe tiwerenge. Zachidziwikire, kulowa pamanja pazolumikizana sikothandiza, kotero dinani batani lomwe lili kumanja kwa gawo lolowera deta.
Pambuyo pake, zenera lothandizira la ntchito limachepetsedwa, ndipo titha kusankha maselo amenewo kapena maselo omwe maselo omwe tikufuna kuwerengetsa amafunikira. Pambuyo poti masankhidwewo asankhidwa, ndi adilesi yakeyo ikupezeka pamalo apadera, dinani batani kumanja kwa gawo ili.
Tikubwereranso ku zenera zotsutsana ndi ntchito. Ngati mukufunikira kuwonjezera zina mwazomwezo, ndiye kuti timangobwereza zomwezo zomwe zatchulidwa pamwambapa, koma kumunda kokha ndi "Nambala 2". Ngati ndi kotheka, mwa njira imeneyi mutha kulowa maadiresi a mitundu yopanda malire. Pambuyo kuti mikangano yonse yantchitoyo yaikidwa, dinani batani "Chabwino".
Pambuyo pake, mu khungu momwe timakhazikitsa zotsatira, zotsatira zonse za maselo onse owonetsedwa ziwonetsedwa.
Kugwiritsa ntchito kachitidwe
Kuchuluka kwama data omwe ali m'maselo mu Microsoft Excel amathanso kuwerengedwa pogwiritsa ntchito njira yosavuta yowonjezera. Kuti muchite izi, sankhani selo yomwe mufunika kukhala kuti mulipo, ndikuyika chikwangwani "=" mkati mwake. Pambuyo pake, timadula foni iliyonse, imodzi mwazomwe mufunika kuwerengera kuti mumve zonse. Pambuyo kuti foni yamaselo yawonjezeredwa mu barula yamuyomu, lowetsani chikwangwani "+" kuchokera pa kiyibodi, motero mutatha kulowa maulalo a foni iliyonse.
Ma adilesi a maselo onse atalowetsedwa, dinani batani Lowani pa kiyibodi. Pambuyo pake, kuchuluka kwathunthu kwa data yomwe idalowa ndikuwonetsedwa mu foni yosonyezedwa.
Choyipa chachikulu cha njirayi ndikuti adilesi ya foni iliyonse iyenera kuyikidwa payokha, ndipo simungasankhe maselo athunthu nthawi yomweyo.
Onani kuchuluka mu Microsoft Excel
Komanso, mu Microsoft Excel, mutha kuwona kuchuluka kwa maselo osankhidwa popanda kuwonetsa kuchuluka mu selo limodzi. Zomwe zikuchitika ndikuti maselo onse, omwe amawerengera, ayenera kukhala pafupi, m'gulu limodzi.
Ingosankha maselo osiyanasiyana, kuchuluka kwa zomwe mukufuna kudziwa, ndikuwona zotsatira mu Microsoft Excel.
Monga mukuwonera, pali njira zingapo zofotokozera mwachidule mu Microsoft Excel. Iliyonse ya njirazi imakhala ndi mtundu wake wosavuta komanso wosinthasintha. Monga lamulo, chosavuta chosankha, sichitha kusintha. Mwachitsanzo, posankha kuchuluka kwa kugwiritsa ntchito matotoni amoto, mutha kungogwira pa data yokonzedwa mu mzere. Chifukwa chake, munthawi iliyonse, wosuta ayenera kusankha njira yoyenera.
