Imisebenzi "Excel": kanjani ukwakha

Namuhla sibheka indlela yokwakha igrafu umsebenzi, "Excel" isisiza kanjani kuleli. Futhi ubambe kafushane ezinye eliwusizo umhleli spreadsheet.

isicelo

Ngakho, siye umbuzo indlela yokwakha umsebenzi in the "Excel". Lokhu umhleli ithebula yilona thuluzi ephelele ukuze umsebenzi ehhovisi futhi ekhaya. Excel uphelele ukuze uthole imali yakho noma wenze iziphetho ezinkulu zezimali emsebenzini enkampanini enkulu. Itafula Umhleli inezici eziningi, kodwa namuhla sizogxila omunye okufunwa kakhulu.

itulo

Asikwazi ukwakha igrafu umsebenzi ku "Eksele" ezivamile noma eziphathelene nokusebenza eziyinkimbinkimbi zezibalo. Ukuze wenze lokhu, senza ngezinyathelo ezimbalwa nje. Vula ishidi le-Excel ihlanzekile noma ukuqalisa iphrojekthi entsha. Dala amakholomu amabili. Ngaphezu kwalokho, umyalo wokuqala ukubhala kuqala ingxabano. Ngqo ukusebenza kule "Eksele" benza kukholamu yesibili. Thina dlulelani esinyathelweni esilandelayo. Uveza kukholamu yokuqala X, adingekayo ukubala futhi ugobe. Sinquma isikhawu lapho umsebenzi izokwakhiwa.

ukubala

Iya ohlwini olulandelayo. Kumelwe ubhale ifomula "Excel" umsebenzi kuwo. Luhlelo izokwakhiwa ku isisekelo salo. Zonke amafomula Lokokulawula-spreadsheet iqala nge uphawu "=". izici Isicelo kakhulu lula inqubo yokudala schedule. Ngokwesibonelo, akudingeki ukuba sigxilise ifomula akhethiwe yonke imigqa. Excel Onjiniyela wakucabangela ukuthi kwakungeke kube yinto elula kakhulu. Ngakho, nje udonse ifomula, futhi iyokwakhiwa ngamunye amaseli. Udinga nje uchofoze emkhakheni ofanele.

Imininingwane esisuka

Siyaqhubeka ikambiso yokwakhiwa kwemisebenzi "Eksele". Ngemva kokwenza izinyathelo ezingenhla ekhoneni engezansi kwesokudla cell kuyoba isikwele encane. Thina ukuqondisa isikhombisi kuso ukuze kushintshile pointer. Manje thina cindezela inkinobho yegundane kwesokudla bese udonse ifomula ngoba inani elidingekayo amaseli. Ngenxa yalokho, lezi zenzo kuzosiza ukwakha igrafu "Excel" umsebenzi.

imfundo

Thina uqhubekele ukwakhiwa. Esikhathini "Imenyu" ithebhu, khetha "Faka". Esikhathini uhlu lokukhethwa kukho ezihlongozwayo ekusetshenzisweni nto "Umdwebo". Khetha noma iyiphi etholakalayo iphuzu amashadi. Chofoza "Next". Sidinga nje ishadi iphuzu. Manje sizokutshela ukuthi kungani. Okunye amashadi ngeke bavunyelwe ukwakha endaweni eyodwa ngendlela umsebenzi futhi impikiswano. Buka ukubaluleka isebenzisa ireferensi iqembu oyifunayo amaseli. Ngenxa yalokho izinyathelo ezingenhla kuyovela ingxoxo entsha, kuwo ucindezela inkinobho "inombolo."

Thina dlulelani esinyathelweni esilandelayo. Yakha inombolo usebenzisa "Engeza" inkinobho. Kuzoba ewindini elilandelayo, lapho predetermined indlela oyifunayo amagugu ukucinga ukwakha schedule edingekayo. Ukuze ukhethe seli engakwesokudla, chofoza isithombe of Excel. Cacisa amaseli edingekayo ethebuleni. Ngokushesha eshidini umsebenzi edingekayo uboniswa, lenani "Eksele" kakade, futhi kungaba kuphela chofoza "Qeda." Luhlelo yakhiwe. Uma wayefisa, kungaba banoma yimuphi usayizi kanye yinkimbinkimbi nelula.

