Yazi iindawo ukuze usebenze ngokubanzi
Ukuba untsha ukuya kwi-Excel, isigama saso sinokuba ngumngeni omncinci. Nantsi ukuhlaziywa kweengxenye eziphambili zekrini ze-Excel 2010 kunye nenkcazo yeendlela ezo zindawo ezisetyenziswa ngayo. Ininzi yale nkcazelo ifake isicelo kwiinguqulelo ze-Excel zangaphambili.
Cell Active
Xa ucofa kwiseli ku-Excel, iseli esebenzayo iboniswe ngumgca wayo omnyama. Ufaka idatha kwiseli esebenzayo. Ukuhambisa kwelinye iseli kwaye wenze ukuba lusebenze, nqakraza kuyo kunye nemouse okanye sebenzisa izitshixo zokucima kwikhibhodi.
Ifayile yefayile
Ithebhu yefayile entsha kwi-Excel 2010 - uhlobo. Yifaka indawo ye-Office Button kwi-Excel 2007, eyayibuyisela imenyu yefayile kwiinguqu zangaphambili ze-Excel.
Njengemenyu yefayili endala, iifayile zefayile zefayili zihambelana kakhulu nokuphathwa kwefayile ezifana nokuvula iifayile ezintsha zekhompyutha okanye ezikhoyo, ukugcina, ukushicilela, kunye nenqaku elitsha elifakwe kule nguqulo: ukugcina nokuthumela iiFayile kwiFom yefomathi.
Ibha yefomula
Ibha yefomula ilapha ngaphezu kwiphepha lokusebenzela, le ndawo ibonisa iziqulatho zeseli esebenzayo. Ingasetyenziselwa ukungena okanye ukuhlela idatha kunye namafomula.
Igama leBhokisi
Ifakwe ecaleni kweruba yefomula, Ibhokisi legama libonisa iselferensi yeseli okanye igama leseli esebenzayo.
Iileta zekholomu
Iikholamu zisebenza ngokuzenzekelayo kwiphepha lokusebenzela , kwaye nganye iyachongwa ngeteksi ekhompyutheni ehamba phambili.
Inani leeNombolo
Iimilo zihamba ngokukhawuleza kwiphepha lokusebenzela kwaye zichongwa ngenombolo elandelwayo .
Idilesi yekholomu kunye nenombolo yomgca yenza i referensi yeseli. Isinye iseli kwiphepha lokusebenzela singabonwa ngolu hlobo lwencwadi kunye neenombolo ezifana ne-A1, F456, okanye iAA34.
Iithebhu zeShedyuli
Ngokungagqibekanga, kukho iifayile ezi-3 kwifayile ye-Excel, nangona kukho enye. Ithebhu ephantsi kwephepha lokusebenzela likuxelela igama lephepha lokusebenzela, njengeSheet1 okanye iSheet2.
Shintsha phakathi kwamaphepha okusebenzela ngokuchofoza kwiphepha lephepha ofuna ukuyifumana.
Ukuqamba kabusha iphepha lokusebenzela okanye ukutshintsha umbala wethebhu kunokukwenza kube lula ukulandelela idatha kwiifayile ezinkulu zespredishithi.
Ibha yamathuluzi okuFikelela
Le barbar ibinokukhangela ukugcina imiyalelo esetyenziswa rhoqo. Cofa kwinqolo ehla ngasekupheleni kwebar yebar u kubonisa okukhethwa kukho ibha yamathuluzi.
IRibhoni
I-Ribbon yimiqulu yeeqhosha kunye neempawu ezikulo ndawo. I- Ribbon iququzelelwe kwichungechunge lweetabhtha ezifana neFayile, iKhaya, kunye neFomula. Ithebhu nganye iqulethe iinkalo ezinxulumeneyo kunye neenketho. Eyokuqala evezwe kwi-Excel 2007, iRibbon ithathe indawo yamagama kunye neetrabars ezifunyenwe kwi-Excel 2003 kunye neenguqulelo zangaphambili.