Electronic Excel spreadsheet - sisixhobo esiluncedo ukuba uhlalutyo lwe data

Ifomu tabular kusetyenziswa ukumela ulwazi ngendlela ngokubanzi, ngokuqhelekileyo ngenxa uhlalutyo data ezilandelayo. Excel spreadsheets nga zokusebenzisa inkqubo yolawulo wecomputing kunye data, ngokwegrafu ukumela uhlalutyo lolwazi.

Xa edle incwadi engenanto ebekwe kwiskrini, nto leyo iseti kweemakhishithi ezintathu (okwendalo), ngasinye apho itafile ekhoyo. Imiqolo Table zibaliwe-1, kwaye imihlathi ezikhethiweyo Latin, kuqalwa A. iphepha elipheleleyo 65 ibekwe phezu kwamawaka ngemiqolo phezu nemihlathi 250. itheyibhile Electronic Excel luqulathe iiseli elityunjwe A1 uhlobo, apho A - umhlathi uphawulo, 1 - umgca isiqu. Unako kwakhona Ungakhetha ibhloko iiseli. Umzekelo, A1: C4 uphawulo imele isethi iiseli akwi kummandla ebuxande, leyo cell iikona yentsimbi A1 no C4.

uphawu ifomathi iiseli ifana kakhulu umqhubekekisi wegama, kuphela Excel mbalwa parameters ukuba itshintshwe. Zonke manipulation iiseli inokwenziwa usebenzisa ifayile yencoko yababini "Iiseli Format."

Njengoko umthetho, emva kokuba lweenkcukacha kuyimfuneko ukubeka iziphumo ngohlobo lomzobo. Kukho ngamathuba angawo ukulungiselela oku Excel. iigrafu Bar, iitshati, indawo kunye neetshathi ipayi. Ngamnye kubo isetyenziswa kwiimeko ezithile. Ukuba ufuna ukubonisa ngokwegrafu ukuzalana yeeseti ezimbini data, ungasebenzisa igrafu okanye itshathi, uyachithachitha. Ukuba ufuna ukubonisa amalungu yonke, sinako ukwakha itshathi yephayi okanye yokuthengisa amaqebengwana. Kwimeko yokugqibela, ukuze kube lula ukuqonda mfanekiso Kuyancomeka ukuthatha inani lamaxabiso kuluhlu 5-6.

Iiseli inokufunyanwa kwi idatha yoqobo kokubhaliweyo, amanani (integers, amaqhezu, percents, njl), kwakunye ifomula. Nayiphi ifomula luqala umqondiso "=" kwaye iqulethe iiseli table notation, iimpawu imisebenzi izibalo kunye nemisebenzi eqhelekileyo. inkqubo Microsoft Excel lunamacandelo 10 kwemisebenzi: zemali, umhla kunye nexesha, yezibalo, zamanani kunye nabanye. Oku kwenziwa kuba lula kuluhlu lwabo, apho zicwangciswe yonke imisebenzi alfabhethi (yokuqala IsiNgesi uze in Russian).

Excel spreadsheets kwakhona ulwenzeko yokuhlela kunye data lokuhluza. Ukuba ungenise netafile uluhlu olude, ngoko kunokuba kakhulu lula ukusebenza, ukuba amalungiselelo imiqolo ngokokhokho okanye kwehle. Ngaphezu koko, njani ukuze kwenziwa nawuphi na umqolo okanye ngaphezulu. Isihluzo ikuvumela ukuba ukhethe imiqolo ezithile isiseko (imeko). Ngokomzekelo, iyakwazi ukubonisa kwikhusi, kuphela ezo amaxabiso ukuba mkhulu kuno-zero.

Xa imveliso Excel spreadsheets kushicilelo lula ukulungisa nayiphi na sheet ubukhulu, ukwanda okanye ukuhla isikali. Ngokungagqibekanga, imida itafile azibonakali xa ukuprinta, ngoko ukuba ufuna njalo, unako ukubonisa igridi ngengxoxo "Iiseli Format" (i "Border").

Microsoft Excel program 2010 zibandakanyiwe MicrosoftOffice package 2010 ebandakanya omnye elinesibini ezinye izicelo luncedo. Zonke ezi nkqubo kufuneka ujongano efanayo lula inkqubo yophuhliso umsebenzisi.