Maitiro ekutenderedza nhamba muExcel. Nhamba yefomati kuburikidza nemenu yemukati, kuseta iyo inodiwa kurongeka, kuratidza marongero

The spreadsheet Excel ine hupamhi hwekushanda hunokubvumira kuti uite zvakasiyana-siyana zvekugadzirisa neruzivo rwenhamba. Zvinowanzoitika kuti kana uchiita zviito zvakasiyana-siyana, zvikamu zviduku zvinotenderedzwa. Ichi chinhu chinobatsira kwazvo, sezvo mazhinji ebasa muchirongwa haadi mhedzisiro chaiyo. Zvisinei, kune maverengero akadaro apo zvakakosha kuchengetedza kurongeka kwechigumisiro, pasina kushandiswa kwekutenderera. Kune nzira dzakawanda dzekushanda nenhamba dzinotenderera. Ngatitarisei pane zvese zvakadzama.

Nhamba dzinochengetwa sei muExcel uye dzinoratidzwa pachiratidziri

Nzira yespredishiti inoshanda pamhando mbiri dzeruzivo rwenhamba: fungidziro uye chaiyo. Munhu anoshanda mumupepeti wespredishiti anogona kusarudza nzira yekuratidza kukosha kwenhamba, asi muExcel pachayo, data iri muchimiro chaicho - kusvika kune gumi nemashanu mavara mushure meiyo decimal point. Mune mamwe mazwi, kana chiratidziro chikaratidza dhata kusvika kunzvimbo mbiri dzedesimali, saka spreadsheet inoreva rekodhi rakanyatsojeka mundangariro panguva yekuverenga.

Iwe unogona kugadzirisa kuratidzwa kwenhamba yeruzivo pachiratidziro. Nzira yekutenderera inoitwa maererano nemitemo inotevera: zviratidzo kubva kune zero kusvika kune ina zvakabatanidzwa zvakakomberedzwa pasi, uye kubva pamashanu kusvika kune mapfumbamwe - kusvika kune imwe huru.

Zvimiro zvekutenderedza nhamba dzeExcel

Ngationgororei zvakadzama nzira dzinoverengeka dzekutenderedza ruzivo rwenhamba.

Kutenderera neRibhoni Mabhatani

Funga nezve nyore kutenderedza nzira yekugadzirisa. Detailed mirairo inoita seizvi:

1. Isu tinosarudza sero kana huwandu hwemasero.
2. Isu tinoenda kuchikamu che "Kumba" uye mu "Nhamba" yekuraira bhuroka, tinya LMB pane "Derece bit kudzika" kana "Wedzera bit kudzika" chinhu. Zvakakosha kucherechedza kuti data yakasarudzwa chete yenhamba ndiyo inotenderedzwa, asi kusvika kumadijiti gumi neshanu enhamba anoshandiswa pakuverenga.
3. Kuwedzera kwemavara nerimwe mushure mecomma kunoitika mushure mekudzvanya pane chinhu "Wedzera bit kudzika".

4. Kudzikira mavara nerimwe kunoitwa mushure mekudzvanya pane "Decrease bit deep" element.

Kutenderera neSero Format

Uchishandisa bhokisi rakanzi "Cell Format", zvinokwanisika zvakare kuita kutenderedza editing. Detailed mirairo inoita seizvi:

1. Isu tinosarudza sero kana renji.
2. Dzvanya RMB pane yakasarudzwa nzvimbo. Menyu yakakosha yemamiriro ekunze yavhurwa. Pano tinowana chinhu chinonzi "Format Cells ..." uye tinya LMB.

3. Hwindo reFormat Cells rinobuda. Enda kune "Nhamba" chikamu. Isu tinoteerera kune iyo column "Numeric mafomati:" uye isa chiratidzo "Numeric". Kana ukasarudza imwe fomati, chirongwa hachizokwanisa kuita nhamba dzekutenderera.. Pakati pehwindo padivi pe "Nhamba yenzvimbo dzedesimali:" tinoisa huwandu hwemavara atinoronga kuona panguva yekuita.

4. Pakupedzisira, tinya pane "OK" chinhu kuti usimbise shanduko dzese dzakaitwa.

Seta maverengero ekuverenga

Mune nzira dzakatsanangurwa pamusoro apa, maparamendi akaiswa aive nemhedzisiro chete pane yekunze kuburitsa kwenhamba ruzivo, uye pakuita masvomhu, dzakanyanya kukosha dzakashandiswa (kusvika kune gumi neshanu). Ngatitaurei zvakadzama pamusoro pekugadzirisa kurongeka kwekuverenga. Detailed mirairo inoita seizvi:

1. Enda kuchikamu che "Faira", uye kuruboshwe rwehwindo idzva tinowana chinhu chinonzi "Parameters" uye tinya pairi neLMB.

