I-Excel

Lapho usebenza eMicrosoft Excel, kungadingeka ukuvula amadokhumenti amaningana noma ifayela elifanayo kumawindows amaningi. Ezinguqulweni ezindala nasezinguqulweni eziqala kusuka ku-Excel 2013, lokhu akuyona inkinga. Vele uvule amafayela ngendlela ejwayelekile, futhi ngayinye yazo izoqala ewindini elisha.

Iphutha elijwayelekile noma, njengoba livame ukubizwa ngokuthi, iphutha le-arithmetic, lingenye yezinkomba ezibalo ezibalulekile. Usebenzisa le nkomba, unganquma i-heterogeneity yesampula. Kubalulekile futhi ekubikezeleni isibikezelo. Ake sibheke ukuthi yiziphi izindlela ongabala ngazo iphutha elijwayelekile usebenzisa amathuluzi e-Microsoft Excel.

Kwesinye isikhathi kunezimo lapho udinga ukuthinta itafula, okungukuthi, imigqa yokushintshana namakholomu. Vele, ungayibulala ngokuphelele yonke idatha njengoba udinga, kodwa kungathatha isikhathi esikhulu. Akubona bonke abasebenzisi be-Excel abakwaziyo ukuthi le processor yetafula inomsebenzi ozosiza ukusebenza kwale nqubo.

Kunezikhathi lapho ngemuva kokuba umsebenzisi eseqede ingxenye ebalulekile yetafula noma aze aqedela umsebenzi kuyo, uyakuqonda ukuthi kuzokwandisa ngokucacile itafula 90 noma ama-180 degrees. Vele, uma ithebula lenzelwa izidingo zakho, futhi hhayi ngokuhleleka, ngakho-ke akulindelekile ukuthi angaphinde alenze, kepha uzoqhubeka nokusebenza ngenguqulo ekhona.

Ukudala uhlu olwehliswayo akugcini nje ngokugcina isikhathi lapho ukhetha inketho enqubekweni yokugcwalisa amatafula, kodwa futhi nokuzivikela ekufaka ngephutha idatha engalungile. Leli ithuluzi elilula kakhulu futhi elisebenzayo. Ake sibheke ukuthi singayisebenzisa kanjani ku-Excel, nokuthi singayisebenzisa kanjani, futhi sithole eminye imiqondo yokubhekana nayo.

Ukubala umehluko kungenye yezenzo ezaziwa kakhulu ngezibalo. Kepha lokhu kubalwa akusetshenziswanga isayensi kuphela. Sihlala sikwenza, ngaphandle kokucabanga, empilweni yansuku zonke. Isibonelo, ukuze kubalwe ushintsho kusuka ekuthengeni esitolo, ukubalwa kokuthola umehluko phakathi kwenani umthengi alinikeze umthengisi nenani lezimpahla nalo liyasetshenziswa.

Elinye lamathuluzi enza lula umsebenzi ngamafomula futhi likuvumela ukuthi wenze umsebenzi usebenze kahle ngama-arrows wedatha ukuqamba la ma arrows. Ngakho-ke, uma ufuna ukubheka uhla lwedatha enkudlwana, ngeke udinge ukuthi ubhale isixhumanisi esiyinkimbinkimbi, kepha kunalokho khombisa igama elilula ukuthi wena ngokwakho uqokile uhlu oluthile.

Imvamisa, kuba khona isimo lapho, lapho siphrinta idokhumenti, ikhasi lishiya indawo engafanele impela. Isibonelo, ingxenye enkulu yetafula ingavela ekhasini elilodwa, kanye nomugqa wokugcina kwesesibili. Kulokhu, udaba lokuhamba noma lokususa igebe lolu lufanelekile. Ake sibheke ukuthi kungenziwa kanjani lapho sisebenza namadokhumenti ku-Excel spreadsheet processor.

Enye yezinkinga ezejwayelekile zezibalo ukuhlela ukuncika. Kubonisa ukuxhomekeka komsebenzi ekushintsheni impikiswano. Ephepheni, le nqubo akulula ngaso sonke isikhathi. Kepha amathuluzi e-Excel, uma ekwazi kahle ukusebenza, akuvumela ukuba wenze lo msebenzi ngokunembile futhi ngokushesha okukhulu.

Umdwebo wenethiwekhi yithebula elenzelwe ukudweba uhlelo lwephrojekthi nokubheka ukuqaliswa kwayo. Ngokwakhiwa kwalo okuhle, kunezicelo ezikhethekile, isibonelo, i-MS Project. Kepha kumabhizinisi amancane futhi ikakhulukazi izidingo zomnotho zomuntu, akunangqondo ukuthenga isoftware ekhethekile futhi uchithe isikhathi esiningi efunda ubunzima bokusebenza kuyo.

