Iphepha lokusebenzela noma ishidi lilodwa elilodwa kufayela elidalwe nge-electronics spreadsheet program efana ne-Excel noma amaSpredishithi e-Google. Ibhuku lezincwadi igama elinikwe ifayela le-Excel futhi liqukethe ama-worksheet eyodwa noma ngaphezulu. Leli gama lesipredishithi livame ukusetshenziselwa ukubhekisela kubhuku lokusebenzela, uma, njengoba kukhonjisiwe, libhekisela ngokwengeziwe ohlelweni lwekhompyutha ngokwayo.
Ngakho-ke, uma uvula uhlelo lwesipredishithi lwe-electronic lilayisha ifayela lokusebenzela elingenalutho eliqukethe eyodwa noma ngaphezulu ama-worksheets angenalutho ongayisebenzisa.
Imininingwane yephepha lokusebenzela
Iphepha lokusebenzela lisetshenziselwa ukugcina, ukuphatha, nokubonisa idatha .
I-unit yokugcina eyisisekelo yedatha kushidi lokusebenzela ama- cell ahlotshaniswa emagqeni angama-rectangular ahlelwe kuphethini yegridi kuzo zonke izikhwama zomsebenzi.
Amaseli omuntu ngamunye wedatha ahlonishwa futhi ahlelwe ngokusebenzisa izinhlamvu zamakholomu eziqondile nezinombolo zomugqa ohamba phambili wephepha lokusebenzela elidala ireferensi yeseli - njenge-A1, D15, noma i-Z467.
Imininingwane yephepha lokusebenzela yezinguqulo zamanje ze-Excel zifaka:
- Imigqa engu-1,048,576 ngeshidi lomsebenzi;
- Amakholomu angu-16,384 ngeshidi lomsebenzi;
- 17,179,869,184 amaseli ngayinye ngeshidi lokusebenzela;
- ikhasi elilodwa lokusebenzela lamafayela amasha (okuzenzakalelayo);
- umkhawulo kunani lamashidi ngefayela ngalinye. Lokhu kunciphise kuphela inani lememori elitholakalayo kwikhompyutha.
AmaSpredishithi e-Google:
- Kukhona amakholomu angama-256 ngeshidi ngalinye.
- Inombolo enkulu yamaseli kuwo wonke ama-worksheets efayeleni ingu-400,000.
- Inombolo ezenzakalelayo yamakhasi okusebenzela amafayela amasha munye.
- Kunamakhasi ama-200 angaphezu kwefayela ngalinye lesipredishithi.
Amagama E-Worksheet
Kokubili i-Excel ne-Google Spreadsheets, ishidi ngalinye lomsebenzi linalo igama. Ngokuzenzakalelayo, ama-worksheets abizwa nge-Sheet1, Sheet2, Sheet3 njalonjalo, kodwa lokhu kungashintshwa kalula.
Izinombolo Zokusebenzela
Ngokuzenzakalelayo, kusukela ku-Excel 2013, kunephepha lokusebenzela kuphela ngebhuku elisha le-Excel, kodwa leli xabiso elizenzakalelayo lingashintshwa. Ukwenza kanjalo:
- Chofoza kwimenyu yefayela .
- Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye- Excel.
- Kulo Uma udala isigaba esisha sezincwadi zokusebenzela ebhokisini elifanele lebhokisi lebhokisi, khulisa inani elilandelayo eduze Kokufaka lezi amashidi amaningi.
- Chofoza ku- Kulungile ukuqedela ushintsho bese uvale ibhokisi lengxoxo.
Qaphela : Inombolo ezenzakalelayo yamashidi kufayela le-Google Spreadsheets ingenye, futhi lokhu akukwazi ukuguqulwa.
Imininingwane yezincwadi
- Amafomu okusebenza engeziwe anganezwa kubhuku lokusebenzela usebenzisa ukusebenzisa imenyu yokuqukethwe noma isithonjana se-Add Sheet (plus uphawu) eceleni kwamathebhu wamanje njengabonwa esithombeni ngenhla.
- Kungenzeka ukususa noma ukufihla amashidi okusebenzela ebhukwini lokusebenzela.
- Kungenzeka futhi ukuqamba kabusha ama-worksheet ngabanye futhi ushintshe imibala yamathebhu okusebenza ukuze wenze kube lula ukukhomba amashidi ngabanye ebhokisini lokusebenzela usebenzisa imenyu yesimo.
- Ukushintsha kusuka kweshidi elilodwa kuya kwelinye ebhukwini kungenziwa ngokuchofoza kuthebhu yethebhu ezansi kwesikrini.
- Ku-Excel, inhlanganisela elandelayo yekhibhodi yokushombisa ingasetshenziswa futhi ukushintsha phakathi kwamashidi okusebenza :
- I-Ctrl + PgUp (ikhasi phezulu) - hamba ngakwesokudla
- Ctrl + PgDn (ikhasi phansi) - hamba ngakwesokunxele
- AmaSpredishithi e-Google, inhlanganisela yokhiye wezinqamuleli zokushintsha phakathi kwamashidi okusebenza:
- Ctrl + Shift + PgUp - hamba ngakwesokudla
- Ctrl + Shift + PgDn - hamba ngakwesokunxele