Enye yezenzo ezifunwayo zezibalo ekuxazululeni izinkinga zemfundo nezisebenzayo ukuthola i-logarithm evela kwinamba enikezwe ngesisekelo. E-Excel, ukwenza lo msebenzi, kunomsebenzi okhethekile obizwa nge-LOG. Ake sifunde kabanzi ukuthi kungenziwa kanjani.
Kusetshenziswa isitatimende se-LOG
Umsebenzi I-LOG kungokwesigaba semisebenzi yezibalo. Umsebenzi wawo ukubala i-logarithm yenombolo ebekiwe yesisekelo esinikeziwe. I-syntax yenethiwekhi echaziwe ilula kakhulu:
= I-LOG (inombolo; [isisekelo])
Njengoba ukwazi ukubona, umsebenzi unezimpikiswano ezimbili kuphela.
Ukuxabana "Inombolo" imelela inombolo kusuka lapho ukubala i-logarithm. Kungathatha isimo senani lezinombolo futhi kube yinkomba kuseli eliqukethe.
Ukuxabana "Isisekelo" imele isisekelo lapho i-logarithm izobalwa khona. Futhi ingaba nefomu lezinombolo noma isebenze njengesixhumanisi seseli. Le ngxabano iyakhethwa. Uma kushiyiwe, khona-ke kubhekwa ukuthi isisekelo ngu-zero.
Ngaphezu kwalokho, ku-Excel kukhona omunye umsebenzi okuvumela ukuthi ubale ama-logarithms - I-LOG10. Umehluko wayo oyinhloko kusuka kwangaphambilini ukuthi ungabala ama-logarithms kuphela ngesisekelo se 10, okungukuthi, ama-logarithms wokugcina kuphela. I-syntax yayo ilula kakhulu kunesitatimende eswethulwe ngaphambili:
= LOG10 (inombolo)
Njengoba ubona, ukuphela kwengxabano kulo msebenzi "Inombolo", okungukuthi, inani lezinombolo noma ireferensi kuseli elikuyo. Ngokungafani no-opharetha I-LOG lo msebenzi unempikiswano "Isisekelo" ngokuvamile ayikho, ngoba kucatshangwa ukuthi yisisekelo samanani elisebenzayo 10.
Indlela yoku-1: sebenzisa umsebenzi we-LOG
Manje ake sibheke ukusetshenziswa kwe-opharetha I-LOG kwisibonelo sikakhonkolo. Sinekholamu yamanani wokubala. Sidinga ukubala kusuka kubo i-logarithm eyisisekelo 5.
- Sikhetha iseli lokuqala elingenalutho eshidi kwikholamu esihlela ukubonisa imiphumela yalo ekugcineni. Okulandelayo, chofoza isithonjana "Faka umsebenzi", etholakala eduze nomugqa wamafomula.
- Iwindows liqala ukukhuphuka. Umsebenzi Wizards. Siqhubekela esigabeni "Izibalo". Senza ukukhetha "LOG" ohlwini lwabasebenza, bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. I-LOG. Njengoba ubona, inezindima ezimbili ezihambelana nokuphikisana kwalokhu ku-opharetha.
Ensimini "Inombolo" kithi, faka ikheli leseli lokuqala lekholamu lapho kutholakala khona idatha yomthombo. Lokhu kungenziwa ngokukufaka ensimini ngesandla. Kepha kunendlela elula. Setha ikhesa kwinkambu echaziwe, bese uchofoza kwesobunxele esitokisini setafula eliqukethe inani lokufisela elifunekayo. Izixhumanisi zalesi seli ziboniswa ngokushesha emkhakheni "Inombolo".
Ensimini "Isisekelo" vele ufake inani "5", ngoba kuzoba okufanayo kulo lonke uchungechunge lwezinombolo olucubunguliwe.
Ngemuva kokwenza lokhu kukhwabanisa, chofoza inkinobho "Kulungile".
- Umphumela Womsebenzi I-LOG Iyakhonjiswa ngokushesha esitokisini esikuchazile esinyathelweni sokuqala salo myalo.
- Kepha sagcwalisa iseli lokuqala lekholamu. Ukuze ugcwalise okuseleyo, udinga ukukopisha ifomula. Setha ikhesa ekhoneni elingezansi kweseli eliqukethe. Umaka wokugcwalisa uvela, omelelwa njengesiphambano. Shaya inkinobho yegundane kwesobunxele bese udonsela isiphambano ekugcineni kwekholamu.
- Inqubo engenhla yabangela wonke amaseli kukholamu "Logarithm" kugcwele ngomphumela wokubala. Iqiniso ngukuthi isixhumanisi sikhonjisiwe enkundleni "Inombolo"isihlobo. Uma udlula kumaseli, nayo iyashintsha.
Isifundo: I-Excel Feature Wizard
Indlela 2: sebenzisa umsebenzi we-LOG10
Manje ake sibheke isibonelo ngokusebenzisa opharetha I-LOG10. Ukwenza isibonelo sizothatha itafula nedatha yokuqala efanayo. Kepha manje, kusobala, umsebenzi ukubala i-logarithm yezinombolo ezitholakala kwikholamu "Idatha yomthombo" ngesisekelo se 10 (i-logarithm yedesimali).
- Khetha iseli lokuqala elingenalutho lekholamu "Logarithm" bese uchofoza isithonjana "Faka umsebenzi".
- Ewindini elivulayo Umsebenzi Wizards iya esigabeni futhi "Izibalo"kepha kulokhu simisa egameni "I-LOG10". Chofoza inkinobho ezansi kwewindi "Kulungile".
- Iwindi lokuphikisana ngomsebenzi lisebenza I-LOG10. Njengoba ubona, inenkambu eyodwa kuphela - "Inombolo". Faka ikheli leseli lokuqala kukholamu "Idatha yomthombo", ngendlela efanayo naleso sasisebenzisa esibonelweni esedlule. Bese uchofoza inkinobho "Kulungile" phansi kwewindi.
- Umphumela wokucubungula idatha, okuyi-logarithm yedesimali yenombolo enikeziwe, uboniswa kuseli elicacisiwe ngaphambili.
- Ukuze senze izibalo zazo zonke ezinye izinombolo ezethulwe etafuleni, sikopisha ifomula usebenzisa umaki wokugcwalisa, ngendlela efanayo nesikhathi esedlule. Njengoba ukwazi ukubona, imiphumela yokubala ama-logarithms ezinombolo ayaboniswa kumaseli, okusho ukuthi umsebenzi usuqediwe.
Isifundo: Eminye imisebenzi yezibalo ku-Excel
Isicelo somsebenzi I-LOG ku-Excel kukuvumela ukubala ngokushesha nangobunzima i-logarithm yenombolo ethile ebekiwe ngesisekelo esinikeziwe. U-opharetha ofanayo angakwazi nokubala i-logarithm yedesimali, kepha ngezinhloso ezikhonjisiwe kunengqondo ukusebenzisa umsebenzi I-LOG10.
