OpenOffice Calc Formulas Tutorial

OpenOffice Calc, purogiramu yepaspiritsi yakabhadharwa pachena pasina openoffice.org, inokubvumira kuti uite maverengero pane data yakapinda muparapariti .

Iwe unogona kushandisa OpenOffice Calc ma formula for basic number crunching, zvakadai sekuwedzera kana kubvisa, pamwe nekuwedzerwa kwakaoma zvakadai sekubhadharwa kwemitero kana kuenzanisa mhinduro dzevadzidzi.

Mukuwedzera, kana ukashandura data Calc ichadzokorora zvakare mhinduro kunze kwekunge iwe udzoke zvakare mufomu.

Ichi chiito chinotevera nechikamu chekutanga chinosanganisira nzira yekusika uye kushandisa shanduko yekutanga mu OpenOffice Calc.

01 ye 05

OpenOffice Calc Formula Tutorial: Step 1 yechitatu

Muenzaniso unotevera unoumba chimiro chekutanga. Nhanho dzinoshandiswa kugadzira chirevo ichi ndechimwechete chekutevera paunonyora mazano akaoma kunzwisisa. Chirevo chacho chichawedzera nhamba 3 + 2. Chimiro chekupedzisira chichaita seizvi:

= C1 + C2

Nhanho 1: Kuisa data

Cherechedza: Kuti rubatsiro nerudzidzisi urwu ruratidze mufananidzo uri pamusoro.

1. Tora 3 mu cell C1 uye shandisa ENTER key pane keyboard.
   
2. Tora 2 mu cell C2 uye shandisa ENTER key pa keyboard.

02 of 05

OpenOffice Calc Formula Tutorial: Step 2 ye3

Paunenge uchigadzira mafomu mu Open Office Calc, unogara uchitanga nekunyora chiratidzo chakaenzana. Iwe unoridza iyo muchitokisi apo iwe unoda kuti mhinduro ioneke.

Cherechedza : Kubatsirwa nemuenzaniso uyu kunoreva chifananidzo chiri pamusoro.

1. Dzvanya pachitokisi C3 (yakatsanangurwa mumusi mumufananidzo) pamwe nemushonga wako wepiguru.
   
2. Tora chiyero chakakwana ( = ) muchitokisi C3.

03 of 05

OpenOffice Calc Formula Tutorial: Step 3 of 3

Titevera chiratidzo chakaenzana, tinowedzera mune zvinyorwa zvese zvemasero ane data yedu.

Nokushandisa sero zvinyorwa zvedunhu redu mumutsetse, fomu yacho ichadzosera mhinduro pakarepo kana data iri mumasero C1 neC2 achichinja.

Nzira yakanakisisa yekuwedzera masero ekutaura ndeyokushandisa purogiramu kuti inongedze uye chengeta pane seni yakakodzera. Iyi nzira inokubvumira kuti ukwanise nemushandi wako pane sero rine data yako kuti uwedzere sero rinotarisa kumutsetse.

Mushure mokunge chiratidzo chakafanana chakawedzerwa muchitsauko 2

1. Dzvanya pachitokisi C1 neine mouse pointer.
   
2. Tora imwe ( + ) chiratidzo.
   
3. Dzvanya pachitokisi C2 neine mouse pointer.
   
4. Dhinda iri ENTER kiyi pane keyboard.
   
5. Mhinduro 5 inofanira kuonekwa muchitokisi C3.
   
6. Dzvanya pane cell C3. Chirongwa chacho chinoratidzwa mumutsara wokupinza uri pamusoro pehwhepa .

04 of 05

Mathematical Operators mu OpenOffice Calc Formulas

Kugadzira mafomu mu OpenOffice Calc hazviremi. Ingosonganisa zvinyorwa zvemasero zve data yako neyakakodzera mashematical operator.

Mathematical operators anoshandiswa muCalc maitiro akafanana neaya anoshandiswa mumatunhu ekirasi.

• Kubvisa - kudisa chiratidzo ( - )
• Kuwedzera - pamwe nechiratidzo ( + )
• Kurambidza - mberi slash ( / )
• Kuwedzera - asterisk ( * )
• Exponentiation - caret ( ^ )

05 of 05

OpenOffice Calc Order of Operations

Kana vakawanda kupfuura imwe yevashandisi inoshandiswa mumutsetse, pane urongwa humwechete iyo Calc inotevera kutevera idzi masvomhu dzemabasa. Iri urongwa hwekushanda rinogona kuchinjwa nekuwedzera mabhakiti kune equation. Nzira iri nyore yekuyeuka kurongeka kwekushanda ndekushandisa shanduro iyi:

BEDMAS

Mutemo wekushanda ndewe:

• B rackets
  E xponents
  D ivision
  M kukurumidza
  A ddition
  S ubtraction

Kuti Mutemo weKushanda Unoshanda sei

Chero basa chero ripi zvaro riri mune mabheji richaitwa kutanga rinoteverwa nemamwe mavara.

Mushure meizvozvo, Calc inofunga kuti kupatsanurana kana kuwedzera kwemaitiro kunokosha zvakaenzana, uye inoita mabasa aya nenzira yakatarwa inoitika kuruboshwe kurudyi mune equation.

Izvo zvinoenda kumabasa maviri anotevera addition withdrawal. Vanonzi vanoenzana muhutano hwekushanda. Kunyangwe imwe inotanga kuonekwa muy equation, kana kuwedzera kana kubvisa, ndiko kushanda kwakaitwa kutanga.