Kwiringira intera muri excel

Bumwe muburyo bwo gukemura ibibazo byibarurishamibare ni ukubara intera. Ikoreshwa nkubundi buryo bwatoranijwe kugeza aho bigereranya nurugero ruto. Twabibutsa ko inzira yo kubara intera igoye. Ariko ibikoresho bya gahunda ya Excel bigushoboza koroshya byoroshye. Reka tumenye uko bikorwa mubikorwa.

Uburyo bwa 2: Ikiranga ikizere.

Mubyongeyeho, hariho ikindi kintu gifitanye isano no kubara intera yicyizere - kwizerana. Byaragaragaye, guhera kuri Excel 2010. Uyu mukoresha ukora kubara abaturage muri rusange akoresheje ikwirakwizwa ryabanyeshuri. Biroroshye cyane gukoresha mugihe utana kandi, kubwibyo, gutandukana bisanzwe ntibizwi. Syntax yumukoresha ni:

= Icyizere .Ntydient (alpha; bisanzwe_otchal; ingano)

Nkuko tubibona, amazina yabakora kandi muriki kibazo ntiyigeze ahinduka.

Reka turebe uburyo bwo kubara imipaka yicyizere hamwe no gutandukana bisanzwe kurwego rutazwi kurugero rwumuryango umwe twasuzumye muburyo bwambere. Urwego rwicyizere, nkigihe cyanyuma, fata 97%.

1. Turagaragaza selile ikabarwa bizakorwa. Ibumba kuri "shyiramo imikorere".



2. Muri wizard ikora imirimo, jya ku cyiciro "imibare". Hitamo izina "kwizerana. Umunyeshuri". Ibumba kuri buto "OK".



3. Impaka zimpaka zabigenewe zatangijwe.

   Mu murima wa alfa, ukurikije ko urwego rwicyizere ari 97%, andika umubare 0.03. Ubwa kabiri kumahame yo kubara iyi parameter ntazahagarara.

   Nyuma yibyo, shiraho indanga mumashuri "gutandukana". Iki gihe iki cyerekezo kitazwi kandi gisabwa kubara. Ibi bikorwa ukoresheje imikorere idasanzwe - standcootclone. Guhamagara idirishya ryuyu mukoresha, kanda kuri mpandeshatu kugera ibumoso bwumugozi wa formula. Niba utabonye izina ryifuzwa murutonde rufungura, noneho unyuze mu "nyungu ...".



4. Inshingano nyamukuru iratangira. Twimukiye mucyiciro "ibarurishamibare" kandi tukayita izina "ritabootclona.b". Noneho ibumba kuri buto "OK".



5. Idirishya ry'impaka rifungura. Igikorwa cyibikorwa bisanzwe bya statorlone. Nibisobanuro byo gutandukana bisanzwe mugihe cyicyitegererezo. Syntax yayo isa nkiyi:

   = VeritClonil.V (Umubare1; Umubare2; ...)

   Biroroshye gukeka ko "umubare" impaka ari adresse yicyitegererezo. Niba icyitegererezo gishyizwe mumirongo imwe, noneho urashobora, ukoresheje impaka imwe gusa, tanga umurongo kuri uru rwego.

   Shyira indanga muri "Umubare1" kandi, nkuko bisanzwe, ufashe buto yimbeba yibumoso, tugenera urutonde. Nyuma yo guhuza umurima, ntukihutire gukanda buto "OK", kuko ibisubizo bizaba atari byo. Abambere, dukeneye gusubira ku mpaka zo gufatanya kwiringira. Umunyeshuri kugirango atange impaka zanyuma. Kuri ibi, kanda kumazina akwiye muri formula.



6. Idirishya ry'impaka risimburwa. Shyira indanga mu murima "ingano". Na none, kanda kuri mpandeshatu umaze kumenyera kujya guhitamo abakora. Nkuko ubyumva, dukeneye izina "konti". Kubera ko twakoresheje iyi miterere mugihe tubara muburyo bwambere, birahari mururu rutonde, kanda rero kuri yo. Niba utabimenye, noneho kora ukurikije algorithm yasobanuwe muburyo bwa mbere.



7. Nyuma yo gukubita idirishya, dushyira indanga murwego rwa "Umubare1" kandi hamwe na buto yimbeba yimbeba, turagaragaza urutonde. Noneho ibumba kuri buto "OK".



8. Nyuma yibyo, porogaramu itanga kubara kandi yerekana agaciro k'ibitekerezo.



9. Kugirango tumenye imipaka, tuzongera gukenera kubara impuzandengo yikigereranyo. Ariko, ahabwa kuba imibare algorithm abifashijwemo Inzira ni kimwe mu buryo Ibanjirije, ndetse ingaruka ntiyahindutse, tuzaba kureka mu buryo burambuye ubwa kabiri.



10. Nyuma yo gukora ibisubizo byo kubara Srvnah no kwizerana. Ubwumvikane, tubona umupaka ukwiye wicyizere.



11. Bifitanye isano nibisubizo byibarwa byumukoresha, ibisubizo byo kubara kubara birakize. Ubwumvikane, dufite umupaka wibumoso wicyizere.



12. Niba kubara ari ugundika hamwe na formula imwe, noneho kubara kumupaka wiburyo murubanza tumeze nkibi:

    = SRNAVOV (B2: B13) + Icyizere .Styty (0.03; stotclonil.v (b2: b13); amanota (B13))



13. Kubwibyo, formula yo kubara umupaka wibumoso izareba nkibi:

    = SRNAVOV (B2: B13) - Essential.styudent (0.03; Standotclonal.V (B2: B13); konti (B2: B13))

Nkuko mubibona, ibikoresho bya excel bizarohereza cyane kubara intera yicyizere nimbibi zayo. Kuri izo ntego, abakora ku giti cyabo bakoreshwa mubyitegererezo, aho gutatanya bizwi kandi bitazwi.