Vula iHhovisi le-Ofisi yeCart Basic Basicreadsheet

I-Open Office Calc, inkqubo yespredishithi yecomputer inikezwa ngentlawulo nge-openoffice.org. Inkqubo kulula ukuyisebenzisa kwaye iqulethe kakhulu, ukuba ayinayo yonke impawu esetyenziswa ngokuqhelekileyo ezifumaneka kwizipredishithi ezifana ne-Microsoft Excel.

Le tutorial ihlanganisa amanyathelo okudala ispredishithi esisisiseko kwi-Open Office Calc.

Ukugqiba amanyathelo kwizihloko ezingezantsi kuza kuvelisa ispredishithi esifana nomfanekiso ongentla.

01 ka 09

Izihloko zeTutorial

Ezinye izihloko eziza kuhlanganiswa:

• Ukongeza idatha kwi-spreadsheet
• Ukwandisa iikholam
• Ukongeza uMsebenzi weMini kunye neNombolo yegama
• Ukongeza iifomula
• Ukutshintsha ukulungelelaniswa kwedatha kwiiseli
• Ukufometha kwamanani - iipesenti kunye nemali
• Ukutshintsha umbala wesiqalo seseli
• Ukutshintsha umbala wefonti

02 we-09

Ukufaka iDatha kwi-Open Office Calc

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Ukungena kwedatha kwi- spreadsheet kuhlala kukho inkqubo yesinyathelo esithathu. La manyathelo:

1. Cofa kwiseli apho ufuna idatha ihambe khona.
   
2. Thayipha idatha yakho kwiseli.
   
3. Cinezela ENTER iqhosha kwikhibhodi okanye nqakraza kwelinye iseli kunye nemouse.

Kule khokelo

Ukulandela le khosi, faka idatha echazwe ngezantsi kwi-spreadsheet engenanto isebenzisa amanyathelo alandelayo:

1. Vula ingqalileyo yefayile yefayile yespredishithi.
   
2. Khetha iseli eboniswe yereferensi yeseli enikeziwe.
   
3. Thayipha idatha ehambelanayo kwiseli ekhethiweyo.
   
4. Cindezela ukhiye wokungena kwibhodibhodi okanye nqakraza kwiseli elandelayo kuloluhlu kunye nemouse.

Data Cell

I-A2 - Izibalo zokukhutshwa kwabasebenzi A8 - Igama lokugqibela A9 - Smith B. A10 - Wilson C. A11 - Thompson J. A12 - James D.

B4 - Umhla: B6 - Ireyithi yokukhutshwa: B8 - Umvuzo omkhulu B9 - 45789 B10 - 41245 B11 - 39876 B12 - 43211

C6 - .06 C8 - Ukuhlaziywa kwe-D8 - Net Salary

Buyela kwi Index Index

03 ka 09

Ukwandisa iikholam

Ukwandisa iikholam e-Open Office Calc:

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Emva kokungena kwedatha uya kufumana ukuba amagama amaninzi, afana nokuDeduction , aphezulu kakhulu kwiseli. Ukulungisa le nto ukuze igama lonke libonakala:

1. Beka isalathisi se mouse kwimgca phakathi kwamakholomu C no-D kwintloko yekholomu .
   
2. I-pointer izakuguqula kwisicatshulwa esiphambili.
   
3. Cofa ngekhompi ye mouse kwaye uhudule iintolo eziphezu kabini ukuya ngasekunene ukwandisa ikholomu C.
   
4. Yandisa amanye amakholomu ukubonisa idatha njengoko kuyimfuneko.

Buyela kwi Index Index

04 we-09

Ukongeza Umhla kunye negama legama

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Kuqhelekile ukuba ungeze usuku kwi-spreadsheet. Eyakhelwe kwi-Open Office Calc yimizuzu yemisebenzi ka-DATE engasetyenziselwa ukwenza oku. Kule tutorial siya kusebenzisa umsebenzi we-TODAY.

1. Cofa kwiseli C4.
   
2. Uhlobo = TODAY ()
   
