Kurongeka sepahwindo muExcel: maitiro ekuseta

Kazhinji, vashandisi vanoverenga muExcel havazive kuti nhamba dzakaratidzwa mumaseru hazvigaro kubvumirana nedata rinoshandiswa nechirongwa kuita masvomhu. Zviri pamusoro pemafractional values. Icho chokwadi ndechekuti chirongwa cheExcel chinochengeta mundangariro manhamba manhamba ane anosvika gumi nemashanu manhamba mushure meiyo decimal point. Uye zvisinei nekuti, toti, 15, 1 kana 2 manhamba chete ndiyo icharatidzwa pachiratidziri (semhedzisiro yesero fomati marongero), Excel ichashandisa iyo yakazara nhamba kubva mundangariro pakuverenga. Dzimwe nguva izvi zvinotungamirira kumigumisiro isingatarisirwi nemigumisiro. Kuti udzivise izvi kuti zvisaitike, unofanirwa kugadzirisa iko kutenderera kurongeka, kureva, kuiisa kune imwechete sepahwindo.

Maitiro ekutenderedza kunoshanda sei muExcel

Chokutanga pane zvose, unofanirwa kufungisisa chokwadi chokuti zviri nani kusashandisa urongwa uhwu zvisina kufanira. Zvakakodzera kuti unyatsofunga uye uzvisarudzire iwe pachako kana zvine musoro kumisa kurongeka senge pachiratidziri kana kwete, sezvo kazhinji pakuita masvomhu nenhamba huru yenhamba dzezvikamu, izvo zvinonzi cumulative effect inoitika, iyo inoderedza kunyatsoita masvomhu akaitwa.

Izvo zvakakodzera kuseta iko kurongeka senge pachiratidziro mune zvinotevera zviitiko. Semuenzaniso, ngatitii tinoda kuwedzera nhamba 6,42 uye 6,33, asi isu tinoda chete kutaridza nzvimbo imwe chete yedesimali, kwete mbiri.

Kuti uite izvi, sarudza maseru aunoda, tinya-kurudyi paari, sarudza chinhu "Format Cells ..".

Kuve mu "Nhamba" tab, tinya pa "Numeric" fomati mune runyorwa kuruboshwe, wobva waisa kukosha ku "1" yehuwandu hwenzvimbo dzedesimali uye tinya OK kuti ubude pahwindo rekufomatidza uye chengetedza marongero.

Mushure mezviito zvakatorwa, bhuku richaratidza kukosha 6,4 uye 6,3. Uye kana idzi nhamba dzezvikamu dzikawedzerwa, chirongwa chinopa huwandu 12,8.

Zvinogona kuita sekuti chirongwa hachishande nemazvo uye chakakanganisa mukuverenga, nekuti 6,4 + 6,3 = 12,7. Asi ngationei kana izvi zviri izvo chaizvo, uye nei mhedzisiro yakadaro yakaitika.

Sezvatataura pamusoro, Excel inotora nhamba dzekutanga dzekuverenga, kureva 6,42 uye 6,33. Mukuita kupfupisa, mhedzisiro i6,75. Asi nekuda kwekuti iyo imwe nzvimbo yegumi isati yatsanangurwa mumagadzirirwo efomati, sero rinobuda rinotenderedzwa zvinoenderana, uye mhedzisiro inoratidzwa yakaenzana ne6,8.

Kuti udzivise kuvhiringika kwakadaro, iyo yakakwana mhinduro ndeyekumisa kutenderera chaiko sepahwindo.

Cherechedza: Kuti uwane kukosha kwepakutanga kunoshandiswa nepurogiramu yekuverenga, tinya pasero rine nhamba inokosha, uye teerera kune formula bar, iyo icharatidza nhamba yakazara yakachengetwa mundangariro yepurogiramu.

Maitiro ekugadzirisa iko kurongeka senge pachiratidziri

Chekutanga, ngationei kuti kutenderera kurongeka kunogadziriswa sei sepahwindo mushanduro Excel 2019.

