I-MS Works Spreadsheets Amafomula

01 ngo-08

Amafomula Okufingqiwe

Amafomula akuvumela ukuba wenze izibalo kudatha efakiwe kuma- spreadsheet akho.

Ungasebenzisa amafomula amaspredishithi wezinombolo eziyisisekelo zokuhlanganisa, njengokufaka noma ukususa, kanye nezibalo eziyinkimbinkimbi ezifana nokukhishwa kwe-payroll noma ukukala imiphumela yokuhlolwa komfundi. Amafomu ekholomu E esithombeni esingenhla anquma ukuthengiswa kwekota yokuqala yokugcina ngokufaka ukuthengiswa kwenyanga ngayinye.

Ngaphezu kwalokho, uma ushintsha idatha MS Works izovuselela ngokuzenzakalelayo impendulo ngaphandle kokufaka kabusha ifomula.

Isifundo esilandelayo sihlanganisa ngokuningiliziwe ukuthi ungasebenzisa kanjani amafomula, kufaka phakathi isinyathelo nesinyathelo esilandelayo sefomu lesisekelo le-MS Works amaspredishithi.

02 ngo-08

Ukubhala ifomula

Ukubhala amafomula ku-MS Works amaspredishithi ahluke kakhulu kunendlela eyenziwa ngayo ekilasini.

I-MS Works ifomula iqala ngesibonakaliso esifanayo (=) esikhundleni sokuphela nayo.

Uphawu olulinganayo luya njalo esitokisini lapho ufuna khona impendulo yefomula ukuthi ivele.

Isibonakaliso esilinganayo sizisa MS Works ukuthi okulandelayo kuyingxenye yefomula, hhayi nje igama noma inombolo.

Inqubo ye-MS Works ingathanda lokhu:

= 3 + 2

kunoku:

3 + 2 =

03 ngo-08

Izinkomba zoMakhalekhukhwini emafomulini

Ngenkathi ifomula kwisinyathelo sangaphambilini isebenza, sinomphumela owodwa. Uma ufuna ukushintsha idatha kubalwa udinga ukuhlela noma ukubhala kabusha ifomula.

Indlela engcono kungaba ukubhala ifomula ukuze ukwazi ukuguqula idatha ngaphandle kokuthi ushintshe ifomula ngokwayo.

Ukwenza lokhu, ungayithayipha idatha kumaseli bese kuthi, ku-formula, tshela i-MS Works ukuthi amaseli kuspredishithi idatha ikhona. Indawo yeseli kuspredishithi ibizwa ngokuthi isithenjwa saso.

Ukuze uthole ireferensi yeseli, mane nje ubheke izihloko zekholomu ukuthola ukuthi iyiphi ikholomu iseli elingaphakathi, futhi ngaphesheya ukuthola ukuthi yiliphi irowu elingaphakathi.

Isithenjwa se-cell yinhlanganisela yombhalo wekholomu nenombolo yomugqa - njenge- A1 , B3 , noma i- Z345 . Uma ubhala izingqikithi zamangqamuzana incwadi yekholomu njalo iza kuqala.

Ngakho, esikhundleni sokubhala le fomula kuseli C1:

= 3 + 2

bhala lokhu kunalokho:

= A1 + A2

Qaphela: Uma uchofoza esitokisini esinefomula ku-MS Works (bona isithombe esingenhla), ifomula ibonakala njalo kubha yefomula elitholakala ngaphezu kwezinhlamvu zekholomu.

04 ngo-08

Ukubuyekeza ama-MS Works Amaspredishithi amafomula

Uma usebenzisa izinkomba zeselula ku-MS Works ifomula lesipredishithi, ifomula izovuselela ngokuzenzakalelayo noma kunini uma idatha efanele ku-spreadsheet ishintsha.

Isibonelo, uma uqaphela ukuthi idatha e-cell A1 kufanele ibe yi-8 esikhundleni se-3, udinga kuphela ukushintsha okuqukethwe kwe-cell A1.

I-MS Works ivuselela impendulo kwiselula C1. Ifomula, ngokwayo, ayidingi ukushintsha ngoba ibhaliwe besebenzisa izinkomba zeselula.

Ukushintsha idatha

1. Chofoza kuselili A1
2. Thayipha i-8
3. Cindezela inkinobho ENTER ekhibhodi

