Uthini umahluko phakathi kwefomula kunye nomsebenzi kwi-Excel?

Excel Sesinye sezona zicelo zidumileyo kwihlabathi, zisebenza kakhulu kusetyenziso lobuchwephesha kunye nobuqu. Isixhobo esilula kodwa esinamandla sokuphatha isixa esikhulu sedatha, ngokulula nangokukhawuleza. Ngokusengqiqweni, ukufumana eyona ntsebenzo ibalaseleyo kwesi sixhobo, kubalulekile ukuba uyazi kakuhle. Oku kuya kusivumela, umzekelo, ukwazi ukuba yintoni na umahluko phakathi kwefomula kunye nomsebenzi kwi-excel, phakathi kwezinye izinto.

Kwaye kukuba, ngaphandle kwamathandabuzo, enye yeengongoma ezinamandla zale nkqubo kukuba ivumela ukuba senze iifomyula apho siphatha idatha eninzi ngexesha elinye kwaye sifumane zonke iintlobo zeziphumo. Oku kubaluleke kakhulu kwiinkampani, nokuba zingamashishini amancinci, xa kuziwa ekulawuleni uluhlu lwempahla, izivumelwano zorhwebo, ii-invoyisi okanye ukuhlawula abasebenzi. Iifomula ze-Excel kunye nokubala zisinceda ukuba khawulezisa umsebenzi.

Ukuqonda kakuhle ukuba yintoni na umahluko phakathi kwefomula kunye nomsebenzi kwi-excelInto yokuqala ekufuneka icace ngayo kukuba zombini iikhonsepthi zinxibelelene ngokusondeleyo. Kangangokuba kunokuthiwa ziyafana. Imisebenzi iifomyula ezichazwe kwangaphambili ezidityanisiweyo kwiprogram kwaye zibizwa ngolu hlobo kuba kunokutolikwa ukuba ziyingxenye yemisebenzi okanye "iinkonzo" ezinikezelwa yi-Excel ukuze silondoloze ixesha.

Koku kungasentla kunokuqondwa ukuba igama elithi "ifomula" kufuneka lisetyenziswe kuzo zonke iifomyula, oko kukuthi, ezo zingachazwanga kwangaphambili, kodwa zenziwe ngabasebenzisi ngokwezinto abazithandayo kunye neemfuno ngamaxesha onke. Umahluko unobuqili, kodwa ubalulekile.

Yintoni ifomula yase-Excel?

Ifomyula ye-Excel ayikho into engaphezu kwe-a ikhowudi yeesimboli kunye namanani angeniswa kwiseli. Isimboli ngasinye sinentsingiselo kunye nomsebenzi. Kwaye zonke kunye zilungelelanisa ukuya yenza ubalo oluthile esisiphumo siyakubonakaliswa kwiseli ngokwayo.

Zonke iifomyula ze-Excel kufuneka ziqale ngesimboli esilinganayo (=). I-syntax ibalulekile. Yonke into mayibhalwe ngokulandela umyalelo ofunekayo. Isimboli "=" kufuneka ilandelwe ngumsebenzi okanye ubalo ofuna ukulwenza kwaye oku ziiseli ofuna ukwenza ubalo kuzo. Siyizekelisa ngayo umzekelo olula:

Apha umsebenzi we "Sum" usetyenziselwe ukubala inani lexabiso leeseli ezintathu (B4, C4 kunye ne-D4) ukuze iziphumo zivele kwiseli E4. Xa sijonga nje kuqala siyabona ukuba isixa sika 200 + 300 + 300 siyakusinika isiphumo sama 800. Kule meko, kufuneka siye kwiseli yesiphumo kwaye sibhale oku kulandelayo:

=USUM(B4:D4)

Ngokwenyani, kuba ingumsebenzi ongagqibekanga, awuyi kufuna ukubhala i-SUM, ngokulula nje khetha umsebenzi kwibar yesixhobo. Ukukhetha iiseli eziqulathe amaxabiso okongeza (ezo zaziwa ngokuba "ziingxabano"), sinokusebenzisa imouse. Emva koko, kufuneka sicinezele u-Enter okanye uqinisekise ifomula ukuze isetyenziswe.

Xa uthi krwaqu nje, kunokubonakala kungeyomfuneko ukusebenzisa ifomula yolo tyando lulula, nangona kunjalo, ukusetyenziswa kwayo kuyenzeka ngendlela engakholelekiyo xa kufuneka sijongane nespredishithi ezinde kakhulu kunye namakhulu, okanye amawaka, iiseli ekunokufakwa kuzo izibalo. nzima ngakumbi.

Uninzi lwemisebenzi ye-Excel esetyenziswayo

Okulandelayo, uluhlu lweyona misebenzi isetyenziswa kakhulu ye-Excel, iodolwe ngokweendidi. Asingabo bonke, nangona abona babalulekileyo benjalo. Konobumba abakhulu, okubhaliweyo okuhamba kanye emva kophawu "=" naphambi kweempikiswano:

Khangela kunye nereferensi

