Kulondola monga pazenera ku Excel: momwe mungakhazikitsire

Nthawi zambiri, ogwiritsa ntchito omwe amawerengera mu Excel samazindikira kuti manambala omwe amawonetsedwa m'maselo samagwirizana nthawi zonse ndi zomwe pulogalamuyo imagwiritsa ntchito powerengera. Ndi za ma fractional values. Chowonadi ndi chakuti pulogalamu ya Excel imasunga manambala okumbukira omwe amakhala ndi manambala mpaka 15 pambuyo pa decimal. Ndipo ngakhale kuti, tinene, manambala 1, 2 kapena 3 okha ndi omwe adzawonetsedwa pazenera (chifukwa cha mawonekedwe amtundu wa cell), Excel idzagwiritsa ntchito nambala yonse yochokera pamtima kuwerengera. Nthawi zina izi zimabweretsa zotsatira zosayembekezereka komanso zotsatira. Kuti izi zisachitike, muyenera kusintha kulondola kozungulira, ndiko kuti, kuyiyika mofanana ndi pazenera.

Momwe kuzungulira kumagwirira ntchito mu Excel

Choyamba, muyenera kuganizira mfundo yakuti ndibwino kuti musagwiritse ntchito izi mopanda pake. Ndikoyenera kuganiza mozama ndikudzipangira nokha ngati kuli koyenera kuyika zowona ngati pazenera kapena ayi, chifukwa nthawi zambiri powerengera ndi manambala owerengeka, zomwe zimatchedwa kuti cumulative effect zimachitika, zomwe zimachepetsa kulondola kwa mawerengedwe ochitidwa.

Ndikoyenera kukhazikitsa kulondola monga pazenera muzochitika zotsatirazi. Mwachitsanzo, tiyerekeze kuti tikufuna kuwonjezera manambala 6,42 ndi 6,33, koma tikufuna kuwonetsa malo amodzi okha, osati awiri.

Kuti muchite izi, sankhani ma cell omwe mukufuna, dinani pomwepa, sankhani "Maselo a Format ..".

Pokhala pagawo la "Nambala", dinani mtundu wa "Numeric" pamndandanda womwe uli kumanzere, kenako ikani mtengo kukhala "1" pa kuchuluka kwa malo owerengera ndikudina CHABWINO kuti mutuluke pazenera la masanjidwe ndikusunga zosintha.

Pambuyo pa zomwe zachitika, bukuli liziwonetsa 6,4 ndi 6,3. Ndipo ngati manambala ang'onoang'ono awa awonjezedwa, pulogalamuyo ipereka kuchuluka kwa 12,8.

Zingawoneke kuti pulogalamuyo siigwira ntchito bwino ndipo inalakwitsa powerengera, chifukwa 6,4 + 6,3 = 12,7. Koma tiyeni tiwone ngati izi zilidi choncho, ndipo chifukwa chiyani zotsatira zake zidachitika.

Monga tafotokozera pamwambapa, Excel imatenga manambala oyambira kuwerengera, mwachitsanzo, 6,42 ndi 6,33. Powafotokozera mwachidule, zotsatira zake ndi 6,75. Koma chifukwa chakuti malo amodziwo asanatchulidwe muzosankha, selo lotsatila limazunguliridwa moyenerera, ndipo zotsatira zomaliza zimawonetsedwa mofanana ndi 6,8.

Kuti mupewe chisokonezo chotere, njira yabwino ndiyo kukhazikitsa kulondola kozungulira monga pawonekera.

Zindikirani: Kuti mudziwe mtengo woyambirira womwe umagwiritsidwa ntchito ndi pulogalamu yowerengera, dinani pa cell yomwe ili ndi nambala, kenako tcherani khutu ku bar formula, yomwe iwonetsa nambala yonse yosungidwa muchikumbutso cha pulogalamuyi.

Momwe mungasinthire kulondola ngati pazenera

Choyamba, tiyeni tiwone momwe kulondola kozungulira kumakonzedwera monga pa skrini mu mtunduwo Excel 2019.

