Momwe mungakhazikitsire kulondola ngati pa skrini mu Excel. Momwe mungakhazikitsire ndikusintha kulondola mu Excel

Pochita mawerengedwe ena mu Excel omwe amagwirizana mwachindunji ndi magawo ang'onoang'ono, ogwiritsa ntchito amatha kukumana ndi zochitika zomwe nambala yosayembekezereka imapezeka mu selo ndi zotsatira zake. Izi ndichifukwa cha luso la pulogalamuyi. Mwachikhazikitso, Excel imatenga magawo ang'onoang'ono powerengera ndi manambala 15 pambuyo pa decimal point, pomwe selo imawonetsa mpaka manambala atatu. Kuti musamalandire zotsatira zosayembekezereka zowerengera, ndikofunikira kuyikatu kulondola kozungulira kofanana ndi komwe kumawonetsedwa pazenera pamaso pa wogwiritsa ntchito.

Momwe makina ozungulira amagwirira ntchito mu Excel

Musanayambe kukhazikitsa kuzunguliridwa kwa magawo a magawo, ndi bwino kuti mudziwe zambiri za momwe dongosololi limagwirira ntchito, zomwe zidzakhudzidwe ndi kusintha magawo ake.

Sitikulimbikitsidwa kuti musinthe makonzedwe a nthawi yomwe mawerengedwe okhudza tizigawo tating'onoting'ono amachitidwa kawirikawiri. Izi zitha kubweza zomwe mukufuna.

Chimodzi mwazinthu zomwe zimalangizidwa kuti ziwonjezeke pakuwerengera molondola ndikuwonjezera manambala angapo pogwiritsa ntchito malo amodzi okha. Kuti mumvetse zomwe zimachitika nthawi zambiri popanda kusintha kowonjezera, muyenera kuganizira chitsanzo chothandiza. Wogwiritsa ntchito ayenera kuwonjezera manambala awiri - 4.64 ndi 3.21, pamene akutenga nambala imodzi yokha pambuyo pa decimal monga maziko. Kachitidwe:

1. Poyamba, muyenera kusankha ma cell omwe ali ndi manambala omwe adalowamo ndi mbewa kapena kiyibodi.
2. Dinani RMB, sankhani ntchito ya "Format Cells" kuchokera pamenyu.

3. Pambuyo pake, zenera lokhala ndi zoikamo lidzawoneka, momwe muyenera kupita ku tabu "Nambala".
4. Kuchokera pamndandanda muyenera kusankha mtundu wa "Numeric".
5. M'munda waulere "Nambala ya malo decimal" ikani mtengo wofunikira.
6. Zimatsalira kusunga zoikamo mwa kukanikiza batani "Chabwino".

Komabe, zotsatira zake sizikhala 7.8, koma 7.9. Chifukwa cha izi, wogwiritsa ntchito amatha kuganiza kuti cholakwika chachitika. Mtengo wapang'onopang'onowu unapezedwa chifukwa chakuti mwachisawawa Excel inkaphatikiza manambala athunthu, ndi malo onse a decimal. Koma malinga ndi zina zowonjezera, wogwiritsa ntchitoyo adatchula nambala yokhala ndi nambala imodzi yokha pambuyo pa decimal kuti iwonetsedwe pazenera. Chifukwa cha izi, mtengo wotsatira wa 7.85 udasonkhanitsidwa, pomwe 7.9 idatuluka.

Zofunika! Kuti mudziwe zamtengo wapatali zomwe pulogalamuyi idzatenge ngati maziko pakuwerengera, muyenera dinani pa selo ndi nambala ya LMB, tcherani khutu pamzere womwe fomula yochokera ku selo imawerengedwa. Ndi momwemo kuti mtengo umene udzatengedwe ngati maziko a mawerengedwe popanda zowonjezera zowonjezera zidzawonetsedwa.

Kukhazikitsa kulondola kozungulira

