Timawerengera munthuyo ndi ID VKontakte

Chimodzi mwa zida zazikulu zowonetsera ziwerengero ndi kuyerekezera kwa kusokonekera koyenera. Chizindikiro ichi chimakulolani inu kuti muyese kulingalira kwa kutayika kwenikweni kwa chitsanzo kapena kwa chiwerengero cha anthu. Tiyeni tiphunzire momwe tingagwiritsire ntchito ndondomeko kuti tipeze kutengeka koyenera mu Excel.

Kutsimikiza kwa kusemphana kwake

Mwamsanga mudziwe chomwe chimapanga zolephereka ndi momwe mawonekedwe ake amawonekera. Mtengo uwu ndi mizu yachindunji ya masamu owerengeka a masitepe a kusiyana kwa zikhalidwe zonse za mndandanda ndi chiwerengero chawo cha masamu. Palinso dzina lofanana la chiwonetserochi - kutayika kumodzi. Maina onsewa ndi ofanana.

Koma, mwachibadwa, mu Excel, wogwiritsa ntchito sayenera kuwerengera, popeza pulogalamuyo imamuchitira zonse. Tiyeni tiphunzire momwe tingawerengere kutengeka koyenera mu Excel.

Kuwerengera mu Excel

Lembani mtengo wotchulidwa mu Excel pogwiritsa ntchito ntchito ziwiri zapadera STANDOWCLON.V (mwa chitsanzo) ndi STANDOCLON.G (malinga ndi anthu ambiri). Mfundo ya ntchito yawo ndi yofanana, koma ingayambitsidwe m'njira zitatu, zomwe tidzakambirana pansipa.

Njira 1: Ntchito Zapamwamba

1. Sankhani selo pa pepala pomwe zotsatira zomaliza ziwonetsedwa. Dinani pa batani "Ikani ntchito"kumanzere kwa mzere wa ntchito.



2. M'ndandanda imene imatsegula, yang'anani mbiri. STANDOWCLON.V kapena STANDOCLON.G. Mndandandawu uli ndi ntchito STANDOWCLONEkoma zatsalira kuchokera kumasulira akale a Excel chifukwa chogwirizana. Pambuyo polowetsedwa, dinani pa batani. "Chabwino".



3. Ntchito yotsutsana yenera ikutsegula. M'munda uliwonse, lowetsani chiŵerengero cha anthu. Ngati nambalayi ili m'maselo a pepala, mungathe kufotokoza makonzedwe a maselowa kapena kungowanikiza pa iwo. Madilesi amasonyezedwa nthawi yomweyo m'madera oyenera. Pambuyo pa manambala onsewa, lowani pa batani "Chabwino".



4. Chotsatira cha kuwerengera chidzawonetsedwa mu selo yomwe idasankhidwa kumayambiriro kwa njirayi kuti mupeze kupotoka kwabwino.

Njira 2: Mafomu a Mafomu

Mukhozanso kuwerengera mtengo wa kupotola kwadongosolo kupyolera pa tabu "Maonekedwe".

1. Sankhani selo kusonyeza zotsatira ndikupita ku tabu "Maonekedwe".



2. M'kati mwa zipangizo "Laibulale ya Ntchito" pressani batani "Ntchito Zina". Kuchokera pandandanda imene ikuwonekera, sankhani chinthucho "Zotsatira". M'ndandanda yotsatira timasankha pakati pa mfundo. STANDOWCLON.V kapena STANDOCLON.G malingana ndi momwe chitsanzocho kapena anthu ambiri amathandizira kuwerengera.



3. Pambuyo pake, zenera zotsutsa zimayamba. Zochitika zina zonse ziyenera kuchitidwa mofanana ndi poyamba.

Njira 3: Kulembera Malemba Olowa

Palinso njira imene simukusowa kuyitanira zenera. Kuti muchite izi, lowetsani ndondomekoyi pamanja.

1. Sankhani selo kuti muwonetse zotsatirazo ndi kuyika mawu mmenemo kapena mu bar barula pogwiritsa ntchito njira yotsatirayi:

   = STDEVRAG.G (number1 (cell_address1); nambala2 (cell_address2); ...)
   kapena
   = STDEVA.V (nambala1 (selo_address1); nambala2 (cell_address2); ...).

   Ngati ndi kotheka, mukhoza kulembera zokwana 255 ngati mukufunikira.



2. Pambuyo polowera, dinani pakani. Lowani pabokosi.

Phunziro: Gwiritsani ntchito mayina mu Excel

Monga mukuonera, njira yokhalira kuperewera mu Excel ndi yophweka. Wogwiritsa ntchitoyo akungoyenera kuitanitsa manambala kuchokera kwa anthu kapena maulumikilo kwa maselo omwe ali nawo. Kuwerengera konse kumachitidwa ndi pulogalamu yokha. Zimakhala zovuta kwambiri kumvetsetsa chomwe chiwerengerochi chimawerengedwa ndi momwe zotsatira za chiwerengerocho zingagwiritsidwe ntchito. Koma kumvetsetsa izi kumagwirizana kwambiri ndi chiwerengero cha ziwerengero kusiyana ndi kuphunzira momwe mungagwiritsire ntchito ndi mapulogalamu.