Vula izifundo ze-Office Calc Basic Spreadsheet

I-Open Office Calc, uhlelo lwe-electronics lwespredishithi olunikezwa mahhala nge-openoffice.org. Lolu hlelo kulula ukuyisebenzisa futhi luqukethe kakhulu, uma kungenjalo konke okusetshenziselwa ukutholakala okutholakala kuzipredishithi ezifana ne-Microsoft Excel.

Lokhu kufundisa kuhlanganisa izinyathelo zokudala ispredishithi eyisisekelo ku-Open Office Calc.

Ukugcwalisa izinyathelo ezihlokweni ezingezansi kuzokhipha ispredishithi efana nesithombe ngenhla.

01 ka 09

Izihloko zezifundo

Ezinye izihloko ezizohlanganiswa:

• Ukungeza idatha kuspredishithi
• Ukwandisa Amakholomu
• Ukwengeza Umsebenzi Usuku kanye negama legama
• Ukungeza amafomula
• Iguqula ukulungiswa kwedatha kumaseli
• Ukufometha kwenombolo - amaphesenti kanye nemali
• Ukushintsha umbala wangemuva weseli
• Ukushintsha umbala wefonti

02 ka 09

Ukufaka idatha ku-Open Office Calc

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.

Ukufaka idatha kuspredishithi kuhlale kuyinkqubo yesinyathelo esithathu. Lezi zinyathelo ziyi:

1. Chofoza kuseli lapho ufuna khona idatha.
   
2. Thayipha idatha yakho kuseli.
   
3. Cindezela inkinobho ENTER ekhibhodi noma chofoza kwesinye iseli negundane.

Kulesi sifundo

Ukuze ulandele le tutorial, faka idatha efakwe kuhlu ngezansi kuspredishithi elingenalutho usebenzisa izinyathelo ezilandelayo:

1. Vula ifayela le-spreadsheet elingenalutho.
   
2. Khetha iseli elikhonjisiwe ngereferensi yeseli enikeziwe.
   
3. Thayipha idatha ehambelanayo esitokisini esikhethiwe.
   
4. Cindezela ukhiye wokungena kwikhibhodi noma uchofoze esiteleni esilandelayo ohlwini olunegundane.

Idatha yeselula

Izibalo ze-A2 - Ukukhishwa Kwezisebenzi Kwabasebenzi A8 - Igama Lokugcina A9 - Smith B. A10 - Wilson C. A11 - Thompson J. A12 - James D.

B4 - Usuku: B6 - Isilinganiso sokukhishwa: B8 - Imali eyinzuzo B9 - 45789 B10 - 41245 B11 - 39876 B12 - 43211

I-C6 - .06 C8 - Ukukhishwa kwe-D8 - Inkokhelo Net

Buyela ekhasini le-Index

03 ka 09

Ukwandisa Amakholomu

Ukwandisa Amakholomu ku-Open Office Calc:

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.

Ngemva kokufaka idatha cishe uzothola ukuthi amagama amaningana, njengokuDeduction, avulekile kakhulu ngeseli. Ukulungisa lokhu ukuze igama lonke libonakale:

1. Beka isikhombisi segundane emgqeni phakathi kwamakholomu C no-D enhlokweni yekholomu .
   
2. I-pointer izoshintshela kumcibisholo ophethwe kabili.
   
3. Chofoza inkinobho yegundane lesokunxele bese uhudula umcibisholo ohlosiwe kabili ngakwesokudla ukwandisa ikholomu C.
   
4. Vula amanye amakholomu ukuze ubonise idatha njengoba kudingeka.

Buyela ekhasini le-Index

04 ka 09

Ukwengeza Usuku Negama Lobuningi

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.

Kuyinto evamile ukwengeza idethi kuspredishithi. Yakhiwe e-Open Office Calc yimibolo yeDATE imisebenzi engasetshenziselwa ukwenza lokhu. Kulesi sifundo sizosebenzisa umsebenzi we-TODAY.

1. Chofoza kuseli C4.
   
2. Thayipha = NAMUHLA ()
   
