Momwe mungaletse kukhudzana pa iPhone

Nthawi zina asanakhale ogwiritsa ntchito Excel kukhala funso momwe angawonjezere chiwerengero cha miyeso yambiri yazitsulo? Ntchitoyi ndi yophweka kwambiri ngati zipilalazi sizipezeka limodzi, koma zabalalika. Tiyeni tione momwe tingawafotokozere iwo m'njira zosiyanasiyana.

Kuwonjezera Powonjezera

Kufotokoza kwa zikhomo ku Excel kumachitika molingana ndi mfundo zowonjezera deta pulogalamuyi. Inde, njirayi ili ndi zochitika zinazake, koma ndizochepa chabe pa lamulo lonse. Monga kufotokoza kwina kulikonse kotsindika kondomekoyi, kuwonjezera kwa zikhomo kungatheke pogwiritsira ntchito ndondomeko yosavuta ya masamu, pogwiritsa ntchito ntchito yopangidwa mu Excel SUM kapena ndalama zokwanira.

Phunziro: Kuwerengera ndalama mu Excel

Njira 1: Gwiritsani ntchito Auto Sum

Choyamba, tiyeni tiyang'ane momwe tingagwiritsire ntchito ndondomekozo mu Excel ndi chithandizo cha chida monga mtengo wamagalimoto.

Mwachitsanzo, tengani tebulo, lomwe limapereka ndalama za tsiku ndi tsiku m'masitolo asanu masiku asanu ndi awiri. Deta pa sitolo iliyonse ili mu gawo losiyana. Ntchito yathu ndiyo kupeza ndalama zonse zogulitsa izi pa nthawi yomwe ili pamwambapa. Pachifukwa ichi, muyenera kungolemba gawolo.

1. Kuti tipeze ndalama zonse za masiku 7 pa sitolo iliyonse padera, timagwiritsa ntchito galimoto mtengo. Sankhani chithunzithunzi ndi batani lamanzere lachinsinsi lomwe linakanikizidwa m'mbali "Gulani 1" zinthu zonse zomwe zili ndi zilembo zamtundu. Ndiye, kukhala mu tab "Kunyumba", dinani pa batani "Autosum"yomwe ili pa riboni m'magulu opangira Kusintha.



2. Monga mukuonera, chiwerengero cha ndalama zamasiku 7 pa chilolezo choyamba chidzawonetsedwa mu selo pansi pa tebulo.



3. Timachita ntchito yofananamo, ndikugwiritsa ntchito galimoto yamtengo wapatali komanso maulendo ena onse okhala ndi deta pazinthu zamasitolo.

   Ngati pali zipilala zambiri, ndiye kuti n'zosatheka kuti muwerengere ndalama zonse payekha. Timagwiritsa ntchito chikhomo chodzaza kuti mufanizire fomu yomwe ili ndi galimoto yokhala yoyamba kumalo ena otsala. Sankhani chinthu chimene chimapangidwira. Sungani chithunzithunzi kupita kumanja kumanja. Iyenera kutembenuzidwa kukhala chizindikiro chodzaza, chomwe chikuwoneka ngati mtanda. Kenaka timapanga chofufumitsa cha batani lamanzere ndikukakaniza chida chodzaza chofanana ndi dzina lachitsulo mpaka kumapeto kwa tebulo.



4. Monga momwe mukuonera, miyezo ya ndalama kwa masiku asanu ndi awiri pa chikwama chilichonse chowerengedwa.



5. Tsopano tikufunika kuwonjezera pamodzi zotsatira zomwe zilipo pamtundu uliwonse. Izi zikhoza kuchitidwa kudzera mumagalimoto omwewo. Sankhani ndi chithunzithunzi ndi batani lamanzere lomwe limagwiritsidwa ntchito m'maselo onse omwe ndalama zopezeka m'masitolo zimapezeka, komanso kuwonjezera apo timagwira selo lopanda kanthu kumanja. Kenaka dinani pa chithunzi chomwe chadziwika kale kwa ife pa leboni.



6. Monga mukuonera, chiwerengero cha ndalama zogulitsa zonse masiku asanu ndi awiri zidzawonetsedwa mu selo yopanda kanthu, yomwe inali kumanzere kwa tebulo.

Njira 2: Gwiritsani ntchito ndondomeko yosavuta ya masamu

