Chii Chinonzi Electronic Spreadsheet Program uye Chii Chinoshandiswa?
Tsanangudzo: Pakutanga, pepanheti yaive, uye inogona kunge iri, pepa raishandiswa kuchengeta uye kuratidza dhepfumi.
Purogiramu yepurogiramu yepurogiramu ipurogiramu yekombiyuta inoshandiswa yakafanana neExcel, OpenOffice Calc, kana Google Sheets iyo inofanidza pepa pepaji.
Sezvakanyorwa nepepanhau version, rudzi urwu rwekushandiswa runoshandiswa pakuchengetedza, kurongedza nekugadzirisa dheta , asi rinewo nhamba yezvakavakwa muzvinhu uye zvishandiso, zvakadai semabasa , mazano, marati, uye zvidzidzo zvekutsvaga deta zvinoita kuti zvive nyore kushanda pamwe nekuchengetedza zvakawanda zve data.
MuEccel uye mamwe maitiro ekugadzirisa, mahwendefa ega ega anowanikwa semabhuku ebasa .
Spreadsheet File Organization
Paunotarisa purogiramu yepaspiritsi pahwindo - sezvinowanikwa mumufananidzo uri pamusoro - unoona tafura rekwangwani kana girasi yemitsara nemirasi . Mitsara yakakosha inozivikanwa nenhamba (1,2,3) uye mazamu akajeka ane tsamba dzealfabheti (A, iwe basic unitB, ceaC). Pamusana pemashure makumi maviri nemakumi maviri, mapuranga anoonekwa nemabhii maviri kana akawanda akadai seAA, AB, AC.
Pakati pechandori nemutsara ibhokisi duku rekwangwani rinonzi sea basic unit . Sero nderekuchengetedza data mune pepiritsi. Sero rimwe nerimwe rinogona kubata chinhu chimwechete kana chinhu che data.
Mutsara wemitsara nemirasi yemasero inoumba pepa rekushanda - iro rinoreva peji rimwe chete kana pepa mubhuku rebhuku.
Sezvo pepa rekushandisa rine zviuru zvemasero, rimwe nerimwe rinopiwa sero retera kana kero kero kuti rione. Sero rinoshandiswa nderokubatanidzwa kwetsamba yemutsara uye nhamba yemutsara yakadai seA3, B6, AA345 .
Saka, kuti uzviise pamwe chete, chirongwa chepaspiritsi , chakadai seExcel, chinoshandiswa kugadzira mafaira ebhuku rebhuku rine imwe kana mamwe mahwendefa ane zvinyorwa nemitsetse yedata kuchengetedza masero.
Data Dhiyabhorosi, Formula, uye Mabasa
Mhando yedata iyo sero inogona kubata inosanganisira nhamba uye zvinyorwa.
Zvinyorwa - chimwe chezvinhu zvinokosha zvepurogiramu yepaspiritsi - inoshandiswa pakuverenga - kazhinji inosanganisira data iri mune mamwe masero. Mapurogiramu epadhetiet anosanganisira mazita akavakwa mune mazita anonzi mabasa anogona kushandiswa kuita mabasa akasiyana siyana uye akaoma.
Kuchengetedza Financial Data muSpreadsheet
A spreadsheet inowanzoshandiswa kuchengetedza data yemari. Zvinyorwa uye mabasa anogona kushandiswa pamatare emari anosanganisira:
- Kuita maitiro ezvidzidzo zvemasvomhu zvakadai sekuenzanisa zvinyorwa uye mitsara yemataiti.
- Kuwana maitiro akadai senzuzo kana kurasikirwa.
- Kuverenga zvirongwa zvekubhadhara zvezvikwereti kana zvekubhadhara mari.
- Kuwana mavhareji, mahombekombe, kana kuti zvishoma zvigaro mune imwe nzvimbo yakawanda yedata.
Zvimwe Zvishandiso zveSpreadsheet yeMepuraneti
Zvimwe zviitiko zvinowanikwa kuti spreadsheet inogona kushandiswa iyo inosanganisira:
- graphing kana charing data kuti ibatsire vashandi pakutsvaga mamiriro ekufambisa;
- kusarudza uye kuchenesa deta kuti uwane ruzivo rwakananga.
Kunyange zvazvo mahwendefa anoshandiswa zvakanyanya pakuchengetedza dheta, haavi nemafungiro akafanana ekugadzirisa kana kutsvaga deta sezvinoita mapurogiramu ese e database.
Mashoko akachengetwa mufaira chepadheseti anogonawo kuiswa mumharidzo yezvemagetsi, mapeji ewebhu, kana kudhindwa muforomo yehupoti.
Murayi Wekutanga & # 34; Killer App & # 34;
Mapaparishiti aiva ekutanga kuuraya mapurogiramu emakombiyuta ega. Mapurogiramu epakuparadzira mapepa okutanga, akadai seVisiCalc (akabudiswa muna 1979) uye Lotus 1-2-3 (yakabudiswa muna 1983), ainyanya kukonzera kukura mukuzivikanwa kwemakombiyuta seApple II uye IBM PC semabhizimisi emabhizimisi.
Shanduro yekutanga yeMicrosoft Excel yakabudiswa muna 1985 uye yakamhanya chete pamakombiyuta eMacintosh. Nemhaka yokuti yakagadzirirwa Mac, yaisanganisira mufananidzo wemashandisirwo akabatanidzwa akabatanidza zvinyorwa pasi uye nzvimbo uye chengetedza simba kushandisa mouse. Yakanga isiri kusvika muna 1987 kuti yekutanga Windows version (Excel 2.0) yakasunungurwa.