01 ka 02
Fumana i-Cosine ye-Angle nge-Ccel Umsebenzi we-COS
Ukufumana i-Cosine ye-Angle e-Excel
Umsebenzi we-trigonometric coine , njenge -sine kunye ne -tangent , isekelwe kunxantathu echanekileyo (inxantathu ene-angle elingana nama-90 degrees) njengoko kuboniswe kumfanekiso ongentla.
Kwiklasi yeemathematika, i-cosine ye-angle ifunyaniswa ngokuhlula ubude becala elikufuphi nekota ngokude kwe-hypotenuse.
Kwi-Excel, i-cosine ye-angle ifunyanwa ngokusebenzisa umsebenzi we-COS ngexesha elide lilinganiselwa kuma- radians .
Ukusebenzisa umsebenzi we-COS kunokukugcina ixesha elininzi kwaye mhlawumbi uninzi lwe-head-scratching njengoko ungasayi kuphinda ukhumbule nawuphi na icala loonxantathu elisecaleni kwinqanaba, eliphambene nalo, kwaye yiyiphi i-hypotenuse.
IziGanga kunye namaRadi
Ukusebenzisa umsebenzi we-COS ukufumana i-cosine ye-angle ingaba lula kunokuba uyenze ngesandla, kodwa, njengoko kubonisiwe, kubalulekile ukuqaphela ukuba xa usebenzisa umsebenzi we-COS, i-angle ifuna ukuba kuma- radians kuneziganga - eyona inxalenye yethu ininzi ayifumene nayo.
AmaRidiya anxulumene nomda weesangqa kunye ne-radian esilingana nokulingana nama-57 degrees.
Ukwenza kube lula ukusebenza kunye ne-COS kunye nezinye izinto ze- Excel, sebenzisa umsebenzi we-RADIANS we-Excel ukuguqula i-angle ekulinganiswe ukusuka kwiiyure ukuya kuma-radians njengoko kuboniswe kwiseli B2 kumfanekiso ongaphezulu apho i-angle ye-degrees ezingama-60 iguqulwa ibe yi-1.047197551 i-radians.
Ezinye iinketho zokuguqula ukusuka kwiiyure ukuya kuma-radians ziquka:
- ukuhlalisa umsebenzi we-RADIANS ngaphakathi kwe-COS umsebenzi - njengoko kuboniswe kumgca 3 kumzekelo;
- usebenzisa umsebenzi we-Excel we- PI kwifom: i- angle (degrees) * PI () / 180 njengoko kuboniswe kumgca 4 kumzekelo.
I-Syntax kunye neArguments yeCOS Function
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi , amabakethi kunye neengxabano .
I-syntax yomsebenzi weCOS yile:
= I-COS (Inani)
Inani - i-angle ibalwa - ilinganiswe kuma-radians
- ubungakanani bekota kuma-radians banokungeniswa kule ngxabano okanye isalathisi yesalathisi kwindawo yeli datha kwiphepha lokusebenzela lingeniswa endaweni
Umzekelo: Ukusebenzisa iCOS Umsebenzi we-Excel
Lo mzekelo uhlanganisa amanyathelo asetyenziswa ukufaka umsebenzi weCOS kwiselfowuni C2 kumfanekiso ongentla ukufumana i-cosine ye-angle-degree engama-60 okanye i-1.047197551 i-radians.
Izinketho zokufaka umsebenzi weCOS ziquka ukuthayipha ngesandla kuyo yonke imisebenzi = COS (B2) , okanye usebenzisa ibhokisi yencoko yencoko yomsebenzi - njengoko kuchazwe ngezantsi.
Ukufaka umsebenzi weCOS
- Cofa kwiseli C2 kwiphepha lokusebenzela ukuze wenze iseli esebenzayo ;
- Cofa kwiThebhu yefomula yemenyu yebhondi;
- Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lwehla lokuhla;
- Cofa kwi-COS kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
- Kwibhokisi yencoko, nqakraza kumgca weNombolo ;
- Cofa kwifowuni B2 kwiphepha lokusebenzela ukuze ufake loo fom yefom yefomula;
- Cofa u-OK ugcwalise ifomu uze ubuyele kwiphepha lokusebenzela;
- Impendulo ye-0.5 kufuneka ibonakale kwiselfowuni C2 - leyo i-cosine ye-angle ye-degree-60;
- Xa ucofa kwiseli C2 umsebenzi opheleleyo = I- COS (B2) ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela.
#VALUE! Iimpazamo kunye neziphumo zeeMbewu ezingenanto
- Umsebenzi weCOS ubonisa i- #VALUE! impazamo ukuba isalathiso esetyenziswe njengesigqibo somsebenzi sikhombisa iseli elineenkcukacha zedata yecatshulwa emithathu umzekelo apho isalathisi esetyenzisiweyo isetyenziswe kwibhile yombhalo: I- Angle (Radians);
- Ukuba iseli likhomba kwisitenki esingenalutho, umsebenzi ubuyisela ixabiso lenye imitha emathandathu ngasentla. Imisebenzi ye-Excel ye-trig isichaza iingubo ezingenanto njenge-zero, kwaye i-cosine yama-radius yelingana ilingana.
Ukusetyenziswa kweTrigonometric kwi-Excel
I-Trigonometry igxininisa ubudlelwane phakathi kwamacandelo kunye neengcangca zontathutathu, kwaye ngelixa abaninzi bethu abayidingi ukuyisebenzisa imihla ngemihla, i-trigonometry inezicelo kwiinkalo ezininzi ezibandakanya izakhiwo, i-physics, ubunjineli kunye nokuhlola.
Abacwangcisi, umzekelo, sebenzisa i-trigonometry ngokubala okubandakanya ukuthungwa kwelanga, umthwalo wendawo, kunye neentaba.
02 we 02
Ibhokisi leNxibelelwano ye-MANOW
Enye indlela yokuthayipha umsebenzi we-MANOW kwifom yokusebenza ngesandla ukusebenzisa ibhokisi yencoko yencoko yomsebenzi. Amanyathelo alandelayo afaka le ndlela yokungena msebenzi WENJE.
- Cofa kwiseli yomsebenzi apho umhla wamanje kunye nexesha liza kuboniswa
- Cofa kwiThebhu yefomula.
- Khetha Umhla & Ixesha kwi-Ribbon ukuvula uluhlu lokuhlaselwa komsebenzi.
- Cofa MANJE kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
- Ekubeni lo msebenzi awuthathi ncoko, nqakraza u-OK ukufaka umsebenzi kwiseli langoku kwaye vala ibhokisi yencoko
- Ixesha kunye nomhla okwangoku kufuneka kuvele kwiseli esebenzayo.
- Xa ucofa kwi-cell esebenzayo, umsebenzi opheleleyo = MANJE () uvela kwibha yefomula ngaphezulu kwephepha lokusebenzela .
RANK Umsebenzi
Qaphela, ibhokisi yencoko yalo msebenzi ayitholakali kwi-Excel 2010 kunye neenguqulelo zexesha elizayo leprogram. Ukuyisebenzisa kwezi nguqulelo, umsebenzi kufuneka ungenwe ngesandla.
Ukuvula Ibhokisi yeDialog
Amanyathelo angezantsi iinkcukacha ezisetyenziswayo ukufaka umsebenzi we-RANK kunye neengxabano kwi-cell B7 usebenzisa ibhokisi yencoko yencoko yomsebenzi kwi-Excel 2007.
- Cofa kwiseli B7 - indawo apho iziphumo ziza kuboniswa
- Cofa kwiThebhu yefomula
- Khetha Imisebenzi Engakumbi> Isitatisti kwibhebhoni ukuvula uluhlu lokuhla kwehla
- Cofa kwi- RANK kwoluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
- Cofa kwifowuni B3 ukukhetha inombolo ukuba ibekwe (5)
- Cofa kwi-"Ref" umgca kwibhokisi yencoko
- Gqamisa iiseli B1 ukuya ku-B5 ukufaka eli luhlu kwibhokisi yencoko
- Cofa kwi "Umyalelo" umgca kwibhokisi yencoko
- Thayipha i-zero (0) kulo mgca ukubeka inani kwinani ehla.
- Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko
- Inombolo 4 kufuneka ibonakale kwiseli yeB7 ukususela kwinani le-5 likhulu lesine
- Xa ucofa kwi-cell B7, umsebenzi opheleleyo = I-RANK (B3, B1: B5,0) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.