Impendulo ku-cell C1, lapho ifomula ikhona khona, ishintsha ngokushesha kusuka ku-5 kuya ku-10, kodwa ifomula ngokwayo ayishintshi.

05 ka-08

Abasebenzisi beMathematika emafomu

Ukudala amafomula ku-MS Works Spreadsheets akulula. Vele uhlanganise izingcaphuno zeselula zedatha yakho ne-opharetha efanele yezibalo.

Ama-opera wezibalo asetshenziswe ku-MS Works amaspredishithi amafomula afana nalawo asetshenziswe ekilasini lesibalo.

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

I-Order of Operations

Uma kune-opharetha abangaphezu kweyodwa asetshenziselwa ifomula, kunomyalelo othize osebenzayo we-MS Works ukuze enze lokhu kusebenza kwembalo. 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

I-Order of Operations ichazwe

1. Noma yikuphi ukusebenza (ama) okuqukethwe kubakaki kuzokwenziwa kuqala
2. Abaxhasi baqhutshwa okwesibili.
3. I-MS Works ibheka imisebenzi yokwahlukanisa noma yokubuyabuyelela ukuba ibaluleke kakhulu, futhi yenza lezi zindlela ngendlela yokuthi zivele ngakwesobunxele kuya kwesokudla ku-equation.
   
4. I-MS Works iphinda ibheke ukuthi ukwengeza nokususa kubaluleke kakhulu. Noma yikuphi okuvela kuqala ku-equation, noma ukufaka noma ukukhipha, umsebenzi owenziwe kuqala.

06 ka-08

I-MS Works Spreadsheet I-Formula Tutorial: Isinyathelo soku-3 sokufaka idatha

Ake sizame isibonelo sesinyathelo nesinyathelo. Sizobhala ifomula elula ku-MS Works spreadsheet ukwengeza izinombolo 3 + 2.

Isinyathelo 1: Ukufaka idatha

Kungcono uma uqala ukungena yonke idatha yakho kuspredishithi ngaphambi kokuba uqale ukudala amafomula. Ngale ndlela uzokwazi ukuthi kunezinkinga zokuhlela, futhi cishe ngeke udinga ukulungisa ifomula yakho kamuva.

Ukuze uthole usizo ngalesi sifundo ubheke isithombe esingenhla.

1. Thayipha i-3 kuseli ye-A1 bese ucindezela inkinobho ENTER ekhibhodi.
   
2. Thayipha i-2 kwiseli A2 bese ucindezela inkinobho ENTER ekhibhodi.

07 ngo-08

Isinyathelo sesi-2 se-3: Thayipha ku-Equal (=) Sign

Uma udala amafomu ku-MS Works Spreadsheets, UYAQALA ngokuqala ukuthayipha uphawu olulinganayo. Uthayipha esitokisini lapho ufuna impendulo ivele khona.

Isinyathelo sesi-2 se-3

Ukuze uthole usizo ngalesi sibonelo ubheke isithombe esingenhla.

1. Chofoza kuselili C1 (elichazwe emnyama esithombeni) nge-pointer yakho yegundane.
   
2. Thayipha uphawu olulinganayo kuseli C1.

08 ngo-08

Isinyathelo sesi-3: Ukwengeza izingqikithi zesigcino ngokusebenzisa ukuveza

Ngemuva kokuthayipha uphawu olulinganayo kwisinyathelo sesi-2, unezinketho ezimbili zokwengeza izinkomba zeseli kwifomula yespredishithi.

1. Ungawafaka phakathi noma,
2. Ungasebenzisa isici se-MS Works esibizwa ngokukhomba

Ukukhomba kukuvumela ukuba uchofoze ngegundane lakho kuseli eliqukethe idatha yakho ukuze ungeze ireferensi yeseli yakho kwifomula.

Isinyathelo sesi-3 sesi-3

Iyaqhubeka isinyathelo sesi-2 salesi sibonelo

1. Chofoza kwiseli A1 ngesininzana segundane
2. Thayipha uphawu lokuhlanganisa (+)
3. Chofoza kuseli ye-A2 ngesinxele segundane
4. Cindezela inkinobho ENTER ekhibhodi
5. Impendulo 5 kufanele ivele kuseli C1.

Ezinye Izinsiza Eziwusizo

• I-Microsoft Works Task Launcher
• I-Microsoft Works Spreadsheets Tutorial
• I-MS Works Spreadsheets Amafomula