Wogwiritsa ntchito ACCOUNT amatanthauza ntchito za Excel. Ntchito yake yayikulu ndikuwerengera maselo osiyanasiyana omwe ali ndi ziwerengero. Tiphunzire zambiri pamitundu ingapo yogwiritsira ntchito njira iyi.
Gwirani ntchito ndi ACCOUNT
Ntchito ACCOUNT amatanthauza gulu lalikulu la ogwiritsa ntchito ziwerengero, zomwe zimaphatikizapo zinthu zana. Ntchitoyi ili pafupi kwambiri ndi ntchito zake MALANGIZO. Koma, mosiyana ndi zomwe timakambirana, zimatengera maselo a akaunti omwe ali ndi chidziwitso chilichonse. Wogwiritsa ntchito ACCOUNT, yomwe tidzakambirana mwatsatanetsatane, amawerengetsa maselo okha omwe ali ndi data mu manambala.
Kodi ndi mawerengero amtundu wanji omwe amawerengera? Izi zikuphatikiza nambala yeniyeni, komanso mtundu wa tsiku ndi nthawi. Mfundo za Boolean ("ZOONA", FALSE etc.) ntchito ACCOUNT chimangoganizira pokhapokha ngati iwo atsutsana nawo. Ngati akungokhala m'gawo la pepala lomwe lingaliro, ndiye kuti wothandizirayo sawaganizira. Zofananazo ndizofanana ndi zolemba za malembo, zomwe zikutanthauza kuti, pomwe manambala alembedwa polemba mawu kapena patazunguliridwa ndi anthu ena. Pano, nawonso, ngati ali wotsutsana mwachindunji, amatenga nawo mbali powerengera, ndipo ngati ali pa pepala, satero.
Koma pofotokoza za nkhani yoyera momwe mulibe manambala, kapena mawu olakwika ("#DEL / 0!", #VALUE! Etc. zinthu sizosiyana. Mfundo ngati izi zimagwira ntchito ACCOUNT ilibe kanthu mwanjira iliyonse.
Kuphatikiza pa ntchito ACCOUNT ndi MALANGIZO, kuwerengetsa kuchuluka kwa maselo odzazidwa kumachitidwabe ndi ogwiritsa ntchito KULIMA ndi COUNTIMO. Pogwiritsa ntchito njira izi, mutha kuwerengera ndalama zina. Mutu wapadera umaperekedwa ku gulu ili la ogwiritsa ntchito manambala.
Phunziro: Momwe mungawerengere kuchuluka kwa maselo odzazidwa mu Excel
Phunziro: Ntchito zama Statist ku Excel
Njira 1: Wizard wa Ntchito
Kwa wogwiritsa ntchito mosazindikira, ndizosavuta kuwerengera maselo okhala ndi manambala pogwiritsa ntchito fomula ACCOUNT mothandizidwa ndi Ogwira Ntchito.
- Timadula foni yopanda pepala pomwe malembedwewo adzawonetsedwa. Dinani batani "Ikani ntchito".
Palinso njira ina yoyambitsa. Ogwira Ntchito. Kuti muchite izi, mutasankha khungu, pitani ku tabu Mawonekedwe. Pa nthiti yomwe ili m'bokosi la chida Laibulale ya Feature dinani batani "Ikani ntchito".
Palinso njira ina, mwina yosavuta, koma nthawi imodzimodzi yokumbukira zabwino. Sankhani khungu pa pepalalo ndikusindikiza kuphatikiza kiyibodi Shift + F3.
- M'njira zonse zitatuzi, zenera liyamba Ogwira Ntchito. Kupita pazenera zotsutsidwa zomwe zili mgululi "Zowerengeka"kapena "Mndandanda wathunthu wa zilembo" kufunafuna chinthu "ACCOUNT". Sankhani ndikudina batani. "Zabwino".
Komanso, zenera la mkangano lingayambitsidwe mwanjira ina. Sankhani khungu kuti muwonetse zotsatira ndikupita pa tabu Mawonekedwe. Pa riboni m'makonzedwe magulu Laibulale ya Feature dinani batani "Ntchito zina". Kuchokera pamndandanda womwe umawonekera, sinthani chidziwitso kupita kumalo "Zowerengera". Pazosankha zomwe zimatsegulira, sankhani "ACCOUNT".
- Windo la mkangano liyamba. Mfundo yokhayo yapa fomuloli ikhoza kukhala mtengo womwe umaperekedwa ngati cholumikizira kapena wolembedwa m'munda wofanana. Zowona, kuyambira ndi mtundu wa Excel 2007, mfundo zoterezi zitha kupezeka 255. M'mabaibulo akale panali 30 okha.
Mutha kuyika zidziwitso kuminda ndikusanthula zofunikira kapena masanjidwe amtundu kuchokera pa kiyibodi. Koma polemba zamagulu, zimakhala zosavuta kungoika chikwangwani m'munda ndikusankha foni yolumikizana kapena mtundu patsamba. Ngati pali magulu angapo, ndiye kuti adilesi yachiwiriyo ikhoza kulowa m'munda "Mtengo2" etc. Pambuyo kutsatira mfundozo, dinani batani "Zabwino".
- Zotsatira zowerengera maselo okhala ndi manambala pamitundu yosankhidwa ziwonetsedwa pamalo omwe adafotokozedwapo pepala.
Phunziro: Ntchito Wizard ku Excel
Njira 2: Kuphatikiza Kugwiritsa Ntchito Kukangana Kwakusankha
Mwa chitsanzo pamwambapa, tidawunikira milanduyi pomwe zomwe zikuwonetsedwazo zimangotanthauza mawonekedwe a pepalalo. Tsopano tiyeni tiwone njira yomwe malingaliro omwe adalowetsedwako mwachindunji m'munda wamtsutso amagwiritsidwanso ntchito.
- Pogwiritsa ntchito zosankha zilizonse zomwe zafotokozedwa mu njira yoyamba, timakhazikitsa zenera la malingaliro la ntchito ACCOUNT. M'munda "Mtengo1" sonyezani adilesi yamtunduwo ndi deta, ndi m'mundawo "Mtengo2" lembani mawu omveka "ZOONA". Dinani batani "Zabwino"kuwerengera.
- Zotsatira zake zikuwonetsedwa pamalo omwe adasankhidwa kale. Monga mukuwonera, pulogalamuyo inawerengera maselo okhala ndi manambala ndikuwonjezera mtengo wina kwa iwo, omwe tidalemba ndi mawuwo "ZOONA" m'munda wokangana. Ngati mawu awa adalembedwa mwachindunji kwa foniyo, ndipo cholumikizira chokha ndi chomwe chidayima m'munda, ndiye kuti sichingawonjezedwe.
Njira 3: kuyambitsa njira
Kuphatikiza pa kugwiritsa ntchito Ogwira Ntchito ndi zenera la mkangano, wogwiritsa ntchito amatha kulowa mawuwo mu selo iliyonse papepala kapena mu barula yokhazikitsidwa. Koma pa izi muyenera kudziwa syntax wa opareting'i. Sizovuta:
= SUM (Mtengo1; Mtengo2; ...)
- Lowetsani mawu ofotokozera mu foni ACCOUNT kutengera kapangidwe kake.
- Kuti mupeze zotsatirazo ndikuwonetsa pazenera, dinani batani Lowanikuyikidwa pa kiyibodi.
Monga mukuwonera, zitatha izi, zotsatira za kuwerengera zimawonetsedwa pazenera muma cell osankhidwa. Kwa ogwiritsa ntchito anzeru, njirayi imatha kukhala yabwino kwambiri komanso mwachangu. Kupitilira zakale ndi zovuta Ogwira Ntchito ndi windows windows.
Pali njira zingapo zogwiritsira ntchito ntchito. ACCOUNTntchito yake yayikulu kuwerengera maselo okhala ndi ziwerengero. Pogwiritsa ntchito formula yomweyo, mutha kuyika zowonjezera zowerengera mwachindunji m'magawo amatsutsana a formula kapena poilembera mwachindunji kuselo malingana ndi syntax ya opaleshoni iyi. Kuphatikiza apo, pakati pa ogwiritsira ntchito manambala pali njira zina zomwe zimakhudzidwa kuwerengera maselo odzazidwa mumtundu wosankhidwa.
