Vula i-Office ye-Calc Tutorial ISIGABA sokusebenza

Isibalo seMathematika, kukho iindlela ezininzi zokulinganisa ukutyekela okuqhelekileyo okanye, njengoko kuthethwa ngokuqhelekileyo, umyinge weesethi zexabiso. Ezi ndlela ziquka i- arithmetic ithetha , i- median , kunye nemodi . Inqanaba eliqhelekileyo eliqhelekileyo lokubaluleka kwetendistanti lithetha ukuthini - okanye umlinganiselo olula. Ukwenza kube lula kwi-arithmetic ithetha, i-Open Office Calc inomsebenzi owakhelwe ngaphakathi, obizwa, akumangalisi, umsebenzi we-AVERAGE.

01 ka 02

Indlela Umyinge obalwa ngayo

Umyinge ubalwa ngokungongeza iqela lamanani kunye kunye nokwahlula ngokubala kwala manani.

Njengoko kuboniswe kumzekelo kumfanekiso ongentla, umlinganiselo wemilinganiselo: 11, 12, 13, 14, 15, no-16 xa ihlulwe ngo-6, okuyi-13.5 njengoko kuboniswe kwiseli C7.

Esikhundleni sokufumanisa lo myinge ngesandla, nangona kunjalo, eli selesti liqukethe umsebenzi WENKQUBO:

= ISIGABA (C1: C6)

oko akufumani kuphela i-arithmetic ithetha inqanaba lamanani lamanje kodwa liya kukunika impendulo ehlaziyiweyo ukuba idilesi yeeseli iguqulwe.

02 we 02

ISISHWANKATHELO Sokusebenza se-Syntax

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano

I-syntax yomsebenzi we-AVERAGE yile:

= ISIGABA (inombolo 1; inombolo 2; ... inombolo30)

Ukufikelela kumanani angama-30 unokulinganiswa ngumsebenzi.

ISISHWANKATHELO Sokusebenza Kweengxoxo

Inombolo 1 (efunekayo) - idatha iya kuba ngumsebenzi

inombolo 2; ... inombolo30 (okukhethwa kukho) - idatha eyongezelelweyo enokungeniswa kwizibalo eziqhelekileyo.

Iingxoxo zingabandakanya:

• uluhlu lweenombolo eziza kubalwa
• izikhokelo zeseli kwindawo yendawo kwiphepha lokusebenzela
• uluhlu lweenkcukacha zeeseli

Umzekelo: Fumana umlinganiselo wexabiso lekholomu yeenombolo

1. Faka idatha elandelayo kwiiseli C1 ukuya ku-C6: 11, 12, 13, 14, 15, 16;
2. Cofa kwiseli C7 - indawo apho iziphumo ziza kuboniswa khona;
3. Cofa kwi icon Yesebenza Yomsebenzi - njengoko kuboniswe kumfanekiso ongentla - ukuvula ibhokisi yencoko yencoko yoMsebenzi ;
4. Khetha iSatisatisti kuluhlu lwamaCandelo;
5. Khetha Umyinge ukusuka kuluhlu lweeNkqubo;
6. Chofoza Okulandelayo;
7. Phakamisa iiseli C1 ukuya ku-C6 kwispredishithi ukungena kweli bhokisi kwibhokisi yencoko kwibhokisi yenkcazo ye- 1 ;
8. Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko;
9. Inombolo "13.5" kufuneka ibonakale kwiselfowuni C7, oku kungumlinganiselo wamanani afakwe kwiiseli C1 ukuya ku-C6.
10. Xa ucofa kwiseli C7 umsebenzi opheleleyo = ISIGABA (C1: C6) sibonakala kumgca wokufakelwa ngaphezulu kwiphepha lokusebenzela

Qaphela: Ukuba idatha ofuna ukuyifumana isasazeka kwiseli nganye kwiphepha lomsebenzi kunokuba kukho enye ikholomu okanye umgca, faka isalathisi nganye yesinye kwibhokisi yencoko kwibhokisi yenkcazo eyahlukileyo - njengenombolo 1, inombolo yesi-2, inombolo 3.