Umsebenzi uyifomula ekhethiweyo kwi-Excel kunye ne- Google AmaSpredishithi okujoliswe ekufezeni izibalo ezithile kwiseli apho ikhona khona.
Umsebenzi weSintax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
Njengazo zonke iifomula, imisebenzi iqala ngophawu olulinganayo ( = ) lulandelwe igama lomsebenzi kunye neengxoxo zalo:
- Igama lomsebenzi lixelela i-Excel ukuba zeziphi izibalo ukwenza;
- Iingxoxo ziqulethwe phakathi kwabazali okanye ngabaxhasi abajikelezayo kwaye uxelele umsebenzi ukuba yeyiphi idatha ekufuneka isetyenziswe kulezo zibalo.
Umzekelo, omnye wemisebenzi esetyenziswa kakhulu kwi-Excel kunye ne-Google AmaSpredishithi ngumsebenzi we- SUM :
= ISUM (iD1: D6)
Kule mzekelo,
- Igama litshela i-Excel ukudibanisa kunye nedatha kwiiseli ezikhethiweyo;
- Umsebenzi (I-D1: D6) idibanisa isiqulatho seselluli D1 ukuya kwi-D6.
ImiSebenzi yokuHlaba kwiiFomula
Ubuncedo bemisebenzi eyakhelwe ngaphakathi ye-Excel inokwandiswa ngokuzalela enye okanye ngaphezulu imisebenzi ngaphakathi komnye umsebenzi kwifom. Imiphumo yemisebenzi yokuhlamba ivumela ukubala ezininzi ukuba kwenzeke kwiseli enye yomsebenzi.
Ukwenza oku, umsebenzi odibeneyo usebenza njengenye yeengxoxo malunga nomsebenzi oyintloko okanye ongaphandle.
Ngokomzekelo, kule fomyula elandelayo, umsebenzi we- SUM udibene ngaphakathi komsebenzi we-ROUND .
Oku kufezwa ngokusebenzisa umsebenzi we-SUM njengengqinamba yenombolo yomsebenzi we-ROUND.
& # 61; ROUND (SUM (D1: D6), 2)
Xa uvavanya imisebenzi ephakamileyo, i-Excel yenza inzulu, okanye ingaphakathi, isebenze kuqala kwaye isebenze indlela yayo ngaphandle. Ngenxa yoko, ifom yangasentla iya kuba:
- fumana ixabiso lemali kwiiseli D1 ukuya kwi-D6;
- ukujikeleza kwesi sibalo kwiindawo ezimbini zokugqibela.
Ukususela kwi-Excel 2007, kumanqanaba angama-64 yemisebenzi enesidima avunyelwe. Kwiinguqu ngaphambi koku, amazinga angama-7 emisebenzi enesidima avunyelwe.
Iphepha lokusebenzela ngokubhekiselele kwiMisebenzi yoMsebenzi
Kukho iinkalo ezimbini zemisebenzi kwi-Excel kunye ne-Google AmaSpredishithi:
- ImiSebenzi yokuSebenza
- Imisebenzi okanye iMisebenzi echaziweyo yomsebenzisi
ImiSebenzi yeeWebhu yilabo abakholelwa kwiprogram, njengemisebenzi ye-SUM kunye ne-ROUND exoxwe ngentla.
Imisebenzi eyenziwa ngokwezifiso, ngakolunye uhlangothi imisebenzi ibhaliweyo, okanye ichazwe , ngumsebenzisi.
Kwi-Excel, imisebenzi yesiko ibhaliwe kwilwimi yokwakha eyakhelwe ngaphakathi: I- Visual Basic yeZicelo okanye i-VBA efutshane. Imisebenzi yenziwa ngokusebenzisa umhleli weVisual Basic ekhompyutheni yonjiniyela yebhanethi .
Imisebenzi yesiko ye-Google yeStats ibhaliwe kwiSkripthi seZ Apps - ifomu yeJavaScript - kwaye idalwa ngokusebenzisa umhleli weskripthi ephantsi kweMenyu yamathuluzi.
Imisebenzi eyenziwa ngokwezifiso ngokuqhelekileyo, kodwa kungekho rhoqo, yamkela uhlobo oluthile lokufakelwa kwedatha kwaye ubuyisela umphumo kwiseli apho ikhona khona.
Ngezantsi umzekelo womsebenzi ochazwe ngumsebenzisi obala umthengi izaphulelo ezibhalwa kwi-VBA khowudi. Imisebenzi yokuqala ichazwe ngumsebenzisi, okanye iDF ishicilelwe kwiwebhusayithi yeMicrosoft:
Isaphulelo semisebenzi (ubuninzi, intengo)
Ukuba ubuninzi> = 100 Emva koko
Isaphulelo = ubuninzi * intengo * 0.1
Eminye
Discount = 0
Ukuphela Ukuba
Isaphulelo = Isicelo.Iziphumo (Ixabiso, i-2)
Qeda Umsebenzi
Imida
Kwi-Excel, imisebenzi echazwe ngumsebenzisi inokubuyisela kuphela ixabiso kwiiseli apho zifumaneka khona. Ngokwenza njalo, abakwazi ukuqhuba imiyalelo yokuba nayiphi na indlela iguqula indawo yokusebenza ye-Excel - njengokuguqula okuqukethwe okanye ukufometha kweseli.
Isiseko solwazi seMicrosoft si dwelisa imida elandelayo yemisebenzi echazwe ngumsebenzisi:
- Ukufaka, ukususa okanye ukufometha iiseli kwiphepha lokusebenzela;
- Ukutshintsha ixabiso leenkcukacha kwelinye iseli;
- Ukuhamba, ukuqamba kabusha, ukususa, okanye ukufaka amashidi kwincwadi yokusebenzela ;
- Ukutshintsha nayiphi na indawo enokukhetha - njengemodi yokubala okanye ukubukwa kwesikrini;
- Ukubeka iipropati okanye ukuqhuba ezininzi iindlela.
Imisebenzi echaziweyo yomsebenzisi kunye neMacros kwi-Excel
Ngelixa i-Google AmaSpredishithi engabancediyo ngoku, kwi-Excel, i-macro yinkalo yamanyathelo aqoshiwe awenza imisebenzi ephindaphindiweyo yomsebenzi - njengokufomatha idatha okanye ukukopisha kunye nokunamathisela imisebenzi - ngokuxelisa iinqununu okanye izenzo ze mouse.
Nangona bobabini basebenzisa ulwimi lwe-Microsoft lwe-VBA ulwimi, bahluke ngeendlela ezimbini:
- I-UDF yenza izibalo ngelixa i-macros yenza izenzo. Njengoko kukhankanywe ngasentla, iDF ayikwazi ukwenza imisebenzi echaphazela imeko yendalo ngexesha i-macros inakho.
- KwiWindows Visitor Basic window, ezi zimbini ziyahlukana ngenxa yokuba:
- I-UDF iqale ngeSatifikethi soMsebenzi kwaye iphele ngoSebenzi Lokugqibela ;
- I-Macros iqala ngesitatimende esisezantsi kwaye iphele nge- Sub Sub .