Kuzenguruka nimero muri Excel: 4 imyambarire yakazi

Mugihe ukora ibice cyangwa akazi hamwe numubare ucuruza, excel itanga ibizunguruka. Ibi biteganijwe, mbere ya byose, hamwe nukuri kuba imibare ihuriweho rwose ni gake cyane mugihe bibaye ngombwa, ariko ntabwo byoroshye gukora hamwe nimvugo nini hamwe nibimenyetso byinshi nyuma ya koma. Mubyongeyeho, hari umubare ushingiye kuhame ntabwo uzengurutse neza. Mugihe kimwe, kuzenguruka rwose birashobora kuganisha kumakosa atoroshye aho bisabwa. Kubwamahirwe, gahunda ifite amahirwe yo gushiraho abakoresha bonyine, uburyo imibare izazunguruka.

Ibiranga imibare izenguruka excel

Imibare yose hamwe nibihe Microsoft imirimo bigabanijwemo neza kandi ugereranije. Ububiko bubikwa murwibukwa kugeza kuri 15, kandi bwerekanwa mbere yo gusohoka, bizagaragaza umukoresha ubwacyo. Ibibara byose bikorwa hakurikijwe ibitswe mu mutwe, kandi ntigaragazwa kuri monitor ya data.

Ukoresheje imikorere yo kuzenguruka, excel yajugunye umubare munini wa semicolon. Ikoresha muburyo rusange bwemewe, mugihe umubare uri munsi ya 5 uzengurutse kuruhande ruto, kandi kurenza cyangwa uhwanye na 5 - kuruhande rwinshi.

Kuzenguruka hamwe na buto kuri rubbon

Inzira yoroshye yo guhindura kuzenguruka ni ukugaragaza selile cyangwa itsinda rya selile kandi, mugihe kuri tab ya home, kanda kuri kaseti kugeza kuri "kwagura binini" cyangwa "kugabanya cyane". Utubuto twombi ruherereye muri "umubare" wibikoresho. Gusa umubare werekanwe uzazunguruka, ariko wo kubara, nibiba ngombwa, imibare igera kuri 15 yimibare izabigiramo uruhare.

Iyo ukanze kuri buto "kwagura binini", umubare winyuguti wakozwe nyuma yuko koma yiyongera.

Akabuto ka "Kugabanya", kunyuranye, bigabanya imibare imwe nyuma ya koma.

Kuzenguruka binyuze muburyo bwamagari

Birashoboka kandi gushiraho kuzenguruka ukoresheje imiterere yimiterere. Kugirango ukore ibi, hitamo intera ya selile kurupapuro, kanda kuri buto yimbeba iburyo hanyuma uhitemo "imiterere yingabo" muri menu igaragara.

Muburyo bwa selire igenamiterere ifungura, jya kuri tab "umubare". Niba imiterere yamakuru idasobanuwe, birakenewe kubishyira hanze, bitabaye ibyo ntuzashobora kugengwa. Mu gice cyo hagati yidirishya hafi yanditse "umubare wibimenyetso bya cumi" byerekana gusa umubare wibimenyetso ushaka kubona mugihe uzengurutse. Nyuma yibyo gukoresha impinduka.

Gushiraho Kubara neza

Niba mubihe byabanjirije iyi, ibice byashizweho byagize ingaruka kumakuru yo hanze gusa, kandi mugihe cyo kubara, ibimenyetso byinshi byakoreshejwe (kugeza ku nyuguti 15), noneho tuzakubwira uburyo bwo guhindura ukuri kubara.

1. Kanda ahanditse File kuva aho ngaho kugeza kuri "ibipimo".



2. Idirishya rya Portl Excel rifungura. Muri iri dirishya, jya kuri disikaction "bidashoboka". Shira igenamiterere ryitwa "mugihe usubiramo iki gitabo". Igenamiterere muriki gice ntirikoreshwa kurupapuro rumwe, ahubwo ni igitabo muri rusange, ni ukuvuga kuri dosiye yose. Shira agasanduku imbere ya "Shiraho ukuri nko kuri ecran" parameter hanyuma ukande OK.



3. Noneho, iyo kubara amakuru, nimero yerekanwe kuri ecran izatabwaho, ntabwo arimwe ubitswe murwibutso rwa Excel. Igenamiterere rya nimero yerekanwe rirashobora gukorwa muburyo bumwe na bumwe twavuze hejuru.

Gushyira mu bikorwa imirimo

Niba ushaka guhindura agaciro ko kuzenguruka mubara imwe cyangwa nyinshi, ariko ntushake kugabanya ukuri kwabarwa muri rusange, mugihe ari byiza gukoresha imikorere "yazengurutse" Kandi itandukaniro ritandukanye, kimwe nindi mirimo.

