Umsebenzi we-LOG ku-Microsoft Excel

Omunye wemisebenzi ethandwa kakhulu yezibalo ekuxazululeni izinkinga zemfundo nezingokoqobo ukuthola i-logarithm yenombolo enikeziwe ngesisekelo. Ku-Excel, ukwenza lo msebenzi, kunomsebenzi okhethekile okuthiwa i-LOG. Masifunde ngokuningiliziwe ukuthi singasetshenziswa kanjani ekusebenzeni.

Ukusebenzisa isitatimende se-LOG

I-Operator LOG kungokwesigaba semisebenzi yezibalo. Umsebenzi wakhe ukubala i-logarithm yenombolo ecacisiwe yesisekelo esinikeziwe. I-syntax yomqhubi ocacisiwe ilula kakhulu:

= LOG (inombolo; [isisekelo]

Njengoba ungabona, umsebenzi unemibono emibili kuphela.

Ukuphikisana "Inombolo" iyinombolo okumele uyibale ngayo i-logarithm. Kungathatha ifomu lenani lezinombolo bese libhekisela kuseli eliqukethe.

Ukuphikisana "Isisekelo" limelela isisekelo esizobalwa ngalo logarithm. Kungaba nakho, njengefomu lezinombolo, bese wenza njengereferensi yeseli. Le mpikiswano iyakhethwa. Uma kungenqatshiwe, khona-ke isisekelo sithathwa njengezero.

Ngaphezu kwalokho, ku-Excel kunomunye umsebenzi ovumela ukuthi ubale i-logarithms - LOG10. Umehluko walo omkhulu owedlule wukuthi ungabala ama-logarithms kuphela ngesisekelo 10, okungukuthi, ama-logarithms kuphela. I-syntax yayo ilula ngisho nesitatimende esinikezwe ngaphambilini:

= LOG10 (inombolo)

Njengoba ungabona, ukuphikisana kuphela kwalokhu msebenzi kuwukuthi "Inombolo", okungukuthi, inani lezinombolo noma ukubhekisela kweseli lapho litholakala khona. Ngokungafani no-opharetha LOG lo msebenzi unenkinga "Isisekelo" engekho ngokuphelele, ngoba kucatshangwa ukuthi isisekelo samanani asebenzayo silingana 10.

Indlela 1: sebenzisa umsebenzi we-LOG

Manje ake sicabangele ukusetshenziswa komsebenzisi LOG ngesibonelo esithile. Sinekholomu yamanani wezinombolo. Sidinga ukubala i-logarithm yesisekelo sabo. 5.

1. Senza ukukhethwa kweseli yokuqala engenalutho kushidi kukholomu esilungiselela ukubonisa umphumela wokugcina. Okulandelayo, chofoza isithonjana "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.



2. Ifasitela iqala. Amakhosi omsebenzi. Hambisa kusigaba "Isibalo". Yenza ukukhethwa kwegama "LOG" ohlwini lwabo opharetha, bese uchofoza inkinobho "Kulungile".



3. I-window ye-arguments function iqala. LOG. Njengoba ubona, kunemikhakha emibili ehambelana nemibono yalokhu opharetha.

   Ensimini "Inombolo" esimweni sethu, faka ikheli leseli yokuqala yekholomu lapho idatha yomthombo ikhona khona. Lokhu kungenziwa ngokuthayipha endle ngesandla. Kodwa kunendlela elula kakhulu. Setha isikhombisi kunsimu ecacisiwe, bese uchofoza inkinobho yesinxele yesinxele esitokisini setafula equkethe inani lamanani esiyidingayo. Izixhumanisi zalesi sese zizovela masinyane ensimini "Inombolo".

   Ensimini "Isisekelo" vele ufake inani "5", ngoba kuzoba okufanayo kulo lonke uchungechunge lwezinombolo olucutshungulwayo.

   Ngemuva kokwenza lezi zindlela zokuchofoza chofoza inkinobho. "Kulungile".



4. Umphumela womsebenzi wokucubungula LOG ngokushesha kuboniswe esitokisini esasibekwe esiteji sokuqala sale myalelo.



5. Kodwa sigcwalise kuphela iseli lokuqala lekholomu. Ukuze ugcwalise okunye, udinga ukukopisha ifomula. Setha isikhombisi ekhoneni elingezansi elingakwesokudla seligcini eliqukethe. Uphawu lokugcwalisa luvela, lunikezwe njengesiphambano. Cisha inkinobho yegundane lesokunxele bese uhudula isiphambano kuze kube sekupheleni kwekholomu.



6. Inqubo engenhla ibangele wonke amaseli kukholomu "I-Logarithm" igcwele umphumela wokubala. Iqiniso liwukuthi isixhumanisi esichazwe ensimini "Inombolo"ihlobene. Uma uhamba phakathi kwamaseli futhi uyashintsha.

Isifundo: I-Excel umsebenzi wizard

Indlela 2: sebenzisa umsebenzi we-LOG10

Manje ake sibheke isibonelo sokusebenzisa opharetha LOG10. Isibonelo, thatha itafula ngedatha efanayo yomthombo. Kodwa manje, ngokuqinisekile, umsebenzi uhlala ukubala i-logarithm yezinombolo ezisekholomu "Isisekelo" ngesisekelo 10 (i-logarithm yedesimali).

1. Khetha iseli lokuqala elingenalutho kukholomu. "I-Logarithm" bese uchofoza isithonjana "Faka umsebenzi".



2. Ewindini evula Amakhosi omsebenzi uphinde wenze ushintsho esigabeni "Isibalo"kodwa manje siyeka igama "LOG10". Chofoza ngezansi kwewindi ku-inkinobho. "Kulungile".



3. Ivuselela iwindi lempikiswano yokusebenza LOG10. Njengoba ungabona, inensimu eyodwa kuphela - "Inombolo". Sifaka kulo ikheli leseli yokuqala yekholomu "Isisekelo", ngendlela efanayo esasisebenzisa esibonelweni sangaphambilini. Bese uchofoza inkinobho. "Kulungile" phansi kwefasitela.



4. Umphumela wokucutshungulwa kwedatha, okungukuthi i-logarithm yedayimali yenombolo enikeziwe, iboniswa kuseli elichaziwe ngaphambilini.



5. Ukuze wenze izinombolo kuzo zonke ezinye izinombolo ezinikezwe etafuleni, senza ikhophi ifomu usebenzisa uphawu lokugcwalisa, ngendlela efanayo nangesikhathi esidlule. Njengoba ungabona, imiphumela yezibalo ze-logarithms yezinombolo iboniswa emajenjini, okusho ukuthi umsebenzi uqediwe.

Isifundo: Ezinye izibalo zisebenza ku-Excel

Uhlelo lokusebenza LOG ivumela ku-Excel kalula futhi ngokushesha ukubala i-logarithm yenombolo ecacisiwe yesisekelo esinikeziwe. Lowo opharetha ofanayo angakwazi futhi ukubala i-logarithm yedesimali, kodwa ngalezi zinhloso kusebenza kahle ukusebenzisa lo msebenzi LOG10.