01 ye 02
Tsvaga Cosine yeAngle neAexcel COS Function
Kuwana Cosine yeAngle muExcel
Izvo zvinonzi trigonometric work co sine , sezvakaita sine uye tangent , yakavakirwa katatu kakanyatsokwana (katatu ine kona yakaenzana ne 90 degrees) sezvinoratidzwa mumufananidzo uri pamusoro.
Muchikwata chemasvomhu, cosine yekona inowanikwa nokuparadzanisa urefu hwechidimbu pedyo nekona nehurefu hwehuwandu.
MuExcel, cosine yekona ingakwanikidzwa uchishanda neCOS basa chero nguva iyo iyo yakaenzana inotaridzwa mumayera .
Kushandisa COS basa kunogona kukuchengetedza nguva yakawanda uye zvichida kuwanda kwekucheka musoro sezvo iwe usisambofaniri kuyeuka rumwe rutivi rwekona katatu riri pedo nekona, iyo inopesana, uye iyo inofungidzira.
Degrees vs. Radians
Kushandisa COS basa kuti uwane cosine yekona ingave iri nyore kupfuura kuzviita, asi, sezvakataurwa, zvinokosha kuziva kuti kana uchishandisa COS basa, iyo ngano inofanirwa kunge iri mumasarare pane zvidzidzo - ndeipi chikwata chedu vazhinji havazive.
VaRadio vanowirirana nezera redu denderedzwa nerimwe radian riri rinenge rakaenzana ne 57 degrees.
Kuita kuti zvive nyore kushanda neCOS pamwe neExcel mamwe mabasa akasiyana, shandisa basa reRALANS re Excel kuti uchinje ma angle akaenzana kubva kumadiresi kusvika kuma radians sezvinoratidzwa muchitokisi B2 mumufananidzo uri pamusoro apa apo yakaenzana yemadhora makumi matanhatu akachinjwa kuva 1.047197551 radians.
Zvimwe zvingasarudzwa zvekushandura kubva kumadiresi kusvika kuma radians zvinosanganisira:
- kuvhara basa reRADIANS mukati meCOS basa - sezvinoratidzwa mumutsara 3 mune muenzaniso;
- uchishandisa Excel PI inoshandiswa mumutsetse: angle (digrii) * PI () / 180 sezvinoratidzwa mumutsara wechina mumuenzaniso.
Iko Syntax yeCOS Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa , mabheji, uye nharo .
Mutsara weCOS basa ndewokuti:
= COS (Nhamba)
Nhamba - iyo yakaenzana ichiverengwa - inoyerwa mumayera
- ukuru hwekona mumasikati kunogona kupinda mukati menyaya iyi kana kuti sero rinoreva nzvimbo ye data iri mubasa rinogona kupinda panzvimbo
Muenzaniso: Kushandisa COS Basa reCOS
Muenzaniso uyu unoshandisa matanho anoshandiswa kupinda muCOS basa mumusero C2 mumufananidzo pamusoro apa kuti uwane cosine ye 60-degree angle kana 1.047197551 radians.
Sarudzo dzekupinda muCOS basa dzinosanganisira kunyora manyore mubasa rose = COS (B2) , kana kushandisa sarudzo yebasa - sezvakataurwa pasi apa.
Kupinda Basa reCOS
- Dzvanya pachitokisi C2 mune pepa rekushanda kuti uite sero rinoshanda ;
- Dzvanya paMafomu tab yebhoni yebhoni;
- Sarudza Math & Trig kubva kubhoni kuti uzarure basa rinoyerera pasi;
- Dzvanya paCOS murugwaro kuti ubudise bhokisi rebasa rebasa;
- Mubhokisi rebhokisi, tora paNhamba yemurongo;
- Dzvanya pachitsi B2 mune pepa rekushanda kuti uise iyo seferensi iri mumutsetse;
- Dzvanya OK kuti upedze rondedzero uye dzoka kubheji rekushanda;
- Mhinduro 0.5 inofanira kuonekwa muchitokisi C2 - iyo inonzi cosine ye 60-degree angle;
- Paunenge uchinge uri pachitsime C2 yakakwana basa = COS (B2) inowanikwa mubhairi yepamusoro pane pepa pepaji.
#VALUE! Zvikanganiso uye Mucheka Asina Kubatsira
- Iko COS basa inoratidza #VALUE! kukanganisa kana shanduro inoshandiswa senyaya yebasa inongedzera kune sero rine text data row mishanu yemuenzaniso apo sero rinoshandiswa rinoshandiswa rinotarisa kumashoko okuti: Angle (Radians);
- Kana sero rinotarisa kune seki risina chinhu, basa rinodzorera kukosha kweimwe-mutsara matanhatu pamusoro apa. Excel's trig function interpret interpret blank cells as zero, uye cosine ye zero radians yakaenzana nechimwe.
Trigonometric Uses mu Excel
Trigonometry inotarisa kuhukama pakati pemakona nemakona emakatatu, uye nepo vazhinji vedu tisingafaniri kuishandisa zuva rega rega, trigonometry ine maitiro mune zvimwe zvinhu zvakasanganisira mashizha, physics, engineering, nekuongorora.
Architects, somuenzaniso, shandisa trigonometry kuti zviverengwe zvinosanganisira zuva shading, zvigadziriswa mutoro, uye, padenga rematope.
02 of 02
Bhokisi reDhiyabhorosi reNOW Function
Pane imwe nzira yekunyora basa iri ikozvino mune pepa rekushandisa manzwiro ndeye kushandisa bhokisi rebasa rebasa. Aya matanho anotevera anovhara nzira iyi yekupinda MUZVIRI basa.
- Dzvanya pane sero rekushanda apo zuva razvino uye nguva kana kuti iyo inofanira kuratidzwa
- Dzvanya paMafomu eTom.
- Sarudza Zuva Nenguva kubva kubhoni kuti uzarure urongwa hwakaderera pasi.
- Dzvanya paZVIMU murugwaro kuti ubudise bhokisi rebasa rebasa
- Sezvo basa racho risingatauri nharo, sarudza OK kuti uite basa racho mune sekuri iko uye uvhare bhokisi rebhokisi
- Nguva yakatarwa uye zuva rinofanira kuonekwa mumusasa unoshanda.
- Paunenge uchinyanya kushandura sero, basa rakakwana = NOW () rinowanikwa mubhairi yepamusoro pane pepa pepaji .
RANK Function
Cherechedza, bhokisi rebhokisi rebasa iri hariwanikwi muExcel 2010 uye mushure mekushandurwa kwepurogiramu. Kuti uishandise mumashanduro aya, basa racho rinofanira kupinda maune.
Kuvhura Bhokisi reDhialog
Nhanho dziri pasi apa tsanangudzo dzinoshandiswa kupinda muRANK basa uye nharo muchitokisi B7 uchishandisa basa rebhokisi rebhokisi muExcel 2007.
- Dzvanya pane sero B7 - nzvimbo iyo migumisiro icharatidzwa
- Dzvanya paMafomu eTom
- Sarudza Mamwe Mabasa> Statistical kubva kubhoni kuti uzarure basa rinoderera pasi
- Dzvanya kuri RANK munyore kuti ubudise bhokisi rebasa rebasa
- Dzvanya pane sero B3 kuti usarudze nhamba kuti ive yakarongerwa (5)
- Dzvanya pa "Ref" line mubhokisi rebhokisi
- Simbisai masero B1 kusvika B5 kupinda muzera iri mubhokisi rebhokisi
- Dzvanya pamutsetse we "Odha" mubhokisi rebhokisi
- Tora zero (0) pamutsara uyu kuti uverenge nhamba yacho ichidzika pasi.
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
- Nhamba yechina inofanira kuonekwa muchitokisi B7 sezvo nhamba ye5 yeyo nhamba yechina huru
- Paunenge uchinyora pa cell B7, basa rakakwana = RANK (B3, B1: B5,0) rinowanikwa mubhairi yepamusoro pane pepa pepaji.