MS Works Workssheets Formulas

01 na 08

Formulas Overview

Formulas ƙyale ka ka yi lissafi akan bayanan da aka shiga cikin layukanka .

Zaka iya amfani da maƙallan lissafi don ƙididdiga na asali, kamar ƙari ko raguwa, da ƙididdigar ƙididdiga irin su ƙididdigar albashi ko ƙaddara sakamakon gwajin dalibi. Dabarar a shafi na E a cikin hoton da ke sama ya lissafa tallace-tallace ta farko na kwandon ta hanyar ƙara tallace-tallace a kowane wata.

Bugu da ƙari, idan kun canza bayanin MS Works zai sauke amsar ta atomatik ba tare da kuna sake sake shigar da tsarin ba.

Koyaswar da ke biyo baya ke rufe dalla-dalla yadda za a yi amfani da maƙirai, ciki har da misali na mataki zuwa mataki na takardun shafukan MS Works.

02 na 08

Rubuta Formula

Rubutun rubutun a cikin takardun mujallan MS Works yana da ɗan bambanci fiye da hanyar da aka yi a cikin lissafin lissafi.

An samfurin MS Works da alamar daidai (=) maimakon kawo karshen tare da shi.

Gwargwadon daidaito yana shiga cikin tantanin halitta a duk lokacin da kake buƙatar daftarin amsawa ya bayyana.

Alamar daidai ta sanar da MS Works cewa abin da ya biyo baya wani ɓangare ne na ƙira, kuma ba kawai sunan ko lamba ba.

Aikin MS Works yana son wannan:

= 3 + 2

maimakon:

3 + 2 =

03 na 08

Siffofin Cell a cikin Formulas

Duk da yake dabarun a cikin mataki na gaba, yana da dashi daya. Idan kana so ka canza bayanan da aka lasafta kana buƙatar gyara ko sake rubuta wannan tsari.

Hanyar mafi kyau ita ce rubuta takarda don ka iya canza bayanin ba tare da canza tsarin da kanta ba.

Don yin wannan, za ku rubuta bayanan a cikin sassan sannan sannan, a cikin tsari, gaya wa MS Works wanda aka sanya a cikin bayanan da aka samo a cikin.

Don samun tantancewar salula, kawai duba kullun shafi don gano ko wane ɓangaren tantanin halitta yake cikin, kuma a fadin don gano wane layin da yake ciki.

Tambayar tantanin halitta shine hade da harafin shafi da jere - irin su A1 , B3 , ko Z345 . Lokacin da aka rubuta rubutun tantanin halitta yana nuna alamar shafi a kowane lokaci sau ɗaya.

Saboda haka, a maimakon rubuta wannan maƙala a cikin cell C1:

= 3 + 2

Rubuta wannan a maimakon:

= A1 + A2

Lura: Lokacin da ka danna kan tantanin halitta wanda ke ɗauke da wata mahimmanci a cikin MS Works (duba hoton da ke sama), wannan tsari yana nuna a cikin maƙallin dabarun dake sama da harufan haruffa.

04 na 08

Ana sabunta samfurori na Taswirar MS Works

Lokacin da kake amfani da bayanan salula a cikin matsala na MS Works, wannan tsari zai sabunta ta atomatik a duk lokacin da bayanai masu dacewa a cikin shafukan keɓaɓɓun sun canza.

Alal misali, idan kun gane cewa bayanan a cikin salula A1 ya kasance 8 maimakon wani 3, kawai kuna buƙatar canza abubuwan da ke ciki na cell A1.

MS Works na ɗaukaka amsar a cikin salula C1. Ma'anar, kanta, baya buƙatar canzawa saboda an rubuta shi ta amfani da nassoshi.

Canza bayanan

1. Danna kan tantanin halitta A1
2. Rubuta 8
3. Danna maballin ENTER akan keyboard

Amsar a cikin ƙwayar cell C1, inda tsarin shine, nan da nan ya sauya daga 5 zuwa 10, amma dabarar kanta ba canzawa ba.

05 na 08

Masu amfani da ilmin lissafi a cikin Formulas

Samar da samfurori a cikin Shafukan Ɗaukar Fassara na MS Works ba wuya. Yi amfani da bayanan salula na bayananku tare da aikin haɗin lissafi.