1. Timapita ku menyu "Fayilo".
2. Dinani pa chinthucho "Zikhazikiko" pamndandanda womwe uli kumanzere kumunsi kwenikweni.
3. Zenera lowonjezera lomwe lili ndi magawo a pulogalamu lidzatsegulidwa, kumanzere komwe timadina gawo la "Advanced".
4. Tsopano, kumanja kwa zoikamo, yang'anani chipika chotchedwa "Pamene mukuwerengeranso bukuli:" ndipo yang'anani bokosi lomwe lili pafupi ndi "Ikani zolondola zomwe zafotokozedwa". Pulogalamuyi idzatichenjeza kuti kulondola kudzachepetsedwa ndi makonzedwe awa. Timavomereza izi podina batani la OK ndiyeno OK kachiwiri kutsimikizira zosintha ndikutuluka pazenera la zosankha.

Zindikirani: Ngati pakufunika kuyimitsa njirayi, pitani ku magawo omwewo ndikungochotsa bokosi lofananira.

Kusintha Kulondola Kwambiri M'matembenuzidwe Akale

Ngakhale kusinthidwa kosalekeza kwa pulogalamu ya Excel, ntchito zambiri zoyambira ndi ma aligorivimu ogwiritsira ntchito zimasintha pang'ono kapena kukhalabe chimodzimodzi kuti ogwiritsa ntchito, atasinthira ku mtundu watsopano, asakumane ndi zovuta kuzolowera mawonekedwe atsopano, ndi zina zambiri.

Kwa ife, njira yokhazikitsira kulondola monga pazenera m'mitundu yam'mbuyomu ya pulogalamuyi ndi yofanana ndi yomwe tidakambirana pamwambapa pa mtundu wa 2019.

Microsoft Excel 2010

1. Pitani ku menyu "Fayilo".
2. Dinani pa chinthucho ndi dzina la "Zikhazikiko".
3. Pazenera lomwe limatsegulira, dinani chinthucho "Advanced".
4. Ikani chizindikiro kutsogolo kwa njira "Ikani zolondola monga pazenera" mu block block "Mukamawerengeranso bukuli". Apanso, timatsimikizira zosintha zomwe zidapangidwa podina batani la OK, poganizira kuti kulondola kwa mawerengedwe kudzachepetsedwa.

Microsoft Excel 2007 ndi 2003

Zomasulira zazaka izi, malinga ndi ogwiritsa ntchito ena, zatha kale. Ena amawaona kuti ndi abwino kwambiri ndipo akupitirizabe kugwira ntchito mpaka lero, ngakhale atulukira mitundu yatsopano.

Tiyeni tiyambe ndi mtundu wa 2007.

1. Dinani pa chithunzi cha "Microsoft Office", chomwe chili pakona yakumanzere kwazenera. Mndandanda uyenera kuwoneka womwe muyenera kusankha gawo lotchedwa "Zosankha za Excel".
2. Wina zenera adzatsegula kumene muyenera "Zapamwamba" katundu. Kenako, kumanja, sankhani "Pamene mukuwerengeranso bukuli" gulu la zoikamo ndikuyang'ana bokosi lomwe lili pafupi ndi ntchito ya "Khazikitsani kulondola ngati pazenera".

Ndi mtundu wakale (2013), zinthu ndi zosiyana.

1. Pamwamba pa menyu muyenera kupeza gawo la "Service". Pambuyo posankhidwa, mndandanda udzawonetsedwa momwe muyenera kudina "Zosankha".
2. Pazenera lomwe limatsegulidwa ndi magawo, sankhani "Kuwerengera" ndikusankha bokosi lomwe lili pafupi ndi "Kulondola ngati pa skrini".

Kutsiliza

Kukhazikitsa kulondola monga pazenera ku Excel ndikothandiza kwambiri, ndipo nthawi zina, ntchito yofunika kwambiri yomwe si wogwiritsa ntchito aliyense amadziwa. Sizingakhale zovuta kupanga zoikika zoyenera muzomasulira zilizonse za pulogalamuyi, chifukwa palibe kusiyana kwakukulu mu dongosolo lochitapo kanthu, ndipo kusiyana kuli kokha m'malo osinthidwa, momwe, komabe, kupitiriza kumasungidwa.