01 ngo-02
Thola i-Cosine ye-Angle nge-COS Umsebenzi we-Excel
Ukuthola i-Cosine ye-Angle e-Excel
Umsebenzi owenziwe nge-trigonometric, njenge -sine kanye ne -tangent , isekelwe kunxantathu elungile (unxantathu onalo i-angle elingana nama-90 degrees) njengoba kuboniswe esithombeni ngenhla.
Esiklasini sesibalo, i-cosine ye-angle itholakala ngokuhlukanisa ubude ohlangothini oluseduze ne-angle ngobude be-hypotenuse.
Ku-Excel, i-cosine ye-angle ingatholakala ngokusebenzisa umsebenzi we-COS uma nje lelo ngoma lilinganiswa kuma- radians .
Ukusebenzisa umsebenzi we-COS kungakusiza isikhathi esiningi futhi mhlawumbe kunomsebenzi omkhulu wokukhanda ikhanda ngoba awusadingeki ukhumbule ukuthi yiliphi uhlangothi lendxantathu eliseduze ne-angle, okuphambene nalokho, futhi yikuphi okuyi-hypotenuse.
Ama-Degrees vs. Radians
Ukusebenzisa umsebenzi we-COS ukuthola i-cosine ye-angle kungase kube lula kunokukwenza ngesandla, kodwa, njengoba kubonisiwe, kubalulekile ukuqaphela ukuthi uma usebenzisa umsebenzi we-COS, i-angle idinga ukuba i- radians kunama- degree - yiyiphi iningi lethu iningi lingazi.
AmaRussia ahlobene nengqikithi yombuthano ngenye ye-radian esilingana nokulingana nama-57 degrees.
Ukuze wenze kube lula ukusebenza nge-COS kanye nezinye izinto ze-Excel ze-Excel, sebenzisa umsebenzi we-RADIANS we-Excel ukuguqula i-engeni elinganiswa ukusuka kuma-degree kuya kuma-radians njengoba kuboniswe esitokisini B2 esithombeni ngenhla lapho i-angle yama-degrees angu-60 iguqulwa ibe yi-radians 1.047197551.
Okunye okukhethwa kukho ukuguqula kusuka kumadiresi kuya kuma-radians kufaka:
- Ukwakha umsebenzi we-RADIANS ngaphakathi komsebenzi we-COS - njengoba kuboniswe kulayini 3 kusibonelo;
- usebenzisa umsebenzi we-Excel we- PI kwifomula: i- angle (degrees) * PI () / 180 njengoba kuboniswe kulayini 4 kusibonelo.
I-Syntax ne-Arguments ye-COS Function
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi , amabakaki, nokuphikisana .
I-syntax yomsebenzi we-COS yilezi:
= I-COS (Inombolo)
Inombolo - i-angle ibalwa - kulinganiswa kuma-radians
- ubukhulu be-angle kuma-radians bungangeniswa kule mpikiswano noma ukubhekisela kweseli endaweni yile datha kushidi lokufaka kungenziwa esikhundleni
Isibonelo: Ukusebenzisa i-COS Umsebenzi we-Excel
Lesi sibonelo sihlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-COS esitokisini C2 esithombeni esingenhla ukuthola i-cosine ye-angle angama-60 degree noma i-1.047197551 i-radians.
Izinketho zokufaka umsebenzi we-COS zifaka ukuthayipha ngesandla kuwo wonke umsebenzi = i- COS (B2) , noma usebenzisa ibhokisi lengxoxo lomsebenzi - njengoba kuchazwe ngezansi.
Ukufaka umsebenzi we-COS
- Chofoza kuseli C2 kushidi lokusebenzela ukuze wenze iseli elisebenzayo ;
- Chofoza kuthebhu yefomula yemenyu ye-Ribbon;
- Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi;
- Chofoza ku-COS ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi;
- Ebhokisini lengxoxo, chofoza kulayini lombhalo;
- Chofoza kuseli B2 kusikripthi sokusebenzela ukufaka lelo referensi yeseli kufomula;
- Chofoza u-Kulungile ukuqedela ifomu bese ubuyela ekhasini lokusebenzela;
- Impendulo 0.5 kumele ibonakale esitokisini C2 - okuyinto i-cosine ye-angle engama-60 degree;
- Uma uchofoza ku-cell C2 umsebenzi ophelele = I- COS (B2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
#VALUE! Amaphutha kanye Nemiphumela Yelikhanda Elibukhali
- Umsebenzi we-COS ubonisa i- #VALUE! iphutha uma ireferensi esetshenzisiwe njengengxabano yomsebenzi ikhomba esitokisini equkethe idatha yombhalo wesigcawu sesihlanu isibonelo lapho isethenjwa selesithenjwa esetshenzisiwe sikhombise ilebula yombhalo: I- Angle (amaRudiya);
- Uma iseli likhomba esitokisini esingenalutho, lo msebenzi ubuyisela inani elilodwa - irowu eyisithupha ngenhla. Imisebenzi ye-Excel ye-trig ihumusha amangqamuzana angenalutho njenge-zero, futhi i-cosine yama-zero radians ilingana nelinye.
Ukusetshenziswa kwe-Trigonometric ku-Excel
I-Trigonometry igxile ebuhlotsheni phakathi kwezinhlangothi nezinhlangothi zontathu, futhi nakuba abaningi bethu kungadingeki bayisebenzise nsuku zonke, i-trigonometry inezinhlelo zokusebenza ezinkambu eziningi ezibandakanya izakhiwo, i-physics, ubunjiniyela, nokuhlola.
Abacwaningi, isibonelo, basebenzisa i-trigonometry ngezibalo ezibandakanya ukushisa kwelanga, umthwalo wesakhiwo, kanye namapulangwe ophahleni.
02 ka 02
Ibhokisi le-Dialog Dialog Function
Enye indlela yokuthayipha umsebenzi we-MANU kumsebenzi wokusebenza ngesandla ukusebenzisa ibhokisi lengxoxo lomsebenzi. Izinyathelo ezilandelayo zihlanganisa le ndlela yokufaka umsebenzi we-MANJE.
- Chofoza kuseli leshidi lokusebenzela lapho usuku nosuku noma isikhathi sizoboniswa khona
- Chofoza kuthebhu yefomula .
- Khetha Usuku Nesikhathi kusuka kubhebhoni ukuvula uhlu lokudonsa phansi lomsebenzi.
- Chofoza ku- MANJE ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi
- Njengoba lo msebenzi awutholi izingxabano, chofoza u-OK ukufaka umsebenzi esitokisini samanje bese uvala ibhokisi lengxoxo
- Isikhathi nosuku samanje kufanele kuvele kuseli elisebenzayo.
- Uma uchofoza esitokisini esisebenzayo, umsebenzi ophelele = MANJE () uvela kubha yamasombululi ngaphezulu kwephepha lokusebenzela .
Umsebenzi we-RANK
Qaphela, ibhokisi lengxoxo yalo msebenzi alitholakali ku-Excel 2010 nezinguqulo zamuva zalolu hlelo. Ukuze uyisebenzise kulezi zinguqulo, umsebenzi kufanele ufakwe ngesandla.
Ukuvula ibhokisi lokuxoxa
Izinyathelo ezansi ngezansi izinyathelo ezisetshenziselwa ukungena umsebenzi we-RANK nezimpikiswano zibe esitokisini B7 usebenzisa ibhokisi lengxoxo lomsebenzi ku-Excel 2007.
- Chofoza kuseli B7 - indawo lapho imiphumela izoboniswa khona
- Chofoza kuthebhu yefomula
- Khetha Imisebenzi Engaphezulu> Isitatimende kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza phansi
- Chofoza ku- RANK kuhlu ukuze ulethe ibhokisi lengxoxo lomsebenzi
- Chofoza kuseli B3 ukukhetha inombolo ezobekwa (5)
- Chofoza ku-"Ref" umugqa ebhokisini lengxoxo
- Qinisekisa amaseli B1 kuya ku-B5 ukungena kuleli banga ukuya ebhokisini lengxoxo
- Chofoza kulayini "Oda" ebhokisini lengxoxo
- Thayipha i-zero (0) kulolu gqa ukuze ubeke inombolo enqoleni.
- Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
- Inombolo 4 kufanele ivele esitokisini B7 kusukela inombolo engu-5 iyinombolo yesine ngobukhulu
- Uma uchofoza ku-cell B7, umsebenzi ophelele = I-RANK (B3, B1: B5,0) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.