nezinye izici

On umbuzo ukwakhiwa kwemisebenzi nalokho okulindelwe for them we hambisa esiphethweni, kodwa itafula umhleli enezinto eziningi nezinye izici, nakho kufanele bazazi lula umsebenzi naye. Ukukhuluma amakhono zezibalo Excel, awukwazi ngiye phambili umsebenzi nokukhipha. Ukuze abale umehluko phakathi izinombolo ezimbili, chofoza kuseli lapho umphumela uboniswa. Thina ufake uphawu kulingana. Uma okuqukethwe iqala ngale notation, Excel ecabanga ukuthi iseli ibekwe operation ezithile zezibalo noma ifomula. Ngemva wathi setshwayo, ngaphandle kokusebenzisa isikhala, kunciphisa inani ngomshini, sasibeka lokususa futhi ukwethula sisuswe. Khona-ke u-Enter. Iseli kuyoba umehluko phakathi izinombolo ezimbili.

Cabangela i samuntu lapho idatha yoqobo zingafundwa evela kwamanye amangqamuzana etafuleni. Ngokwesibonelo, ku-B5 iseli liye kuboniswe inombolo ukuncipha ingxenye 55, etholakala cell D1, cindezela ku-B5. Thina ufake uphawu kulingana. Bese ucindezela iseli D1. Setshwayo kulandele isixhumanisi koxhumana naye yezinyoni ekhethiwe. Ungase futhi ushayele ikheli oyifunayo ngesandla, ngaphandle kokusebenzisa i-mouse. Ngemva kwalokho, singena uphawu nokukhipha. Cacisa inombolo 55. Cindezela u-Enter. Okulandelayo Excel ngeke ukubala ngokuzenzekelayo futhi sibonisa Chile.

Ukuze sidonsa ukubaluleka kuseli eyodwa izinkomba komunye, usebenzisa i-algorithm efanayo. Thina ufake uphawu kulingana. Ukuthola ikheli noma baphoqelele isikhombisi cell lapho ukubaluleka minuend. Ngemva kwalokho, sasibeka lokususa. Wokufaka noma ukuqhafaza igundane esitokisini lapho ukubaluleka kwengosi kuba subtrahend. Sebenzisa u-Enter. Isenzo ephelele.

Sekuvele waveza ukuthi ukwakhiwa umsebenzi Excel ifomula esetshenziswa, ngakho kufanele bajwayelane izici yokudalwa kwayo. Ukuze wenze lokhu, kukhona ezinye imithetho ehambisana ngqo nensiza. Phakathi kokunye, amafomula avumele ukuba ukushintsha inqubo kubalwa amagugu okokufaka ku amaseli. Ake uqale kusukela ekuqaleni. Run-Excel. yibhekisise esibonakalayo ajwayelekile. String amafomula esiqokiwe izinhlamvu fx. It wayengadlali, futhi sidinga usizo.

Ukufaka ifomula elula, unikezwa kumaseli value oyifunayo ngokubhalela kuye isibonakaliso kokulingana. Ngemva ukuphokophela Faka, sibona umphumela. Ungasebenzisa izindlela eziningana ukungena idatha. Chofoza elingenalutho kuseli A1. Faka kuwo inani elithile ngu esandulele ngayo uphawu "zilingana 'nezinsuku. Yisa engumakhelwane kuseli B1. Eliqondisa esinye isici enkulumweni ifomula. Siyaqhubeka izinyathelo ezifanayo kuze kube yilapho yonke nemingcele ezinikezwe e inkinga ngeke angena etafuleni. Isibonakaliso "elilingana" wafaka kakhulu cell ezingenalutho.

Thina dlulelani esinyathelweni esilandelayo. Khetha A1 cell. Faka kuwo uphawu arithmetical (division, ukubuyabuyelela, kwalokho). Ukukhetha kwesinye isitokisi, isib, B2. Cindezela u-Enter. Dala Inkulumo yokuqala kabili ngokucindezela esitokisini futhi ngokucindezela Ctrl futhi "aphostrofi".

Ngakho esiphethweni kanjani uhlela "Excel" sici, kanye bafunda indlela ukusebenza amafomula algorithm ukuthi kungadingeka salokhu.