MS Works Spreadsheets Formulas

01 ye 08

Formulas Overview

Mafomu anobvumira kuti uite maverengi pane data yakanyorerwa maepesheetsiti ako.

Iwe unogona kushandisa mahwendefa epadhesi nokuda kwenhamba yakakosha crunching, yakadai sekuwedzera kana kubvisa, pamwe nekuwedzerwa kwakaoma zvakadai sekubhadharwa kwemabhadharo kana kujekesa mhinduro dzevadzidzi. Nzira dziri muchitsauko E chiri mumufananidzo uri pamusoro apa inoyera dare rekutanga rokutengesa nekuwedzera kutengesa kwemwedzi mumwe nomumwe.

Mukuwedzera, kana ukashandura iyo data MS Works ichadzokorora zvakare mhinduro yacho pasina iwe unofanirwa zvakare kupinda mufomu.

Dzidzo inotevera inosanganisira zvakajeka kuti ungashandisa sei mazano, kusanganisira danho nehanho muenzaniso weSMS Works Primary spreadsheets fomu.

02 of 08

Kunyora Iforomu

Kunyora mabhairimu mune MS Works spreadsheets yakasiyana zvakanyanya kupfuura iyo inoitwa mumatunhu eklasi.

An MS Works formula inotanga nechiratidzo chakaenzana (=) panzvimbo pokuguma nayo.

Chiratidzo chakaenzana nguva dzose chinopinda muchitokisi uko iwe unoda mhinduro yechinyorwa kuoneka.

Chiratidzo chakafanana chinozivisa MS Works kuti izvo zvinotevera chikamu chemuumbi, uye kwete zita kana nhamba.

An MS Works formula angada izvi:

= 3 + 2

pane ku:

3 + 2 =

03 of 08

Cell References in Formulas

Kunyange zvazvo chirevo chiri mudanho rinotanga kushanda, rine rimwe dambudziko. Kana iwe uchida kuchinja data iri kuverengwa iwe unoda kuchinja kana kunyorazve fomu.

Nzira iri nani ndeyokunyora chimiro kuitira kuti iwe ugone kuchinja data pasina kushandura chimiro pachako.

Kuti uite izvi, iwe unogona kuisa deta yacho mumasero uye zvakare, mumutemo, taurira MS Works iyo masero ari mupadheetet data inowanikwa. Pane imwe sero iri mune pepadheet inonzi inoshandiswa.

Kuti uwane sero rinotarisa, tongotarisa pamisoro yechinyorwa kuti uone kuti ndepi iyo seni iri mukati, uye kumativi ose kuti uwane mutsara iwoyo urimo.

Sero rinoshandiswa nderokubatanidzwa kwemutsara wemutsamba nemutsara wenhamba - seA1 , B3 , kana Z345 . Apo paunyorera zvinyorwa zvinyorwa zvinyorwa zvinyorwa nguva dzose zvinouya pakutanga.

Saka, panzvimbo yekunyora chirevo ichi muchitokisi C1:

= 3 + 2

nyora izvi pane izvi:

= A1 + A2

Cherechedza: Paunenge uchitsvaga pane sero rine maitiro mu MS Works (ona mufananidzo uri pamusoro), maitiro acho anowanzoonekwa mubhairi yepamusoro iri pamusoro pemakoromari.

04 of 08

Kudzokorora MS Works Spreadsheets Form

Paunoshandisa sero zvinyorwa muSMS Works spreadsheet fomu, fomu yacho ichadzoka pakarepo apo chero data yakakosha iri paspredishiti ichichinja.

Somuenzaniso, kana iwe ukaona kuti data iri muchitokisi A1 inofanirwa kunge iri 8 panzvimbo ye3, iwe unongoda kuchinja zviri mukati memusero A1.

MS Works anovandudza mhinduro yacho muchitokisi C1. Icho chimiro, chaicho, hachifaniri kuchinja nokuti chakange chakanyorwa kushandiswa kwemasero.

Kuchinja data

1. Dzvanya pane sero A1
2. Tora an 8
3. Dhinda iri ENTER kiyi pane keyboard

