Ntchito ya TAN Yopambana: Pezani Tangent ya Angle

Ntchito ya trigonometric, monga sine ndi cosine , imachokera pa katatu kolondola (katatu kamene kali ndi ngodya yofanana ndi madigiri 90) monga momwe tawonetsera pa chithunzi pamwambapa.

Mu kalasi ya masamu, chimango cha ngodya chikhoza kupezeka pogwiritsira ntchito chiŵerengerocho kufanizitsa kutalika kwa mbali kumbali ya ngodya (o) mpaka kutalika kwa mbali pafupi ndi ngodya (a).

Mndandanda wa chiŵerengero ichi ukhoza kulembedwa:

Tan Θ = o / a

komwe Θ ili kukula kwa mbali yomwe ikuganiziridwa (45o mu chitsanzo ichi)

Mu Excel, kupeza thambo laling'ono kungakhale losavuta pogwiritsira ntchito TAN ntchito kwa angles omwe amayeza mu radians .

01 ya 05

Malemba ndi Ma Radi

Kugwiritsira ntchito ntchito ya TAN kuti mupeze khungu la ngodya kungakhale kophweka kusiyana ndi kuzichita mwadongosolo, koma, monga tanenera, mpangidwe uyenera kukhala mu ma radian osati madigiri - omwe ndi ambiri omwe ife sitidziwa nawo.

Asilikali akugwirizana ndi malo ozungulira omwe ali ndi radian omwe amakhala ofanana ndi madigiri 57.

Kuti zikhale zosavuta kugwira ntchito ndi ntchito zina za TAN ndi Excel, gwiritsani ntchito ntchito ya RADIANS ya Excel kuti mutembenuzire mbali yomwe imayesedwa kuchokera madigiri kupita ku radian monga momwe yasonyezedwera mu selo B2 mu fano pamwambapa pomwe mpweya wa madigiri 45 unasanduka ma radian 0,785398163.

Zosankha zina kuti mutembenuke kuchoka ku madigiri mpaka kumawuni ndi awa:

• kumanga ntchito za RADIANS mkati mwa ntchito ya TAN - monga momwe tawonetsera mzere 3 mu chitsanzo;
• pogwiritsa ntchito Pcel ya PI ntchito : njira (madigiri) * PI () / 180 monga momwe tawonedwera mzere 4 mu chitsanzo.

02 ya 05

Syntax ndi Maganizo a Ntchito ya TAN

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito , mabaki, ndi zifukwa .

Chidule cha ntchito ya TAN ndi:

= TAN (Nambala)

Chiwerengero - (chofunika) chiwerengerocho chiwerengedwera - chikuyengedwa mu radians;
- kukula kwa mbali ya radians kungalowetsedwe pazokambirana izi, kapena, kutanthauzira selo kumalo a deta iyi mu tsamba la ntchito .

Chitsanzo: Kugwiritsira ntchito Ntchito ya TAN ya Excel

Chitsanzo ichi chikuphimba njira zomwe zimagwiritsidwa ntchito kulowa TAN mu selo C2 mu chithunzi pamwambapa kuti mupeze mbali ya 45 degree kapena 0.785398163 radians.

Zosankha zogwira ntchito ya TAN zikuphatikizapo kujambula pamanja pa ntchito yonse = TAN (B2) , kapena kugwiritsa ntchito bokosi la zokambirana - monga momwe tafotokozera m'munsimu.

03 a 05

Kulowa Ntchito ya TAN

1. Dinani pa selo C2 mu tsambalo kuti mupange selo yogwira ntchito ;
2. Dinani pa Fomu tab ya menyu yowonongeka;
3. Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi;
4. Dinani pa TAN mu mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
5. Mu bokosi la bokosi, dinani pa Number line;
6. Dinani pa selo B2 papepala la ntchito kuti mulowe mu seloloyi mu njira;
7. Dinani OK kuti mukwaniritse ndondomekoyi ndi kubwerera ku tsamba la ntchito;
8. Yankho 1 liyenera kuoneka mu selo C2 - lomwe ndilo mbali ya 45 digitala;
9. Mukasindikiza pa selo C2 ntchito yakenthu = TAN (B2) ikuwoneka mu barabu lazenera pamwamba pa tsamba.

04 ya 05

#VALUE! Zolakwa ndi Msewu Wosawona Kumapezeka

Ntchito ya TAN imasonyeza #VALUE! kulakwitsa ngati mawu omwe agwiritsidwa ntchito ngati ndemanga ya ntchito amagwiritsira ntchito selo lokhala ndi deta - mzere wachisanu mwachitsanzo momwe malo ogwiritsira ntchito selo akugwiritsira ntchito polemba: Angle (Ma Radiya);

Ngati selo likulozera ku selo yopanda kanthu, ntchitoyo imabweretsanso mtengo umodzi wa mzere umodzi pamwambapa. Zochita za Tricel zosamveka zimatanthauzira osawona maselo monga zero, ndipo maonekedwe a zero radians ali ofanana ndi amodzi.

05 ya 05

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.