Ukusondeza ku Excel - kulula!

Kweli nqaku siza kukhangela kwenye izicelo ofisi MS Office Excel.

MS Office Excel - inkqubo esele ifakiwe Complex Microsoft Office. Isetyenziswa ngenxa yezizathu ezininzi ezahlukeneyo izibalo, yatshati, ukudala iitafile, njl

uxwebhu nkqubo yomsebenzi. Le ncwadi iqulathe i esingenakubalwa kweemakhishithi ebekwe yi ngumsebenzisi.

inkqubo nganye iphepha itafile, eliquka lemiqolo 256 nemihlathi 65.536. Wonke iseli itafile kuthiwa iseli.

Excel zeeseli idilesi yayo ngamnye eyenziwa inombolo umqolo kunye Latin iileta zomhlathi (umz, 1A, 2B, 5c).

iimpawu eziphambili

Umsebenzi "Sum" (isixa in Excel)

Le summation yamanani kunye namanani e-Excel kungenziwa ngeendlela ezintathu.

1. Ukusebenzisa uphawu lokwengeza umgangatho - plus ( "+"). Kwiimeko ezininzi, indlela enjalo isetyenziswa ukongeza iqela elincinane lemivo okanye amanani, kunye neefomula ukongeza ngenxa intelekelelo kweminye imisebenzi.
2. Usebenzisa umsebenzi "Imali" igalelo nokukhetha iingxoxo. Ivumela ukudibanisa amanani akhe uluhlu olunye (of umhlathi, umqolo), iiseli non-kunayo, omnye uluhlu liyajikeleza, uluhlu iiseli ezikufutshane kunye nezahlulo non-kunayo. Isixa e Excel usebenzisa lo msebenzi ibalwe na.
3. Ukusebenzisa ezenzekelayo isimboli «Σ», kwaye ukhetha uluhlu ngokoMthetho. Oku kusetyenziswa ukubala i-mali kwiimeko ezinjalo, kwakunye "sum".

Ifomula "ROUND"

Isiphumo nayiphi ukubala, kwakunye imali Excel, kusenokubakho angenamivo. Ukusondeza e Excel likaThixo ukuba mazingabhidaniswa ixabiso elibonisiweyo.
Ukwenza intshukumo "lingqukuva Excel," kufuneka ukhethe i iseli equlathe isiphumo ukubala, mayikhokele inombolo kunye uphawu lokulingana ( '='), khetha i "ROUNDUP" function kwaye ukuseta inombolo oyifunayo ziikhowudi.

Ngokuphathelele ukubonisa uphawu ukuba kuqatshelwe ukuba iseli kubonisa inani ziikhowudi leyo ibekwa kuyo ukubonakala yomsebenzisi. Kodwa kulo mzekelo, ukusongwa njengoko enjalo akwenzeki. Xa ukutshintsha ubungakanani yeseli, inani ziikhowudi kwakhona yahluka njenge elikhulu, ngokwandisa iseli, yaye ezincinane, xa liyehla, ulwalathiso.

Njengoko ubona, i lingqukuva Excel ayikho umsebenzi olunzima njengolu.

"OFANELEKILEYO", "LEN" - imisebenzi umbhalo ezivumela ukutshintsha irejista umgca ubude okanye ukusetyenziswa, kwaye ukudibanisa okanye umgca uphuphu.

"BDSCHET", "Isiseko" - function yolwazi. Vumela ukuba zibale inani iirekhodi database, isixa lwamaxabiso. Lo msebenzi kuyafana imali Excel like "SUM".

"Iiseli" - Lo msebenzi ubonelela umsebenzisi ulwazi malunga neempawu kwiseli.

Math Imisebenzi - Excel kernel. Ubalo usebenzisa them - njongo ephambili yale program. Ngo-Excel, i iseti enkulu zemathematika nemisebenzi efana sine, cosine, arc cosine, arc sine, kodwa azikweli phezulu, njengenani elinekona ezisibhozo. Xa ezi mpawu zidla wafumana ixabiso multi-bit. Ngoko ke ukhethe "Ukusondeza e-Excel" kweli nqaku kuluncedo kule meko.

"MMULT", "MDETERM", "ASI" kuba imisebenzi kwimiboniso amanani, matrices.

"UNIT", "WETHUTYANA 'amaxabiso aphakathi kunye lokugqibela.

Logarithm, see logarithm yomgama, see logarithm.

Statistics. "BETAINV" - yenza ukubuyela umsebenzi uguqulo lonikezelo lwe elipheleleyo umsebenzi beta lilonke mninzi. "ROOTN" - engasiyiyo-ekhatywayo nth.

Kwakhona MS Office Excel la engenamsebenzi zemali, umsebenzi iimbekiselo kunye kwimiboniso, umhla kunye nemisebenzi ixesha, izabelo ukuhlola kunye neepropati.

Ngenxa yoko, le nkqubo sisixhobo ebalulekileyo kubantu bazo zonke imisebenzi abo oxhulumene ngandlela kunye namanani kunye namanani.