Qhib Chav Ua Haujlwm Calc Basic Spreadsheet Tutorial

Open Office Calc, yog ib qho kev tshaj tawm hauv khoos phis tawj tau dawb los ntawm openoffice.org. Qhov kev pab cuam yog ib qho yooj yim mus siv thiab muaj feem ntau, yog tias tsis tag nrho cov qauv siv tau nyob hauv spreadsheets xws li Microsoft Excel.

Cov ntawv nyeem no siv cov kauj ruam los tsim ib qho kev tshaj tawm hauv Open Office Calc.

Ua kom tiav cov kauj ruam hauv cov ncauj lus hauv qab no yuav tsim ib daim ntawv tshaj tawm zoo ib yam li cov duab saum toj no.

01 ntawm 09

Cov Ntsiab Lus Kawm

Qee cov ntsiab lus uas yuav raug them:

• Muab cov ntaub ntawv ntxiv rau ib daim ntawv tshaj tawm
• Widening Txhua
• Ntxiv Hnub Ua Haujlwm thiab Ntau Lub Npe
• Ntxiv cov qauv
• Hloov cov ntaub ntawv kawm zauv hauv hlwb
• Tawm xov tooj - feem pua ​​thiab txiaj
• Hloov cov xim keeb kwm ntawm tes
• Hloov xim xim

02 ntawm 09

Nkag Mus rau Cov Ntaub Ntawv Tso hauv Chaw Ua Hauj Lwm Qhib Calc

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.

Cov ntaub ntawv nkag mus rau hauv ib qho kev tshaj tawm yog ib txoj kev ua peb txheej txheem. Cov kauj ruam no yog:

1. Nias ntawm lub xovtooj uas koj xav tau cov ntaub ntawv mus.
   
2. Sau koj cov ntaub ntawv rau hauv lub xovtooj ntawm.
   
3. Nias tus yuam sij ENTER rau cov keyboard lossis nias ntawm lwm lub xovtooj nrog nas.

Rau qhov kev nyeem no

Ua raws li cov kev qhia no, sau cov ntaub ntawv teev tseg hauv qab no rau hauv ib daim ntawv dawb paug uas siv cov kauj ruam nram qab no:

1. Qhib daim ntawv dawb paug Calc spreadsheet.
   
2. Xaiv lub xov tooj ntawm tes uas qhia los ntawm cov xov tooj ntawm tes siv .
   
3. Ntaus cov ntaub ntawv sib thooj rau hauv lub xov tooj xaiv.
   
4. Nias tus Enter Enter rau hauv keyboard lossis nias rau ntawm tus xovtooj tom ntej hauv daim ntawv nrog tus nas.

Cov Ntaub Ntawv Xovtooj

A2 - Txiav Nyiaj Them Nqi rau Neeg Ua Hauj Lwm A8 - Lub Xeem A9 - Smith B. A10 - Wilson C. A11 - Thompson J. A12 - James D.

B4 - Hnub tim: B6 - Txiav nqi: B8 - Cov nyiaj hli tag nrho B9 - 45789 B10 - 41245 B11 - 39876 B12 - 43211

C6 - .06 C8 - Txiav D8 - Cov Nqi Nyiaj

Rov qab mus rau nplooj ntawv Index

03 ntawm 09

Widening Txhua

Widening Txhua Hauv Chaw Ua Hauj Lwm Qhib Calc:

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.

Tom qab nkag hauv cov ntaub ntawv koj yuav pom tau tias ntau lo lus, xws li Txiav , ntau dhau rau ib lub xovtooj. Los kho qhov no kom tag nrho cov lus pom:

1. Muab tus pointer pointer ntawm kab ntawm kab C thiab D rau sab header .
   
2. Tus pointer yuav hloov mus rau ob-coj xub.
   
3. Nias nrog rau sab laug nas khawm thiab luag ob-taw xub mus rau sab xis sab sab C.
   
4. Tshawb cov kab nrib los muab cov ntaub ntawv raws li xav tau.

Rov qab mus rau nplooj ntawv Index

04 ntawm 09

Ntxiv Hnub thiab Ntau Lub Npe

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.

Nws yog qub ntxiv rau hnub rau ib qho kev tshaj tawm. Ua tau rau hauv Open Office Calc yog ib lub xov tooj ntawm DATE cov haujlwm uas tuaj yeem siv los ua qhov no. Nyob hauv phau ntawv nyeem no peb yuav siv cov kev ua txij ua tiav.