3. Cindezela inkinobho ENTER ekhibhodi.
   
4. Idethi yamanje kufanele ivele kuseli C4

Ukwengeza igama lamagama ku-Open Office Calc

1. Khetha iseli C6 kuspredishithi .
   
2. Chofoza ebhokisini legama .
   
3. Thayipha "isilinganiso" (ayikho izingcaphuno) ebhokisini legama.
   
4. I-Cell C6 manje inegama "isilinganiso". Sizosebenzisa igama ukwenza kube lula ukwenza amafomula kusinyathelo esilandelayo.

Buyela ekhasini le-Index

05 ka 09

Ukungeza Amafomula

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.

1. Chofoza kuseli C9.
   
2. Thayipha isilinganiso sefomula = B9 * bese ucindezela ukhiye we- Enter ekhibhodi.

Ukubala umholo wenetha

1. Chofoza kuseli D9.
   
2. Thayipha kwifomula = B9 - C9 bese ucindezela ukhiye we- Enter ekhibhodi.

• Imininingwane yefomula eyengeziwe:
  Vula izifundo ze-Office Calc Formulas

Ukukopisha amafomula kumaseli C9 no-D9 kwamanye amaseli:

1. Chofoza kuseli seli C9 futhi.
   
2. Hambisa isikhombisi segundane phezu kwesibambo sokugcwalisa (i-dot encane encane) ekhoneni elingezansi elingakwesokudla leseli esebenzayo .
   
3. Lapho inkomba ishintshe "uphawu olulodwa" olumnyama, chofoza bese ubamba inkinobho yegundane lesokunxele bese uhudula isibambo sokugcwalisa phansi kweseli C12. Ifomula ku-C9 izokopishwa kumaseli C10 - C12.
   
4. Chofoza kuseli D9.
   
5. Phinda izinyathelo 2 no-3 bese uhudula isibambo sokugcwalisa phansi kweselula D12. Ifomula ku-D9 izokopishwa kumaseli D10 - D12.

Buyela ekhasini le-Index

06 ka 09

Ukuguqula ukulungiswa kwedatha

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla. Futhi, uma ufaka igundane lakho phezu kwesithonjana kubha yamathuluzi, igama lesithonjana lizoboniswa.

1. Hudula ukhethe amaseli A2 - D2.
   
2. Chofoza ku- Iqoqo lezingqamuzana zezithonjana kwibha yamathuluzi yokufometha ukuze uhlanganise amaseli akhethiwe.
   
3. Chofoza ku- Isikhungo Soxhumano Sokuzenzekelayo kwi- Barbar yamathuluzi okufometha ukuze ubeke isihloko kulo lonke indawo ekhethiwe.
   
4. Hudula ukhethe amaseli B4 - B6.
   
5. Chofoza ku-I-icon yokukhetha kwesokudla kwesokudla kwibha yamathuluzi yokufometha ukuze uvumelanise idatha kulezi maseli.
   
6. Hudula ukhethe amaseli A9 - A12.
   
7. Chofoza ku-I-icon yokuqondisa ngakwesokudla kwibha yamathuluzi yokufometha ukuze uvumelanise idatha kulezi maseli.
   
8. Hudula ukhethe amaseli A8 - D8.
   
9. Chofoza ku- Isikhungo Soxhumano Sokuzenzekelayo kwi- Barbar yamathuluzi okufometha ukuze ubeke idatha kulawa maseli.
   
10. Hudula ukhethe amaseli C4 - C6.
    
11. Chofoza ku- Isikhungo Soxhumano Sokuzenzekelayo kwi- Barbar yamathuluzi okufometha ukuze ubeke idatha kulawa maseli.
    
12. Hudula ukhethe amaseli B9 - D12.
    
13. Chofoza ku- Isikhungo Soxhumano Sokuzenzekelayo kwi- Barbar yamathuluzi okufometha ukuze ubeke idatha kulawa maseli.

07 ka 09

Ukwengeza ukufometha kwenombolo

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla. Futhi, uma ufaka igundane lakho phezu kwesithonjana kubha yamathuluzi, igama lesithonjana lizoboniswa.