Masu amfani da ilmin lissafi da aka yi amfani da su cikin shafukan Bayani mai suna MS Works sunyi kama da waɗanda aka yi amfani da su a cikin lissafin lissafi.

• Ƙididdiga - alamar musa ( - )
• Bugu da kari - da alamar ( + )
• Division - gaba slash ( / )
• Multiplication - alama ( * )
• Exponentiation - caret ( ^ )

Ayyukan Ma'aikata

Idan an yi amfani da afareta ɗaya fiye da ɗaya a wata hanya, akwai takamaiman tsari da MS Works zasu bi don aiwatar da waɗannan ayyukan haɗin lissafi. Wannan tsari na aiki zai iya canza ta ƙara ƙuƙwalwar zuwa lissafin. Hanyar da za ta iya tunawa da tsari na aiki shi ne yin amfani da wannan kalma:

BEDMAS

Dokokin Ayyuka shine:

B rackets
E xponents
D hangen nesa
M rubutun
A ddition
S sancewa

An Bayyana Ma'aikatar Ayyukan Ma'aikata

1. Duk wani aiki (s) da ke ƙunshe cikin ƙuƙwalwa za a gudanar da farko
2. Exponents ana gudanar da na biyu.
3. MS Works ya ɗauki aikin rarraba ko ƙaddamarwa don daidaitaccen mahimmanci, kuma yana ɗaukar waɗannan ayyukan a cikin tsari da suke faruwa a hagu zuwa dama a cikin lissafin.
   
4. MS Works har ila yau yana duba ƙari da haɓaka don daidaitaccen mahimmanci. Kowane wanda ya bayyana a farko a cikin daidaito, ko dai ƙarawa ko raguwa, shine aikin da aka fara a farkon.

06 na 08

Takaddun Shafuka na MS Ayyukan Shafuka: Mataki na 1 na 3 - Shigar da Data

Bari mu gwada misali ta kowane mataki. Za mu rubuta wata hanya mai sauƙi a cikin Ɗab'in ayyukan MS Works don ƙara lambobi 3 + 2.

Mataki na 1: Shigar da bayanai

Zai fi kyau idan ka fara shigar da duk bayananka a cikin shafukan yanar gizo kafin ka fara samar da tsari. Wannan hanyar za ku san idan akwai matsalolin layout, kuma yana da wataƙila za ku buƙaci gyara tsarinku a baya.

Don taimako tare da wannan koyawa na koma zuwa hoton da ke sama.

1. Rubuta 3 a cikin salula A1 kuma danna maballin ENTER akan keyboard.
   
2. Rubuta 2 a cell A2 kuma danna maballin ENTER akan keyboard.

07 na 08

Mataki na 2 na 3: Rubuta a Daidaita (=) Sa hannu

Yayin da kake samar da takamammun a cikin sassan shafukan MS Works, za ku fara da buga alamar daidai. Kuna buga shi a tantanin salula inda kake son amsawa ta bayyana.

Mataki 2 na 3

Don taimako tare da wannan misali koma zuwa hoton da ke sama.

1. Danna kan tantanin halitta C1 (kayyade a baki a cikin hoton) tare da maɓallin linzamin ka.
   
2. Rubuta alamar daidai a cikin cell C1.

08 na 08

Mataki na 3: Ƙara Maɓallin Siffar ta Amfani da Gyara

Bayan buga rubutu daidai a mataki na 2, kuna da zabi biyu don ƙara tantancewar salula a cikin maƙallin lissafi.

1. Zaka iya rubuta su cikin ko,
2. Zaka iya amfani da aikin MS Works wanda ake kira yana nunawa

Bayani yana ba ka dama ka danna tare da linzaminka akan tantanin halitta wanda ke dauke da bayananka don ƙara yawan tantanin salula zuwa tsarin.

Mataki 3 na 3

Ci gaba daga mataki na 2 don wannan misali

1. Danna kan salula A1 tare da maɓallin linzamin kwamfuta
2. Rubuta alamar (+) da (+)
3. Danna maɓallin A2 tare da maɓallin linzamin kwamfuta
4. Danna maballin ENTER akan keyboard
5. Amsar 5 ya kamata ya bayyana a cell C1.

Sauran Bayanai Masu Amfani

• Kayan aiki na Ayyukan Microsoft
• Shafin Farko na Microsoft Works Spreadsheets
• MS Works Workssheets Formulas