I-Excel

Ematafuleni ngenani elikhulu lamakholomu, kunalokho kunzima ukuhamba idokhumenti. Phela, uma itafula livulekile ngaphesheya kwemingcele yendiza yeskrini, bese ubona amagama emigqa lapho idatha efakiwe khona, kuzodingeka uqhubekele njalo ikhasi ngakwesobunxele, bese ubuyela futhi.

Ukumisa umsebenzi kuwuphawu lokubaluleka komsebenzi wempikiswano ngayinye ehambelanayo, enikezwe isinyathelo esithile, ngaphakathi kwemingcele echazwe ngokucacile. Le nqubo iyithuluzi lokuxazulula imisebenzi ehlukahlukene. Ngesizo salo, ungakwazi ukubona izimpande ze-equation, thola ama-maxima ne-minima, uxazulule ezinye izinkinga.

Ukwahlukana ngenye yezinto ezine ezijwayelekile zokusebenza kwezibalo. Ngokuvamile kunezibalo eziyinkimbinkimbi ezingenza ngaphandle kwakhe. I-Excel inezinhlobo eziningi zemisebenzi yokusebenzisa lolu hlelo lokusebenza. Ake sithole ukuthi singakwenza kanjani ukuhlukaniswa ku-Excel.

Lapho ushicilela amatafula kanye neminye idatha kumqulu we-Excel, zivame ukubhekana nezimo lapho idatha ihamba ngaphezu kwemida yeshidi. Kuyinto engathandeki ikakhulukazi uma itafula lingavumelani nendawo. Ngempela, kulokhu, amagama omugqa azovela engxenyeni eyodwa yedokhumenti ephrintiwe, namakholomu ngamanye - ngakolunye uhlangothi. Kuyamanga nakakhulu uma kukhona isikhala esincane esisele ukubeka ngokuphelele ithebula ekhasini.

Lapho usebenza namatafula afaka inani elikhulu lemigqa noma amakholomu, umbuzo wokuhlela idatha uba ophuthumayo. Ku-Excel lokhu kungatholakala ngokusebenzisa ukuqoqwa kwezici ezihambelanayo. Leli thuluzi likuvumela ukuthi ungahle uhlele idatha kuphela, kodwa futhi ufihle okwesikhashana izakhi ezingadingekile, okukuvumela ukugxila kwezinye izingxenye zetafula.

Abasebenzisi abaningi be-Excel babhekene nombuzo wokufaka isikhathi sokungena esikhundleni samakhomitha etafuleni. Lokhu kuvame ukuthi ngenxa yokuthi emazweni akhuluma isiNgisi kuwumkhuba ukuhlukanisa izingxenyana zamadayimenti kusuka kunani eligcwele ichashazi, futhi ezweni lethu - i-comma. Okubi nakakhulu, izinombolo ezinephashazi azibonakali ngezilimi zesiRussia izinguqulo ze-Excel njengefomethi yenombolo.

Ngokuvamile, ukuhlolwa kusetshenziselwa ukuhlola ikhwalithi yolwazi. Zibuye zisetshenziselwe ukuhlolwa kwengqondo nezinye izinhlobo zokuhlolwa. Ku-PC, izicelo ezihlukahlukene ezikhethekile zivame ukusetshenziselwa ukubhala izivivinyo. Kodwa ngisho nesimiso esijwayelekile se-Microsoft Excel, esitholakala kumakhompyutha cishe cishe wonke abasebenzisi, singakwazi ukubhekana nomsebenzi.

Njengomthetho, ngenxa yobuningi babasebenzisi, ukwengeza amaseli uma usebenza ku-Excel akumele umsebenze obunzima. Kodwa, ngeshwa, akuwona wonke umuntu owazi zonke izindlela zokuzenza. Kodwa kwezinye izimo, ukusebenzisa indlela ethile kungasiza ukunciphisa isikhathi esichithwa enkambisweni.

Ukubhala umbhalo we-strikethrough kusetshenziselwa ukukhombisa ukungabi nandaba, ukwephulwa kwesenzo noma umcimbi. Ngezinye izikhathi leli thuba libonakala lidingekile ukusebenzisa uma usebenza ku-Excel. Kodwa, ngeshwa, azikho amathuluzi enembile okwenza lesi senzo kungaba kwikhibhodi noma engxenyeni ebonakalayo ye-interface yomsebenzi.

Omunye wemisebenzi edumile kakhulu engeyona eyisiqalo, esetshenziselwa izibalo, embonweni wokulinganisa okuhlukile, kuzibalo kanye nangokwakho okungenzeka ukuthi yi-Laplace. Ukuxazulula izinkinga nazo kudinga ukuqeqeshwa okujulile. Ake sithole ukuthi ungasebenzisa kanjani ama-Excel amathuluzi ukubala le nkhomba.

