Tsegulani Zolemba Zachikulu Zowonjezera Maofesi

Open Office Calc, ili ndi pulogalamu yamakono yowonjezera operekedwa ndiulere openoffice.org. Pulogalamuyi ndi yophweka kugwiritsira ntchito ndipo ili ndi zambiri, ngati sizinthu zonse zomwe zimagwiritsidwa ntchito kawirikawiri zomwe zimapezeka m'masamba monga Microsoft Excel.

Phunziroli limaphatikizapo masitepe opanga spreadsheet yofunikira ku Open Office Calc.

Kukwaniritsa masitepe omwe ali m'munsimu kudzatulutsa sepirititi yofanana ndi chithunzi pamwambapa.

01 ya 09

Mitu Yophunzitsa

Mitu ina yomwe idzaphimbidwa:

• Kuwonjezera deta ku spreadsheet
• Kukulitsa Ma Columns
• Kuwonjezera Ntchito ya Tsiku ndi Dzina Lalikulu
• Kuwonjezera ma formula
• Kusintha kayendedwe ka data m'maselo
• Mapangidwe a chiwerengero - peresenti ndi ndalama
• Kusintha mtundu wa chigawo cha selo
• Kusintha mtundu wa fosholo

02 a 09

Kulowa Data ku Open Office Calc

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Kulowetsa deta mu spreadsheet nthawi zonse ndi njira zitatu. Izi ndi izi:

1. Dinani mu selo komwe mukufuna deta kupita.
   
2. Lembani deta yanu mu selo.
   
3. Onetsetsani ENTER yeniyeni pa khibhodi kapena dinani pa selo ina ndi mbewa.

Kwa phunziro ili

Kuti muwone phunziroli, lowetsani deta ili pansipa mu tsamba lopanda kanthu pogwiritsa ntchito njira zotsatirazi:

1. Tsegulani chopanda kanthu Fichi ya spreadsheet.
   
2. Sankhani selo lomwe limasonyezedwa ndi selo lofotokozedwa .
   
3. Lembani deta yofananayo mu selo losankhidwa.
   
4. Lembani fungulo lolowani mu Enteri pa kambokosi kapena dinani selo yotsatira mndandanda ndi mbewa.

Cell Data

A2 - Kuwerengetsera Kuchokera kwa Ogwira Ntchito A8 - Dzina Loyamba A9 - Smith B. A10 - Wilson C. A11 - Thompson J. A12 - James D.

B4 - Tsiku: B6 - Mtengo Wotsatsa: B8 - Zolama Zambiri B9 - 45789 B10 - 41245 B11 - 39876 B12 - 43211

C6 - .06 C8 - Kuchotsa D8 - Net Salary

Bwererani ku Index Index

03 a 09

Kukulitsa Ma Columns

Kuwonjezera Ma Columns ku Open Office Calc:

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Pambuyo polowera deta mudzapeza kuti mawu angapo, monga Kuchepetsa , ali ochuluka kwambiri kwa selo. Kukonza izi kuti mawu onse awoneke:

1. Ikani pointer ya mouse pamzere pakati pa zigawo C ndi D mu mutu wa mutuwo .
   
2. Chojambulacho chidzasinthira kuvivi la mutu wawiri.
   
3. Dinani ndi batani lamanzere lachitsulo ndi kukokera chingwe chophindikizira kumanja kuti mukulitse ndime C.
   
4. Yambani zikho zina kuti musonyeze deta ngati mukufunikira.

Bwererani ku Index Index

04 a 09

Kuwonjezera Tsiku ndi Dzina Lalikulu

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Ndi zachilendo kuwonjezera tsikulo ku spreadsheet. Kumangidwira ku Open Office Calc ndi ntchito zingapo za DATE zomwe zingagwiritsidwe ntchito kuchita izi. Mu phunziro ili tidzakagwiritsa ntchito MASIKU ano.

1. Dinani pa selo C4.
   
2. Mtundu = MASIKU ANO ()
   
