Kugawanika mu Excel. Momwe magawano amagwirira ntchito mu Excel

Excel ndi pulogalamu yogwira ntchito kwambiri. Itha kugwiritsidwa ntchito ngati mtundu wamapulogalamu komanso ngati chowerengera chogwira ntchito kwambiri chomwe chimakulolani kuwerengera chilichonse. Lero tiwona kagwiritsidwe kachiwiri ka pulogalamuyi, komwe ndi kugawa manambala.

Ichi ndi chimodzi mwazinthu zomwe zimagwiritsidwa ntchito kwambiri pamasamba, pamodzi ndi masamu ena monga kuwonjezera, kuchotsa, ndi kuchulukitsa. M'malo mwake, kugawikana kuyenera kuchitika pafupifupi masamu aliwonse. Amagwiritsidwanso ntchito powerengera ziwerengero, ndipo pa izi purosesa ya spreadsheet imagwiritsidwa ntchito nthawi zambiri.

Kugawanitsa luso mu Excel spreadsheet

Mu Excel, mutha kubweretsa zida zingapo nthawi imodzi kuti mugwire ntchitoyi, ndipo lero tipereka zomwe zimagwiritsidwa ntchito nthawi zambiri. Uku ndiko kugwiritsa ntchito ma fomu omwe amawonetsa molunjika pamakhalidwe (omwe ndi manambala kapena ma adilesi a maselo) kapena kugwiritsa ntchito ntchito yapadera kuti achite masamuwa.

Kugawa nambala ndi nambala

Iyi ndiye njira yoyambira kwambiri yochitira masamu mu Excel. Imachitidwa mofanana ndi pa chowerengera wamba kuti amathandiza athandizira masamu mawu. Kusiyana kokha ndiko kuti musanalowe manambala ndi zizindikiro za ogwiritsira ntchito masamu, muyenera kulowa = chizindikiro, chomwe chidzawonetsa pulogalamu yomwe wogwiritsa ntchitoyo akufuna kulowa mu fomu. Kuti mugwire ntchito yogawa, muyenera kugwiritsa ntchito / chizindikiro. Tiyeni tiwone momwe izi zimagwirira ntchito. Kuti muchite izi, tsatirani njira zomwe zafotokozedwa m'bukuli:

1. Timadina mbewa pa selo iliyonse yomwe ilibe data (kuphatikiza ma fomula omwe amapereka zotsatira zopanda kanthu kapena zilembo zosasindikizidwa).
2. Kulowetsa kungatheke m'njira zingapo. Mutha kuyamba mwachindunji kulemba zilembo zofunika, kuyambira ndi chikwangwani chofanana, ndipo pali mwayi woti mulowetse fomuyo mwachindunji pamzere wolowera, womwe uli pamwambapa.
3. Mulimonsemo, choyamba muyenera kulemba = chizindikiro, ndiyeno lembani nambala kuti mugawidwe. Pambuyo pake, timayika chizindikiro cha slash, kenako timalemba pamanja nambala yomwe magawowo adzagwiritsire ntchito.
4. Ngati pali zogawanitsa zingapo, zitha kuwonjezeredwa wina ndi mnzake pogwiritsa ntchito ma slashes owonjezera.
5. Kuti mulembe zotsatira, muyenera kukanikiza batani Lowani. Pulogalamuyi imangopanga mawerengedwe onse ofunikira.

Tsopano tikuwona ngati pulogalamuyo yalemba mtengo wolondola. Ngati zotsatira zake zikhala zolakwika, pali chifukwa chimodzi chokha - kulowetsa molakwika. Pankhaniyi, muyenera kukonza. Kuti muchite izi, dinani pamalo oyenera mu bar ya formula, sankhani ndikulemba mtengo womwe uli wolondola. Pambuyo pake, dinani batani lolowetsa, ndipo mtengowo udzawerengedwanso.

