Pakati pa ogwira ntchito osiyanasiyana a Excel, ntchitoyi imadziwika kuti ili ndi mphamvu. OSTAT. Zimakupatsani inu kuti muwonetsere mu selo yeniyeniyiyi nambala yotsala imodzi yogawanika ndi ina. Tiyeni tiphunzire zambiri za momwe ntchitoyi ingagwiritsidwire ntchito pochita, komanso fotokozani maonekedwe omwe amagwira nawo ntchito.
Ntchito yogwiritsira ntchito
Dzina la ntchitoyi limachokera ku dzina lofupikitsa la mawu akuti "otsala a magawano." Wogwiritsira ntchito, yemwe ali m'gulu la masamu, amakulolani kuti muwonetse gawo lotsalira la zotsatira za kugawa manambala mu selo losankhidwa. Pa nthawi yomweyo, gawo lonse la zotsatira silinenedwe. Ngati magawowa amagwiritsira ntchito ziwerengero za chiwerengero ndi chizindikiro cholakwika, ndiye zotsatira za kusinthidwa zidzasonyezedwa ndi chizindikiro chomwe wogawayo anali nacho. Chidule cha mawu awa ndi awa:
= OST (nambala; wotsogolera)
Monga mukuonera, mawuwa ali ndi zifukwa ziwiri zokha. "Nambala" ndigawikanitsa wolembedwa muzinthu zamatsenga. Mtsutso wachiwiri ndi wopereka malangizo, monganso umboni wake. Ndi yomalizira mwa iwo omwe amatsimikizira chizindikiro chomwe zotsatira za processing zidzabwezeretsedwa. Zokangana zingakhale zowerengeka zamakono kapena mafotokozedwe a maselo omwe ali nawo.
Taganizirani njira zingapo zomwe mungayambitsire mawu ndi zotsatira zagawani:
- Mawu oyambirira
= REMA (5; 3)Zotsatira zake: 2.
- Mawu oyambirira:
= OSTAT (-5; 3)Zotsatira zake: 2 (popeza wotsogolera ndiwopindulitsa ndithu).
- Mawu oyambirira:
= OSTAT (5; -3)Zotsatira zake: -2 (popeza wotsogolera ndi mtengo wowerengeka).
- Mawu oyambirira:
= OSTAT (6; 3)Zotsatira zake: 0 (kuyambira 6 on 3 adagawidwa popanda zotsalira).
Chitsanzo chogwiritsa ntchito woyendetsa
Tsopano pachitsanzo cha konkire, timalingalira za maonekedwe a ntchitoyi.
- Tsegulani buku la Excel, sankhani selo komwe zotsatira za kusinthidwa kwa deta zidzasonyezedwe, ndipo dinani pazithunzi. "Ikani ntchito"adayikidwa pafupi ndi bar.
- Kuchita kumachitidwa Oyang'anira ntchito. Pitani ku gawo "Masamu" kapena "Mndandanda wathunthu wa alfabeti". Sankhani dzina "OSTAT". Sankhani ndipo dinani pa batani. "Chabwino"anaika pansi theka la zenera.
- Fesholo yotsutsana ikuyamba. Ilo liri ndi magawo awiri omwe akugwirizana ndi zomwe tanena pamwambapa. Kumunda "Nambala" lowetsani mtengo wa chiwerengero umene ungawonongeke. Kumunda "Opatukana" lowetsani mtengo wa chiwerengero chomwe chingawonongeke. Monga zifukwa, mukhoza kutanthauzira maumboni a maselo omwe ali ndi malingaliro omwe alipo. Pambuyo pazidziwitso zonse zafotokozedwa, dinani pa batani "Chabwino".
- Pambuyo pochitapo kanthu kotsiriza, zotsatira za kusungidwa kwa deta ndi woyendetsa, ndiko kuti, magawo otsalira a magawo awiri, amasonyezedwa mu selo lomwe tanena mu ndime yoyamba ya bukhu ili.
Phunziro: Excel ntchito wizara
Monga momwe mukuonera, woyendetsa ntchito yophunzira amapangitsa kuti zikhale zophweka kufotokozera magawo otsalira a manambala kukhala selo yoyambirira. Pachifukwa ichi, ndondomekoyi imachitika molingana ndi malamulo omwewo monga ntchito zina za Excel.