3. Onetsetsani ENTER yowonjezera pa kambokosi.
   
4. Tsiku lamakono liyenera kuoneka mu selo C4

Kuwonjezera Dzina Lalikulu mu Open Office Calc

1. Sankhani selo C6 mu spreadsheet .
   
2. Dinani pa Bokosi la Dzina .
   
3. Lembani "mlingo" (palibe ndemanga) mu Box Name.
   
4. Cell C6 tsopano ili ndi dzina la "mlingo". Tidzagwiritsa ntchito dzinali kuti tipewe kupanga mawonekedwe mu sitepe yotsatira.

Bwererani ku Index Index

05 ya 09

Kuwonjezera Mafomu

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

1. Dinani pa selo C9.
   
2. Lembani muyezo = B9 * mlingo ndipo pindani mu Enter key pa makiyi.

Kuwerengera malipiro amtundu

1. Dinani pa selo D9.
   
2. Lembani mu fomu = B9 - C9 ndipo pindikizani fungulo lolowani mukibokosi.

• Zowonjezera zowonjezereka:
  Tsegulani Maofesi a Maofesi a Calgary Open

Kujambula mafomu m'ma cells C9 ndi D9 kupita ku maselo ena:

1. Dinani pa selo C9 kachiwiri.
   
2. Sungani ndondomeko yamagulu pa mzere wodzaza (tinthu tating'onoting'onoting'onoting'onoting'onoting'ono) kamene kali kumunsi kudzanja lamanja la selo yogwira ntchito .
   
3. Pamene pointer ikusintha ku "chizindikiro chophatikiza" chakuda, dinani ndi kugwiritsira ntchito batani lamanzere ndipo yesani kugwiritsira ntchito pansi pa cell C12. Fomu ya C9 idzakopedwa ku maselo C10 - C12.
   
4. Dinani pa selo D9.
   
5. Bweretsani masitepe 2 ndi 3 ndikukoka gwiritsirani mankhwalawo mpaka selo D12. Dongosolo mu D9 lidzakopedwa ku maselo D10 - D12.

Bwererani ku Index Index

06 ya 09

Kusinthasintha kwa Dongosolo la Data

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa. Komanso, ngati mutayika mbewa yanu pa chithunzi pa toolbar, dzina la chithunzi lidzawonetsedwa.

1. Kokani osankha maselo A2 - D2.
   
2. Dinani pazithunzi Zogwirizanitsa Maselo pa Formatting toolbar kuti muyanjanitse maselo osankhidwa.
   
3. Dinani pa Chithunzi Chakugwirizanitsa Pachilumikizo Pazomwe Mungapangire Chombo Chothandizira kuti mupange mutu womwe mumasankhidwa.
   
4. Kokani osankha maselo B4 - B6.
   
5. Dinani pa Gwiritsani ntchito chithunzi choyenera pa Formatting toolbar kuti mugwirizane molumikizana ndi data mu maselo awa.
   
6. Kokani osankha maselo A9 - A12.
   
7. Dinani pa Yogwirizanitsa chithunzi choyimira pa Formatting toolbar kuti mugwirizane molumikizana ndi data mu maselo awa.
   
8. Kokani osankha maselo A8 - D8.
   
9. Dinani pa chithunzi Chakugwirizanitsa Pachilumikizo pazomwe mukupanga Formatbar toolkit kuti muyike deta mu maselo awa.
   
10. Kokani osankha maselo C4 - C6.
    
11. Dinani pa chithunzi Chakugwirizanitsa Pachilumikizo pazomwe mukupanga Formatbar toolkit kuti muyike deta mu maselo awa.
    
12. Kokani osankha maselo B9 - D12.
    
13. Dinani pa chithunzi Chakugwirizanitsa Pachilumikizo pazomwe mukupanga Formatbar toolkit kuti muyike deta mu maselo awa.

07 cha 09

