Nyob rau hauv tus txheej txheem ntawm ntau cov lus teb thiab ua hauj lwm nrog cov ntaub ntawv, nws yog feem ntau yuav tsum tau los xam lawv qhov nruab nrab muaj nqis. Nws suav los ntawm kev ntxiv cov zauv thiab faib cov nqi tag nrho ntawm lawv tus naj npawb. Cia peb xav paub seb yuav ua li cas thiaj li xam nruab nrab ntawm cov lej siv Microsoft Excel ntau txoj kev.
Txheem Txoj Cai
Qhov yooj yim tshaj thiab paub zoo tshaj plaws los nrhiav kev txhais cov ntsiab lus ntawm cov zauv yog siv lub pob tshwj xeeb rau Microsoft Excel qauv. Xaiv qhov ntau ntawm cov lej nyob hauv kab lossis kab ntawv ntawm daim ntawv. Thaum nyob hauv "Tsev" tab, nyem rau ntawm "AutoSum" khawm, uas nyob rau ntawm daim ntawv sau rau hauv "Editing" toolbox. Ntawm daim ntawv teev npe cia, xaiv qhov khoom "Average".
Tom qab ntawd, siv qhov ua "AVERAGE", qhov kev xam yog tsim. Tus lej nruab nrab ntawm cov zauv ntawm cov zauv no tshwm nyob rau hauv xov tooj ntawm kab lus xaiv, lossis rau sab xis ntawm cov kab ntawv xaiv.
Hom no yog qhov zoo thiab yooj yim. Tab sis nws kuj muaj teeb meem loj. Nrog rau hom no, koj tuaj yeem suav qhov nruab nrab ntawm cov naj npawb uas tau npaj ua ke hauv ib kab, los yog hauv ib kab. Tab sis, nrog ib qho array ntawm hlwb, los yog nrog tawg hlwb rau ntawm ib daim ntawv, siv hom no ua tsis tau haujlwm.
Piv txwv li, yog tias koj xaiv ob kab twg thiab xam qhov nruab nrab nruab nrab los ntawm txoj kev tau piav qhia saum toj no, ces cov lus teb yuav muab rau txhua kem cais, thiab tsis yog rau tag nrho cov khoom ntawm cov hlwb.
Muab xam los ntawm kev siv lub lag luam
Rau cov xwm txheej thaum koj xav muab xam nruab nrab ntawm ib qho kev sib txuas ntawm cov hlwb, lossis cov hlwb tawg, koj tuaj yeem siv qhov haujlwm ua haujlwm. Nws siv tag nrho tib lub luag haujlwm "AVERAGE", peb paub los ntawm tus thawj txoj kev muab xam, tab sis nws ua li ib qho txawv me ntsis.
Peb nias ntawm lub xov tooj ntawm tes uas peb xav tau qhov txiaj ntsig ntawm qhov muab xam ntawm qhov nqi nruab nrab. Ndliv lub khawm "Insert Function", uas nyob rau sab laug ntawm lub mis bar. Los yog, peb ntaus yuam ua haujlwm ua haujlwm + F3.
Pib kev ua haujlwm ua haujlwm. Nyob rau hauv daim ntawv teev cov functions peb saib "AVERAGE". Xaiv nws, thiab nyem rau ntawm "OK" khawm.
Qhov sib cav ntawm qhov kev ua haujlwm qhib. Hauv lub tshav pob "Number" nkag rau cov lus sib cav ntawm txoj haujlwm. Cov no tuaj yeem yog cov naj npawb ntawm cov xov tooj lossis cov xov tooj ntawm tes uas cov zauv nyob ntawd. Yog tias nws tsis txaus rau koj nkag mus rau ntawm qhov chaw nyob ntawm xov tooj ntawm tes, ces koj yuav tsum nias lub khawm rau ntawm sab xis ntawm cov ntaub ntawv nkag teb chaws.
Tom qab ntawd, qhov kev sib cav sib cav yuav raug txo kom tsawg, thiab koj tuaj yeem xaiv cov pab pawg ntawm cov ntawv uas koj siv rau xam. Tom qab ntawd, ntxiv, nias ntawm lub pob mus rau sab laug ntawm cov ntaub ntawv nkag teb chaws rov mus rau qhov kev sib tham ntawm cov lus sib tham.
Yog hais tias koj xav xam cov nruab nrab nruab nrab ntawm cov zauv uas nyob hauv ib pawg ntawm cov hlwb, ces ua cov yeeb yam li hais saum toj no hauv "Number 2" field. Thiab li ntawd, kom txog rau thaum txhua pawg uas tsim nyog yuav tau xaiv.
Tom qab ntawd, nyem rau ntawm "OK" khawm.
Qhov tshwm sim ntawm kev xam xyuas qhov nruab nrab ntawm cov ntsiab lus tseem ceeb yuav tau muab tso rau hauv lub xov tooj ntawm tes uas koj tau xaiv ua ntej khiav cov haujlwm ua haujlwm.
Formula Bar
Nws muaj peb txoj kev khiav qhov haujlwm "AVERAGE". Ua li no, mus rau qhov "Cov qauv". Xaiv lub xov tooj ntawm tes uas lub txiaj ntsig yuav tshwm sim. Tom qab ntawd, nyob rau hauv cov pab pawg ntawm cov cuab yeej "Lub Tsev Qiv Ntawv Ntawm Haujlwm" ntawm daim kab xev nias rau khawm "Lwm yam haujlwm". Ib daim ntawv tshwm nyob rau hauv uas koj xav tau los ntawm cov khoom "Statistical" thiab "AVERAGE" sequentially.
Tom qab ntawd, raws nraim tib lub txiaj ntsig sib cav qhov rai pib thaum uas siv qhov Function Wizard, lub lag luam uas peb tau piav rau hauv kev nthuav dav saum toj no.
Cov kev nqis tes ua ntxiv yog raws nraim tib yam.
Kev ceev cov tswv yim ua lag luam
Tab sis tsis txhob hnov qab tias koj tuaj yeem nkag mus rau qhov kev ua haujlwm "AVERAGE" yog koj xav tau. Nws yuav muaj cov qauv nram qab no: "= AVERAGE (cell_address (naj npawb); cell_address (naj npawb)).
Ntawm chav kawm, qhov no tsis yog yooj yim npaum li cov yav dhau los, thiab yuav tsum tau qee cov qauv uas tau khaws cia rau hauv tus neeg siv lub taub hau, tab sis nws muaj ntau txuam.
Qhov muab xam tus nqi nruab nrab ntawm qhov xwm txheej
Ntxiv rau qhov kev suav txhua zaus ntawm qhov nruab nrab tus nqi, nws yog tau los xam qhov nruab nrab tus nqi ntawm qhov kev mob. Hauv qhov no, tsuas yog cov zauv ntawm qhov xaiv ntau uas tau raws li ib yam mob yuav raug suav rau hauv tus account. Piv txwv, yog cov zauv no ntau dua los yog tsawg tshaj li qhov teev nqi
Rau cov laj thawj no, qhov ua haujlwm "AVERAGE" siv. Zoo li qhov "AVERAGE" muaj nuj nqi, nws tuaj yeem tso tawm los ntawm Kev Ua Haujlwm Sawv Cev, los ntawm qhov qauv mis, los yog los ntawm kev xuas tes mus rau hauv lub xov tooj. Tom qab qhov kev sib tham muaj nuj nqi qhib qhov rai, koj yuav tsum sau nws cov tsis. Nyob rau hauv "Range" field, nkag mus rau ntau yam ntawm cov hlwb, qhov tseem ceeb ntawm cov uas yuav koom nrog kev txiav txim siab txog tus lej zauv. Peb ua nws ib yam nkaus li nrog txoj haujlwm "AVERAGE".
Tab sis, nyob rau ntawm "Condition", peb yuav tsum qhia tias tus nqi muaj nuj nqis, cov xov tooj ntau dua los yog tsawg dua uas yuav koom rau hauv kev xam pom. Qhov no yuav ua tau los siv cov kev qhia sib piv. Piv txwv li, peb tau hais qhov "> = 15000". Qhov ntawd yog, tsuas yog lub hlwb ntawm qhov ntau ntawm cov zauv uas siab tshaj los sis sib npaug li 15000 rau kev suav.
Cov kev sib hloov thaj tsam ntawm thaj tsam ntawm no tsis tas yuav tsum muaj. Cov ntaub ntawv nkag rau hauv nws yog yuav tsum yog thaum siv hlwb nrog cov ntawv ntsiab lus.
Thaum sau tag nrho cov ntaub ntawv, nyem rau ntawm "OK" khawm.
Tom qab ntawd, ntawm qhov muab xam ntawm qhov nruab nrab ntawm qhov xaiv tau pom muaj nyob rau hauv lub pre-xaiv cell, nrog tsuas yog cov hlwb uas nws cov ntaub ntawv ua tsis tau raws li cov kev mob.
Raws li koj tuaj yeem pom, hauv Microsoft Excel, muaj ntau cov khoom siv uas koj tuaj yeem suav qhov nruab nrab ntawm qhov xaiv ntawm cov lej. Ntxiv mus, muaj ib qho kev ua uas cia li xaiv cov zauv los ntawm ib thaj tsam uas ua tsis tau raws li cov txheej txheem yav tas los ntawm tus neeg siv. Qhov no ua rau xam hauv Microsoft Excel txawm ntau tus neeg siv-phooj ywg.