Ukufometha kwenombolo kubhekisela ekungezeni izimpawu zemali, izimpawu zamadesimali, izimpawu zamaphesenti, nezinye izimpawu ezisiza ukukhomba uhlobo lwedatha ekhona esitokisini nokukwenza kube lula ukufunda.

Kulesi sinyathelo sinezela izimpawu zamaphesenti namaphesenti emali kudoti lethu.

Ukungeza i-Sign percentage

1. Khetha iseli C6.
   
2. Chofoza kuFomathi Yombolo: Isithonjana sephesenti kubha yamathuluzi okufometha ukuze ungeze uphawu lwamaphesenti kumakhalekhukhwini akhethiwe.
   
3. Chofoza kuFomathi Yombolo: Susa isithonjana seDesimali endaweni yebha yamathuluzi yokufomatha kabili ukuze ususe izindawo ezimbili zesidali.
   
4. Idatha engqamuzaneni C6 kufanele ifunde manje njengo-6%.

Ukungeza i-Symbol yeMali

1. Hudula ukhethe amaseli B9 - D12.
   
2. Chofoza kuFomathi Yombolo: Isithonjana seMali kubha yamathuluzi okufometha ukuze ungeze isignali yama dollar kumaseli akhethiwe.
   
3. Idatha kumaseli B9 - D12 kufanele manje ibonise uphawu lwedola ($) nezindawo ezimbili zedesimali.

Buyela ekhasini le-Index

08 ka 09

Ukushintsha umbala wangemuva weseli

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla. Futhi, uma ufaka igundane lakho phezu kwesithonjana kubha yamathuluzi, igama lesithonjana lizoboniswa.

1. Hudula ukhethe amaseli A2 - D2 kuspredishithi.
   
2. Chofoza kusithonjana sombala sangemuva ku- Barbar yamathuluzi okufometha (kubonakala sengathi upende ungakwazi) ukuvula uhlu oludonsela phansi lombala.
   
3. Khetha uLwandle Oluhlaza okwesibhakabhaka kusuka kuhlu ukuze ushintshe umbala wangemuva wamaseli A2 - D2 kuya eluhlaza okwesibhakabhaka.
   
4. Hudula ukhethe amaseli A8 - D8 kuspredishithi.
   
5. Phinda izinyathelo 2 no-3.

Buyela ekhasini le-Index

09 ka 09

Ukushintsha Umbala Wefonti

Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla. Futhi, uma ufaka igundane lakho phezu kwesithonjana kubha yamathuluzi, igama lesithonjana lizoboniswa.

1. Hudula ukhethe amaseli A2 - D2 kuspredishithi.
   
2. Chofoza kusithonjana sombala wefonti kubha yamathuluzi wokufometha (kuyincwadi enkulu "A") ukuvula uhlu lwezintambo zombala wefonti.
   
3. Khetha Okumhlophe ohlwini ukuze ushintshe umbala wombhalo kumaseli A2 - D2 kuya kumhlophe.
   
4. Hudula ukhethe amaseli A8 - D8 kuspredishithi.
   
5. Phinda izinyathelo 2 no-3 ngenhla.
   
6. Hudula ukhethe amaseli B4 - C6 kuspredishithi.
   
7. Chofoza ku-Isithonjana sombala wefonti kubha yamathuluzi okufometha ukuze uvule uhlu lwezintandokazi zombala wefonti.
   
8. Khetha uLwandle Oluhlaza okwesibhakabhaka kusuka ohlwini ukuze ushintshe umbala wombhalo emafonini B4 - C6 kuya eluhlaza okwesibhakabhaka.
   
9. Hudula ukhethe amaseli A9 - D12 kuspredishithi.
   
10. Phinda izinyathelo 7 no-8 ngenhla.
    
11. Kuleli phuzu, uma ulandele zonke izinyathelo zalesi sifundo ngendlela efanele, ispredishithi sakho kufanele sifane nespredishithi efanekisiwe kuNyathelo 1 yalesi sifundo.

Buyela ekhasini le-Index