Maitiro ekuseta sei chaizvo sepahwindo muExcel. Maitiro ekuseta uye kugadzirisa iko kurongeka muExcel

Paunenge uchiita mamwe maverengero muExcel ane hukama zvakananga nezvikamu zvezvikamu, vashandisi vanogona kusangana nemamiriro ezvinhu apo nhamba isingatarisirwe zvachose inooneka musero nekubuda kwechigumisiro. Izvi zvinokonzerwa nehunyanzvi hwekuita chirongwa ichi. Nekumisikidza, Excel inotora mafractional values ​​ekuverenga ane gumi nemashanu manhamba mushure meiyo decimal point, nepo sero richiratidza kusvika manhamba matatu. Kuti urege kugara uchigamuchira zvisingatarisirwi zvekuverenga mhinduro, zvinodikanwa kufanoseta kutenderera kurongeka kwakaenzana nekwakaratidzwa pachiratidziro pamberi pemushandisi.

Maitiro ekutenderedza system anoshanda muExcel

Usati watanga kuseta kutenderedzwa kwezvikamu zvezvikamu, zvinokurudzirwa kuti udzidze zvakawanda nezve mashandiro anoita sisitimu iyi, inozokanganiswa nekuchinja ma parameter ayo.

Hazvikurudzirwe kushandura marongero mumamiriro ezvinhu apo kuverenga kunosanganisira zvikamu kunoitwa kazhinji. Izvi zvinogona kukanganisa pane zvaunoda.

Imwe yemamiriro ezvinhu apo inokurudzirwa kuita zvimwe zvigadziriso kuhuwandu hwekuverenga ndeyekuwedzera nhamba dzakati wandei uchishandisa nzvimbo imwe chete yedesimali. Kuti unzwisise zvinoitika kazhinji pasina imwe gadziriso, unofanirwa kufunga nezve muenzaniso unoshanda. Mushandisi anoda kuwedzera nhamba mbiri - 4.64 uye 3.21, uchitora digit imwe chete mushure medesimali sehwaro. Maitiro:

1. Pakutanga, unofanirwa kusarudza masero ane nhamba dzakapinda mukati mavo ne mouse kana keyboard.
2. Dzvanya RMB, sarudza iyo "Format Cells" basa kubva pane yemukati menyu.

3. Mushure maizvozvi, hwindo rine zvigadziriso richaonekwa, umo iwe unofanirwa kuenda kune "Nhamba" tab.
4. Kubva pane rondedzero iwe unofanirwa kusarudza iyo "Numeric" fomati.
5. Mumunda wemahara "Nhamba yenzvimbo dzedesimali" isa kukosha kunodiwa.
6. Inosara kuchengetedza zvigadziriso nekudzvanya bhatani re "OK".

Nekudaro, mhedzisiro haizove 7.8, asi 7.9. Nekuda kweizvi, mushandisi angangofunga kuti chikanganiso chaitwa. Uku kukosha kwechikamu kwakawanikwa nekuda kwekuti nekusarudzika Excel yakapfupisa nhamba dzizere, nenzvimbo dzese dzedesimali. Asi zvinoenderana nechimwe chimiro, mushandisi anotsanangura nhamba ine digit imwe chete mushure meiyo decimal point yekuratidzwa pachiratidziri. Nekuda kweizvi, kukosha kwe7.85 kwakapetwa, uko 7.9 yakabuda.

Zvinokosha! Kuti uone kukosha kwechirongwa chinozotora sehwaro panguva yekuverenga, iwe unofanirwa kudzvanya pane sero nenhamba yeLMB, teerera kune mutsara uko iyo formula kubva musero inotsanangurwa. Iri mairi kuti kukosha kunozotorwa sechikonzero chekuverenga pasina mamwe marongero acharatidzwa.

Kuisa kutenderera chaiko

Iyo nzira yekugadzirisa kutenderedzwa kwezvikamu zvishoma zveExcel (2019) - maitiro:

