Imisebenzi Excel: lokho ziberegiselwa?

Kufanele kuqashelwe ukuthi uhlelo owaziwa Excel has ukusebenza okukhulu, ngisho ingxenye encane okuvame ahlale "ekusithekeni". Lokhu kuyiqiniso ikakhulukazi ngokuphathelene nsuku zonke emsebenzini ehhovisi, abaningi imisebenzi okungatholakala ezenzakalelayo. Esikhathini professional imvelo umsebenzisi izici ethandwa kakhulu Excel, ngawo ungakha ngisho ifomula yakho siqu. Nokho, kuyini imayelana nani?

Iqiniso lokuthi izici kulesi sicelo abizwa ngokuthi imiyalo umbhalo elula ukuthi zibhekwa yikhompyutha, ukuvumela ngisho izibalo eziyinkimbinkimbi kakhulu zezibalo. Ukuze sikusize uqonde ukuthi, nika sibonelo esigqamile. Ucabanga ukuthi ukhombise umsebenzi Excel kanje: "= ISILINGANISO (A1: A5)"? Uma wokufunda isifinyezo ekuqaleni, kule nguqulo Russian salokhu "ukubaluleka isilinganiso ibanga lamaseli A1 ukuze A5 kukonke." Isibonakaliso ":" akuyona esiqokiwe ukwahlukana futhi ububanzi.

Mangisho ukuthi ngesandla faka inombolo indawo akwenzi mqondo njengoba isabelomali igundane ngokwaso esikhundleni uhlelo ukhiye yesokunxele ibhokisi yabo ifomula input. I kungenzeka ukwenza izibalo ezinjengalezi Excel yithuluzi elinamandla lokufeza imisebenzi eziyinkimbinkimbi zezibalo ngokuxhumanisa amatafula zibe munye uhlelo interactive.

Indlela ukungena kuwo?

Njengoba imisebenzi ifomula kufanele kuqale ngokuthi "=" uphawu emgqeni input. Lokhu kulandelwa isifinyezo okuvela kuyo le nkulumo, okwathi ngemva kwalokho kubakaki asethwe (njengoba ku isibonelo ngenhla). Ngaphakathi has agumenti kuyinto ukubonisa sokuqhafaza amagugu lisetshenziswe izibalo. Ngenxa yalokho, imisebenzi Excel ingasetshenziswa hhayi kuphela amangqamuzana ngamanye, kodwa futhi ukuba inani elilodwa, kanye lonke uchungechunge iseli amareferensi. Ngakho, inkulumo ethi "= INANI (12; 24)" uyokunika yi "36", ngenkathi inqubo efana "= INANI (A12: A24)" kuyonikeza isamba izinombolo ukuthi uhla ecacisiwe.

imisebenzi isichazi

Njengoba sishilo kakade, leli thuluzi elinamandla kangaka ukuthi uvumela ukuxazulula ngisho kwesibalo eziyinkimbinkimbi kakhulu. Ngenxa yalesi Excel (ukubaluleka imisebenzi okungaba ehlukene kakhulu) lisebenzisa izinhlelo eziyinkimbinkimbi nezinye izinkulumo. Ukuze wenze kube sobala, sikunikeza isibonelo esiwusizo: "= INANI. (A5: A10; ISILINGANISO (B7: C10))" Qaphela ukuthi asekelwe kasikhombisa yokwakha isidleke. Yiqiniso, ungafaka i-agumenti nokuningi, kodwa kukholakala ukuthi inkulumo kuyobe kungasekho.

Nokho, ochwepheshe Microsoft njalo sisebenzela ukuthuthukisa imikhiqizo yabo, ngakho kukhona ithuba lokuthi uhlelo maduze baqonde namazwi eziyinkimbinkimbi.

"Master"

Ukuze abasebenzisi imfundamakhwela inikezwa "Umsebenzi Iseluleki", okuyinto kusiza kakhulu ukusungulwa yabo. Ungayisebenzisa ngezindlela ezimbili:

• Thola ithebhu "Faka" bese ukhetha khona into "umsebenzi";
• ungehlisa isikhathi ukuthola ku yamathuluzi inkinobho "Umsebenzi Faka".

Njengoba sishilo kakade, ukusebenzisa i-spreadsheet mhleli kusuka Microsoft nakho kungaba abafundi, njengoba ikuvumela ukuba abale nokuningi izibonelo "kuyaphuthuma". Ngakho, igrafu Excel imisebenzi sizonikeza elula futhi enembile isixazululo sokuqhafaza izinkinga yohlobo «y = f (x), esigabeni [a, b]. Isinyathelo h = 0,1 ». Lokhu kuzokwenza kakhulu lula inqubo yokufunda.