Column DRM mu Microsoft Excel

Nthawi zina funso la ogwiritsa ntchito Excel ndi momwe mungawonjezere kuchuluka kwathunthu pazakhazikitso zingapo? Ntchitoyi imakhala yovuta kwambiri ngati mizereyi sinapezeke mndandanda umodzi, koma yogawika. Tiyeni tiwone momwe tingazifotokozere mwachidule m'njira zosiyanasiyana.

Kuphatikiza pazambiri

Mafuta a zipolopolo mu Excel amachitika molingana ndi mfundo zowonjezereka zowonjezera pulogalamuyi. Zachidziwikire, njirayi ili ndi mawonekedwe ena, koma ndi gawo limodzi mwanjira wamba. Monga zochita zina zilizonse mu purosesa iyi ya tebulo, kuwonjezeranso kwa mizati kumatha kuchitika pogwiritsa ntchito njira yosavuta yogwiritsira ntchito masamu, pogwiritsa ntchito ntchito ya Excel SUM kapena kuchuluka kwagalimoto.

Phunziro: Kuwerenga kuchuluka kwake mu Excel

Njira 1: gwiritsani ntchito totali yamagalimoto

Choyamba, tiyeni tiwone momwe tingakwaniritsire masamu mu Excel pogwiritsa ntchito chida monga auto-sum.

Mwachitsanzo, tengani tebulo lomwe likuwonetsa ndalama za masitolo asanu patsiku zisanu ndi ziwiri. Zambiri pa sitolo iliyonse zili mgulu lina. Ntchito yathu ndikuti tipeze ndalama zonse zogulitsidwa pamsika uno. Pachifukwa ichi, ingofunika pindani pazembe.

1. Kuti tipeze ndalama zonse za masiku 7 pa sitolo iliyonse payekhapayekha, timagwiritsa ntchito kuchuluka kwa magalimoto. Sankhani ndi chowunikira mutasunga batani lakumanzere muchikamu "Gulani 1" zinthu zonse zomwe zimakhala ndi manambala. Kenako, kukhala tabu "Pofikira"dinani batani "Autosum"ili pa riboni m'magulu azokonda "Kusintha".



2. Monga mukuwonera, ndalama zonse za masiku 7 pazogulitsa koyamba ziwonetsedwa mu khungu pansi pamizere ya tebulo.



3. Timagwiranso ntchito yofananira ndikugwiritsa ntchito kuchuluka kwamagalimoto kumakola ena onse omwe ali ndi data pazosungira.

   Ngati pali zipilala zambiri, ndiye kuti simungathe kuwerengera chilichonse payekhapayekha. Tidzagwiritsa ntchito chikhomo polemba formula yokhala ndi kuchuluka kwa magalimoto pamalopo oyambira kumizere yotsalira. Sankhani chinthu chomwe formula ili. Yendani pamwamba pakona kumunsi. Iyenera kusinthidwa kukhala chikhomo chodzaza, chomwe chimawoneka ngati mtanda. Kenako timagwira batani lakumanzere ndikusaka chikhomo chofananira ndi dzina lanyimbo kumapeto kwa tebulo.



4. Monga mukuwonera, phindu la ndalama zamasiku 7 pachinthu chilichonse chawerengedwa chilichonse.



5. Tsopano tifunikira kuwonjezera zonse pazotsatira zomwe zidapezekanso paliponse. Izi zitha kuchitika kudzera mu auto-sum yomweyo. Timapanga chosankha ndi chowonekera ndi batani lakumanzere ndikumapanikiza maselo onse momwe phindu la zinthu mumasitolo payekha limapezekamo, ndikuphatikiza timagwira selo lina lopanda kudzanja lamanja la iwo. Kenako timadina chikwangwani cha auto-sum pa riboni chomwe timadziwa kale.



6. Monga mukuwonera, ndalama zonse zogulitsa zonse kwa masiku 7 ziziwonetsedwa m'chipindacho, chomwe chinali kumanzere kwa tebulo.

Njira 2: gwiritsani ntchito njira yosavuta yowerengera

Tsopano tiwone momwe mungafotokozere mwachidule mizati ya tebulo pogwiritsa ntchito njira yosavuta yazamasamu pazolinga izi. Mwachitsanzo, tidzagwiritsa ntchito tebulo lomweli lomwe limagwiritsidwa ntchito kufotokoza njira yoyamba.

