01 ka 01
Incazelo ye-Cell kanye nokusetshenziswa kwayo ku-Excel nama-Google Spreadsheets
Incazelo
Iseli iyona iyunithi eyisisekelo yokugcina etholakalayo ohlelweni lwesipredishithi njenge-Excel noma i-Google Spreadsheet. Idatha efakwe ohlelweni lwesipredishithi igcinwa njalo esitokisini.
Esikrinini, iseli libonakala njengesakhiwo esinjengobhokisi futhi ngasinye sitholakala ekhoneni lezinhlangothi zekholomu eliqondile kanye nomugqa olinganiselwe ephepheni lokusebenzela.
Ngamakholomu angaba ngu-16,000 kanye nemigqa engaphezu kwezigidi ezingu-1 ngeshidi lomsebenzi , kunamaseli angaphezu kwezigidi eziyi-17 ngeshidi lomsebenzi ku-Excel. Amapredishithi e-Google amancane kakhulu namaseli angu-400,000 kuphela ngeshidi lokusebenzela.
Ukusetshenziswa
- Njengoba kukhonjisiwe, amaseli asetshenziselwa ukugcina idatha futhi asetshenziselwa ukubonisa idatha - ngokuvamile enekholomu nemigqa yedatha ehlobene eqoqwe ndawonye ukwenza amatafula.
- Amaseli angabamba izinhlobo ezine eziyisisekelo zolwazi (izinhlobo zedatha):
- Izinombolo - ezihlanganisa amafomula, izinsuku, nezikhathi;
- Idatha yombhalo - evame ukubhekwa njengezintambo zombhalo noma izintambo nje;
- Amagugu we-Boolean (ngezinye izikhathi abizwa ngokuthi amanani anengqondo ) - TRUE noma FALSE kuphela;
- Amanani wephutha - njenge-#NULL !, #REF !, no- # DIV / 0! - ezikhiqizwa wuhlelo uma ihlangabezana nenkinga nedatha esitokisini.
- Amaseli aqukethe amafomula yinhliziyo yama-spreadsheet izinhlelo ngoba lezi zibalo ezenza kube lula ukusebenza ngemininingwane eminingi. Ngokujwayelekile, amaseli abonisa imiphumela yamafomula, kodwa imodi ye-Excel yokubonisa amafomu ingahle ishintshwe futhi ivalwe njengoba kudingeka ukuze ubone ifomula esikhundleni sokuphendula esitokisini.
Izinkomba Zezinhlamvu
Njengoba kunikezwe inani lamaseli ngeshidi lomsebenzi, uhlelo lokuhlonza noma ukubhekana nalo oludingekayo ukuze idatha ingasheshi futhi ifakwe kalula uma kudingeka.
Isistimu esetshenziselwa amaspredishithi anamuhla ayizinkomba zeseli, eziyinhlanganisela yombhalo wekholomu nenombolo yomugqa wendawo yeseli. Kulezi zingqikithi zeseli , incwadi yekholomu ihlale ibhalwe kuqala njenge-A1, B12, noma i-AA2345.
Izinkomba zeselula zisebenza njengabanikazi bendawo uma zisetshenziswe ezintweni ezinjengamafomula namashadi kanye nokuba khona kwazo kwenza kube lula ukuvuselela la mafomula namashadi, ngoba noma yiluphi ulwazi olukhona esitokisini lungafakwa endaweni efanele kufomula noma ishadi .
Ukufometha kweselula
- Wonke amaseli kushidi lokusebenzela asebenzisa ukufometha okufanayo ngokuzenzakalelayo, okwenza ama-worksheets amakhulu aqukethe idatha enzima ukufunda. Ukwengeza ukufometha ezindaweni ezihlukene zeshidi kungasetha izingxenye ezithile futhi kwenze kube lula ukufunda nokuqonda.
- Ukufometha kweselula kuhluke ekufomeni kwenombolo . Ukufometha kweselula kuhilela izinguquko esitokeni ngokwayo - njengokushintsha umbala wangemuva weselula, ukungeza imingcele, noma ukuguqula ukulungiswa kwedatha. Amadili wokufometha kwenombolo nendlela izinombolo kumaseli aboniswa ngayo - njengemali, amaphesenti, noma ukubonisa izinombolo ezimbi ngokubomvu.
Kuboniswa nombhalo ogcinwe
Kuzo zombili i-Excel nama-Google Spreadsheets, uma kufakwa amafomethi enombolo, inombolo ephumela ekubonisweni esitokisini ingase ihluke kwinombolo egcinwe esitokisini futhi isetshenziswe kubalo.
Uma ukufometha izinguquko kwenziwa ezinombeni esitokisini lezo zinguquko zithinta kuphela ukubukeka kwenombolo hhayi inombolo ngokwayo. Isibonelo, uma inombolo 5.6789 esitokisini ifomathiwe ukukhombisa izindawo ezimbili kuphela ezide zamadesimali (amadijithi amabili kuya kwesokudla kwedayimali), iseli lizobonisa inombolo njengo-5.68 ngenxa yokugoqa idijithi yesithathu.
Izibalo nezinombolo ezifakiwe
Uma kuziwa ekusebenziseni amangqamuzana anjalo ahlelwe kwedatha kubalwa, noma kunjalo, inamba yonke - kulesi simo 5.6789 - ingasetshenziswa kuzo zonke izibalo hhayi inombolo ehambelanwe ebonakala esitokisini.
Ukwengeza Amaseli Ku-Worksheet ku-Excel
Qaphela: I-Google Spreadsheets ayivumeli ukwengeza noma ukususwa kwamangqamuzana angabodwa - kuphela ukwengeza noma ukususwa kwemigqa noma amakholomu.
Lapho amangqamuzana ngabanye ehlanganisiwe kwiphepha lokusebenzela, amaseli akhona nedatha yabo idluliselwa phansi noma ngakwesokudla ukwenza indawo yeseli elisha.
Amaseli angafakwa
- Ngamakhi okunciphisa ikhibhodi;
- Ngokuchofoza kwesokudla ngegundane
- Ngokusebenzisa inketho yokungenisa kwithebhu yaseKhaya yebhebhoni;
Ukwengeza ngaphezu kwelilodwa iseli ngesikhathi, ukhethe amaseli amaningi njengesinyathelo sokuqala ezindleleni ezingezansi.
Ukufaka Amaseli nge-Shortcut Keys
Inhlanganisela yekhibhodi yekhibhodi yokufakela amaseli ibe ishidi lokusebenza yilena:
Ctrl + Shift + "+" (plus uphawu)Qaphela : Uma unekhibhodi enombhalo we-Number Pad ngakwesokudla kwekhibhodi evamile, ungasebenzisa isibonakaliso + lapho ngaphandle kwesihluthulelo se- Shift . Inhlanganisela eyinhloko iba nje:
Ctrl + "+" (plus uphawu)Chofoza ngakwesokudla ngeMouse
Ukwengeza iseli:
- Chofoza ngakwesokudla kuseli lapho iseli elisha kufanele lengezwe ukuvula imenyu yokuqukethwe;
- Emenyu, chofoza ku-Faka ukuze uvule ibhokisi lokufaka le- Insert ;
- Ebhokisini lebhokisi, khetha ukuthi amaseli azungezile asuke phansi noma angakwesokudla ukwenza indawo yeseli elisha;
- Chofoza OK ukufaka iseli bese uvale ibhokisi lengxoxo.
Ngaphandle kwalokho, ibhokisi lokufaka le- Insert lingavulwa ngesithonjana se- Insert kuthebhu lasekhaya lebhoni njengoba kuboniswa esithombeni ngenhla.
Uma usuvulekile, landela izinyathelo ezintathu no-4 ngenhla ngokungeza amaseli.
Ukususa Amaseli kanye Nezicucu Zezingcingo
Amaseli ngabanye kanye nokuqukethwe kwawo nawo angasuswa kushidi lokusebenzela. Uma lokhu kwenzeka, amaseli nedatha yabo kusukela ngezansi noma kwesokudla kweseli esusiwe kuzohambisa ukugcwalisa igebe.
Ukususa amaseli:
- Qinisekisa eyodwa noma ngaphezulu amaseli ukuthi asuswe;
- Chofoza ngakwesokudla kumaseli akhethiwe ukuvula imenyu yemongo;
- Ku imenyu, chofoza ku-Susa ukuze uvule ibhokisi lengxoxo ye- Delete ;
- Ebhokisini lebhokisi, khetha ukuthi amaseli asuke phezulu noma ukusuka ngakwesobunxele ukuze athathe indawo esusiwe;
- Chofoza OK ukuze ususe amaseli bese uvale ibhokisi lengxoxo.
Ukususa okuqukethwe kweseli elilodwa noma ngaphezulu, ngaphandle kokususa iseli ngokwayo:
- Qinisekisa amaseli aqukethe okuqukethwe ukuthi asuswe;
- Cindezela ukhiye wokususa kukhibhodi.
Qaphela: Ikhi ye-Backspace ingasetshenziswa ukususa okuqukethwe kweseli elilodwa kuphela ngesikhathi. Ngokwenza kanjalo, ibeka i-Excel ku- Hlela imodi. Ukhiye wokususa kuyindlela engcono yokususa okuqukethwe kwamaseli amaningi.