Open Office Calc Basic Spreadsheet Tutori

Open Office Calc, chirongwa chemagetsi chepurogiramu chinopiwa pachena pasina openoffice.org. Purogiramu yacho iri nyore kushandisa uye ine zvakawanda, kana isiri iyo yese inowanzoshandiswa inowanika mumapapiritsi akadai seMicrosoft Excel.

Iyi tutori inosanganisira matanho ekugadzira pepadheti yekutanga mu Open Office Calc.

Kuzadza matanho ari mumusoro ari pasi apa kuchabudisa safurasi yakafanana nemufananidzo uri pamusoro.

01 ye 09

Zvidzidzo Misoro

Mimwe misoro ichave yakafukidzwa:

• Kuwedzera dhidhiro kune pepasiteteti
• Kuwedzera Columns
• Kuwedzera zuva reMabasa uye Range Range
• Kuwedzera mafomu
• Kuchinja kudanana kwemasero mumasero
• Nhamba dzemaitiro - peresita uye mari
• Kushandura ruvara rwemashure
• Kushandura fonti ruvara

02 of 09

Kupinda Dhavhima mu Open Office Calc

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Kuisa dhipatimendi muchiparidziro inogara iri danho rechitatu. Aya matanho ndeokuti:

1. Dzvanya pane sero apo iwe unoda kuti data iende.
   
2. Nyora yako data muyero.
   
3. Dhinda iri ENTER kiyi pane keyboard kana tora pane imwe sero ine mouse.

Nokuda kweikudzidzisa iyi

Kuti uite izvi, tumira mazita akarongwa pasi apa muchiparidzi chakashama uchishandisa matanho anotevera:

1. Vhura pasina chinyorwa Calc spreadsheet file.
   
2. Sarudza sero rinoratidzwa nesero rinoshandiswa rakapiwa.
   
3. Tora iyo yakakodzana nedzimwe mujecha rakasarudzwa.
   
4. Dhinda pikicha inopinda mubhobhoyo kana chengetera pane imwe sero iri mumutsetse ne mouse.

Cell Data

A2 - Kuverenga Kunotswa Kwevashandi A8 - Zita Rokupedzisira A9 - Smith B. A10 - Wilson C. A11 - Thompson J. A12 - James D.

B4 - Zuva: B6 - Mubairo Wokutsvaga: B8 - Mhuri Yakawanda B9 - 45789 B10 - 41245 B11 - 39876 B12 - 43211

C6 - .06 C8 - Kubviswa D8 - Net Salary

Dzokera ku Index Index

03 of 09

Kuwedzera Columns

Kuwedzera Ma Columns mu Open Office Calc:

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Mushure mokupinda munharaunda iwe uchaona kuti mamwe mazita, akadai seDeduction , akawandisa kune sero. Kugadzirisa izvi kuitira kuti shoko rose rionekwe:

1. Isa iyo pointer ye mutsara pamuganhu pakati pemakoronike C uye D mumutsetse wemusoro .
   
2. Iyo pointer ichashandura kune mutsara wepamusoro-kaviri.
   
3. Dzvanya nebhokisi reboshwe uye shandisai museve wepamusoro-kuru kurudyi kuti uwedzere chinyorwa C.
   
4. Wedzera mamwe ma column kuti aratidze data sezvinodiwa.

Dzokera ku Index Index

04 of 09

Kuwedzera Zuva uye Range Range

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Zvinowanzoita kuti kuwedzerwa zuva racho kune spreadsheet. Inovakwa muOfree Office Calc inoverengeka DATE mabasa anogona kushandiswa kuita izvi. Muchidzidzo ichi tichashandisa TODAY basa.

1. Dzvanya pane cell C4.
   
2. Tanga = TODAY ()
   
3. Dhinda iri ENTER kiyi pane keyboard.
   
4. Zuva razvino rinofanira kuonekwa muchitokisi C4

Kuwedzera Range Range mu Open Office Calc

1. Sarudza sero C6 mudapiritsi .
   
2. Dzvanya paBhokisi Razita .
   
3. Tora "purogiramu" (hapana zvinyorwa) muZita reBhokisi.
   
4. Cell C6 iye zvino ine zita re "chiyero". Tichashandisa zita kuti tive nyore kuita zvigadziro mune danho rinotevera.

Dzokera ku Index Index

05 of 09

Kuwedzera maforomu

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

1. Dzvanya pane cell C9.
   
2. Tora mu formula = B9 * muzinga uye pinda paImpikicha pabhodhi.

Kuverenga misha yemari

1. Dzvanya pane cell D9.
   
2. Tora mu formula = B9 - C9 uye tapindura kuIta yekiyo pabhokisi.

• Zvimwe zveruzivo runyaya:
  Open Office Calc Formulas Tutorial

Kunyora mafomu mumasero C9 uye D9 kune mamwe masero:

1. Dzvanya pane cell C9 zvakare.
   
2. Tungamira mutsara weguru pamusoro pemiti yekuzadza (a small black dot) muzasi kwekona yekona yebasa rinoshanda .
   
3. Apo pointer inoshandura kune rimwe dhi "pamwe chete chiratidzo", dika uye ubatisise ibhokisi rezasi re mouse uye dhonza gadzazadza pasi pasi pane cell C12. Izvo zvinyorwa mu C9 zvichakopihwa kumasero C10 - C12.
   
4. Dzvanya pane cell D9.
   
5. Dzokorora matanho 2 ne3 uye wedhonza gadziriro yekuzadza pasi kune cell D12. Nzira iri muD9 ichakopwa kumasero D10 - D12.

Dzokera ku Index Index

06 of 09

