OpenOffice Calc, usoro mmemme nke a na-enye n'efu site openoffice.org, na-enye gị ohere ịmepụta nchịkọta na data abanye na spreadsheet .
Ị nwere ike iji OpenOffice Calc mee ihe maka nchịkọta ọnụ ọgụgụ, dị ka mgbakwunye ma ọ bụ ntinye, yana mgbagwoju mgbagwoju anya dịka nkwụsị ụgwọ ma ọ bụ iji nweta ule nke nwa akwụkwọ.
Tụkwasị na nke ahụ, ọ bụrụ na ị gbanwee data Calc ga-eme ka azịza ya na-akpaghị aka na-enweghị ịghachị ịbanye na usoro ahụ.
Ntụụkwụ nzọụkwụ site nzọụkwụ na-ekpuchi otu esi emepụta na jiri usoro bụ isi na OpenOffice Calc.
01 nke 05
Nhazi akwukwo nduzi OpenOffice Calc: Nzọụkwụ 1 nke 3
Ihe atụ na-esonụ na-emepụta usoro bụ isi. Nzọụkwụ ndị eji mepụta usoro a bụ otu ihe ahụ ị ga - eso mgbe ị na - ede ihe dị mgbagwoju anya. Usoro a ga-agbakwunye nọmba 3 + 2. Usoro ikpeazụ ga - adị ka nke a:
= C1 + C2
Nzọụkwụ 1: Ịbanye data
Rịba ama: Maka enyemaka na nkuzi a na-ezo aka na oyiyi dị n'elu.
- Pịnye 3 n'ime cell C1 ma pịa igodo ENTER na keyboard.
- Pịnye 2 n'ime cell C2 ma pịa igodo ENTER na keyboard.
02 nke 05
Akwụkwọ OpenOffice Calc Formula Tutorial: Nzọụkwụ 2 nke 3
Mgbe ị na-emepụta usoro na Open Office Calc, ị NA- amalite site na ịpị akara aka. Ị tinye ya na cell ebe ịchọrọ ka azịza ya pụta.
Rịba ama : Maka enyemaka na ihe atụ a na-ezo aka na oyiyi dị n'elu.
- Pịa mkpụrụ ndụ C3 (nke e depụtara na oji na mbido ahụ) ya na pointer gị.
- Pịnye akara nha ( = ) na cell C3.
03 nke 05
Akwụkwọ OpenOffice Calc Formula Tutorial: Nzọụkwụ 3 nke 3
N'ịgbaso ihe ịrịba ama ahụ, anyị na-agbakwụnye na mkpokọta mkpụrụ ndụ nke mkpụrụ ndụ ndị nwere data anyị.
Site n'iji sụgharịa mkpụrụ data anyị na usoro ahụ, usoro a ga-emezi azịza ya ozugbo ma ọ bụrụ na data nke mkpụrụ ndụ C1 na C2 gbanwere.
Ụzọ kacha mma ị ga-esi agbakwụnye ederede mkpụrụokwu bụ site n'iji òké mee ihe ma pịa ezigbo cell. Usoro a na-enye gị ohere iji ntan gị pịa na cell nke nwere data gị iji gbakwunye ọnụ ọgụgụ ya na usoro ahụ.
Mgbe akara nha ama agbakwunyere na nzọụkwụ 2
- Pịa na cell C1 site na pouse pointer.
- Pịnye akara aka ( + ).
- Pịa na C2 cell na pointer pouse.
- Pịa igodo ENTER na keyboard.
- Azịza nke 5 kwesịrị ịpụta na cell C3.
- Pịa na cell C3. E gosipụtara usoro a na akara ntinye n'elu akwụkwọ ọrụ .
04 nke 05
Ndị ọrụ mgbakọ na mwepụ na OpenOffice Calc Formulas
Ịmepụta usoro na OpenOffice Calc abụghị ihe siri ike. Naanị jikọta ọnụ ọgụgụ nke mkpụrụedemede gị na ezigbo ọrụ mgbakọ na mwepụ.
Ndị ọrụ mgbakọ na mwepụ na-eji usoro nchịkọta Calc yiri ndị ahụ e ji mee ihe na mpempe akwụkwọ.
- Ntughari - ntinye aka ( - )
- Mgbakwunye - gbakwunyere akara ( + )
- Nkeji - nhazi slash ( / )
- Ntinye ederede - akara mmuke ( * )
- Nkwụsị - caret ( ^ )
05 05
OpenOffice Calc Order Operations
Ọ bụrụ na a na-eji ihe karịrị otu onye na-eme ihe n'otu usoro, enwere otu usoro nke Calc ga-agbaso iji rụọ ọrụ mgbakọ na mwepụ ndị a. Usoro nke arụmọrụ a nwere ike gbanwere site na ịgbakwunye brackets na akara. Ụzọ dị mfe iji cheta usoro nke arụmọrụ bụ iji okwu nkwekọrịta:
BEDMAS
Usoro Ịrụ Ọrụ bụ:
- B akpa
Ejiri
D anya
M ultiplication
A ddition
S ubtraction
Otu esi arụ ọrụ
A ga - arụ ọrụ ọ bụla dị na brackets mbụ nke ọ bụla exponents.
Mgbe nke ahụ gasịrị, Calc na-ele ọrụ nkewa ma ọ bụ ọrụ ịmepụta ọnụ dị ka ihe dị mkpa, ma na-arụ ọrụ ndị a n'usoro ka ha na-aga n'aka ekpe gaa n'aka nri.
Otu ihe ahụ na-aga maka arụ ọrụ abụọ na-esote ọhụụ � na ntinye. A na-ewere ha na hà nhata n'usoro ọrụ. Kedu nke ọ bụla na-egosi na mbido, ntinye ma ọ bụ ntinye, bụ ọrụ nke mbụ.