Tsopano tiyeni tiwone momwe tingafotokozere mwachidule zipilala za tebulo, kugwiritsa ntchito zofuna izi pokhapokha masamu a masamu. Mwachitsanzo, tidzagwiritsa ntchito tebulo lomwe linagwiritsidwa ntchito pofotokoza njira yoyamba.

1. Monga nthawi yotsiriza, choyamba, tifunikira kuwerengera kuchuluka kwa ndalama masiku asanu ndi limodzi pa sitolo iliyonse. Koma tidzachita izi mwa njira yosiyana. Sankhani selo yoyamba yopanda kanthu pansi pa ndimeyi. "Gulani 1"ndi kuyika chizindikiro pamenepo "=". Kenaka, dinani pa choyamba choyamba cha ndimeyi. Monga mukuonera, adilesi yake imasonyezedwa nthawi yomweyo mu selo ya ndalamazo. Pambuyo pake timaika chizindikiro "+" kuchokera ku kibodiboli. Kenaka, dinani pa selo lotsatira m'mbali yomweyo. Choncho, mafotokozedwe osinthira ku zigawo za pepala ndi chizindikiro "+", timakonza maselo onse a chithunzi.

   Momwe ife tikuchitira, ife tiri ndi njira yotsatirayi:

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

   Inde, pazifukwa zonse zikhoza kukhala zosiyana malingana ndi malo a tebulo pa pepala ndi chiwerengero cha maselo m'ndandanda.



2. Pambuyo pa maadiresi a zigawo zonse za mndandanda, mwawonetsa zotsatira zafupikitsa za ndalama masiku asanu ndi awiri pa choyamba, dinani pa batani Lowani.



3. Ndiye mukhoza kuchita zomwezo m'masitolo ena anayi, koma zidzakhala zosavuta komanso mofulumira kuti awerengere deta muzitsulo zina pogwiritsa ntchito chikhomo chodzaza chimodzimodzi monga momwe tinachitira kale.



4. Icho chiri tsopano kuti ife tipeze chiwerengero cha zikhomo. Kuti muchite izi, sankhani chinthu chilichonse chopanda kanthu pa pepala, chomwe tikukonzekera kuti tisonyeze zotsatirazo, ndipo tiyike chizindikirocho "=". Kenaka ife tikuwonjezera maselo omwe mndandanda wa zipilala, zomwe tawerengera kale, zilipo.

   Tili ndi njira yotsatirayi:

   = B9 + C9 + D9 + E9 + F9

   Koma chiwerengerochi ndichanso payekha payekha.



5. Kuti mupeze zotsatira zonse za kuwonjezera mazamu, dinani pa batani. Lowani pabokosi.

Sizingatheke kuzindikira kuti njirayi imatenga nthawi yochuluka ndipo imafuna khama kusiyana ndi yomwe yapitayo, chifukwa imaganiza kuti pofuna kubwereketsa ndalama zonse, kubwereza kachiwiri kwa selo iliyonse yomwe iyenera kuwonjezeredwa. Ngati pali mizere yambiri pagome, ndiye kuti njirayi ingakhale yovuta. Panthawi imodzimodziyo, njira iyi ili ndi mwayi umodzi wosatsutsika: zotsatira zake zikhoza kubweretsedwa ku selo iliyonse yopanda kanthu pa pepala yomwe wosankhayo amasankha. Mukamagwiritsa ntchito galimoto, palibe zotheka.

Mwachizolowezi, njira ziwirizi zikhoza kuphatikizidwa. Mwachitsanzo, kutambasula zigawo zonse pamtundu uliwonse pokhapokha pogwiritsira ntchito galimoto, ndikupeza phindu lonse pogwiritsira ntchito ndondomeko ya masamu mu selo pamasamba omwe wosankhidwa amusankha.

Njira 3: Gwiritsani ntchito ntchito ya SUM

Zoipa za njira ziwiri zapitazo zingathetsedwe pogwiritsira ntchito ntchito yomangidwa mu Excel yotchedwa SUM. Cholinga cha wogwiritsira ntchitoyi ndi ndondomeko ya manambala. Zili m'gulu la masamu ndipo ali ndi mawu ophweka awa:

= SUM (nambala1; nambala2; ...)

Zokambirana, chiwerengero chake chingathe kufika ku 255, ndi nambala zowerengeka kapena maadiresi a selo, kumene ali.

