MS Works Zowonjezera Mafomu

01 a 08

Mafomu Mwachidule

Mafomu amakulolani kuti muwerenge mawerengedwe pa deta lopangidwa m'masamba anu.

Mungagwiritse ntchito ma fomu apamwamba pazinthu zofunikira, monga kuwonjezera kapena kuchotsa, komanso kuwerengera kovuta kwambiri monga kuchotsera malipiro kapena kupereka zotsatira za mayesero a wophunzira. Mayendedwe mu gawo E mu chithunzi pamwambapa akuwerengetsa yoyamba ya sitolo malonda mwa kuwonjezera malonda kwa mwezi uliwonse.

Kuonjezerapo, ngati mutasintha deta, MS Works adzakonzanso yankho pokhapokha mutayambanso kulowa.

Mitu yotsatirayi ikufotokoza mwatsatanetsatane momwe mungagwiritsire ntchito maonekedwe, kuphatikizapo chitsanzo chotsatira ndi sitepe ya machitidwe a Basic Works MSS.

02 a 08

Kulemba Mndandanda

Kulemba mayina mu MS Works spreadsheets ndi zosiyana kwambiri ndi momwe zimachitikira masamu.

Ntchito ya MS Works ikuyamba ndi chizindikiro chofanana (=) m'malo molimbana nayo.

Chizindikiro chofanana nthawi zonse chimapita mu selo kumene mukufuna yankho lachidule kuti liwonekere.

Chizindikiro chofanana chimawuza MS Works kuti zomwe zikutsatira ndi gawo la ndondomeko, osati dzina kapena nambala chabe.

Ntchito ya MS Works ingakonde izi:

= 3 + 2

m'malo moti:

3 + 2 =

03 a 08

Mafotokozedwe a Mapepala mu Mafomu

Ngakhale kuti njira yowonjezera ikuyendera, ili ndi vuto limodzi. Ngati mukufuna kusintha deta ikuwerengedwa muyenera kusintha kapena kulembetsanso fomuyi.

Njira yabwino ingakhale kulemba ndondomeko kuti muthe kusintha deta popanda kusintha machitidwewo.

Kuti muchite izi, mukhoza kufotokozera deta mu maselo, kenako, muwuzeni MS Ntchito zomwe maselo omwe ali pa spreadsheet deta ili mkati. Malo omwe ali m'chipindalachi amatchulidwa ngati selo yake.

Kuti mupeze mawonekedwe a selo, ingoyang'anani pa mutu wa mutuwo kuti mupeze ndime yomwe selo ilimo, ndi kudutsa kuti mupeze mzere uti umene uli.

Chiwerengero cha selo ndi kuphatikiza kalata ya mzere ndi nambala ya mzere - monga A1 , B3 , kapena Z345 . Mukamalemba ma selo a kalata yanu nthawi zonse zimabwera poyamba.

Kotero, mmalo molemba fomu iyi mu selo C1:

= 3 + 2

lembani izi mmalo mwake:

= A1 + A2

Zindikirani: Pamene mutsegula pa selo lokhala ndi fomu mu MS Works (onani chithunzi pamwambapa), fomuyo imapezeka nthawizonse mu barrale yamtundu yomwe ili pamwamba pa makalata olembedwa.

04 a 08

Kusintha MS Works Spreadsheets Mafomu

Mukamagwiritsa ntchito ma selolo mu MS Works spreadsheet fomu, ndondomekoyi idzasinthidwa pokhapokha ngati deta yolondola ikutha kusintha.

Mwachitsanzo, ngati muzindikira kuti deta mu selo A1 iyenera kukhala 8 m'malo mwa 3, muyenera kusintha zomwe zili mu selo A1.

MS Works amasintha yankholo mu selo C1. Machitidwewo, enieni, sakusowa kusintha chifukwa analembedwa pogwiritsa ntchito mafotokozedwe a selo.

Kusintha deta

1. Dinani pa selo A1
2. Sakani 8
3. Onetsetsani ENTER yowonjezera pa kambokosi

Yankho lake mu selo C1, momwe chiganizocho chiri, nthawi yomweyo amasintha kuchoka pa 5 mpaka 10, koma mawonekedwe omwewo samasintha.

05 a 08

Masamu Ogwira Ntchito mu Mafomu

Kupanga mafomu mu MS Works Spreadsheets sivuta. Ingosinthanitsani mafotokozedwe a maselo a deta yanu ndi olemba masamu oyenera.

