Arctanges inoshanda muExcel

Anonim

Arctnons muMicrosoft Excel

Arctangerenent inosanganisirwa muhuwandu hwezvikamu zveTrigonometric kutaura. Akapesana neTangent. Kunge tsika dzese dzakafanana, dzinoverengerwa muma radians. Excel ine basa rakakosha iro rinobvumira kuverenga kweArctangere yenhamba yakatarwa. Ngatifungei kuti ungashandisa sei uyu mushandiri.

Kuverenga kwekukosha kweArcctane

Arctambens is a trigonometric kutaura. Iyo inoverengwa mune fomu yekona mu radians, ayo tangent akaenzana nehuwandu hwekupokana kweArctangere.

Kuti uverenge kukosha uku, iyo ATAN Operator inoshandiswa mukubiridzira, iyo inosanganisirwa muboka remabasa emasvomhu. Iyo chete nharo ndiyo nhamba kana chirevo chechitokisi, icho chine chirevo chehuwandu. Syntax inotora fomu inotevera:

= Atan (nhamba)

Nzira 1: bhuku rekupinda basa

Kune mushandisi ane ruzivo, nekuda kwekureruka kweiyo syntax yechinhu ichi, zviri nyore uye nekukurumidza kuti ubudise iyo bhuku rayo rebhuku.

  1. Isu tinosimbisa sero umo mhedzisiro yacho mhedzisiro yekuverenga, uye nyora pasi nzira yemhando:

    = Atan (nhamba)

    Panzvimbo pekupokana "nhamba", sezvazviri, isu tinotsiva chaiyo nhamba yehuwandu. Saka Arcthangnence ina ichaverengerwa maererano neye inotevera formula:

    = Atani (4)

    Kana kukosha kwenhamba kuri mune imwe sero renyaya, ipapo kupokana kwebasa kunogona kuve kero kwayo.

  2. Atan Microsoft Excel Feature

  3. Kuratidza mhedzisiro yekuverenga kune iyo skrini, tinya bhatani rePeturu.

Mhedzisiro yekuverenga kweiyo ATAN Microsoft Excel basa

Nzira 2: Kuverenga uchishandisa tenzi emabasa

Asi kune avo vashandisi vasina kunyatsoziva maitiro emanyorero ebhuku rekupinda, kana kungoita kuti vashande navo chete kuburikidza neiyo graphical interface, kuverenga kunenge kwakakodzera kushandisa mabasa emubhadharo wizard.

  1. Sarudza iyo sero kuti ubudise mhedzisiro yekugadzirisa data. Dzvanya pane iyo "Insert basa" bhatani, yakaiswa kuruboshwe rwetambo ye formula.
  2. Chinja kune tenzi wemabasa muMicrosoft Excel

  3. Kuvhura madhiri emabasa anoitika. Muboka "masvomhu" kana "yakazara alfabheti rondedzero", iwe unofanirwa kuwana zita rekuti "Atan". Kutanga hwindo rekupokana, sarudza iyo uye tinya iyo "OK" bhatani.
  4. Shanduko yeAtani yekuita nharo muMicrosoft Excel

  5. Mushure mekuuraya izvi zviito, iyo inoshanda nharo hwindo ichavhura. Iyo ine chete munda - "nhamba". Inoda kuunzwa nehuwandu, iyo arctangerent yeicho inofanira kuverengerwa. Mushure meizvozvo, tinya pane "OK" bhatani.

    Atani basa rekupokana muMicrosoft Excel

    Zvakare sepfungwa, unogona kushandisa chinongedzo kuchitokisi umo nhamba iyi. Mune ino kesi, zviri nyore kusapinda mumarongerwo, asi isa iyo yekukonzera nharaunda yemunda uye inongogovera chinhu pane pepa raizivikanwa. Mushure meizvi zviito, kero yesero iri icharatidzwa muhwindo rekupokana. Zvadaro, sezviri mune yekare embodiment, tinya iyo "OK" bhatani.

  6. Mhedzisiro yekuverenga kweiyo Atan basa muMicrosoft Excel

  7. Mushure mekuita zviito pane iyo ALGORITHM iri muchitokisi chakatsanangurwa, iyo Arctangens kukosha inoratidzwa muma radians yenhamba iyo yakatsanangurwa mubato.

Arctangen yakagadzirirwa kuMicrosoft Excel

Chidzidzo: Wizard mabasa muExcel

Sezvauri kuona, kuwana kubva kuhuwandu hweArctctgenes mukubuda haisi dambudziko. Izvi zvinogona kuitwa uchishandisa inokosha ATAN Operator ine yakanaka nyore syntax. Iwe unogona kushandisa iyi formula sebhuku raNoual yekuisa uye kuburikidza neiyo mabasa wizard interface.

Verenga zvimwe