Ua haujlwm nyob rau hauv Excel heev yooj yim rau peb txoj haujlwm, vim hais tias tus lej lej rov qab hloov txhua qhov kev hloov hauv ib qho thib ob. Nws yooj yim heev! Yog tias koj tab tom pib nkag siab txog lub peev xwm ntawm txoj haujlwm no, koj tuaj yeem kawm paub siv kab kos saib pom kev hloov pauv hauv koj cov ntaub ntawv. Thaum koj paub qhov no, koj tuaj yeem daws cov teeb meem no hauv ob peb feeb.
Cov Lus Qhia
Kauj ruam 1
Thaum peb kuaj cov kab ntawm kev ua haujlwm, nws yog qhov tsim nyog yuav tsum paub npaj cov ntaub ntawv. Hauv thawj kab, pib ntawm kab B, peb sau qhov tseem ceeb ntawm X ntawm cov ntsiab lus uas peb yuav tshuaj xyuas kab xwm ntawm txoj haujlwm. Piv txwv li, pib txij -3 nrog kauj ruam ntawm 0.2 txog 3 suav nrog. Peb yuav tsum xav txog kab xwm ntawm tus muaj nuj nqi y = (x + 2) / x ^ 2. Tom qab ntawd nws yog ib qho tseem ceeb kom sau cia lub laij mis xam kom raug. Rau kab ntawv B, nws yuav zoo li qhov no: = (B1 + 2) / B1 ^ 2. Nws tseem tsuas yog theej cov qauv no rau txhua lub hlwb ntawm kab thib ob hauv qab nkag ntawm qhov tseem ceeb ntawm X. Nws paub tseeb tias X tsis tuaj yeem sib npaug ua xoom, vim nws tsis tuaj yeem faib 0. Yog li ntawd, yuav tsum ceev faj, vim tias Excel tsis tuaj yeem kos cov duab tsis tseem ceeb rau infinity, thiab yuav yooj yim txuas rau yav dhau los thiab tom ntej cov ntsiab lus nrog cov kab muaj zog.
Kauj ruam 2
Cia peb xaiv cov ntaub ntawv npaj, nyiam dua ua ke nrog cov ntawv cim. Piv txwv li, yog tias koj cov ntaub ntawv raug sau txhua hli rau ntau lub tuam txhab, tom qab ntawd cov npe ntawm cov tuam txhab, lub hlis thiab cov ntaub ntawv nws tus kheej yuav tsum raug xaiv tib lub sijhawm. Tom qab ntawd hauv cov ntawv qhia zaub mov peb nias "Ntxig" thiab hauv cov submenu xaiv "Diagram …".
Kauj ruam 3
Lub sijhawm tseem ceeb tshaj plaws los, vim nws yog qhov yuav tsum tau xaiv hom duab ntawm daim duab. Daim duab uas kheev siv feem ntau yog "Daim Duab" (hauv cov ntawv qub nws hu ua "Kab Tawm"), tshwj xeeb tshaj yog thaum ntsuas ntsuas txhua xyoo, txhua hli lossis txhua hnub. Daim duab "Teeb" tso cai rau peb los tsim cov duab kos ntawm kev hloov pauv nrog lub sijhawm ntev tsis hloov raws li lub sijhawm, thaum daim duab nws tus kheej tau nkag siab txawm tias tus pib tshiab. Thaum kuaj cov phiaj xwm ua haujlwm, Cov phiaj xwm Scatter zoo tshaj. Yog tias peb xav pom cov kev qhia tawm ntawm cov ntsuas tshwj xeeb hauv qhov hnyav tag nrho, ces "Daim Npav" lossis "Donut" cov duab kos tau zoo. Peb xaiv, piv txwv li, "Graph". Nyem "Tom ntej".
Kauj ruam 4
Hauv lub thawv ntawv sib tham tshiab, peb tuaj yeem pom seb peb daim duab yuav zoo li cas. Yog tias cov phiaj xwm ntawm cov ntaub ntawv tsis meej, sim hloov cov kab kom cov duab kos tsis suav nrog kab, tab sis hauv kab. Muaj kev xaiv cov kev xaiv zoo tshaj plaws, koj tuaj yeem nyem "Ua tiav", txij li hauv cov thawv txuas ntxiv tom ntej no peb tsuas yog tuaj yeem kho cov npe ntawm kab ntawv, kab kos, xim, ntxiv rau qhia seb puas yuav qhia tau cov kab ntawv ntawm daim ntawv sib txawv, lossis nyob rau tib qho chaw uas cov ntaub ntawv nws tus kheej nyob.
