Pulogalamu ya OpenOffice, pulogalamu ya spreadsheet imaperekedwa kwaulere ndi openoffice.org, imakulolani kuchita mawerengedwe pa deta loperekedwa mu spreadsheet .
Mungagwiritse ntchito mawonekedwe a OpenOffice Calc chifukwa cha kuwerengeka kwa chiwerengero, monga kuwonjezera kapena kuchotsa, komanso kuwerengera kovuta kwambiri monga kuchotsera malipiro kapena kupereka zotsatira za mayesero a wophunzira.
Kuonjezerapo, ngati mutasintha deta yamtunduwu idzakonzanso yankho lanu popanda kubwezeretsanso.
Chitsanzo chotsatira ndi sitepe ikutsatanetsatane momwe mungakhalire ndikugwiritsa ntchito chiyambi cha OpenOffice Calc.
01 ya 05
Maphunziro a Zopangira Omwe Akhazikitsidwa Otsatira: Gawo 1 lachitatu
Chitsanzo chotsatira chimapanga chiyambi chofunikira. Njira zomwe zimagwiritsidwa ntchito popanga ndondomekoyi ndizofanana ndizo polemba zovuta zambiri. Fomuyi idzawonjezera manambala 3 + 2. Mndandanda womaliza udzawoneka ngati uwu:
= C1 + C2
Khwerero 1: Kulowa deta
Zindikirani: Kuti chithandizo ndi phunziroli liwonetse chithunzi pamwambapa.
- Lembani 3 mu selo C1 ndikusindikizira ENTER kwachinsinsi pa kambokosi.
- Lembani 2 mu selo C2 ndikusindikizira ENTER kwachinsinsi pa kambokosi.
02 ya 05
Maphunziro a Zopangira Omwe Akhazikitsidwa Pachiyambi: Gawo 2 lachitatu
Pogwiritsa ntchito maofesi ku Open Office Calc, nthawizonse mumayamba polemba chizindikiro chofanana. Mukuzijambula mu selo kumene mukufuna yankho liwonekere.
Zindikirani : Kuti muthandizidwe ndi chitsanzo ichi mutchule chithunzi pamwambapa.
- Dinani pa selo C3 (yofotokozedwa wakuda mu chithunzi) ndi pointer yanu ya mouse.
- Lembani chizindikiro chofanana ( = ) mu selo C3.
03 a 05
Maphunziro a Zopangira Maola a Omwe Akhazikitsidwa: Gawo 3 la 3
Potsatira chizindikiro chofanana, timayika mu mafotokozedwe a maselo a maselo omwe ali ndi deta yathu.
Pogwiritsira ntchito mafotokozedwe a maselo a deta yathu muyambidwe, mayendedwewo adzasintha yankho lake ngati deta m'maselo C1 ndi C2 amasintha.
Njira yabwino yowonjezeramo ma selo ndi kugwiritsa ntchito mbewa kuti mulowe ndikugwiritsira ntchito selo lolondola. Njira iyi imakulolani kuti musinthe ndi ndondomeko yanu pa selo yomwe muli ndi deta yanu kuti muwonjeze selo yake yowonjezeredwa.
Pambuyo pa chizindikiro chofanana chiwonjezeredwa mu sitepe yachiwiri
- Dinani pa selo C1 ndi pointer ya mouse.
- Lembani chizindikiro chowonjezera ( + ).
- Dinani pa selo C2 ndi pointer ya mouse.
- Onetsetsani ENTER yowonjezera pa kambokosi.
- Yankho lachisanu liyenera kuoneka mu selo C3.
- Dinani pa selo C3. Fomuyi imasonyezedwa mu mzere wolembera pamwamba pa tsamba .
04 ya 05
Masamu Ogwira Ntchito mu OpenOffice Calc Formulas
Kupanga mafomu mu OpenOffice Calc sivuta. Ingosinthanitsani mafotokozedwe a maselo a deta yanu ndi olemba masamu oyenera.
Olemba masamu omwe amagwiritsidwa ntchito mu ma Calc ali ofanana ndi omwe amagwiritsidwa ntchito mu masamu.
- Kuchotsa - kusayina chizindikiro ( - )
- Kuwonjezera - kuphatikiza chizindikiro ( + )
- Gawani - kutsogolo kutsogolo ( / )
- Kuwonjezeka - asteriski ( * )
- Kutsatsa - chisamaliro ( ^ )
05 ya 05
Maofesi a Koperative ya Kalata Yoyenera
Ngati oposa angapo amagwiritsa ntchito njira, pali dongosolo lapadera lomwe Calc lidzawatsatira kuti lichite masabata awa. 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
Momwe Ntchito Yogwirira Ntchito imagwirira ntchito
Ma opaleshoni aliwonse omwe ali nawo mabakita adzakonzedwa koyambirira kutsatiridwa ndi zovumbulutsidwa zilizonse.
Pambuyo pake, Calc imaona ntchito zogawikana kapena kuchulukitsa kuti zikhale zofanana, ndipo zimayendetsa ntchitoyi motere kuti zichitike kumanzere.
Zomwezo zimapita ku zochitika ziwiri zotsatira. Kuwonjezera ndi kuchotsa. Amaonedwa kuti ndi ofanana mu dongosolo la ntchito. Chilichonse chimene chimawoneka choyambirira mu mgwirizano, kuphatikizapo kuwonjezera kapena kuchotsa, ntchitoyi idzachitidwa yoyamba.