Uma sinetafula ngokusho ukuthi ingqikithi kufanele ibalwe, khona-ke idlala indima ebalulekile ukuthi yimuphi umsebenzi ababalwayo, ngoba. ithebula lingaba:
- Izihlungi zifakiwe
- Eminye imigqa ifihliwe
- Kugoqwe imigqa eqoqwe
- Amanani angaphansi kwetafula
- Amaphutha kumafomula
Ezinye zezindlela ezingezansi ziyazwela kulezi zici, ezinye azizona. Lokhu kufanele kucatshangelwe lapho kwenziwa izibalo:
ISUM (SUM) - ngobuwula uhlanganisa yonke into ebangeni elikhethiwe ngokungakhethi, okungukuthi nemigqa efihliwe futhi. Uma kukhona noma yiliphi iphutha okungenani kuseli eyodwa, liyayeka ukubala futhi linikeze iphutha kokuphumayo.
IZITHOMBE ZAMABILI (AMABILI ANYE) ngekhodi 9 ku-agumenti yokuqala - ihlanganisa wonke amaseli abonakala ngemva kwesihlungi. Iziba eminye imisebenzi efanayo engase icabangele amanani amancane angaphakathi ebangeni lomthombo.
IZITHOMBE ZAMABILI (AMABILI ANYE) ngekhodi 109 ku-agumenti yokuqala - ihlanganisa wonke amaseli abonakala ngemva kwesihlungi namaseli okuqoqa (noma afihliwe). Iziba eminye imisebenzi efanayo engase icabangele amanani amancane angaphakathi ebangeni lomthombo.
Uma ungadingi ukuhlanganisa, ungasebenzisa amanye amanani wekhodi yokusebenza kwezibalo:
UNIT (ISIBAMBILI) - isici esinamandla kakhulu esivele ku-Office 2010. Njenge-SUBTOTALS, ayikwazi ukuhlanganisa kuphela, kodwa futhi ibala isilinganiso, inombolo, ubuncane, ubukhulu, njll. - ikhodi yokusebenza inikezwa ngokuphikisana kokuqala. Futhi, inezinketho eziningi zokubala, ezingacaciswa njengengxabano yesibili:
- Izibalo ezikhethiwe zesimo esisodwa noma ngaphezulu
- Namathisela emigqeni ehlungiwe
- Fihla ngokushesha futhi ubonise imigqa namakholomu angafuneki