OpenOffice Calc Formulas Tutorial

OpenOffice Calc, shirin da aka ba da kyautar kyauta ta openoffice.org, ba ka damar yin lissafi akan bayanan da aka shiga cikin rubutu .

Zaka iya amfani da Maɓallin OpenOffice Calc don ƙididdiga na ainihi, kamar ƙari ko raguwa, da ƙididdigar ƙididdiga irin su ƙididdigar haraji ko ƙaddara sakamakon gwajin dalibi.

Bugu da ƙari, idan kun canza bayanin Kira zai sauke amsar ta atomatik ba tare da kuna sake sake shigarwa ba.

Mataki na gaba da mataki na gaba yayi la'akari da yadda za a ƙirƙira da amfani da mahimmin tsari a OpenOffice Calc.

01 na 05

OpenOffice Calc Formula Tutorial: Mataki 1 na 3

Misalin da ke gaba ya haifar da mahimman tsari. Matakan da aka yi amfani da su don ƙirƙirar wannan tsari su ne wadanda suka biyo bayan yin rubutun mahimman tsari. Dabarar za ta ƙara lambobi 3 + 2. Ma'anar ta ƙarshe za ta kasance kamar wannan:

= C1 + C2

Mataki na 1: Shigar da bayanai

Lura: Don taimako tare da wannan koyo na koma zuwa hoton da ke sama.

1. Rubuta 3 a cell C1 kuma danna maballin ENTER akan keyboard.
   
2. Rubuta 2 a cell C2 kuma danna maballin ENTER akan keyboard.

02 na 05

OpenOffice Calc Formula Tutorial: Mataki 2 na 3

Lokacin da aka samar da takaddun a cikin Open Office Calc, za ku fara da buga alamar daidai. Kuna buga shi a tantanin salula inda kake son amsawa ta bayyana.

Lura : Domin taimako tare da wannan misali ya koma zuwa hoton da ke sama.

1. Danna kan tantanin C3 (kayyade a baki a cikin hoton) tare da maɓallin linzamin kwamfuta.
   
2. Rubuta alamar daidai ( = ) a cikin cell C3.

03 na 05

OpenOffice Calc Formula Tutorial: Mataki 3 na 3

Idan muka bi daidai alamar, zamu kara a cikin tantanin halitta na kwayoyin dake dauke da bayanan mu.

Ta amfani da bayanan bayanan sirrin bayanan mu a cikin wannan tsari, wannan tsari zai sabunta amsar ta atomatik idan bayanai a cikin kwayoyin C1 da C2 sun canza.

Hanya mafi kyau don ƙara sassan labaran ita ce ta amfani da linzamin kwamfuta don nunawa kuma danna madaidaicin cell. Wannan hanya ta ba ka damar danna tare da linzamin kwamfuta a kan tantanin halitta dauke da bayananka don ƙara ƙirar salula zuwa wannan tsari.

Bayan daidai alamar da aka kara a mataki na 2

1. Danna maɓallin C1 tare da maɓallin linzamin kwamfuta.
   
2. Rubuta alamar ( + ) da ( + ).
   
3. Danna maɓallin C2 tare da maɓallin linzamin kwamfuta.
   
4. Danna maballin ENTER akan keyboard.
   
5. Amsar 5 ya kamata ya bayyana a cikin C3 cell.
   
6. Danna kan salula C3. Ana nuna ma'anar a cikin layin rubutun sama da takardun aiki .

04 na 05

Masu amfani da ilmin lissafi a cikin OpenOffice Calc Formulas

Samar da samfurori a cikin OpenOffice Calc ba wuya. Yi amfani da bayanan salula na bayananku tare da aikin haɗin lissafi.

Masu amfani da ilmin lissafi da aka yi amfani da shi a cikin tsarin Calc suna kama da waɗanda aka yi amfani da su a cikin lissafin lissafi.

• Ƙididdiga - alamar musa ( - )
• Bugu da kari - da alamar ( + )
• Division - gaba slash ( / )
• Multiplication - alama ( * )
• Exponentiation - caret ( ^ )

05 na 05

Shirye-shiryen Magana na OpenOffice Calc

Idan an yi amfani da mai amfani fiye da ɗaya a cikin wata ƙira, akwai takamaiman tsari da Calc zai bi don aiwatar da waɗannan ayyukan lissafi. Wannan tsari na aiki zai iya canza ta ƙara ƙuƙwalwar zuwa lissafin. Hanyar da za ta iya tunawa da tsari na aiki shi ne yin amfani da wannan kalma:

BEDMAS

Dokokin Ayyuka shine:

• B rackets
  E xponents
  D hangen nesa
  M rubutun
  A ddition
  S sancewa

Yadda Dokokin Ayyuka ke aiki

Duk wani aiki (s) da ke ƙunshe cikin ƙuƙwalwa za a gudanar da shi na farko da kowane mai gabatarwa ya biyo baya.

Bayan haka, Calc yana la'akari da rabawa ko ƙaddamarwa ta hanyar daidaitawa, kuma yana ɗaukar waɗannan ayyukan a cikin tsari da suke faruwa a hagu zuwa dama a cikin lissafin.

Hakanan yana faruwa don aiki na gaba guda biyu ðin bidiyon da haɓaka. Ana la'akari da su daidai a cikin tsari na aiki. Kowane wanda ya fara bayyana a cikin daidaito, ko dai ƙarawa ko raguwa, shine aikin da aka fara a farkon.