1. Monga nthawi yotsiriza, choyambirira, tifunika kuwerengetsa ndalama za masiku 7 pa sitolo iliyonse payokha. Koma tidzachita izi mwanjira yosiyana pang'ono. Sankhani foni yoyamba yopanda kanthu, yomwe ili pansi pazolowera "Gulani 1", ndikuyika chikwangwani pamenepo "=". Kenako, dinani chinthu choyambirira patsamba lino. Monga mukuwonera, adilesi yake imawonetsedwa nthawi yomweyo mu foniyo ndi kuchuluka kwake. Pambuyo pake timayika chikwangwani "+" kuchokera pa kiyibodi. Kenako, dinani pa foni yotsatira pagawo lomweli. Chifukwa chake, kusinthanitsa kulumikizana ndi zinthu za pepala ndi chikwangwani "+", sinthani maselo onse m'mizati.

   M'malo mwathu, njira yotsatirayi idapezedwa:

   = B2 + B3 + B4 + B5 + B6 + B7 + B8

   Zachidziwikire, nthawi iliyonse, zimatha kukhala zosiyana kutengera malo omwe patebulopo ndi pepala komanso maselo omwe ali mgulowo.



2. Pambuyo polemba ma adilesi a zinthu zonse za mzere, kuwonetsa zotsatira za kufupikitsa ndalama masiku 7 atangoyamba kumene, dinani batani Lowani.



3. Kenako mutha kuchitanso zomwezo m'mashopu ena anayi, koma zidzakhala zosavuta komanso mwachangu kuwerengetsa zotsalazo pazipilala zina pogwiritsa ntchito chikhomo chofananira ndi zomwe tidachita munthawi yapita.



4. Tsopano tikufunika kupeza kuchuluka kwathunthu. Kuti muchite izi, sankhani chilichonse chopanda pa pepala chomwe tikufuna kuwonetsa, ndikuyika chikwangwani "=". Kenako, timawonjezera maselo omwe timadongosolo tomwe timawerengera kale.

   Tili ndi kachitidwe kotsatira:

   = B9 + C9 + D9 + E9 + F9

   Koma formula iyi ndiwomwe payekha payekhapayekha.



5. Kuti mupeze zotsatira zonse zowonjezera mizati, dinani batani Lowani pa kiyibodi.

Ndizosatheka kuzindikira kuti njirayi imatenga nthawi yayitali komanso imafunikira kuchita zambiri kuposa yoyamba ija, chifukwa imaphatikizanso kudina kwamanja kwa foni iliyonse yomwe imafunika kuzikulungidwa kuti iwonetse ndalama zonse. Ngati tebulo lili ndi mizere yambiri, njirayi imakhala yosautsa. Nthawi yomweyo, njirayi ili ndi mwayi umodzi wosasinthika: zotulukapo zimatha kuwonetsedwa mu khungu lililonse lopanda pepala lomwe wosuta amasankha. Mukamagwiritsa ntchito ndalama zokha, palibe mwayi wotere.

Pochita, njira ziwiri izi zitha kuphatikizidwa. Mwachitsanzo, kufotokozera mwachidule zotsatira mu gawo lililonse aliyense payekhapayekha pogwiritsa ntchito zowerengera, ndikuwonetsa mtengo wonse mwakugwiritsira ntchito formula yamaselo pafoni yomwe wosuta amasankha.

Njira 3: kugwiritsa ntchito SUM

Zoyipa za njira ziwiri zapitazi zitha kuthetsedwa pogwiritsa ntchito ntchito yomwe idapangidwa mu Excel yotchedwa SUM. Cholinga cha wothandizirayi ndi ndendende kuchuluka kwa manambala. Ili m'gulu la ntchito zamasamu ndipo ili ndi syntax yosavuta:

= SUM (nambala1; nambala2; ...)

Zotsutsazo, kuchuluka kwake komwe kungafikire 255, ndi manambala osungidwa kapena ma adilesi am'magawo momwe amapezeka.

Tiyeni tiwone momwe ntchito iyi ya Excel imagwiritsidwira ntchito, pogwiritsa ntchito gome lofanana la ndalama m'malo ogulitsa asanu m'masiku 7 monga zitsanzo.

