Isici esiyinhloko we spreadsheet ... Izakhi eziyisisekelo i isipredishithi Excel

Njalo PC umsebenzisi yesimanje, bake babhekana ne izinhlelo Microsoft Office, namuhla omunye ezivamile, uyazi ukuthi kuyinto impoqo samanje MS Excel isicelo. Manje sibheka Umqondo oyisisekelo spreadsheet. Endleleni, niyophiwa isifinyezo izici eyinhloko isakhiwo etafuleni izakhi kanye nedatha, futhi ezinye izici zazo.

Kuyini isipredishithi Excel?

Lapho kukhulunywa ngaye okokuqala i-Excel, libhekisela 1987, lapho i-Microsoft ezikhishwe edume kunazo yayo office suite kwezinhlelo zokusebenza, ngaphansi kwesihloko esithi jikelele MS Office.

Eqinisweni, i-spreadsheet Excel iyindlela jikelele zezibalo idatha ukucutshungulwa zonke izinhlobo namazinga nobunzima. Lokhu kuhlanganisa izibalo kanye algebra futhi geometry, futhi trigonometry umsebenzi nge matrices futhi izingabunjalo, futhi isixazululo salezi zimiso kuyinkimbinkimbi kunazo zibalo, nokuningi. Cishe konke libhekisela sciences ngqo ngomklamo evezwa hlelo. Ze-spreadsheet imisebenzi enjalo ukuthi abasebenzisi abaningi musa ke abazi ngazo, abangaze bangaqaphela ukuthi anamandla kangakanani le softhiwe. Kodwa izinto zokuqala kuqala.

Ukuqalisa nge Amaspredishithi

Njengoba ngokushesha ngemva kokuna umsebenzisi uqalisa isimiso Excel, ebona itafula wadala kusukela okuthiwa okuzenzakalelayo isifanekiso. The main esifundeni ukusebenza siqukethe lemigqa namakholomu, ogama empambana yakha cell. Ukuze siqonde ukusebenza nazo zonke izinhlobo idatha, element eyinhloko cell isipredishithi, kusukela ngiwo ephathwa ngayo.

Nokho, iseli ngalinye has ukulandelana izinombolo ehlanganisa irowu kanye ikholomu namagama, ezinguqulweni ezihlukahlukene isicelo ingehluka. Ngokwesibonelo, e-version 2003 iyona cell yokuqala, elise ezimpambanweni zomgwaqo kukholamu «A» futhi «1» umugqa, ukubizwa ngokuthi «A1». Ngo-2010 version, le ndlela ishintshile. Lapha notation umelwe ukulandelana kweenomboro nezinombolo, kodwa incazelo amakholomu kumugqa eyabizwa ngokuthi «C», futhi emgqeni - njengoba «R». Abaningi abakuqondi lokho ixhunyiwe. Kodwa yonke into ilula: «R» - uhlamvu lokuqala lesiNgisi elithi irowu (inombolo irowu), futhi «C» - ngowokuqala incwadi izwi ikholomu (ikholomu).

Idatha esetshenziswa

Yisho ukuthi isici esiyinhloko kuba yeseli isipredishithi, kufanele kuqondwe ukuthi lokhu kubhekisela kuphela idatha okufakwayo (amanani, umbhalo, amafomula, ubudlelwano obusebenzayo, njll). Idatha kumaseli angase abe isimo esihlukile. Cell format ushintsho umsebenzi kungaba ngokuthi kwimenyu yokuqukethwe uma chofoza kukho RMB (inkinobho yegundane kwesokudla).

Idatha kungenziwa okwethulwa umbhalo, izinombolo, iphesenti, notation ngokwesayensi, imali (imali), ayingxenye nesikhathi, kanye usuku. Ngaphezu kwalokho, ungacacisa imingcele engeziwe noma uhlobo zedesimali ngokusebenzisa izinombolo.

The main Uhlelo iwindi: Sakhiwo

Uma sihlole main isicelo iwindi, ungabona ukuthi version standard ethebuleni ingaqukatha kufika ku 256 kanye nemigqa 65.536. Ezansi amashidi ithebhu ahlelwe. Ngo ifayela zabo ezintathu ezintsha, kodwa kungenzeka ukusetha nokuningi. Uma sicabanga ukuthi isici esiyinhloko siwukuthi uyibhala isipredishithi, lo mqondo kumele kwenziwe isibaluli okuqukethwe amashidi ezahlukene zedatha ezahlukene engasetshenziswa uma ubalula engu- amafomula ezifanele noma imisebenzi.

imisebenzi enjalo ziwusizo kakhulu uma udala isifinyezo amatafula, amarekhodi, noma izinhlelo eziyinkimbinkimbi yezamakhompyutha. Kufanele futhi ukuthi khona ku amashidi ezahlukene ezihlobene idatha ngenxa ushintsho lamaseli engaphansi amashidi ibalwa ngokuzenzakalelayo ngaphandle kabusha ngokufaka ifomula noma umsebenzi eveza ubuhlobo ethile lokwehlukile futhi constants.

