Ngati tili ndi tebulo malinga ndi zomwe ziwerengero ziyenera kuwerengedwa, ndiye kuti zimagwira ntchito yofunika kwambiri yomwe imawerengedwa, chifukwa. tebulo likhoza kukhala:
- Zosefera zikuphatikizidwa
- Mizere ina yabisika
- Mizere yosungidwa m'magulu
- Ma subtotals mkati mwa tebulo
- Zolakwika mumayendedwe
Zina mwa njira zomwe zili pansipa zimakhudzidwa ndi izi, zina siziri. Izi ziyenera kuganiziridwa powerengera:
SUM (SUM) - mopusa amawerengera zonse zomwe zasankhidwa mosasankha, mwachitsanzo, mizere yobisika. Ngati pali cholakwika chilichonse mu selo imodzi, imasiya kuwerengera komanso imapereka cholakwika pazotulutsa.
ZONSE ZONSE (ZAMBIRI) ndi code 9 pa mkangano woyamba - imawerengera maselo onse omwe amawoneka pambuyo pa fyuluta. Imanyalanyaza ntchito zina zofananira zomwe zingaganizire zing'onozing'ono zamkati mumtundu woyambira.
ZONSE ZONSE (ZAMBIRI) ndi code 109 pa mkangano woyamba - imawerengera maselo onse omwe amawoneka pambuyo pa fyuluta ndi magulu (kapena kubisala) maselo. Imanyalanyaza ntchito zina zofananira zomwe zingaganizire zing'onozing'ono zamkati mumtundu woyambira.
Ngati simukuyenera kuwerengera, ndiye kuti mutha kugwiritsa ntchito zikhalidwe zina zamasinthidwe a masamu:
UNIT (AGGREGATE) - chinthu champhamvu kwambiri chomwe chinawonekera mu Office 2010. Monga SUBTOTALS, sizingangowonjezera mwachidule, komanso kuwerengera chiwerengero, chiwerengero, chochepa, chochepa, ndi zina zotero - ndondomeko ya opaleshoni imaperekedwa ndi mkangano woyamba. Kuphatikiza apo, ili ndi zosankha zambiri zowerengera, zomwe zitha kufotokozedwa ngati mkangano wachiwiri:
- Kuwerengera kosankhidwa kwa chinthu chimodzi kapena zingapo
- Matani mizere yosefedwa
- Bisani mwachangu ndikuwonetsa mizere ndi zipilala zosafunikira