Tiyeni tiwone momwe ntchito iyi ya Excel imagwiritsidwira ntchito pogwiritsira ntchito chitsanzo cha tebulo limodzi la ndalama zogulitsa zisanu masiku asanu ndi awiri.

1. Timayika chinthu pa pepala momwe ndalama zomwe zili mukhola yoyamba zidzawonetsedwa. Dinani pazithunzi "Ikani ntchito"yomwe ili kumanzere kwa bar.



2. Kuchita kumachitidwa Oyang'anira ntchito. Kukhala m'gulu "Masamu"ndikuyang'ana dzina "SUMM"Pangani chisankho chake ndipo dinani pa batani "Chabwino" pansi pazenera ili.



3. Kugwiritsa ntchito ndondomeko yotsutsana ndiwindo. Ikhoza kukhala ndi minda 255 yomwe ili ndi dzina "Nambala". Masamba awa ali ndi zifukwa zogwiritsira ntchito. Koma kwa malo athu gawo limodzi lidzakhala lokwanira.

   Kumunda "Number1" Mukufuna kuika zida zazomwe zili ndi maselo am'mbali "Gulani 1". Izi zatheka mwachidule. Ikani chotsekeramo m'munda wa zenera. Kenaka, mwa kukanikiza batani lamanzere, sankani maselo onsewo. "Gulani 1"zomwe zili ndi mfundo zamtengo wapatali. Adilesiyo inasonyezedwa nthawi yomweyo mu bokosi lotsutsana pamene makonzedwe a gulu akukonzedwa. Dinani pa batani "Chabwino" pansi pazenera.



4. Mtengo wa phindu la masiku asanu ndi awiri kwa sitolo yoyamba idzawonetsedwa nthawi yomweyo mu selo yomwe ili ndi ntchito.



5. Ndiye mukhoza kuchita zofanana ndi ntchitoyi SUM ndi pazitsulo zotsalira za tebulo, kuwerengera momwe ndalamazo zilili masiku asanu ndi awiri m'masitolo osiyanasiyana. Machitidwe a ntchito adzakhala chimodzimodzi ndi omwe atchulidwa pamwambapa.

   Koma pali njira yothandiza kwambiri ntchito. Kuti tichite izi, timagwiritsa ntchito chizindikiro chodzaza. Sankhani selo yomwe ili ndi ntchitoyo. SUM, ndi kutambasula chizindikiro pofanana ndi mutu wazamu mpaka kumapeto kwa tebulo. Monga mukuonera, panopa, ntchitoyi SUM Kukopera mofanana momwe ife tinkakopera kale njira yosavuta ya masamu.



6. Pambuyo pake, sankhani selo lopanda kanthu pa pepala, limene timaganiza kuti tisonyeze zotsatira zonse za mawerengedwe m'masitolo onse. Mofanana ndi njira yapitayi, ikhoza kukhala chinthu chilichonse chapepala. Pambuyo pake, mwadziwika, timayitana Mlaliki Wachipangizo ndi kusamukira ku zenera zotsutsana SUM. Tiyenera kudzaza mundawu "Number1". Monga momwe zinalili kale, timayika malonda mmunda, koma nthawiyi ndi batani lamanzere lomwe limagwiritsidwa ntchito, sankhani mzere wonse wa ndalama zonse zomwe zimagulitsidwa. Pambuyo pa adiresi ya chingwe ichi ngati ndondomeko yowonjezera yalowa muzenera lazenera, dinani pa batani. "Chabwino".



7. Monga mukuonera, kuchuluka kwa ndalama zogulitsa zonse chifukwa cha ntchitoyi SUM Idawonetsedwa mu selo loyambirira.

Koma nthawi zina pamakhala zochitika pamene mukufunika kufotokozera zotsatira zowonongeka zonse popanda kufotokozera zazing'ono za malo ogulitsira. Pamene zikuchitika, woyendetsa SUM ndipo izo zingathe, ndipo yankho la vuto ili ndi losavuta kuposa kugwiritsa ntchito njira yapitayi ya njira iyi.

1. Monga nthawizonse, sankhani selo pa pepala komwe zotsatira zake zidzasonyezedwe. Fuula Mlaliki Wachipangizo dinani pazithunzi "Ikani ntchito".



