Ngenkathi usebenza eMicrosoft Excel, uvame ukudiliza isamba kukholamu nemigqeni yamatafula, futhi futhi umane unqume isamba sobubanzi beseli. Uhlelo luhlinzeka ngamathuluzi ambalwa ukuxazulula le nkinga. Ake sibheke ukuthi angalinganisa kanjani amaseli ku-Excel.
I-AutoSum
Ithuluzi elidume kakhulu nelisebenziseka kalula ekunqumeni inani ledatha kumaseli eMicrosoft Excel yi-avtosum.
Ukuze ukubala inani ngale ndlela, chofoza iseli lokugcina elingenalutho lekholamu noma umugqa, bese kuthi, kuthebhu "Ikhaya", chofoza inkinobho "AutoSum".
Uhlelo lukhombisa ifomula esitokisini.
Ukuze ubone umphumela, kufanele ucindezele inkinobho ethi Faka ku-keyboard.
Kungenziwa ngokuhlukile. Uma sifuna ukwengeza amaseli hhayi wonke umugqa noma ikholomu, kodwa kuphela ebangeni elithile, bese ukhetha lobu bubanzi. Ngemuva kwalokho sichofoza inkinobho "Autosum" eseyivele isijwayele.
Umphumela uboniswa esikrinini.
Okubi kakhulu ekubaleni ngosizo lwe-auto-sum ukuthi ikuvumela ukubala uchungechunge olulandelanayo lwemininingwane etholakala kumugqa owodwa noma kukholomu. Kepha iqoqo ledatha etholakala kumakholomu ambalwa nemigqa ayikwazi ukubalwa ngale ndlela. Ngaphezu kwalokho, ngosizo lwayo akunakwenzeka ukubala isamba samaseli ambalwa kude nomunye.
Isibonelo, sikhetha ibanga lamaseli, bese sichofoza inkinobho "AutoSum".
Kepha hhayi isamba sawo wonke la maseli akhonjiswa esikrinini, kepha inani lemali ngayinye noma umugqa ngokuhlukile.
Umsebenzi we-SUM
Ukuze ubuke isamba sonke samalungu afanayo, noma imininingwane eminingana yedatha, umsebenzi we- "SUM" ukhona kwiMicrosoft Excel.
Khetha iseli lapho sifuna inani likhonjiswe khona. Chofoza inkinobho ethi "Faka Umsebenzi" etholakala kwesokunxele sebha lefomula.
Iwindi le-Function Wizard liyavula. Uhlu lwemisebenzi sifuna umsebenzi "SUM". Khetha lona, bese uchofoza inkinobho "Kulungile".
Ewindini elivuliwe lokuphikisana komsebenzi, faka izixhumanisi zamaseli, isamba esizokubala. Kuyiqiniso, ukufaka ngesandla izixhumanisi kungenamikhawulo, ngakho-ke chofoza inkinobho ebekwe ngakwesokunene senkambu yokufaka idatha.
Ngemuva kwalokho, iwindi lokuphikisana komsebenzi lincishisiwe, futhi singakwazi ukukhetha lawo maseli noma uhlu lwamaseli esilinganiso salo samanani esifuna ukubala. Ngemuva kokuthi uhlu olukhethiwe selukhethiwe, futhi ikheli lalo livela emkhakheni okhethekile, chofoza inkinobho ngakwesokudla kwale nkambu.
Siphinde sibuyele ewindini lokuphikisana lomsebenzi. Uma udinga ukwengeza enye iqoqo ledatha enanini eliphelele, khona-ke siphinda isenzo esifanayo esishiwo ngenhla, kodwa kuphela endimeni enophawu "Inombolo 2". Uma kunesidingo, ngale ndlela ungafaka amakheli wenombolo ecishe ibe nomkhawulo yokuhlelwa. Ngemuva kokuthi zonke izingxabano zomsebenzi zifakiwe, chofoza inkinobho "Kulungile".
Ngemuva kwalokho, esitokisini lapho sibeke khona ukuphuma kwemiphumela, inani ledatha lawo wonke amaseli akhonjisiwe azoboniswa.
Kusetshenziswa ifomula
Inani ledatha kumaseli eMicrosoft Excel nayo ingabalwa kusetshenziswa ifomula yokuhlanganisa elula. Ukuze wenze lokhu, khetha iseli lapho inani kufanele litholakale khona, bese ufaka uphawu "=" kulo. Ngemuva kwalokho, sichofoza kuseli ngayinye, eyodwa yalezo okudingeka ubale kuzo amanani. Ngemuva kokuthi ikheli leseli lifakiwe kubha yefomula, faka uphawu "+" olusuka kwikhibhodi, bese ungena ngemuva kokufaka izixhumanisi zeseli ngalinye.
Lapho amakheli awo wonke amaseli efakiwe, cindezela inkinobho ethi Enter kwikhibhodi. Ngemuva kwalokho, inani lemininingwane efakiwe liboniswa kuseli ekhonjisiwe.
Okubi kakhulu ngale ndlela ukuthi ikheli leseli ngalinye kufanele lifakwe ngokuhlukile, futhi ngeke ukwazi ukukhetha uhla lwamaseli wonke ngokushesha.
Bheka amanani kuMicrosoft Excel
Futhi, kuMicrosoft Excel, ungabuka isamba samaseli akhethiwe ngaphandle kokubonisa leli nani kuseli elihlukile. Isimo kuphela ukuthi wonke amaseli, inani lazo okufanele libalwe, kumele abe eduzane, ngokulandelana okukodwa.
Vele ukhethe uhla lwamaseli, inani ledatha okudingeka uluthole, bese ubheka umphumela kubha yesimo ye-Microsoft Excel.
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokufingqa idatha ku-Microsoft Excel. Enye yalezi zindlela inezinga layo lokuxaka nokuguquguquka. Njengomthetho, okulula ukukhetha, okungaguquki kalula. Isibonelo, lapho unquma inani usebenzisa amathothali we-auto, ungasebenza kuphela kudatha ehlelwe ngokulandelana. Ngakho-ke, esimweni ngasinye esithile, umsebenzisi kufanele anqume ukuthi iyiphi indlela efanelekile.