• KHANGELA: Khangela amaxabiso oluhlu lomqolo okanye umqolo.
• HLOOKUP: Phendla kumqolo wokuqala wetheyibhile okanye uluhlu lwamaxabiso.
• VLOOKUP: Khangela ixabiso kuluhlu lokuqala ukusuka ekhohlo kwetafile.
• IKHOLAM: Isinika inombolo yekholamu yereferensi.
• KHETHA: Khetha ixabiso kuluhlu olusekwe kwinani lesalathiso.
• UROW: Ibuyisela inombolo yomqolo yereferensi.
• I-HYPERLINK: Yenza indlela emfutshane kuxwebhu olugcinwe kwi-hard drive okanye kwi-Intanethi.
• TRANSPOSE: Ibuyisela uluhlu oluthe nkqo lweeseli njengoluhlu oluthe tye, kwaye ngokuphendululekileyo.

Umbhalo

• CONCATENATE: Dibanisa amanqaku aliqela okubhaliweyo kwinto enye.
• FUMANA: Ibuyisela indawo yokuqala kumtya wokubhaliweyo.
• IZITHUBA. Ikhupha zonke izithuba kumbhalo, ngaphandle kwezo ziphakathi kwamagama.
• PHEZULU: Utshintsha umtya wokubhaliweyo ube ngonobumba abakhulu.
• PHANTSI: Utshintshwa bonke oonobumba ukusuka kwelinye ukuya kwelincinane.
• IMALI: Itshintsha inombolo ebhalwe ngohlobo lwemali.
• VALUE: Itshintsha ingxabano yokubhaliweyo emele inani libe linani lokwenyani.

Database

• I-BDDESVEST: Ibala ukutenxa okusemgangathweni kwesiseko sedatha.
• I-BDEXTRAER: Ikhupha irekhodi enye ehambelana neemeko ezichaziweyo kwisiseko sedatha.
• DPRODUCT: Uphinda-phinda amaxabiso kumqolo ohambelana neemeko ezikhankanyiweyo.
• UDAVERAGE: Bala umndilili wamaxabiso kuluhlu okanye uluhlu okanye isiseko phantsi kweemeko ezithile.

IMathematika

• QUOTIENT: Kubalwa inani elipheleleyo lecandelo.
• UHLANGANISA: Ubonisa inani leendibaniselwano kunye nophinda-phindo lwenani elithile lezinto.
• INTEGER: Jikela inani kwinani elikufutshane elisezantsi.
• EXP: Ibala inani elinyuswe kumandla athile.
• LN: Ibala i-logarithm yendalo yenani.
• I-LOG: Ibala i-logarithm yenani ukuya kwisiseko esikhankanyiweyo.
• I-GCD: Bala eyona nto ixhaphakileyo.
• I-LCM: Bala ezona zininzi zixhaphakileyo.
• INUMERO.ARABE: Utshintsha amanani esiRoma ukuya kwisiArabhu.
• I-ROMAN.INOMBOLO: Kungenjalo, tshintsha iinombolo zesiArabhu zibe ngamanani aseRoma (kwifomathi yombhalo).
• PRODUCT: Uphinda-phinda onke amanani achazwe njengeengxabano.
• Ingcambu: Kubalwa ingcambu yenani.
• I-SUM: Yongeza onke amanani kuluhlu lweeseli (ngumsebenzi esiwubonileyo kumzekelo).

imisebenzi yezemali

• AMORTIZ.LIN: Ibala i-amortization yexesha ngalinye lobalo.
• I-AMORTIZ.PROGRE: Ibala i-amortization yexesha ngalinye lobalo kusetyenziswa i-amortization coefficient ethile.
• I-INT.ACCUM: Ibala inzala eyongeziweyo yesibambiso esihlawula inzala ngamaxesha athile.
• INT.ACC.V: Ibala inzala efunyenweyo kwisibambiso esihlawula inzala ekuvuthweni.
• I-INT ESEBENZAYO: Ibala umyinge wenzala wonyaka osebenzayo.
• ISIVUNO: Ibala isivuno sesibambiso esifumana inzala ngamaxesha athile.
• UMLINGANISO. Ubala umlinganiselo wenzala wonyaka.
• IRR: Ibala umlinganiselo wangaphakathi wembuyekezo yotyalo-mali.

Isimo

• I-STDEV.M: Ibala ukutenxa okusemgangathweni kwesampulu enikiweyo.
• UMGCA WOKUQALA: Kubalwa izibalo ezichaza indlela yomgca edibana neendawo ezaziwayo zedatha.
• ULOGST
• IFREQUENCY: Bala ukuphindaphinda apho ixabiso lenzeka phakathi koluhlu.
• I-BoundedMean: Ibala intsingiselo yesahlulo sangaphakathi seseti yamaxabiso edatha.
• MEDIAN: Bala inani eliphakathi okanye eliphakathi kwiseti yamanani.
• IMODE. ONE: Ibala elona xabiso lixhaphakileyo okanye eliphinda-phindayo loluhlu lwedatha.
• I-AVERAGE: Bala umndilili (i-arithmetic mean) yeengxoxo.