Pokonza mawerengedwa osiyanasiyana ndikugwira ntchito ndi deta, nthawi zambiri ndikofunikira kuti awerengere mtengo wawo. Amawerengeredwa powonjezera manambala ndikugawa chiwerengerocho pogwiritsa ntchito manambala. Tiyeni tiwone momwe mungawerengere kuchuluka kwa kuchuluka kwa manambala akugwiritsa ntchito Microsoft Excel m'njira zosiyanasiyana.
Njira yokhayo yoyenera kuwerengera
Njira yosavuta komanso yodziwika kwambiri yopezera manambala amatanthauza kugwiritsa ntchito batani lapadera pa riboni la Microsoft Excel. Sankhani manambala omwe ali mgulu kapena mzere wa chikalata. Kukhala mu "Home" tabu, dinani batani la "AutoSum", lomwe lili patsamba lachifumu mu "zida" za "Editing". Kuchokera pamndandanda wotsitsa, sankhani "Avereji".
Pambuyo pake, pogwiritsa ntchito "AVERAGE", kuwerengera kumapangidwa. Kutanthauza kwa masinthidwe a manambala amtunduwu kumaonetsedwa mu khungu pansi pa mzere wosankhidwa, kapena kumanja kwa mzere wosankhidwa.
Njirayi ndi yabwino kuphweka komanso zosavuta. Koma, amakhalanso ndi zovuta zoyipa. Pogwiritsa ntchito njirayi, mutha kuwerengera kuchuluka kwa manambala okhawo omwe ali pamzere umodzi, kapena mzere umodzi. Koma ,okhala ndi maselo ambiri, kapena ndi maselo obalalika papepala, simungathe kugwira ntchito ndi njirayi.
Mwachitsanzo, ngati mungasankhe mizati iwiri ndikuwerengera tanthauzo la masamu m'njira yomwe tafotokozayi, yankho lidzaperekedwa pagawo lililonse padera, osati maselo onse.
Kuwerengera pogwiritsa ntchito Wizard Yogwira Ntchito
Kwa milandu mukafunikira kuwerengera masamu ambiri maselo, kapena maselo osiyana, mutha kugwiritsa ntchito Workiz Wizard. Amagwiritsa ntchito "AVERAGE" yomweyo, yomwe tikudziwa kuyambira njira yoyamba yowerengera, koma imachita mwanjira yosiyana.
Timadulira foni komwe timafuna zotsatira zakuwerengera mtengo wapakati kuti uwonetsedwe. Dinani pa batani la "Insert Function", lomwe lili kumanzere kwa barula ya fomula. Kapena, timalemba pa kiyibodi kuphatikiza kwa Shift + F3.
Ntchito mfiti imayamba. Pamndandanda wazinthu zomwe zaperekedwa, yang'anani "AVERAGE". Sankhani, ndikudina batani "Chabwino".
Yenera kutsutsana pa ntchitoyi kutsegulidwa. Zotsutsana za ntchitoyi zalowetsedwa m'magawo a Nambala. Izi zitha kukhala manambala wamba kapena ma adilesi amaselo komwe manambala amapezeka. Ngati ndizovuta kuti mulowe ma adilesi am'manja pamanja, dinani batani lomwe lili kumanja kwa gawo lolowera deta.
Pambuyo pake, zenera zotsutsa ntchito zidzachepetsedwa, ndipo mutha kusankha gulu la maselo patsamba lomwe mumawerengera. Kenako, dinani batani kumanzere kwa gawo lolowera deta kuti mubwerere ku zenera zotsutsana ndi ntchito.
Ngati mukufuna kuwerengetsa tanthauzo la masamu pakati pa manambala omwe ali m'magulu osiyana a maselo, chitani zomwezo zomwe zatchulidwazi pamunda wa "Nambala 2". Ndi zina zotero mpaka magulu onse ofunikira a maselo amasankhidwa.
Pambuyo pake, dinani batani "Chabwino".
Zotsatira zakuwerengera zamasamu zikuwunikidwa mu khungu lomwe mudasankha musanayambe Ntchito Wizard.
Baramu Wamtundu
Pali njira yachitatu yoyendetsera ntchito ya AVERAGE. Kuti muchite izi, pitani pa tabu ya "Fomula". Sankhani khungu lomwe zotsatira zikuwonetsedwa. Pambuyo pake, pagulu la chida cha "Function Library" pa riboni, dinani batani la "Ntchito Zina". Mndandanda ukuwoneka womwe muyenera kupita motsatana kuzinthu "Statistical" ndi "AVERAGE".
Kenako, zenera lomweli la zothandizira limakhazikitsidwa ngati mugwiritsa ntchito Ntchito Wizard, ntchito yomwe tafotokoza mwatsatanetsatane pamwambapa.
Zochita zina ndizofanana.
Kulowa kwa ntchito
Koma musaiwale kuti nthawi zonse mutha kulowa mu "AVERAGE" pamanja ngati mukufuna. Idzakhala ndi pulogalamu yotsatirayi: "= AVERAGE (cell_range_address (nambala); cell_range_address (nambala)).
Zachidziwikire, njirayi si yabwino monga yapita, ndipo imafunika kuti njira zina zizisungidwa m'maganizo a wogwiritsa ntchito, koma zimasinthasintha.
Kuwerengetsa kwa mtengo wapakati pamlingowo
Kuphatikiza pa kuwerengera kwamtengo wamba, ndikotheka kuwerengera mtengo wapakati malinga ndi momwe zinthu ziliri. Poterepa, manambala okhawo amene asankhidwa omwe angagwirizane ndi vuto linalake ndi omwe adzawerengedwa. Mwachitsanzo, ngati manambala ndi okulirapo kapena ochepera kuposa mtengo wake.
Pazifukwa izi, ntchito ya "AVERAGE" imagwiritsidwa ntchito. Monga "AVERAGE" ntchito, imatha kukhazikitsidwa kudzera mu Ntchito Wizard, kuchokera pa barula yodula, kapena mwa kulowa m'selo. Pambuyo pazenera zotsutsana ndi ntchito zatsegulidwa, muyenera kulowa magawo ake. M'munda wa "Range", lowetsani maselo omwe maselo awo azikhudzidwa kuti adziwe kuchuluka kwa masamu. Timachita izi chimodzimodzi ndi ntchito ya AVERAGE.
Ndipo apa, mundawo "Zowonekera" tiyenera kuwonetsa mtengo wake, manambala owonjezera kapena omwe atengere mbali pakuwerengera. Izi zitha kuchitika pogwiritsa ntchito kuyerekezera zinthu. Mwachitsanzo, tidatenga mawu akuti "> = 15000". Ndiye kuti, maselo amtundu wokha omwe manambala omwe amaposa kapena lofanana ndi 15000 ndi omwe ati awerengeredwe. Ngati ndi kotheka, m'malo mwa nambala inayake, apa munganene adilesi ya foni yomwe nambala yomwe ikugwirizana ndi yomwe ili.
Gawo Lotsogolera Kulowetsa zambiri mmenemo ndikofunikira pokhapokha ngati mugwiritsa ntchito maselo okhala ndi zolemba.
Datha yonse ikalowa, dinani batani "Chabwino".
Pambuyo pake, zotsatira za kuwerengera kwapakati pa masamu zomwe zasankhidwa zimawonetsedwa mu khungu losankhidwa, kupatula maselo omwe deta yake siyikukwanira.
Monga mukuwonera, mu Microsoft Excel, pali zida zingapo zomwe mungawerengere mtengo wapakati wamitundu yosankhidwa. Kuphatikiza apo, pali ntchito yomwe imasankha yokha manambala kuchokera pamitundu yosagwirizana ndi njira zomwe ogwiritsa ntchito adaziwiratu. Izi zimapangitsa kuti makompyuta a Microsoft Excel akhale osavuta kwa ogwiritsa ntchito.