1. Tikuyika chizindikirocho papepala momwe phindu lolipirira gawo loyamba liziwonetsedwa. Dinani pachizindikiro "Ikani ntchito", yomwe ili kumanzere kwa baramu yamu formula.



2. Kachitidwe kakuchitika Ogwira Ntchito. Kukhala pagululi "Masamu"kufunafuna dzina SUM, sankhani ndikudina batani "Zabwino" pansi pa zenera ili.



3. Ntchito yotsutsana ndi ntchito imayambitsidwa. Itha kukhala ndi minda mpaka 255 yokhala ndi dzinalo "Chiwerengero". Magawo awa ali ndi zotsutsana za ogwiritsira ntchito. Koma kwa ife, gawo limodzi lidzakwanira.

   M'munda "Nambala1" ndikufuna kuyika zolumikizira zamagulu omwe ali ndi maselo "Gulani 1". Izi zimachitika mosavuta. Tikuyika chidziwitso m'bokosi la zenera zotsutsa. Kenako, podina batani lakumanzere, sankhani maselo onse omwe ali mgulowo "Gulani 1"zomwe zimakhala ndi ziwerengero. Adilesiyi idawonetsedwa nthawi yomweyo m'bokosi la zenera zotsutsana mwanjira ya oyang'anira madongosolo omwe akukonzedwa. Dinani batani "Zabwino" pansi pazenera.



4. Mtengo wa masiku asanu ndi awiri ogulitsira woyamba uwonetsedwa muselo yomwe imakhala ndi ntchitoyo.



5. Ndiye mutha kuchita ntchito zofananira ndi ntchitoyo SUM Pazigawo zotsalira za tebulo, kuwerengera kuti ndalama zolipirira masiku 7 m'masitolo osiyanasiyana. Ma algorithm ogwiritsira ntchito azikhala chimodzimodzi monga tafotokozera pamwambapa.

   Koma pali njira yothandizira kuti ntchitoyo iziyenda bwino. Kuti muchite izi, gwiritsani ntchito chikhomo chodzaza. Sankhani khungu lomwe lili ndi ntchito kale SUM, ndikukoka chikhomo chomwe chikufanana ndi mitu ya mzere mpaka kumapeto kwa tebulo. Monga mukuwonera, panthawiyi, ntchito SUM ndinatsata chimodzimodzi monga momwe tidakopera njira yaying'ono yosavuta.



6. Zitatha izi, sankhani cell yopanda pepala lomwe tikufuna kuwonetsa zowerengera zonse m'masitolo onse. Monga momwe munachitira kale, iyi ikhoza kukhala chilichonse chaulere. Pambuyo pake, m'njira yodziwika, timayitanitsa Fotokozerani Wizard ndi kupita ku zenera zotsutsana ndi ntchito SUM. Tiyenera kudzaza mundawo "Nambala1". Monga momwe zinaliri m'mbuyomu, tinakhazikitsa tchire m'munda, koma nthawi ino ndikabatani chakumanzere, timasankha mzere wathunthu wazopeza zonse m'masitolo amodzi. Pambuyo pa adilesi ya mzerewu mu njira yolumikizana nawo adalowa m'munda wa zenera la mkangano, dinani batani "Zabwino".



7. Monga mukuwonera, ndalama zonse m'masitolo onse chifukwa cha ntchitoyo SUM adawonetsedwa mu khungu lomwe kale lidasankhidwa mu pepalalo.

Koma nthawi zina pamakhala nthawi zina pamene muyenera kuwonetsa zotsatira zonse pazogulitsa zonse popanda kufotokozera mwachidule zotsatira zapakatikati pa masitolo amodzi. Zikuwoneka kuti wothandizira SUM ndipo itha, kuthetsa vutoli ndikosavuta kuposa kugwiritsa ntchito njira yam'mbuyomu.

1. Monga nthawi zonse, sankhani khungu papepala pomwe zotsatira zomaliza zidzakhale. Timayimba Fotokozerani Wizard kudina chizindikiro "Ikani ntchito".



