MS Works Spreadsheets Ifomu

01 ngo 08

Iifomula eziPhezulu

Iifomula zivumela ukuba wenze izibalo kwiedatha ezifakwe kwiipredishithi zakho.

Ungasebenzisa iifomula zespredishithi ngenombolo yokuqhafaza kwenombolo, njengokungeza okanye ukukhupha, kunye nokubala okunzima kunjengeentlawulo zokurhoxiswa kwemirhumo okanye ukulinganisela iziphumo zokuvavanya zabafundi. Iifomula kwikholam ye-E kumfanekiso ongentla zibala i-quarter yeevenkile yokuthengisa ngokuthengisa ukuthengisa kwinyanga nganye.

Ukongeza, ukuba utshintshe idatha ye-MS Works izakuphindaphinda ngokuzenzekelayo impendulo ngaphandle kokuba uphinde ufake ifom.

Isifundo esilandelayo sihlanganisa ngokubanzi indlela yokusebenzisa iifomula, kubandakanywa isinyathelo kunye nomzekelo wesisombululo sefom ye-MS esebenzayo.

02 ngo 08

Ukubhala iFormula

Ukubhala iifomula kwi-MS Works spreadsheets ahluke kakhulu kunendlela eyenziwa kwiklasi yamatriki.

Ifom ye-MS Works iqalisa uphawu olulinganayo (=) kunokuba luphele nalo.

Uphawu olulinganayo luhlala luhlala kwiseli apho ufuna impendulo yefomula ibonakale.

Uphawu olulinganayo lukwazisa iMisebenzi ye-MS ukuba le nto ilandelayo inxalenye yolu hlobo, kwaye kungekhona nje igama okanye inombolo.

Ifom ye-MS Works ingathanda oku:

= 3 + 2

ngaphandle kwe:

3 + 2 =

03 we-08

Iingxelo zeSeli kwiifomu

Ngoxa i-formula kwisinyathelo esandulelayo isebenza, inomlinganiselo othile. Ukuba ufuna ukutshintsha idatha ibalwa kufuneka uhlele okanye uphinde ubhale ifom.

Indlela engcono kukuba kubhala ifom ukuze ukwazi ukutshintsha idatha ngaphandle kokuba utshintshe ifom ngokwalo.

Ukwenza oku, uthayibhile idatha kwiiseli kwaye ke, kwifomula, xelela i-MS Works apho iiseli kwispredishithi idatha. Indawo yesisele kwi-spreadsheet ibhekiselwa kuyo njengeteksi yeseli yayo.

Ukufumana iselferensi yeseli, qwa lasela kwiibhloko zekholomu ukufumana ukuba yeyiphi ikholomu iseli ilapha, kwaye ngaphaya kokufumana umqolo ophi.

Iselferensi yeseli ludibaniso lwencwadi yekholomu kunye nenombolo yomqolo - njenge- A1 , B3 , okanye i- Z345 . Xa ubhala iingxelo zeselfowuni kwileta yekholomu zihlala ziqala kuqala.

Ngoko, endaweni yokubhala le fomyula kwiseli C1:

= 3 + 2

bhala oku:

= A1 + A2

Qaphela: Xa ucofa kwiseli equkethe ifom e-MS Works (jonga umfanekiso ongentla), le fomyula ibonakala rhoqo kwibha yefomula esekelwe kwiibhokisi zekholomu.

04 we-08

Ukuhlaziya i-MS Works Spreadsheets ifomu

Xa usebenzisa ii-cell reference kwi-MS Works ifom ye-spreadsheet yefomula, ifomula iya kuhlaziya ngokuzenzekelayo naluphi na ulwazi olufanelekileyo kwi-spreadsheet lushintsha.

Ngokomzekelo, ukuba uqaphela ukuba idatha kwi-A1 yeseli ifanele ibe yi-8 esikhundleni se-3, kufuneka uguqule kuphela okuqukethwe kwiseli A1.

I-MS Works ihlaziya impendulo kwiseli C1. I-formula, ngokwayo, ayifuni ukutshintsha kuba ibhaliwe kusetyenziswa izikhokelo zeseli.

Ukutshintsha idatha

1. Cofa kwi-cell A1
2. Thayipha i-8
3. Cinezela i- ENTER iqhosha kwikhibhodi

