Ke eng e entsoeng ka eona?
Excel e na le mesebetsi e mengata e hahiloeng ka trigonometric e etsang hore ho be bonolo ho fumana cosine, sine, le tangent ea boraro-pota-pota-pota e nang le lehlakoreng le lekanang le likhato tse 90. Bothata feela ke hore mesebetsi ena e hloka hore maqhubu a lekanyetsoe ka li-radians ho feta li-degree, 'me ha radians e le tsela e nepahetseng ea ho lekanya li-angles tse thehiloeng mokokotlong oa selikalikoe, hase ntho eo batho ba bangata ba sebetsang le eona kamehla.
Ho thusa basebelisi ba tloaelehileng ho fumana bothata bona, Excel e na le mosebetsi oa RADIANS, o etsang hore ho be bonolo hore o fetole li-degree ho radians.
01 ea 07
RADIANS Mosebetsing Syntax le Arguments
Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .
Sephetho sa mosebetsi oa RADIANS ke:
= RADIANS (Angle)Phehisano ea Mangeloi ke lebelo la likhato tse tla fetoloa ho radians. E ka kenngoa e le li-degrees kapa e le sello ea sele ho sebaka sa data ena lefats'eng.
02 ea 07
Excel RADIANS Mesebetsi Mohlala
Sheba setšoantšo se tsamaeang le sehlooho sena ha u ntse u latela le thupelo ena.
Mohlala ona o sebelisa mosebetsi oa RADIANS ho fetola mahlakore a 45-degree ho radians. Tlhahisoleseding e akaretsa mehato e sebelisetsoang ho kenya mosebetsi oa RADIANS ka seleng ea B2 ea setšoantšo sa mosebetsi.
Ho kenya mosebetsi oa RADIANS
Dikgetho bakeng sa ho kena mosebetsing le mabaka a eona a kenyeletsa:
- Tšoara mosebetsi o feletseng: = RADIANS (A2) kapa = RADIANS (45) ka seleng ea B2
- Ho khetha mosebetsi le mabaka a oona ho sebelisa mosebetsi oa RADIANS dialog box
Le hoja ho ka khoneha ho kenya letsoho ka botlalo, batho ba bangata ba fumana ho le bonolo ho sebelisa lebokose la lebokose, kaha le hlokomele ho kena ka syntax ea mosebetsi e kang likereke le likarohano tsa lihlahisoa pakeng tsa likhang.
03 ea 07
Ho bula lebokose la Dialog
Ho kenya mosebetsi oa RADIANS le likhang ka seleng ea B2 ho sebelisa lebokose la lebokose la mosebetsi:
- Tobetsa ho cell B2 kahare ea mosebetsi. Mona ke moo mosebetsi o tla fumanoa teng.
- Tobetsa Tlhahlobo ea temo ea menu.
- Khetha Math & Trig ho tloha leboneng ho bula lenane la ho theoha mosebetsing.
- Tobetsa ho RADIANS lethathamong la ho hlahisa lebokose la lebokose la mosebetsi.
04 ea 07
Ho kenya Khang ea Mosebetsi
Bakeng sa mesebetsi e meng ea Excel, e kang mosebetsi oa RADIANS, ke taba e bonolo ho kenya data ea sebele e lokelang ho sebelisoa bakeng sa khang ka ho toba lebokoseng la lebokose.
Leha ho le joalo, hangata ho molemo hore u se ke ua sebelisa data ea sebele bakeng sa khang ea mosebetsi hobane ho etsa joalo ho etsa hore ho be thata ho ntlafatsa leqephe la mosebetsi. Mohlala ona o kenella selekaneng ea sele ho data e le khang ea mosebetsi.
- Ka lebokoseng la lebokose, tobetsa ho Molumo oa Angle .
- Tobetsa seleng ea A2 leqepheng la mosebetsi oa ho kenya selefouno ea sele joaloka ntlha ea mosebetsi.
- Tobetsa OK ho qeta mosebetsi mme o khutlele mosebetsing. Karabo ea 0.785398163, e leng likhato tse 45 tse hlahisoang ka li-radians, e hlaha seleng ea B2.
Tobetsa seleng B1 ho bona mosebetsi o feletseng = RADIANS (A2) e hlaha kahare ea foromo ka holim'a leqephe la mosebetsi.
05 ea 07
Ntho e 'Ngoe
Ntho e 'ngoe, joalokaha e bontšitsoe setšoantšong se seng sa mohlala, ke ho atisa lebelo ka PI () le ho arola sephetho sa 180 ho fumana mahlaseli a radians.
06 ea 07
Trigonometry le Excel
Trigonometry e lebisa tlhokomelo likamanong pakeng tsa mahlakoreng le maqhubu a boraro-boraro, 'me ha ba bangata ba rona re sa hloke ho e sebelisa letsatsi le leng le le leng, trigonometry e na le mekhoa e mengata ho akarelletsa le linaleli, fisiks, boenjiniere le ho hlahloba.
07 ea 07
Tlaleho ea Histori
Kamoo ho bonahalang kateng, mesebetsi ea Tricel ea Tricel e sebelisa radians ho e-na le litekanyetso hobane ha lenaneo le qala ho bōptjoa, mesebetsi ea trig e ne e etselitsoe ho lumellana le mesebetsi ea trig lenaneong la spreadsheet Lotus 1-2-3, e neng e boetse e sebelisa radians le e neng e laola PC marakeng ea software ea spreadsheet ka nako eo.