I-OpenOffice Calc Formulas Tutorial

I-OpenOffice Calc, inkqubo yespredishithi inikezwa ngesihlawulelo nge-openoffice.org, ikuvumela ukuba wenze izibalo kwidatha efakwe kwispredishithi .

Ungasebenzisa iifomula ze-OpenOffice zeCalc for the crunching number, njengokongeza okanye ukukhupha, kunye nokubala okunzima kunjengeentlawulo zokurhoxiswa komvuzo okanye ukulinganisela iziphumo zokuvavanya zabafundi.

Ukongeza, ukuba utshintshe idatha yeCalc iya kuphinda iphinde ibuyele kwakhona impendulo ngaphandle kokuba uphinde ufake ifom.

Eli nyathelo elilandelayo ngumzekelo wesigqeba liquka indlela yokudala nokusebenzisa ifom eyisisiseko kwi-OpenOffice Calc.

01 ngo 05

I-OpenOffice Calc Formula Tutorial: Isinyathelo soku-3

Umzekelo olandelayo udala ifom ye siseko. Amanyathelo asetshenziselwa ukudala le fomyula ayafana nokulandela xa ebhala iifomula eziyinkimbinkimbi. Imfomula iya kwandisa amanani 3 + 2. Ifom yokugqibela iya kubonakala ngathi:

= C1 + C2

Inyathelo 1: Ukufaka idatha

Qaphela: Ukuba uncedo ngale khokelo ubhekisela kumfanekiso ongentla.

1. Thayipha i-3 kwiseli C1 uze ucinezela ENTER ukhiye kwikhibhodi.
   
2. Thayipha i-2 kwiseli C2 kwaye cinezela ENTER kwikhibhodi.

02 we 05

I-OpenOffice ye-Calc Formula Tutorial: Isinyathelo 2 se-3

Xa udala amafomula kwi-Open Office Calc, UYAQALA ngokuqala ukuthayipha uphawu olulinganayo. Ulufake kwisisele apho ufuna impendulo ivele khona.

Qaphela : Uncedo kulo mzekelo ubhekisela kumfanekiso ongentla.

1. Cofa kwiseli C3 (echazwe kumnyama emfanekisweni) kunye nesalathisi sakho semouse.
   
2. Thayipha uphawu olulinganayo ( = ) kwiseli C3.

03 we 05

I-OpenOffice ye-Calc Formula Tutorial: Isinyathelo 3 se-3

Ukulandela uphawu olulinganayo, songeza kwiingxelo zeeseli zeeseli eziqulethe idatha yethu.

Ngokusebenzisa izithenferensi zeesetyenzisiweyo zedatha kwifomyula, ifomu iya kuhlaziya ngokuzenzekelayo impendulo ukuba idatha kwiiseli zeC1 noC2 ziguquka.

Indlela eyona ndlela yokongeza iiferensi zesalathisi kukusebenzisa imouse ukukhomba uze uklikhe kwi-cell efanelekileyo. Le ndlela ikuvumela ukuba ucofe kunye nemouse yakho kwiseli equle idatha yakho yokongeza isalathisi yayo kwifom.

Emva kokuba uphawu olulinganayo lufakwe kwisinyathelo 2

1. Cofa kwifowuni C1 kunye nesilathisi se mouse.
   
2. Thayipha uphawu lokuhlanganisa ( + ).
   
3. Cofa kwifowuni C2 kunye nesilathisi se mouse.
   
4. Cinezela i- ENTER iqhosha kwikhibhodi.
   
5. Impendulo 5 kufuneka ibonakale kwiseli C3.
   
6. Cofa kwiseli C3. Imfomula iboniswa kumgca wegalelo ngaphaya kwephepha lokusebenzela .

04 we 05

AbaSebenzi beMathematika kwi-OpenOffice Calc form

Ukudala iifomula kwi-OpenOffice Calc akunzima. Hlanganisa iinkcukacha zeseli zedatha yakho kunye nomqhubi weemathematika ochanekileyo.

Abaqhubi beemathematika asetyenziswa kwiifomula zeCalc zifana nezo zisetyenziswa kwizifundo zamatriki.

• Ukukhupha - uphawu lokunciphisa ( - )
• Ukongeza - kunye nomqondiso ( + )
• Ulwahlulo - ukuqhuma phambili ( / )
• Ukuphindaphinda - i-asterisk ( * )
• Exponentiation - caret ( ^ )

05 we 05

I-OpenOffice Calc Order of Operations

Ukuba ngaphezulu komsebenzisi omnye kusetyenziswa kwifom, kukho umyalelo othile othi uCalc uya kulandela ukwenza le misebenzi yemathematika. Lo myalelo wezenzo unokutshintshwa ngokufaka amabakaki kwi-equation. Indlela elula yokukhumbula umyalelo wemisebenzi kukusebenzisa isichazi:

BEDMAS

UMyalelo weMisebenzi ngu:

• B rackets
  E xponents
  D ivision
  M ultiplication
  Isibhengezo
  S ubtraction

Indlela uMyalelo weMisebenzi oSebenza ngayo

Naliphi na imisebenzi (e) equlethwe kwiibakaki iya kwenziwa emva kokuqala.

Emva koko, iCalc ithatha imisebenzi yokwahlukana okanye yokuphindaphinda ukuba ibaluleke ngokulinganayo, kwaye yenza le mi sebenzi ngokulandelelana kwayo ivela ngakwesobunxele kuya kwesokudla kwi-equation.

Okufanayo kuya kokubili imisebenzi elandelayo � ukongeza nokukhupha. Zibhekwa njengelilinganayo ngendlela yokusebenza. Naluphi na ovela kuqala kwi-equation, nokuba ukongeza okanye ukukhupha, yinto eyenziwa kuqala.