Olemba masamu omwe amagwiritsidwa ntchito mu MS Works mapepala apangidwe ali ofanana ndi omwe amagwiritsidwa ntchito mu masamu.

• Kuchotsa - kusayina chizindikiro ( - )
• Kuwonjezera - kuphatikiza chizindikiro ( + )
• Gawani - kutsogolo kutsogolo ( / )
• Kuwonjezeka - asteriski ( * )
• Kutsatsa - chisamaliro ( ^ )

Order of Operations

Ngati oposa angapo akugwiritsidwa ntchito mwachindunji, pali dongosolo lomwe MS Works adzatsatila kuti achite masamu. Kukonzekera uku kwa ntchito kungasinthidwe mwa kuwonjezera makina ku equation. Njira yosavuta kukumbukira dongosolo la ntchito ndikugwiritsa ntchito mawu ofotokozera:

BEDMAS

Order of Operation ndi:

B rackets
E xponents
D ivision
M kuwonjezera
Chidziwitso
S kubweza

Ndondomeko ya Ntchito Yofotokozedwa

1. Opaleshoni iliyonse yomwe ili mu mabakita idzachitidwa poyamba
2. Otsatsa akuchitidwa chachiwiri.
3. MS Works ikuwonetsa ntchito zogawana kapena kuchulukitsa kuti zikhale zofanana, ndipo zimayambitsa ntchitoyi mwadongosolo kuti zichitike kumanzere kumanja.
   
4. MS Works ikuwonanso kuti kuwonjezera ndi kuchotsa kuti ndi kofunikira kwambiri. Chomwe chimakhala choyamba choyamba mu mgwirizano, kaya kuwonjezera kapena kuchotsa, ndiye ntchito yoyamba.

06 ya 08

MS Works Spreadsheets Mauthenga Othandizira: Khwerero 1 pa 3 - Kulowa Deta

Tiyeni tiyese chitsanzo cha mapazi ndi mapazi. Tilembera mankhwala ophweka mu MS Ntchito spreadsheet kuti uwonjezere nambala 3 + 2.

Khwerero 1: Kulowa deta

Ndi bwino ngati mutangotumiza deta yanu yoyamba mu spreadsheet musanayambe kupanga mawonekedwe. Momwemo mudzadziwira ngati pali mavuto aliwonse, ndipo simukufunikira kusintha njira yanu pamapeto pake.

Kuti chithandizo ndi phunziroli chikuwonetse chithunzi pamwambapa.

1. Lembani 3 mu selo A1 ndikusindikizira ENTER kwachinsinsi pa kambokosi.
   
2. Lembani 2 mu selo A2 ndikusindikizira ENTER mzere pa makiyi.

07 a 08

Gawo 2 lachitatu: Lembani mu Equal (=) Sign

Pogwiritsa ntchito malemba mu MS Works Spreadsheets, INUYAMBIRA kuyambira pakulemba chizindikiro chofanana. Mukuzijambula mu selo kumene mukufuna yankho liwonekere.

Gawo 2 pa 3

Thandizo ndi chitsanzo ichi likutanthauza chithunzi pamwambapa.

1. Dinani pa selo C1 (yofotokozedwa wakuda mu chithunzi) ndi pointer wanu mouse.
   
2. Sakani chizindikiro chofanana mu selo C1.

08 a 08

Gawo 3: Kuwonjezera Mafotokozedwe a Cell Pogwiritsa Ntchito Kujambula

Pambuyo polemba chizindikiro chofanana mu sitepe yachiwiri, muli ndi zisankho ziwiri zoonjezera zizindikiro za selo pa fomu ya spreadsheet.

1. Mutha kuzilemba kapena,
2. Mukhoza kugwiritsa ntchito chipangizo cha MS Works chotchedwa kukopa

Kulongosola kumakulolani kuti muchoke ndi ndondomeko yanu mu selo yomwe ili ndi deta yanu kuti muwonjezere selo yake yowonjezeredwa ndi ndondomekoyi.

Gawo 3 pa 3

Kupitiliza pa gawo 2 pa chitsanzo ichi

1. Dinani pa selo A1 ndi pointer ya mouse
2. Lembani chizindikiro chowonjezera (+)
3. Dinani pa selo A2 ndi pointer ya mouse
4. Onetsetsani ENTER yowonjezera pa kambokosi
5. Yankho lachisanu liyenera kuoneka mu selo C1.

Zina Zofunikira Zothandiza

• Mkonzi Woyambitsa Ntchito wa Microsoft
• Microsoft Works Spreadsheets Tutorial
• MS Works Zowonjezera Mafomu