01 ntawm 06
Kev Npaj Ua Haujlwm Rau Koj Tej Ntaub Ntawv Ua Haujlwm Microsoft
Npaj Ua Hauj Lwm Hauj Lwm Spreadsheet
Cov ntaub ntawv nkag mus rau hauv Microsoft Works spreadsheet yog ib qho yooj yim raws li txhaj rau ntawm tes , sau tus lej, ib hnub, lossis ib co ntawv thiab tom qab koj nias ENTER qhov tseem ceeb ntawm cov keyboard.
Txawm tias nws yog ib qho yooj yim mus nkag rau cov ntaub ntawv , nws yog ib lub tswv yim zoo ua ib txoj kev npaj ua ntej koj pib ntaus.
Cov ntsiab lus xav txog :
- Lub hom phiaj ntawm daim ntawv khom nqi yog dab tsi?
- Cov ntaub ntawv dab tsi yuav tsum tau muab xam nrog?
- Cov nqe lus twg yuav tsum tau los piav cov lus qhia hauv Works spreadsheet?
- Dab tsi yog qhov zoo tshaj plaws teeb tsa rau cov ntaub ntawv?
02 ntawm 06
Xov tooj ntawm tes hauv Microsoft Works Spreadsheets
Cell Xov xwm
- Cov ntaub ntawv khaws cia hauv hlwb nyob hauv Microsoft Works spreadsheet.
- Ib qho duab plaub me me nyob hauv ib qho hauj lwm spreadsheet yog ib lub xovtooj.
- Ib lub xovtooj yog qhov kev sibtshuam ntawm ib kem thiab kab hauv ib kab ntawv.
Spreadsheet Cov Lus Tseeb
- Txhua zaus khiav vau nyob rau hauv ib qho kev tshaj tawm thiab qhia los ntawm ib tsab ntawv.
- Cov kab pib khiav ntawm horizontally thiab raug qhia los ntawm tus xov tooj.
- Muaj 16,384 natwm, tshaj 200 kab, thiab yuav luag 4 lab lub hlwb nyob rau hauv txhua daim ntawv xov xwm hauj lwm.
Xovtooj Qhia Qhov Tseeb
- Yuav kom khiav ntawm tag nrho cov hlwb, txhua lub cell muaj xov tooj ntawm tes lossis chaw nyob.
- Ib tug xov tooj ntawm tes yog ib qho ua ke ntawm kem ntawv thiab tus lej kab.
- Lub xov tooj ntawm tes siv tau qhia nyob hauv lub npov lub npe saum sab A.
03 ntawm 06
Microsoft Cov Ntaub Ntawv Kev Tshaj Tawm Ntaub Ntawv
Nws muaj peb lub ntsiab lus ntawm cov ntaub ntawv siv Microsoft Works Spreadsheets:
- daim ntawv lo
- qhov tseem ceeb
- hnub / sijhawm
Ib daim ntawv lo yog ib qho nkag uas feem ntau yog siv rau cov hau lus, npe, thiab kom paub txhua kab lus. Cov ntawv yuav muaj cov ntawv thiab cov lej.
Tus nqi muaj cov zauv thiab siv tau rau hauv cov lus teb.
Cov ntaub ntawv hnub / lub sij hawm yog li ntawd, hnub tim lossis lub sijhawm nkag mus rau hauv ib lub xovtooj.
04 ntawm 06
Tshawb Txhua Hauv Cov Kev Tshaj Tawm Microsoft Works
Tshawb Txhua Hauv Cov Kev Tshaj Tawm Microsoft Works
Qee lub sij hawm cov ntaub ntawv yog qhov dav rau lub xov tooj ntawm tes nws nyob hauv. Thaum qhov no tshwm sim, cov ntaub ntawv kuj yuav yog los sis tsis tuaj yeem txeeb mus rau ntawm tes ntawm nws.
- Yog tias daim ntawv lo ntev heev rau lub xov tooj ntawm tes, tiam sis tsis muaj dab tsi nyob rau hauv lub xov tooj ntawm txoj cai ntawm nws daim ntawv lo tsuas yog kis mus rau hauv qhov chaw mus rau sab xis (saib cell B2 hauv daim duab saum toj no).
- Yog tias daim ntawv lo ntev heev rau lub xov tooj ntawm tes tab sis nws muaj cov ntaub ntawv nyob rau hauv lub xovtooj ntawm sab xis, daim ntawv lo yog txiav tawm. Cov ntawv pov thawj ntawm tseem niaj hnub tseem muaj, tsuas yog chav nyob hauv chav tsev xwb (saib cell B4 hauv daim duab saum toj no).
Yog tias daim ntawv qhia tawm raug txiav tawm, koj tuaj yeem qhib sab xa tuaj rau nws. Hauv Microsoft Works spreadsheets, koj tuaj yeem tsis qhib cov qe neeg, koj yuav tsum pib tag nrho cov kem.
Piv txwv - Tshooj Sab B:
- Muab koj tus pointer mouse rau kab ntawm kab B thiab C ntawm sab header .
- Thaum lub pointer hloov mus rau ob lub xub coj, nyem nrog nas khawm thiab luag rau sab xis.
05 ntawm 06
Tag Nrho Txhua Hauv Cov Kev Tshaj Tawm Microsoft Ua Haujlwm (tsis yog)
Tag Nrho Txhua Hauv Cov Kev Tshaj Tawm Microsoft Ua Haujlwm (tsis yog)
- Hauv Microsoft Works Spreadsheets, yog tias tus nqi ntev heev rau lub xovtooj, nws tsis txeej rau cov hlwb uas nyob ib sab txawm tias cov hlwb tsis muaj. Kem yuav tsum raug tsim ua ntej ua ntej tus nqi yuav tshwm.
Hauv daim duab saum toj no, tus nab npawb ntawm B2 nyob rau hauv (####) qhia tias muaj nqis (naj npawb) hauv cov xov tooj ntawm tes.
Piv txwv - Tshooj Sab B:
- Muab koj tus pointer mouse rau kab ntawm kab B thiab C ntawm sab header .
- Thaum lub pointer hloov mus rau ob lub xub coj, nyem nrog nas khawm thiab luag rau sab xis.
06 ntawm 06
Editing Cells hauv Microsoft Works Spreadsheets
Hloov Tiav Cell Txheem
- Hauv Microsoft Works spreadsheets yuav hloov tus txheem ntawm ib lub xovtooj, nyem rau ntawm tes, ntaus dua cov lus uas twb muaj lawm, thiab nias ENTER tus yuam sij nyob rau hauv cov keyboard.
Hloov Ib Feem Ntawm Cov Ntsiab Lus Ntawm Lub Cev
- Txoj Cai 1
- Nias ntawm lub xov tooj ntawm tes kom nws ua txoj haujlwm ntawm tes .
- Nias ntawm cov ntaub ntawv hauv cov qauv mis.
- Rho tawm qhov feem hloov thiab ntaus hauv cov ntaub ntawv tshiab.
- Nias lub khawm ENTER .
- Txoj Kev 2
- Ob npaug nias ntawm tes.
- Kho kom raug ib feem ntawm lub xov tooj ntawm tes koj xav hloov.
- Nias lub khawm ENTER .
Hauv qhov ua piv txwv saum toj no, cov naj npawb ntawm 5,6 thiab 7 hauv cov qauv formula tau muab tshem tawm los ntawm nias lub DELETE key rau cov keyboard thiab hloov nrog cov zauv sib txawv. Lwm cov khoom hauv phau ntawv no