Zochita zina zitha kugwiritsidwanso ntchito pochita masamu. Akhoza kuphatikizidwa ndi magawano. Pankhaniyi, ndondomekoyi idzakhala momwe iyenera kukhalira malinga ndi malamulo a masamu:

1. Ntchito yogawa ndi kuchulukitsa imachitika poyamba. Kuwonjezera ndi kuchotsa kumabwera kachiwiri.
2. Mawu amathanso kuikidwa m'makolo. Pankhaniyi, iwo adzakhala patsogolo, ngakhale ali ndi ntchito kuwonjezera ndi kuchotsa.

Tonse tikudziwa kuti, molingana ndi malamulo oyambira masamu, kugawa ndi ziro sikutheka. Ndipo chingachitike ndi chiyani ngati tiyesera kuchita chimodzimodzi mu Excel? Apa, cholakwika "#DIV/0!" idzaperekedwa.

Gawo la data la cell

Pang'onopang'ono tikupanga zinthu kukhala zovuta. Bwanji ngati, mwachitsanzo, tifunikira kulekanitsa maselo pakati pawo? Kapena ngati mukufunikira kugawa mtengo womwe uli mu selo linalake ndi nambala inayake? Ndiyenera kunena kuti mawonekedwe a Excel amapereka mwayi wotere. Tiyeni tione mwatsatanetsatane mmene tingachitire zimenezi.

1. Timadina pa selo iliyonse yomwe ilibe mfundo zilizonse. Mofanana ndi chitsanzo chapitachi, muyenera kuonetsetsa kuti palibe zilembo zosasindikizidwa.
2. Kenako, lowetsani fomula yolowera chizindikiro =. Pambuyo pake, timadina kumanzere pa selo lomwe lili ndi mtengo woyenerera.
3. Kenako lowetsani chizindikiro chogawa (slash).
4. Kenako sankhaninso selo lomwe mukufuna kuligawa. Kenako, ngati pakufunika, lowetsaninso slash ndikubwereza masitepe 3-4 mpaka kuchuluka kwa mikangano kulowetsedwa.
5. Mawuwo akalowetsedwa kwathunthu, dinani Enter kuti muwonetse zotsatira patebulo.

Ngati mukufuna kugawa nambala ndi zomwe zili mu selo kapena zomwe zili mu selo ndi nambala, ndiye kuti izi zikhoza kuchitika. Pankhaniyi, m'malo mongodina batani lakumanzere pa cell yofananira, muyenera kulemba nambala yomwe idzagwiritsidwe ntchito ngati gawo kapena gawo. Mutha kuyikanso ma adilesi a foni kuchokera pa kiyibodi m'malo mwa manambala kapena kudina mbewa.

Kugawaniza ndime

Excel imakulolani kuti mugwire ntchito yogawa ndime imodzi ndi ina. Ndiko kuti, nambala ya gawo limodzi idzagawidwa ndi chowerengera cha gawo lomwe lili pafupi nalo. Sizitenga nthawi yochuluka kuti tichite izi, chifukwa momwe ntchitoyi imachitikira ndi yosiyana pang'ono, mofulumira kwambiri kusiyana ndi kungogawanitsa mawu amodzi. Zoyenera kuchita?

1. Dinani pa selo pomwe zotsatira zomaliza zomaliza zidzawonetsedwa. Pambuyo pake, lowetsani fomula lolowera chizindikiro =.
2. Pambuyo pake, dinani kumanzere pa selo yoyamba, ndiyeno mugawe mu yachiwiri monga momwe tafotokozera pamwambapa.
3. Kenako dinani batani lolowera.

Pambuyo pochita ntchitoyi, mtengowo udzawonekera mu selo lofanana. Mpaka pano zonse zili monga tafotokozera pamwambapa.