1. Nyem ntawm tes C4.
   
2. Hom = HNUB NO ()
   
3. Nias tus yuam sij ENTER rau cov keyboard.
   
4. Hnub tim yuav tsum tshwm sim rau ntawm C4

Ntxiv Npe Ntawm Qhov Chaw Qhib Rau Chav Qhib Calc

1. Xaiv cov xovtooj ntawm C6 rau hauv daim ntawv khom nqi .
   
2. Nias ntawm lub Thawv Npe .
   
3. Hom "tus nqi" (tsis muaj quotes) hauv lub Thawv Npe.
   
4. Cell C6 tam sim no muaj lub npe ntawm "tus nqi". Peb yuav siv lub npe los txhim kho cov qauv kev tsim qauv nyob hauv kauj ruam tom ntej.

Rov qab mus rau nplooj ntawv Index

05 ntawm 09

Ntxiv cov qauv

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.

1. Nyem ntawm tes C9.
   
2. Ntaus hom formula = B9 * tus nqi thiab nias tus Sau rau ntawm tus keyboard.

Xam nyiaj hli

1. Nyem ntawm tes D9.
   
2. Ntaus hom formula = B9 - C9 thiab nias tus Sau rau ntawm tus keyboard.

• Cov ntaub ntawv ntxiv mis:
  Qhib Office Calc Formulas Nyeem

Luam cov qauv hauv hlwb Cell C9 thiab D9 rau lwm lub hlwb:

1. Nyem ntawm tes C9 dua.
   
2. Tshem cov pointer nas hla kev tuav (lub me me dub teev) hauv qab ntawm kaum sab xis ntawm lub xovtooj ntawm tes .
   
3. Thaum lub pointer hloov mus rau ib qho dub "ntxiv rau kev kos npe", nias thiab puag hauv pob nyem khawm thiab luag tus ua daim pib rau ntawm C12. Tus qauv hauv C9 yuav muab theej mus rau cells C10 - C12.
   
4. Nyem ntawm tes D9.
   
5. Rov ua li cov kauj ruam 2 thiab 3 thiab rub tus npuaj kab rau hauv D12. Tus qauv hauv D9 yuav muab theej mus rau lub hlwb D10 - D12.

Rov qab mus rau nplooj ntawv Index

06 ntawm 09

Hloov Cov Txheej Txheem Tshaj Lij

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no. Zoo li, yog tias koj tso koj tus nas dhau ib qho ntawm ib qhov toolbar, lub icon lub npe yuav muab tso tawm kom pom.

1. Xaiv lub hlwb A2 - D2.
   
2. Nias ntawm lub Cov Ntawv Xov Xwm Ntawm Cov Tuam Rooj Sib Tham nyob rau ntawm Formatting toolbar los ua ke rau lub hlwb xaiv.
   
3. Nias rau ntawm Qhov Chaw Nruab Nrab Horizontally icon nyob rau Formatting toolbar los nruab nrab lub npe ntawm thaj chaw xaiv.
   
4. Tsav xaiv lub hlwb B4 - B6.
   
5. Nias rau ntawm txoj hlua raws txoj cai nyob rau ntawm Formatting toolbar rau txoj kab ntawm cov ntaub ntawv hauv cov hlwb.
   
6. Tsav xaiv lub hlwb A9 - A12.
   
7. Nias rau ntawm txoj hlua raws txoj cai nyob rau Formatting toolbar rau txoj cai ntawm cov ntaub ntawv hauv cov hlwb.
   
8. Xaiv lub hlwb A8 - D8.
   
9. Nias rau ntawm Qhov Chaw Nres Nkag Horizontally icon nyob rau Formatting toolbar los nruab nrab ntawm cov ntaub ntawv hauv cov hlwb.
   
10. Tsav xaiv hlwb C4 - C6.
    
11. Nias rau ntawm Qhov Chaw Nres Nkag Horizontally icon nyob rau Formatting toolbar los nruab nrab ntawm cov ntaub ntawv hauv cov hlwb.
    
12. Tsav xaiv lub hlwb B9 - D12.
    
13. Nias rau ntawm Qhov Chaw Nres Nkag Horizontally icon nyob rau Formatting toolbar los nruab nrab ntawm cov ntaub ntawv hauv cov hlwb.

07 ntawm 09

