Electronic excel-spreadsheet - ithuluzi eliwusizo ukuhlaziya idatha

Ifomu tabular ifanekisela ulwazi oluthile generalized, ngokuvamile okwalandela ukuhlaziywa idatha. Excel ungakwazi ukushintsha inqubo Computing nokuphatha idatha, imidwebo amele ukuhlaziywa ulwazi.

Lapho hlelo ugijima ibhuku ezingenalutho wabonisa esibukweni, okuyinto iqoqo amashidi ezintathu (okuzenzakalelayo), ngasinye lapho itafula likhona. Ithebula imigqa ibalwa kusukela 1, futhi amakholomu esiqokiwe zesi-Latin, eziqala A. In ishidi Imininingwane 65 ibekwe phezu izinkulungwane imigqa phezu 250 amakholomu. Electronic Excel ithebula aqukethe amaseli ebekwe A1 uhlobo, lapho A - ikholomu isiqu, 1 - umugqa isiqu. Ungaphinde ukhethe block of amaseli. Ngokwesibonelo, A1: C4 ukuqokwa limelela iqoqo amaseli okuqondene isifunda elingunxande, okuyinto emakhoneni steel kuseli A1 bese C4.

uhlamvu ukufometha kumaseli kuyafana ye-word, kuphela Excel imingcele mbalwa kungashintshwa. Zonke manipulation amaseli engenziwa basebenzisa ibhokisi "Ifomethi Amaseli."

Njengomthetho, ngemva ukucutshungulwa idatha kubalulekile ukwethula imiphumela ngefomu sokuqhafaza. Kukhona amathuba amaningi kule Excel. Ibha emagrafu, emashadi, iphuzu futhi pie amashadi. Ngamunye wabo usetshenziselwa ezimweni ezithile. Uma ufuna imidwebo ukubonisa ubuhlobo amasethi amabili idatha, ungasebenzisa igrafu noma ishadi chitha. Uma ufuna ukukhombisa izingxenye lonke, singakwazi ukwakha pie noma Ungalokothi ishadi. Kulo mBhalo, ukuze kube lula ukuqonda umdwebo kuyinto efiselekayo ukuthatha senombolo yamanani uhla 5-6.

Amaseli kungenzeka etholakala idatha yoqobo njengoba umbhalo, izinombolo (integers, amafraktjhini, percents, njll), kanye amafomula. Noma yimuphi ifomula iqala isibonakaliso "=" futhi liqukethe etafuleni notation amaseli, izimpawu izibalo imisebenzi nemisebenzi ejwayelekile. Uhlelo Microsoft Excel has 10 imikhakha imisebenzi: ezezimali, usuku kanye nesikhathi, zezibalo, kwezibalo nabanye. Lokhu kwenziwa kube lula uhlu zabo, lapho bonke imisebenzi ahlelwe ngokulandelana kwama-alfabhethi (lokuqala ngesiNgisi bese ngesiRashiya).

Excel futhi babe khono of ukuhlunga kanye nedatha zokuhlunga. Uma imenze etafuleni uhlu olude ke kungaba lula impela ukusebenza, uma uhlele imigqa in inyuka noma kwehle. Ngaphezu kwalokho, imithombo yezokuzijabulisa ingadlulisela ekuhlungeni zenziwa ikholomu noma nakakhulu. Lemifanekiso ivumela ukukhetha imigqa ezithile ngesisekelo (isimo). Isibonelo, ungabonisa esikrinini, kuphela labo ukuziphatha ngaphezu kuka-zero.

Lapho i okukhiphayo kuya Excel ukuphrinta kalula ulungise kunoma usayizi ishidi, ngokwandisa noma ukunciphisa esikalini. Ngokuzenzakalelayo, imingcele ithebula awabonakali uma uzitholele, ngakho uma udinga ukuba, ungakwazi ukubonisa igridi ngokusebenzisa inkhulumomphendvulwano "Ifomethi Amaseli" (i- "Border").

UHlelo Lokungena Emibikweni Ye-2010 uhlelo kufakwe MicrosoftOffice 2010 iphakethe ukuthi kuhlanganisa omunye kweshumi yezinye izinhlelo zokusebenza ewusizo. Woke amahlelo la abe esibonakalayo efanayo esenza kube lula ukucubungula ukuthuthukiswa umsebenzisi.