Funda ukuthi yiziphi lezo zincenye kwesikrini se-Excel enhle
Uma usemusha ukusebenzisa i-Excel 2013 ngama-spreadsheet, ungahle ukwazi ukuthi konke okukrini kusikrini. Kungenzeka ukuthi uzothola izindlela ezilula noma ezisebenzayo zokusebenza nama-spreadsheet wakho uma uthola okwengeziwe mayelana nesimo esibonakalayo. Nakhu ukubuka okusheshayo izingxenye zesibuko se-Excel.
Excel 2013 Screen Elements
Isikrini se-Excel sigcwele amathuba. Ngemuva kokuthi ufunde ukuthi isigaba ngasinye sini, uzobe ushiya izipredishithi ezibukeka kahle ezikhathini.
Bheka isithombe esingenhla ukuthola izindawo ezichazwe.
Iseli esebenzayo
- Iseli elisebenzayo liyabonakala ngohlaka lwaso oluhlaza. Idatha ingena njalo esitokisini esisebenzayo. Amaseli ahlukene angenziwa asebenze ngokuchofoza kubo ngegundane noma ngokusebenzisa okhiye bomcibisholo ekhibhodi.
Engeza I-Ishi Icon
- Ukuchofoza isithonjana se- Ishidi eseza eceleni kwethebhu yethebhu ngaphansi kweskrini kuneza elinye iphepha lokusebenzela. (Ungasebenzisa futhi izinqamuleli ezimbili zekhibhodi ukwengeza ishidi lokusebenzela elisha : Shift + F11 ne- Alt + Shift + F1.)
Iseli
- Amaseli angama-boxes angama-rectangular asezindaweni eziphakathi kwephepha lokusebenzela.
- Idatha efakwe kushidi lokusebenzela igcinwa esitokisini. Iseli ngayinye lingabamba ingxenye eyodwa yedatha ngesikhathi esisodwa.
- I-cell iyinkhomba yezingxenyana zekholomu eliqondile nomugqa oqondile.
- Iseli ngayinye kuphepha lokusebenzela lingabonwa ngereferensi yeseli , okuhlanganiswa kwezinhlamvu nezinombolo ezifana ne-A1, F456, noma i-AA34.
Izincwadi zekholomu
- Amakholomu asebenza ngokuzenzekelayo ephepheni lokusebenzela , futhi ngayinye ibonakala ngencwadi ekhoneni lekholomu.
Ibha yefomula
- Kutholakala ngaphezu kwephepha lokusebenzela, le ndawo ibonisa okuqukethwe kweseli esebenzayo. Ibha yefomula ingasetshenziselwa ukufaka noma ukuhlela idatha kanye namafomula .
Ibhokisi legama
- Kutholakala eduze kwebhola lefomula, Ibhokisi Legama libonisa ireferensi yeseli noma igama leseli esebenzayo.
Ibha yamathuluzi okufinyelela okusheshayo
- Ibha yamathuluzi ye-Quick Access ikuvumela ukuthi ungeze imiyalo esetshenziswa njalo. Chofoza umcibisholo ophansi ekupheleni kwebha yamathuluzi ukuze ubonise izinketho ezitholakalayo.
I-Ribbon
- I- Ribbon ingumdwebo wezinkinobho nezimpawu ezitholakala ngaphezu kwephepha lokusebenzela. Uma uchofoze, lezi izinkinobho nezimpawu zivuselela izici ezihlukahlukene zohlelo. Okokuqala okulethwe ku-Excel 2007, i-ribbon ithathe indawo yamamenyu namathuluzi wamathuluzi atholakala ku-Excel 2003 nezinguqulo zangaphambili.
Amathebhu we-Ribbon
- Amathebhu we-Ribbon ayingxenye yemenyu ye-ribbon enezingqimba equkethe izixhumanisi ezihlukahlukene ezihlangene zohlelo. Ithebhu ngayinye -kufana nekhaya , ukuhlelwa kwekhasi , namafomula - iqukethe izinto eziningana ezihambisanayo nezinketho ezenziwa ngokuchofoza isithonjana esifanele.
Ithebhu Yefayela
- Ithebhu yefayela ithunyelwe ku-Excel 2010, esikhundleni se-Button Office ye-Excel 2007, futhi isebenza ngokungafani namanye amathebhu. Esikhundleni sokuba nezinketho zayo zibonise i-Ribbon enezingqimba, ukuchofoza ithebhu yefayela kuvulwa imenyu yokudonsa ngakwesokunxele kwesikrini.
- Lethebhu iqukethe izinto ezihlobene kakhulu nefayela nokuphathwa kwedokhumenti, njengokuvula amafayela omsebenzi omusha noma okhona, ukulondoloza nokunyathelisa.
- Into yezinketho, eyatholakala futhi kwimenyu, isetshenziselwa ukushintsha ukubukeka kohlelo lonke ngokukhetha ukuthi yiziphi izakhi zesikrini okufanele ziboniswe, njengezingcingo zokupheqa namagaladi wegridi. Iqukethe nezinketho zokuqalisa izilungiselelo eziningi ezihlanganisa ukuvuselelwa okuzenzakalelayo kwamafayili okusebenzela bese ukhetha iziphi izilimi ozisebenzisela ukuhlolwa kwesipelingi nohlelo lolimi.
Izinombolo zamanani
- Imigqa isebenza ngokuzenzekelayo kwiphepha lokusebenzela futhi likhonjiswe ngenombolo ekhanda lomugqa .
Amathebhu weSpredishithi
- Ngokuzenzakalelayo, kuneshidi elilodwa lokusebenzela kufayela le-Excel 2013, kodwa ungangezela amanye amashidi. Ithebhu ye-Sheet ngezansi kwekhasi lokusebenzela litshela igama lephepha lokusebenzela, njengeSheet1 noma i- Sheet2 .
- Ukuqamba kabusha ishidi lokusebenzela noma ukushintsha umbala wethebhu kungenza kube lula ukulandelela idatha kumafayela amakhulu wepredishithi.
- Ukushintsha phakathi kwamashidi okusebenza kungenziwa ngokuchofoza kuthebhu leshidi ofuna ukufinyelela. (Ungashintsha phakathi kwamashidi okusebenza ngezinqamuleli zekhibhodi ukuze ushintshe phakathi kwamashidi okusebenza : Ctrl + PgUp no- Ctrl + PgDn.)
Ibha yomumo
- I- Status Bar , egijima ngokuzansi ngaphansi kweskrini, ingahle ibekwe ngokwezifiso ukubonisa izinketho eziningi, eziningi zazo ezinikezela ngolwazi lomsebenzisi mayelana nephepha lokusebenzela, idatha iphepha lokusebenzela liqukethe, futhi ikhibhodi yomsebenzisi kufaka phakathi ukuthi i- Caps Lock , Skrolela Khiya , futhi izinkinobho ze- Num Lock zivuliwe noma zivaliwe.
- Ibha yesimo nayo iqukethe isilayidi se-Zoom , evumela abasebenzisi ukuthi bashintshe ukukhuliswa kweshidi lokusebenzela.
Slider Sondeza
- Kutholakala ekhoneni elingezansi elingakwesokudla kwesikrini se-Excel, islayidi yeSondon isetshenziselwa ukuguqula ukukhuliswa kweshidi lokusebenzela uma udonsela ibhokisi lesilayidi emuva noma phambili noma uchofoze izinkinobho Zoom Out no Zoom In ezikupheleni kwesilayidi.
Ukubuyekeza kwangaphambili kwe-Excel
Uma ungasebenzisi i-Excel 2013, enye yalezi zihloko ingaqukatha ulwazi olufunayo.