01 na 02
Nemo Cosine na Angle tare da Ayyukan COS na Excel
Nemo Cosine na Angle a Excel
Ayyukan kwakwalwa ta jiki, kamar sine da tangent , suna 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 hoton da ke sama.
A cikin lissafin lissafi, an gano cosine na kusurwa ta rarraba tsawon gefen gefen gefen kusurwar ta tsawon tsayin hypotenuse.
A cikin Excel, ana iya samo cosine na kusurwa ta yin amfani da aikin COS muddun ana auna wannan kusurwa a cikin masu radians .
Amfani da aikin COS zai iya adana ku mai yawa lokaci da yiwu yiwuwar kai-kaiwa tun lokacin da ba ku da abin tunawa da gefen alwatika mai kusanci zuwa kusurwar, wanda yake akasin haka, kuma wane ne hypotenuse.
Digiri da Radians
Yin amfani da aikin COS don gano cosine na kusurwa zai iya zama sauki fiye da yin shi da hannu, amma, kamar yadda aka ambata, yana da mahimmanci a gane cewa lokacin amfani da aikin COS, buƙatar ya kamata a kasance a cikin radians maimakon digiri - wanda shine ɗayanmu ba mu san ba.
Radians suna da dangantaka da radius na da'irar tare da radian daya kamar daidai da digiri 57.
Don yin sauƙi don aiki tare da COS da Excel ta sauran ayyukan trig, yi amfani da ayyukan RADIANS na Excel don sake mayar da kusurwar daga digiri zuwa ga radians kamar yadda aka nuna a cikin sakon B2 a cikin hoton da ke sama inda inda aka kai kimanin digiri 60 a cikin 1.047197551.
Wasu zaɓuɓɓukan don canzawa daga digiri zuwa radians sun haɗa da:
- Nesting aikin RADIANS cikin aikin COS - 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.
Ƙungiyar COS Function da Arguments
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Maganar aikin COS shine:
= COS (Lambar)
Lambar - ana ƙidayar kwana - auna a cikin masu radians
- za a iya shigar da girman yawan kusurwa a cikin masu rukuni don wannan hujja ko kuma tantance tantanin halitta zuwa wuri na wannan bayanan a cikin takardun aiki za a iya shiga a maimakon
Misali: Amfani da aikin COS na Excel
Wannan misali yana rufe matakan da ake amfani dashi don shigar da aikin COS zuwa cikin tantanin halitta C2 a cikin hoton da ke sama don samun cosine na 60-degree angle ko 1.047197551 radians.
Zaɓuɓɓuka don shiga aikin COS sun hada da haɗin hannu tare da aikin duka = COS (B2) , ko yin amfani da akwatin maganganun - kamar yadda aka tsara a kasa.
Shigar da aikin COS
- 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 COS 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 ya kamata ya bayyana a cell C2 - wanda shine cosine na kusurwa 60-digiri;
- Lokacin da ka danna kan tantanin halitta C2 cikakken aikin = COS (B2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
#VALUE! Kurakurai da Sakamakon Sakamakon Blank
- Ayyukan COS suna nuna #VALUE! kuskure idan tunani da aka yi amfani dashi azaman jigidar aikin ya nuna a cikin kwayar halitta dauke da rubutun kalmomin rubutu biyar na misali inda inda kalmar 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 trig na fassara fasikancin kwayoyin kamar sifili, kuma cosine na zane-zane yana daidai da ɗaya.
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.
Misali, shafukan gine-gine, suna amfani da fasali na lissafi waɗanda suka shafi shadewa, kayan aiki, da kuma rufin rufin.
02 na 02
Aikin Gida ta NOW Aiki
Wani madadin yin amfani da aikin NOW a cikin takardun aiki tare da hannu shine don amfani da akwatin maganganun. Matakan da suka biyo baya sun haɗa wannan hanyar shiga aikin NOW.
- Danna kan tantanin aikin aiki inda aka nuna kwanan wata da ko lokaci
- Danna kan shafukan Formulas .
- Zabi Kwanan wata & Time daga ribbon don buɗe jerin abubuwan da aka sauke.
- Danna NOW a cikin jerin don kawo akwatin maganganun aikin
- Tun da aikin ba shi da wata hujja, danna Ya yi don shigar da aikin cikin cell din yanzu kuma rufe akwatin maganganu
- Yawan lokaci da kwanan wata ya kamata ya bayyana a cikin salula mai aiki.
- Lokacin da ka danna kan tantanin halitta, cikakkiyar aikin = NOW () yana bayyana a cikin maɓallin tsari a sama da takardun aiki .
RANK Function
Lura, akwatin maganganun don wannan aikin ba a samuwa a cikin Excel 2010 da kuma wasu sigogi na wannan shirin ba. Don amfani da shi a cikin waɗannan nau'i, dole ne a shigar da aikin da hannu.
Ana buɗe akwatin maganganu
Matakan da ke ƙasa dalla-dalla matakan da ake amfani dashi don shigar da aikin RANK da kuma muhawara a cikin tantanin halitta B7 ta amfani da maganganun maganganun a cikin Excel 2007.
- Danna kan tantanin halitta B7 - wurin da za a nuna sakamakon
- Danna kan shafukan Formulas
- Zaɓi Ƙari Ayyuka> Lissafi daga rubutun don buɗe jerin sauƙaƙe aikin
- Danna RANK cikin jerin don kawo akwatin maganganun aikin
- Danna kan tantanin halitta B3 don zaɓar lambar da za'a zaba (5)
- Danna kan layin "Ref" a cikin akwatin maganganu
- Buga sauti B1 zuwa B5 don shigar da wannan tashar cikin akwatin maganganu
- Danna kan layin "Layi" a cikin akwatin maganganu
- Rubuta siffar (0) a kan wannan layi don matsayi lambar a sauƙaƙe tsari.
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
- Yawan lamba 4 ya kamata ya bayyana a tantanin halitta B7 tun lokacin da lambar 5 ita ce ta huɗu mafi girma
- Lokacin da ka danna kan tantanin B7, cikakken aikin = RANK (B3, B1: B5,0) ya bayyana a cikin maɓallin tsari a sama da aikin aiki.