Indlela yokongeza iikholam okanye iiNombolo zeNombolo kwi-Open Office Calc

01 ka 02

I-OpenOffice Calc Umsebenzi we-SUM

Idatha yeSomming usebenzisa i-Button SUM. © Ted French

Ukongeza imigqa okanye iikholomu zamanani enye yezona zinto ziqhelekileyo ezenziwa kwiiprogram ze- spreadsheet njenge-OpenOffice Calc. Ukwenza kube lula ukufezekisa lo msebenzi, iCalc iquka eyakhelwe kwifomula ebizwa ngokuba ngumsebenzi we- SUM.

Izindlela ezimbini zokungena kulo msebenzi ziquka:

  1. Ukusebenzisa inkinobho yokunquma komsebenzi we-SUM - yileta yesiGrike yeGermma (Σ) esekelwe kwicala lokufakelwa (njengendlela ye-bar bar e-Excel).
  2. Ukongeza umsebenzi we-SUM kwiphepha lokusebenzela usebenzisa ibhokisi yencoko yababini bhokisi. Ibhokisi yencoko ingavulwa ngokuchofoza kwiqhosha leWeb Wizard elikufutshane neqhosha lase Sigma kumgca wokufaka .

Iqhosha leNgcaciso kunye neeNobhokisi zeNguqulo

Inzuzo yokusebenzisa iqhosha le-Sigma ukungena emsebenzini kukuba likhawuleza kwaye lilula ukuyisebenzisa. Ukuba idatha iya kubalwa iqokelelwe ndawonye kwinqanaba elithintekayo umsebenzi uya kufuthi ukhethe uluhlu.

Ubuncedo bokusebenzisa ibhokisi yencoko yebhokisi ye-SUM kukuba idilesi ekufuneka idibeneyo isasazeka phezu kweenombolo ezingezizo. Ukusebenzisa ibhokisi yencoko kule meko yenza kube lula ukufaka iiseli ngamnye kumsebenzi.

I-Syntax yeMisebenzi kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-SUM ngu:

= ISUM (inombolo 1; inombolo 2; ... inombolo 30)

inombolo 1; inombolo 2; ... inombolo ye-30 - idatha ukuba igxininiswe ngumsebenzi. Iingxoxo zingabandakanya:

Qaphela : ubuninzi beenombolo ezingama-30 zingongezwa ngumsebenzi.

Oko umsebenzi we-SUM ungabikho

Umsebenzi uyazilahla iiseli ezingenanto kunye nedatha yombhalo kwibala elikhethiweyo - kubandakanywa namanani afomathiweyo njengombhalo.

Ngokungagqibekanga, idatha yombhalo kwiCalc ishiywe ihambelaniswe kwiseli - njengoko iboniswe nenombolo 160 kwi-A2 yeseli kumfanekiso ongentla - idatha yeenombolo ihambelana ngakwesokudla ngokungafi.

Ukuba loo datha yombhalo iguqulwa emva koko ukuba ibale idatha okanye amanani ayongezwa kwii-cells ezingenanto kwibala, umsebenzi we-SUM uhlaziyo oluzenzekelayo ngokuzenzekelayo ukufaka idatha entsha.

Ukufaka ngokuzenzekelayo Umsebenzi we-SUM

Kanti enye inketho yokungena kumsebenzi ukuwufakela kwiseli yomsebenzi. Ukuba iinkcazo zeeseli zoluhlu lweenkcukacha ziza kubalwa, umsebenzi ungangena ngokuzenzekelayo ngesandla. Ngomzekelo kumfanekiso ongentla, ukuthayipha

= I-SUM (A1: A6)

kwifowuni ye-A7 kwaye ucinezela ukhiye wokungena kwikhibhodi uza kufumana umphumo ofanayo kunye namanyathelo alulwe apha ngezantsi ukusebenzisa inkinobho yokunciphisa i-SUM.

Idatha yeSomming nge-Button SUM

Kulabo abakhetha imouse kwibhodibhodi, iqhosha le-SUM yindlela esheshayo nelula yokufaka umsebenzi we-SUM.

Xa ufakwe kule fashoni, umsebenzi uzama ukucacisa uluhlu lweeseli ukuba lufakwe kwi-data ejikelezileyo kwaye ngokuzenzekelayo lufaka uluhlu oluninzi njengengxabano yenombolo yomsebenzi.

Umsebenzi uhlola kuphela idatha yedatha ekhompyutheni engenhla okanye kwimigca ngakwesobunxele kweseli esebenzayo kwaye iyayigcina idatha yombhalo kunye neeseli ezingenanto.