3. Cinezela i- ENTER iqhosha kwikhibhodi.
   
4. Umhla okwangoku kufuneka uvele kwiseli C4

Ukongeza igama lomgama kwi-Open Office Calc

1. Khetha iseli C6 kwispredishithi .
   
2. Cofa kwiBhokisi legama .
   
3. Thayipha "umlinganiselo" (akukho zicaphulo) kwiBhokisi legama.
   
4. I-Cell C6 ngoku inegama "inqanaba". Siza kusebenzisa igama ukwenza lula ukwenza amafomula kwisinyathelo esilandelayo.

Buyela kwi Index Index

05 ka 09

Ukongeza iifomula

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

1. Cofa kwiseli C9.
   
2. Thayipha kwi-formula = B9 * umlinganiselo kwaye cinezela ukhiye wokungena kwikhibhodi.

Ukubala umvuzo wenetha

1. Cofa kwiseli D9.
   
2. Thayipha kwifom = = B9 - C9 uze ucinezela ukhiye wokungena kwikhibhodi.

• Ulwazi olongezelelweyo lwefom:
  Vula iHhovisi le-Calc Formulas Tutorial

Ukukopisha iifomula kwiiseli C9 no-D9 kwezinye iiseli:

1. Cofa kwiseli C9 kwakhona.
   
2. Hambisa i-pointer ye mouse phezu kwesibambo sokugcwalisa (i-dot encane encane) ekhoneni elingezantsi lasekuneni leseli esebenzayo .
   
3. Xa i-pointer iguqula "uphawu oludibanisa" olumnyama, nqakraza ubambe inkinobho yemouse ekhohlo uze udibanise isibambo sokugcwalisa phantsi kwiseli C12. Ifom e C9 iya kukopishwa kwiiseli C10 - C12.
   
4. Cofa kwiseli D9.
   
5. Phinda amanyathelo 2 no-3 uze udibanise isibambo sokugcwalisa phantsi kwiseli D12. Ifom e D9 iya kukopishwa kwiiseli D10 - D12.

Buyela kwi Index Index

06 ka 09

Ukutshintshwa kwedatha Ukulungelelaniswa

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla. Kwakhona, ukuba ubeka imouse yakho phezu kwesithonjana kwibar yamathuluzi, igama legama liza kuboniswa.

1. Hudula ukhethe iiseli A2 - D2.
   
2. Cofa kwi- Merge Iiselingi ze icon kwiBar yokufakela ibar yo kudibanisa iiseli ezikhethiweyo.
   
3. Cofa kwi- Idibaniso yokuHlanganisa i- icon ngokuzenzekelayo kwi- Barbar yokufomathiza ukuFometha ukubeka isihloko kwisihloko esikhethiweyo.
   
4. Hudula ukhethe iiseli B4 - B6.
   
5. Cofa kwi-icon yokulungelelanisa i- icon kwifayile yefomathi yokufometha ngokufanelekileyo ukulungelelanisa idatha kule seli.
   
6. Hudula ukhetha iiseli A9 - A12.
   
7. Cofa kwi- Ilungelo lelungelo lelungelo kwibharki yefayile yokufometha ngokufanelekileyo ukulungelelanisa idatha kule seli.
   
8. Hudula ukhethe iiseli ze-A8-D8.
   
9. Cofa kwi- Idibaniso yokuHlanganisa i- icon ngokuzenzekelayo kwi- Barbar yefomathi yokufometha ukusekwa kwedatha kule seli.
   
10. Hudula ukhethe iiseli C4-C6.
    
11. Cofa kwi- Idibaniso yokuHlanganisa i- icon ngokuzenzekelayo kwi- Barbar yefomathi yokufometha ukusekwa kwedatha kule seli.
    
12. Hudula ukhethe iiseli B9 - D12.
    
13. Cofa kwi- Idibaniso yokuHlanganisa i- icon ngokuzenzekelayo kwi- Barbar yefomathi yokufometha ukusekwa kwedatha kule seli.

07 ka 09