2. Kutsegulidwa Mlaliki Wachipangizo. Mukhoza kusunthira ku chigawo "Masamu"koma ngati mwangogwiritsa ntchito posachedwapa SUMmonga ife tinatero, ndiye inu mukhoza kukhala mu gululo "Posachedwapa Anagwiritsidwa Ntchito" ndipo sankhani dzina lofunika. Ziyenera kukhala pamenepo. Dinani pa batani "Chabwino".



3. Fesholo yotsutsana ikuyambanso. Ikani cholozera mmunda "Number1". Koma nthawi ino timagwiritsa ntchito batani lamanzere ndikusankha zonse zomwe zilipo, zomwe zili ndi ndalama zogulitsa zonse. Choncho, mundawu uyenera kupeza adiresi yonse ya tebulo. Kwa ife, ili ndi mawonekedwe awa:

   B2: F8

   Koma, ndithudi, pambali iliyonse adiresi idzakhala yosiyana. Chokhazikika nthawi zonse ndi chakuti makonzedwe a selo lakumanzere lakumanzerelo ndilo loyambirira ku adilesiyi, ndipo chinthu cholowera chakumanja chidzakhala chotsiriza. Makonzedwe ameneŵa adzalekanitsidwa ndi colon (:).

   Mndandanda wa adiresi yanu italowa, dinani pa batani "Chabwino".



4. Zitatha izi, zotsatira za kuwonjezereka kwa deta zidzawonetsedwa mu selo losiyana.

Ngati tilingalira njirayi kuchokera pazowona, sitikuyika zipilala, koma zonsezi. Koma zotsatira zake zinakhala zofanana, ngati kuti chigawo chilichonse chinawonjezeka mosiyana.

Koma pali zochitika pamene mukufunika kuwonjezera osati mazenera onse a tebulo, koma ena okhawo. Ntchitoyi imakhala yovuta kwambiri ngati sali malire. Tiyeni tiyang'ane momwe kuwonjezerako kwakukugwiritsidwira ntchito pogwiritsa ntchito opanga SUM ndi chitsanzo cha tebulo lomwelo. Tiyerekeze kuti tikufunikira kuwonjezera pazomwe timapanga "Gulani 1", "Gulani 3" ndi "Gulani 5". Izi zimafuna kuti zotsatirazi ziwerengedwe popanda kuchotsa zigawozo ndi ndondomeko.

1. Ikani cholozera mu selo komwe zotsatira zake ziwonetsedwe. Ikani zowonjezera zowonjezera zowonjezera SUM mwanjira yomweyo momwe izo zinkachitikira kale.

   Muzenera lotseguka m'munda "Number1" lowetsani adiresi ya deta yomwe ili m'ndandanda "Gulani 1". Timachita mofanana ndi poyamba: ikani cholozera m'munda ndikusankha ma tebulo oyenera. M'minda "Number2" ndi "Number3" Momwemo, ife timalowa maadiresi a data arrays muzitsulo "Gulani 3" ndi "Gulani 5". Kwa ife, zowonongeka zolembedwera ndi izi:

   B2: B8
D2: D8
F2: F8

   Ndiye, monga nthawi zonse, dinani pa batani. "Chabwino".



2. Zitatha izi, zotsatira za kuwonjezera kuchuluka kwa ndalama kuchokera m'masitolo atatu pa asanu zidzasonyezedwe mmaguluwo.

PHUNZIRO: Kugwiritsa ntchito Wofalitsa wa Ntchito mu Microsoft Excel

Monga mukuonera, pali njira zitatu zowonjezera mazenera ku Excel: pogwiritsa ntchito galimoto, masamu komanso ntchito SUM. Njira yosavuta komanso yofulumira ndiyo kugwiritsa ntchito galimoto yokwanira. Koma ndizovuta kusintha ndipo sizigwira ntchito nthawi zonse. Njira yosinthasintha kwambiri ndiyo kugwiritsa ntchito masamu a ma masamu, koma sizowonongeka ndipo nthawi zina, ndi deta yambirimbiri, kukhazikitsa kwake mwakhama kungatenge nthawi yambiri. Gwiritsani ntchito ntchito SUM akhoza kutchedwa "golide" pakati pakati pa njira ziwirizi. Njirayi ndi yosasinthasintha komanso yofulumira.