Uburyo bwo Kwagura Imbonerahamwe muri Excel

Iyo ukorana na partshede, rimwe na rimwe birakenewe kugirango wongere ibipimo byabo, kubera ko amakuru yo mubisubizo biva ari mato cyane, bituma bigora gusoma. Mubisanzwe, buriwese andi masomo akomeye cyangwa adakomeye afite mubikoresho bya Arsenal kugirango byongere ameza. Ntabwo rero bitangaje kuburyo bari muri gahunda yo kugwita kuba indako. Reka tubimenye uburyo muriyi porogaramu ushobora kwagura ameza.

Ongera imbonerahamwe

Ugomba guhita uvuga ko bishoboka kongera imbonerahamwe nuburyo bubiri bwingenzi: kwiyongera mubunini bwibintu byihariye (imirongo, inkingi, inkingi, inkingi Mu rubanza rwa nyuma, inzitizi iziyongera. Ihitamo rigabanijwemo uburyo bubiri butandukanye: gupima kuri ecran no ku icapiro. Noneho tekereza kuri buri buryo muburyo burambuye.

Uburyo 1: Ongera ibintu byihariye

Mbere ya byose, tekereza uburyo bwo kongera ibintu kumeza, ni ukuvuga, imirya n'inkingi.

Reka dutangire imirongo yiyongera.

1. Dushiraho indanga kumurongo uhagaze neza kumurongo wo hasi wumugozi duteganya kwaguka. Muri iki gihe, indanga igomba guhinduka umwambi we. Funga buto yimbeba yibumoso hanyuma ukure hasi kugeza ubunini bwumurongo ntuduhaza. Ikintu nyamukuru ntabwo ari ukutiranya icyerekezo, kuko niba uyikuramo, noneho umugozi ugabanuka.



2. Nkuko mubibona, umugozi wagutse, kandi hamwe nacyo cyaguye ameza muri rusange.

Rimwe na rimwe, birasabwa kwagura umurongo umwe, n'umurongo mwinshi cyangwa umurongo wose w'imbonerahamwe yashushanyije amakuru, kubwibi dukora intambwe zikurikira.

1. Kanda buto yimbeba hanyuma uhitemo Umurenge uhuza itsinda rihagaritse ryiyi mirongo dushaka kwaguka.



2. Dushiraho indanga kumupaka wo hasi wumwe murikazi watoranijwe kandi, ufashe buto yimbeba yibumoso, kurambura hasi.



3. Nkuko tubibona, ntabwo ari umurongo wagutse gusa, mumahanga twakwega, ariko izindi mirongo yose yagabanijwe. Muri byumwihariko, urubanza rwacu ni imirongo yimbonerahamwe.

Hariho ubundi buryo bwo kwagura imirya.

1. Turabigaragaza kumwanya uhuza uhuza urwego rwumurongo cyangwa itsinda ryimigozi ushaka kwaguka. Kanda kuri Kugaragaza buto yimbeba iburyo. Ibikubiyemo byatangijwe. Hitamo ikintu "uburebure bwumurongo ...".



2. Nyuma yibyo, idirishya rito ryatangijwe, ryerekana uburebure bwaho bwibintu byatoranijwe. Kugirango wongere uburebure bwimigozi, kandi, kubwibyo, ingano yimbonerahamwe, ugomba kwinjizamo murwegohego hose uruta iyambere. Niba utazi neza uburyo bwo kongera ameza, noneho muriki gihe, gerageza gushiraho ingano uko bishakiye, hanyuma urebe uko bigenda. Niba ibisubizo bitagushimishije, ingano irashobora guhinduka. Rero, tugaragaza agaciro hanyuma ukande kuri buto "OK".



3. Nkuko tubibona, ingano yimirongo yose yatoranijwe yiyongereyeho agaciro runaka.

Ubu duhindukirira amahitamo yo kongera ameza array muguka kwagura inkingi. Nkuko ubishoboye, amahitamo asa niyituweho na gato yongereye gato imirongo.

1. Dushiraho indanga kumupaka ukwiye wumurenge winkingi igiye kwaguka kumurongo wa horizontal. Indanga igomba guhinduka umwambi we. Tubyara clamp buto yimbeba yibumoso hanyuma tukabikurura iburyo kugeza ubunini bwinkingi ihaze.



2. Nyuma yibyo turekura imbeba. Nkuko dushobora kubibona, ubugari bwinkingi yariyongereye, kandi icyarimwe ingano yimbonerahamwe yiyongera.

Nko kubireba imirongo, hariho ubwoko bwiyongera kwibiyongera mubugari bwinkingi.

1. Kanda buto yimbeba hanyuma uhitemo guhuza intebe itambitse hamwe na indanga yumurenge wizo nkingi dushaka kwaguka. Nibiba ngombwa, urashobora guhitamo inkingi zose.



2. Nyuma yibyo, duhinduka kumupaka ukwiye winkingi imwe. Tubyara Clamp ibumoso buto hanyuma tukurura umupaka kugeza iburyo kumupaka wifuzwa.



3. Nkuko ushobora kwitegereza, nyuma yibyo, ubugari bwiyongereye ku nkingi, hamwe numupaka wakorewemo ibikorwa, ariko nanone abandi bavuga.

Mubyongeyeho, hari uburyo bwo kongera inkingi mu kwinjiza ubwinshi bwabo.

1. Hitamo inkingi cyangwa itsinda ryinkingi zigomba kwiyongera. Kugabanuka dukora muburyo bumwe nkuko mubikorwa byabanje. Hanyuma ukande kuri interineti iburyo bwimbeba. Ibikubiyemo byatangijwe. Kanda muri yo ku "bugari bw'inkingi ...".



2. Ifungura hafi yidirishya rimwe ryiruka mugihe hahindutse uburebure. Ikeneye kwerekana ubugari bwifuzwa bwinkingi zatoranijwe.

   Mubisanzwe, niba dushaka kwagura ameza, ubugari bugomba kuba bugaragara kuruta iyindi. Nyuma yo kwerekana agaciro gasabwa, kanda kuri buto "OK".



3. Nkuko tubibona, inkingi zatoranijwe zaguwe ku gaciro kerekanwe, kandi ubunini bw'urutonde bwiyongereye.

Uburyo 2: Gupima kuri monitor

Noneho wige uburyo bwo kongera ubunini bwimbonerahamwe kubipimo.

Ako kanya, twakagombye kumenya ko bishoboka gupima intera kuri ecran, kandi urashobora ku rupapuro rwacapwe. Banza urebe ibyambere muri aya mahitamo.

1. Kugirango wagure urupapuro kuri ecran, ugomba kwimura igipimo kinini iburyo, kirimo mu mfuruka yo hepfo yiburyo bwurubanza.

   

   Cyangwa ukande buto muburyo bwa "+" iburyo bwiki gice cyayi slide.



2. Ibi bizamura ingano atari ameza gusa, ahubwo ni nibindi bintu byose kurupapuro nibyinshi. Ariko twakagombye kumenya ko izi mpinduka zigamije kwerekana gusa kuri monitor. Iyo icapiro ku bunini bw'ameza, ntibazagira ingaruka.

Byongeye kandi, igipimo cyerekanwe kuri monidise kirashobora guhinduka kuburyo bukurikira.

1. Twimukiye kuri tab "kureba" kuri excel ribbon. Kanda kuri buto "Igipimo" mugice cyibikoresho cyizina rimwe.



2. Idirishya rifungura aho hashyizweho impinduka zisanzwe zurugero. Ariko umwe gusa muri bo arenga 100%, ni ukuvuga ubunini busanzwe. Rero, muguhitamo gusa amahitamo "200%", tuzashobora kongera ingano yimbonerahamwe kuri ecran. Nyuma yo guhitamo, kanda buto "OK".

   

   Ariko mu idirishya rimwe hari ubushobozi bwo gushiraho ibyawe, umukoresha. Kugirango ukore ibi, birakenewe gushiraho umwanya wa "ukomoka kuri" mu murima uhateganye na iyi parameter, agaciro k'umubare ku ijana, kizerekana igipimo cy'ameza ari rusange. Mubisanzwe, kugirango wongere ugomba kwinjiza umubare urenze 100%. Umubare ntarengwa wiyongera kugaragara mumeza ni 400%. Nko kubijyanye no gukoresha amahitamo ya perezida, nyuma yo gukora igenamiterere, kanda kuri buto "OK".



3. Nkuko mubibona, ubunini bw'ameza n'urupapuro muri rusange byiyongereye ku gaciro kateganijwe mu buryo bw'imikorere.

Nibyiza rwose ni "igipimo cya" gikemuwe ", kigufasha kongera igipimo cyimbonerahamwe neza kugirango ikoreshwe neza mu idirishya rya Excel.

1. Dutanga amanota kugirango dukomere.



2. Twimukira kuri tab "kureba". Mu itsinda rya "Igipimo", kanda kuri "Igipimo ukoresheje buto yatoranijwe".



3. Nkuko mubibona, nyuma yiki gikorwa, ameza yiyongereye bihagije kugirango ahuze idirishya rya porogaramu. Noneho, muburyo bwihariye, urugero rwacu rwageze ku gaciro ka 171%.

Byongeye kandi, igipimo cyimbonerahamwe yurutonde kandi urupapuro rwose rushobora kwagurwa no gufata buto ya CTRL no gufunga imbeba imbere ("ubwacu ubwacu").

Uburyo 3: Hindura igipimo cyimbonerahamwe ku icapiro

Noneho reka turebe uburyo bwo guhindura ubunini bwimbonerahamwe, ni ukuvuga ubunini bwayo biri ku kashe.

1. Kwimukira muri tab "dosiye".



2. Ibikurikira, jya kuri "icapiro".



3. Mu gice cyo hagati cyidirishya rifungura, Igenamiterere ryanditse riherereye. Hasi cyane muribo ni yo nyirabayazana wo gupima. Mburabuzi, ibipimo "byubu bigomba gushyirwaho. Kanda kuri iki kintu.



4. Urutonde rwibikorwa byo guhitamo. Hitamo umwanya "Igenamiterere ryibipimo ngenderwaho ...".



5. Idirishya rya page ritangira. Mburabuzi, urupapuro rugomba gufungurwa. Aradukeneye. Muri "Igipimo", guhinduranya bigomba gushyirwaho umwanya "wishyire". Mu gace kanyuranye igomba kwinjira mu gipimo wifuza. Mburabuzi, ni 100%. Kubwibyo, kongera imbonerahamwe yameza, dukeneye kwerekana umubare munini. Urubibi ntarengwa, nko muburyo bwambere, ni 400%. Dushiraho ubunini bwa zoom hanyuma ukande buto "OK" hepfo yurupapuro rwa Page Page.



6. Nyuma yibyo, mu buryo bwikora ugaruka kurupapuro rwabapasizi. Ukuntu ameza yagutse azasa, urashobora kureba mukarere kibanza, kirimo mumadirishya amwe kugeza iburyo bwimiterere yicapa.



7. Niba ibintu byose bigukwiriye, urashobora kugaburira imbonerahamwe kuri printer ukanze kuri buto ya "Icapa" yashyizwe hejuru yicyuma.

Hindura igipimo cyimeza mugihe icapiro rishobora kuba ritandukanye.

1. Kwimukira muri tab ya "Mariko". Muri "Shakisha ibikoresho" kuri kaseti hari "igipimo". Mburabuzi, hari agaciro "100%". Kugirango wongere ubunini bwameza mugihe icapiro, ugomba kwinjira mubipimo kuva 100% kugeza 400% muriki gice.



2. Tumaze kubikora, ingano yimbonerahamwe yurwego kandi urupapuro rwiyongereye kurwego rwagenwe. Noneho urashobora kwimukira kuri tab "dosiye" hanyuma utangire gucapa muburyo bumwe byavuzwe mbere.

Isomo: Nigute wandika urupapuro muri excel

Nkuko mubibona, urashobora kwagura ameza muri excel muburyo butandukanye. Nibyo, kandi munsi yikibazo cyo kongera intangarugero birashobora kubera ibintu bitandukanye rwose: kwagura ingano yibintu, byongera igipimo kuri ecran, byongera igipimo cyo gucapa. Ukurikije ko uyikoresha ari ngombwa, agomba guhitamo ibikorwa runaka.