MS Works Spreadsheets Cov Qauv

01 ntawm 08

Cov Qauv Kev Ntsuam Xyuas

Cov qauv tso cai rau koj ua cov lus teb rau cov ntaub ntawv nkag mus rau hauv koj cov ntaub ntawv .

Koj siv tau daim ntawv tshaj tawm cov ntawv xov xwm rau cov lej yooj yim, xws li sib ntxiv lossis rho tawm, nrog rau cov kev suav ntau ntxiv xws li kev them nyiaj tawm haujlwm lossis cov txiaj ntsim ntawm cov tub ntxhais kawm qhov kev xeem. Cov qauv hauv kem E nyob rau hauv daim duab saum toj no suav ib lub khw muag khoom lub quarter thib muag los ntawm kev ntxiv cov muag rau txhua lub hli.

Ntxiv mus, yog tias koj pauv cov ntaub ntawv MS Works yuav rov ntsuas cov lus teb tsis muaj koj rov nkag rau qhov formula.

Cov kev qhia hauv qab no qhia txog kev siv cov qauv, xws li cov kauj ruam ua piv txwv ntawm cov qauv MS Workssheets yooj yim.

02 ntawm 08

Sau lub mis

Kev sau cov qauv hauv MS Works spreadsheets nws txawv me ntsis tshaj qhov uas nws tau ua hauv chav kawm zauv.

Ib qho qauv MS Works pib nrog qhov sib npaug sib npaug (=) es tsis xaus nrog nws.

Daim phiaj xwm sib npaug yeej ib txwm mus rau hauv lub xov tooj ntawm tes uas koj xav kom lub cev teb tuaj.

Daim phiaj xwm sib npaug qhia paub MS Works tias qhov ua tau raws li nram no yog ib feem ntawm tus qauv, thiab tsis yog lub npe lossis tus nab npawb.

Ib qho MS Works formula yuav nyiam qhov no:

= 3 + 2

es tsis yog:

3 + 2 =

03 ntawm 08

Xov tooj ntawm tes hauv cov qauv

Thaum lub mis nyuj nyob rau hauv cov kauj ruam dhau los, nws muaj ib qhov teeb meem. Yog tias koj xav hloov cov ntaub ntawv raug xam koj xav hloov los yog rov sau dua cov mis.

Ib txoj kev zoo dua tuaj yeem sau cov formula kom koj hloov tau cov ntaub ntawv tsis tas hloov pauv nws tus kheej.

Ua li no, koj yuav ntaus cov ntaub ntawv rau hauv hlwb thiab tom qab ntawd, hauv cov mis, qhia rau MS Works uas lub hlwb nyob rau hauv daim ntawv khom nqi cov ntaub ntawv nyob hauv. Ib lub xov tooj ntawm tes nyob rau hauv daim ntawv khom nqi yog hu ua nws cov xov tooj .

Yuav nrhiav ib lub xov tooj ntawm tes, saib ntawm cov kab ntawv sab nraud kom pom cov kem ntawm lub xov tooj ntawm tes, thiab thoob plaws los nrhiav cov kab uas nws nyob hauv.

Lub xov tooj ntawm tes yog ib qho ua ke ntawm kem ntawv thiab kab leej twg - xws li A1 , B3 , lossis Z345 . Thaum sau cov xov tooj ntawm tes ntawm daim ntawv qhia kab ntawv txhua zaus los ua ntej.

Yog li, tsis yog sau cov qauv no hauv cell C1:

= 3 + 2

sau qhov no xwb:

= A1 + A2

Lus Cim: Thaum koj nias rau ntawm ib lub xov tooj uas muaj cov qauv hauv MS Works (saib daim duab saum toj no), cov mis yeej tshwm nyob hauv qhov formula formula nyob saum toj sau ntawv.

04 ntawm 08

Hloov MS Works Spreadsheets Cov Qauv

Thaum koj siv cov references ntawm xov nyob rau hauv ib qho MS Works spreadsheet, lub mis yuav tuaj yeem hloov kho tshiab thaum twg cov ntaub ntawv tseem ceeb hauv cov ntawv khom nqi.

Piv txwv li, yog tias koj paub tias cov ntaub ntawv hauv xov tooj ntawm tes A1 yuav tsum yog ib qho 8 es tsis txhob muaj 3, koj tsuas yog xav hloov cov khoom ntawm tes A1.

MS Works teb cov lus teb hauv xov tooj ntawm tes C1. Cov mis, nws tus kheej, tsis tas yuav hloov vim nws tau sau ntawv siv cov xov tooj ntawm tes.

Hloov cov ntaub ntawv

1. Nyem ntawm tus xovtooj ntawm A1
2. Qhib ib qho 8
3. Nias tus yuam sij ENTER rau cov keyboard

Cov lus teb hauv Cell C1, qhov uas yog qhov mis, tam sim ntawd hloov ntawm 5 txog 10, tab sis qhov mis nws tus kheej tsis hloov.

05 ntawm 08

Zauv Cov Neeg Khiav Haujlwm hauv Cov Qauv

Tsim cov qauv hauv MS Works Spreadsheets tsis yooj yim. Cia li muab cov xov tooj ntawm cov xov tooj ntawm koj cov ntaub ntawv nrog tus zauv tseeb tus neeg teb xov tooj.