Pambuyo pake, mutha kuchitanso chimodzimodzi pama cell otsatirawa. Koma ili si lingaliro lothandiza kwambiri. Ndikwabwino kugwiritsa ntchito chida chapadera chotchedwa autocomplete marker. Ili ndi lalikulu lomwe likuwoneka kumunsi kumanja kwa selo yosankhidwa. Kuti mugwiritse ntchito, muyenera kusuntha cholozera cha mbewa pamwamba pake. Mfundo yakuti zonse zachitika molondola zingapezeke mwa kusintha muvi kukhala mtanda. Pambuyo pake, dinani batani lakumanzere la mbewa ndikuyiyika pansi, kokerani chilinganizo kumaselo onse otsala.

Pambuyo pochita opaleshoniyi, timapeza gawo lodzaza ndi deta yofunikira.

Chidwi. Mutha kusuntha fomula mbali imodzi ndi chogwirira cha AutoComplete. Mutha kusamutsa mitengo kuchokera pansi kupita pamwamba komanso kuchokera pamwamba mpaka pansi. Pamenepa, ma adilesi a selo adzasinthidwa ndi awa.

Makinawa amakulolani kuti muwerenge zolondola m'maselo otsatirawa. Komabe, ngati mukufuna kugawa ndime ndi mtengo womwewo, njirayi idzachita molakwika. Izi ndichifukwa chakuti mtengo wa nambala yachiwiri udzasintha nthawi zonse. Choncho, muyenera kugwiritsa ntchito njira yachinayi kuti zonse zikhale zolondola - kugawaniza ndime ndi nthawi zonse (chiwerengero chokhazikika). Koma kawirikawiri, chida ichi ndi chosavuta kugwiritsa ntchito ngati ndime ili ndi mizere yambiri.

Kugawa mzati mu selo

Ndiye, nchiyani chomwe chiyenera kuchitidwa kuti mugawe gawo lonse ndi mtengo wokhazikika? Kuti muchite izi, muyenera kulankhula za mitundu iwiri ya maadiresi: wachibale ndi mtheradi. Zoyamba ndi zomwe tafotokozazi. Fomuyo ikangokopedwa kapena kusamukira kumalo ena, maulalo achibale amasinthidwa kukhala oyenera.

Komano, zolozera zenizeni zimakhala ndi adilesi yokhazikika ndipo sizisintha mukasamutsa fomula pogwiritsa ntchito kope-paste kapena chikhomo chodzaza zokha. Ndi chiyani chomwe chiyenera kuchitidwa kuti mugawe gawo lonse kukhala selo limodzi (mwachitsanzo, lingakhale ndi kuchuluka kwa kuchotsera kapena kuchuluka kwa ndalama za chinthu chimodzi)?

1. Timadina mbewa yakumanzere pa cell yoyamba yagawo momwe tiwonetsera zotsatira za masamu. Pambuyo pake, timalemba fomula yolowera, dinani pa selo loyamba, chizindikiro cha magawo, chachiwiri, ndi zina zotero malinga ndi dongosolo. Pambuyo pake, timalowetsa chokhazikika, chomwe chidzakhala mtengo wa selo linalake.
2. Tsopano muyenera kukonza ulalo posintha adilesi kuchokera pachibale kupita ku mtheradi. Timapanga mbewa kudina mosalekeza. Pambuyo pake, muyenera kukanikiza kiyi F4 pa kiyibodi kompyuta. Komanso, pama laputopu ena, muyenera kukanikiza batani Fn + F4. Kuti mumvetse ngati mukufuna kugwiritsa ntchito kiyi kapena kuphatikiza, mutha kuyesa kapena kuwerenga zolemba zovomerezeka za wopanga laputopu. Tikasindikiza kiyi iyi, tiwona kuti adilesi ya selo yasintha. Anawonjezera chizindikiro cha dollar. Amatiuza kuti adiresi yeniyeni ya selo imagwiritsidwa ntchito. Muyenera kuwonetsetsa kuti chizindikiro cha dola chayikidwa pafupi ndi chilembo cha mzere ndi nambala ya mzere. Ngati pali chizindikiro cha dola imodzi yokha, ndiye kuti kukonzako kudzachitika molunjika kapena molunjika.
3. Kenako, kuti mutsimikize zotsatira zake, dinani batani lolowera, kenako gwiritsani ntchito chizindikiro cha autofill kuti muchite izi ndi ma cell ena omwe ali mugawoli.
4. Tikuwona zotsatira zake.

