Pakompyuta amakhoza spreadsheet - chida chothandiza kwa kusanthula deta

The tabular mawonekedwe ntchito kuimira zambiri mu mawonekedwe zowombetsa mkota, kawirikawiri kwa kusanthula wotsatira deta. Excel spreadsheets akhoza automate ndondomeko ya kayendetsedwe kompyuta ndi deta, zimaonetsa akuimira kusanthula zambiri.

Msonkhanowu limayenda lolembamo kanthu anasonyeza pa zenera, yomwe ndi ya mapepala zitatu (cha kusakhulupirika), aliyense amene tebulo alipo. Table mizera 1, ndi mizati chokhazikitsidwa mu makalata Latin, kuyambira A. okwana pepala 65 pamwamba pa zikwi mizere ndi oposa 250 mizati. Pakompyuta kupambana tebulo zigwirizana maselo anatchulidwa A1 mtundu, kumene A - ndime lakuti, 1 - mzere chikhazikitso. Mukhozanso kusankha chipika maselo. Mwachitsanzo, A1: C4 lakuti akuimira ya maselo ndiwe wa dera amakona anayi, omwe ngodya zitsulo selo A1 ndi C4.

khalidwe Zokongoletsa maselo ndi zofanana kwambiri ndi purosesa mawu okha mu kupambana magawo ochepa kuti zikhoza kusintha. Onse mpheto kwa maselo angathe kuchitidwa ntchito kukambirana "Mtundu Maselo."

Monga ulamuliro, pambuyo processing deta m'pofunika kuti mupereke zotsatira mu mawonekedwe mawonekedwe. Pali mwayi wokwanira imeneyi kupambana. Bar chintchito, matchati, mfundo ndi matchati chitumbuwa. Aliyense wa iwo ntchito nthawi zina. Ngati mukufuna zimaonetsa kuwonetsa ubale wa miyeso iwiri deta, mungagwiritse ntchito Zithunzi kapena kuwanditsa tchati. Ngati mukufuna kusonyeza ziwalo za lonse, tikhoza kupanga chitumbuwa kapena kalikiliki tchati. Zikatero, kuti mayiko kumvetsa chithunzi ziri zofunika kutenga chiwerengero cha makhalidwe osiyanasiyana 5-6.

maselo akhoza ili mu deta pachiyambi monga malemba, manambala (integers, tuzigawo twa, percents, etc.), komanso mitunduyi. chilinganizo aliyense amayamba ndi chizindikiro "=" ndipo lili ndi kalembedwe tebulo maselo, zizindikiro za ntchito masamu ndi ntchito muyezo. Microsoft kupambana pulogalamu ali magawo 10 a ntchito: zachuma, tsiku ndi nthawi, masamu, zowerengera ndi ena. Izi zachitika chifukwa mayiko mndandanda awo, imene ntchito zonse anakonza kuti afabeti (loyamba m'Chingelezi ndiyeno Russian).

Excel spreadsheets sapeza imapanga kusanja ndi deta zosefera. Ngati inu kubweretsa tebulo mndandanda, ndiye kungakhale N'zosavuta kwa ntchito ndi, ngati kukonza mizere mu kukwera kapena kutsika dongosolo. Komanso, kusanja mwina kuchitidwa ndi ndime iliyonse kapena kuposa. Sefa amalola kusankha mizere ena a maziko (chikhalidwe). Mwachitsanzo, angasonyeze pa zenera, kokha makhalidwe amene ali wamkulu kuposa ziro.

Pamene linanena bungwe kwa kupambana spreadsheets yosindikiza mosavuta kusintha kwa pepala kukula kulikonse, kuchuluka kapena mwayamba kufooka lonse. Ndi kusakhulupirika, malire tebulo zosaoneka pamene inu kusindikiza, ngati mukufuna, mukhoza kusonyeza gululi kudzera kukambirana "Mtundu Maselo" (ndi "Border").

Microsoft kupambana 2010 pulogalamu m'gulu MicrosoftOffice 2010 phukusi monga dazeni wina wa ntchito zina zothandiza. mapulogalamu onsewa ndi mawonekedwe ofanana kuti zimatithandiza citukuko ya wosuta.