Rounding kuna Excel - zviri nyore!

Munyaya ino tichakurukura imwe hofisi zvikumbiro MS Office Excel.

MS Office Excel - purogiramu Rinowanikwawo Microsoft Office Complex. Rakashandiswa dzakasiyana-siyana masvomhu, charting, asika matafura, etc.

Chirongwa Gwaro iri workbook. Bhuku ine ane risingaperi uwandu machira wakasiyiwa user.

jira chirongwa nechimwe chinhu tafura, zvinosanganisira 256 mitsara uye 65.536 mbiru. Sero rimwe nerimwe riri patafura anonzi sero.

Excel Sero ine nomumwe kero pachake raiumbwa mutsara nhamba uye Latin tsamba mbiru (semuenzaniso, 1a, 2b, 5c).

Main zvinhu

Mashandiro "Sum" (Verengai mu Excel)

The summation kuti manhamba uye nhamba Excel anogona kuitwa nenzira nhatu.

1. Kushandisa mwero ndinoiitawo chiratidzo - the ndinoiitawo ( "+"). Kazhinji, kwakadaro nzira inoshandiswa kuwedzera vashoma digits kana nhamba, uye Kuwedzera zvokuimba kuti computation vamwe mabasa.
2. Kushandisa mazano basa "Amount" uye kusarudza nenharo. Inobvumira wedzera nhamba akaronga chimwe chete hondo (ari mbiru, mutsara), dzisiri contiguous masero, mumwe ndeiya yakaita hondo, siyana masero pedyo uye non-contiguous nhengo. Amount muna Excel vachishandisa basa iri rinogona dzaona chero.
3. Uchishandisa AutoSum chiratidzo «Σ», uye kusarudza zvakawanda mazwi. Rinoshandiswa kuverenga huwandu Muzviitiko zvakadaro, uyewo "Verengai".

The payakavakirwa "Round"

Mugumisiro upi kukarukureta, uyewo mari iri Excel, vangagara kuti rounding. Rounding muna Excel rinokosha kuti kuvhiringidzika pamwe kuratidza kukosha.
Kuti aite chiito "rounding mu Excel," unofanira kusarudza sero chine kukarukureta mugumisiro, anoteverwa nhamba ane chiratidzo yakaenzana ( '='), sarudza kuti "Round" mashandiro uye akaisa neuwandu matomu.

Achitaura chiratidzo vanoratidza kuti kuonekwa kuti sero anoratidza nhamba nematomhu iyo anoiswa mariri mushandisi maonero. Asi pano, rounding sezvo vakadaro zvikasaitika. Kana kuchinja muchitokisi saizi, nhamba nematomhu uyewo kunosiyana-siyana sezvo hombe, nokuwedzera muchitokisi, uye munguva duku, kana kudzikira, mirayiridzo.

Sezvaunogona kuona, kuti rounding muna Excel hakusi basa rakaoma kudaro.

"KWAKAKODZERA", "Len" - chinyorwa mabasa hunoita kuchinja mutsetse pakureba mazita kana kushandiswa, uye kuti nokubatanidza kana mahwanda mutsetse.

"BDSCHET", "DSUM" - mashandiro nokuda Databases. Bvumira kuti nhamba Database zvinyorwa, mubatanidzwa tsika. basa Izvi zvakafanana huwandu mu Excel se "Verengai".

"Masero" - Zvaiitwa Izvi zvinopa inodzidzisa mashoko pamusoro ehupfumi muchitokisi.

Math rutina - Excel tsanga. Masvomhu kuvashandisa - chinangwa chikuru purogiramu. In Excel, guru akagadzirwa kwemasvomhu mashandiro akadai Sine, cosine, riemukaari cosine, riemukaari Sine, tangent, cotangent. Kana izvi zvinhu kazhinji kuwana multi-ikakuruma ukoshi. Saka sarudza "Rounding mu Excel" munyaya ino inobatsira iyi.

"MMULT", "MDETERM", "but" nokuti mabasa ari Numeric arrays, matrices.

"UNIT", "zvokungoitawo" nokuda zvenguva uye yokupedzisira tsika.

Logarithms, Linear logarithms, logarithms.

Statistics. "BETAINV" - anoita huchadzokerazve Ivan Kuchin kushanda chinokosha basa Beta mukana arambe achirema. "WEIBULL" - Unodzokera kune Weibull kugovera.

MS Office Excel anewo mari basa, basa nezvakawanikwa arrays, zuva uye nguva mashandiro, vachiongorora basa uye zvivako.

Saka, chirongwa ichi chiri kushaika chishandiso vanhu pane ose vari sezvineiwo chokuita nemifananidzo uye nhamba.