Vula i-Office ye-Calc Tutorial ISIGABA sokusebenza

Ngokwezibalo, kunezindlela eziningi zokulinganisa ukuthambekela okuphakathi noma, njengoba kuvame ukubizwa ngokuthi, isilinganiso sesethi yamanani. Lezi zindlela zihlanganisa isichazamazwi sisho , i- median , nemodi . Isibalo esivame ukubalwa ngaso sonke isikhathi sokuthambekela okuphakathi kuwukuthi kusho izibalo - noma isilinganiso esilula. Ukwenza kube lula kwi-arithmetic kusho, i-Open Office Calc inomsebenzi owakhelwe ngaphakathi, okuthiwa, akumangazi, umsebenzi we-AVERAGE.

01 ngo-02

Yeka ukuthi Isilinganiso sibhekiswe kanjani

Isilinganiso sibalwa ngokungeza iqembu lezinombolo ndawonye bese uhlukanisa ngokubala kwalezo zinombolo.

Njengoba kuboniswe kusibonelo esithombeni esingenhla, isilinganiso samanani: 11, 12, 13, 14, 15, no-16 uma ihlukaniswe ngu-6, okuyi-13.5 njengoba kuboniswe esitokisini C7.

Esikhundleni sokuthola lokhu ngokwezifiso ngesandla, noma kunjalo, le seli liqukethe umsebenzi WOKUSEBENZA:

= I-AVERAGE (C1: C6)

okuyinto engatholi kuphela ukuthola izibalo zamanani amanani okwamanje kodwa futhi izokunikeza impendulo ebuyekeziwe uma idatha kuleli qembu lamaseli lishintsha.

02 ka 02

I-Syntax YOKUSEBENZA KOMSEBENZI

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana

I-syntax yomsebenzi we-AVERAGE yile:

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

Kufika kuzinombolo ezingu-30 kungalinganiselwe umsebenzi.

Iziphakamiso ZOMSEBENZI WOKUSEBENZA

inombolo 1 (edingekayo) - idatha okufanele ibe nomsebenzi

inombolo 2; ... inombolo30 (okukhethwa kukho) - idatha eyengeziwe engangezwa kumanani ajwayelekile.

Izingxabano zingaqukatha:

• uhlu lwezinombolo ezingalinganiselwe
• amasetferensi weselula endaweni yedatha kushidi lokusebenzela
• ububanzi bezinkomba zocingo

Isibonelo: Thola inani elilinganiselwe lekholomu yezinombolo

1. Faka imininingwane elandelayo kumaseli C1 kuya eC6: 11, 12, 13, 14, 15, 16;
2. Chofoza kuseli C7 - indawo lapho imiphumela izoboniswa khona;
3. Chofoza isithonjana se- Function Wizard - njengoba kuboniswe esithombeni ngenhla - ukuvula ibhokisi lengxoxo ye- Function Wizard ;
4. Khetha Isitatimende kusuka ohlwini Uhlu;
5. Khetha Isilinganiso kusuka ohlwini loSebenzi;
6. Chofoza Okulandelayo;
7. Qinisekisa amaseli C1 kuya ku-C6 kuspredishithi sokufaka leli banga ukuya ebhokisini lebhokisi enombeni we-argument yenombolo 1 ;
8. Chofoza OK ukuze uqedele umsebenzi bese uvala ibhokisi lengxoxo;
9. Inombolo "13.5" kufanele ivele esitokisini C7, lokhu kungenani ukuthi izinombolo zingena kumaseli C1 kuya ku-C6.
10. Uma uchofoza ku-cell C7 umsebenzi ophelele = I-AVERAGE (C1: C6) ivela emgqeni wokufaka ngenhla kwephepha lokusebenzela

Qaphela: Uma idatha ofuna ukuyifaka isakazwa ngamaseli ngabanye kumshini wokusebenzela kunokuba ikholomu eyodwa noma umugqa, faka isithenjwa ngasinye samangqamuzana ebhokisini lengxoxo emgqeni wezingxabano ezihlukene - njengenombolo 1, inombolo 2, inombolo 3.