Abantu abaninzi bakholelwa ukuba baziphethe kakuhle zonke iimfihlo ze Excel, inkqubo ye-spreadsheet ye-Ofisi ye-Microsoft eyaziwayo, kodwa abaqapheli amaqhinga anomdla. Enye yazo yile siza kugqabaza ngayo kwaye sichaze kolu ngeniso: ubala njani iiseli ezinombhalo kwi-excel.
Ukuba ungomnye waba basebenzisi, le nto sikuxelela yona kwimihlathi elandelayo iya kuba nomdla kuwe. Kuba, nangona i-Excel inokusongamela ngeefomula ezininzi kunye nokhetho olukhoyo, inyani kukuba sakuba sifunde ukuyisebenzisa, iba sesinye sezona zixhobo zethu zibalaseleyo.
Umxholo weeseli kwi-Excel spreadsheets unokwahluka kakhulu. Ngokuqhelekileyo, la ngamaxabiso amanani, kodwa anokuqulatha iifomula kunye nemisebenzi, kunye nemifanekiso, amakhonkco, kunye izicatshulwa zeentlobo ezahlukeneyo (amanqaku, amagqabantshintshi, njl.njl.).
Yintoni injongo yokubala iiseli ezinesicatshulwa kwiMicrosoft Excel?
Nangona ekuqaleni lo msebenzi unokubonakala ungaphezulu, inyaniso kukuba unokuba luncedo kuthi. kwimisebenzi emininzi kunye neenjongo. Olu luluhlu oluncinci lwabo:
- Uhlalutyo lwedatha, ihlanganiswe kulwazi oluqulethwe kwiiseli ezikwimo yokubhaliweyo.
- Ukuhlela kunye nokwahlulahlula, ukwenza amaqela iiseli kunye nokudala iindidi ngokusekelwe kuhlobo lomxholo obonakaliswe kumbhalo.
- Ulawulo lwempahla, xa isicatshulwa sibhekisa kwiinkcazo zemveliso kunye nokunye.
- Ukulandela impendulo yefomu.
- Ukuqinisekiswa kwedatha, ukuchonga iiseli ezifanele ukuba namanani endaweni yokubhaliweyo, umzekelo.
Isishwankathelo, kunokuthiwa ukubala iiseli ezinombhalo kwi-Excel ngumthombo esinokuwusebenzisa umbutho ochanekileyo wolwazi. Esinye isixhobo se Fumana okuninzi kwisixhobo se-spreadsheet sikaMicrosoft.
Umsebenzisi uneendlela ezininzi zokubala iiseli ezinombhalo kwi-Excel. Eyona nto isebenzayo kunye nobukrelekrele kukusebenzisa ifomula ukufezekisa loo njongo. Kwaye sele sisazi ukuba kwi-Excel banokuqwalaselwa iifomula okanye imisebenzi phantse nantoni na ofuna ukuyizuza. Makhe sibone ukuba zeziphi esinokuzisebenzisa:
COUNTIF umsebenzi
Lo ngumsebenzi phantse wonke umntu owusebenzisayo ukubala iiseli ezinombhalo kwi-Excel. Ikhethwa ngabo basebenzisa inkqubo ngokuphindaphindiweyo, ngenxa yokulula kunye nokusebenza kwayo. I COUNTIF umsebenzi Ingasetyenziselwa iinjongo ezininzi, njengoko yenzelwe ukubala iiseli ezihlangabezana nemilinganiselo ethile. Kwimeko ekhoyo, nantsi indlela esinokuyisebenzisa ngayo:
Ukuba sifuna ukubala iiseli ezinombhalo kuluhlu oluthile (umzekelo, ikholamu A, ukusuka kwiseli A1 ukuya kwiseli A10), kufuneka sibhale le fomula ilandelayo:
=COUNTIF(A1:A10, «*»).
Kwisithuba apho sibeke khona i-asterisk iya igama okanye itekisi ekufuneka ifakwe kwiseli ukuba ibalwe. Umzekelo, ukubala iiseli ngaphakathi koluhlu lwe-A1: A10 apho igama elithi "intengiso" livela khona, siya kulibhala ngokucaphula kwindawo apho i-asterisk ihamba khona.
COUNTA umsebenzi
Enye ifomyula eya kusinceda ukubala iiseli ezinesicatshulwa kwi-Excel yile COUNT umsebenzi. Enkosi kuye, siya kukwazi Khangela kwaye ubale zonke iiseli kuluhlu olunikiweyo olungenanto. Oko kukuthi, apho kukho naluphi na uhlobo lomxholo, nokuba umbhalo, inombolo okanye nayiphi na enye idatha.
Ukusebenzisa uluhlu olufanayo njengakumzekelo wangaphambili, ukulusebenzisa kuya kufuneka singenise le fomula ilandelayo:
=COUNT (A1:A10)
Kwimeko sebenza ngemithamo emikhulu yedatha, ukuchaneka ngakumbi kumsebenzi wethu wokubala iiseli ezinombhalo, kufanelekile ukusebenzisa uhlobo oluthile lwe umsebenzi odibeneyo. Iingcali ze-Excel ziyayazi indlela yokwenza. Kubantu abatsha, sincoma ukufunda iposi yethu yangaphambili Uwusebenzisa njani umsebenzi we-IF kwi-Excel.
Hluza okubhaliweyo kwi-Excel
Okokugqibela, sibonisa esinye isixhobo esinokusisebenzisa ukubala iiseli ezinombhalo kwi-Excel: i ukuhluzwa kweeseli. Kule meko, akusiyo ifomula okanye umsebenzi njengoko sibonile ukuza kuthi ga ngoku. Inyaniso yeyokuba liqhinga elilula ngakumbi, ngakumbi kwabo basebenzisi babhidekileyo xa befaka iifomyula kwaye bafuna isibonelelo esifikelelekayo. Nantsi into omawuyenze:
- Okokuqala, kuya kufuneka Khetha ngemouse ikholamu, umqolo okanye iiseli ofuna ukuzihluza.
- Nje ukuba iiseli zikhethiwe, siya kwi-aphoyintimenti yesixhobo kwaye nqakraza kwithebhu "Idatha".
- Emva koko sikhetha ukhetho "Icebo lokucoca ulwelo".
- Okulandelayo, sikhetha "Izihluzi zesicatshulwa".
- Apho sikhetha "Iqulethe" okanye "Ayiqulathanga", kuxhomekeke kwinjongo yethu.
- Ekugqibeleni, sicinezela iqhosha "Faka isicelo".
Emva kokufaka isihluzo, kuphela ezo seli ziqulethe okubhaliweyo okanye ezingezizo eziya kubonakala kuxwebhu, kuxhomekeke kukhetho lwethu lwangaphambili. Njengoko ubona, yindlela elula kakhulu yokufezekisa into efanayo: bala iiseli ezinombhalo kwi-Excel.