2. Kutsegula Fotokozerani Wizard. Mutha kusamukira ku gululi "Masamu"koma ngati udagwiritsa ntchito neno posachedwapa SUMmonga tidachita, mutha kukhalabe m'gululi "10 Zomwe Zagwiritsidwa Ntchito Posachedwa" ndikusankha dzina lomwe mukufuna. Ziyenera kukhalapo. Dinani batani "Zabwino".



3. Zenera lotsutsa liyambiranso. Ikani wolemba m'munda "Nambala1". Koma pakadali pano, timagwira batani lakumanzere ndikusankha mndandanda wonse, womwe umakhala ndi ndalama zonse zogulitsa. Chifukwa chake, adilesi ya gawo lonse la tebulo iyenera kukhala m'munda. Kwa ife, ili ndi mawonekedwe awa:

   B2: F8

   Koma, zoona, munthawi zonsezi, adilesiyo idzakhala yosiyana. Zomwe zimachitika nthawi zonse ndikuti zogwirizanitsa za selo lakumanzere la gulu ndizomwe zidzakhale zoyamba adilesi iyi, ndipo gawo lamanzere lakumanzere likhala lomaliza. Izi zitha kupatulidwa ndi koloni (:).

   Pambuyo adilesi ya gulu lakhazikitsidwa, dinani batani "Zabwino".



4. Pambuyo pa izi, zotsatira zakuphatikizira kwa deta zikuwonetsedwa mu khungu limodzi.

Ngati tilingalira motere kudzera muukadaulo, ndiye kuti sitinakukhazikitsa mzati, koma gulu lonse. Koma zotulukapo zake zinali zofanana ndi ngati chidutswa chilichonse chidasungidwa mosiyana.

Koma pali nthawi zina pamene mungafunikire kuwonjezera pazigawo zonse za tebulo, koma zina zokha. Ntchitoyi imakhala yovuta kwambiri ngati sagwirizana malire. Tiyeni tiwone momwe mtundu uwu wowonjezera umachitikira pogwiritsa ntchito SUM opangira pogwiritsa ntchito gome lomweli. Tingoyerekeza timangowonjezera maulamu "Gulani 1", "Gulani 3" ndi "Gulani 5". Ndikofunikira kuti zotsatira zake zithe kuwerengedwa popanda kutulutsa mawu ang'onoang'ono mumizati.

1. Tikuyika cholozera mu chipinda chomwe zotsatira zake ziziwonetsedwa. Timawatcha kutiwotsutsa a ntchito SUM momwemonso tidachita kale.

   Pazenera lomwe limatsegulira m'munda "Nambala1" lowetsani adilesi yamtundu wazambiri mu mzati "Gulani 1". Timachita izi chimodzimodzi monga kale: ikani cholozera m'mundamu ndikusankha magawo ofanananira a tebulo. Kulowa m'minda "Nambala2" ndi "Nambala 3" motero, timalowetsa ma adilesi a zosanjidwa izi m'mizati "Gulani 3" ndi "Gulani 5". M'malo mwathu, maungwe omwe adalowetsedwa ndi awa:

   B2: B8
D2: D8
F2: F8

   Kenako, monga nthawi zonse, dinani batani "Zabwino".



2. Mukamaliza kuchita izi, zotsatira zowonjezera mtengo wopeza m'masitolo atatu mwa asanu ziziwonetsedwa muzomwe mukufuna.

Phunziro: Kugwiritsa ntchito Feature Wizard mu Microsoft Excel

Monga mukuwonera, pali njira zitatu zazikulu zowonjezera mzati ku Excel: kugwiritsa ntchito ndalama, magwiritsidwe ntchito a masamu, ndi ntchito SUM. Njira yosavuta komanso yachangu kwambiri yogwiritsira ntchito kuchuluka kwa magalimoto. Koma ndiosasintha kwambiri ndipo sioyenera nthawi zonse. Njira yosinthika kwambiri ndikugwiritsa ntchito njira zamasamu, koma ndizokhazo zomwe zimangochitika zokha ndipo nthawi zina, ndikakhala ndi kuchuluka kwa deta, kukhazikitsidwa kwake machitidwe kungatenge nthawi yayitali. Ntchito yogwira ntchito SUM imatha kutchedwa "golide" wapakati pakati pa njira ziwiri izi. Izi zimasinthasintha komanso zimathamanga.