Hoʻopuka i ka hana kuhikuhi o ka Calc Tutorial AVERAGE

I kaʻike pāʻani, aia kekahi mauʻano o ke anaʻana i keʻano o ke kikowaena waena , aiʻole ia, e like me ka mea i kapaʻia he nui,ʻo ka maʻamau no ka hoʻonohonohoʻana i nā koina. ʻO kēia mauʻano e pili ana i ka hua'ōlelo helu , ke kiko waena , a me keʻano . ʻO ka anaʻana o ka mea maʻamau i ka helu maʻamauʻo ka mean mean - a iʻole keʻano maʻamau. I mea e maʻalahi ai ka huahelu helu, Open Office Calc he hana i kūkuluʻia, kāheaʻia,ʻaʻole he mea kānalua, ka hana AVERAGE.

01 o 02

Pehea e heluʻia ai ka palena

Ua heluʻia ka awelika ma ka hoʻohuiʻana i kahi hui o nā helu a ma laila e puʻunaue ana i ka helu o kēlā mau helu.

E like me ia i hōʻikeʻia ma ka hiʻohiʻona ma ka kiʻi ma luna,ʻo ka maʻamau no nā koina: 11, 12, 13, 14, 15, a me 16 i ka wā i puʻunaueʻia e 6, i 13.5 e hōʻikeʻia i ke kelepona C7.

Ma kahi o ka loaʻaʻana i kēia maʻamau me ka lima, akā, aia kēia pūnaewele i ka hana AVERAGE:

='ĀKAHI (C1: C6)

ʻaʻole i loaʻa wale keʻano helu helu no nāʻano kumuhana o kēia manawa akā e hāʻawi hou akuʻo ia i ka hoʻololi hou inā e hoʻololi nāʻikepili i kēia pūʻulu o nā pūnaewele.

02 o 02

ʻO ka SyntaxʻOihana o ka AVERAGE

ʻO ka'ōkuhi o kahi hana e pili ana i ka hoʻolālā o ka hana a me ka inoa o nā hana, nā pale, a me nā manaʻo

ʻO ka syntax no ka hana AVERAGE:

= AVERAGE (helu 1; helu 2; ... number30)

Hiki i nā helu he 30 ke loaʻa i ka hana.

Nā Manaʻo o ka Hana AVERAGE

helu 1 (makemakeʻia) - nāʻikepili i laweʻia e ka hana

helu 2; ... number30 (ke kohoʻia) - hōʻailona hou i hiki ke hoʻonuiʻia i ka hoʻonuiʻana o ka helu.

Hiki i nā pane ke komo:

• he papa inoa o nā helu e hoʻonui
• no kaʻikepili pūnaewele i kahi o kaʻikepili ma ka pepa haʻawina
• i keʻano o nā kūmole pūnaewele

Ka Laʻana: E Huli i ka Hoʻohālikelike Kaulike o kahi Mālā o nā Nūpepa

1. E komo i kēiaʻikepili i loko o nā pūnaewele C1 i C6: 11, 12, 13, 14, 15, 16;
2. Kaomi ma ka pūnaewele C7 - kahi i kahi e hōʻikeʻia ai nā hualoaʻa;
3. Kaomi ma ka hōʻailona Wizard Wiki - e like me ka mea i hōʻikeʻia ma ka kiʻi ma luna - e wehe i ka pahu Wizard Wizard ;
4. E koho i ka helu helu mai ka papa inoa o ka papa inoa;
5. E koho i ka mahele mai ka papa hana;
6. Kaomi pākuhi;
7. ʻO nā kinona kelepona C1 i C6 i ka pakuhi e komo i kēia kikowaena i loko o ka pahu hōʻike ma ka laina helu hoʻopiʻi helu 1 ;
8. E kaomi iā OK e hoʻopiha i ka hana a hoʻopau i ka pahu pahu;
9. Pono ke helu "13.5" i loko o ka cell C7,ʻo ia ka awelika no nā helu i komo i loko o nā kiʻikuhi C1 a C6.
10. Ke pāʻaniʻoe i ke kelepona C7 ka hana piha =ʻO ka AVERAGE (C1: C6) i loko o ka laina hoʻokomo ma luna aʻe o ka pepa haʻawina

Nānā: Inā hoʻolahaʻia nāʻikepili āu e makemake ai i ke kaiapili i nā kelepona hoʻokahi ma ka pepa haʻawina ma mua o ka mahele aʻele paha, e hoʻokomo i kēlā me kēia helu pilikino pūnaewele i loko o ka pahu diaka ma kahi laina hoʻopiʻi - e like me ka helu 1, number 2, helu 3.