Ntchito ya LOG mu Microsoft Excel

Chimodzi mwazinthu zomwe zimafunikira masamu kuti athetse mavuto a maphunziro ndi othandiza ndikupeza Logarithm kuchokera ku nambala yomwe yapatsidwa pamaziko. Ku Excel, kuti mugwire ntchito iyi, pali ntchito yapadera yotchedwa LOG. Tiyeni tiphunzire mwatsatanetsatane momwe zingagwiritsidwire ntchito.

Kugwiritsa ntchito mawu a LOG

Wogwiritsa ntchito LOG ali m'gulu la ntchito zamasamu. Ntchito yake ndikuwunika Logarithm ya nambala yomwe yatchulidwa pamsika wopatsidwa. Syntax yothandizira wofotokozedwayo ndiyosavuta:

= LOG (nambala; [maziko])

Monga mukuwonera, ntchitoyo imangokhala ndi mfundo ziwiri zokha.

Kukangana "Chiwerengero" imayimira nambala yomwe kuwerengera logarithm. Itha kutenga mawonekedwe a kuchuluka kwa manambala ndikuwongolera foni yomwe ili nayo.

Kukangana "Maziko" ikuyimira maziko omwe logarithm imawerengedwa. Ikhozanso kukhala ndi mawonekedwe a manambala kapena kuchita ngati cholumikizira foni. Mkanganowu ndi wosankha. Ngati yasiyidwa, ndiye kuti mumayang'ana kuti maziko ndi zero.

Kuphatikiza apo, ku Excel pali ntchito ina yomwe imakuthandizani kuwerengetsa ma logarithms - LOG10. Kusiyana kwake kwakukulu kuchokera koyambirira ndikuti kumatha kuwerengetsa ma logarithms kokha pamaziko a 10, ndiye kuti, Logarithms okha. Kuphatikizika kwake ndikosavuta kuposa mawu omwe adanenedwa kale:

= LOG10 (nambala)

Monga mukuwonera, mfundo yokhayo yothandizazi ndi "Chiwerengero", ndiye kuti, nambala yamtengo wapatali kapena zonena za khungu lomwe lilimo. Mosiyana ndi wothandizira LOG ntchitoyi ili ndi mkangano "Maziko" nthawi zambiri kulibe, chifukwa chimaganiziridwa kuti ndizoyambira zomwe zimakhazikitsa 10.

Njira 1: gwiritsani ntchito ntchito ya LOG

Tsopano tiyeni tiwone momwe opaleshoni amagwirira ntchito LOG pa chitsanzo cha konkriti. Tili ndi mzere wazotsatira zamanambala. Tiyenera kuwerengera kwa iwo maziko a logarithm 5.

1. Timasankha khungu loyamba lopanda chilichonse pa pepalalo lomwe tikuganiza zowonetsa zotsatira zomaliza. Chotsatira, dinani pazizindikiro "Ikani ntchito", yomwe ili pafupi ndi mzere wa fomula.



2. Zenera limayamba. Ogwira Ntchito. Timasunthira ku gululi "Masamu". Timasankha "LOG" mndandanda wazogwiritsira, ndiye dinani batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imayamba. LOG. Monga mukuwonera, ili ndi magawo awiri omwe amagwirizana ndi zotsutsana za ogwiritsira ntchito.

   M'munda "Chiwerengero" m'malo mwathu, lowetsani adilesi ya foni yoyamba yam'malo momwe mudapeza. Izi zitha kuchitika ndikulowetsa iwo m'munda pamanja. Koma pali njira yosavuta. Khazikitsani cholowezera mundawo, kenako dinani kumanzere kwa foniyo patebulo lomwe muli nambala ya kufunika. Ogwirizanitsa a cell amawonetsedwa nthawi yomweyo m'munda "Chiwerengero".

   M'munda "Maziko" ingolowetsani mtengo wake "5", popeza zidzakhala zofanana pazosanjidwa zonse ziwerengero.

   Pambuyo pochita izi, dinani batani "Zabwino".



4. Zotsatira Zantchito LOG imawonetsedwa nthawi yomweyo mu khungu lomwe tidatchulapo gawo loyamba la malangizowa.



5. Koma tidadzaza koyamba kokhako. Kuti mudzaze zotsalazo, muyenera kutsata njira. Khazikitsani cholowetsa kumunsi chakumanzere kwa foni yomwe ili nacho. Chizindikiro chodzaza chimayimiriridwa ngati mtanda. Tsitsani batani lakumanzere ndikukoka mtanda mpaka kumapeto kwa mzati.



6. Njira yomwe ili pamwambapa idapangitsa maselo onse m'ndendemo "Logarithm" yodzaza ndi zotsatira za kuwerengera. Chowonadi ndi chakuti ulalo womwe ukuwonetsedwa m'munda "Chiwerengero"ndi wachibale. Mukamasuntha maselo, amasinthanso.

Phunziro: Excel Feature Wizard

Njira 2: gwiritsani ntchito ntchito ya LOG10

Tsopano tiyeni tiwone chitsanzo pogwiritsa ntchito opereshoni LOG10. Mwachitsanzo, titenga tebulo ndimawu omwewo. Koma tsopano, mwachidziwikire, ntchito ndikuwerengera Logarithm yamanambala omwe akhazikitsidwa "Zambiri patsamba" pamaziko a 10 (decimal logarithm).

1. Sankhani selo yoyamba yopanda chilichonse "Logarithm" ndikudina chizindikiro "Ikani ntchito".



2. Pazenera lomwe limatseguka Ogwira Ntchito pitani pagawo lino "Masamu"koma nthawi ino tayimilira dzinali "LOG10". Dinani batani pansi pazenera "Zabwino".



3. Tsamba la mkangano wa ntchito limayambitsa LOG10. Monga mukuwonera, ili ndi gawo limodzi lokha - "Chiwerengero". Lowetsani adilesi ya selo loyamba m'ndandayo "Zambiri patsamba", momwemonso momwe tidakhalira mu chitsanzo cham'mbuyomu. Kenako dinani batani "Zabwino" pansi pazenera.



4. Zotsatira zakusintha kwa deta, zomwe ndi nambala yaumambala wa nambala yomwe yapatsidwa, imawonetsedwa mu khungu lomwe lidatchulidwa kale.



5. Pakuwerengera manambala ena onse omwe atchulidwa patebulopo, timatsata fomula pogwiritsa ntchito chikhomo, chimodzimodzi ndi nthawi yapita. Monga mukuwonera, zotsatira za kuwerengera kuchuluka kwa manambala zikuwonekera m'maselo, zomwe zikutanthauza kuti ntchitoyi yakwaniritsidwa.

Phunziro: Ntchito zina za masamu ku Excel

Ntchito yogwirira ntchito LOG mu Excel limakupatsani mwayi kuwerengera mwachangu komanso mosavuta kuchuluka kwa nambala yodziwika pamaziko omwe mwapatsidwa. Wogwiritsa ntchito yemweyo amatha kuwerengetsanso logarithm, koma pazifukwa zomwe akuwonetsa zimakhala zomveka kugwiritsa ntchito ntchitoyo LOG10.