Microsoft Word ili ndi lamulo lalikulu la menyu Mtundu - Mndandanda (Mawonekedwe - Zipolopolo ndi Manambala), zomwe zimakulolani kuti musinthe mwamsanga ndime kuti zikhale mndandanda wa zipolopolo kapena manambala. Kuthamanga, kosavuta, kowoneka, osafunikira kutsatira manambala. Palibe ntchito yotere mu Excel, koma mutha kuyesa kutsanzira pogwiritsa ntchito mafomu osavuta komanso masanjidwe.
Mndandanda wa zipolopolo
Sankhani ma cell a data pamndandanda, dinani pomwepa ndikusankha Mawonekedwe a cell (Maselo a Format), tabu Number (nambala), Komanso - Mitundu yonse (Mwambo). Ndiye m'munda Mtundu lowetsani chigoba chotsatirachi:
Kuti mulowe kadontho kolimba kwambiri, mutha kugwiritsa ntchito njira yachidule ya kiyibodi Alt + 0149 (gwirani Alt ndikulemba 0149 pamakina a manambala).
Mndandanda wa manambala
Sankhani cell yopanda kanthu kumanzere kwa chiyambi cha mndandanda (pa chithunzicho ndi C1) ndikulowetsamo zotsatirazi:
=IF(ISBLANK(D1),””;COUNT($D$1:D1))
=IF(ISBLANK(D1);»»;COUNTA($D$1:D1))
Kenako koperani fomula ku gawo lonse. Muyenera kumaliza ndi izi:
M'malo mwake, fomula yomwe ili mugawo C imayang'ana zomwe zili muselo pafupi ndi kumanja (ntchito IF и ISBLANK). Ngati selo yoyandikana nayo ilibe kanthu, ndiye kuti sitiwonetsa kalikonse (mawu opanda kanthu). Ngati mulibe kanthu, sonyezani kuchuluka kwa ma cell opanda kanthu (function COUNT) kuyambira pachiyambi cha mndandanda kupita ku selo yamakono, ndiye kuti, nambala ya ordinal.