Excel cov ntaub ntawv software muaj lub sijhawm zoo rau kev ua cov ntaub ntawv digital. Tab sis tsis muaj ib lub rooj tuaj yeem nthuav qhia tus txheej txheem kom meej meej raws li lub teeb ntsuas ntawm cov haujlwm uas piav qhia nws. Hauv Excel kuj tseem muaj qhov tshwm sim hauv cov ntawv qhia zaub mov Sau - Daim ntawv (rau Microsoft Office 2003).
Tsim nyog
Microsoft Excel 2003 software
Cov Lus Qhia
Kauj ruam 1
Qhib cov nplooj ntawv dawb paug ntawm phau ntawv ua haujlwm Microsoft Excel 2003. Xav txog cov kauj ruam uas koj yuav tsum xam cov ntsiab lus ntawm kab ntsuas ntawm txoj haujlwm hauv lub rooj. Qhov ntau cov teeb nraaj ntawm txoj haujlwm, qhov tsawg dua cov kauj ruam koj yuav tsum tau coj los ua kom tseeb dua cov phiaj xwm. Hauv thawj kab ntawv ntawm lub rooj rau qhov muaj nuj nqis ntawm qhov kev sib cav muaj nuj nqi, sau rau thawj ob qhov tsawg tshaj plaws qhov tseem ceeb los ntawm cov nyiaj txaus siab. Tom qab ntawd, xaiv lawv nrog lub thaiv siv "nas".
Kauj ruam 2
Txav tus nas cursor mus rau sab hauv qab yog kaum ntawm cov xaiv, nws yuav coj daim ntawv hla dub. Nias lub sab laug thiab xaub nqes, cheem tus cursor tom kawg ntawm cov txiaj ntsig. Qhov no yuav tsim cov nuj nqi ntawm kev sib cav. Piv txwv li, yog tias koj xav tau txais lub teeb ntawm txoj haujlwm hauv qhov ntau (-10; 10) nrog kauj ruam ntawm 0, 5, thawj ob qhov tseem ceeb yuav yog -10 thiab -9, 5, thiab koj yuav tsum nres tus cursor tom qab tus lej 10 tshwm hauv kab ntawv.
Kauj ruam 3
Txhawm rau txhim kho ib kem ntawm qhov muaj nuj nqis, hauv lub xov tooj ntawm ib sab kom tsawg tshaj tus nqi ntawm qhov kev sib cav, tso tus kab tus me thiab nias "=". Tom qab ntawv, ntaus tus qauv hloov chaw siv tsis txhob sib cav (tus nqi "x"), tas li nias "nas" ntawm tus xovtooj uas nyob ib sab. Tom qab cov mis raug ntaus, nias tus yuam sij Enter. Cov nuj nqi muaj nuj nqi rau kev sib cav los ntawm thawj kem tshwm hauv kab ntawm tes. Muab tus cursor rau tus nqi no ua haujlwm. Tsiv tus nas cursor mus rau hauv qab yog kaum ntawm lub xov tooj thiab pom tus ntoo khaub lig dub, rub nws mus rau qhov kawg ntawm qhov ntau ntau los ntawm nias lub khawm sab laug. Kem qhia txog cov nuj nqi muaj nuj nqi sib haum rau cov lus sib cav hauv thawj kem.
Kauj ruam 4
Xaiv "Ntxig" - "Daim ntawv" los ntawm cov ntawv qhia. Hauv qhov rai uas qhib, xaiv "Hnov". Ntawm sab xis ntawm lub qhov rais, xaiv "Scatter chart nrog cov nqi sib txuas los ntawm cov kab ncaj ncaj tsis muaj qhov cim" cov duab saib. Nyem "Tom ntej". Hauv qhov rai uas qhib, teeb tsa tus taw tes rau "Rows hauv: kab ntawv" khoom. Nyem rau ntawm lub npov (checkbox) uas nyob rau sab xis ntawm txoj kab "Ntau" thiab nias lub khawm laug khawm xaiv tag nrho cov kev sib cav thiab qhov tseem ceeb. Nyem rau ntawm lub tab ntawm tib lub qhov rais "Series" thiab hauv kab "X qhov tseem ceeb" nrog "nas" qhia txog ntau ntawm kev sib cav. Nyem Tom ntej no khawm ob zaug, Tom qab ntawd Ua tiav. Lub teeb duab yuav raug hloov raws li kev hloov pauv ntawm tus qauv. Hauv lwm cov qauv, lub algorithm zoo ib yam nkaus thiab tsuas yog paub meej.
