Imisebenzi ku Excel: zisetyenziselwa ntoni?

Kufuneka kuqatshelwe ukuba iprogram ye-Excel eyaziwa-bephilile ukusebenza omkhulu, nokuba yinxalenye encinane evame ukuhlala "emva ningi". Oku kuyinyani ngakumbi umsebenzi-ofisi mihla le, uninzi imisebenzi anokuthi ezenzekelayo. Kwindawo yomsebenzisi professional na iimpawu ethandwa kakhulu Excel, ngazo Unga yenza ifomula yakho. Noko ke, yintoni na yonke loo nto?

Inyaniso yokuba izinto ezisebenzayo kwesi sicelo zibizwa ngokuba imiyalelo itekisi elula ukuba zitolikwa yikhompyutha, evumela nkqu Ukubala kakhulu entsonkothileyo izibalo. Ukuze uqonde, ukunika umzekelo ocacileyo. Ngaba ucinga ukuba ubonise umsebenzi e-Excel ngolu hlobo: "= AVERAGE (A1: A5)"? Ukuba izakhi basisishunqulelo ekuqaleni, le nguqulelo Russian le yi "ixabiso avareji uluhlu iiseli A1 libe ngu- A5 ebandakanya wonke." Umqondiso ":" akukho elijongene iyantlukwano kunye noluhlu.

Ndimele ndithi ukuba ukungena ngesandla inombolo indawo akwenzi ngqiqo, ekubeni isabelo sabo mouse ngokwayo substitutes isimiso iqhosha ekhohlo ukuya ibhokisi labo igalelo ifomula. Ukuba nokwenzeka yokwenza izibalo ezinje ngo-Excel isixhobo esinamandla ukwenza imisebenzi enzima zezibalo ngokunxulumanisa iitafile zibe omnye kwinkqubo interactive.

Indlela ukungena kuyo?

Njengoko imisebenzi olungumgubo kufuneka uqale ngo "=" uphawu kumgca igalelo kulo. Oku kulandelwa segama elithi, emva koko kwizibiyeli zibekiwe (njengoko kule umzekelo ngasentla). Ngaphakathi has iimpikiswano ngumbonisi lomzobo we amaxabiso ezisetyenziswa izibalo. Ngenxa yoko, imisebenzi Excel zingasetyenziswa kuphela iiseli zomntu ngamnye, kodwa ixabiso enye, kwakunye uthotho yonke ezibhekisa cell. Ngenxa yoko, ibinzana elithi "= SUM (12; 24)" uya kukunika result "36", lo gama inkqubo efanayo "= SUM (A12: A24)" Ndikunika inani onamanani kuluhlu ekhankanyiweyo.

imisebenzi ekwiseli

Njengokuba sele sitshilo, esi sixhobo unamandla kangangokuba ivumela yokuxazulula ngisho inxaki entsonkothileyo kakhulu. Kuba lo Excel (ixabiso imisebenzi leyo yahluke kakhulu) lisebenzisa iinkqubo ezintsonkothileyo nezinye izinto. Ukuyenza ibonakale ncono, sinikela umzekelo bobuqili: "= SUM. (A5: A10; AVERAGE (B7: C10))" Qaphela ukuba kasixhenxe yokwakha inkxaso. Kakade ke, ungangenisa impikiswano nangaphezulu, kodwa kukholelwa ukuba binzana ziya kubakho.

Noko ke, iingcali Microsoft njalo sisebenzela ukuphucula iimveliso zabo, ngoko kukho ithuba lokuba le nkqubo iza ukuqonda kungekudala namabinzana ezintsonkothileyo.

"Nkosi"

Kuba abasebenzisi makhwelo inikezelwa "Function Wizard", nto leyo lula kakhulu noku kunyanisa. Uyakwazi ukusebenzisa oko ngeendlela ezimbini:

• Fumana tab "Faka" uze ukhethe apho umba "umsebenzi";
• uyakwazi ukunciphisa ixesha ukufumana kwi bar yesixhobo iqhosha "Function Faka".

Njengokuba sele sitshilo, ukusebenzisa umhleli spreadsheet kwi Microsoft kunokuba yinto abafundi, njengoko ikuvumela ukuba ukubala nemizekelo ngakumbi "ngokungxamisekileyo". Ngenxa yoko, le grafu kwimisebenzi ye-Excel iya kubonelela isisombululo lula kwaye ongenantandabuzo womzobo iingxaki uhlobo «y = f (x), icandelo [a, b]. Inyathelo h = 0.1 ». Oku kuya kwenza kube lula kakhulu inkqubo yokufunda.