Yini okwenziwe ngayo?
I-Excel inezinombolo eziningi ezakhiwe ngaphakathi kwe-trigonometric eyenza kube lula ukuthola i-cosine, i-sine, ne-tangent yenxantathu engakwesokudla-unxantathu equkethe i-angle elingana nama-90 degrees. Inkinga kuphela ukuthi le misebenzi idinga ukuthi ama-angles alinganiswe kuma-radians kunama-degrees, kanti ngenkathi i-radians yindlela evumelekile yokulinganisa ama-angles asekelwe engxenyeni yombuthano, akuyona into abantu abaningi abasebenza ngaso sonke isikhathi.
Ukuze usize umsebenzisi wesipredishithi esiphakathi angenele le nkinga, i-Excel inomsebenzi we-RADIANS, okwenza kube lula ukuguqula ama-degrees kuma-radians.
01 ngo-07
RADIANS Umsebenzi we-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-RADIANS yilezi:
= I-RADIAN (i-Angle)Impikiswano ye-Angle iyona engxenyeni emadigri okuguqulwa kuma-radians. Ingangena njengezigridi noma njengencazelo yeselula endaweni yale datha kushidi lokusebenzela .
02 ngo-07
I-Excel RADIANS Isibonelo somsebenzi
Bheka umfanekiso ohambisana nalesi sihloko njengoba ulandela nalesi sifundo.
Lesi sibonelo sisebenzisa umsebenzi we-RADIANS ukuguqula ama-degree angama-45 kuya kuma-radians. Lolu lwazi luhlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-RADIANS kumakhalekhukhwini we-B2 weshidi lomsebenzi.
Ukufaka umsebenzi we-RADIANS
Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:
- Ukuthayipha umsebenzi ophelele: = amaRADIANS (A2) noma = amaRADIANS (45) angene esitokisini B2
- Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lengxoxo ye- RADIANS
Nakuba kungenzeka ukufaka umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo, njengoba kunakekela ukungena kwe-syntax yomsebenzi njengabakaki kanye nabahlukanisi be-comma phakathi kwama-arguments.
03 ka-07
Ukuvula ibhokisi lokuxoxa
Ukufaka umsebenzi we-RADIANS nezimpikiswano kumakhalekhukhwini B2 usebenzisa ibhokisi lengxoxo lomsebenzi:
- Chofoza kuseli B2 kushidi lokusebenzela. Yilapho umsebenzi uzobe khona.
- Chofoza kuthebhu yefomula yemenyu ye- ribbon .
- Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi lomsebenzi.
- Chofoza ku- RADIANS ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi.
04 ka 07
Ukufaka Ukungqubuzana Komsebenzi
Kweminye imisebenzi ye-Excel, njengomsebenzi we-RADIANS, kuyindaba elula ukungena idatha yangempela okufanele isetshenziselwe ukuphikisana ngokuqondile ebhokisini lengxoxo.
Kodwa-ke, kuvame ukuthi kungcono ukuthi ungasebenzisi idatha yangempela yokuphikisana komsebenzi ngoba ukwenza kanjalo kwenza kube nzima ukuvuselela ishidi lokusebenzela. Lesi sibonelo sifaka ireferensi yeseli yedatha njengengxabano yomsebenzi.
- Ebhokisini lengxoxo, chofoza ku- Angle line.
- Chofoza ku-cell A2 ekhasini lokusebenzela ukuze ufake ireferensi yeseli njengengxabano yomsebenzi.
- Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela. Impendulo ye- 0.785398163, eyi-degrees angu-45 evezwe kuma-radians, ivela esitokisini B2.
Chofoza kuseli B1 ukuze ubone umsebenzi ophelele = I-RADIANS (A2) ivela kubha yefomula ngaphezulu kwephepha lokusebenzela.
05 ka-07
An Alternative
Okunye, njengoba kuboniswe emgqeni wesithombe sesibonelo sesine, kuzokwandisa ukusebenza nge-PI () bese uhlukanisa umphumela we-180 ukuze uthole i-angle kuma-radians.
06 ka-07
I-Trigonometry ne-Excel
I-Trigonometry igxile ebuhlotsheni phakathi kwezinhlangothi nezingxenyeni zontathu, kanti iningi lethu alidingi ukuyisebenzisa nsuku zonke, i-trigonometry inezinhlelo zokusebenza ezinkambu eziningi ezibandakanya izinkanyezi, i-physics, ubunjiniyela, nokuhlola.
07 ka-07
Inothi lomlando
Ngokusobala, imisebenzi ye-Excel ye-trig isebenzisa ama-radians kunama-degrees ngoba ngenkathi uhlelo luqala ukudala, imisebenzi ehlanganisiwe yenzelwe ukuhambisana nemisebenzi emithathu ohlelweni lwepredishithi iLotus 1-2-3, eyasebenzisa i-radians futhi eyayilawula i-PC imakethe yesofthiwe yesipredishithi ngaleso sikhathi.