Sibala lowo muntu nge-ID VKontakte

Enye yamathuluzi amakhulu okuhlaziywa kwezibalo ukubalwa kokuphambuka okujwayelekile. Le nkhomba ikuvumela ukuba wenze ukulinganisa okujwayelekile kwesampula noma inani labantu. Masifunde indlela yokusebenzisa ifomula yokunquma ukuphambuka okujwayelekile ku-Excel.

Ukunqunywa kokuphambuka okujwayelekile

Masinyane thola ukuthi yini okushiwo ukuphambana okujwayelekile nokuthi ifomula yayo ibonakala kanjani. Le nzuzo ingumsuka wesigcawu senombolo yesilinganiso se-arithmetic yezikwele zokwahlukana kwazo zonke izindinganiso zochungechunge kanye nesilinganiso sabo se-arithmetic. Kukhona igama elifanayo lenkomba - ukuphambuka okujwayelekile. Womabili amagama alingana ncamashi.

Kodwa, ngokwemvelo, ku-Excel, umsebenzisi akudingeki ukubala, ngoba uhlelo lwenza konke kuye. Ake sifunde ukuthilala ukuphambuka okujwayelekile ku-Excel.

Ukubalwa ku-Excel

Bala inani elibekiwe ku-Excel usebenzisa imisebenzi emibili ekhethekile I-STANDOWCLON.V (ngesampula) futhi STANDOCLON.G (ngokusho komphakathi jikelele). Isimiso sokusebenza kwabo sinjalo, kodwa singabangela ngezindlela ezintathu, esizoxoxa ngezansi.

Indlela 1: Imisebenzi Yomsebenzi

1. Khetha iseli kushidi lapho umphumela ophelile uzoboniswa khona. Chofoza inkinobho "Faka umsebenzi"ngakwesokunxele komsebenzi womsebenzi.



2. Kulolu hlu oluvulekayo, bheka irekhodi. I-STANDOWCLON.V noma STANDOCLON.G. Uhlu lubuye lube nomsebenzi STANDOWCLONEkodwa kushiyelwe kunguqulo zangaphambilini ze-Excel ngezizathu zokuhambisana. Ngemva kokungena kukhethiwe, chofoza inkinobho. "Kulungile".



3. Iwindi lempikiswano yokusebenza ivula. Ensimini ngayinye, faka inani labantu. Uma izinombolo zingaphakathi kwamaseli eshidi, ungacacisa izixhumanisi zala maseli noma mane uchofoze kuzo. Amakheli abonakala ngokushesha emasimini afanelekile. Ngemuva kokuthi zonke izinombolo zihlanganisiwe, chofoza inkinobho "Kulungile".



4. Umphumela wokubala uzoboniswa esitokisini okhethiwe ekuqaleni kwenqubo yokuthola ukuphambana okujwayelekile.

Indlela 2: Ifomula ithebhu

Ungakwazi futhi ukubala ukubaluleka okujwayelekile ngaphakathi kwethebhu "Amafomula".

1. Khetha iseli ukubonisa umphumela bese uya kuthebhu "Amafomula".



2. Ebhokisini lamathuluzi "I-Function Library" cindezela inkinobho "Iminye imisebenzi". Kusukela kuhlu oluvela, khetha into "Isitatimende". Emenyu elandelayo senza ukukhetha phakathi kwamagugu. I-STANDOWCLON.V noma STANDOCLON.G kuye ngokuthi ngabe isampuli noma umphakathi jikelele uthatha ingxenye ekubaleni.



3. Emva kwalokho, iwindi lezingxoxo liqala. Zonke izenzo ezengeziwe kufanele zenziwe ngendlela efanayo nakwehlukile kokuqala.

Indlela 3: Ukungena kwe-Formula Yomqulu

Kukhona futhi indlela ongadingeki ngayo ukubiza ifasitela lokuphikisana nhlobo. Ukwenza lokhu, faka ifomula ngesandla.

1. Khetha iseli ukubonisa umphumela bese usetha inkulumo kuwo noma kubha yefomula usebenzisa iphethini elilandelayo:

   = STDEVRAG.G (inombolo1 (cell_address1); inombolo2 (cell_address2); ...)
   noma
   = STDEVA.V (inombolo1 (cell_address1); inombolo2 (cell_address2); ...).

   Uma kunesidingo, ungabhala kuze kube ngu-255 izingxabano uma kunesidingo.



2. Emva kokungeniswa kwenziwa, chofoza inkinobho. Ngena kwikhibhodi.

Isifundo: Sebenzisa ngamafomula ku-Excel

Njengoba ubona, indlela yokubala ukuphambuka okujwayelekile e-Excel ilula kakhulu. Umsebenzisi udinga kuphela ukufaka izinamba kusuka kubantu noma izixhumanisi eziya kumaseli anakho. Zonke izibalo zenzelwa uhlelo ngokwayo. Kunzima kakhulu ukuqonda ukuthi yini isibonakaliso esibalwayo nokuthi imiphumela yesibalo ingasetshenziswa kanjani ekusebenzeni. Kodwa ukuqonda lokhu kuhloswe kakade emkhakheni wezibalo kunokufunda ukuthi ungasebenza kanjani nesofthiwe.