Ukuqoqa kuya Excel - kulula!

Kulesi sihloko sizohlola esinye zokusebenza ehhovisi MS Office Excel.

I-MS Office Excel - uhlelo likhona-Microsoft Office Complex. Isetshenziselwa ezihlukahlukene izibalo, charting, ukudala amatafula, njll

Uhlelo dokhumenti ibhuku. Incwadi siqukethe esingenamkhawulo ukuthi amashidi esabekwa umsebenzisi.

Uhlelo ngalunye Ishidi itafula, ehlanganisa imigqa 256 futhi 65.536 amakholomu. Njalo iseli itafula libizwa ngokuthi ingqamuzana.

Excel iseli linekheli lalo umuntu ehlanganisa inombolo ilandelana Latin izinhlamvu ikholomu (isib 1A, 2B, 5c).

izici main

Umsebenzi "Sum" (isamba Excel)

I summation lezinombolo nezinombolo Excel kungenziwa ngezindlela ezintathu.

1. Ukusebenzisa ejwayelekile uphawu lokuhlanganisa - plus ( "+"). Ezimweni eziningi, indlela enjalo isetshenziswa ukwengeza inamba encane kwamadijithi noma izinombolo, ngaphezu amafomula for ikhompyutha nezinye imisebenzi.
2. Ukusebenzisa okufakwayo umsebenzi "Inani" bese ukhetha agumenti. Ivumela wengeza izinombolo kuhlelwe ngendlela afanayo olulodwa (kwekholomu, irowu), amaseli non-ohlanganisa, omunye afanayo ntathu, uhla amaseli aseduze nezingxenye ze-non-ohlanganisa. Inani Excel usebenzisa lo msebenzi ingabalwa iyiphi.
3. Ukusebenzisa Kuyazihlanganisela uphawu «Σ», bese ukhetha uhla imigomo. Isetshenziselwa ukubala inani ezimweni ezinjalo, kanye "sum".

Ifomula "ROUND"

Umphumela wanoma isiphi ukubala, kanye lemali Excel, ungaba ngaphansi kweziqondiso ukuba ukuqoqa. Ukuqoqa Excel ezibaluleke hhayi badideka anenani isibonisi.
Ukwenza isenzo "ukuqoqa Excel," kumelwe ukhethe yeseli equkethe umphumela ukubala, sibandulele inombolo ngesibonakaliso alinganayo ( '='), khetha "ROUND" umsebenzi bese usetha inombolo oyifunayo izingcezu.

Ngokuphathelene ukubonisa uphawu Kumelwe kuphawulwe ukuthi iseli ubonisa inani izingcezu okuyinto ibekwe kuwo ukubonakala umsebenzisi. Kodwa kulokhu, ukuqoqa njengoba enjalo kungenzeki. Lapho kushintshwa usayizi cell, inani izingcezu iyahlukahluka njengoba esikhulu, ngokwandisa cell, futhi ezincane, lapho lehla, isiqondiso.

Njengoba ubona, the ukubopha Excel akuyona umsebenzi onzima kangaka.

"OKUFANELE", "LEN" - imisebenzi umbhalo okukuvumela ukushintsha umugqa obuphelele irejista noma ukusetshenziswa, futhi sihlanganise noma umugqa okuhlukene.

"BDSCHET", "DSUM" - umsebenzi yolwazi. Vumela ukubala inani amarekhodi egciniwe, yesamba samanani. Lokhu kusebenza ngendlela efanayo nenani Excel efana "SUM".

"Amaseli" - Le umsebenzi inikeza umsebenzisi ulwazi mayelana izakhiwo iseli.

Izibalo Imisebenzi - Excel ikhenela. Izibalo ukuzisebenzisa - injongo eyinhloko uhlelo. Ku-Excel, iqoqo elikhulu imisebenzi weembalo afana sine, cosine, arc cosine, arc sine, tangent, cotangent. Lapho lezi zici ngokuvamile etholwe multi-bit value. Ngakho khetha "Ukuqoqa Excel" kulesi sihloko ewusizo kule ndaba.

"MMULT", "MDETERM", "ASI" ngoba imisebenzi afanayo ezinombolo, matrices.

"UNIT", "zesikhashana" ngoba amanani Intermediate futhi esingujuqu.

Logarithms, logarithms yomugqa, logarithms.

Izibalo. "BETAINV" - yenza ukubuya umsebenzi inverse we ebalulekile umsebenzi beta okungenzeka kwabantu. "WEIBULL" - Ibuyisa ukusatshalaliswa WEIBULL.

I-MS Office Excel Ubuye umsebenzi wezimali, umsebenzi izithenjwa afanayo, usuku kanye nesikhathi imisebenzi, izabelo sokuhlola izakhiwo.

Ngakho, lolu hlelo iyithuluzi elibalulekile abantu ngabe ngumuphi umsebenti ngubani ngandlela-thile exhunywe ne izibalo kanye nezinombolo.