Kuwerengera kuchuluka kwa mzere wa tebulo mu Microsoft Excel

Pogwira ntchito ndi matebulo, nthawi zambiri mumayenera kugwetsa pansi manambala onse a dzina linalake. Dzinalo la mnzake, dzina la wantchito, nambala yaunitsi, deti, ndi zina zinalembedwe ngati dzina ili. Nthawi zambiri mayina awa ndi mutu wa mizere motero, kuti muwerenge zonse zomwe zapezeka pachinthu chilichonse, ndikofunikira kufotokozera mwachidule zomwe zili m'maselo a mzere winawake. Nthawi zina zambiri zimawonjezeredwa mzere pochita zina. Tiyeni tiwone njira zosiyanasiyana momwe izi zingachitikire ku Excel.

Onaninso: Momwe mungawerengere kuchuluka kwa Excel

Kutchula mfundo motsatana

Mokulira, pali njira zitatu zazikulu zofotokozera mwachidule zofunikira mu chingwe ku Excel: kugwiritsa ntchito kakhazikidwe kogwiritsa ntchito masamu, ntchito, komanso ndalama. Nthawi yomweyo, njirazi zitha kugawidwa m'magulu osiyanasiyana.

Njira 1: Njira Zankhondo

Choyamba, tiona momwe kugwiritsa ntchito njira yamisamu momwe mungawerengere kuchuluka kwa mzere. Tiyeni tiwone momwe njirayi imagwirira ntchito pa mwachindunji.

Tili ndi tebulo lomwe likuwonetsa ndalama za masitolo asanu pofika tsiku. Mayina ogulitsa ndi mayina amizere, ndipo masiku ake ndi mayina a mizati. Tiyenera kuwerengera ndalama zonse zogulitsa zoyambirira panthawi yonseyo. Kuti tichite izi, tiyenera kuwonjezera maselo onse amizere omwe ali pachiwonetserochi.

1. Sankhani selo yomwe zotsatira zomaliza zowerengera zikuwonetsedwa. Tidayika chikwangwani pamenepo "=". Dinani kumanzere pa foni yoyamba mzere uwu, womwe umakhala ndi ziwerengero. Monga mukuwonera, adilesi yake imawonetsedwa nthawi yomweyo mu mawonekedwe kuti muwonetsetse. Timayika chikwangwani "+". Kenako dinani selo lotsatira mzere. Mwanjira imeneyi timasinthira chizindikirocho "+" ndi ma adilesi a maselo amzera omwe akutanthauza sitolo yoyamba.

   Zotsatira zake, m'malo mwathu, njira yotsatirayi ikupezeka:

   = B3 + C3 + D3 + E3 + F3 + G3 + H3

   Mwachilengedwe, mukamagwiritsa ntchito matebulo ena, mawonekedwe ake amakhala osiyana.



2. Kuti muwonetse ndalama zonse zomwe mwapeza koyamba, dinani batani Lowani pa kiyibodi. Zotsatira zake zikuwonetsedwa mu cell momwe formula idapangidwira.

Monga mukuwonera, njirayi ndi yosavuta komanso yothandiza, koma imakhala yokhazikika. Ndikofunikira kugwiritsa ntchito nthawi yayitali pakukhazikitsa kwake, poyerekeza ndi zosankha zomwe tikambirana pansipa. Ndipo ngati pali mizati yambiri patebulopo, ndiye kuti nthawi yake itchukanso.

Njira 2: AutoSum

Njira yofulumira kwambiri yowonjezerapo data mu mzere ndikugwiritsa ntchito ndalama.

1. Sankhani maselo onse okhala ndi manambala a mzere woyamba. Timasankha pogwirizira batani lakumanzere. Kupita ku tabu "Pofikira"dinani pachizindikiro "Autosum"ili pa riboni m'bokosi la chida "Kusintha".

   

   Njira ina yoyitanitsa auto sum ndikupita pa tabu Mawonekedwe. Pamenepo m'bokosi la chida Laibulale ya Feature dinani pa batani pa riboni "Autosum".

   

   Ngati simukufuna kuyang'ana ma tabo konse, kenako mutatsindika mzere, mutha kungopeka zophatikiza zotentha Alt + =.

2. Zochita zilizonse zomwe mungasankhe pamwambazi, zingapo ziwonetsedwa kumanja kwa magulu omwe mwasankhawo. Zikhala kuchuluka kwa mzerewo.

Monga mukuwonera, njirayi imakuthandizani kuti muwerengere kuchuluka kwa mzere mwachangu kwambiri kuposa mtundu wakale. Koma alinso ndi vuto. Zimakhala kuti kuchuluka kwake kudzawonetsedwa kumanja kwa malo osankhidwa okha, osati kumalo komwe wogwiritsa ntchito akufuna.

Njira 3: Ntchito ya SUM

Kuti muthane ndi zoperewera za njira ziwiri zomwe zili pamwambapa, kusankha pogwiritsa ntchito Excel yomwe mwayitanitsa SUM.

