Iprogram ye-Electronic Spreadsheet yintoni kwaye isetyenziselwa ntoni?
Inkcazo: Ekuqaleni, ispredishithi yayisayi, kwaye isenokuba, iphepha elisetyenziswa ukugcina nokubonisa idatha yezemali.
Inkqubo yespredishithi yekhompyutheni yinkqubo yekhompyutheni esebenzayo njenge-Excel, i-OpenOffice Calc, okanye i- Google AmaSpredishithi ahlalutya iphepha lespredishithi.
Njengoko kwiphepha lephepha, lolu hlobo lwesicelo lusetyenziselwa ukugcina, ukuhlela nokucwangcisa idatha , kodwa luneempawu ezizakhelwe kunye nezixhobo, ezinjengemisebenzi, amafomula, iitshathi kunye nezixhobo zokuhlaziya idatha ezenza kube lula ukusebenzisana kunye nokugcina imali eninzi yedatha.
Kwi-Excel kunye nezinye izicelo ezikhoyo, iifayile zepredishithi ngamnye zibhekiswa njengeencwadi zokusebenzela .
Ifayile yeFayile yeSpredishithi
Xa ukhangela ispredishithi kwiprinki - njengoko kubonwe kumfanekiso ongentla - ubona itafile emxholweni okanye igridi yemiqolo kunye neikholomu . Imigca egciniweyo ichongwa ngamanani (1,2,3) kunye neentsika zamagama kunye neeleta ze-alfabhethi (A, wena oyisisiseko esisiseko, leaC). Kwiikholam ezingaphezu kwe-26, iikholamu zichongwa ngamabini amabini okanye ngaphezulu njengeAA, AB, AC.
Ikhonkco le-intersection phakathi kwekholam kunye nomqolo ibhokisi elincinci elincinci elibizwa ngokuba yiyunithi yesiseko esiselwandle. Isisele kukugcina idatha kwi-spreadsheet. Isitya ngasinye sinokubamba iqela elilodwa okanye into yedatha.
Iqoqo lemiqolo kunye neentsika zeeseli zakha ifom yokusebenzela - ebhekisela kwikhasi elilodwa okanye kwiphepha kwincwadi yokusebenzela.
Ngenxa yokuba iphepha lokusebenzela liqukethe amawaka eeseli, nganye inikwe iselfowuni okanye idilesi yeseli ukuyichonga. Iselferensi yeseli ludibene nencwadi yekholomu kunye nenombolo yomqolo efana ne- A3, B6, AA345 .
Ngoko, ukuyibeka ndawonye, inkqubo yespredishithi , efana ne-Excel, isetyenziselwa ukwenza iifayile zeencwadi eziqukethe enye yamaphepha okanye ama- worksheet aqulethe iikholomu kunye nemigca yedatha yokugcina iiseli.
Iinkcukacha zeeDatha, iiFomula kunye neMisebenzi
Iindidi zedata esithintelayo zingabandakanya amanani kunye neeteksi.
Iifomula - enye yezinto eziphambili zesofthiwe yespredishithi - isetyenziselwa ukubala - ngokuqhelekileyo ibandakanya idatha equlethwe kwezinye iiseli. Iiprogram zeSpredishithi ziquka inani lamagama afakwe kwiimfomula ezibizwa ngokuba yimisebenzi engasetyenziselwa ukwenza imisebenzi eyahlukileyo neyinkimbinkimbi.
Ukugcina Iinkcukacha zeMali kwiSpredishithi
I-spreadsheet isoloko isetyenziselwa ukugcina idatha yezemali. Iifomula nemisebenzi enokusetyenziswa kwiinkcukacha zemali ziquka:
- Ukwenziwa kwemisebenzi eyisiseko yeemathematika ezifana neenkomfa zokuhlanganisa kunye nemigca yamanani.
- Ukufumana ixabiso njengenzuzo okanye ukulahleka.
- Ukubala izicwangciso zokubuyiselwa kwemali mboleko okanye iimali zokuthenga.
- Ukufumana umlinganiselo, ubuninzi, okanye ubuncinci kwixabiso elithile.
Ezinye izinto zeSpredishithi ye-elektroniki
Eminye imisebenzi evamile ukuba ispredishithi isetyenziselwa ukuquka:
- idrafing okanye idatha yeenkcukacha zokuncedisa abasebenzisi ekuchongeni imizila yedatha;
- ukuhlunga kunye nokucoca idatha ukuze ufumane ulwazi oluthe ngqo.
Nangona iipredishithi zisetyenziselwa kakhulu ukugcinwa kwedatha, azikwazi ukwenza okufanayo ukulungiswa okanye ukuchithwa kwedatha njengenkqubo epheleleyo yeenkcukacha zeenkcukacha.
Ulwazi olugcinwe kwifayile yespredishithi lungabandakanywa kwiinkcazo zekhompyutha, kumaphepha ewebhu, okanye ziprintwe kwifom yokunika ingxelo.
I-Original & # 34; I-App App & # 34;
Iipredishithi zezixhobo zokubulala zangasese zeekhomputer. Iiprogram zepredishithi zokuqala, ezifana neVisiCalc (ekhutshwe ngo-1979) kunye neLotus 1-2-3 (ekhutshwe ngo-1983), zazikhokelela kakhulu ekukhuleni kwintando yeekhompyutha ezifana ne-Apple II kunye ne-IBM PC njengezixhobo zoshishino.
Uhlobo lokuqala lwe-Microsoft Excel lwakhululwa ngo-1985 kwaye lwabaleka kuphela kwiikhomputha ze-Macintosh. Ngenxa yokuba yenzelwe i-Mac, yayiquka umboniso womsebenzisi odwebayo owafaka phakathi kwamamenyu kunye nephuzu kwaye ucofe ubuchule ngokusebenzisa mouse. Kwaye kwafika ngowe-1987 ukuba inkululeko yokuqala yeWindows (Excel 2.0) ikhishwe.