1. Isu tinoenda kune "Faira" menyu.
2. Dzvanya pane chinhu "Settings" mune runyorwa kuruboshwe pazasi chaipo.
3. Iwindo rekuwedzera rine mapurogiramu epurogiramu richazarura, kuruboshwe rwatinodzvanya pachikamu che "Advanced".
4. Zvino, kudivi rerudyi rezvirongwa, tsvaga bhuroka inonzi "Paunenge uchiverengera bhuku iri:" uye tarisa bhokisi riri padivi pe "Seta iyo yakatsanangurwa chaiyo" sarudzo. Purogiramu ichatinyevera kuti kururama kuchaderedzwa negadziriro iyi. Isu tinobvumirana neizvi nekudzvanya bhatani OK uyezve OK kuti usimbise shanduko uye kubuda pahwindo resarudzo.

Cherechedza: Kana zvikave zvakakosha kudzima iyi modhi, enda kune iwo ma paramita uye ingo bvisa inoenderana cheki bhokisi.

Kugadzirisa Rounding Precision mumavhezheni ekutanga

Zvisinei nekugadzikiswa kwechirongwa cheExcel, mazhinji emabasa ekutanga uye algorithm yekuashandisa anochinja zvishoma kana kuramba akafanana kuitira kuti vashandisi, mushure mekuchinja kune imwe vhezheni, vasasangana nematambudziko ekujaira iyo itsva interface, nezvimwe.

Kwatiri, iyo algorithm yekuisa iko kurongeka senge pachiratidziro mumavhezheni ekutanga echirongwa chakada kufanana nezvatakafunga pamusoro pevhezheni ye2019.

Microsoft Excel 2010

1. Enda kune "Faira" menyu.
2. Dzvanya pane chinhu chine zita "Settings".
3. Muwindo rezvirongwa rinovhurwa, tinya pane "Advanced" chinhu.
4. Isa tiki pamberi pechisarudzo "Seta kurongeka senge pachiratidziri" mune zvigadziriso block "Kana uchiverengera bhuku iri". Zvakare, isu tinosimbisa zvigadziriso zvakaitwa nekudzvanya bhatani re OK, tichifunga nezvekuti kurongeka kwekuverenga kuchaderedzwa.

Microsoft Excel 2007 uye 2003

Shanduro dzemakore aya, maererano nevamwe vashandisi, dzatove dzechinyakare. Vamwe vanozviona sezviri nyore uye vanoramba vachishanda mazviri kusvikira nhasi, pasinei nekubuda kweshanduro itsva.

Ngatitangei neshanduro ya2007.

1. Dzvanya pa "Microsoft Office" icon, iyo iri mukona yepamusoro kuruboshwe rwehwindo. Rondedzero inofanira kuoneka yaunoda kusarudza chikamu chinonzi "Excel Options".
2. Rimwe hwindo rinozaruka raunoda "Advanced" chinhu. Tevere, kurudyi, sarudza "Paunenge uchiverengera bhuku rino" boka rezvirongwa uye tarisa bhokisi riri padyo ne "Seta kurongeka sepahwindo" basa.

Neshanduro yekutanga (2013), zvinhu zvakati siyanei.

1. Mupamusoro menyu bar iwe unofanirwa kuwana "Sevhisi" chikamu. Mushure mekusarudzwa, rondedzero icharatidzwa iyo yaunoda kudzvanya pane "Options" chinhu.
2. Muhwindo rinovhura nemaparamita, sarudza "Kuverengera" uye wobva watarisa bhokisi riri padivi pe "Kururama sepahwindo" sarudzo.

mhedziso

Kuisa iko kurongeka senge pachiratidziro muExcel kunobatsira, uye mune mamwe mamiriro, basa rinokosha iro risiri mushandisi wese anoziva nezvaro. Hazvizove zvakaoma kuita zvigadziro zvakakodzera mune chero shanduro yepurogiramu, sezvo pasina misiyano yakakosha muurongwa hwekuita, uye misiyano inongova munzvimbo dzakagadziridzwa, umo, zvisinei, kuenderera kunochengetedzwa.