01 a 02
Pezani Cosine ya Angle ndi Ntchito ya COS ya Excel
Kupeza Cosine ya Angle ku Excel
Ntchito ya trigonometric yowonongeka, monga sine ndi tangent , imachokera pa katatu yolumikizidwa bwino (katatu kamene kali ndi ngodya yofanana ndi madigiri 90) monga momwe taonera pa chithunzi pamwambapa.
Mu masamu a masamu, cosine ya pangodya imapezeka pogawanika kutalika kwa mbali kumbali ya ngodya ndi kutalika kwa hypotenuse.
Mu Excel, cosine ya ngodya ingapezeke pogwiritsira ntchito ntchito ya COS malinga ngati mbaliyo imayezedwa mu radians .
Kugwiritsira ntchito ntchito ya COS kungakupulumutseni nthawi yochuluka ndipo mwinamwake kulira mutu chifukwa simukumbukira kuti mbali yanji ya katatu ili pafupi ndi mphambano, yomwe ili moyang'anizana ndi, ndipo ndi yodani.
Malemba ndi Ma Radi
Kugwiritsira ntchito ntchito ya COS kupeza cosine ya pangakhale kungakhale kophweka kusiyana ndi kuigwiritsa ntchito, koma monga tanenera, ndikofunikira kuzindikira kuti pogwiritsa ntchito ntchito ya COS, mbaliyo iyenera kukhala yowonongeka osati madigiri - ndiyi 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 COS ndi Excel, gwiritsani ntchito ntchito ya RADIANS ya Excel kuti mutembenuzire mbali yomwe imayerekeza kuyambira madigiri kupita ku radian monga momwe ikusonyezedwera mu selo B2 mu chithunzi pamwambapa pomwe mpweya wa madigiri 60 ukutengedwa kukhala radians 1.047197551.
Zosankha zina kuti mutembenuke kuchoka ku madigiri mpaka kumawuni ndi awa:
- kumanga RADIANS ntchito mkati mwa ntchito ya COS - monga momwe tawonedwera mzere 3 mu chitsanzo;
- pogwiritsa ntchito Pcel ya PI ntchito : njira (madigiri) * PI () / 180 monga momwe tawonedwera mzere 4 mu chitsanzo.
Syntax ndi Zokambirana za Ntchito ya COS
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito , mabaki, ndi zifukwa .
Chidule cha ntchito ya COS ndi:
= COS (Nambala)
Chiwerengero - chiwerengerocho chiwerengedwera - chimayesedwa mu radians
- kukula kwa mbali ya radians kungalowetsedwe pazitsutsano izi kapena selo lotanthauzira malo a deta iyi mu tsamba lolemba likhoza kulowa mmalo mwake
Chitsanzo: Gwiritsani ntchito Ntchito ya COS ya Excel
Chitsanzo ichi chikuphatikizapo njira zomwe zimagwiritsidwa ntchito kulowa ntchito ya COS mu selo C2 mu chithunzi pamwambapa kuti mupeze cosine ya angle ya digiri 60 kapena 1.047197551 radians.
Zosankha zolowera mu ntchito ya COS zikuphatikizapo kujambula pamanja pa ntchito yonse = COS (B2) , kapena kugwiritsa ntchito bokosi lazokambirana - monga momwe tafotokozera m'munsimu.
Kulowa Ntchito ya COS
- Dinani pa selo C2 mu tsambalo kuti mupange selo yogwira ntchito ;
- Dinani pa Fomu tab ya menyu yowonongeka;
- Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi;
- Dinani pa COS mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
- Mu bokosi la bokosi, dinani pa Number line;
- Dinani pa selo B2 papepala la ntchito kuti mulowe mu seloloyi mu njira;
- Dinani OK kuti mukwaniritse ndondomekoyi ndi kubwerera ku tsamba la ntchito;
- Yankho la 0.5 liyenera kuoneka mu selo C2 - yomwe ndi cosine ya angle ya digirii 60;
- Mukasindikiza pa selo C2 ntchito yonse = COS (B2) ikuwoneka mu barra yazenera pamwamba pa tsamba.
#VALUE! Zolakwa ndi Msewu Wosawona Kumapezeka
- Ntchito ya COS ikuwonetsa #VALUE! cholakwika ngati mawu omwe akugwiritsidwa ntchito monga ndondomeko ya ntchitoyo akulozera selo lokhala ndi deta mzere mzere wachitsanzo zisanu zomwe 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. Ntchito za Tricel zosiyana zimatanthauzira zopanda maselo monga zero, ndipo cosine ya zero radians ndi ofanana ndi imodzi.
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 dzuwa, kukonza katundu, komanso malo otsetsereka.
02 a 02
Bokosi la Zokambirana LOWENERA
Njira ina yosinthira ntchito YOPHUNZITSIRA mkati mwa tsamba lolemba ndi kugwiritsa ntchito bokosi la ntchito. Zotsatira izi zikutsegula njira iyi yolowera MASIKU ano.
- Dinani pa selo lamasewera lomwe lilipo pakali pano komanso nthawi yomwe ikuwonetsedwera
- Dinani pa Fomu ya Fomu.
- Sankhani Tsiku ndi Nthawi kuchokera ku Riboni kuti mutsegule ndondomeko yotsika pansi.
- Dinani pakali pano mndandanda kuti mubweretse bokosi lazokambirana
- Popeza kuti ntchitoyi silingayankhe, dinani Kulungani kuti mulowetse ntchitoyo mu selo yamakono ndikutseketsani bokosi
- Nthawi yeniyeni ndi tsiku liyenera kuoneka mu selo yogwira ntchito.
- Mukamangogwiritsa ntchito selo yogwira ntchito, ntchito yeniyeni = NOW () ikuwoneka mu barolo lazenera pamwamba pa tsamba .
NTCHITO YA NTCHITO
Onani, bokosi la ntchitoyi silipezeka mu Excel 2010 komanso pamapeto pake pulogalamuyi. Kuti muzigwiritse ntchito mu mawamasulidwe awa, ntchitoyo iyenera kulowa mwadongosolo.
Kutsegula Bokosi la Zokambirana
Mndandanda pansipa tsatanetsatane wa njira zomwe zimagwiritsidwa ntchito kulowetsa RANK ntchito ndi zokambirana mu selo B7 pogwiritsa ntchito bokosi la bokosi mu Excel 2007.
- Dinani pa selo B7 - malo omwe zotsatira zidzawonetsedwa
- Dinani pa Fomu ya Fomu
- Sankhani Ntchito Zambiri> Chiwerengero chochokera ku riboni kuti mutsegule ntchitoyi
- Dinani pa RANK m'ndandanda kuti mubweretse bokosi lazokambirana
- Dinani pa selo B3 kuti musankhe nambala kuti ikhale payekha (5)
- Dinani pa "Ref" mzere mu bokosi la bokosi
- Onetsetsani maselo B1 ku B5 kuti mulowetse mndandanda uwu mu bokosi
- Dinani pa "Lamulo" mzere mu bokosi la bokosi
- Lembani zero (0) pa mzerewu kuti muwerenge chiwerengero chotsika.
- Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
- Nambala 4 iyenera kuoneka mu selo B7 chiwerengero chachisanu ndi chiwerengero chachinayi
- Mukasindikiza pa selo B7, ntchito yonse = RANK (B3, B1: B5,0) ikuwoneka muzenera zamatabwa pamwamba pa tsamba.