Kwabasebenzisi beMicrosoft Excel, akuyona imfihlo ukuthi idatha ekule processor yesipredishithi ifakwa kumaseli ahlukile. Ukuze umsebenzisi afinyelele le datha, isakhi ngasinye seshidi sinikezwa ikheli. Ake sibheke ukuthi yiziphi izimiso izinto ezise-Excel zibaliwe nokuthi ngabe lokhu kubalwa kungashintshwa.

Ukunquma ubungako bokuncika phakathi kwezinkomba eziningana, kusetshenziswa ama-coefficients amaningi wokuxhumanisa. Ngemuva kwalokho kufingqwa kutafula elihlukile, elinobizo lwe-matrix yokuhlobanisa. Amagama imigqa namakholomu we-matrix angamagama wemingcele okuncike kuyo ukuncika komunye nomunye.

Ngokuvamile kuyadingeka ukuthi lapho uphrinta itafula noma omunye umbhalo, isihloko kufanele siphindwe ekhasini ngalinye. Ngokwethi, ngokweqiniso, ungachaza imingcele yekhasi ngokusebenzisa indawo yokubuka kuqala bese ufaka igama phezulu komunye nomunye wabo. Kepha le ndlela izothatha isikhathi esiningi futhi iholele ekhepheni ekuthembekeni kwetafula.

Okunye kokusebenza okwenziwa njalo lapho kusetshenzwa no-matrices ngukuphindaphindeka komunye wabo ngomunye. I-Excel inqubo eprinta ispredishithi enamandla, eyenzelwe, kufaka phakathi ukusebenza matrices. Ngakho-ke, unamathuluzi azivumelayo ukuba zanda phakathi kwazo.

I-Excel iyithebula elinamandla, lapho usebenza lapho izinto ziguqulwa, amakheli ayaguqulwa, njll. Kepha kwezinye izimo, udinga ukulungisa into ethile noma, njengoba besho ngenye indlela, bayiqede ukuze ingashintshi indawo yayo. Ake sibheke ukuthi yikuphi ukukhetha okuvumela lokhu.

Lapho usebenza kudokhumenti e-Excel, kwesinye isikhathi udinga ukusetha ideshi ende noma elifushane. Kungafunwa, kokubili njengophawu lwezimpawu embhalweni, nangesimo sedeshi. Kodwa inkinga ukuthi asikho isibonakaliso esinjalo kukhibhodi. Uma uqhafaza uphawu kukhibhodi, olufana kakhulu nedeshi, umphumela sithola udeshi omfishane noma "minus".

Kubasebenzisi abajwayelekile be-Excel, akuyona imfihlo ukuthi kulolu hlelo ungenza ukubala okuhlukahlukene, ubunjiniyela kanye nezezimali. Leli thuba liyabonakala ngokusebenzisa amafomula ahlukahlukene kanye nemisebenzi. Kepha, uma i-Excel isetshenziselwa njalo ukubalwa okunjalo, khona-ke impikiswano yokuhlela amathuluzi adingekayo kuleli lungelo eshidini iba efanelekile, okuzonyusa isivinini sokubala kanye nezinga lokusebenziseka kalula komsebenzisi.

Lapho usebenza namatafula, kwesinye isikhathi kufanele ushintshe ukwakheka kwawo. Umehluko owodwa wale nqubo i-concatenation yentambo. Ngasikhathi sinye, izinto ezihlanganisiwe ziphenduka umugqa owodwa. Ngaphezu kwalokho, kunethuba lokuhlela izinto ezisezingeni eliphansi eliseduze. Ake sibheke ukuthi yiziphi izindlela ongaqhuba ngazo lezi zinhlobo zokuhlanganisa eMicrosoft Excel.

Isidingo sokuguqula itafula ngesandiso se-HTML kufomethi ye-Excel kungenzeka emacaleni ahlukahlukene. Mhlawumbe udinga ukuguqula idatha yekhasi lewebhu kusuka kwi-Intanethi noma amafayela we-HTML asetshenziswa endaweni yakini ngezinhloso ezithile. Ngokuvamile baguqula ekuhambeni.

I-ODS yifomethi yespredishithi eyaziwayo. Singasho ukuthi lolu uhlobo lomqhudelwano kwizimo zama-Excel xls nama-xlsx. Ngaphezu kwalokho, i-ODS, ngokungafani nabalingani abangaphezulu, yifomethi evulekile, okungukuthi, ingasetshenziswa mahhala futhi ngaphandle kwemikhawulo. Kodwa-ke, kwenzeka futhi ukuthi idokhumenti enwetshiwe i-ODS idinga ukuvulwa ku-Excel.