Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel

Akenshi, imbere yabakoreshaga umwanditsi wameza, ikibazo kivuka gifitanye isano no kubara umubare wibipimo ngenderwaho. Muyandi magambo, birakenewe kubara umubare wimirima yinkingi yuzuyemo inyandiko cyangwa amakuru yimibare. Umwanditsi wameza afite gutandukana kwinshi akwemerera gukora iyi miterere.

Uburyo bwo kubara mu nkingi

Ukurikije intego zumukoresha mumyandikire yameza, urashobora gushyira mubikorwa amakuru yose mu nkingi. Tuzasesengura buri kintu muburyo burambuye.

Uburyo 1: Yerekana umubare windangagaciro mumiterere

Ubu buryo nuburyo bworoshye gukoresha. Ishyira mubikorwa kubara amakuru namakuru, ariko ntishobora gukoreshwa mugihe ukora mubihe. Igikorwa rusange Algorithm:

1. Hitamo aho usabwa.
2. Turebe kumurongo wa leta.
3. Twiga umubare w'indangagaciro.

imwe

Uburyo buroroshye gukoresha gusa mugihe ukorana nubunini bwamakuru, ubundi ukeneye gukoresha ubundi buryo. Undi ukuyemo uburyo - ibisubizo biragaragara mugihe cyo kwigunga, ugomba rero gukurwaho cyangwa gufata mu mutwe cyangwa gukemuka ahandi. Intambwe-kuntambwe yo kuyobora kugirango ushireho ikimenyetso cya "Umubare":

1. Kanda PCM kumurongo wumurongo.
2. Ecran yerekana urutonde. Hano birakenewe kugenzura niba ikimenyetso kijyanye na "Umubare". Niba atari byo, bigomba gushyirwa ukanda kuri buto yimbeba yibumoso.

2.

1. YITEGUYE! Noneho ibimenyetso byerekana "umubare" biherereye mumiterere yumurongo wameza.

Uburyo 2: Gushyira mubikorwa imikorere ya RC

Uyu mukoresha ushyira mubikorwa kimwe nkuburyo bwabanjirije, ariko mugihe kimwe wongeyeho ibisubizo. Izindi ntangama zisigaye, kubera ko imikorere ya fagitire idashobora gukorana nibisabwa.

Hariho ubwoko bubiri bwumukoresha:

1. = Akabari (selile1; selile2; ... selile).
2. = Indabyo (selile1: selile).

Muburyo bwa 1, umukoresha arabara buri selile yatoranijwe. Muburyo bwa 2, umubare wurwego rwuzuye ubarwa murwego rwa nimero ya selire 1 kuri selire hamwe numubare N. Intambwe ku ntambwe yo kuntambwe:

1. Turatanga guhitamo akagari aho kubara bizerekanwa.
2. Kwimukira mu gikurikira "formulate". Kanda "Shyiramo imikorere."

3.

1. Ubundi buryo - kanda ahanditse "shyiramo imikorere", biherereye kuruhande rwumurongo kugirango hashyizweho formula.

Bane

1. Agace gato "Shyiramo imikorere" yagaragaye kuri ecran. Fungura urutonde ruri hafi ya "icyiciro". Murutonde rwahagaritswe, hitamo "setiction". Mubikorwa "hitamo:" Umwanya, dusanga umukoresha wa fagitire hanyuma ukande kuri LKM. Nyuma ya manipitions, kanda kuri "Ok".

bitanu

1. Iyerekana ryerekana idirishya ryo kwandika impaka zishinzwe. Hano birakenewe mu kohereza selile cyangwa urutonde rwinjiza kugirango ushireho ingingo. Birakwiye ko tumenya ko intera ishobora gushyirwaho hamwe nizina. Nyuma ya Manipulations yose, kanda kuri "Ok", uherereye munsi yidirishya.

6.

1. YITEGUYE! Kubera iyo mpamvu, twabonye ibisubizo byo kubara muri selile yagenwe. Byazirikanye rwose selile yuzuye.

Uburyo 7: Gukoresha imikorere ya konti

Konti ni nziza yo gukorana nibipimo byumubare. Hariho ubwoko bubiri bwumukoresha:

1. = Konte (selile1; selile2; ... selile).
2. = Konte (selile1: selile).

Intambwe kuntambwe ku giti cye:

1. Turatanga guhitamo akagari aho kubara bizerekanwa.
2. Kwimukira mu gikurikira "formulate". Kanda kuri "Shyiramo imikorere". Ecran yerekana idirishya rito ryitwa "Imikorere yinjiza". Hishura urutonde ruri hafi ya "icyiciro". Murutonde rwahagaritswe, hitamo "setiction". Muri "Guhitamo Imikorere:" Umwanya, Turahasanga konti umukoresha hanyuma ukande kuri lkm. Nyuma ya manipitions, kanda kuri "Ok".

umunani

1. Idirishya ryimpaka zuzuza imirongo ya selile nkenerwa. Nyuma ya Manipulations yose, kanda kuri "Ok", uherereye munsi yidirishya.

icyenda