Mubikorwa byingenzi bigenga kuzenguruka bigomba guterwa kuburyo bukurikira:

• "Kuzenguruka" - kuzenguruka ku mubare wagenwe wibimenyetso icumi ukurikije amategeko azemewe muri rusange;
• "Intara yo hejuru" - kuzenguruka kugeza ku mubare wegereye hejuru ya module;
• "Roungedlice" - kuzenguruka kugeza ku mubare wegereye hasi ya module;
• "Uruziga" - ruzenguruka umubare ufite ukuri runaka;
• "Okrwp" - kuzenguruka umubare hamwe nukuri byatanzwe kuri module;
• "Okrvnis" - kuzenguruka umubare wa module ifite ukuri runaka;
• "Otbr" - kuzenguruka amakuru ku musemari;
• "Urukiko" - ruzenguruka amakuru ku mubare;
• "Ikibazo" - kizenguruka amakuru ku mubare udasanzwe.

Kubikorwa bya "uruziga", "Rounger" na "Roungedlice" bikoresha imiterere yinjira: izina ryimikorere (umubare; umubare; umubare wibice). Ni ukuvuga, niba wowe, kurugero, ushaka kuzenguruka nimero 2,56896 kugeza kuri itatu, hanyuma ukoreshe imikorere "yazengurutse (2,56896; 3)". Nkigisubizo, bizimya umubare 2.569.

Kubikorwa "Akarere ka Akarere ka", "okrwp" na "okrvis" ibi bikoreshwa na formulaire izenguruka: izina ryimikorere (umubare; umubare; wukuri). Noneho, kuzenguruka nimero 11 kugeza kumubare wegereye, benshi 2, twinjije imikorere "Akarere (11; 2)". Ibisohoka bibona ibisubizo 12.

Imikorere ya "Otbr", "ndetse" na "na" imyenda imwe "ikoresha imiterere ikurikira: Izina ryimikorere (nimero). Kugirango tugere ku mubare wa 17 kugeza hafi ndetse, dukoresha imikorere "Urukiko (17)". Twabonye ibisubizo 18.

Imikorere irashobora kwinjizwa haba mukagari no kumurongo, nyuma yo guhitamo selile aho bizabaho. Mbere yuko buri gikorwa kigomba gushyirwaho "=".

Hariho uburyo butandukanye bwo kumenyekanisha imirimo yo kuzenguruka. Nukuri byoroshye gukoresha mugihe hari ameza ufite indangagaciro ukeneye guhindura imibare izengurutse mumikino itandukanye.

1. Jya kuri tab "formulaire" hanyuma ukande buto "imibare". Kurutonde rufungura, hitamo imikorere ikwiye, kurugero, "kuzenguruka".



2. Nyuma yibyo, idirishya ryinganda rifungura. Muri "Umubare", urashobora kwinjiza umubare wintoki, ariko niba dushaka guhita uzenguruka amakuru yimeza yose, hanyuma ukande kuri buto iburyo bwidirishya ryintangiriro.



3. Idirishya ryibiganiro ryimikorere irabitswe. Noneho kanda kuri selile yo hejuru yinkingi amakuru yabo tugiye kuzenguruka. Nyuma y'agaciro byinjijwe mu idirishya, kanda kuri buto iburyo bwagaciro.



4. Idirishya ryibiganiro byongeye gufungura. Muri "umubare wo gusohora" umurima, andika bike dukeneye kugabanya uduce no gushyira mu bikorwa impinduka.



5. Umubare uzengurutse. Kugirango uzenguruke hamwe nandi makuru yose yinkingi yifuzwa, uzane indanga iburyo bwiburyo bwa selile hamwe na gato kangana, hanyuma uyambuke kugeza kumpera yimbonerahamwe.



6. Noneho indangagaciro zose mu nkingi zizazunguruka.

Nkuko mubibona, hariho inzira ebyiri zingenzi zo kwerekana kwerekana umubare: ukoresheje buto ya kaseti kandi muguhindura ibipimo byuburyo bwa selire. Mubyongeyeho, urashobora guhindura uruziga rwamakuru yabazwe mubyukuri. Irashobora kandi gukorwa muburyo butandukanye: Hindura igenamiterere ryigitabo muri rusange cyangwa gukoresha imirimo idasanzwe. Guhitamo uburyo runaka biterwa nuko ugiye gukoresha ubwoko busa bwo kuzenguruka amakuru yose muri dosiye cyangwa gusa kubijyanye na selile.