Ayyukan tasirin na tangent , kamar sine da cosine , yana dogara ne a kan alƙalan hagu-angled (wani ɓangaren triangle wanda ke dauke da kusurwar daidai da digiri 90) kamar yadda aka nuna a cikin hoto a sama.
A cikin lissafin lissafi, ana iya samun tanguwa na kusurwa ta yin amfani da ragowar kwatankwacin tsawon gefen gefen kusurwar (o) har zuwa tsawon gefen gefen kusurwar (a).
Za'a iya rubuta ma'anar wannan rukunin:
Tan Θ = o / a
inda Θ shine girman girman kwana a ƙarƙashin binciken (45o cikin wannan misali)
A cikin Excel, ana iya samun tanguwa na kwana ɗaya za a iya sauƙaƙa ta hanyar amfani da aikin TAN na kusassun da aka auna a cikin radians .
01 na 05
Digiri da Radians
Yin amfani da aikin TAN don samun tangentar wani kusurwa na iya zama sauki fiye da yin shi da hannu, amma, kamar yadda aka ambata, kusurwar yana bukatar zama a cikin radians maimakon digiri - wanda shine ɗayan ɗayanmu ba su da masaniya.
Radians suna da dangantaka da radius na da'irar tare da radian daya kamar daidai da digiri 57.
Don yin sauƙaƙa don aiki tare da TAN da Excel ta sauran ayyuka na trig, yi amfani da ayyukan RADIANS na Excel don sake mayar da kusurwar daga digiri zuwa radians kamar yadda aka nuna a cikin b2 B2 a cikin hoton da ke sama inda inda ake yin kusurwar 45 digiri zuwa 0.785398163 radians.
Wasu zaɓuɓɓukan don canzawa daga digiri zuwa radians sun haɗa da:
- Nesting aikin RADIANS cikin aikin TAN - kamar yadda aka nuna a jere na 3 a misali;
- Ta amfani da aikin Excel na PI a cikin tsari: kwana (digiri) * PI () / 180 kamar yadda aka nuna a jere 4 a misali.
02 na 05
Hanyoyin TAN da kuma Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin na TAN shine:
= TAN (Lambar)
Lambar - (da ake buƙata) ana ƙidayar kwana - ma'auni a cikin radians;
- za a iya shigar da girman girman kusurwar a cikin masu rukuni don wannan hujja ko, a madadin haka, tantancewar tantanin halitta game da wurin da wannan bayanan yake a cikin takardun aiki .
Misali: Yin amfani da aikin TAN na Excel
Wannan misali ya haɗa matakan da ake amfani da shi don shigar da aikin TAN zuwa cikin cell C2 a cikin hoton da ke sama don samun tangentar wani kusurwa 45 ko 0.785398163 radians.
Zaɓuɓɓuka don shiga aikin TAN sun haɗa da hannu da hannu a dukan aikin = TAN (B2) , ko yin amfani da akwatin maganganun - kamar yadda aka tsara a kasa.
03 na 05
Shigar da aikin TAN
- Danna maɓallin C2 a cikin takardun aiki don yin sautin mai aiki ;
- Danna maɓallin Formulas na shafin ribbon ;
- Zabi Math & Trig daga rubutun don buɗe jerin sauƙaƙe aikin;
- Danna TAN a cikin jerin don kawo akwatin maganganu na aikin;
- A cikin akwatin maganganu, danna kan Lambar waya;
- Danna kan salula B2 a cikin aikin aiki don shigar da wannan tantanin halitta a cikin tsari;
- Danna Ya yi don kammala tsarin da kuma komawa zuwa aikin aiki;
- Amsar 1 ya kamata ya bayyana a cell C2 - wanda shine tangent na kwana 45;
- Lokacin da ka danna kan tantanin halitta C2 cikakkiyar aikin = TAN (B2) ya bayyana a cikin wannan tsari a sama da takardun aiki.
04 na 05
#VALUE! Kurakurai da Sakamakon Sakamakon Blank
Ayyukan TAN na nuna #VALUE! kuskure idan tunani da aka yi amfani dashi azaman aikin yana nuna wani kwayar halitta dauke da bayanan rubutu - jere biyar na misalin inda ma'anar salula ta yi amfani da kalmomi zuwa lakabin rubutu: Angle (Radians);
Idan tantanin halitta yana nuna zuwa maras komai, aikin zai dawo darajar daya - jere shida a sama. Ayyukan Excel na trigon fassara fasalin kwayoyin da ba kome ba kamar zane, kuma tangentar zane-zane ne daidai da daya.
05 na 05
Mahimmanci yana amfani da shi a Excel
Tantance na al'ada yana mayar da hankali akan dangantakar tsakanin bangarori da kusurwar magungunan, kuma yayin da yawancin mu bazai buƙaci amfani dasu a kullum, tasirin na da aikace-aikace a wasu fannoni ciki har da gine-gine, fasaha, aikin injiniya, da kuma binciken.
Gidajen tarihi, misali suyi amfani da fassarar lissafi don lissafi da suka shafi shading, kayan aiki, da kuma rufin rufin.