Kawm paub yuav tsim daim ntawv qib twg hauv Microsoft Excel yog cov cuab yeej siv tau zoo. Nws muab daim ntawv nthuav qhia cov ntaub ntawv thiab cov qauv uas yuav txo lub sijhawm thiab kev rau siab siv rau hauv kev sau cia thiab suav cov qhab nia siv cov txheej txheem qub. Cov hauv qab no yog cov ncauj lus kom ntxaws ntxaws ntawm cov kauj ruam uas yuav cog lus kawm qhov txuj ci no thiab siv lub cuab yeej uas yuav muaj txiaj ntsig zoo rau yav tom ntej ntawm kev txheeb xyuas cov ntaub ntawv. Koj tsuas yog xav tau kev paub yooj yim ntawm yuav ua li cas Windows 7, XP lossis Vista los siv kab lus no. Koj tsis tas yuav tsum paub nrog Microsoft Excel.
Cov kauj ruam
Kauj Ruam 1. Qhib Microsoft Excel
Kauj Ruam 2. Sau cov ntaub ntawv hauv chav kawm mus rau daim ntawv Excel
Kauj Ruam 3. Xaiv Phau Ntawv Qeb Layout
Kauj Ruam 4. Tsim cov qauv
Txoj Kev 1 ntawm 4: Qhib Microsoft Excel
Kauj Ruam 1. Ntawm koj lub vijtsam hauv tsev, nyem "Pib", tom qab ntawd mus rau "Txhua qhov haujlwm"
Kauj Ruam 2. Nyem rau ntawm "Txhua qhov program", Qhib Microsoft Excel
Kauj Ruam 3. Nrhiav "Microsoft Office" los ntawm cov npe, thiab nyem rau sab laug
Kauj Ruam 4. Nias "Microsoft Excel"
Txhawm rau nkag tau yooj yim rau Microsoft Excel, nyem thiab rub lub cim Excel, los ntawm kauj ruam 3, mus rau koj lub desktop
Txoj Kev 2 ntawm 4: Sau cov ntaub ntawv hauv chav kawm mus rau daim ntawv Excel
Rau lub hom phiaj ntawm kev koom tes, koj yuav tsum ib txwm teev npe daim ntawv uas koj tab tom tsim thiab suav nrog cov ntaub ntawv dav dav txog chav kawm (piv txwv li tus kws qhia lub npe, npe ntawm chav kawm, thiab/lossis sijhawm sib tham). Cov kauj ruam no yog qhov tseem ceeb thaum koj xav tau luam daim ntawv, luam theej thiab muab faib rau lawv. Nws yog qhov muaj txiaj ntsig zoo hauv kev txheeb xyuas cov qib-phau ntawv cov lus tau hais qhia kom raug thiab muaj txiaj ntsig.
Kauj Ruam 1. Sau daim ntawv qib Kawm
- Ob npaug nias rau "Sheet1" hauv qab ntawm Excel qhov rai, "Sheet1" tam sim no tau hais meej
- Ntaus lub npe rau daim ntawv, piv txwv li: Thawj Teev Sijhawm Kawm
-
Nias Sau
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 10 Kauj Ruam 2. Ntxig Cov Ntaub Ntawv Hauv Chav Kawm
- Nyem cell A1 los xaiv nws
- Ntaus xib fwb lub npe
- Nias tus yuam sij qis kom xaiv cell A2
- Ntaus lub npe chav kawm, piv txwv li: Social Science Class
- Nias tus yuam sij qis kom xaiv cell A3
- Ntaus lub sijhawm sib tham hauv chav kawm
- Nias tus yuam sij qis kom xaiv A4
- Nkag mus rau lub sijhawm, piv txwv li: Caij nplooj zeeg 2012
- Nias "Nkag mus" ob zaug kom mus rau ntawm tes A6
- "Lub npov npe" nyob rau sab saud ntawm daim ntawv qhia seb lub xovtooj twg raug xaiv.
Txoj Kev 3 ntawm 4: Xaiv Phau Ntawv Qeb Layout
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 11 Kauj Ruam 1. Sau Cov Npe Ntawm Cov Tub Kawm Ntawv
- Nws yog ib qho tseem ceeb los xaiv cov txheej txheem uas yooj yim tshaj plaws rau koj. Paub txog hom nkag uas koj yuav ua yuav pab txheeb xyuas kab sib txawv uas koj xav tau. Koj yuav xav tau ib kab ntawv rau txhua qhov haujlwm tau muab qhab nia, ntxiv rau kab ntawv rau cov tub ntxhais kawm lub npe, tag nrho, qhov nruab nrab thiab qib kawg.
- Txog cov ntaub ntawv no koj yuav xav tau peb kab lus: Npe Lub Npe, Xeem Lub Npe thiab ib kab rau cov tub ntxhais kawm.
-
Tsim kom muaj ib kab zuj zus ntawm Tus Zauv
- Nrog cell A6 raug xaiv, hom 1
- Nias tus yuam sij nqis
- Ntaus tus lej 2
- Hover hla cell A6 kom txog thaum tus cursor zoo li tus
- Nyem thiab rub tus cursor los ntawm Cell A6 rau A7, tam sim no ob lub xov tooj tau hais meej nrog lub thawv nyob ib puag ncig lawv
- Hover hla kaum sab xis ntawm lub npov kom txog thaum tus cursor dhau los ua ib qho ntxiv +(qhov no hu ua tus tuav tuav)
-
Nyem thiab luag kom txog thaum koj tus lej kawg mus txog.
- Ntaus lub npe ntawm kab ntawv: Xaiv cell B5, Ntaus kab npe Lub Npe Lub Npe, Nias tab los ntawm cov keyboard, Ntaus Xeem, Sau cov npe ntawm cov tub ntxhais kawm mus rau txhua kab.
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 12 Kauj Ruam 2. Tsim kab ntawv ntxiv (ua raws cov kauj ruam raws li qhia ua ntej):
Ntaus cov seem ntawm kab ntawv xws li Ua Tsev 1, Ua Haujlwm 2, Xeem 1, Xeem 2, Xeem, Tag Nrho, Nruab Nrab, thiab Qib Kawg. Siv tus yuam sij tab kom txav los ntawm kab xov tooj mus rau tom ntej.
Txhawm rau kom muaj cov npe tshwm nyob rau hauv cov ntawv raws tus lej, Hauv qab lub tsev tab, nyem rau ntawm "Sort & Filter" icon, xaiv A txog Z
Txoj Kev 4 ntawm 4: Tsim cov qauv
Excel muab cov npe ntawm ntau lub luag haujlwm uas tuaj yeem siv hauv kev suav cov qhab nia. Thawj txoj haujlwm yog qhov ua haujlwm sib npaug. Peb yuav siv qhov suav ua haujlwm los nrhiav tag nrho cov tub ntxhais kawm qib kawm. Qhov thib ob, peb yuav siv qhov haujlwm nruab nrab uas yuav txhais tag nrho rau feem pua.
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 13 Kauj Ruam 1. Tag Nrho Cov Tub Kawm Ntawv Qib Kawm
- Xaiv cell I 6 (cell ncaj qha hauv qab ntawm "Total" cell)
- Hauv qab Cov Ntawv qhia zaub mov, xaiv Auto Sum
- Nyem thiab luag cov hlwb D6 txog H6 hla kab.
- Nias Sau
-
Txhawm rau theej cov qauv rau tag nrho Cov Kab Lus Tag Nrho, Nyem thiab rub qhov ua tiav kom txog thaum koj mus txog ntawm tes I15. (qhov no yuav theej tawm txoj haujlwm rau txhua kab, suav tag nrho cov qhab nia rau txhua tus tub ntxhais kawm)
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 14 Kauj Ruam 2. Qhov nruab nrab ntawm cov qhab nia
Txhawm rau nrhiav qhov nruab nrab ntawm cov qhab nia rau txhua tus tub ntxhais kawm, peb yuav faib tag nrho pom nyob hauv kab "tag nrho" los ntawm qhov siab tshaj plaws ua tau.
(hauv qhov piv txwv no, peb yuav xav tias qhov ua tau zoo tshaj plaws ntawm qib yog 500)
- Xaiv cell J6 (ntawm tes ncaj qha hauv qab "nruab nrab" ntawm tes)
- Nyem rau ntawm Formula bar los ntaus
- Hom = 16/500
- Nias Sau
- Los ntawm xov tooj ntawm tes J6, nyem thiab rub tus tes tuav mus rau tag nrho kab nruab nrab, kom txog rau thaum xov tooj J15
- Txhawm rau teeb tsa qhov nruab nrab hauv daim ntawv feem pua, xaiv kab ntawv J6 txog J15
- Txoj cai nyem rau ntawm kab ntawv xaiv
-
Xaiv Format Cells, lub npov yuav tshwm sim
Los ntawm Tus lej tab, nyem rau ntawm Pawg Feem Feem
- Hloov cov lej ntawm cov lej zauv raws li koj nyiam
-
Nyem Ok.
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 15 Kauj Ruam 3. Txhais Cov Lej Qhov Qeb Kawm Qeb Kawm Qib rau Tsab Ntawv Kawg
Excel tso cai rau peb ntxiv qhov ua haujlwm uas suav tus lej raws li lawv qhov nruab nrab hauv kab J. Txhawm rau ua txoj haujlwm no peb yuav xav tau tus yuam sij, uas yog cov lus yooj yim ntawm cov ntawv qib thiab cov lej sib xws. Peb yuav siv cov qauv piv txwv los ntawm Excel.
- Tsim Cov Ntsiab Lus
-
Xaiv cell M7, peb yuav pib ntaus lub rooj ntawm no
- Ntaus "Nruab Nrab", qhov no yuav yog thawj kab ntawv
- Nias lub tab tseem ceeb
- Hom "Qib"
- Hauv qab "Nruab Nrab" ntaus koj cov qhab nia qhab nia
-
Hauv qab "Qib Kawm" kab ntawv, ntaus cov ntawv sib xws sib npaug rau txhua tus qhab nia
Tsim Gradebook ntawm Microsoft Excel Kauj Ruam 16 Kauj Ruam 4. Ntaus Tus Qauv
Txoj haujlwm yuav tsum tau xa rov qab qib ntawv yog VLOOKUP muaj nuj nqi, thiab hu ua zes nuj nqi. Nws ua raws cov qauv:
VLOOKUPlookup_value, table_array, column_index_number, [range_lookup])
- Xaiv cell K6
-
Pib ntaus tus lej = VLOOKUP (J6, $ M $ 18: $ N $ 22, 2, TSEEB)
Kev piav qhia: tom qab tus kab zauv, ntaus lub xovtooj ntawm uas muaj tus qhab nia kawg ntawm tus tub ntxhais kawm uas nyob hauv qhov piv txwv ntawm tes J6. Qhov thib ob ntawm cov mis yog suav nrog los ntawm kev xaiv lub rooj tseem ceeb; nias F4 los ntawm cov keyboard kom ntxig cov cim nyiaj daus las uas yuav xauv qhov xaiv. Ib feem peb yog tus lej ntawm kab lus uas muaj cov ntawv qib. Qhov tseeb sawv cev rau kwv yees qhov sib tw nrog qhov tseem ceeb ntawm kab ntawv, tsis raug yuav ua rau muaj qhov sib tw tseeb
- Nias Sau
- Luam cov qauv mus rau tag nrho kab ntawv kom txog rau ntawm cell K15 los ntawm txhaj thiab rub qhov ua tiav ntawm tes ntawm cell K6.
-
Rov ua cov txheej txheem no yuav tso cai rau koj xam cov qhab nia rau lwm chav kawm yav tom ntej.
Lub tswv yim
- Ib txwm muab koj qib-phau ntawv lub npe, los ntawm nyem rau ntawm "file" tab, xaiv "Save As", hauv Save As window, xaiv qhov chaw nyob thiab ntaus lub npe rau koj daim ntawv. Nias "Txuag" thaum npaj tseg.
- Xa mus rau Excel cov ntawv qhia dav dav "Pab" thaum xav tau. Nws muaj cov cuab yeej ntawm kev tsim txheeb cais cov ntaub ntawv.
- Txhawm rau nrhiav seb lub khoos phis tawj koj lub PC muaj li cas, nyem "Pib", nyem rau ntawm "Computer", nqes mus thiab nyem rau ntawm "Properties", lub kaw lus sib tham yuav tshwm nrog cov ntaub ntawv hais txog koj lub computer.
- Txhawm rau nkag tau yooj yim rau Microsoft Excel, nyem thiab rub lub cim Excel, los ntawm kauj ruam 3, mus rau koj lub desktop.
- Lub npov lub npe nyob rau sab saud yog daim ntawv qhia seb lub xovtooj twg raug xaiv.
Lus ceeb toom
- Nco ntsoov xyuas kom meej tias cov zauv uas koj tsim rau koj phau ntawv qib tau suav qhov raug.
- Nco ntsoov tias koj khaws koj qhov kev kawm tau zoo thoob plaws los tiv thaiv cov ntaub ntawv poob thaum koj ua haujlwm.
- Ib txwm khaws cov thaub qab ntawm koj phau ntawv qib thiab khaws cov ntawv nyuaj.
