Momwe Mungachotsere manambala ozungulira

Njira 1: Ntchito "Kukulitsa Kukula"

Njira yosavuta komanso yovuta kwambiri yoyatsa manambala omwe aposachedwa ndikugwiritsa ntchito "kukulitsa kukula". Imagwira ntchito yowonjezera chiwonetsero cha manambala pambuyo pa kuchuluka kwa ndalamazo ku kuchuluka kwake kofunikira, ndipo idzafunika kuchitapo kanthu.

1. Sankhani zomwe muyenera kusintha, ndipo ngati ambiri a iwo, amagawa zonse nthawi imodzi.



2. Mu "nambala yakuti" kukulitsa mndandanda wa mitundu ya manambala ndikusankha zomwe mukufuna kugwiritsa ntchito.



3. Nthawi yomweyo, ndiye dinani batani "kukulitsa kukula kwake" nthawi zambiri monga manambala omwe mukufuna kuwonjezera.



4. Tsatirani zosintha mwa kuona mkhalidwe wa maselo, ndipo onani kuti kungozungulira kumeneku kumawerengedwa kwathunthu, mtengo uliwonse wotsatira udawonjeza kuti ndi "0".

Chimodzimodzi njira inayi ikugwiranso ntchito, yopangidwa kuti ichepetse zotulutsa. Imapezeka pagawo limodzi ndipo itha kugwiritsidwa ntchito ngati mwawonjezera zizindikiro zosafunikira.

Njira 2: Kukhazikitsa mawonekedwe a maselo

Kukhazikitsa mtundu wa khungu kumakupatsani mwayi wokhazikitsa kuchuluka kwa semicolons kuti musunge zokha. Sizingalepheretse chilichonse kuti chiwonjezere nambala yawo kwa omwe akufunika, motero amakhumba. Kuti muchite izi, muyenera kutanthauza mndandanda woyenera mu Excel.

1. Choyamba, nthawi zonse amagawa maselo amenewo momwe kusintha kotsatira kudzagwiritsidwa ntchito.



2. Chotsatira, konjezerani menyu "ndikusankha menyu yotsika.



3. Mmenemo, dinani pa gulu laposachedwa la mtundu wa cell.



4. Sankhani batani lakumanzere ndi mtundu wa manambala omwe amagwiritsidwa ntchito maselo omwe adasankhidwa kale.



5. Khazikitsani chiwerengero cha zizindikiro za decomal polemba mtengo wake m'munda wogawidwa izi, gwiritsani ntchito makonda atsopano ndikusiya menyu.



6. Onani maselo omwe adasankhidwa kale ndikuwonetsetsa kuti mfundo zawo zikuwonetsedwa bwino.

Njira 3: Kusintha kwa mawonekedwe a cell

Imamaliza nkhaniyo mwa njira yomwe imatanthawuza kusintha kwa maselo omwe ali ndi manambala omwe mzere womwe ukuzungulira udazimitsidwa. Iyi ndiye njira yokhayo yomwe ingagwiritsidwe ntchito ngati kuzungulira kumachitika chifukwa cha malo osakwanira mu cell pazizindikiro zonse.

Mutha kugwiritsa ntchito njira yapitayi posankha mtundu wina, koma nthawi yomweyo ndi zotsatira zomwe mungawerenge pokhapokha mutatuluka. Kapenanso, tikukulangizani kuti mupereke menyu ya "nambala", yomwe yanenedwa kale mu njira 1, ndikuwona mawonekedwe a manambala ena. Dinani pa yomwe ikhale yoyenera kuti ichitike nthawi yomweyo.

Ganizirani kuti ngati chiwerengero cha mtundu wa mawu sichitha kuwerengetsa ndalama zake panthawi yodzipatula kapena gwiritsani ntchito foniyo munjira ya masamu. Ngati mtsogolomo zifunikenso manambala ozungulira, gwiritsani ntchito malangizo ena patsamba lathu podina ulalo pansipa.

Werengani zambiri: manambala ozungulira mu Microsoft Excel