I-OpenOffice Calc Training Tutorial

I-OpenOffice Calc, uhlelo lwespredishithi olunikezwa mahhala nge-openoffice.org, likuvumela ukuba wenze izibalo kudatha efakwe kuspredishithi .

Ungasebenzisa amafomula e- OpenOffice Calc ngenombolo yesisekelo eyisisekelo, njengokungeza noma ukususa, kanye nezibalo eziyinkimbinkimbi ezifana nokukhishwa kwe-payroll noma ukukala imiphumela yokuhlolwa komfundi.

Ngaphezu kwalokho, uma ushintsha idatha yeCalc izophinde ibuyele kabusha impendulo ngokuzenzakalelayo ngaphandle kokufaka kabusha ifomula.

Lesi sinyathelo esilandelayo nesibonelo sesigaba sibandakanya indlela yokudala nokusebenzisa ifomula eyisisekelo ku-OpenOffice Calc.

01 ka 05

I-OpenOffice Calc Training Tutorial: Isinyathelo sokungu-3

Isibonelo esilandelayo sakha ifomula eyisisekelo. Izinyathelo ezisetshenziselwa ukwakha le fomula zifanayo okumele zilandele uma ubhala amafomula amaningi ahlukene. Ifomula izokwengeza izinombolo 3 + 2. Ifomula yokugcina izobukeka kanje:

= C1 + C2

Isinyathelo 1: Ukufaka idatha

Qaphela: Ukuze uthole usizo ngalesi sifundo ubheke isithombe esingenhla.

1. Thayipha i-3 kuseli C1 bese ucindezela inkinobho ENTER ekhibhodi.
   
2. Thayipha i-2 kwiseli C2 bese ucindezela inkinobho ENTER ekhibhodi.

02 ka 05

I-OpenOffice Calc Tutorial Training: Isinyathelo 2 se-3

Lapho udala amafomula ku-Open Office Calc, uQALA ngokuqala ukuthayipha uphawu olulinganayo. Uthayipha esitokisini lapho ufuna impendulo ivele khona.

Qaphela : Ukuze uthole usizo ngalesi sibonelo ubheke isithombe esingenhla.

1. Chofoza kuseli C3 (okuchazwe kumnyama esithombeni) ngesininzana sakho segundane.
   
2. Thayipha uphawu olulinganayo ( = ) esitokisini C3.

03 ka 05

I-OpenOffice Calc Training Tutorial: Isinyathelo sesi-3 se-3

Ukulandela isibonakaliso esilinganayo, sengeza ezinkombulweni zeseli zamaseli aqukethe idatha yethu.

Ngokusebenzisa izinkomba zocingo zedatha yethu kwifomula, ifomula izovuselela ngokuzenzakalelayo impendulo uma idatha emaseleni C1 no-C2 ishintsha.

Indlela engcono kakhulu yokwengeza izingqikithi zeseli ngokusebenzisa igundane ukuze ukhombe futhi uchofoze kuseli elungile. Le ndlela ikuvumela ukuba uchofoze ngegundane lakho kuseli eliqukethe idatha yakho ukwengeza ireferensi yeseli kwifomula.

Ngemuva kwesibonakaliso esilinganayo esenezwe isinyathelo 2

1. Chofoza kuseli C1 nge-pointer yegundane.
   
2. Thayipha uphawu lokuhlanganisa ( + ).
   
3. Chofoza kuseli C2 nge-pointer yegundane.
   
4. Cindezela inkinobho ENTER ekhibhodi.
   
5. Impendulo 5 kufanele ivele esitokisini C3.
   
6. Chofoza kuseli C3. Ifomula iboniswa emgqeni wokufaka ngenhla kwephepha lokusebenzela .

04 ka 05

AbaSebenzi beMathematika emafomula ama-OpenOffice Calc

Ukudala amafomula ku-OpenOffice Calc akulula. Vele uhlanganise izingcaphuno zeselula zedatha yakho ne-opharetha efanele yezibalo.

Ama-opharetha wezibalo asetshenziselwa amafomu e-Calc afana nalawo asetshenziswe ekilasini lezibalo.

• Ukususa - uphawu lokususa ( - )
• Ukwengeza - nesibonakaliso ( + )
• Isigaba - ukukhishwa phambili ( / )
• Ukuphindaphinda - i-asterisk ( * )
• I-Exponentiation - ukunakekelwa ( ^ )

05 ka 05

I-OpenOffice Calc Order of Operations

Uma kune-opharetha angaphezu kweyodwa esetshenziselwa ifomula, kune-oda elithile ukuthi iCalc izoyilandela ukwenza le misebenzi yokubala. Le oda lomsebenzi lingashintshwa ngokufaka amabakaki ku-equation. Indlela elula yokukhumbula umyalelo wemisebenzi ukusebenzisa isichazamazwi:

BEDMAS

I-Order of Operations yilezi:

• Ama- racket B
  E xponents
  D ivision
  Ukukhumbuza okuphezulu
  I- ddition
  S ukukhishwa

Indlela i-Order of Operations isebenza ngayo

Noma yikuphi ukusebenza (ama) okuqukethwe kubakaki kuzokwenziwa kuqala kulandelwa noma yikuphi okuvezwayo.

Ngemuva kwalokho, i-Calc ibheka imisebenzi yokuhlukaniswa noma yokubuyabuyelela ukuthi ibaluleke kakhulu, futhi yenza lokhu kusebenza ngendlela ehamba ngayo ngakwesobunxele kuya kwesokudla ku-equation.

Okufanayo kuya emisebenzini emibili elandelayo addition and withdrawal. Babhekwa njengalingana ngokulandelana kwemisebenzi. Kungakhathaliseki ukuthi ubani oqala kuqala ku-equation, noma ukufaka noma ukukhipha, ukuhlinzwa kwenziwa kuqala.