01 ka 05
Mayelana nama-Worksheets afihliwe e-Excel
Iphepha lokusebenzela lase-Excel liyispredishithi elilodwa eliqukethe amaseli. Iseli ngayinye lingabamba umbhalo, inombolo, noma ifomula, futhi iseli ngalinye lingabhekisela esitokisini esithile kuphepha elifanayo lomsebenzi, ibhuku elifanayo noma incwadi ehlukile.
Incwadi ye-Excel iqukethe ama-sheet one noma ngaphezulu. Ngokuzenzakalelayo, zonke izincwadi ezivulekile ze-Excel zibonisa amathebhu womsebenzi kubha yomsebenzi ngezansi kwesikrini, kodwa ungafihla noma ubonise njengoba kudingeka. Okungenani ishidi lokusebenzela elilodwa kumele libonakale ngaso sonke isikhathi.
Kunendlela engaphezu kweyodwa yokufihla nokudibanisa ama-worksheets e-Excel. Ungakwazi:
- Sebenzisa imenyu ye-contextual imenyu yokuchofoza ngakwesokudla.
- Sebenzisa okukhethwa kukho kwefomathi kuthebhu yaseKhaya yebhande .
Ukusetshenziswa kwedatha kumaHebhu Okusebenza Okufihliwe
Idatha etholakala kumashidi okusebenza afihliwe ayisusiwe, futhi ingabhekiswa emafomulini namashadi akhiwe kwamanye ama-worksheets noma ezinye izincwadi zokusebenza .
Amafomu efihliwe aqukethe izigcawu zeselula avuselela uma idatha kumaseli ahlongoziwe ishintsha.
02 ka 05
Fihla i-Excel Worksheet usebenzisa iMenyu eyi-Context
Izinketho ezitholakalayo kwimenyu yenkambiso-noma imenyu yokuchofoza ngakwesokudla-shintsha kuye ngokuthi into ekhethiwe uma imenyu ivuliwe.
Uma inketho yokufihla ingasebenzi noma igxiliwe, cishe cishe ibhuku lamanje linomsebenzi owodwa kuphela wokusebenzela. I-Excel icala inketho yokufihla ngezincwadi zokusebenzela ezikodwa ngoba kuzomele kube khona njalo okungenani eyodwa ishidi lokusebenzela elibonakalayo encwadini yokusebenzela.
Ukufihla ishidi elilodwa lokusebenzela
- Chofoza kuthebhu yephepha lokusebenzela leshidi ukuze lifihlwe ukulikhetha.
- Chofoza ngakwesokudla kuthebhu yokusebenzela ukuze uvule imenyu yangokomongo.
- Ku imenyu, chofoza inketho ye Fihla ukufihla ishidi lokusebenzela elikhethiwe.
Ukufihla Ama-Worksheets amaningi
- Chofoza kuthebhu yephepha lokuqala lokusebenzela ukuze lifihle ukulikhetha.
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Chofoza kumathebhu ezengeziwe zamakhasi ukuze uzikhethe.
- Chofoza ngakwesokudla kuthebhu eyodwa yokusebenzela ukuze uvule imenyu yangokomongo.
- Ku imenyu, chofoza inketho yokufihla ukufihla wonke amafomethi okusebenza akhethiwe.
03 ka 05
Fihla Ama-Worksheet Ukusebenzisa iRibhoni
I-Excel ayinayo isinqamuleli sekhibhodi sokufihla amaphepha okusebenzela, kodwa ungasebenzisa i-riboni ukwenza umsebenzi.
- Khetha ithebhu yomsebenzi wezansi phansi kwefayela le-Excel.
- Chofoza ithebhu yasekhaya ekhabheni bese ukhetha isithonjana sezinhlamvu .
- Khetha Ifomethi emenyu ehlayo evelayo.
- Chofoza ukufihla nokudibanisa .
- Khetha Fihla Ishidi .
04 ka 05
Hlanganisa i-Excel Worksheet usebenzisa iMenyu eyi-Context
Izinketho ezitholakalayo kwimenyu yenkambiso-noma imenyu yokuchofoza ngakwesokudla-shintsha kuye ngokuthi into ekhethiwe uma imenyu ivuliwe.
Ukuxhumanisa i-Single Worksheet
- Chofoza ngakwesokudla kuthebhu yokusebenzela ukuze uvule ibhokisi lengxoxo elingavumelekile, elibonisa wonke amashidi afihliwe njengamanje.
- Chofoza kushidi ukuze ungene.
- Chofoza u- KULUNGILE ukuze uhlanganise ishidi elikhethiwe bese uvala ibhokisi lengxoxo.
05 ka 05
Hlanganisa ishidi lomsebenzi usebenzisa i-Ribbon
Njengokufihla amafomu okusebenza, i-Excel ayinayo isinqamuleli sekhibhodi sokukhipha ishidi lokusebenzela, kodwa ungasebenzisa i-riboni ukuze uthole futhi uhlanganise amashidi okusebenza afihlekile.
- Khetha ithebhu yomsebenzi wezansi phansi kwefayela le-Excel.
- Chofoza ithebhu yasekhaya ekhabheni bese ukhetha isithonjana sezinhlamvu .
- Khetha Ifomethi emenyu ehlayo evelayo.
- Chofoza ukufihla nokudibanisa .
- Khetha ishidi elingenamkhawulo .
- Buka uhlu lwamafayela afihliwe avela. Chofoza efayeleni ofuna ukuyihlanganisa.
- Chofoza OK .