Ntchito yotchedwa trigonometric sine , monga cosine ndi yosalala , imachokera pa katatu yolumikizidwa bwino (katatu kamene kali ndi ngodya yofanana ndi madigiri 90) monga momwe taonera pa chithunzi pamwambapa.
Mu masamu a masamu, sine ya ngodya imapezeka pogawanika kutalika kwa mbali kumbali ya ngodya ndi kutalika kwa chiwonetsero.
Mu Excel, sine ya ngodya ingapezeke pogwiritsira ntchito TCHIMO malinga ngati mbaliyo imayezedwa mu radians .
Kugwiritsira ntchito ntchito ya SIN ikhoza kukupulumutsani nthawi yambiri ndipo mwinamwake kuyambanso mutu chifukwa simukumbukira kuti mbali yanji ya katatu ili pafupi ndi mbali, yomwe ili moyang'anizana ndi, ndipo ndi yotani.
01 a 02
Malemba ndi Ma Radi
Kugwiritsira ntchito ntchito ya SIN kuti mupeze sine ya ngodya zingakhale zophweka kusiyana ndi kuzichita mwadongosolo, koma, monga tanenera, ndikofunikira kuzindikira kuti pamene ntchito SIN ikugwira ntchito, mbaliyo iyenera kukhala yowonongeka osati madigiri gulu lathu ambiri sitidziwa.
Asilikali akugwirizana ndi malo ozungulira omwe ali ndi radian omwe amakhala ofanana ndi madigiri 57.
Kuti zikhale zosavuta kugwira ntchito ndi ntchito zina za SIN ndi Excel, gwiritsani ntchito ntchito ya RADIANS ya Excel kuti mutembenuzire mbali yomwe imayesedwa kuchokera madigiri kupita ku radian monga momwe ikusonyezedwera mu selo B2 mu chithunzi pamwambapa pamene mpangidwe wa madigiri 30 ukutembenuzidwa kukhala radians 0.523598776.
Zosankha zina kuti mutembenuke kuchoka ku madigiri mpaka kumawuni ndi awa:
- Kupanga ntchito za RADIANS mkati mwa ZINTHU ntchito - monga momwe tawonetsera mzere 3 mu chitsanzo.
- Kugwiritsira ntchito Pcel ya PL ikugwiritsidwa ntchito mwachindunji: ngodya (madigiri) * PI () / 180 monga momwe tawonedwera mzere 4 mu chitsanzo.
02 a 02
Syntax ndi Funso la Sinthini
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito , mabaki, ndi zifukwa .
Chidule cha ntchito ya SIN ndi:
= SIN (Nambala)
Namba = chiwerengero chowerengedwa, chiyeso mu radians. Kukula kwa ngodya ya radians kungalowetsedwe pazokambiranazi kapena selo lofotokozera malo a deta iyi mu tsamba la ntchito likhoza kulowa mmalo mwake.
Chitsanzo: Gwiritsani ntchito Funso la SIN la Excel
Chitsanzo ichi chikuphatikizapo njira zomwe zimagwiritsidwa ntchito kulowa mu Sinthini kumalowa mu selo C2 (monga momwe tawonetsera pa chithunzi pamwambapa) kuti tipeze mtundu wa ma digita 30 kapena 0.523598776 radians.
Zosankha zolowera ku Sinthini ntchito zimaphatikizapo kujambula pamanja pa ntchito yonse = SIN (B2) , kapena kugwiritsa ntchito bokosi lazokambirana , monga momwe tafotokozera m'munsimu.
Kulowa Ntchito ya SIN
- Dinani pa selo C2 mu tsamba kuti mupange selo yogwira ntchito .
- Dinani pa Fomu tab ya menyu yowonjezera.
- Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi.
- Dinani pa SIN m'ndandanda kuti mubweretse bokosi lazokambirana.
- Mu bokosi la bokosi, dinani pa Nambala .
- Dinani pa selo B2 papepala la ntchito kuti mulowetse selolo mu njirayi.
- Dinani OK kuti mutsirizitse ndondomekoyi ndi kubwerera kuntchito.
- Yankho la 0.5 liyenera kuoneka mu selo C2 - yomwe ili ndi sine ya digiri ya digrii 30.
- Mukasindikiza pa selo C2 ntchito yonse = SIN (B2) ikuwoneka mu barra yazenera pamwamba pa tsamba.
#VALUE! Zolakwa ndi Msewu Wosawona Kumapezeka
- Ntchito YONSE imasonyeza #VALUE! cholakwika ngati mawu omwe akugwiritsidwa ntchito monga ndondomeko ya ntchito akuwonetsera selo lokhala ndi deta mzere mzere wachitsanzo zisanu zomwe malo ogwiritsira ntchito selo akugwiritsira ntchito polemba: Angle (Ma Radi) .
- Ngati selo likulozera ku selo yopanda kanthu, ntchitoyo imabweretsanso mtengo wa zero monga momwe tawonedwera mzere wachisanu ndi chimodzi pamwambapa. Ntchito za Excel zomwe zimatanthauzira osasanthula maselo ngati zero, ndipo sine ya zero radians ndi ofanana ndi zero.
Ntchito za Trigonometric mu Excel
Trigonometry imagogomezera mgwirizano pakati pa mbali ndi makona a katatu, ndipo pamene ambirife sitisowa kuzigwiritsa ntchito tsiku ndi tsiku, trigonometry ili ndi ntchito m'madera ambiri kuphatikizapo zomangamanga, fizikiki, umisiri, ndi kufufuza.
Mwachitsanzo, akatswiri a zomangamanga amagwiritsa ntchito trigonometry kuti aziwerengera za dzuwa, zomangamanga, komanso malo otsetsereka.