Muab Tus Ntaus Npe Ntxiv

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no. Zoo li, yog tias koj tso koj tus nas dhau ib qho ntawm ib qhov toolbar, lub icon lub npe yuav muab tso tawm kom pom.

Teeb meem formatting hais txog kev ntxiv cov cim cim, zauv cim, feem pua ​​cim, thiab lwm cov cim uas pab txheeb xyuas cov hom ntaub ntawv nyob rau hauv xov tooj ntawm tes thiab ua kom yooj yim nyeem.

Hauv kauj ruam no peb ntxiv feem pua ​​cim thiab cim cim rau peb cov ntaub ntawv.

Ntxiv ntawm Feem Pej Xeem

1. Xaiv ntawm tes C6.
   
2. Nias rau ntawm tus Naj Npawb Hom: Tshem Pes Nres nyob rau Formatting toolbar ntxiv cov cim feem pua ​​rau lub xov tooj xaiv.
   
3. Nias rau ntawm tus Naj Npawb Hom: Tshem Pua Decimal Place icon nyob rau Formatting toolbar ob zaug kom tshem ob qhov zauv.
   
4. Cov ntaub ntawv hauv xov tooj C6 yuav tsum tam sim no nyeem li 6%.

Ntxiv cov cim cim

1. Tsav xaiv lub hlwb B9 - D12.
   
2. Nias lub Naj Naj Naj Npawb: Nthuav cov cim nyob rau Formatting toolbar ntxiv cov cim sau npe rau lub hlwb xaiv.
   
3. Cov ntaub ntawv nyob rau hauv hlwb B9 - D12 yuav tsum tam sim no qhia lub cim cim ($) thiab ob zauv chaw.

Rov qab mus rau nplooj ntawv Index

08 ntawm 09

Hloov cov xim keeb kwm ntawm tes

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no. Zoo li, yog tias koj tso koj tus nas dhau ib qho ntawm ib qhov toolbar, lub icon lub npe yuav muab tso tawm kom pom.

1. Tsav xaiv lub hlwb A2 - D2 ntawm daim ntawv khom nqi.
   
2. Nias ntawm Background Color icon nyob rau Formatting toolbar (zoo li xim muaj peev xwm ua tau) qhib xim tom qab tso npe cia.
   
3. Xaiv Xiav Xiav ntawm daim ntawv los hloov cov xim keeb kwm yav dhau ntawm lub hlwb A2 - D2 rau xiav.
   
4. Tsav xaiv lub hlwb A8 - D8 ntawm lub spreadsheet.
   
5. Rov qauj ruam 2 thiab 3.

Rov qab mus rau nplooj ntawv Index

09 ntawm 09

Hloov xim xim

Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no. Zoo li, yog tias koj tso koj tus nas dhau ib qho ntawm ib qhov toolbar, lub icon lub npe yuav muab tso tawm kom pom.

1. Tsav xaiv lub hlwb A2 - D2 ntawm daim ntawv khom nqi.
   
2. Nias rau ntawm Tsab Ntawv Xim Npe ntawm Formatting toolbar (nws yog ib daim ntawv loj loj "A") los qhib xim xim kos cia npe.
   
3. Xaiv White ntawm daim ntawv los hloov cov xim ntawm cov ntawv nyeem hauv hlwb A2 - D2 mus dawb.
   
4. Tsav xaiv lub hlwb A8 - D8 ntawm lub spreadsheet.
   
5. Rov qauj ruam 2 thiab 3 saum toj no.
   
6. Tsav xaiv lub hlwb B4 - C6 ntawm tsab ntawv khom nqi.
   
7. Nias rau ntawm Daim Phiaj Xim Xim ntawm daim Formatting toolbar kom qhib lub xim xim cim npe.
   
8. Xaiv Xiav Xiav ntawm daim ntawv los hloov cov xim ntawm cov ntawv nyeem hauv hlwb B4 - C6 xiav.
   
9. Tsav xaiv lub hlwb A9 - D12 ntawm lub spreadsheet.
   
10. Rov ua li cov kauj ruam 7 thiab 8 saum toj no.
    
11. Nyob rau ntawm lub sij hawm no, yog tias koj tau ua raws li tag nrho cov kauj ruam ntawm phau ntawv no kom raug, koj daim ntawv tshaj tawm yuav tsum zoo li cov ntawv khom nqi hauv daim ntawv qhia ua theem 1 ntawm qhov kev qhia no.

Rov qab mus rau nplooj ntawv Index