Ukongeza ifomathi yeSombululo

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla. Kwakhona, ukuba ubeka imouse yakho phezu kwesithonjana kwibar yamathuluzi, igama legama liza kuboniswa.

Ukufometha kweenombolo kubhekiselele kwongezwa kweempawu zeemali, iimpawu zokugqibela, iimpawu zeepesenti kunye nezinye iimpawu ezikunceda ukuchonga uhlobo lweenkcukacha ezikhoyo kwiseli kwaye zenze kube lula ukufunda.

Kule nyathelo songeza iimpawu zeepesenti kunye neemali kwiedatha zethu.

Ukongeza uphawu lwepesenti

1. Khetha iseli C6.
   
2. Cofa kwiFomathi yeNombolo: Ikhonkco yeepesenti kwiBrawu yefayile yokuFometha ukufaka uphawu lwepesenti kwiseli ekhethiweyo.
   
3. Cofa kwiFomathi yeNombolo: Cima uphawu lweDisimal Place kwiBar yokufakela ibar yesibili ukususa iindawo ezimbini zokugqibela.
   
4. Idatha kwiseli C6 kufuneka ifunde ngoku njengama-6%.

Ukongeza iMpawu yeMali

1. Hudula ukhethe iiseli B9 - D12.
   
2. Cofa kwiFomathi Yombolo: I icon yeMali kwiBar yokutyekisa ifayile yokongeza isibonakaliso se dola kwiiseli ezikhethiweyo.
   
3. Idata kwiiseli B9 - D12 kufuneka ngoku ibonise isimboli sedoli (iirekhodi) kunye neendawo ezimbini zokugqibela.

Buyela kwi Index Index

08 ka 09

Ukutshintsha umbala wesiqalo seseli

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla. Kwakhona, ukuba ubeka imouse yakho phezu kwesithonjana kwibar yamathuluzi, igama legama liza kuboniswa.

1. Hudula ukhethe iiseli A2-D2 kwispredishithi.
   
2. Cofa kwi icon Yembala Yemvelaphi kwiBraw toolbar (ifana nepeyinti ingakwazi) ukuvula uluhlu lwembala engezantsi.
   
3. Khetha uLwandle oluBluhlaza ukusuka kuloluhlu ukutshintsha umbala wangasemva weeseli A2 - D2 kwi-blue.
   
4. Hudula ukhethe iiseli ze- A8-D8 kwispredishithi.
   
5. Phinda amanyathelo 2 no-3.

Buyela kwi Index Index

09 we 09

Ukutshintsha Umbala Wefonti

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla. Kwakhona, ukuba ubeka imouse yakho phezu kwesithonjana kwibar yamathuluzi, igama legama liza kuboniswa.

1. Hudula ukhethe iiseli A2-D2 kwispredishithi.
   
2. Cofa kwi icon ye- Font Color kwiBhayilethi yefayile yokufometha (yincwadi enkulu "A") ukuvula uluhlu lwebala lomnxeba.
   
3. Khetha Uluhlu oluluhlu ukutshintsha umbala weetekisi kwiiseli A2 - D2 ukuya kumhlophe.
   
4. Hudula ukhethe iiseli ze- A8-D8 kwispredishithi.
   
5. Phinda amanyathelo 2 no-3 ngaphezulu.
   
6. Hudula ukhethe iiseli B4-C6 kwi-spreadsheet.
   
7. Cofa kwi icon ye- Font Color kwiBhayilethi yefayile yokuFometha ukuvula uluhlu lwebala lomnxeba.
   
8. Khetha uLwandle oluLwandle oluluhlu kuloluhlu ukutshintsha umbala weetekisi kwiiseli ze-B4-C6 ukuya eluhlaza.
   
9. Hudula ukhethe iiseli ze- A9-D12 kwispredishithi.
   
10. Phinda amanyathelo 7 no-8 ngentla.
    
11. Kule ngongoma, ukuba ulandele onke amanyathelo okufundisa ngokuchanekileyo, ispredishithi sakho sifane ne-spreadsheet eboniswe kwiNyathelo 1 yale khokelo.

Buyela kwi Index Index