Iphepha lokusebenzela okanye iphepha likhasi elilodwa kwifayili eyenziwe kwiprogram yespredishithi ye-elektroniki njenge-Excel okanye i-Google AmaSpredishithi. Incwadi yomsebenzi igama elinikwe kwifayile ye-Excel kwaye iqukethe enye yamaphepha okanye ama-worksheets. Ixesha elithi spreadsheet lisoloko lisetyenziselwa ukubhekisela kwincwadi yencwadi, xa, njengoko kukhankanywe, ichanekileyo ngokubhekiselele kwinkqubo yekhompyutha ngokwayo.
Ngoko ke, ngokuthe ngqo, xa uvula inkqubo yespredishithi yekhompyutheni iyalayisha iifayili yencwadi engenalutho equkethe enye okanye ngaphezulu kwamaphepha okusebenzela oyisebenzisayo.
Iinkcukacha zokusebenzela
Iphepha lokusebenzela lisetyenziselwa ukugcina, ukusetyenziswa, nokubonisa idatha .
Iyunithi yesiseko yokugcina yedatha kwiphepha lokusebenzela iiseli ezinemilo emacatsheni ezilungiswe kwipateni yegridi kwiphepha lokusebenzela.
Iiseli zomntu ngamnye zichongiwe kwaye ziququzelelwe ngokusebenzisa iileta zemiqolo kunye namanani omqolo ojikelezayo wephepha lokusebenzela elidala isalathisi yeseli - njenge-A1, D15, okanye i-Z467.
Iinkcukacha zeeWebhu zeenkcukacha zangoku ze-Excel ziquka:
- Imivuzo eyi-1,048,576 nganye ngephepha lokusebenzela;
- Iikhompyutheni ezili-16,384 ngephepha lokusebenzela;
- 17,179,869,184 iiseli nganye kwiphepha lokusebenzela;
- kwiphepha elilodwa lomsebenzi weefayile ezintsha (ezizenzekelayo);
- umda kwinani lamaxwebhu ngefayile. Oku kunqongophele kuphela ngemali yememori efumanekayo kwikhompyutha.
Iifayile zeGoogle:
- Kukho iikholeji ezingama-256 ngephepha ngalinye.
- Inani elona likhulu leeseli kuwo onke amaxwebhu okusebenzela kwifayile yi-400,000.
- Inombolo engagqibekanga yamanqaku okusebenzela iifayile ezintsha enye.
- Kukho ama-worksheets angaphezu kwama-200 ngefayile yepredishithi nganye.
Amanqaku okusebenzela
Kuzo zombini i-Excel kunye ne-Google Spreadsheets, iphepha ngalinye lomsebenzi linalo igama. Ngokungagqibekanga, iifayile zemiSebenzi zibizwa ngokuba yiSheet1, iSheet2, iSheet3 njalo njalo, kodwa ezi ziza kutshintshwa lula.
Amanani omsebenzi
Ngokungagqibekanga, ukususela kwi-Excel 2013, kukho kuphela iphepha lokusebenzela ngeencwadi ezintsha ze-Excel, kodwa eli xabiso elingagqibekanga linokutshintshwa. Ukwenza njalo:
- Cofa kwi Imenyu yefayile .
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye -Excel.
- Kulo Xa udala icandelo lamaphepha omsebenzi kwicala elifanelekileyo kwibhokisi yencoko yababini, khulisa ixabiso elikufutshane ukuquka ezi festile ezininzi.
- Cofa kwi- OK ukugqiba utshintsho kwaye uvale ibhokisi yencoko.
Qaphela : Inombolo engapheliyo yamashidi kwifayile ye-Google Spreadsheets enye, kwaye oku akunako ukutshintshwa.
Iinkcukacha zeencwadi
- Ezinye iifishthi zemivuzo zingongezwa kwincwadi yokusebenzisa usebenzisa imenyu yomongo okanye isithonjana se-Add Sheet (kunye nesayina) ecaleni kwamathebhu ekhoyo njengokuba kubonwe kumfanekiso ongentla.
- Kuyakwazi ukucima okanye ukufihla amaphepha okusebenzela ngamnye kwincwadi yokusebenzela.
- Kwakhona kunakho ukuqamba kwakhona amaxwebhu omsebenzi kunye nokutshintsha imibala yetshekhthi yomsebenzi ukwenza kube lula ukuchonga amaxwebhu ngamnye kwincwadi yokusebenzela usebenzisa imenyu yomongo.
- Ukutshintsha ukusuka kwiphepha lokusebenzela ukuya kwelinye kwincwadi yencwadi kunokwenziwa ngokucofa kwiphepha leskrini ngaphantsi kwesikrini.
- Kwi-Excel, ukuhlanganiswa okubalulekileyo kwindlela efutshane yokuncinci kungasetyenziselwa ukutshintsha phakathi kwamaphepha okusebenzela :
- Ctrl + PgUp (iphepha phezulu) - hamba ngakwesokudla
- Ctrl + PgDn (iphepha elisezantsi) - hamba ngakwesobunxele
- Kwi-Google Spreadsheets, inhlanganisela yeqhosha lokuncinci ukutshintshela phakathi kwamaphepha okusebenzela:
- Ctrl + Shift + PgUp - hamba ngakwesokudla
- Ctrl + Shift + PgDn - hlela ngakwesobunxele