Kutholwe phezu ipuleti ejwayelekile nge imenyu ezimbalwa eziyisisekelo, ngezansana nje kwenqaba ibha ifomula. Ekhuluma idatha equkethwe amaseli, kungashiwo ukuthi isici esiyinhloko kuba isipredishithi kanye isici asebenzayo, kusukela e irowu kakhulu ubonisa umbhalo noma idatha yezinombolo sangena iseli noma ifomula kanye ukwencika sokusebenza. Ngokuya isibonisi iseli emgqeni amafomula okufanayo. Nokho, i-esebenzayo irowu format noma idatha uhlobo msebenzi. It nje izindlela kwehlwaya kanye ukuthayipha.

Amafomula e Excel

Ngokuphathelene amafomula zohlelo miningi. Ezinye zazo awazi nick eziningi. Nokho, Yiqiniso, ukuze asebenzelane nabo bonke babo, kungenzeka ukufunda ngokucophelela okufanayo reference guide, uhlelo inikeza ithuba kanye nenqubo ezishintshayo ekhethekile.

Ngokuchofoza ngakwesokunxele inkinobho ohlangothini «f _x» (noma uphawu "="), uhlu kuyiphi ukukhetha isenzo oyifunayo, okuzokwenza ugcine umsebenzisi ngesandla ethula ifomula.

Kukhona elinye ithuluzi ajwayele ukusetshenziswa. Lokhu Kuyazihlanganisela umsebenzi ethulwa ngesimo izinkinobho phezu yamathuluzi. Nalapha futhi, ungenalo ukufaka ifomula. Kwanele kusebenze iseli emgqeni futhi ikholomu ngemuva esikhethiwe, lapho kufanele ukwenza ukubala, bese uchofoze inkinobho. Futhi lokhu akuyona isibonelo kuphela.

Oxhumene idatha amashidi, amafayela, izikhombo

Ngokuphathelene izixhumanisi kuncike, iyiphi iseli bese ishidi ke kungenziwa bufakwe idatha kusuka endaweni ezahlukene idokhumenti, idatha ubuso isithombe yithuluzi Internet noma iskripthi elisebenzisekayo. Lize ikuvumela ukuba ugcine sediski futhi sinciphise ubukhulu idokhumenti yokuqala. Yiqiniso, nge kanjani ukwakha ukuxhumana okunjalo kufanele baqonde kahle. Kodwa njengoba besho, bekuyoba ufisa.

Engeza-in, imidwebo namashadi

Ngokuya mathuluzi angeziwe nezici MS Excel ukunikeza umsebenzisi ligunya lekukhetsa kabanti. Ingasaphathwa ethize add-ins noma elisebenzisekayo Java scripts Basic Visual, sizogxila ukudalwa nezinsiza ingcaca ezibukwayo ukubukwa sokuhlaziya imiphumela.

Kuyacaca ukuthi ukudweba ishadi noma igrafu yakhiwa ngesisekelo lenqwaba yedatha encike ngesandla, bese ufaka isithombe ku itafula uhele noma isithombe enamathiselwe akuyona wonke umuntu, futhi bafuna.

Yingakho ukusetshenziswa ukudalwa ngokuzenzekelayo pre-ukukhethwa ifomu kanye nohlobo. Kuyacaca ukuthi zisekelwe ezindaweni ezithize idatha. Njengoba isikhathi amagrafu yekwakha imidvwebo kungenziwa wagomela ukuthi isici esiyinhloko kuba isipredishithi endaweni ekhethiwe noma ezindaweni eziningana ku amashidi ezahlukene noma ezahlukene amafayela ananyathiselwe, okuyinto ezakususwa amagugu lokwehlukile ethembela kathisha imiphumela.

Sebenzisa okuhlungayo

Kwezinye izimo, kungase kudinge ukusetshenziswa okuhlungayo ekhethekile efakwe eyodwa noma ngaphezulu izinsika. Injalo elula, kuyasiza ukucinga idatha, umbhalo, noma kunenzuzo ikholomu. Lapho kuqondana zonke imiphumela etholakele uyoboniswa ngokwehlukile.

Uma kukhona ukuncika, nomunye ikholomu idatha ehlungiwe sizobonisa ezinye izindinganiso elise nezinye nemigqa. Kodwa lesi isibonelo silula, ngoba isihlungi ngokwezifiso ngamunye inemenyu encane yayo nge ethize nokuseshiwe noma kulungiselelwa ethize.

isiphetho

Yiqiniso, kubhekwe isihloko olulodwa zonke izici-MS Excel software iphakethe akunakwenzeka. Okungenani lapha ungabona lapho ziku amatafula main ngesisekelo ngamunye icala ngabanye noma isimo, kanye kancane ukuliqonda, ngakho ukukhuluma, izisekelo umsebenzi kulolu hlelo eliyingqayizivele. Kodwa ukuthuthukiswa yayo egcwele kuzodingeka basebenze kanzima. Ngokuvamile Onjiniyela ngokwabo musa bahlale bazi ukuthi ingane yabo uyakwazi.