I-Microsoft Excel akuyona nje umhleli wespredishithi, kodwa futhi nesicelo esinamandla kakhulu sokubala okuhlukahlukene. Okokugcina, lesi sici sinezici ezakhelwe ngaphakathi. Ngosizo lweminye imisebenzi (opharetha), kungenzeka ukuba ucacise ngisho nezimo zokubala, okubizwa ngokuthi yizidingo ezivamile.

Lapho usebenza namatafula, zivame ukubhekana nezimo lapho, ngaphandle kwama totali jikelele, kudingeka ukuba unciphise abaphakathi. Isibonelo, etafuleni lokuthengiswa kwezimpahla zenyanga, lapho umugqa ngamunye ngamunye ubonisa inani lemali evela ekudayiseni uhlobo oluthile lomkhiqizo ngosuku, ungangeza amanani angaphansi kwansuku zonke ekudayiseni yonke imikhiqizo, futhi ekupheleni kwetafula ucacise inani lemali engenayo yenyanga ngenyanga yebhizinisi.

Ukwakhiwa kwesiphakamiso kungenye yezinto eziziwayo zezibalo. Ngokuvamile lisetshenziselwa izinjongo zesayensi kuphela, kepha futhi ngenxa yokusebenza okungokoqobo. Masifunde ukwenza le nqubo ngokusebenzisa i-Excel toolkit. Ukudala umdwebo I-parabola igrafu yomsebenzi we-quadratic wenhlobo elandelayo f (x) = ax ^ 2 + bx + c.

Emisebenzini yokuhlela nokuklama, indima ebalulekile ilinganiselwa. Ngaphandle kwalo, ngeke kwenzeke ukuqala noma iyiphi iphrojekthi enkulu. Ngokuvamile ngokusebenzisa izindleko zokulinganisa embonini yokwakha. Yiqiniso, akulula ukwenza isabelomali ngendlela efanele, okuwukuphela kochwepheshe kuphela. Kodwa baphoqeleka ukuba basebenzise kwi-software ehlukahlukene, evame ukukhokhwa, ukwenza lo msebenzi.

Kwezinye izimo, umsebenzisi uphethwe ngokungabala inani lamagugu kukholomu, kodwa ubala inombolo yakhe. Okusho ukuthi ukuyibeka kalula, kubalulekile ukuthila ukuthi mangaki amaseli ekholomu elinikeziwe agcwele imininingwane ethile yenombolo noma yombhalo. Ku-Excel, kunamathuluzi amaningi angaxazulula le nkinga.

Uma usebenza ku-Excel, ngokuvamile kuvame ukubhekana nesimo lapho ingxenye enkulu yamakhasi esetshenziselwa ukubalwa futhi ayithwali umthwalo wolwazi lomsebenzisi. Idatha enjalo ivele kuphela futhi ihlukanisa ukunakwa. Ngaphezu kwalokho, uma umsebenzisi ephutha ngephutha isakhiwo sabo, lokhu kungabangela ukwephulwa komjikelezo wokubala kulo mbhalo.

I-Microsoft Excel ingenza kube lula kakhulu ukuthi umsebenzisi asebenze ngamatafula nezinkulumo zamanani, azenze ngokuzenzakalelayo. Lokhu kungafinyelelwa ngokusebenzisa i-toolkit yalolu hlelo lokusebenza, nemisebenzi yayo ehlukahlukene. Ake sibheke izici eziwusizo kakhulu ze-Microsoft Excel.

Uma usebenza ku-Excel ngesethi eside kakhulu yeqoqo lezinamba eziningi, kunalokho kungathandeki ukukhuphukela esihlokweni isikhathi ngasinye ukuze ubone amanani wemingcele kumasethini. Kodwa, ku-Excel kunethuba lokulungisa umugqa ophezulu. Kulesi simo, kungakhathaliseki ukuthi udelela kangakanani uhla lwedatha phansi, umugqa ophezulu uzohlale uhlala esibukweni.

Izihloko nezinyawo ziyizinkambu ezisezingeni eliphezulu nangaphansi kwe-Excel sheet. Amanothi alotshiwe kanye neminye imininingwane ngokuqonda komsebenzisi. Ngesikhathi esifanayo, ukubhaliswa kuzoba khona, okungukuthi, uma uqopha ekhasini elilodwa, lizoboniswa kwamanye amakhasi omadokhumenti endaweni efanayo. Kodwa, ngezinye izikhathi abasebenzisi bahlangana nenkinga uma bengakwazi ukukhubaza noma ukususa ngokuphelele unhlokweni nonyawo.

Ukusebenza ngetafula elijwayelekile kuhilela ukudonsa amagugu kusuka kwamanye amathebula kuwo. Uma kukhona amatafula amaningi, ukudluliswa kwamandla kuzothatha isikhathi esiningi, futhi uma idatha ivuselelwa njalo, khona-ke lokhu kuzoba umsebenzi we-Sisyphean. Ngenhlanhla, kukhona umsebenzi we-CDF onika amandla okuzitholela ngokuzenzakalelayo idatha.