Yazi izingxenye ukuze usebenze ngokwengeziwe
Uma ususha ku-Excel, igama layo lingasho ukuthi liyinselelo encane. Nansi ukubuyekezwa kwezingxenye eziyinhloko kwesikrini se-Excel 2010 kanye nezincazelo zendlela lezo zingxenye ezisetshenziswa ngayo. Okuningi kwalolu lwazi luphinde lusetshenziselwe izinguqulo zamuva ze-Excel.
Iseli esebenzayo
Uma uchofoza esitokisini ku-Excel, i- cell esebenzayo ibonakala ngombala wayo omnyama. Ufaka idatha kuseli elisebenzayo. Ukuthuthela kwesinye iseli bese uyenza kusebenze, chofoza kuso ngegundane noma sebenzisa okhiye bomcibisholo ekhibhodi.
Ithebhu yefayela
Ithebhu yefayela entsha ku-Excel 2010 - uhlobo. Kuyishintsho se-Office Button ku-Excel 2007, okwakuyindawo yokufaka imenyu yefayili kuzinguqulo zangaphambili ze-Excel.
Njengemenyu yefayela elidala, izinketho zethebhu yefayela zihlobene kakhulu nokuphathwa kwefayela njengokuvula amafayela omsebenzi omusha noma okhona, ukulondoloza, ukunyathelisa, nesici esisha esethuliwe kule nguqulo: ukulondoloza nokuthumela amafayela e-Excel ngefomethi ye-PDF.
Ibha yefomula
Ibha yefomula itholakala ngaphezu kwephepha lokusebenzela, le ndawo ibonisa okuqukethwe kweseli esebenzayo. Kungasetshenziswa futhi ukufaka noma ukuhlela idatha namafomula.
Ibhokisi legama
Kutholakala eduze kwebhola lefomula, Ibhokisi Legama libonisa ireferensi yeseli noma igama leseli esebenzayo.
Izincwadi zekholomu
Amakholomu asebenza ngokuzenzekelayo ekhasini lokusebenzela , futhi ngalinye likhonjiswe ngumbhalo okhonjiwe kukholomu.
Izinombolo zamanani
Imigqa isebenza ngokuzenzekelayo kwiphepha lokusebenzela futhi ibonakala ngenombolo emgqeni oholayo .
Iqoqo lekholomu kanye nenombolo yomugqa yakha ireferensi yeseli. Iseli ngayinye kuphepha lokusebenzela lingabonwa yilo nhlanganisela yezinhlamvu nezinombolo ezifana ne-A1, F456, noma i-AA34.
Amathebhu weSpredishithi
Ngokuzenzakalelayo, kunama-worksheets amathathu efayeleni le-Excel, nakuba kungenzeka kube ngaphezulu. Ithebhu ngezansi kwekhasi lokusebenzela likutshela igama lephepha lokusebenzela, njengeSheet1 noma i-Sheet2.
Shintshela phakathi kwamashidi okusebenza ngokuchofoza kuthebhu leshidi ofuna ukufinyelela.
Ukuqamba kabusha ishidi lokusebenzela noma ukushintsha umbala wethebhu kungenza kube lula ukulandelela idatha kumafayela amakhulu wepredishithi.
Ibha yamathuluzi okufinyelela okusheshayo
Le barbar ingenziwa ngezifiso ukuze ibambe imiyalo esetshenziswa njalo. Chofoza umcibisholo ophansi ekupheleni kwebha yamathuluzi ukuze ubonise okukhethwa kukho ibha yamathuluzi.
I-Ribbon
I-Ribbon yimibala yezinkinobho nezimpawu ezitholakala ngaphezu kwendawo yomsebenzi. I- Ribbon ihlelwe ibe uchungechunge lwamathebhu afana nefayela, ikhaya, namafomula. Ithebhu ngayinye iqukethe izici eziningi ezihlobene nezinketho. Okokuqala okuthunyelwe ku-Excel 2007, i-Ribbon ishintshe amamenyu namabha yamathuluzi atholakala ku-Excel 2003 nezinguqulo zangaphambili.