Kawm paub tsim lub teeb duab ntawm lub voj voog siv kev txhaum (sine) thiab cos (cosine) ua haujlwm hauv Microsoft Excel hauv kab lus no. Ib qho ntxiv, koj yuav kawm paub txo lub voj voog, phiaj lub vojvoog thiab ua kom qis lossis nthuav lub voj voog thiab lub vojvoog ib txhij.
Cov kauj ruam
-
Ua kom paub txog cov duab yooj yim los tsim:
Duab
Ntu 1 ntawm 3: Tutorial
Kauj Ruam 1. Qhib phau ntawv XL ua haujlwm tshiab los ntawm lub desktop
- Nyem rau ntawm lub cim ntsuab X ntawm Dock kom Excel ua haujlwm tau zoo.
- Muab tso rau ntawm qhov khoom nrog cov xim daj nyob rau sab laug ntawm lub qhov rais ntawm ib qho XL phau ntawv ua haujlwm tau qhib.
- Ua Cov Ntawv Ua Haujlwm Tshiab los ntawm Excel Ntawv Qhia.
- Txuag phau ntawv ua haujlwm Lub Vev Xaib, lossis lwm lub npe zoo sib xws, rau hauv cov ntawv tais ceev tseg cov ntaub ntawv (yog tias koj ua raws txhua Xhohx thiab Christopher G. kab lus, qhov no yog #110, thiab koj yuav xav tsim cov ntawv tshwj xeeb nrog lub npe apt nco txog ntawm kab lus lub npe rau daim nplaub tshev, pib nrog 110 - hauv qhov xwm txheej ntawd, cov ntaub ntawv npe = lub npe kab lus) (100 rau Xhohx, thiab qhov no yog #10 rau Christopher G.). Txoj kev ntawd, koj tuaj yeem nkag mus rau Kev Kho Kom Zoo Dua thiab ua cov ntawv luam ntawm tag nrho cov kab lus kom muaj kev nyab xeeb los ntawm muab nws tso rau hauv Lo Lus, nyob rau hauv lub siab tawv thiab txuas lub npe.
Kauj Ruam 2. Teev Cov Ntawv Nyiam nyob hauv Excel cov ntawv qhia zaub mov:
- Feem ntau, teeb tsa R1C1 rau Off thiab xaiv Qhia 10 Cov Ntaub Ntawv Tsis ntev los no.
- Hauv Kho kom raug, teeb tsa txhua qhov kev xaiv thawj zaug los tshuaj xyuas tshwj tsis yog Hloov Hloov Hnub Tim. Teeb Zaub Cov lej ntawm cov lej zauv rau qhov khoob (raws li cov lej nyiam dua). Khaws cov zaub ntawm cov hnub thiab teeb tsa 30 rau kev txiav tawm xyoo pua 21st.
- Hauv Kev Pom, nyem rau ntawm qhia Tus Qauv Bar thiab Tus Txheej Txheem Bar thiab yuj rau cov lus pom ntawm txhua Lub Hom Phiaj. Kos Kos Qhia kab kab thiab teeb txhua lub thawv hauv qab no kom pib lossis kos.
- Hauv Daim Duab, tso cai qhia cov npe kab ntawv thiab teeb tsa cov cim cim ntawm tus hover thiab tawm qhov tsis tau txheeb xyuas tam sim no.
- Hauv Kev Suav, nco ntsoov Txheeb Xyuas raug suav thiab suav ua ntej txuag kuj tseem tshawb xyuas. Teeb qhov kev hloov pauv mus rau.001 raws li lub hom phiaj nrhiav tsis tau ua tiav hauv txoj haujlwm no. Txheeb xyuas txuag qhov txuas sab nraud thiab siv 1904 system
- Hauv Kev txheeb xyuas qhov yuam kev, txheeb xyuas txhua qhov kev xaiv.
- Hauv Txuag, xaiv txuag daim duab saib ua ntej nrog cov ntaub ntawv tshiab thiab Txuag Autorecover tom qab 5 feeb
- Hauv Ribbon, khaws txhua tus ntawm lawv tshwj tsis yog Hide pawg npe thiab Tus Tsim Tawm.
Kauj Ruam 3. Mus rau ntawm cell A2 thiab ua Freeze Panes hauv qab Windows menu
- Nws pab los ntawm kev tso tus cursor nruab nrab ntawm A ntawm Kab A thiab 1 hauv Kab 1 nyob rau ntawm kaum sab saud sab saud thiab xaiv tag nrho cov ntawv ua haujlwm.
- Format Cells Number Number Custom +0.0000; -0.0000; = 0.0000, Font Loj 9 txog 12.
- Ua Format Cells Alignment Text Alignment Horizontal Center.
Kauj Ruam 4. Nkag mus rau kab ntawv cov ntawv cim npe, txhais cov npe sib txawv thiab cov txiaj ntsig sib txawv hauv Kab 1, thiab kab E thiab F:
- Sau daim ntawv Cos rau hauv cell A1;
- Sau daim ntawv lo txhaum rau hauv cell B1;
- Sau daim ntawv lo Radius x rau hauv cell C1;
- Sau daim ntawv lo Radius y rau hauv cell D1;
- Nkag mus rau lub ntsiab lus sib txawv lub npe ShrinkExpand rau hauv cell E1 thiab kho kab loj kom haum;
- Nkag mus rau lub ntsiab lus hloov pauv lub npe X Offset rau hauv cell E2;
- Nkag mus rau lub ntsiab lus sib txawv lub npe Y Offset rau hauv cell E3;
- Xaiv ntau yam E1: F3 thiab ua Insert Names Create in Right Column;
- Nkag mus rau 2 ntawm cell F1 thiab nkag mus rau 2 rau ntawm cell F2 thiab nkag mus rau 2 rau ntawm cell F3.
- Xaiv cov xov tooj ntawm tes F1: F3 thiab ua Format Cells Font Liab, Sau Daj, txij li lawv nyob hauv cov cell.
Kauj Ruam 5. Nkag mus rau cov qauv rau kab lus "3 teev" Cov kab hluav taws xob kom tshwm rau hauv Daim Duab:
- Nkag mus rau cell C2 cov mis, tsis hais cov lus, "= X_Offset"
- Nkag mus rau cell D2 cov mis, tsis hais cov lus, "= Y_Offset"
- Nkag mus rau cell C3 cov mis, tsis hais cov lus, "= C2+ShrinkExpand"
- Nkag mus rau cell D3 tus qauv, tsis hais nqe lus, "= D2"
Kauj Ruam 6. Nkag mus rau Cosine (x) thiab Sine (y) cov qauv thiab sau rau hauv:
- Nkag mus rau cell A2 tus qauv, w/o quotes, "= X_Offset+COS ((ROW ()-2)*PI ()/180)*ShrinkExpand"
- Nkag mus rau cell B2 tus lej, w.o hais tawm, "= Y_Offset+SIN ((ROW ()-2)*PI ()/180)*ShrinkExpand"
- Kho kom raug Mus rau cell ntau A2: B362
- Kho kom raug sau cia
Ntu 2 ntawm 3: Cov Kab Lus piav qhia, Duab kos duab, Duab
Kauj Ruam 1. Tsim Daim Qauv:
- Nrog cov xov tooj ntawm tes A2: B362 tseem raug xaiv, ua ib qho Insert Chart lossis Xaiv Charts los ntawm Ribbon;
- Xaiv daim ntawv hom Scatter, Smooth Line Scatter; daim ntawv yuav tsum tshwm ntawm koj daim ntawv.
- Lub npe ntawm daim ntawv ua haujlwm, Vajvoog Cov Ntaub Ntawv thiab Daim Duab;
- Nkag mus rau cell D4 qhov kev ceeb toom 'kho kab ntawv kab ntawv' thiab ua kom nws qaij thiab ua raws txoj cai;
- Xaiv cov xov tooj ntawm tes C2: D3, ua cov lus txib thiab c rau luam, nyem hauv lub voj voog hauv kab ntawv thiab ua cov lus txib thiab v, muab tshuaj txhuam. Qhov no tuaj yeem tawm tsis raug. Nyem rau kab uas tau tsim thiab hloov kho Cov Qauv Qauv hauv kab ntawv mis kom txog thaum nws tau nyeem raws li hauv qab no (tab sis w/o quotes):
- "= SERIES (" Radius ", 'Circle Data and Chart'! $ C $ 2: $ C $ 3, 'Circle Data and Chart'! $ D $ 2: $ D $ 3, 2)"
- Nyem rau ntawm Vajvoog. Nws Cov Qauv Cov Qauv yuav tsum tau nyeem raws li hauv qab no - koj yuav zaum yuav tau hloov kho hauv "Kab ncig":
- "= SERIES (" Kev ncig "," Cov vojvoog Cov Ntaub Ntawv thiab Daim Duab "! $ A $ 2: $ A $ 362, 'Cov Ntaub Ntawv Vajvoog thiab Daim Duab'! $ B $ 2: $ B $ 362, 1)"
- Txheeb xyuas tias koj daim duab zoo li daim duab ntawm no.
- Qhov ntawd yog nws! Koj ua tiav!
Kauj Ruam 2. Ntxiv cov qauv ntawm daim duab (tsis teb los tau):
- Los ntawm ob-nias ntawm Kab Lus lossis Radius, koj yuav nthuav tawm Cov Qauv Cov Ntaub Ntawv Series sib tham, uas muab ntau txoj hauv kev rau koj raws li qhov pom ntawm koj daim duab kawg-sim tawm cov kev xaiv sib txawv-muaj kev lom zem nrog nws !!
-
Koj tseem tuaj yeem coj mus rhaub nrog nas nyob ze rau sab nraud ntawm daim duab, dhau ntawm thaj chaw uas tau npaj tseg, thiab tuav tus Shift Key, thiab ua Kho Cov Duab Luam. Tom qab ntawd muaj ntau yam ntawv qhia zaub mov cov cuab yeej ua qauv xaiv ntxiv rau koj. Koj yuav ua Shift Key thiab Muab Daim Duab rau daim ntawv tshiab uas hu ua SAVES, lossis CHARTS, lossis VIEWS, lossis qee yam zoo sib xws.
Duab
Ntu 3 ntawm 3: Pab Qhia
Kauj Ruam 1. Ua kom siv cov ntawv pabcuam thaum pib ua los ntawm kev qhia no:
- Saib kab lus Yuav Ua Li Cas Tsim Spirallic Spin Particle Path lossis Necklace Form lossis Spherical Border rau cov npe kab lus ntsig txog Excel, Geometric thiab/lossis Trigonometric Art, Charting/Diagramming and Algebraic Formulation.
- Yog xav paub ntau daim duab kos thiab kab duab, koj kuj tseem yuav xav nyem rau Pawg: Microsoft Excel Duab, Qeb: Zauv, Qeb: Spreadsheets lossis Qeb: Cov duab los saib ntau daim ntawv Excel thiab cov duab kos uas Trigonometry, Geometry thiab Calculus tau hloov mus ua Art, lossis tsuas yog nyem rau ntawm pawg ntawd yog nws tshwm nyob rau sab saud sab xis dawb ntawm nplooj ntawv no, lossis nyob hauv qab sab laug ntawm nplooj ntawv.