1. YITEGUYE! Kubera iyo mpamvu, twabonye ibisubizo byo kubara muri selile yagenwe. Hano hafashwe amakuru yuzuye selile, usibye ubusa niyanditse amakuru yinyandiko iherereye.

Uburyo 10 4: Umukoresha 8

Uyu mukoresha aragufasha kubara umubare windangagaciro kubihe byihariye. Muri rusange kubona umukoresha: = 8 (intera; ibipimo).

1. Intera - ibi byerekana agace gakenewe kugirango tubare umubare wa countriction kumiterere yihariye.
2. Ibipimo ni ibintu bisabwa aho duhuriramo bizatandukanya.

Tuzasesengura ibintu byose kurugero runaka. Intambwe kuntambwe ku giti cye:

1. Kurugero, tuzagena umubare wijambo "kwiruka" mu nkingi na siporo. Kwimuka mumurima ugiye kwerekana ibisubizo.
2. Kwimukira mu gikurikira "formulate". Kanda kuri "Shyiramo imikorere". Ecran yerekana idirishya rito ryitwa "Imikorere yinjiza". Hishura urutonde ruri hafi ya "Icyiciro:". Murutonde rwahagaritswe, hitamo "setiction". Muri "Guhitamo Imikorere:" Umwanya, dusanga umukoresha hanyuma ukande kuri lkm. Nyuma ya manipitions, kanda kuri "Ok".

cumi n'umwe

1. Ecran igaragara "imikorere yerekana" idirishya. Murongo rusange, tumenyekanisha imirongo ya selile yitabira kubara. Mumurongo "ibipimo" turabaza uko ubwabwo. Gutwara hano: "Iruka". Nyuma yo gukora manipulations zose, kanda ahantu "OK".

12

1. Umukoresha wabazwe kandi yerekanwe umubare wabagize impanuka mumirima yerekanwe hamwe nijambo "kwiruka". Twabonye impanuka cumi n'itandatu.

13

Reka tugerageze guhindura imiterere kugirango twumve neza umurimo wumukoresha. Intambwe kuntambwe ku giti cye:

1. Reka tubaze izindi ndangagaciro muriyi nkingi, usibye agaciro "kwiruka".
2. Turasubiramo ingingo ya kabiri duhereye ku nyigisho zavuzwe haruguru.
3. Murongo rusange, twinjiza aderesi imwe nko murugero rwavuzwe haruguru. Mu murongo "Kunera" Dutwara ikimenyetso cy'ubusumbane "" mbere yuko Agaciro "Kwiruka". Nyuma ya Manipulations, kanda kuri "Ok".

cumi na bine

1. Nkigisubizo, twakiriye cumi na birindwi - umubare wamagambo mu nkingi yatoranijwe atazirikana ijambo "kwiruka".

Kurangiza gusuzuma uburyo, tumenye uburyo umukoresha akorana nibihe byingenzi ">" na "

1. Gukoresha amabwiriza yavuzwe haruguru, shyiramo uwukoresha kugirango urebe selire ikenewe.
2. Mu murongo wa Range, twinjije imirongo ikenewe ya selile yabatanze. Mu murongo wa "CRETER", andika agaciro "> 350". Nyuma ya Manipulations, kanda kuri "Ok".

cumi na batanu

1. Nkigisubizo, twabonye agaciro ka icumi - umubare wimibare uruta 350 mumifuka yatoranijwe.

16 Ingero zo gukoresha imikorere yimikorere muri Excel

Tuzasesengura urundi rugero kugirango twumve neza akazi ka Operator. Kurugero, dufite ibimenyetso bikurikira hamwe namakuru yo kugurisha:

17.

Intego: Shakisha umubare wibicuruzwa bigurishwa nibicuruzwa biva kuri Samsung. Dukurikiza formula ikurikira: = C3: C17; "Samsung") / A17. Nkigisubizo, tubona ibisubizo bya 40%:

Ibintu 18 byo gukoresha imikorere yimikorere muri Excel

Vuga kubintu bimwe na bimwe byumukoresha:

• Igitabo cyibimenyetso ntacyo gitwaye niba umurongo wubwoko bwinyandiko washyizweho nkibipimo;
• Ibisubizo byo kubara bizaba zeru niba yerekeza kuri selile yubusa cyangwa umurongo wubusa uzatangizwa nkingingo;
• Umukoresha arashobora gukurikizwa nka formula ya array, nikihe umubare wa selile hamwe namakuru ahuye nibihe byinshi bizabaho.

Uburyo 5: Gukoresha umukoresha ni 8 ukora

Umukoresha arari kumwe numurimo wavuzwe haruguru. Biratandukanye kuko bigufasha kongeramo umubare runaka wingingo hamwe nibihe bitandukanye cyangwa bisa. Kurugero, dukeneye kubara umubare wibicuruzwa byagurishijwe mugihe cyibice birenga magana atatu. Byongeye kandi, birakenewe kubara ko igiciro cyibicuruzwa kirenze agaciro k'ibihumbi bitandatu. Intambwe kuntambwe ku giti cye:

