Nhazi nkuzi nke OpenOffice Calc

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

OpenOffice Calc Formula Tutorial. © Ted French

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.

  1. Pịnye 3 n'ime cell C1 ma pịa igodo ENTER na keyboard.
  2. 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

OpenOffice Calc Formula Tutorial. © Ted French

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.

  1. Pịa mkpụrụ ndụ C3 (nke e depụtara na oji na mbido ahụ) ya na pointer gị.
  2. Pịnye akara nha ( = ) na cell C3.

03 nke 05

Akwụkwọ OpenOffice Calc Formula Tutorial: Nzọụkwụ 3 nke 3

OpenOffice Calc Formula Tutorial. © Ted French

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

  1. Pịa na cell C1 site na pouse pointer.
  2. Pịnye akara aka ( + ).
  3. Pịa na C2 cell na pointer pouse.
  4. Pịa igodo ENTER na keyboard.
  5. Azịza nke 5 kwesịrị ịpụta na cell C3.
  6. 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

A na-eji igodo mgbakọ na mwepụ mee ihe na paịmba nọmba iji mepụta Usoro Calc. © Ted French

Ị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

OpenOffice Calc Formula Tutorial. © Ted French Ted French

Ọ 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ụ:

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ụ.