Cov neeg paub siv lej siv hauv MS Works spreadsheets formulas zoo li cov uas siv hauv chav kawm lej.

• Rho tawm - rho npe tawm ( - )
• Ntxiv - ntxiv rau kos npe ( + )
• Phaj - luaj luaj ( / )
• Txooj - cim ( * )
• Exponentiation - caret ( ^ )

Kev Thaj Tsam ntawm Haujlwm

Yog tias ntau tshaj ib tus neeg khiav lag luam raug siv mis, nws muaj ib qho kev txiav txim siab uas MS Works yuav ua raws li cov kev ua zauv. Qhov kev txiav txim ntawm kev ua haujlwm no yuav raug muab hloov los ntawm kev ntxiv rau cov kab ntawv sib npaug. Ib qho yooj yim uas yuav tsum nco ntsoov qhov kev txiav txim ntawm kev ua haujlwm yog siv cov lus cim:

TSHAJ

Txoj Haujlwm ntawm Kev Ua Haujlwm yog:

B rackets
Thiab thaum kawg
D ivision
M kawg
Ib tug ddition
S ub nroj

Qhov Kev Tshaj Tawm Ntawm Kev Ua Haujlwm Piav Qhia

1. Cov kev lag luam uas muaj nyob rau hauv cov khoom yuav tsum nqa ua ntej
2. Cov khoom siv yog nqa tawm ob.
3. MS Works xam cov kev faib haujlwm lossis kev sib npaug ntawm qhov sib npaug los ua qhov sib npaug tseem ceeb, thiab ua kom tiav cov haujlwm no raws li lawv tau ua tiav rau sab xis.
   
4. MS Works kuj suav qhov sib ntxiv thiab sib faib kom muaj kev sib txig sib luag. Qhov twg puas yog ib qho tshwm sim ua ntej hauv ib qho kev ua kom sib npaug, qhov sib ntxiv lossis sib rho, yog qhov ua haujlwm ua ntej.

06 ntawm 08

MS Works Spreadsheets Formula Nyeem: Kauj ruam 1of 3 - Nkag mus rau Cov Ntaub Ntawv

Cia sim sim ib kauj ruam yog piv txwv. Peb yuav sau ib daim ntawv yooj yim hauv MS Works spreadsheet ntxiv rau cov zauv 3 + 2.

Kauj ruam 1: Nkag mus rau cov ntaub ntawv

Nws yog qhov zoo tshaj yog tias koj xub sau tag nrho koj cov ntaub ntawv rau hauv daim ntawv khom nqi ua ntej koj pib tsim cov qauv. Li no koj yuav paub tias puas muaj teeb meem qhov teeb meem, thiab nws tsis tshua xav tias koj yuav tsum kho koj cov mis tom qab ntawd.

Yog xav tau kev pabcuam nrog rau qhov kev nyeem no xa mus rau cov duab saum toj no.

1. Ntaus 3 hauv Cell A1 thiab nias qhov ENTER yawm ntawm cov ntawv.
   
2. Ntaus tus 2 hauv A2 cell thiab nias qhov ENTER yawm ntawm cov keyboard.

07 ntawm 08

Kauj ruam 2 ntawm 3: Ntaus qhov sib npaug (=) Kos npe

Thaum tsim cov qauv hauv kev ua haujlwm MS Works Spreadsheets, koj yuav pib los ntawm sau tus cim sib npaug. Koj ntaus nws hauv lub xov tooj ntawm tes uas koj xav tau lo lus teb tshwm.

Kauj ruam 2 ntawm 3

Xav tau kev pab nrog qhov kev piv txwv no xa mus rau cov duab saum toj no.

1. Nias ntawm tes C1 (teev hauv dub nyob hauv daim duab) nrog koj tus pointer nas.
   
2. Sau qhov sib npaug sib npaug rau ntawm tes C1.

08 ntawm 08

Kauj Ruam 3: Ntxiv Cov Xov Tooj Ntawm Xov Tooj Uas Siv Taw Qhia

Tom qab sau tus cim sib npaug hauv kauj ruam 2, koj muaj ob txoj kev xaiv ntxiv cov lus xa xov mus rau cov ntawv xov xwm.

1. Koj tuaj yeem ntaus lawv los yog,
2. Koj tuaj yeem siv MS Professional feature hu ua taw qhia

Taw tes tso cai rau koj nyem nrog koj tus nas ntawm lub xov tooj ntawm tes uas muaj koj cov ntaub ntawv ntxiv rau nws lub xov tooj ntawm tes rau lub mis.

Kauj Ruam 3 ntawm 3

Mus txuas ntxiv ntawm kauj ruam 2 rau qhov ua piv txwv no

1. Nyem ntawm tes A1 nrog tus nas pointer
2. Sau ib daim ntawv ntxiv (+)
3. Nyem ntawm tes A2 nrog tus nas pointer
4. Nias tus yuam sij ENTER rau cov keyboard
5. Cov lus teb 5 yuav tsum tshwm sim rau ntawm tes C1.

Lwm Cov Kev Pab Uas Pab Tau

• Microsoft Works Task Launcher
• Microsoft Works Spreadsheets Tutorial
• MS Works Spreadsheets Cov Qauv