Njira yosinthira kuzunguliridwa kwamitengo yamagulu a Excel (2019) - ndondomekoyi:

1. Pitani ku menyu yayikulu "Fayilo".

2. Pitani ku tabu "Parameters". Mutha kuzipeza pansi pa tsamba kumanzere.
3. Sankhani zokonda zapamwamba.
4. Kumanja kwa zenera lomwe likuwoneka, pezani chipika "Mukamawerengeranso bukuli", pezani ntchito "Ikani zolondola zomwe zanenedwa" mmenemo. Apa muyenera kuyang'ana bokosi.
5. Pambuyo pa izi, zenera laling'ono lochenjeza liyenera kuwonekera pazenera. Zidzawonetsa kuti pochita izi, kulondola kwa mawerengedwe m'matebulo kungachepetse. Kuti musunge zosintha, muyenera kuvomereza zosinthazo podina "Chabwino". Dinani "Chabwino" kachiwiri kuti mutuluke makonda.

Mukafunika kuzimitsa ntchito yeniyeni yozungulira kapena kuisintha, muyenera kupita kumalo omwewo, osayang'ana bokosilo kapena lowetsani chiwerengero chosiyana cha zilembo pambuyo pa chiwerengero cha decimal, chomwe chidzaganiziridwa panthawi yowerengera.

Momwe mungasinthire kulondola kwamitundu yakale

Excel imasinthidwa pafupipafupi. Imawonjezera zatsopano, koma zida zazikulu zambiri zimagwira ntchito ndipo zimakonzedwa mofananamo. Mukakhazikitsa kulondola kwamitengo mumitundu yoyambirira ya pulogalamuyi, pali kusiyana pang'ono ndi mtundu wamakono. Kwa Excel 2010:

1. Pitani ku tabu "Fayilo" pazida zazikulu.
2. Pitani ku zosankha.
3. Zenera latsopano lidzawoneka momwe muyenera kupeza ndikudina "Zapamwamba".
4. Ingotsala kuti mupeze chinthucho "Mukamawerengeranso bukuli", ikani mtanda pafupi ndi mzere "Khalani zolondola monga pazenera." Tsimikizirani zosintha, sungani zoikamo.

Ndondomeko ya Excel 2007:

1. Pagawo lapamwamba lokhala ndi zida zotseguka zamasamba, pezani chizindikiro cha "Microsoft Office", dinani pamenepo.
2. Mndandanda uyenera kuwonekera pazenera, pomwe muyenera kusankha chinthu cha "Excel Options".
3. Pambuyo kutsegula zenera latsopano, kupita "Zapamwamba" tabu.
4. Kumanja, pitani ku gulu la zosankha "Mukamawerengeranso bukuli". Pezani mzere "Ikani zolondola monga pa zenera", ikani mtanda patsogolo pake. Sungani zosintha ndi batani "Chabwino".

Ndondomeko ya Excel 2003:

1. Pezani "Service" tabu pamwamba chachikulu chazida chachikulu, kulowa izo.
2. Kuchokera pamndandanda womwe umawonekera, pitani ku gawo la "Zikhazikiko".
3. Pambuyo pake, zenera lokhala ndi zoikamo liyenera kuwoneka, pomwe muyenera kusankha "Computations".
4. Ingoyang'anani bokosi lomwe lili pafupi ndi gawo la "Accuracy as on screen".

Kutsiliza

Ngati muphunzira kuyika kulondola kozungulira mu Excel, kuyika uku kukuthandizani kuwerengera kofunikira, malinga ndi momwe mikhalidwe imakhalira, manambala okhawo uXNUMXbuXNUMXb omwe amaganizira nambala imodzi pambuyo pa decimal angaganizidwe. Komabe, tisaiwale kuzimitsa izo pa zochitika muyezo, pamene mawerengedwe ayenera kukhala olondola monga momwe tingathere, poganizira manambala onse.