Funda ukuba zonke ezo ndawo zesikrini se-Excel zilungile
Ukuba unesitsha sokusebenzisa i-Excel 2013 kwiipredishithi, awukwazi ukuba yintoni into esesikrinini. Amathuba kukuba, uzakufumana iindlela ezilula okanye ezisebenzayo zokusebenza kunye nezipredishithi zakho emva kokuba ufumane okungakumbi malunga nomsebenzisi. Nanku ukujonga ngokukhawuleza kwiindawo ze-Excel kwesikrini.
Excel 2013 Screen Elements
I-Excel isikrini izaliswe ngamathuba. Emva kokuba ufunde ukuba yiliphi licandelo ngalinye, uya kukhwela iipredishithi ezikhangeleleneyo ezibuchwepheshe ngaphandle kwexesha.
Jonga umfanekiso ongentla ukufumana izinto ezichazwe.
Cell Active
- Iseli esebenzayo ibonakala ngoluhlu oluluhlaza. Idatha isoloko ingeniswa kwisisele esisebenzayo. Amaseli ahlukeneyo angenziwa ngokusebenza ngokuchofoza kuwo nge mouse okanye ngokusebenzisa izitshixo zokucoca kwikhibhodi.
Yongeza Ikhonkco Ikhonkco
- Ukuchofoza kwi- Ishici ye-Ishicilelo ecaleni kwithebhu yeSheet ezantsi kwesikrini kuneza elinye iphepha lokusebenzela. (Ungasebenzisa kwakhona iinkcenkceshelo ezimbini zekhibhodi ukuze ungeze iphepha lokusebenzela elitsha : Shift + F11 ne- Alt + Shift + F1.)
Cell
- Iiseli ziibhokisi ezixandekileyo ezikwindawo ephakathi kwiphepha lokusebenzela.
- Idatha efakwe kwishidi lomsebenzi igcinwa kwiseli. Isisele ngasinye sinokubamba iqela elilodwa lwedatha ngexesha.
- Isisele yinqanaba le-intersect of column column and row line.
- Isinye iseli kwiphepha lokusebenzela singabonwa ngeteksi yeseli , edibanisa iileta namanani anjenge-A1, F456, okanye i-AA34.
Iileta zekholomu
- Iikholamu zisebenza ngokuzenzekelayo kwiphepha lokusebenzela , kwaye nganye iyachongwa yileta kwintloko yentloko.
Ibha yefomula
- Ekho ngaphaya kwiphepha lokusebenzela, le ndawo ibonisa iziqulatho zeseli esebenzayo. Ibha yefomula ingasetyenziselwa ukungena okanye ukuhlela idatha kunye namafomula .
Igama leBhokisi
- Ifakwe ecaleni kweruba yefomula, Ibhokisi legama libonisa iselferensi yeseli okanye igama leseli esebenzayo.
Ibha yamathuluzi okuFikelela
- Ibha yecandelo lokufikelela ngokukhawuleza likuvumela ukuba ungeze imiyalelo esetyenziswa rhoqo. Cofa kwinqolo engezantsi ekupheleni kwebar yebar yokubonisa iinketho ezikhoyo.
IRibhoni
- I- Ribbon yimiqulu yeeqhosha kunye neefayile ezikufuphi kwiphepha lokusebenzela. Xa uqakraza, ezi ziqhosha kunye neempawu zenza iinkqubo ezahlukeneyo zenkqubo. Eyokuqala evezwe kwi-Excel 2007, i-ribbon ithathe indawo yamagama kunye neetrabars ezifunyenwe kwi-Excel 2003 kunye neenguqulelo zangaphambili.
Iibhubhu zeRibhoni
- Iibhubhu zebhanki ziyinxalenye yemenyu yeebhondi ephezulu eneekhonkco kwiinkalo ezahlukeneyo zeprogram. Nganye itek-njenge- Home , Layout Page , kunye neFomula- iqulethe iinkalo ezinxulumene kunye neenketho ezicwangcisiweyo ngokuchofoza kwi icon efanelekileyo.
Ifayile yefayile
- Ithebhu yefayile yafakwa kwi-Excel 2010, ithatha indawo ye-Button ye-Excel 2007, kwaye isebenza ngokuhlukileyo kunezinye iithebhu. Esikhundleni sokuba neendlela ezikhethiweyo zibonise kwi-Ribbon eneqhosha, ukucofa kwiTebhu yefayile ivula imenyu ehlayo kwicala lasekhohlo kwesikrini.
- Le tbhu iqulethe izinto ezinxulumene kakhulu nefayile kunye nokuphathwa koxwebhu, njengokuvula iifayile ezintsha okanye ezikhoyo zefayile, ukugcina nokushicilela.
- Into ekhethiweyo, ekhoyo kwakhona kwimenyu, isetyenziselwa ukuguqula ukubonakala kweprogram ngokubanzi ngokukhetha izixhobo zesikrini ezizobonisa, njengemivalo yokuprola kunye neefowuni zegridi. Iqulethe iinketho zokwenza iisethingi ezininzi ziququzelelwe ngokuzenzekelayo iifayile zefayile kunye nokukhetha ukuba zeziphi iilwimi ozisebenzisayo ukukhangela upelo kunye negrama.
Inani leeNombolo
- Iimilo zihamba ngokulandelelana kwiphepha lokusebenzela kwaye zichongwa ngenombolo kumqolo ophezulu .
Iithebhu zeShedyuli
- Ngokungagqibekanga, kukho enye iphetshana lokusebenzela kwifayile ye-Excel 2013, kodwa unokongeza amaphepha amaphepha. Ithebhu yephepha lezantsi kwiphepha lokusebenzela lixelela igama lephepha lokusebenzela, njengeSheet1 okanye i- Sheet2 .
- Ukuqamba kabusha iphepha lokusebenzela okanye ukutshintsha umbala wethebhu kunokukwenza kube lula ukulandelela idatha kwiifayile ezinkulu zespredishithi.
- Ukutshintsha phakathi kwamaphepha okusebenzela kunokukwenziwa ngokuchofoza kwithebhu lephepha ofuna ukuyifumana. (Ungatshintsha kwakhona phakathi kwamaphepha okusebenzela kunye nekhefu yebhodi yebhodi yokutshintsha phakathi kwamaphepha eemisebenzi : Ctrl + PgUp kunye neCtrl + PgDn.)
Ibha yomgangatho
- I- Bar Status , ehamba ngokubanzi ngaphantsi kwesikrini, inokwenziwa ngokweenkcukacha ukubonisa inani lezinketho, ininzi zazo ezinika ulwazi lomsebenzisi malunga nephepha lokusebenzela, idatha yephepha lokusebenzela eliqulethe, kunye nekhibhodi yomsebenzisi kuquka nokuba iCaps Lock , Scroll Lock , kunye neNow Lock iqhosha livulwe okanye livaliwe.
- Ibha yomgangatho iqulethe i- Zoom slider , evumela abasebenzisi ukuba batshintshe ukukhuliswa kwephepha lokusebenzela.
Sowder Slider
- Kukho kwinqakra engezantsi yekhompyutheni ye-Excel, islayidi yeSowom isetyenziselwa ukutshintsha ukuphakanyiswa kwephepha lokusebenzela xa udonsa ibhokisi yesilayidi ngaphaya nangaphandle okanye nqakraza kwi- Zoom Out kunye ne- Zoom In ezinkinobho ezisekupheleni kwesilayidi.
Iinguqulelo zangaphambili ze-Excel
Ukuba awusebenzisi i-Excel 2013, enye yala manqaku ingaba nolwazi olufunayo.