Momwe mungagwiritsire ntchito ntchito ya PRIVATE

Palinso njira ina yochitira magawano - kugwiritsa ntchito ntchito yapadera. Mawu ake ndi awa: =GAWO(nambala, denominator). Sizingatheke kunena kuti ndi bwino kuposa woyendetsa magawano muzochitika zonse. Zoona zake n’zakuti imazungulira yotsalayo kukhala nambala yaing’ono. Ndiko kuti, kugawanika kukuchitika popanda chotsalira. Mwachitsanzo, ngati zotsatira za kuwerengera pogwiritsa ntchito woyendetsa (/) ndi nambala 9,9, ndiye kuti mutatha kugwiritsa ntchito ntchitoyi. PRIVATE mtengo 9 udzalembedwa ku selo. Tiyeni tifotokoze mwatsatanetsatane momwe tingagwiritsire ntchito ntchitoyi:

1. Dinani pa selo kumene zotsatira za kuwerengera zidzalembedwa. Pambuyo pake, tsegulani bokosi la dialog lowetsani (kuti muchite izi, dinani batani la "Insert ntchito", lomwe lili pomwepo kumanzere pafupi ndi mzere wolowetsa formula). Batani ili likuwoneka ngati zilembo ziwiri zachilatini fx.
2. Bokosi la zokambirana likawoneka, muyenera kutsegula mndandanda wathunthu wa zilembo, ndipo kumapeto kwa mndandanda padzakhala woyendetsa. PRIVATE. Timasankha izo. Pansipa palembedwa tanthauzo lake. Komanso, wogwiritsa ntchito amatha kuwerenga mwatsatanetsatane momwe angagwiritsire ntchito ntchitoyi podina ulalo wa "Thandizo la ntchitoyi". Mukamaliza masitepe onsewa, tsimikizirani zomwe mwasankha podina batani la OK.
3. Zenera lina lidzatsegulidwa kutsogolo kwathu, momwe muyenera kulowa nambala ndi denominator. Simungathe kulemba manambala okha, komanso maulalo. Chilichonse chimakhala chofanana ndi magawo amanja. Timayang'ana momwe deta idasonyezedwera molondola, ndikutsimikizira zomwe tachita.

Tsopano tikuwona ngati magawo onse adalowetsedwa bwino. Kuthyolako kwa moyo, simungatchule bokosi la zokambirana, koma ingogwiritsani ntchito mzere wolowera, ndikulemba ntchitoyo ngati =Zachinsinsi(81), monga momwe tawonetsera pa chithunzi pansipa. Nambala yoyamba ndi manambala ndipo yachiwiri ndi denominator.

Zotsutsana za ntchito zimasiyanitsidwa ndi semicolons. Ngati fomulayo idalowetsedwa molakwika, mutha kuyikonza posintha mzere wolowetsa. Chifukwa chake, lero taphunzira momwe tingachitire magawano m'njira zosiyanasiyana mu Excel. Palibe chovuta mu izi, monga tikuwonera. Kuti muchite izi, muyenera kugwiritsa ntchito gawo logawa kapena ntchito PRIVATE. Yoyamba imawerengera mtengo mofanana ndendende ndi chowerengera. Wachiwiri angapeze nambala popanda chotsalira, chomwe chingakhalenso chothandiza powerengera.

Onetsetsani kuti mwayeserera musanagwiritse ntchito izi pochita zenizeni. Zoonadi, palibe zovuta muzochitazi, koma kuti munthu waphunzira chinachake anganene kokha pamene akuchita zolondola zochita basi, ndi kupanga zisankho intuitively.