Nigute ushobora kugwiza Akagari kuri selile muri Excel

Uburyo 1: Kugwiza Akagari ka Akagari

Kubijyanye no kugwiza selile muri Excel, ntakintu cyihariye, nkuko abaterana bakoze namafaranga. Ishirahamwe ridakenewe cyane, kubera ko iyo ugwiza imibare nini, umukoresha arashobora kubona igisubizo kigomba kuzamurwa murwego hamwe na base. Ariko, kugwiza selile nyinshi imwe kurundi ntakibazo.

1. Mu kagari keza, andika ikimenyetso "=", bisobanura intangiriro ya formula.



2. Shyira ahagaragara selile yambere kugirango izina ryayo ryerekanwe nyuma yikimenyetso cyuburinganire.



3. Shira ikimenyetso "*" cyerekana kugwiza.



4. Muri ubwo buryo, byerekana selile ya kabiri kandi wemeze ibyaremwe bya formula ukanda urufunguzo rwa Enter.



5. Noneho muri selile ibisubizo bizerekanwa, kandi formula ubwayo irerekanwa mumigozi iri hejuru.



6. Urashobora kongeramo selile nyinshi zo kugwira cyangwa guhuza ibikorwa bitandukanye byimibare, ariko tekereza ko gahunda ifite imipaka yo kwerekana imibare minini.

Iyo ngingo irangiye, hasobanuwe kubibazo bifitanye isano no kugwiza ingirabuzimafatizo, niba rero hari ikintu cyatsinzwe, uhita gifungura iki gice kandi ushake uburyo bukwiye bwo kwishyura.

Uburyo 2: Kugwiza kwa selire numubare

Niba ushobora kugwiza selile imwe kurindi, bivuze ko ntakintu kibabaza nka selile ya kabiri kugirango asimbuze umubare ukenewe. Noneho formula izaba irindi, ariko ntabwo ari imbere.

1. Injira ibikubiye mumurongo kimwe no kwerekanwa muburyo bwambere, ariko ntuzuzuze amakuru kuri selire ya kabiri.



2. Ahubwo, ongeraho ikimenyetso cyo kugwiza hanyuma wandike umubare kubikorwa byimibare.



3. Guhindura byuzuye ukanze kuri Enter, urebe ibyabaye amaherezo.

Nanone guhuza ingirabuzimafatizo mu zindi selile n'umubare cyangwa ongeraho ibindi bikorwa by'imibare, utibagiwe gukurikirana urukurikirane rwabo. Niba ukeneye gushyira ikintu muburyo bwibanze, koresha utwugarizo kugirango ukoreshe ibikorwa. Gufata amajwi nkaya muburyo bwiza rwose byubahiriza amategeko asanzwe yimibare.

Uburyo 3: Kugwiza buri gihe

Guhora byitwa umubare uhoraho, kandi mubireba selile mumeza ya elegitoroniki, ikora nkibiciro bikwiye. Kugira ngo ukore ibi, koresha ikimenyetso "$" cyerekana ibyaremwe byahoraho. Noneho, iyo kwimura ameza cyangwa kuyandukure, selile ntizigera yimuka. Niba ibintu byose bisobanutse neza kubyerekeranye na formulaire, hanyuma usome kubyerekeye gukosorwa kwa selire muri imwe mu ngingo ikurikira.

Soma byinshi: Ongeraho amadolari muri Microsoft Excel

Gukemura ibibazo bishoboka hamwe no kugwiza selire

Ibibazo hafi ya byose bivuka mugihe ugerageza kugwiza indangagaciro cyangwa kurema izindi formulaire muri excel zifitanye isano nuburyo bwamategeko. Kugenzura no gukosora iki kibazo, urashobora gusoma ingingo ya tishigitire kurubuga rwacu, witange kugirango ukemure umubare wo kubara amafaranga, ariko nanone ukwiranye mubuzima bugezweho.

Soma birambuye: Gukemura ikibazo cyo kubara ingano ya selile zatoranijwe muri Microsoft Excel