Zauv, muaj ntau txoj hauv kev ntsuas kev ntsuas ntawm lub hauv paus lossis, raws li nws tau nquag hu ua, qhov nruab nrab rau ib qho ntawm qhov tseem ceeb. Cov kev no muaj xws li kev txhais cov ntsiab lus , tus zauv nruab nrab , thiab hom . Qhov kev ntsuas feem ntau suav ntawm qhov kev xav hauv nruab nrab yog qhov txhais ua piv txwv - lossis qhov nruab nrab yooj yim. Kom ua kom yooj yim dua rau lub ntsiab lus tseem ceeb, Qhib Office Calc muaj ib qho kev ua kom muaj nuj nqi , hu ua, tsis yog qhov ua tsis tau zoo, muaj nuj nqi AVERAGE.
01 ntawm 02
Npaum Li Cas Qhov Nruab Nrab
Qhov nruab nrab yog xam los ntawm ntxiv ib pawg ntawm cov zauv ua ke thiab muab faib los ntawm qhov suav ntawm cov zauv.
Raws li pom hauv daim duab saum toj no, qhov nruab nrab rau qhov tseem ceeb: 11, 12, 13, 14, 15, thiab 16 thaum muab faib ua 6, uas yog 13.5 raws li muaj hauv xov tooj ntawm C7.
Hloov qhov nruab nrab ntawm qhov nruab nrab no, txawm li cas los xij, lub xov tooj ntawm tes no muaj cov nuj nqi AVERAGE:
= AVERAGE (C1: C6)
uas tsis tsuas yog pom lub ntsiab lus txhais rau ntau yam ntawm qhov tseem ceeb, tab sis kuj tseem yuav muab koj cov lus teb tshiab rau cov ntaub ntawv hauv cov pab pawg ntawm cov kev hloov hlwb.
02 ntawm 02
Qhov kev ua haujlwm AVERAGE Syntax
Ib qho kev ua haujlwm syntax hais txog qhov teeb tsa ntawm txoj haujlwm thiab suav nrog txoj haujlwm, lub npe, thiab sib cam
Lub syntax rau lub txiaj ntsim AVERAGE yog:
= AVERAGE (naj npawb 1; naj npawb 2; ... number30)
Mus txog 30 tus naj npawb tuaj yeem tau los ntawm qhov kev ua.
Qhov Kev Ua Haujlwm Cov Kev Lag Luam
zauv 1 (yuav tsum tau) - cov ntaub ntawv yuav raug kwv yees los ntawm qhov ua haujlwm
tooj 2; ... number30 (yeem) - ntxiv cov ntaub ntawv uas muab ntxiv tau rau cov lus teb nruab nrab.
Cov lus sib tham muaj peev xwm:
- ib daim ntawv teev cov najnpawb yuav tsum tau ntaus nqi
- xov tooj ntawm tes rau qhov chaw nyob ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm
- ib txoj kab ntawm xov tooj ntawm cov xov tooj
Piv txwv: Nrhiav qhov nruab nrab ntawm qhov Kem ntawm Numbers
- Sau cov ntaub ntawv nram qab no rau hauv hlwb C1 rau C6: 11, 12, 13, 14, 15, 16;
- Nias ntawm xov tooj ntawm tes C7 - qhov chaw nyob qhov twg yuav tshwm sim tau;
- Nias rau ntawm qhov Function Wizard icon - raws li muaj nyob rau hauv daim duab saum toj no - qhib qhov kev ua hauj lwm Wizard dialog box ;
- Xaiv qhov tshwm sim los ntawm daim ntawv teev npe Qeb;
- Xaiv qhov nruab nrab los ntawm Daim Ntawv Sau Npe;
- Nyem Tom ntej;
- Highlight hlwb C1 rau C6 nyob rau hauv daim ntawv khom nqi kom nkag mus rau qhov no ntau rau hauv lub thawv dialog hauv tus nab npawb 1 nqe kab;
- Nias OK los ua kom tiav cov kev ua thiab kaw lub thawv ntawv;
- Tus naj npawb "13.5" yuav tsum tshwm sim hauv xov tooj ntawm tes C7, qhov no yog qhov nruab nrab rau cov zauv nkag hauv hlwb C1 rau C6.
- Thaum koj nias rau ntawm C7 cell tus ua tiav tiav = AVERAGE (C1: C6) tshwm nyob rau hauv cov lus nug saum toj ntawm daim ntawv ua haujlwm
Ceeb Toom: Yog tias cov ntaub ntawv koj xav tau nruab nrab yog sau hauv cov tib neeg lub hlwb hauv daim ntawv sau ua haujlwm tsis yog hauv ib kab los yog kab, sau txhua tus neeg siv cell rau hauv lub thawv tawm ntawm ib txoj kab sib cais - xws li cov lej 1, nab npawb 2, tooj 3