Ngezantsi zidweliswe amanyathelo asetyenziswa ukufaka umsebenzi we-SUM kwifom ye-A7 njengoko kuboniswe kumfanekiso ongentla.

  1. Cofa kwiseli A7 ukwenzela ukuba yenze iseli esebenzayo - indawo apho iziphumo zomsebenzi ziza kuboniswa
  2. Cinezela iqhosha le-SUM ecaleni komgca wokufakwayo - njengoko kuboniswe kumfanekiso ongentla
  3. Umsebenzi we-SUM kufuneka ungeniswe kwi-cell esebenzayo-umsebenzi kufuneka ufake ngokuzenzekelayo isalathisi ye-cell A6 njengengxabano yenombolo
  4. Ukutshintsha uluhlu lweenkomfa zesetyenzisiweyo ezisetyenziselwa ingxabano yenombolo , sebenzisa i-pointer ye mouse ukugqamisa udidi lwe-A1 ukuya ku-A6
  5. Cinezela ukhiye wokungena kwikhibhodi ukugqiba umsebenzi
  6. Impendulo 417 imele iboniswe kwiseli A7
  7. Xa ucofa kwi-cell A7, umsebenzi opheleleyo = ISUM (A1: A6) ibonakala kumgca wokufaka ngaphaya kwephepha lokusebenzela

02 we 02

Yongeza Amanani Ukusebenzisa ibhokisi yeDiscobo ye-SUM ye-SUM

Data Summing usebenzisa i-SUM Function Box kwi-Open Office Calc. © Ted French

Idatha yeSomming kunye nebhokisi yeNtsebenzo yeSUM ye-SUM

Njengoko kubonisiwe, enye indlela yokufaka umsebenzi we-SUM kukusebenzisa ibhokisi yencoko yencoko yomsebenzi, evulekileyo okanye yiyo:

Ibhokisi leNgcaciso

Inzuzo yokusebenzisa ibhokisi yencoko ibandakanya:

  1. Ibhokisi yencoko ibinakekisa i-syntax yomsebenzi - yenza kube lula ukufaka iingxabano zomsebenzi omnye ngexesha ngaphandle kokungena uphawu olulinganayo, iibakaki, okanye ii-semicolons ezenza njengabahluli phakathi kweengxabano.
  2. Xa idatha isingathelwanga ayifumanekanga kwibala elithintekayo, ukuboniswa kweeseli, njenge-A1, A3, kunye ne-B2: B3 ingafakwa ngokungenangqangi njengeengcamango zeenombolo ezahlukileyo kwibhokisi yencoko ngokubaluleka- okuquka ukucofa kwiiseli ezikhethiweyo kunye imouse kunokuba uthayiphe kuyo. Akukona nje ukubonisa lula, kunceda ukunciphisa amaphutha kwiifomula ezibangelwa zikhombisi zeefayile ezingalunganga.

Umsebenzi we-SUM Example

Ngezantsi zidweliswe amanyathelo asetyenziswa ukufaka umsebenzi we-SUM kwifom ye-A7 njengoko kuboniswe kumfanekiso ongentla. Imiyalelo isebenzise ibhokisi yencoko yomsebenzi we-SUM ukungena kwiimpawu ezikhoyo kwiiseli A1, A3, A6, B2, kunye ne-B3 njengeengxelo zeenombolo zomsebenzi.

  1. Cofa kwiseli A7 ukwenzela ukuba yenze iseli esebenzayo - indawo apho iziphumo zomsebenzi ziza kuboniswa
  2. Cofa kwi icon ye- Function Wizard eceleni komgca wokufakelwa (njengendlela yefom yefomula kwi-Excel) ukukhupha ibhokisi yencoko yencoko ye Wizard
  3. Cofa kwiluhlu lokuhlahla lweCandelo uze ukhethe iMathematika ukubona uluhlu lwemisebenzi yamatriki
  4. Khetha i-SUM kuluhlu lwemisebenzi
  5. Chofoza Okulandelayo
  6. Cofa kwinombolo 1 kwibhokisi yencoko xa kuyimfuneko
  7. Cofa kwifowuni A1 kwiphepha lokusebenzela ukuze ufake ifowuni yesibini kwibhokisi yencoko
  8. Cofa kwinombolo 2 kwibhokisi yencoko
  9. Cofa kwifowuni A3 kwiphepha lokusebenzela ukuze ufake ifowuni yesalathisi
  10. Cofa kwinombolo 3 kwibhokisi yencoko
  11. Cofa kwifowuni A6 kwiphepha lokusebenzela ukufaka eso saziso seeseli
  12. Cofa kwinombolo 4 kwibhokisi yencoko
  13. Khanyisa iiseli B2: B3 kwiphepha lokusebenzela ukufaka eli luhlu
  14. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
  15. Inombolo 695 ifanele ivele kwiseli ye-A7 - njengolu luhlu lwamanani e-cell A1 ukuya kwi-B3
  16. Xa ucofa kwi-cell A7 umsebenzi opheleleyo = ISUM (A1; A3; A6; B2: B3) ibonakala kumgca wokufakelwa ngaphezulu kwephepha lokusebenzela