Kuchinja Dhigiriro Dhidhiyo

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro. Saizvozvowo, kana iwe ukaisa mouse yako pamusoro pechiratidzo pane imwe mudziyo, zita rezita racho richaratidzwa.

1. Dragodza masero A2 - D2.
   
2. Dzvanya paKunganisa Mhedziso icon paBuritsa toolbar yekubatanidza masero akasarudzwa.
   
3. Dzvanya paIndaneti Pakugarisa pane imwe mufananidzo paGwaro Rakadzika rekushandisa kuti uise musoro wepakati munzvimbo yakasarudzwa.
   
4. Draganisa sarudza masero B4 - B6.
   
5. Dzvanya paGadziriro yezvakarurama chinodiwa pane yeBuritsa toolbar kuti ugadzirise zvakakodzera data iri mumasero.
   
6. Draganisa sarudza masero A9 - A12.
   
7. Dzvanya paAkabatanidza chiratidzo chekuona pane Bhizimisi rebarimi kuti ugadzire zvakakodzera data iri mumaseli.
   
8. Dragodza masero A8 - D8.
   
9. Dzvanya paChipatoreri Chigarire Chiratidzo pane Chimiro Chekushandisa chekushandisa kuti uise deta iri mumasero.
   
10. Dragodza masero C4 - C6.
    
11. Dzvanya paChipatoreri Chigarire Chiratidzo pane Chimiro Chekushandisa chekushandisa kuti uise deta iri mumasero.
    
12. Draganisa sarudza masero B9 - D12.
    
13. Dzvanya paChipatoreri Chigarire Chiratidzo pane Chimiro Chekushandisa chekushandisa kuti uise deta iri mumasero.

07 of 09

Kuwedzera Kufomesa Nhamba

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro. Saizvozvowo, kana iwe ukaisa mouse yako pamusoro pechiratidzo pane imwe mudziyo, zita rezita racho richaratidzwa.

Nhamba yehuwandu hwemhando inoreva kuwedzerwa kwezviratidzo zvemari, decimal markers, percent zviratidzo, nezvimwe zviratidzo zvinobatsira kuziva rudzi rwe data riripo muchitokisi uye kuti zvive nyore kuverenga.

Munhanho iyi tinowedzera mazana zviratidzo nezviratidzo zvemari kune data yedu.

Kuwedzera Chiratidzo chePentcent

1. Sarudza sero C6.
   
2. Dzvanya Purogiramu Yenhamba: Pikicha yePentcent pane Bhuku rekushandisa rekugadzirisa kuwedzera purosi yechipikisi kune imwe sero yakasarudzwa.
   
3. Dzvanya pa Fomu Yechiverengero
   
4. Iyo data iri muchitokisi C6 inofanira kuverengwa zvino se 6%.

Kuwedzera Mari Yechiratidzo

1. Draganisa sarudza masero B9 - D12.
   
2. Dzvanya kuFomende yeNhamba: Dhiyabhorosi icon pane Bhuku rekushandisa rekuita kuti uwedzere chiratidzo chemadhora kune masero akasarudzwa.
   
3. Nhamba iri mumasero B9 - D12 inofanira kunge ichinyanya kuratidza chiratidzo chemadhora ($) uye mbiri nzvimbo dzepamusoro.

Dzokera ku Index Index

08 of 09

Kushandura ruvara rwemashure

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro. Saizvozvowo, kana iwe ukaisa mouse yako pamusoro pechiratidzo pane imwe mudziyo, zita rezita racho richaratidzwa.

1. Draganisa sarudza masero A2 - D2 pane spreadsheet.
   
2. Dzvanya neCheto Rakavara icon pane Chimiro chebarimiro (rinoratidzika sepende rinogona) kuzarura ruvara rwemukati rutsika pasi.
   
3. Sarudza Gungwa Dzvuku kubva pakurongwa kuti uchinje ruvara rwemukati wemasero A2 - D2 kusvika kubhuruu.
   
4. Draganisa sarudza masero A8 - D8 pane spreadsheet.
   
5. Dzokorora matanho 2 ne3.

Dzokera ku Index Index

09 of 09

Changing Color Font

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro. Saizvozvowo, kana iwe ukaisa mouse yako pamusoro pechiratidzo pane imwe mudziyo, zita rezita racho richaratidzwa.

1. Draganisa sarudza masero A2 - D2 pane spreadsheet.
   
2. Kira pa Font Font icon pane Formatting toolbar (iri tsamba huru "A") kuti uzarure rudzi rwemapurusi ruka pasi.
   
3. Sarudza Muchena kubva pane urongwa kuti uchinje ruvara rwemavara mumasero A2 - D2 kusvika kuchena.
   
4. Draganisa sarudza masero A8 - D8 pane spreadsheet.
   
5. Dzokorora matanho 2 ne3 pamusoro.
   
6. Dragedza sarudza masero B4 - C6 pane spreadsheet.
   
7. Dzvanya paIndaneti Mufananidzo wepaImbaji paBuritsa toolbar kuti uzarure ruvara rwemapurusi ruka pasi.
   
8. Sarudza Gungwa Dzvuku kubva pakurongwa kuti uchinje ruvara rwemavara mumasero B4-C6 kusvika kubhuruu.
   
9. Draganisa sarudza masero A9 - D12 pane pepanheti.
   
10. Dzokorora matanho 7 ne8 pamusoro.
    
11. Panguva ino, kana iwe wakatevera matanho ose emudzidzisi uyu nenzira yakakodzera, shanduro yako inofanira kufanana nespredishiti inoratidzwa muChitatu 1 chekudzidzisa.

Dzokera ku Index Index