Yiyiphi into eyenza ukuyenza nayo?
I-Excel inomsebenzi omiselweyo we-trigonometric owenza kube lula ukufumana i-cosine, i-sine, ne-tangent ye-triangle-angle-triangle inxantathu ene-angle elingana nama-90 degrees. Ingxaki kuphela kukuba le mi sebenzi idinga ukuba ama-angles alinganiswe kuma-radians kunama-degrees, kwaye ngelixa i-radians yindlela efanelekileyo yokulinganisa iingqungquthela ezisekelwe kwirejista yesangqa, akuyona into eninzi abantu basebenza ngayo rhoqo.
Ukunceda umsebenzisi wespredishithi oqhelekileyo ajikeleze le ngxaki, i-Excel inomsebenzi we-RADIANS, okwenza kube lula ukuguqula ama-degrees kuma-radians.
01 ngo 07
I-RADIANS Umsebenzi we-Syntax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .
I-syntax yomsebenzi we-RADIANS yile:
= IAROMA (iNgesi)Ingxabano ye-Angle iyona ngqungqutyana kwiimigangatho ekufuneka iguqulwe ibe ngama-radians. Ingangeniswa njengama-degrees okanye njengetereferensi yeseli kwendawo yale datha kwiphepha lokusebenzela .
02 we-07
Excel RADIANS Umsebenzi Umzekelo
Jonga umfanekiso ohamba kule nqaku njengoko ulandela kunye nale khokelo.
Lo mzekelo usebenzisa umsebenzi we-RADIANS ukuguqula i-angle-degree-degree. Ingcaciso iquka amanyathelo asetyenziswa ukufaka umsebenzi we-RADIANS kwisitimu B2 somzekelo wephepha lokusebenzela.
Ukufaka umsebenzi weRADIANS
Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:
- Ukuthayipha umsebenzi opheleleyo: = IARADIANS (A2) okanye = IARADIANS (45) kwi-cell B2
- Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yencoko ye -RADIANS
Nangona kunokwenzeka ukufaka umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukuyisebenzisa ibhokisi yencoko, njengoko kuthatha ukunakekelwa kokungena kwi-syntax yomsebenzi njengabakaki kunye nabahluli be-comma phakathi kweengxabano.
03 we-07
Ukuvula Ibhokisi yeDialog
Ukufaka umsebenzi weRADIANS kunye neengxabano kwi-cell B2 usebenzisa ibhokisi yencoko yomsebenzi:
- Cofa kwiseli B2 kwiphepha lokusebenzela. Le yilapho umsebenzi uya kuba khona.
- Cofa kwiTrafom ithebhu yemenyu yebhondi .
- Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lokuhlaselwa komsebenzi.
- Cofa kwi- RADIANS kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi.
04 we-07
Ukungena kwiSigqibo sokuSebenza
Kweminye imisebenzi ye-Excel, njengomsebenzi we-RADIANS, kuyinto elula ukufaka idatha yangempela ukuze isetyenziswe ngxabano ngqo kwibhokisi yencoko.
Nangona kunjalo, ngokuqhelekileyo kungcono ukuba ungasebenzisi idatha yangempela kwimpikiswano yomsebenzi kuba ukwenza njalo kwenza kube nzima ukuhlaziya iphepha lokusebenzela. Lo mzekelo ungena kwiselferensi yeseli kwidatha njengengxabano yomsebenzi.
- Kwibhokisi yencoko, nqakraza kwi- Angle line.
- Cofa kwifowuni A2 kwiphepha lokusebenzela ukuze ufake ifowuni yesalathisi njengengxabano yomsebenzi.
- Cofa Kulungile ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela. Impendulo ye- 0.785398163, eyi-degrees ezingama-45 ezichazwe kuma-radians, ibonakala kwiseli B2.
Cofa kwiseli B1 ukubona umsebenzi opheleleyo = IARADIANS (A2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
05 we-07
Eyona ndlela
Ngenye indlela, njengoko kuboniswe kumqolo omine womfanekiso mzekelo, kukunyusa i-angle nge-PI () kwaye uhlule umphumo we-180 ukufumana i-angle kuma-radians.
06 we-07
Trigonometry kunye ne-Excel
I-Trigonometry igxininisa ubudlelwane phakathi kwamacandelo kunye neengcangca zontathutathu, kwaye ngelixa abaninzi bethu abayidingi ukuyisebenzisa imihla ngemihla, i-trigonometry inezicelo ezininzi kwiinkalo ezibandakanya i-astronomy, i-physics, ubunjineli kunye nokuhlola.
07 we-07
Inqaku leMbali
Kuyabonakala ukuba, imisebenzi ye-Excel ye-trig isebenzise ama-radians kunokuba i-degrees kuba xa iprogram yaqala ukudala, imisebenzi ye-trig yenzelwe ukuhambelana nemisebenzi emithathu kwiprogram yespredishithi iLotus 1-2-3, eyasebenzisa i-radians kunye neyolawulo kwi-PC isofthiwe yespredishithi yeevenkile ngexesha.