Impendulo kwiseli C1, apho ifom, iguquke ngokukhawuleza ukusuka kwi-5 kuya ku-10, kodwa i-formula ngokwayo ayitshintshi.

05 ka 08

AbaSebenzi beMathematika kwiifomu

Ukudala amafomula kwi-MS Works Spreadsheets ayinzima. Hlanganisa iinkcukacha zeseli zedatha yakho kunye nomqhubi weemathematika ochanekileyo.

Abaqhubi beemathematika asetyenziswa kwi-MS Works spreadsheet amafomula afana nalawo asetyenziswa kwizifundo zamatriki.

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

Umyalelo weMisebenzi

Ukuba ngaphezulu komsebenzisi omnye kusetyenziswa kwifom, kukho umyalelo othile oza kulandelwa ngu-MS Works 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

UMyalelo weMisebenzi uchazwe

1. Naliphi na imisebenzi (e) equkethwe kubakaki iya kwenziwa kuqala
2. Abaxhasi baqhutyelwa okwesibini.
3. I-MS Works ibona imisebenzi yokwahlula okanye yokuphindaphinda ukuba ibaluleke ngokulinganayo, kwaye yenza le mi sebenzi ngokulandelelana kwayo ivela ngakwesobunxele ukuya kwesokudla kwi-equation.
   
4. I-MS Works iphinda ibone ukuba ukongeza nokukhupha kubaluleke kakhulu. Naluphi na umntu ovela kuqala kwi-equation, nokuba ukongeza okanye ukukhupha, ngumsebenzi owenziwa kuqala.

06 we-08

I-MS Works Spreadsheets I-Formula Tutorial: Isinyathelo soku-3 - Ukungenisa idatha

Makhe sizame umzekelo wesinyathelo nesinyathelo. Siza kubhala ifomula elula kwi-MS Works spreadsheet yokongeza amanani 3 + 2.

Inyathelo 1: Ukufaka idatha

Kungcono ukuba uqale ufake yonke idatha yakho kwi-spreadsheet ngaphambi kokuba uqale ukudala amafomula. Ngale ndlela uza kuqonda ukuba kukho nayiphi na ingxaki yokubekwa, kwaye akunakwenzeka ukuba uzakufuna ukulungisa ifom yakho yakho kamva.

Ukuba uncedo kule tutorial ubhekisela kumfanekiso ongentla.

1. Thayipha i-3 kwiseli ye-A1 uze ucinezela ENTER kwikhibhodi.
   
2. Thayipha i-2 kwiseli ye-A2 kwaye cinezela ENTER kwikhibhodi.

07 ka 08

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

Xa udala amafomula kwi-MS Works Spreadsheets, UYAQALA ngokuqala ukuthayipha uphawu olulinganayo. Ulufake kwisisele apho ufuna impendulo ivele khona.

Isinyathelo 2 se-3

Ukuba uncedo kulo mzekelo ubhekisela kumfanekiso ongentla.

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

08 ka 08

Inyathelo lesi-3: Ukongeza iiReferensi zeeSetyenziso ngokuSebenzisa

Emva kokuthayipha uphawu olulinganayo kwisinyathelo 2, unokhetho oluninzi lokufaka iinkcukacha zeseli kwifom yespredishithi.

1. Ungawafaka phakathi okanye,
2. Ungasebenzisa inkcazelo ye-MS Works ebizwa ngokuba yi- pointing

Ukutshintshwa kukuvumela ukuba ucofe kunye nemouse yakho kwiseli equle idatha yakho ukuze ungeze ifowuni yayo kwifomula.

Isinyathelo 3 se-3

Ukuqhubeka ukusuka kwisinyathelo 2 kulo mzekelo

1. Cofa kwifowuni A1 kunye ne-mouse pointer
2. Thayipha uphawu lokuhlanganisa (+)
3. Cofa kwi-cell A2 kunye ne-mouse pointer
4. Cinezela i- ENTER iqhosha kwikhibhodi
5. Impendulo yesi-5 kufuneka ibonakale kwiseli C1.

Ezinye izinto eziNcedo

• Umqalisi weMicrosoft Task Launcher
• IMicrosoft Works Spreadsheets Tutorial
• MS Works Spreadsheets Ifomu