01 ngo-02
I-OpenOffice Calc Umsebenzi we-SUM
Ukwengeza imigqa noma izinsika zezinombolo kungenye yezinto ezivame kakhulu ezenziwa ezinhlelweni zespredishithi njenge-OpenOffice Calc. Ukwenza kube lula ukufeza lo msebenzi, i-Calc ihlanganisa eyakhelwe kufomula okuthiwa umsebenzi we-SUM.
Izindlela ezimbili zokungena kulo msebenzi zihlanganisa:
- Ukusebenzisa inkinobho yezinqamuleli zomsebenzi we-SUM - yileligama elikhulu lesiGreki elithi Sigma (Σ) eliseduze nomugqa wokufaka (njengendlela ye- formula bar ku-Excel).
- Ukwengeza umsebenzi we-SUM kushidi lokusebenzela usebenzisa ibhokisi lebhokisi lengxoxo lewindi. Ibhokisi lengxoxo lingavulwa ngokuchofoza inkinobho ye- Function Wizard eseduze nenkinobho yeSigma emgqeni wokufaka .
Izinqamuleli zebhokisi lokunciphisa kanye nebhokisi lezingxoxo
Inzuzo yokusebenzisa inkinobho ye-Sigma ukungena emsebenzini yukuthi kuyashesha futhi kulula ukuyisebenzisa. Uma idatha ifingqa ihlelwe ndawonye ebangeni elixubile umsebenzi uzovame ukukhetha ububanzi kuwe.
Inzuzo yokusebenzisa ibhokisi lebhokisi lengxoxo ye-SUM uma idatha ifingqa isakazwa phezu kwamanani amangqamuzana angenayo. Ukusebenzisa ibhokisi lengxoxo kule simo kwenza kube lula ukwengeza amaseli ngabanye emsebenzini.
I-Syntax ye-Function ne-Arguments ye-SUM
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-SUM yilezi:
= I-NUM (inombolo 1; inombolo yesibili; ... inombolo 30)
inombolo 1; inombolo 2; ... inombolo 30 - idatha okufanele ifingqwe umsebenzi. Izingxabano zingaqukatha:
- uhlu lwezinombolo okufanele zifingqwe
- uhlu lwezingqikithi zeseli ezibonisa indawo yedatha kushidi lokusebenzela
- ububanzi bezinombolo zocingo endaweni yedatha
Qaphela : inani eliphezulu lezinombolo ezingu-30 linganezelwa ngomsebenzi.
Okushiwo umsebenzi we-SUM
Lo msebenzi ulahla amaseli angenalutho kanye nedatha yombhalo ebangeni elikhethiwe - kufaka phakathi izinombolo ezifakwe njengombhalo.
Ngokuzenzakalelayo, idatha yombhalo ku-Calc ishiyelwe ekhoneni - njengoba kuboniswe nenombolo 160 eselifini A2 esithombeni ngenhla - idatha yedatha ihambelana ngakwesokudla ngokuzenzakalelayo.
Uma idatha yombhalo enjalo iguqulwa ngokuhamba kwesikhathi ukuze inomboro yedatha noma izinombolo zengeziwe kumangqamuzana angenalutho ebangeni, umsebenzi we-SUM uhlaziywe ngokuzenzakalelayo ngokuzenzakalelayo ukufaka idatha entsha.
Ukufaka ngesandla ngomsebenzi we-SUM
Kodwa enye indlela yokufaka lo msebenzi ukuwufakela kwisitoreji somsebenzi. Uma izingcaphuno zeseli zohlu lwemininingwane ukuze zifinyezwe ziyaziwa, umsebenzi ungafakwa kalula ngesandla. Ngomfanekiso esithombeni ngenhla, ukuthayipha
= SUM (A1: A6)
zibe esitokisini A7 futhi ucindezela ukhiye wokungena kwikhibhodi uzothola umphumela ofanayo nezinyathelo ezibalulwe ngezansi ukuze usebenzise inkinobho yokunciphisa i-SUM.
Idatha yokwethula nge-Button SUM
Kulabo abakhetha igundane kukhibhodi, inkinobho ye-SUM iyindlela elula futhi elula yokufaka umsebenzi we-SUM.
Uma ufakwe kule fomethi, umsebenzi uzama ukunquma ububanzi bamaseli ukuthi afingqwe ngokusekelwe kwedatha ezungezile futhi ngokuzenzakalelayo ufaka ububanzi obungenzeka kakhulu njengengxabano yenombolo yomsebenzi.
Umsebenzi ucinga kuphela idatha yedatha ekhoneni eliphezulu noma emigqeni ngakwesokunxele kweseli esebenzayo futhi iyayinaki idatha yombhalo namaseli angenalutho.
Ngezansi kubalwa izinyathelo ezisetshenziselwa ukungena umsebenzi we-SUM esitokisini A7 njengoba kuboniswe esithombeni ngenhla.
- Chofoza kuseli A7 ukwenza kube iseli elisebenzayo - indawo lapho imiphumela yomsebenzi izoboniswa khona
- Cindezela inkinobho ye-SUM eceleni komugqa wokufaka - njengoba kuboniswe esithombeni ngenhla
- Umsebenzi we-SUM kufanele ungene esitokisini esisebenzayo - umsebenzi kufanele ufake ngokuzenzekelayo ireferensi yeseli ye-A6 njengengxabano yenombolo
- Ukuze ushintshe ububanzi bezingqikithi zeseli ezisetshenziselwa ukuphikisana kwenombolo , sebenzisa i-pointer yegundane ukugqamisa ububanzi be-A1 kuya ku-A6
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi
- Impendulo 417 kufanele iboniswe esitokisini A7
- Uma uchofoza ku-cell A7, umsebenzi ophelele = i-SUM (A1: A6) ivela emgqeni wokufaka ngaphezulu kwephepha lokusebenzela
02 ka 02
Engeza Izinombolo Ukusebenzisa Ibhokisi leDiski lokuSebenza le-SUM le-Calc
Idatha yokubamba ngebhokisi le-Function ye-SUM
Njengoba kukhonjisiwe, enye indlela yokufaka umsebenzi we-SUM ukusebenzisa ibhokisi lengxoxo lomsebenzi, elingavulwa noma:
- ngokuchofoza inkinobho ye- Function Wizard emgqeni wokufaka ngaphezulu kwephepha lokusebenzela.
- ucindezela okhiye be-Ctrl + F2 ekhibhodi
Ibhokisi lezingxoxo ze-Dialog
Izinzuzo zokusebenzisa ibhokisi lengxoxo zihlanganisa:
- Ibhokisi lebhokisi lizinakekela i-syntax yomsebenzi - okwenza kube lula ukufaka izingxabano zomsebenzi ngesikhathi esisodwa ngaphandle kokufaka uphawu olulinganayo, amabakaki, noma ama-semicolons enza njengabahlukanisi phakathi kwezimpikiswano.
- Uma idatha isingeniswe ayikho ebangeni elihle, izingqikithi zeseli, ezifana ne-A1, A3, ne-B2: B3 zingangena kalula njengezingqinamba zenombolo ezihlukene ebhokisini lebhokisi ngokukhomba - okubandakanya ukuchofoza amaseli akhethiwe igundane kunokuba uthayiphe kuyo. Akusikho kuphela okukhomba ukuthi kulula, futhi kusiza ukunciphisa amaphutha amafomula abangelwa amareferensi angalungile.
Isibonelo somsebenzi we-SUM
Ngezansi kubalwa izinyathelo ezisetshenziselwa ukungena umsebenzi we-SUM esitokisini A7 njengoba kuboniswe esithombeni ngenhla. Imiyalo isebenzisa ibhokisi lokusebenza lomsebenzi we-SUM ukuze ufake amanani afakwe kumaseli A1, A3, A6, B2, ne-B3 njengama-arguments wenombolo yomsebenzi.
- Chofoza kuseli A7 ukwenza kube iseli elisebenzayo - indawo lapho imiphumela yomsebenzi izoboniswa khona
- Chofoza kusithonjana se- Function Wizard eduze komugqa wokufaka (kufana ne-bar yefomula ku-Excel) ukuletha ibhokisi lengxoxo ye-Function Wizard
- Chofoza kuhlu lokwehliswa kwesigaba bese ukhetha iMathematika ukubona uhlu lwezibalo zemisebenzi
- Khetha i-SUM ohlwini lwemisebenzi
- Chofoza Okulandelayo
- Chofoza inombolo 1 ebhokisini lengxoxo uma kunesidingo
- Chofoza ku-cell A1 kushidi lokusebenzela ukuze ufake leyo reference reference ebhokisini lengxoxo
- Chofoza kunomboro 2 ebhokisini lengxoxo
- Chofoza kuseli le-A3 kusikripthi sokusebenzela ukuze ufake leyo reference reference
- Chofoza kunombolo 3 ebhokisini lengxoxo
- Chofoza kuseli le-A6 kusikripthi sokusebenza ukuze ufake leyo reference reference
- Chofoza kunombolo 4 ebhokisini lengxoxo
- Gqamisa amaseli B2: B3 kushidi lokufaka ukungena kuleli banga
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
- Inombolo 695 kufanele ibonakale esitokisini A7 - njengoba lokhu kungumumo wezinombolo ezikhona kumaseli A1 kuya ku-B3
- Uma uchofoza ku-cell A7 umsebenzi ophelele = SUM (A1; A3; A6; B2: B3) ivela emgqeni wokufaka ngenhla kwephepha lokusebenzela