Sikuti ogwiritsa ntchito onse a MS Word amadziwa kuti pulogalamuyi ndiyotheka kuwerengera malinga ndi mafomula opatsidwa. Zachidziwikire, Mawu samakwanitsa kuthekera kwa woyang'anira ofesi ina, purosesa ya purosesa ya Excel, komabe, ndizotheka kuwerengera kosavuta mmenemo.
Phunziro: Momwe mungalembe fomula m'Mawu
Nkhaniyi ifotokoza momwe mungawerengere kuchuluka kwa Mawu. Monga mukumvetsetsa, kuchuluka kwa manambala, kuchuluka kwake komwe kumayenera kupezedwa, kuyenera kukhala patebulo. Talembanso mobwerezabwereza za chilengedwe komanso ntchito ndi zomalizazi. Pofuna kutsitsimula zomwezo kukumbukira, tikulimbikitsa kuwerenga nkhani yathu.
Phunziro: Momwe mungapangire tebulo m'Mawu
Chifukwa chake, tili ndi tebulo lomwe lili ndi deta yomwe ili mgawo lomweli, ndipo ndizomwe tiyenera kufotokozera mwachidule. Ndizomveka kuganiza kuti chiwerengerocho chiyenera kukhala mu gawo lotsiriza (lotsika) la mzati, lomwe mulibe kanthu mpaka pano. Ngati tebulo lanu lilibe mzere momwe kuchuluka kwawomwe kuli, mupange pogwiritsa ntchito malangizo athu.
Phunziro: Momwe mungapangire mzere pa tebulo m'Mawu
1. Dinani pa cell yopanda kanthu (pansipa) ya kakholalo yomwe deta yanu mukufuna kuimitsa.
2. Pitani ku tabu "Kapangidwe"yomwe ili mgawo lalikulu “Kugwira ntchito ndi matebulo”.
3. Mu gulu "Zambiri"yomwe ili patsamba ili, dinani batani “Fomula”.
4. Pakanema yomwe imatsegulira, pansi "Ikani ntchito”Sankhani "SUM", zomwe zikutanthauza "kuchuluka".
5. Kusankha kapena kunena maselo momwe angapangire ku Excel, Mawu sadzagwira ntchito. Chifukwa chake, malo omwe maselo amafunikira amafupikitsidwa akuwonetsedwa mosiyana.
Pambuyo "= SUM" pamzere “Fomula” lowani "(PANGANI)" wopanda magawo ndi malo. Izi zikutanthauza kuti tifunika kuwonjezera data kuchokera ku maselo onse omwe ali pamwambapa.
6. Mukamaliza "Zabwino" kutseka zokambirana “Fomula”, mu khungu lanu posankha zomwe mungasankhe zikuwoneka.
Zomwe muyenera kudziwa za auto sum function mu Mawu
Mukamawerengera tebulo lomwe lidapangidwa ndi Mawu, muyenera kudziwa za zingapo zofunika:
1. Ngati mungasinthe zomwe zili m'maselo omwe afotokozedwa, kuchuluka kwawo sikungosinthidwa zokha. Kuti mupeze zotsatira zoyenera, dinani kumanja ndi chilinganizo ndikusankha 'Munda Wotsitsimula'.
2. Mawerengeredwe ndi formula amachitika kokha maselo omwe amakhala ndi kuchuluka kwa manambala. Ngati pali maselo opanda kanthu m'ndimeyo omwe mukufuna kuti muwerenge, pulogalamuyo imangowonetsa kuchuluka kwa gawo lomwe maselo ali pafupi ndi formula, kunyalanyaza maselo onse omwe ali pamwamba pa chopanda kanthu.
Ndizo zonse, makamaka, tsopano mukudziwa momwe mungawerengere kuchuluka kwa Mawu. Pogwiritsa ntchito gawo la "Fomula", mutha kuwerengenso kuwerengera zina zingapo zosavuta.