Mhinduro yacho muchitokisi C1, iyo yakarongeka, inoshanduka kubva pa5 kusvika ku10, asi chimiro chayo pachacho hachina kuchinjwa.

05 of 08

Mathematical Operators muFormula

Kugadzira mafomu mune MS Works Spreadsheets haisi nyore. Ingosonganisa zvinyorwa zvemasero zve data yako neyakakodzera mashematical operator.

Mathematical operators anoshandiswa muSMS Works spreadsheets maforamu akafanana neaya anoshandiswa mumatunhu ekirasi.

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

Mutemo weKushanda

Kana vakawanda kupfuura imwe yevashandi vari kushandiswa mumurairo, kune urongwa huripo uyo MS Works achazotevera kuti aite izvi masvomhu maitiro. 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

Mutemo wekushandisa unotsanangurwa

1. Chero kushanda (s) iri mune mabheji kuchaitwa kutanga
2. Vanodzidzisa vanoitwa wechipiri.
3. MS Works inobata mabasa ekuparadzanisa kana kupararira kuti ave akaenzana zvakakosha, uye anoita mabasa aya nenzira yakatarwa inoitika kuruboshwe kuenda kurudyi mune equation.
   
4. MS Works inofungawo kuti kuwedzera nekubvisa kunokosha zvakaenzana. Iyo ipi zvayo inotanga kuonekwa pakutanga muy equation, kana kuwedzera kana kubvisa, ndiyo inoshanda yakatanga.

06 of 08

MS Works Spreadsheets Formula Tutorial: Step 1 yechitatu - Kuisa Data

Ngatiedzei muenzaniso unhanho neshato. Tichanyora shanduro iri nyore muSMS Works spreadsheet kuti uwedzere nhamba 3 + 2.

Nhanho 1: Kuisa data

Zvakanakisisa kana iwe ukatanga kupinda yose yako yedhadha muparashirusi usati watanga kugadzira mapepa. Nzira iyo iwe uchaziva kana pane matambudziko ekugadzirisa, uye hazviiti kuti iwe unoda kururamisa fomu yako gare gare.

Kuti rubatsiro nemudzidzisi uyu titaure pamufananidzo uri pamusoro.

1. Tora 3 mu cell A1 uye shandisa ENTER key pa keyboard.
   
2. Tora 2 mu cell A2 uye shandisa ENTER key pane keyboard.

07 of 08

Nhanho 2 ye3: Tanga muEqual (=) Sign

Paunenge uchigadzira mapepa muS MS Works Spreadsheets, iwe WOSE unotanga nokunyora chiratidzo chakaenzana. Iwe unoridza iyo muchitokisi apo iwe unoda kuti mhinduro ioneke.

Nhanho 2 ye3

Kuti ubatsirwe nemuenzaniso uyu taura kune chifananidzo chiri pamusoro.

1. Dzvanya pachitokisi C1 (yakarondedzerwa mumusi mumufananidzo) neine mouse yako pointer.
   
2. Tora chiyero chakakwana muchitokisi C1.

08 we 08

Nhanho 3: Kuwedzera Maferensi eSekushandisa Kushandisa

Mushure mokutora chiratidzo chakaenzana muchikamu chechipiri, une zvisarudzo zviviri zvekuwedzera masero ekutaurirwa kushandura faira.

1. Unogona kuzvipinza mukati kana,
2. Iwe unogona kushandisa MS Works iyo inonzi inotsanangura

Kutaura kunokubvumira kuti ukwanise newaini yako pane sero ine deta yako kuti uwedzere sero rinotaridzirwa.

Nhano 3 ye3

Kuenderera mberi kubva padanho rechipiri pamuenzaniso uyu

1. Dzvanya pane sero A1 neine mouse pointer
2. Tora imwe (+) chiratidzo
3. Dzvanya pachitokisi A2 neine mouse pointer
4. Dhinda iri ENTER kiyi pane keyboard
5. Mhinduro 5 inofanira kuonekwa muchitokisi C1.

Zvimwe Zvimwe Zvinobatsira Zvinobatsira

• Microsoft Works Task Launcher
• Microsoft Works Works Spreadsheets Tutori
• MS Works Spreadsheets Formulas