Kuwonjezera Kujambula Nambala

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa. Komanso, ngati mutayika mbewa yanu pa chithunzi pa toolbar, dzina la chithunzi lidzawonetsedwa.

Kusintha kwa chiwerengero kumatanthauza kuwonjezera kwa zizindikiro za ndalama, zizindikiro zapakati, zizindikiro za peresenti, ndi zizindikiro zina zomwe zimathandiza kuzindikira mtundu wa deta zomwe zilipo mu selo ndi kuti zikhale zosavuta kuwerenga.

Mu sitepe iyi timaphatikizapo zizindikiro zamatsenga ndi ndalama ku data yathu.

Kuwonjezera chizindikiro cha Percent

1. Sankhani selo C6.
   
2. Dinani pa Fomu ya Namba: Chithunzi cha peresenti pa Formatting toolbar kuwonjezera peresenti peresenti ku selo losankhidwa.
   
3. Dinani pa Fomu ya Namba: Chotsani icon ya Decimal Place pa Formatting toolbar kawiri kuchotsa malo awiri osungirako.
   
4. Deta mu selo C6 iyenera kuwerengedwa ngati 6%.

Kuwonjezera Ndalama Zamtengo

1. Kokani osankha maselo B9 - D12.
   
2. Dinani pa Fomu ya Nambala: Chithunzi cha Ndalama pa Formatting toolbar kuwonjezera chizindikiro cha dola kwa maselo osankhidwa.
   
3. Deta mu maselo B9 - D12 ayenera tsopano kusonyeza chizindikiro cha dola ($) ndi malo awiri osungira.

Bwererani ku Index Index

08 ya 09

Kusintha mtundu wa chigawo cha selo

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa. Komanso, ngati mutayika mbewa yanu pa chithunzi pa toolbar, dzina la chithunzi lidzawonetsedwa.

1. Kokani osankha maselo A2 - D2 pa spreadsheet.
   
2. Dinani pa Chithunzi Chakumbuyo Chojambula pa Formatting toolbar (ikuwoneka ngati utoto ukhoza) kutsegula mndandanda wa m'munsi.
   
3. Sankhani Nyanja Yakuda Kuchokera Mndandanda kuti musinthe mtundu wa maselo A2 - D2 ku blue.
   
4. Kokani osankha maselo A8 - D8 pa spreadsheet.
   
5. Bwerezaninso masitepe 2 ndi 3.

Bwererani ku Index Index

09 ya 09

Mtundu Wosinthidwa

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa. Komanso, ngati mutayika mbewa yanu pa chithunzi pa toolbar, dzina la chithunzi lidzawonetsedwa.

1. Kokani osankha maselo A2 - D2 pa spreadsheet.
   
2. Dinani pa Chithunzi cha mtundu wa Font pa Formatting toolbar (ndilo chilembo chachikulu "A") kutsegula mndandanda wazithunzi.
   
3. Sankhani White kuchokera mndandanda kuti musinthe mtundu wa malemba m'maselo A2 - D2 kuti akhale oyera.
   
4. Kokani osankha maselo A8 - D8 pa spreadsheet.
   
5. Bwerezaninso masitepe 2 ndi 3 pamwambapa.
   
6. Kokani osankha maselo B4 - C6 pa spreadsheet.
   
7. Dinani pa chithunzi cha mtundu wa Font pa Formatting toolbar kuti mutsegule mndandanda wazithunzi.
   
8. Sankhani Nyanja Yakuda Kuchokera pa mndandanda kuti musinthe mtundu wa malemba mu maselo B4 - C6 mpaka buluu.
   
9. Kokani osankha maselo A9 - D12 pa spreadsheet.
   
10. Bwerezaninso masitepe 7 ndi 8 pamwambapa.
    
11. Panthawiyi, ngati mwatsatira ndondomeko yonse ya phunziro ili molondola, tsamba lanu liyenera kufanana ndi spreadsheet yomwe ikuwonetsedwa mu Gawo 1 la phunziroli.

Bwererani ku Index Index