Phunzirani momwe mungasinthire angles kuchokera ku digiri kupita ku mafilimu ku Excel

Nchiyani chomwe chikugwera ndi izo?

Excel ili ndi ntchito zingapo zopangidwa ndi trigonometric zomwe zimapangitsa kuti zikhale zosavuta kupeza cosine, sine, ndi katatu ya katatu kolumikiza-katatu kamene kali ndi ngodya yofanana ndi madigiri 90. Vuto lokha ndilokuti ntchitoyi imafuna kuti maangelo ayesedwe mu ma radians osati madigiri, ndipo pamene radians ndi njira yolondola yowunikira angles pogwiritsa ntchito malo ozungulira, sizinthu zomwe anthu amagwira ntchito nthawi zonse.

Kuti athandize owerenga spreadsheet kupeza vutoli, Excel ili ndi ntchito RADIANS, zomwe zimapangitsa kukhala kosavuta kusintha madigiri mpaka radians.

01 a 07

ZOKHUDZA NTCHITO Ntchito Yogwirizanitsa ndi Zokambirana

Kutembenuza Angles kuchokera ku Degrees to Radians ku Excel. © Ted French

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya RADIANS ndi:

= ANTHU (Angle)

Mtsutso Wachifumu ndi mpangidwe mu madigiri kuti atembenuzidwenso kuti awonekere. Ikhoza kulowa ngati madigiri kapena selo lofotokozera za malo a deta iyi muzenera .

02 a 07

Excel Ntchito YOPHUNZITSIRA Chitsanzo

Tchulani chithunzi chomwe chikutsatira nkhaniyi pamene mukutsatira limodzi ndi phunziroli.

Chitsanzo ichi chimagwiritsa ntchito ntchito ya RADIANS kuti isinthe mawonekedwe a digiri 45 mpaka ma radians. Chidziwitsochi chimagwiritsa ntchito njira zomwe zimagwiritsidwa ntchito kulowa mu RADIANS mu selo B2 la tsamba la ntchito.

Kulowa Ntchito YOPHUNZITSIRA

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

Ngakhale kuti n'zotheka kugwira ntchito yeniyeni pamanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo, popeza zimasamalira kulowa mu syntax monga mabakiteriya ndi ogawanikana pakati pa zifukwa.

03 a 07

Kutsegula Bokosi la Zokambirana

Kulowa ntchito za RADIANS ndi zokambirana mu selo B2 pogwiritsa ntchito bokosi la bokosi:

  1. Dinani pa selo B2 papepala. Apa ndi pamene ntchitoyi idzapezeka.
  2. Dinani pa Fomu tab ya menyu yowonjezera.
  3. Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi.
  4. Dinani pa RADIANS mndandanda kuti mubweretse bokosi lazokambirana.

04 a 07

Kulowa Kutsutsana kwa Ntchito

Kwa ntchito zina za Excel, monga ntchito ya RADIANS, ndizosavuta kulowetsa deta lenileni kuti ligwiritsidwe ntchito pazokambirana mwachindunji ku bokosi.

Komabe, ndibwino kuti musagwiritse ntchito chidziwitso chenichenicho chifukwa cha kukangana kwa ntchito chifukwa kuchita zimenezi kumawunikira kuti musinthe tsambalo. Chitsanzo ichi chimalowa mu selo loyang'ana pa deta monga kukangana kwa ntchito.

  1. Mu bokosi la bokosi, dinani pa mzere wa Angelo .
  2. Dinani pa selo A2 patsiku la ntchito kuti mulowetse selo monga gawo la ntchito.
  3. Dinani OK kuti mukwaniritse ntchitoyi ndi kubwerera kuntchito. Yankho la 0.785398163, lomwe ndi madigiri 45 operekedwa mu radians, limapezeka mu selo B2.

Dinani pa selo B1 kuti muwone ntchito yonse = RADIANS (A2) imawoneka mu barra ya fomu pamwamba pa tsamba.

05 a 07

Njira Yina

Njira ina, monga momwe ikusonyezedwera m'zithunzi zinayi za chithunzi, ndi kuchulukitsa mbali ndi PI () ntchito ndikugawanitsa zotsatira za 180 kuti muzitha kuima.

06 cha 07

Trigonometry ndi Excel

Trigonometry imagogomezera mgwirizano pakati pa mbali ndi makona a katatu, ndipo pamene ambirife sitisowa kuzigwiritsa ntchito tsiku ndi tsiku, trigonometry ili ndi ntchito muzinthu zosiyanasiyana monga zakuthambo, fiziki, engineering, ndi kufufuza.

07 a 07

Historical Note

Zikuoneka kuti ntchito za Excel zomwe zimagwiritsidwa ntchito zimagwiritsira ntchito ma radians osati madigiri chifukwa pamene pulogalamuyo inayamba kukhazikitsidwa, ntchito zitatuzo zinapangidwa kuti zigwirizane ndi ntchito zomwe zili m'ndondomeko ya Lotus 1-2-3, yomwe idagwiritsanso ntchito radians ndi yomwe inkalamulira PC. malonda a pulogalamu yamapulogalamu pa nthawiyo.