Kupanga zowerengera zosiyanasiyana mu Excel, osagwiritsa ntchito nthawizonse amaganiza kuti zikhalidwe zomwe zimayikidwa mu maselo nthawizina sizigwirizana ndi zomwe zikugwiritsidwa ntchito pulogalamuyi. Izi ndizowona makamaka pazigawo zochepa. Mwachitsanzo, ngati mwaika mawerengedwe a chiwerengero, omwe amawonetsera manambala ndi malo awiri osankhidwa, ndiye kuti izi sizikutanthauza kuti Excel imaganiziranso deta. Ayi, mwachisawawa, purogalamuyi ikuwerengera mpaka 14 decimal malo, ngakhale ziwerengero ziwiri zokha zikuwonetsedwa mu selo. Izi nthawi zina zingathe kuwonetsa zotsatira zosasangalatsa. Pofuna kuthetsa vutoli, muyenera kukhazikitsa zolingalira molondola monga pazenera.
Kuyika zozungulira monga pazenera
Koma musanayambe kusintha, muyenera kudziwa ngati mukufunadi kutembenuza zolondola monga pawindo. Zoonadi, nthawi zina, mukamagwiritsa ntchito chiwerengero chochulukirapo ndi malo osungira, chiwerengero chokwanira chikhoza kuwerengedwa, chomwe chidzachepetsa kulondola kwa chiwerengerocho. Choncho, popanda zosowa zosafunikira izi zili bwino kuti musamachitire nkhanza.
Phatikizani mosamalitsa pazenera, mukufunikira pazomwe mukukonzekera. Mwachitsanzo, muli ndi ntchito yowonjezera manambala awiri 4,41 ndi 4,34, koma ndi kofunika kuti pakhale tsamba limodzi lokha lamasitomala pambuyo pa chiwonetsero pa pepala. Tikapanga mawonekedwe oyenera a maselo, makhalidwe adayamba kuwonekera pa pepala. 4,4 ndi 4,3, koma powonjezeredwa, pulogalamuyi sichisonyeza nambala mu selo chifukwa cha zotsatira 4,7ndikuyamikira 4,8.
Izi ndizo chifukwa chakuti kuwerengetsera kwa Excel kumapitirizabe kuwerengetsa 4,41 ndi 4,34. Pambuyo kuwerengera, zotsatira zake ndizo 4,75. Koma, popeza tikuyika maonekedwe kuti tiwonetse manambala omwe ali ndi malo amodzi okhazikika, kuzungulira kumachitika ndipo chiwerengero chikuwonetsedwa mu selo 4,8. Kotero, izo zimapanga mawonekedwe omwe pulogalamuyo yalakwitsa (ngakhale izi siziri chomwecho). Koma pa pepala lofalitsidwa motere 4,4+4,3=8,8 ndi kulakwitsa. Choncho, pakadali pano, ndizomveka kutembenuzira malo olondola monga pawindo. Ndiye Excel iwerengera popanda kulingalira manambala omwe pulogalamuyo imasunga mu kukumbukira, koma molingana ndi zikhalidwe zosonyezedwa mu selo.
Kuti mudziwe kufunika kwa chiwerengero chimene Excel amatenga kuti awerengere, muyenera kusankha selo limene lili. Pambuyo pake, phindu lake lidzawonetsedwa mu bar, yomwe imasungidwa mu Memory Memory.
Phunziro: Nambala zozungulira zambiri
Kutembenuzira zochitika zolondola monga pawindo mu Excel zamakono
Tsopano tiyeni tipeze momwe tingatsegulire molondola monga pawindo. Choyamba, ganizirani momwe mungachitire zimenezi pa chitsanzo cha Microsoft Excel 2010 ndi kumasulira kwake. Iwo ali ndi gawo ili likuphatikizapo mwa njira yomweyo. Kenako tikuphunzira momwe tingagwiritsire ntchito molondola pazenera pa Excel 2007 komanso mu Excel 2003.
- Pitani ku tabu "Foni".
- Pawindo limene limatsegula, dinani pa batani "Zosankha".
- Fenje yowonjezera yowonjezera imayambika. Pitani ku gawolo "Zapamwamba"amene dzina lake lili m'ndandanda kumanzere kwawindo.
- Atapita ku gawolo "Zapamwamba" pita kumbali yakanja yawindo, momwe mipangidwe yambiri ya pulogalamuyi ilili. Pezani malo osungira "Pofotokoza bukhu ili". Ikani nkhuni pafupi ndi parameter "Konzani molondola pawindo".
- Pambuyo pake, bokosi la bokosi likupezeka, lomwe likunena kuti kulondola kwa ziwerengero kudzachepetsedwa. Timakanikiza batani "Chabwino".
Pambuyo pake, mu Excel 2010 ndi mtsogolo, njirayi idzayankhidwa. "molondola pazenera".
Kuti mulepheretse njirayi, samitsani bokosilo m'mawindo osankhidwa pafupi ndi zochitika. "Konzani molondola pawindo"ndiye dinani batani "Chabwino" pansi pazenera.
Sinthani zosintha zolondola pazenera pa Excel 2007 ndi Excel 2003
Tsopano tiyeni tiyang'ane mofulumira momwe momwe kulondola kulili kutsegulidwa, monga pa chinsalu mu Excel 2007 ndi mu Excel 2003. Ngakhale kuti mawotchi awa akuwoneka kuti ndi amatha, iwo amagwiritsidwa ntchito ndi owerenga ambiri.
Choyamba, ganizirani momwe mungathandizire mu Excel 2007.
- Dinani ku chizindikiro cha Office Microsoft ku kona kumtunda kumanzere pawindo. Mundandanda womwe ukuwonekera, sankhani chinthucho "Excel Options".
- Pawindo limene limatsegula, sankhani chinthucho "Zapamwamba". Mu gawo labwino lawindo pa gulu la machitidwe "Pofotokoza bukhu ili" Ikani nkhuni pafupi ndi parameter "Konzani molondola pawindo".
Mchitidwe wokonzekera ngati chinsalu chidzapatsidwa.
Mu Excel 2003, ndondomeko yothandizira machitidwe omwe tikusowa amasiyana kwambiri.
- Mu menyu yopingasa, dinani pa chinthucho "Utumiki". M'ndandanda yomwe imatsegula, sankhani malo "Zosankha".
- Fenje lazitali likuyambira. Muli, pitani ku tabu "Ziwerengero". Kenaka, yikani nkhuni pafupi ndi chinthucho "Kulondola pawindo" ndipo dinani pa batani "Chabwino" pansi pazenera.
Monga mukuonera, ndi zophweka kukhazikitsa njira yolondola monga pawonekera pa Excel, mosasamala kanthu za pulogalamuyo. Chinthu chachikulu ndicho kudziwa ngati mungayambitse njirayi pazochitika zina kapena ayi.
