Kodi Chipangizo Chamakono Chimachita Chiyani ndipo N'chiyani Chogwiritsidwa Ntchito?
Tanthauzo: Poyambirira, spreadsheet inali, ndipo ikhoza kukhala, pepala limene amagwiritsidwa ntchito kusunga ndi kusonyeza deta zachuma.
Pulogalamu yamakaseti ya spreadsheet ndi makompyuta othandizira monga Excel, OpenOffice Calc, kapena Google Mapepala omwe amatsanzira pepala lamasamba.
Monga momwe zilili ndi mapepala, mtundu uwu wa ntchito umagwiritsidwa ntchito kusungirako, kukonzekera ndi kusunga deta , koma imakhalanso ndi zida zambiri zowonjezera ndi zipangizo, monga ntchito , ma fomu, masatidwe, ndi zipangizo zowunika deta zomwe zimapangitsa kuti zikhale zosavuta kugwira ntchito ndi kusunga zambiri za deta.
Mu Excel ndi zochitika zina zamakono, mafayilo apasipoti aliwonse amatchulidwa ngati mabuku ogwira ntchito .
Fayilo la Fayilo Fomu
Mukayang'ana pulogalamu yapiritsiti pazenera - monga momwe mukuwonera pa chithunzi pamwambapa - mukuwona tebulo laling'ono kapena gridi ya mizere ndi mizere . Mizere yopingasa imadziwika ndi manambala (1,2,3) ndi mazenera ofanana ndi zilembo za zilembo (A, you basic unitB, ceaC). Kwa zigawo zopitirira 26, zipilala zimadziwika ndi makalata awiri kapena ambiri monga AA, AB, AC.
Pakati pa ndime ndi mzere ndi bokosi laling'ono laling'ono lotchedwa sea basic unit . Selo ndi kusungiramo deta mu spreadsheet. Selo lirilonse lingakhoze kugwiritsira ntchito mtengo umodzi kapena chinthu cha deta.
Mndandanda wa mizere ndi timapepala ta maselo timapanga pepala - lomwe limatanthauza tsamba limodzi kapena pepala m'buku.
Chifukwa pepala lamasewera liri ndi maselo ambiri, aliyense amapatsidwa selo kapena selo laadiresi kuti adziwe. Chiwerengero cha selo ndi kuphatikiza kalata ya mzere ndi mzere wowerengeka monga A3, B6, AA345 .
Choncho, kuti muyike palimodzi, pulogalamu ya spreadsheet , monga Excel, imagwiritsidwa ntchito popanga mafayilo a mabuku omwe ali ndi pepala limodzi kapena ambiri okhala ndi zipilala ndi mizere ya deta yosunga maselo.
Ma Deta, Mafomu, ndi Ntchito
Mndandanda wa deta yomwe selo ikhoza kugwira ndi monga manambala ndi malemba.
Mafomu - chimodzi mwa zinthu zofunika pa pulogalamu yapiritsiti - amagwiritsidwa ntchito pazowerengera - kawirikawiri zimakhudzana ndi deta yomwe ili m'maselo ena. Mapulogalamu a mapepala amaphatikizapo maumboni angapo omangidwa omwe amatchedwa ntchito zomwe zingagwiritsidwe ntchito kugwira ntchito zosiyanasiyana zomwe zimakhala zovuta komanso zovuta.
Kusunga Financial Data mu Spreadsheet
Kawirikawiri tsamba lamasamba limagwiritsidwa ntchito kusungirako deta zachuma. Mafomu ndi ntchito zomwe zingagwiritsidwe ntchito pa deta ya ndalama zikuphatikizapo:
- Kupanga machitidwe oyambirira a masamu monga kuphatikiza ndemanga ndi mizere ya ziwerengero.
- Kupeza mfundo monga phindu kapena kutaya.
- Kuwerengera mapulani obwezera ngongole kapena ngongole.
- Kupeza chiwerengero, chiwerengero, kapena chiwerengero chazing'ono pa deta yambiri.
Zina Zogwiritsa Ntchito Zopangira Zamakono
Zochitika zina zomwe zimachitika kuti spreadsheet ikhoza kugwiritsidwa ntchito monga:
- zojambulajambula kapena deta yolongosola othandizira kuti adziwe machitidwe a deta;
- kusankha ndi kusanthula deta kuti mudziwe zambiri.
Ngakhale kuti masambawa amagwiritsidwa ntchito kwambiri pofuna kusungirako deta, iwo alibe mphamvu zomwezo zokonza kapena kuchotsa deta monga mapulogalamu okhudzidwa.
Zosungidwa pa fayilo la spreadsheet zingathenso kuphatikizidwa m'mawonetsero apakompyuta, masamba, kapena kusindikizidwa mu mawonekedwe a lipoti.
Woyamba & # 34; Willer App & # 34;
Mafayilo anali mapulogalamu opha oyambirira a makompyuta. Mapulogalamu oyambirira a spreadsheet, monga VisiCalc (omasulidwa mu 1979) ndi Lotus 1-2-3 (atatulutsidwa mu 1983), ndiwo makamaka omwe amachititsa kuti makompyuta adziwe ngati Apple II ndi IBM PC ngati zipangizo zamalonda.
Baibulo loyamba la Microsoft Excel linatulutsidwa mu 1985 ndipo linangothamanga pamakompyuta okhaokha a Macintosh. Chifukwa adapangidwira Mac, idaphatikizapo mawonekedwe omwe amagwiritsa ntchito omwe akuphatikizapo menyu ndi ndondomeko ndi kuwongolera mphamvu pogwiritsa ntchito mbewa. Kuyambira mu 1987 panalibe mawindo oyambirira a Windows (Excel 2.0).