Kuyini Uhlelo LweSpredishithi Ye-Electronic futhi Yini Eyasetshenziselwa?
Incazelo: Ekuqaleni, ispredishithi yayisenjalo, futhi isengaba, ishidi lephepha elisetshenziselwa ukugcina nokubonisa idatha yezimali.
Uhlelo lwe-spreadsheet lwe-electronic uhlelo lokusebenza lwekhompyutha olusebenzayo njenge-Excel, i-OpenOffice Calc, noma ama- Google AmaSpredishithi afanisa iphepheni lephepha.
Njengenguqulo yephepha, lolu hlobo lwesicelo lisetshenziselwa ukugcina, ukuhlelwa nokuphatha idatha , kodwa lunezici eziningi ezakhiwe namathuluzi, njengemisebenzi, amafomula, amashadi, namathuluzi wokuhlaziya idatha okwenza kube lula ukusebenza nokugcina idatha enkulu.
Ku-Excel nezinye izinhlelo zokusebenza zamanje, amafayela aspredishithi ngamunye abizwa njengezincwadi zokusebenza .
Ifayela leSpredishithi Inhlangano
Uma ubheka uhlelo lwesipredishithi esikrinini - njengoba kuboniswe esithombeni ngenhla - ubona ithebula elixubile noma igridi yemigqa namakholomu . Imigqa enezingqimba ikhonjwe ngezinombolo (1,2,3) namakholomu aqondile nezinhlamvu ze-alfabhethi (A, wena oyinhlangano eyisisekeloB, leaC). Amakholomu angaphezu kuka-26, amakholomu abonakala ngamagama amabili noma ngaphezulu afana ne-AA, AB, AC.
Iphuzu lesiphambano phakathi kwekholomu nomugqa ibhokisi elincane le-rectangular elibizwa ngokuthi iyunithi eyisisekelo yolwandle. Iseli ukugcina idatha kuspredishithi. Iseli ngayinye lingabamba inani elilodwa noma into yedatha.
Iqoqo lemigqa namakholomu amangqamuzana enza ishidi lokusebenzela - elibhekisela kukhasi elilodwa noma ishidi ebhokisini lokusebenzela.
Ngenxa yokuthi ishidi lokusebenzela liqukethe izinkulungwane zamaseli, ngamunye unikezwa ireferensi yeseli noma ikheli leseli ukulikhomba. Isithenjwa seligca liyinhlanganisela yombhalo wekholomu nenombolo yomugqa efana ne- A3, B6, AA345 .
Ngakho, ukuyibeka ndawonye, uhlelo lwespredishithi , njenge-Excel, lisetshenziselwa ukwakha amafayela ebhuku eliqukethe ama- worksheet eyodwa noma ngaphezulu aqukethe amakholomu nemigqa yedatha egcina amaseli.
Izinhlobo Zedata, Amafomula, Nemisebenzi
Izinhlobo zedatha ezingakwazi ukubamba zihlanganisa izinombolo kanye nombhalo.
Amafomu - enye yezici eziyinhloko zesofthiwe yespredishithi - isetshenziselwa izibalo - ngokuvamile ehilela idatha equkethwe kwamanye amaseli. Ama-spreadsheet izinhlelo zihlanganisa amanani amafomu akhethiwe abizwa ngokuthi imisebenzi engasetshenziswa ukwenza imisebenzi ehlukahlukene neyinkimbinkimbi.
Ukugcina imininingwane yezimali kwiSpredishithi
I-spreadsheet ivame ukusetshenziswa ukugcina idatha yezimali. Amafomu nemisebenzi engasetshenziselwa idatha yezimali ihlanganisa:
- Ukwenza imisebenzi eyisisekelo yezibalo ezifana nokuhlanganisa amakholomu nemigqa yezibalo.
- Ukuthola amanani njengenzuzo noma ukulahlekelwa.
- Ukubala izinhlelo zokukhokhwa kwemali yokuboleka imali noma imali yokubolekwa kwemali.
- Ukuthola isilinganiso, isilinganiso esiphezulu, noma ubuncane emkhakheni ocacisiwe wedatha.
Okunye ukusetshenziswa kweSpredishithi ye-Electronic
Okunye imisebenzi evamile ukuthi ispredishithi ingasetshenziselwa ukufaka:
- idatha yegraphing noma ye-charting ukusiza abasebenzisi ekukhoneni izitayela zedatha;
- ukuhlunga nokuhlunga idatha ukuthola ulwazi oluqondile.
Nakuba amaspredishithi asetshenziselwa kakhulu ukugcinwa kwedatha, ayinakho amandla afanayo wokuhlela noma ukuzama idatha njengamahlelo egciniwe egciniwe.
Ulwazi olulondolozwe efayeleni lesipredishithi lungabuye lufakwe kwizethulo zobuchwepheshe, amakhasi wewebhu, noma kuphrintiwe kwifomu lokubika.
I-Original & # 34; Killer App & # 34;
Ama-spreadsheet ayimisebenzi yokuqala yokubulala yamakhompyutha abo. Izinhlelo zokuqala zespredishithi, njenge-VisiCalc (ekhishwe ngo-1979) kanye noLotus 1-2-3 (eyakhishwa ngo-1983), ikakhulukazi yayiyibophezelo ekukhuleni kwamakhompiyutha afana ne-Apple II ne-IBM PC njengamathuluzi ebhizinisi.
Inguqulo yokuqala ye-Microsoft Excel yakhululwa ngo-1985 futhi yagijima kuphela kumakhompyutha e-Macintosh. Ngenxa yokuthi yenzelwe i-Mac, yayihlanganisa isikhombikubona somsebenzisi esibonisa ukufaka phakathi kwamamenyu okudonsa phansi kanye nephoyinti bese uchofoza amandla usebenzisa igundane. Kwaze kwafika ngo-1987 ukuthi i-Windows yokuqala version (Excel 2.0) ikhishwe.