Imikorere yo kubaka muri Excel

Imwe mubikorwa byimibare yakunze gukoreshwa mubuhanga nibindi bikaba ni ukugaragaza umubare murwego rwa kabiri, rutandukanye muri kare. Kurugero, ubu buryo burabara ahantu hantu cyangwa ishusho. Kubwamahirwe, nta gikoresho gitandukanye muri gahunda ya Excel byubaka umubare wagenwe. Nubwo bimeze bityo, iki gikorwa kirashobora gukorwa ukoresheje ibikoresho bimwe bikoreshwa mukubaka izindi mpamyabumenyi. Reka tumenye uburyo bwo kubikoresha kugirango tubare kare kuva kumurongo wagenwe.

Uburyo bwo kubaka kare

Nkuko mubizi, kare yumubare ubarwa no kugwira kwayo wenyine. Aya mahame asanzwe ayobowe no kubara ibimenyetso byagenwe kandi muri Excel. Muri iyi gahunda, dushobora kubaka umubare muri kare muburyo bubiri: ukoresheje ikimenyetso cyimyitozo kurwego rwamateguro "^" no gushyira mubikorwa. Reba algorithm yo gukoresha aya mahitamo mubikorwa kugirango ushimire imwe nziza.

Uburyo 1: Gukuramo hamwe nubufasha bwa formula

Mbere ya byose, suzuma uburyo bworoshye kandi busanzwe bwo kubaka impamyabumenyi ya kabiri muri Excel, irimo gukoresha formula nikimenyetso "^". Mugihe kimwe, nkikintu, kizamurwa kuri kare, urashobora gukoresha umubare cyangwa umurongo uhuza selile, aho agaciro k'umubare uherereye.

Kubona muri rusange formula yo kubaka kare ni izi zikurikira:

= N ^ 2

Muri yo, aho kuba "n", birakenewe gusimbuza umubare wihariye ugomba kuzamurwa muri kare.

Reka turebe uko ikora ku ngero zihariye. Kutangirira hamwe, yubatse umubare muri kare uzaba igice cya formula.

1. Turagaragaza selile kurupapuro ruzakorwamo. Twabishyize ikimenyetso "=". Noneho twanditse umubare wumubare twifuza kubaka impamyabumenyi kare. Reka kuba umubare 5. Ibikurikira, shyira ikimenyetso. Ni ikimenyetso "^" nta magambo. Noneho tugomba kwerekana ikintu kigomba gushyirwaho. Kubera ko kare ari impamyabumenyi ya kabiri, noneho twashyizeho umubare "2" udafite amagambo. Kubera iyo mpamvu, kuri twe, formula yarahindutse:

   = 5 ^ 2



2. Kugirango werekane ibisubizo byibibare kuri ecran, kanda urufunguzo rwinjira kuri clavier. Nkuko mubibona, gahunda ibaze neza ko umubare wa 5 muri kare uzangana na 25.

Noneho reka turebe uko twubaka agaciro muri kare iherereye muyindi kagari.

1. Shyira ikimenyetso "kingana" (=) mukagari aho umusaruro wo kubara uzerekanwa. Ibikurikira, kanda ku kintu cyurupapuro, aho umubare ushaka kubaka kare. Nyuma yibyo, uhereye kuri clavier, twishakira imvugo "^ 2". Ku bitureba, formula ikurikira yarahindutse:

   = A2 ^ 2



2. Kubara ibisubizo, nkigihe cyanyuma, kanda kuri buto yinjira. Porogaramu ibarwa kandi ikerekana ibisubizo murupapuro rwatoranijwe.

Uburyo 2: Gukoresha Impamyabumenyi

Kandi, kubaka umubare muri kare, urashobora gukoresha imikorere yashyizwemo impamyabumenyi ya Exced. Uyu mukoresha yinjiye murwego rwimibare hamwe ninshingano zayo ni ukubaka agaciro runaka kurwego rwihariye. Syntax yimikorere ni izi zikurikira:

= Impamyabumenyi (umubare; impamyabumenyi)

Impaka "Umubare" urashobora kuba umubare wihariye cyangwa ubyerekeranye nibintu byurupapuro, aho biherereye.

Impaka "impamyabumenyi" yerekana urwego umubare ugomba kubarirwa. Kubera ko duhuye nikibazo cyo kubaka kare, noneho kuri gahunda yacu iyi mpaka zizaba zingana na 2.

Noneho reka turebe urugero rwihariye, uburyo bwo gukora kare ukoresheje impamyabumenyi.

1. Hitamo akagari ibisubizo byo kubara bizerekanwa. Nyuma yibyo, kanda kuri "Shyiramo imikorere". Iherereye ibumoso bwumugozi wa formula.



2. Ikirangantego Wizard Idirishya ritangira kwiruka. Dutanga inzibacyuho muri icyiciro "imibare". Murutonde rwahagaritswe, hitamo "agaciro". Hanyuma ukande kuri buto "OK".



3. Idirishya ryimpaka zumukoresha wagenwe iratangizwa. Nkuko tubibona, hariho imirima ibiri muri yo, guhuza umubare w'impaka muriyi mirimo yimibare.

   Muri "Umubare", vuga agaciro k'umubare ugomba kuzamurwa muri kare.

   Muri "dogere", tugaragaza umubare "2", kubera ko dukeneye gukora neza kare.

   Nyuma yibyo, twongeyeho buto ya "ok" hepfo yubuso bwidirishya.



4. Nkuko mubibona, ako kanya nyuma yibi, ibisubizo byubaka kare byerekanwe muburyo bwateganijwe mbere.

Kandi, kugirango ukemure inshingano, aho kuba impaka nyinshi, urashobora gukoresha umurongo ugana muri selire aho iherereye.

1. Kugirango ukore ibi, hamagara idirishya ryimikorere yavuzwe haruguru nkuko twabikoze hejuru. Mu idirishya ryiruka muri "Umubare", sobanura umurongo ujya muri selire, aho agaciro k'umubare kaherereye kuri kare. Ibi birashobora gukorwa mugushiraho indanga gusa mumurima hanyuma ukande buto yimbeba yibumoso ku kintu gikwiye kurupapuro. Aderesi izahita igaragara mu idirishya.

   Muri "dogere", nkigihe cyanyuma, dushyira numero "2", hanyuma ukande kuri buto "OK".



2. Umukoresha utunganije amakuru yinjiye kandi yerekana ibisubizo kuri ecran. Nkuko tubibona, muriki gihe, ibisubizo bivamo bingana na 36.

Reba kandi: Uburyo bwo kubaka impamyabumenyi muri Excel

Nkuko mubibona, hariho uburyo bubiri bwo kwambuka umubare muri kare: ukoresheje ikimenyetso cya "^" no gukoresha imikorere yubatswe. Ibi byombi byo guhitamo birashobora kandi gukoreshwa mukubaka umubare kurwego urwo arirwo rwose, ariko kubara kare muri ibyo bihe byombi ugomba kwerekana impamyabumenyi "2". Buri buryo bwerekanwe burashobora gukora ibarwa, nkuko bivuye kumibare yagenwe, bityo ushyire kumurongo ugana muri selire itaherereyemo. Na nini, amahitamo ahwanye nimikorere, biragoye rero kuvuga niyihe nziza. Ahubwo ikibazo cyingeso nibyihutirwa bya buri mukoresha kugiti cye, ariko formula nikimenyetso "^" biracyakoreshwa cyane.