1. Turatanga guhitamo akagari aho kubara bizerekanwa.
2. Kwimukira mu gikurikira "formulate". Kanda "Shyiramo imikorere." Ecran yerekana idirishya rito ryitwa "Imikorere yinjiza". Hishura urutonde ruri hafi ya "icyiciro". Murutonde rwahagaritswe, hitamo "setiction". Mubikorwa "hitamo:" Umwanya, dusanga ibimenyetso bya Operator hanyuma tukande kuri LKM. Nyuma ya manipitions, kanda kuri "Ok".

cumi n'icyenda

1. Idirishya rimenyerewe munsi yizina "imikorere yimpaka". Hano, iyo winjiye muburyo bumwe, umurongo mushya uhita uzuza ikindi kintu. Mu murongo "intera 1", dutwara aderesi yinkingi aho amakuru yo kugurisha iherereye. Mu murongo "Imiterere 1", dutwara "> 300". Mu murongo "urwego 2", utware aderesi yinkingi aho amakuru yishyuwe iherereye. Muri "imiterere 2", ongeraho agaciro "> 6000". Nyuma ya Manipulations, kanda kuri "Ok".

makumyabiri

1. Nkigisubizo, twabonye ibisubizo byerekana selile ibereye kubintu byiyongereye byagaragaye murwego rwagenwe. Twabonye umubare wa cumi na kane.

Uburyo bwa 21: Imikorere ya Clamp

Ihitamo rikurikira rigufasha kubara umubare wa selile zubusa. Gushyira mu bikorwa ubu buryo, bukwiranye rwose. Muri rusange kubona umukoresha: = isuku (intera). Intambwe kuntambwe ku giti cye:

1. Turatanga guhitamo akagari aho kubara bizerekanwa.
2. Kwimukira mu gikurikira "formulate". Kanda kuri "Shyiramo imikorere". Ecran yerekana idirishya rito ryitwa "Imikorere yinjiza". Hishura urutonde ruri hafi ya "Icyiciro:". Murutonde rwahagaritswe, hitamo "setiction". Mubikorwa "hitamo:" Umwanya, dusanga umukoresha kugirango usukure hanyuma ukande kuri LKM. Nyuma ya manipitions, kanda kuri "Ok".

22.

1. Muri "Impaka z'imirimo" yagaragaye, dutwara ibintu bikenewe bya selile, hanyuma ukande kuri "Ok".

23.

1. Kubera iyo mpamvu, twabonye ibisubizo aho umubare wa selile zubusa zizerekanwa.

24.

Kubara inyandiko zidasanzwe muri MS Excel

Kurugero, suzuma ikimenyetso gikurikira:25.

Intego: Kubara umubare wibipimo bidasanzwe byanditse muri A7: A15. Kugira ngo dukore ibi, dukoresha formula: = sumpacy ((a15 "") / 8: A15; A15)).

Nigute ushobora kubona indangagaciro zisubiramo muri Excel.

Kurugero, dufite isahani ikurikira:

26.

Kubara indangagaciro zisubiramo, ni ngombwa kumenyekanisha formula ikurikira muri g5: = niba (na $ 5: $ 10; A5)> 1 $); 1). Noneho ukeneye kwigana iyi formula kumurongo wose.

Kubara umubare windangagaciro zisubiramo mu nkingi

Kugirango ubare umubare usabwa wikubye kabiri mu nkingi, ugomba gukora ibi bikurikira:

1. Koresha Twese Uzasohokera kurugero rwavuzwe haruguru. Dutanga guhitamo selile yinkingi.
2. Kuvanga mu idirishya.
3. Muri "hitamo Ubwoko bwanditse:" Umwanya, kanda ku kintu "koresha formula kugirango umenye selile".
4. Mu murongo "Hindura formula kugirango umenye selile zigizwe", gutwara = 8 ($ a: $ a; a5)> 1.

27.

1. YITEGUYE! Twashyize mu bikorwa kubara ibipimo bimwe mu nkingi, kandi nanone byatumye amakuru asubiramo mu yandi mabara.

Kubara umubare wa selile yihariye muri Excel yatanze

Suzuma uyu mwanya kurugero runaka. Dufate ko dufite isahani ikurikira:

28.

Tugenera E2: e5 intera no kumenyekanisha formula: = 8: B3: B19; D2: D5). B3: B19 - selile irimo ibigereranyo, na D2: D5 - selile, aho ibipimo biherereye kubara umubare wa inzandiko. Nkigisubizo, tubona ibisubizo nkibyo:

29.

Umwanzuro

Ubwanditsi bwa Exel Exel ni gahunda yo kugwiza igufasha gukemura umubare munini wibikorwa bitandukanye. Porogaramu itanga imirimo myinshi yemerera kubara umubare windangagaciro muburyo bwagenwe. Buri mukoresha azashobora kwigenga guhitamo uburyo bworoshye bubereye imirimo ye.

Ubutumwa uburyo bwo kubara umubare windangagaciro mu nkingi ya Excel. Uburyo 6 bwo kubara umubare w'indangagaciro muri Eksel Inkingi yagaragaye mbere mu ikoranabuhanga.