1. Enda kune iyo huru menyu "Faira".

2. Enda kune "Parameters" tab. Unogona kuiwana pazasi chaipo peji padivi rekuruboshwe.
3. Sarudza zvigadziriso zvepamusoro.
4. Kurudyi kwehwindo rinoonekwa, tsvaga bhuroka "Paunenge uchiverengera bhuku iri", tsvaga basa "Seta iyo yakatsanangurwa kurongeka" mairi. Pano iwe unofanirwa kutarisa bhokisi.
5. Mushure mematanho aya, hwindo diki rekunyevera rinofanira kuoneka pachiratidziri. Icharatidza kuti nekuita chiito ichi, kururamisa kwekuverenga mumatafura kunogona kuderera. Kuti uchengetedze zvigadziriso, unofanirwa kubvumirana neshanduko nekudzvanya "OK". Dzvanya "OK" zvakare kuti usiye marongero.

Paunenge uchida kudzima iyo chaiyo yekutenderedza basa kana kuichinja, iwe unofanirwa kuenda kune imwechete marongero, uncheck bhokisi kana kuisa akasiyana nhamba yemavara mushure meiyo decimal point, iyo inozoverengerwa panguva yekuverenga.

Maitiro ekugadzirisa kurongeka mumavhezheni ekutanga

Excel inovandudzwa nguva dzose. Inowedzera zvinhu zvitsva, asi zvizhinji zvezvishandiso zvikuru zvinoshanda uye zvakagadzirirwa nenzira yakafanana. Paunenge uchiseta kutenderedza chaiko kwehunhu mumavhezheni ekutanga echirongwa, pane misiyano midiki kubva kune yazvino vhezheni. YeExcel 2010:

1. Enda kune "Faira" tab pane huru toolbar.
2. Enda kune zvingasarudzwa.
3. Iwindo idzva richaonekwa raunoda kutsvaga uye tinya "Advanced".
4. Izvo zvinosara kuti uwane chinhu "Paunenge uchiverengera bhuku iri", isa muchinjikwa padivi pemutsara "Seta kurongeka sepahwindo." Simbisa shanduko, chengetedza marongero.

Maitiro eExcel 2007:

1. Pamusoro pepaneru ine maturusi espredishiti akavhurika, tsvaga "Microsoft Office" icon, tinya pairi.
2. Rondedzero inofanirwa kuoneka pachiratidziri, kubva kwaunoda kusarudza chinhu che "Excel Options".
3. Mushure mekuvhura hwindo idzva, enda ku "Advanced" tab.
4. Kurudyi, enda kuboka rezvisarudzo "Paunenge uchiverenga bhuku iri". Tsvaga mutsara "Seta kurongeka sepahwindo", isa muchinjikwa pamberi payo. Sevha shanduko nebhatani rekuti "OK".

Maitiro eExcel 2003:

1. Tsvaga iyo "Sevhisi" tebhu pane yepamusoro huru toolbar, pinda mairi.
2. Kubva pane rondedzero inoonekwa, enda kuchikamu che "Settings".
3. Mushure meizvozvo, hwindo rine zvigadziriso rinofanira kuoneka, kubva paunofanira kusarudza "Computations".
4. Inosara yekutarisa bhokisi riri padivi pe "Kururama sepahwindo" parameter.

mhedziso

Kana iwe ukadzidza kuseta iko kutenderedza muExcel, kuseta uku kuchakubatsira iwe kuita maverengero anodiwa kana, zvinoenderana nemamiriro ezvinhu, iwo chete manhamba enhamba uXNUMXbuXNUMXbinotora iyo dhijitari imwe mushure meiyo decimal inogona kuverengerwa. Zvisinei, hatifaniri kukanganwa kuidzima kumamiriro ezvinhu akaenzana, apo kuverenga kunofanira kuva kwakarurama sezvinobvira, tichifunga nezvenhamba dzose.