I-Arc tangent ifakiwe ochungechungeni lwezincazelo eziphikisayo ze-trigonometric. Kuphambene ne-tangent. Njengawo wonke amanani anjalo, kubalwa kuma-radian. I-Excel inomsebenzi okhethekile okuvumela ukuthi ubale i-arc tangent yenombolo enikeziwe. Ake sibheke ukuthi ungayisebenzisa kanjani le opharetha.
Ukubalwa kwenani le-arctangent
I-Arc tangent iyinkulumo eyisisekelo. Kubalwa njenge-engeli kuma-radian kabana tangent yayo ilingana nenombolo yengxabano ye-arc tangent.
Ukubala leli nani, i-Excel isebenzisa opharetha E-ATANokuyingxenye yeqembu lemisebenzi yezibalo. Ukuphikisana kwayo kuphela yinombolo noma ireferensi yeseli equkethe inkulumo yezinombolo. I-syntax ithatha indlela elandelayo:
= ATAN (inombolo)
Indlela yoku-1: Ukungenela Umsebenzi Wemisebenzi
Kumsebenzisi onolwazi, ngenxa yobulula be-syntax yalomsebenzi, kulula futhi ngokushesha ukusifaka kuwo.
- Khetha iseli lapho umphumela wokubala kufanele ube khona, bese ubhala ifomula yohlobo:
= ATAN (inombolo)Esikhundleni sokuphikisana "Inombolo", Yebo, sibeka inani elithile lezinombolo. Ngakho-ke i-arc tangent yezine izobalwa ngefomula elandelayo:
= ATAN (4)Uma inani lamanani lisesitokisini esithile, khona-ke ikheli lomsebenzi lingaba yisiphikisi somsebenzi.
- Ukukhombisa imiphumela yokubala esikrinini, cindezela inkinobho Ngena.
Indlela 2: Bala Usebenzisa iWizard Yomsebenzi
Kepha kulabo abasebenzisi abangakazazi ngokuphelele izindlela zokungenela ngesandla noma abajwayele ukusebenza nabo kuphela ngesibonisi sokuqhafaza, ukubala kusetshenziswa Umsebenzi Wizards.
- Khetha iseli ukubonisa umphumela wokulungiswa kwedatha. Chofoza inkinobho "Faka umsebenzi"ibekwe kwesokunxele sebha lefomula.
- Ukuvula kwenzeka Umsebenzi Wizards. Esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi" igama kufanele litholakale E-ATAN. Ukuze uvule iwindi lokuphikisana, likhethe bese uchofoza inkinobho "Kulungile".
- Ngemuva kokwenza lezi zinyathelo, iwindi lokuphikisana ne-opharetha liyavula. Inenkambu eyodwa kuphela - "Inombolo". Kuyo, udinga ukufaka inombolo okufanele i-arc tangent ibalwe. Ngemuva kwalokho chofoza inkinobho "Kulungile".
Futhi, njengengxabano, ungasebenzisa isixhumanisi esiya kuseli lapho le nombolo itholakala khona. Kulokhu, kulula ukuthi ungafaki izixhumanisi ngesandla, kepha ukubeka isikhombisi endaweni yenkambu bese umane ukhethe ekhasini lelo element lapho inani elifunekayo litholakala khona. Ngemuva kwalezi zinyathelo, ikheli lalesi seli lizokhonjiswa ewindini lokuphikisana. Ngemuva kwalokho, njengakuhlobo lwangaphambilini, chofoza inkinobho "Kulungile".
- Ngemuva kokwenza izinyathelo ngokuya nge-algorithm engenhla, inani le-arc tangent ku-radian yenombolo ebekwe emsebenzini lizokhonjiswa kuseli elakhelwe ngaphambili.
Isifundo: Umsebenzi Wizard e-Excel
Njengoba ukwazi ukubona, ukuthola inani le-arctangent e-Excel akuyona inkinga. Lokhu kungenziwa kusetshenziswa opharetha okhethekile. E-ATAN nge-syntax elula elula. Ungasebenzisa le formula kungaba ngokufaka okwenziwe ngesandla noma ngesibonisi Umsebenzi Wizards.