2. Bhokisi rinonzi "Excel Options" rinoonekwa pachiratidziro. Tinoenda ku "Advanced". Isu tinowana block yemirairo "Paunenge uchiverengera bhuku iri." Zvinokosha kucherechedza kuti chinjo dzakaitwa dzichashanda kubhuku rose. Isa cheki padivi pechinyorwa "Seta chokwadi sepahwindo." Chekupedzisira, tinya pane "OK" chinhu kusimbisa shanduko dzese dzakaitwa.

3. Ready! Iye zvino, kana uchiverenga ruzivo, kukosha kwekubuda kwenhamba yedata pachiratidziro ichatorwa mu account, uye kwete iyo inochengetwa mundangariro yespredishiti processor. Kugadzika nhamba dzakaratidzwa dzinoitwa neimwe yenzira mbiri dzatsanangurwa pamusoro apa.

Kushandiswa kwemabasa

Chenjerera! Kana mushandisi achida kugadzirisa kutenderedza paanenge achiverenga hukama kune imwe kana maseru akati wandei, asi asingaronge kudzikisa kurongeka kwekuverenga mubhuku rose rebasa, saka anofanira kushandisa kugona kweROUND opareta.

Iri basa rine mashandisiro akati wandei, kusanganisira mukubatana nemamwe maoperator. Mune main operators, kutenderera kunoitwa:

• "ROUNDDOWN" - kune nhamba iri pedyo pasi mumodulus;
• "ROUNDUP" - kusvika kune yakakosha kukosha kumusoro mumodulo;
• "OKRVUP" - nekurongeka kwakatarwa kumusoro kwemodulo;
• "OTBR" - kusvika panguva iyo iyo nhamba inova nhamba yakazara;
• "KUDZORERA" - kusvika kunhamba yakatarwa yemavara edesimali zvinoenderana neyakagamuchirwa miyero yekutenderedza;
• "OKRVNIZ" - nekururama kwakatarwa pasi modulo;
• "KUNYANGE" - kune iri pedyo kunyange kukosha;
• "OKRUGLT" - nekururama kwakataurwa;
• "ODD" - kune iri pedyo isingawanzo kukosha.

Iwo ROUNDDOWN, ROUND, uye RUNDUP vanoshanda vane inotevera general fomu: =Zita remushandisi (nhamba;number_digits). Ngatitii mushandisi arikuda kuita kutenderedza maitiro kune kukosha 2,56896 kune 3 nzvimbo dzedesimali, ipapo anofanira kupinda “=RUNDZO(2,56896;3)”. Pakupedzisira, achagamuchira:

Vashandisi "ROUNDDOWN", "ROUND", uye "ROUNDUP" vane fomu rinotevera: =Zita remushandisi(nhamba,chaizvo). Kana mushandisi achida kutenderedza kukosha 11 kune iri padyo yakawanda yevaviri, saka anofanira kupinda "= RUNDO(11;2)". Pakupedzisira, achagamuchira:

Vashandisi "ODD", "SELECT", uye "EVEN" vane fomu rinotevera:  =Zita remushandisi (nhamba). Semuenzaniso, kana uchitenderedza kukosha 17 kune iri padyo kunyange kukosha, anofanirwa kupinda «=CHINA (17)». Pakupedzisira, achagamuchira:

Zvakakodzera kucherechedza! Mushandi anogona kuiswa mumutsara wemabasa kana muchitokisi pachayo. Usati wanyora basa musero, rinofanira kusarudzwa pachine nguva nerubatsiro rweLMB.

Iyo spreadsheet inewo imwe opareta nzira yekuisa iyo inokutendera iwe kuita maitiro ekutenderedza nhamba ruzivo. Yakanakira kana iwe uine tafura yenhamba dzinoda kushandurwa kuita dzakatenderedzwa tsika mune imwe column. Detailed mirairo inoita seizvi:

1. Isu tinotamira kune "Formulas" chikamu. Pano tinowana chinhu "Math" uye tinya pairi neLMB. Runyoro rurefu rwakazaruka, umo tinosarudza mushandisi anonzi "ROUND".

2. Bhokisi renhaurirano rinonzi "Function Arguments" rakabuda pachiratidziro. Mutsara "Nhamba" inogona kuzadzwa neruzivo iwe pachako nekupinza kwemaoko. Imwe sarudzo inobvumidza iwe kuti utenderere otomatiki ruzivo rwese ndeye kudzvanya LMB pane iyo icon iri kurudyi rwemunda wekunyora kupokana.

