Iseli ku-Excel iyingxenye yesakhiwo eyinhloko yeshidi lapho ungafaka khona idatha nokunye okuqukethwe. Kulesi sifundo, sizofunda izisekelo zokusebenza ngamaseli nokuqukethwe kwawo ukuze senze izibalo, sihlaziye futhi sihlele idatha ku-Excel.
Ukuqonda Amaseli ku-Excel
Ishidi ngalinye ku-Excel lakhiwe izinkulungwane zonxande ababizwa ngamaseli. Iseli iyisiphambano somugqa nekholomu. Amakholomu ku-Excel achazwa ngezinhlamvu (A, B, C), kuyilapho imigqa ichazwa ngezinombolo (1, 2, 3).
Ngokusekelwe kumugqa nekholomu, iseli ngalinye ku-Excel linikezwa igama, elaziwa nangokuthi ikheli. Isibonelo, i-C5 iseli elisempambanweni yekholomu C nomugqa wesi-5. Uma ukhetha iseli, ikheli layo livezwa endaweni ethi Igama. Sicela uqaphele ukuthi uma iseli likhethiwe, izihloko zomugqa nekholomu ezimpambanweni zomgwaqo lapho etholakala khona ziyagqanyiswa.
I-Microsoft Office Excel inamandla okukhetha amaseli amaningi ngesikhathi esisodwa. Isethi yamaseli amabili noma ngaphezulu ibizwa ngokuthi ububanzi. Noma yibuphi ububanzi, njengeseli, linekheli lalo. Ezimweni eziningi, ikheli lobubanzi liqukethe ikheli lamaseli aphezulu kwesokunxele naphansi kwesokudla, ahlukaniswe ikholoni. Ububanzi obunjalo bubizwa ngokuthi i-cotiguous noma eqhubekayo. Isibonelo, ububanzi obuqukethe amaseli B1, B2, B3, B4, kanye ne-B5 bungabhalwa ngokuthi B1:B5.
Umfanekiso ongezansi ugqamisa izigaba ezimbili ezihlukene zamaseli:
- Ibanga A1:A8
- Ibanga A1:B8
Uma amakholomu ekhasini lokusebenzela emelwe izinombolo esikhundleni sezinhlamvu, udinga ukushintsha isitayela sokuxhuma esimisiwe ku-Excel. Ukuze uthole imininingwane, bheka isifundo: Siyini isitayela sezixhumanisi ku-Excel.
Khetha amaseli ku-Excel
Ukufaka idatha noma ukuhlela okuqukethwe kweseli, kufanele uqale uyikhethe.
- Chofoza iseli ukuze uyikhethe.
- Iseli elikhethiwe lizofakwa umngcele futhi ikholomu nezihloko zomugqa zizogqanyiswa. Iseli lizohlala likhethiwe uze ukhethe noma iyiphi enye iseli.
Ungaphinda ukhethe amaseli usebenzisa okhiye bemicibisholo kukhibhodi yakho (okhiye bemicibisholo).
Khetha ibanga lamaseli ku-Excel
Lapho usebenza ne-Excel, ngokuvamile kuyadingeka ukukhetha iqembu elikhulu lamaseli noma ububanzi.
- Chofoza iseli yokuqala kububanzi futhi, ngaphandle kokukhulula inkinobho, hambisa igundane kuze kukhethwe wonke amaseli aseduze ofuna ukuwakhetha.
- Khipha inkinobho yegundane, ububanzi obudingekayo buzokhethwa. Amaseli azohlala ekhethiwe uze ukhethe noma iyiphi enye iseli.