Tsegulani Tetorial Open Office Calvani YAM'MBUYO YOTSATIRA Ntchito

Masamu, pali njira zingapo zowunikira chizoloŵezi chachikulu kapena, monga momwe zimatchulira kawirikawiri, chiwerengero cha zikhalidwe. Njira izi zikuphatikizapo masamu amatanthawuza , wamkati , ndi machitidwe . Chiwerengero chowerengedwera cha chizoloŵezi chapakati ndi mathemati amatanthawuza - kapena osawerengeka. Kuti zikhale zophweka ku masamu, amatanthawuza, Open Office Calc, yomwe imatchedwa ntchito , yotchedwa, osadabwitsa, ntchito YOPHUNZITSIRA.

01 a 02

Momwe Average akuwerengedwera

Ambiri amawerengedwa powonjezera manambala a gulu palimodzi ndikugawanika ndi chiŵerengero cha nambala imeneyo.

Monga momwe tawonera mu chitsanzo cha chithunzi pamwambapa, chiwerengero chazofunika: 11, 12, 13, 14, 15, ndi 16 zikagawidwa ndi 6, zomwe ziri 13.5 monga momwe zasonyezedwera mu selo C7.

M'malo modzifufuza pamanja, komabe selo ili liri ndi NTCHITO:

= GAWO (C1: C6)

zomwe sizimangopeza kuti masamu amatanthawuza zamtundu wamakono koma amakupatsanso yankho lolondola ngati deta ya maselowa isintha.

02 a 02

Syntax Yogwira Ntchito

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa

Mawu omasulira a NTCHITO ntchito ndi:

= GAWO (nambala 1; nambala 2; ... nambala30)

Kufikira manambala makumi asanu ndi atatu akhoza kuwerengedwa ndi ntchitoyi.

Maganizo a NTCHITO YA NTCHITO

nambala 1 (yofunikira) - deta yomwe iyenera kuwerengedwa ndi ntchitoyo

nambala 2; ... nambala30 (zosankha) - deta yowonjezera yomwe ingathe kuwonjezeredwa kuwerengetsera.

Maganizo angakhale nawo:

• mndandanda wa manambala omwe angakhalepo
• mafotokozedwe a selo kumalo a deta mu worksheet
• malingaliro osiyanasiyana a selo

Chitsanzo: Pezani Mtengo Wapakati wa Column ya Numeri

1. Lowani deta zotsatirazi mu maselo C1 mpaka C6: 11, 12, 13, 14, 15, 16;
2. Dinani pa selo C7 - malo omwe zotsatira zidzawonetsedwa;
3. Dinani pa chithunzi cha Mpangidwe wa Wothandizira - monga momwe chikuwonetsedwera pa chithunzi pamwambapa - kutsegula bokosi la dialog Wizard ;
4. Sankhani Chiwerengero kuchokera ku Category List;
5. Sankhani Werenganinso kuchokera m'ndandanda wa Ntchito;
6. Dinani Zotsatira;
7. Onetsetsani maselo C1 mpaka C6 mu spreadsheet kuti mulowetse mndandanda uwu mu bokosi la mndandanda mu mzere wotsutsana nambala 1 ;
8. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la dialog;
9. Chiwerengero "13.5" chiyenera kuoneka mu selo C7, izi ndizowerengeka kuti nambalayi imalowa mu maselo C1 mpaka C6.
10. Mukasindikiza pa selo C7 ntchito yonse = MAGAZINI (C1: C6) amawoneka pazowonjezera pamwamba pa tsamba

Zindikirani: Ngati deta yomwe mukufuna kuifalitsa imafalikira m'maselo omwe ali pamsewu m'malo molemba limodzi kapena mzere umodzi, lowetsani mndandanda wa mndandanda wa mndandanda wa mndandanda wa mndandanda wa mndandanda wotsutsana - monga nambala 1, nambala 2, nambala 3.