3. Mushure mekudzvanya pane iyi icon, iyo "Function Arguments" hwindo rakadonha. Isu tinodzvanya LMB pamunda wepamusoro wekoramu, ruzivo rwatinoronga kutenderedza. Chiratidzo chakaonekwa mubhokisi renharo. Isu tinodzvanya LMB pane icon iri kurudyi rweukoshi hunoonekwa.

4. Iyo skrini zvakare yakaratidza hwindo rainzi "Function Arguments". Mumutsara we "Nhamba yemanhamba" tinotyaira mune zvishoma zvakadzika izvo zvakakosha kudzikisa zvikamu. Pakupedzisira, tinya pane "OK" chinhu kuti usimbise shanduko dzese dzakaitwa.

5. Huwandu hwenhamba hwapetwa. Iye zvino isu tinoda kuita maitiro ekutenderera kune mamwe ese maseru ari mukoramu iyi. Kuti uite izvi, fambisa chinongedzo chembeva kukona yekurudyi yemunda nemhedzisiro yakaratidzwa, uyezve, nekubata LMB, tambanudza fomuro kusvika kumagumo etafura.

6. Ready! Taita nzira yekutenderedza maseru ese ari muchikamu chino.

Maitiro ekukomberedza kumusoro uye pasi muExcel

Ngatitarisei zvakanyanya kune ROUNUP mushandisi. Iyo yekutanga nharo inozadzwa neinotevera: kero yesero inopinzwa nenhamba ruzivo. Kuzadza gakava rechipiri kune mitemo inotevera: kupinda kukosha "1" zvinoreva kutenderedza chikamu chedesimali kune chikamu chakakwana, kuisa kukosha "2" zvinoreva kuti mushure mekushandiswa kwemaitiro ekutenderedza pave nehunhu mumwechete mushure meiyo decimal point. , etc. Isa kukosha kunotevera mumutsara wekuisa mafomula: = RUNDUP (A1). Pakupedzisira tinowana:

Zvino ngatitarisei muenzaniso wekushandisa ROUNDDOWN opareta. Isa kukosha kunotevera mumutsara wekuisa mafomula: =ROUNDSAR(A1).Pakupedzisira tinowana:

Izvo zvakakosha kuti tizive kuti vashandisi "ROUNDDOWN" uye "ROUNDUP" vanoshandiswawo kuita maitiro ekutenderedza mutsauko, kuwanda, nezvimwe.

Muenzaniso wekushandisa:

Nzira yekutenderedza kune nhamba yakazara muExcel?

Iyo "SELECT" mushandisi inobvumidza iwe kushandisa kutenderedza kune yakazara uye kurasa mavara mushure meiyo decimal point. Somuenzaniso, funga mufananidzo uyu:

Basa rakakosha respredishiti rinodaidzwa kuti "INT" rinokutendera kuti udzore kukosha kwakazara. Pane nharo imwe chete - "Nhamba". Iwe unogona kuisa chero nhamba yedata kana maseru coordinates. Muenzaniso:

Chinhu chikuru chakashata cheanoshanda ndechekuti kutenderera kunoitwa pasi chete.

Kuti utenderedze ruzivo rwenhamba kusvika kuhuwandu hunokosha, zvinodikanwa kushandisa vaimbofungidzirwa vashandi "ROUNDDOWN", "EVEN", "ROUNDUP" uye "ODD". Mienzaniso miviri yekushandisa maoperator aya kuita kutenderedza kurudzi rwakakwana:

Nei Excel ichitenderedza nhamba huru?

Kana chikamu chepurogiramu chine kukosha kukuru, semuenzaniso 73753956389257687, zvino inotora fomu rinotevera: 7,37539E + 16. Izvi zvinodaro nekuti munda une "General" maonero. Kuti ubvise rudzi urwu rwekubuda kwehurefu hurefu, unofanirwa kugadzirisa chimiro chemunda uye shandura rudzi rweNumeric. Iko kusanganiswa kwekiyi "CTRL + SHIFT + 1" ichakubvumidza kuti uite maitiro ekugadzirisa. Mushure mekuita zvigadziriso, iyo nhamba inotora iyo chaiyo fomu yekuratidzira.

mhedziso

Kubva pachinyorwa, takaona kuti muExcel kune nzira mbiri huru dzekutenderedza chiratidziro chinooneka cheruzivo rwenhamba: kushandisa bhatani riri paturu, pamwe nekugadzirisa mafomati esero. Uyezve, iwe unogona kuita kugadzirisa kutenderedzwa kweruzivo rwakaverengerwa. Kune zvakare akati wandei sarudzo dzeizvi: editing gwaro paramita, pamwe nekushandisa masvomhu vanoshanda. Mumwe nemumwe mushandisi achakwanisa kuzvisarudzira nzira yakanyanya kunaka inokodzera zvinangwa zvake uye zvinangwa.