Wogwiritsa ntchito SUM ndi gulu la Excel la masamu. Ntchito yake ndi kuchita manambala. Kapangidwe ka ntchitoyi ndi motere:

= SUM (nambala1; nambala2; ...)

Monga mukuwonera, mfundo za wothandizira uyu ndi manambala kapena maadiresi am'melo momwe amapezeka. Chiwerengero chawo chikhoza kukhala 255.

Tiyeni tiwone momwe titha kuwerengera zinthuzi mzere pogwiritsa ntchito opaleshoni iyi pogwiritsa ntchito gome lathu.

1. Sankhani selo iliyonse yopanda pepala pomwe tikufuna kuwonetsa zotsatira zake. Ngati mungafune, mutha kuyisankha ngakhale papepala lina. Koma izi zimachitika mwanjira zambiri, chifukwa nthawi zambiri zimakhala zosavuta kuyika khungu pazotsatira mzere womwewo monga momwe amawerengera. Masankhidwe atapangidwa, dinani pa chizindikirocho "Ikani ntchito" kumanzere kwa baramu yamu formula.



2. Chida chomwe chimatchedwa Fotokozerani Wizard. Timadutsamo "Masamu" Kuchokera pamndandanda wa omwe akutsegula, sankhani dzinalo SUM. Kenako dinani batani "Zabwino" pansi pazenera Ogwira Ntchito.



3. Windo la wotsutsana likuyambitsidwa SUM. Windo ili limatha kukhala ndi minda yokwana 255, koma kuti muthane ndi mavuto athu, mukufunika gawo limodzi lokha - "Nambala1". Ndikofunikira kulowa zolumikizira za mzerewu, zomwe zimayeneredwa pazowonjezeramo. Kuti muchite izi, ikani cholozera m'munda womwe watchulidwa, kenako, ndikusunga batani lakumanzere, sankhani mtundu wonse wa mzere womwe tikufuna ndi chowombeza Monga mukuwonera, adilesi yamtunduwu iwonetsedwa pomwepo pazenera la mkangano. Kenako dinani batani "Zabwino".



4. Tikamaliza zomwe tafotokozazi, kuchuluka kwa mzerewu kumaonekera nthawi yomweyo mu khungu lomwe tidasankha koyambirira kuthana ndi mavutowa motere.

Monga mukuwonera, njirayi imasinthasintha komanso imathamanga. Zowona, sizachilendo kwa onse ogwiritsa ntchito. Chifukwa chake, iwo omwe sakudziwa za kukhalapo kwake kuchokera kumagwero osiyanasiyana sapeza kawirikawiri mawonekedwe a Excel okha.

Phunziro: Mfiti ya Excel Wizard

Njira yachinayi: kuchuluka kwa kuchuluka m'mizere

Koma bwanji ngati mungafotokoze mwachidule osati kumzere umodzi kapena awiri, koma nkuti, 10, 100, kapena ngakhale 1000? Kodi ndizofunikiradi kuti mzere uliwonse uzigwiritsa ntchito zomwe tafotokozazi? Zotsatira zake, sizofunikira ayi. Kuti muchite izi, muyenera kungotengera chilinganizo cha ma cell mu ma cell ena momwe mumakonzekera kuwonetsa mzere wa mizere yotsalayo. Izi zitha kuchitika pogwiritsa ntchito chida chomwe chimadziwika ndi dzina lodzaza.

1. Timawonjezera zomwe zili mzere woyamba wa tebulo pogwiritsa ntchito njira zomwe zidafotokozedwapo kale. Timayika cholozera mu ngodya ya m'munsi yakumanja ya chipangizacho momwe zotsatsira kapena mawonekedwe ake adawonetsera. Potere, cholozera chizisintha mawonekedwe ake ndikusintha chikhomo, chomwe chimawoneka ngati mtanda wawung'ono. Kenako tigwirizira batani lamanzere lakumanzere ndikokera kounikira pansi limodzi ndi maselo okhala ndi mayina amizere.



2. Monga mukuwonera, maselo onse adadzaza ndi chidziwitso. Uwu ndiye kuchuluka kwa mitengo mosiyanasiyana mzere uliwonse. Zotsatirazi zidapezeka chifukwa, mosasinthika, maulalo onse mu Excel ndi achibale, osati amtheradi, ndipo akamakopera, amasintha ma mgwirizano awo.

Phunziro: Momwe mungapangire kuti zikwaniritsidwe mu Excel

Monga mukuwonera, ku Excel pali njira zazikulu zitatu zowerengetsera kuchuluka kwa zotsatirazi mzere: formula wa arithmetic, auto-sum ndi SUM ntchito. Iliyonse mwanjira izi ili ndi zabwino komanso zovuta zake. Njira yodziwikiratu ndikugwiritsa ntchito formula, njira yachangu kwambiri ndi auto-sum, ndipo chodziwika kwambiri ndikugwiritsa ntchito SUM opangira. Kuphatikiza apo, pogwiritsa ntchito cholembera, mutha kukwaniritsa kuchuluka kwa mfundo pogwiritsa ntchito mizere, yochitidwa ndi imodzi mwanjira zitatu zomwe tafotokozazi.