Lub sij hawm daim ntawv nthuav tawm tau muab los ntawm daim ntawv loj uas cov neeg siv nyiaj txiag siv rau kev lag luam nyiaj txiag. Tus accountant yuav nthuav tawm cov ntaub ntawv xws li tus nqi, kev them nyiaj, se, cov nyiaj tau los, thiab lwm yam tawm ntawm ib leeg, loj, ntawv loj ntawm daim ntawv kom tau txais kev qhia meej txog nyiaj txiag.
Spreadsheets hnub no muaj ntau thiab siv ntau dua. Qee qhov piv txwv yog:
- Spreadsheets ua zoo li lub laij lej los ntawm kev suav xam.
- Spreadsheets tau siv los taug qab kev nqis peev ntawm tus kheej, peev nyiaj txiag, daim ntawv sau nqi, kev txheeb xyuas cov khoom lag luam, kev txheeb xyuas tus lej, tus lej ua qauv, phau ntawv chaw nyob, phau ntawv xov tooj, luam ntawv cim, thiab lwm yam.
- Spreadsheets tau siv nyob rau hauv yuav luag txhua txoj haujlwm los xam, teeb duab, tshuaj xyuas thiab khaws cov ntaub ntawv.
- Spreadsheets tau siv rau What-if calculations. Hloov ib tus lej hauv daim ntawv nthuav qhia thiab txhua qhov kev suav hauv daim ntawv nthuav dav yuav rov suav dua, yuav hloov pauv.
Nrog rau wiki no kawm paub siv OpenOffice Calc kom kawm paub koj txoj hauv kev ib puag ncig no muaj zog (thiab pub dawb) software.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Qhib Ntawv Spreadsheet
Kauj Ruam 1. Yog tias koj nyob hauv OpenOffice program, nyem File> New> Spreadsheet
-
Hauv ob qho xwm txheej ib daim ntawv hu ua Untitled1 tshwm ntawm peb lub vijtsam.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 1 Bullet 1
Txoj Kev 2 ntawm 3: Calc Toolbars
Plaub qhov Calc Toolbars hauv qab no tshwm nyob rau sab saum toj ntawm txhua Calc cov ntxaij vab tshaus.
Kauj Ruam 1. Tshuaj Ntsuam Xyuas Cov Ntawv Qhia Ua Haujlwm Zoo
-
Thawj lub cuab yeej yog Lub Hauv Paus Cov Ntawv Qhia toolbar uas muab rau koj nkag mus rau ntau yam ntawm cov lus txib yooj yim siv hauv Calc.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 2 Bullet 1
Kauj Ruam 2. Saib rau ntawm Function Toolbar
-
Qhov toolbar thib ob yog Function Toolbar. Txoj Haujlwm Pabcuam Toolbar muaj cov cim (duab) kom nkag tau sai rau cov lus txib xws li Tshiab, Qhib, Luam Ntawv, Luam, Muab Tshuaj, thiab lwm yam. npo.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 3 Bullet 1 -
Txav koj tus cursor hla lub cim. (Lo lus "Tshiab" tshwm. Nyem rau ntawm qhib daim ntawv tshiab.)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 3 Bullet 2
Kauj Ruam 3. Txheeb xyuas Cov Ntawv Cuam Tshuam Formatting
-
Qhov thib peb toolbar nqis yog Formatting Toolbar. Cov Ntawv Cuam Tshuam Toolbar muaj cov cim ntxiv rau cov ntawv qhia zaub mov uas tso cai rau koj xaiv tus font, xim xim, ua kom haum, tus lej tus lej, xaiv ciam teb thiab xim tom qab.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 4 Bullet 1
Kauj Ruam 4. Saib seb Formula Toolbar tuaj yeem ua dab tsi
-
Qhov toolbar thib plaub yog Formula Toolbar. Cov Ntawv Cuab Yeej Toolbar muaj Lub Npe Lub Npe cov ntawv qhia zaub mov nco thiab lub thawv dawb ntev hu ua Kab Kab Lus.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 5 Bullet 1 -
Nco tseg: Yog tias koj lub Toolbars zoo li txawv, nws yog vim cov cuab yeej no nyob hauv 800x600 npo daws teeb meem thiab yim lub cim kawg tsis pom tab sis muaj los ntawm txhaj rau ntawm sab xis ntawm lub toolbar.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 5 Bullet 2
Txoj Kev 3 ntawm 3: Daim Ntawv Qhia Nws Tus Kheej
Tus so ntawm lub qhov rais muaj daim ntawv nthuav qhia. Daim ntawv nthuav tawm tau muab faib ua kab uas muaj tus lej nyob ntawm sab laug ntawm txhua kab thiab muab faib ua kab nrog cov ntawv nyob rau sab saum toj ntawm txhua kab ntawv.
Kauj Ruam 1. Kawm lub ntsiab lus ntawm lub xov tooj ntawm tes hauv daim ntawv nthuav tawm
-
Cell yog lub hauv paus tseem ceeb ntawm daim ntawv ua haujlwm. Nov yog qhov khoom ntxiv thiab qhov twg pom. Ib qhov chaw nyob ntawm tes hauv daim ntawv nthuav qhia qhia qhov chaw nyob ntawm tes nyob hauv daim ntawv nthuav qhia. Ib qhov chaw nyob ntawm tes yog kev sib txuas ntawm kab ntawv thiab kab lej ntawm tus xovtooj, xws li A2 lossis B16.etc. Thaum txheeb xyuas lub xovtooj ntawm nws qhov chaw nyob, kab ntawv ib txwm raug sau ua ntej ua raws tus lej. Qhov chaw nyob ntawm tes ntawm qhov piv txwv hauv qab no yog A5.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 6 Bullet 1
Kauj Ruam 2. Sau Cov Ntaub Ntawv
-
Nyem rau ntawm A1 cell (Lub xovtooj ntawm sab saum toj kawg nkaus ntawm daim ntawv nthuav qhia).
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 7 Bullet 1 -
Pom qhov ciam teb dub hnyav nyob ib puag ncig A1 ntawm tes. Tus ciam dub hnyav qhia tias A1 yog lub cell nquag. (A yog nyob rau sab saum toj ntawm thawj kab ntawv thiab 1 yog nyob rau thawj kab. Ob qho tseem ceeb tau hais tseg. Qhov tseem ceeb tseem qhia tau tias A1 yog lub cell nquag.)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 7 Bullet 2 -
Ntaus Nyob Zoo Ntiaj Teb thiab nias Enter.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 7 Bullet 3 Tam sim no cov cell nquag yog A2. (Cov lus "Nyob Zoo Ntiaj Teb" nyob hauv A1.)
-
Thaum koj ntaus ib yam dab tsi hauv xovtooj ntawm tes thiab nias Enter, qhov koj ntaus ntawv tau pom hauv lub xovtooj ntawd thiab lub xovtooj hauv qab no dhau los ua lub cell txuas ntxiv.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 7 Bullet 4 Kauj Ruam 3. Rho Tawm Cov Ntaub Ntawv
-
Nyem rau A1 dua.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Nrog OpenOffice.org Calc Step 8 Bullet 1 -
Nias lub Rho tawm qhov tseem ceeb lossis txoj cai nyem rau ntawm tes thiab xaiv rho tawm cov ntsiab lus. (Qhov "Rho Tawm Cov Ntsiab Lus" qhov rai tshwm.)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 8 Bullet 2 -
Kos rau lub npov Delete tag ces nyem OK. ("Nyob Zoo Ntiaj Teb" raug tshem tawm ntawm A1)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 8 Bullet 3 Kauj Ruam 4. Format Cov Ntaub Ntawv
-
Sib cais Ntau txhiab, Ob Qhov Chaw Zaum Kawg, Liab Tsis Zoo Tus Zauv. Nyem cell A1. > Ntaus tus lej -9999.129> Nias Sau. (Tus cursor txav mus rau cell A2)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 9 Bullet 1 -
Txoj cai-nias ntawm tes A1. (Cov ntawv qhia zaub mov me me tshwm)> nyem Format cells. (Qhov "Format cells" window tshwm)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 9 Bullet 2 -
Nyem Numbers tab. Hauv "Pawg", nyem rau Tus lej. Hauv qab "Format", nyem rau -1, 234.12. Nyem Hauv lub thawv me me ua ntej "Cov lej tsis zoo liab". (Cov cim kos tshwm nyob rau hauv lub thawv)> Nyem OK. (Tus lej '-9, 999.13 "tshwm hauv cell A1.
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 9 Bullet 3 -
Align Left, Nyem Alignment tab. Hauv kab ntawv "Kab rov tav" rub tawm, xaiv Sab laug. Nyem OK. (cov lej txav mus rau sab laug ntawm tes.)
Kawm Daim Ntawv Qhia Txog Cov Ntawv Qhia Qhib nrog OpenOffice.org Calc Step 9 Bullet 4 Lub tswv yim
-
Muaj ob txoj hauv kev xaiv cov kab lossis kab uas nyob ib sab:
- Nyem rau kab lossis kab lus taub hau thiab luag nws kom xaiv kab lossis kab uas nyob ib sab;
- Lossis, xaiv thawj kab lossis kab ntawv thiab tom qab ntawv kab lossis kab kawg los ntawm nias ua haujlwm.
-
-
-
