Mukamawerengera zinthu zosiyanasiyana ku Excel, ogwiritsa ntchito nthawi zonse saganiza kuti mfundo zomwe zimawonetsedwa m'maselo nthawi zina sizigwirizana ndi zomwe pulogalamuyi imagwiritsa ntchito kuwerengera. Izi ndizofunikira makamaka kwa mfundo zachikhalidwe. Mwachitsanzo, ngati muli ndi mawonekedwe amumisiri omwe adayikidwa omwe amawonetsa manambala omwe ali ndi malo awiri omaliza, izi sizitanthauza kuti Excel imawerengera zomwezi. Ayi, mwakanthawi pulogalamuyi imawerengeredwa mpaka malo 14, ngakhale anthu awiri okha awonetsedwa mchipindamu Izi nthawi zina zimatha kubweretsa zotsatira zosasangalatsa. Kuti muthane ndi vutoli, muyenera kukhazikitsa zolondola mozungulira ngati zenera.
Kukhazikitsa mozungulira ngati pazenera
Koma musanapange kusintha kwamakonzedwe, muyenera kudziwa ngati mukufunikiradi kuthandizira kulondola monga pazenera. Zowonadi, nthawi zina, chiwerengero chambiri chokhala ndi malo owerengeka chikagwiritsidwa ntchito, zotsatira zowerengera zimatheka kuwerengera, zomwe zimachepetsa kulondola konse kuwerengera. Chifukwa chake, popanda zosowa zosafunikira kukhazikikaku ndikwabwino osazunza.
Kuphatikiza kulondola monga pazenera, ndikofunikira pamikhalidwe yotsatira. Mwachitsanzo, muli ndi ntchito yowonjezera manambala awiri 4,41 ndi 4,34, koma choyambirira ndikuti malo amodzi okha amawonetsedwa papepala. Titapanga masanjidwe oyenera amaselo, zomwe timayang'ana zidayamba kuwoneka pa pepalalo 4,4 ndi 4,3, koma akawonjezedwa, pulogalamuyo imawonekera chifukwa chosakhala nambala mu foni 4,7, komanso kufunika kwake 4,8.
Izi zikuchitika makamaka chifukwa chakuti Excel ndi yoona pakuwerengera. 4,41 ndi 4,34. Pambuyo powerengera, zotsatira zake zimakhala 4,75. Koma, popeza tanena mu mtundu wa kuwonetsera manambala ndi malo amodzi okha, kuzungulira kumachitika ndipo nambala imawonetsedwa 4,8. Chifukwa chake, zikuwoneka kuti pulogalamu idalakwitsa (ngakhale sizili choncho). Koma papepala losindikizidwa, mawu oterowo 4,4+4,3=8,8 chimakhala cholakwika. Chifukwa chake, pankhaniyi, ndizanzeru kuyatsa makonzedwe olondola monga zenera. Kenako Excel idzawerengera osaganizira ziwerengero zomwe pulogalamuyo imakumbukira, koma malinga ndi mfundo zomwe zikuwonetsedwa mu cell.
Kuti mudziwe kuchuluka kwa chiwerengero chomwe Excel imawerengera, muyenera kusankha foni yomwe ili. Pambuyo pake, mtengo wake umawonetsedwa mu barula yokhazikitsidwa, yomwe imasungidwa mu kukumbukira kwa Excel.
Phunziro: Kuchulukitsa ziwerengero ku Excel
Yambitsani kusintha kolondola pazenera m'mitundu yamakono ya Excel
Tsopano tiyeni tiwone momwe tingawongolere kulondola onse pazenera. Choyamba, tiwona momwe tingachitire izi pogwiritsa ntchito chitsanzo cha Microsoft Excel 2010 ndi zomwe zidasinthidwa pambuyo pake. Atembenuza gawo ili mwanjira yomweyo. Ndipo tidzaphunziranso momwe tingayendere kuwongolera zonse pazenera mu Excel 2007 ndi Excel 2003.
- Pitani ku tabu Fayilo.
- Pazenera lomwe limatsegulira, dinani batani "Zosankha".
- Tsamba lina lowonjezera lakhazikitsidwa. Timasunthira mmenemo kupita ku gawo "Zotsogola"dzina lake limapezeka mndandanda kumanzere kwa zenera.
- Pambuyo posamukira ku gawo "Zotsogola" sunthani mbali yakumanja kwa zenera, momwe mumakhazikitsidwa mapulogalamu osiyanasiyana. Pezani zotchinga "Mukamawerengera bukuli". Chongani bokosi pafupi ndi gawo "Khazikitsani zolondola ngati pazenera".
- Pambuyo pake, bokosi la zokambirana limawonekera pomwe likuti kuwerengera bwino kumatsitsidwa. Dinani batani "Zabwino".
Pambuyo pake, mu Excel 2010 ndi pamwambapa, mawonekedwewo adzathandizidwa "kulondola monga pachithunzi".
Kuti mulepheretse njirayi, muyenera kuyimitsa zenera pazosankha pafupi ndi zoikamo "Khazikitsani zolondola ngati pazenera", kenako dinani batani "Zabwino" pansi pazenera.
Kuthandizira makonzedwe apazenera pazenera mu Excel 2007 ndi Excel 2003
Tsopano tiyeni tiwone mwachidule momwe machitidwe olungamitsawa amathandizira onse pazenera mu Excel 2007 ndi Excel 2003. Ngakhale matembenuzidwewa amawonedwa kuti ndi achikale, amagwiritsidwabe ntchito ndi ogwiritsa ntchito ambiri.
Choyamba, lingalirani momwe mungapangire mawonekedwe mu Excel 2007.
- Dinani pa Microsoft Office Office pakona yakumanzere ya zenera. Pamndandanda womwe umawonekera, sankhani Zosankha za Excel.
- Pazenera lomwe limatsegulira, sankhani "Zotsogola". Gawo lamanja la zenera mumagulu azokonda "Mukamawerengera bukuli" onani bokosi pafupi ndi paramayo "Khazikitsani zolondola ngati pazenera".
Makina olondola monga pazenera adzatsegulidwa.
Mu Excel 2003, njira yothandizira mawonekedwe omwe timafuna ndiyosiyana kwambiri.
- Pa mndandanda woyang'ana, dinani chinthucho "Ntchito". Pamndandanda womwe umatsegulira, sankhani malo "Zosankha".
- Zenera la kusankha limayamba. Mmenemo, pitani ku tabu "Kuwerengetsa". Kenako, onani bokosi pafupi "Kulondola ngati pachithunzi" ndipo dinani batani "Zabwino" pansi pazenera.
Monga mukuwonera, kuyika mawonekedwe olondola ofanana ndi omwe ali pazenera ku Excel ndikosavuta, mosasamala mtundu wa pulogalamuyo. Chachikulu ndikuti mudziwenso ngati zili choncho muyenera kuyendetsa njirayi kapena ayi.
