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 mumiterereUbu buryo nuburyo bworoshye gukoresha. Ishyira mubikorwa kubara amakuru namakuru, ariko ntishobora gukoreshwa mugihe ukora mubihe. Igikorwa rusange Algorithm:
- Hitamo aho usabwa.
- Turebe kumurongo wa leta.
- Twiga umubare w'indangagaciro.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_1](/userfiles/21/11232_1.webp)
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":
- Kanda PCM kumurongo wumurongo.
- Ecran yerekana urutonde. Hano birakenewe kugenzura niba ikimenyetso kijyanye na "Umubare". Niba atari byo, bigomba gushyirwa ukanda kuri buto yimbeba yibumoso.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_2](/userfiles/21/11232_2.webp)
- YITEGUYE! Noneho ibimenyetso byerekana "umubare" biherereye mumiterere yumurongo wameza.
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:
- = Akabari (selile1; selile2; ... selile).
- = 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:
- Turatanga guhitamo akagari aho kubara bizerekanwa.
- Kwimukira mu gikurikira "formulate". Kanda "Shyiramo imikorere."
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_3](/userfiles/21/11232_3.webp)
- Ubundi buryo - kanda ahanditse "shyiramo imikorere", biherereye kuruhande rwumurongo kugirango hashyizweho formula.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_4](/userfiles/21/11232_4.webp)
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_5](/userfiles/21/11232_5.webp)
- 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.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_6](/userfiles/21/11232_6.webp)
- YITEGUYE! Kubera iyo mpamvu, twabonye ibisubizo byo kubara muri selile yagenwe. Byazirikanye rwose selile yuzuye.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_7](/userfiles/21/11232_7.webp)
Konti ni nziza yo gukorana nibipimo byumubare. Hariho ubwoko bubiri bwumukoresha:
- = Konte (selile1; selile2; ... selile).
- = Konte (selile1: selile).
Intambwe kuntambwe ku giti cye:
- Turatanga guhitamo akagari aho kubara bizerekanwa.
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_8](/userfiles/21/11232_8.webp)
- Idirishya ryimpaka zuzuza imirongo ya selile nkenerwa. Nyuma ya Manipulations yose, kanda kuri "Ok", uherereye munsi yidirishya.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_9](/userfiles/21/11232_9.webp)
- YITEGUYE! Kubera iyo mpamvu, twabonye ibisubizo byo kubara muri selile yagenwe. Hano hafashwe amakuru yuzuye selile, usibye ubusa niyanditse amakuru yinyandiko iherereye.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_10](/userfiles/21/11232_10.webp)
Uyu mukoresha aragufasha kubara umubare windangagaciro kubihe byihariye. Muri rusange kubona umukoresha: = 8 (intera; ibipimo).
- Intera - ibi byerekana agace gakenewe kugirango tubare umubare wa countriction kumiterere yihariye.
- Ibipimo ni ibintu bisabwa aho duhuriramo bizatandukanya.
Tuzasesengura ibintu byose kurugero runaka. Intambwe kuntambwe ku giti cye:
- Kurugero, tuzagena umubare wijambo "kwiruka" mu nkingi na siporo. Kwimuka mumurima ugiye kwerekana ibisubizo.
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_11](/userfiles/21/11232_11.webp)
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_12](/userfiles/21/11232_12.webp)
- Umukoresha wabazwe kandi yerekanwe umubare wabagize impanuka mumirima yerekanwe hamwe nijambo "kwiruka". Twabonye impanuka cumi n'itandatu.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_13](/userfiles/21/11232_13.webp)
Reka tugerageze guhindura imiterere kugirango twumve neza umurimo wumukoresha. Intambwe kuntambwe ku giti cye:
- Reka tubaze izindi ndangagaciro muriyi nkingi, usibye agaciro "kwiruka".
- Turasubiramo ingingo ya kabiri duhereye ku nyigisho zavuzwe haruguru.
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_14](/userfiles/21/11232_14.webp)
- Nkigisubizo, twakiriye cumi na birindwi - umubare wamagambo mu nkingi yatoranijwe atazirikana ijambo "kwiruka".
Kurangiza gusuzuma uburyo, tumenye uburyo umukoresha akorana nibihe byingenzi ">" na "
- Gukoresha amabwiriza yavuzwe haruguru, shyiramo uwukoresha kugirango urebe selire ikenewe.
- Mu murongo wa Range, twinjije imirongo ikenewe ya selile yabatanze. Mu murongo wa "CRETER", andika agaciro "> 350". Nyuma ya Manipulations, kanda kuri "Ok".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_15](/userfiles/21/11232_15.webp)
- Nkigisubizo, twabonye agaciro ka icumi - umubare wimibare uruta 350 mumifuka yatoranijwe.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_16](/userfiles/21/11232_16.webp)
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%:
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_17](/userfiles/21/11232_17.webp)
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.
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:
- Turatanga guhitamo akagari aho kubara bizerekanwa.
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_18](/userfiles/21/11232_18.webp)
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_19](/userfiles/21/11232_19.webp)
- Nkigisubizo, twabonye ibisubizo byerekana selile ibereye kubintu byiyongereye byagaragaye murwego rwagenwe. Twabonye umubare wa cumi na kane.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_20](/userfiles/21/11232_20.webp)
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:
- Turatanga guhitamo akagari aho kubara bizerekanwa.
- 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".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_21](/userfiles/21/11232_21.webp)
- Muri "Impaka z'imirimo" yagaragaye, dutwara ibintu bikenewe bya selile, hanyuma ukande kuri "Ok".
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_22](/userfiles/21/11232_22.webp)
- Kubera iyo mpamvu, twabonye ibisubizo aho umubare wa selile zubusa zizerekanwa.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_23](/userfiles/21/11232_23.webp)
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:
- Koresha Twese Uzasohokera kurugero rwavuzwe haruguru. Dutanga guhitamo selile yinkingi.
- Kuvanga mu idirishya.
- Muri "hitamo Ubwoko bwanditse:" Umwanya, kanda ku kintu "koresha formula kugirango umenye selile".
- Mu murongo "Hindura formula kugirango umenye selile zigizwe", gutwara = 8 ($ a: $ a; a5)> 1.
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_24](/userfiles/21/11232_24.webp)
- 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:
![Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel. Inzira 6 zo kubara umubare windangagaciro mu nkingi ya ekstel 11232_25](/userfiles/21/11232_25.webp)
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.