Uburyo buke bukabije muri excel

Uburyo buke bwibasitu ni uburyo bwimibare yo kubaka umurongo ugereranya umurongo, bikaba byahuye neza numurongo wimirongo ibiri yimibare. Intego yo gukoresha ubu buryo ni ugugabanya ikosa ryuzuye. Gahunda ya Excel ifite ibikoresho nuburyo ubu buryo bushobora gukoreshwa mugihe kubara. Reka duhangane nuburyo bikorwa.

Gukoresha uburyo muri Excel

Uburyo buke bubiri (MNC) ni imibare isobanura kwishingikiriza kumurongo umwe uva kumasegonda. Irashobora gukoreshwa mugihe uhanura.

Gufasha Ongeraho-kuri "Gushakisha igisubizo"

Kugirango ukoreshe MNA muri Excel, ugomba gukora "Gushakisha igisubizo" Ongeraho, bikaba bimugaye kubisanzwe.

1. Jya kuri tab "dosiye".



2. Kanda ku izina "Ibipimo".



3. Mu idirishya rifungura, uhagarike amahitamo kuri "Ongeraho".



4. Muri "imiyoborere", iherereye munsi yidirishya, shyira kuri "Excel Ongeraho-" muburyo (niba ahandi hashyizweho buto ya "Genda ... kugenda.



5. Idirishya rito rifungura. Twabishyizemo amatiku hafi ya "Gushakisha Gushakisha igisubizo". Kanda kuri buto ya "OK".

Noneho imikorere yimikorere yo kumuti muri Excel irakora, kandi ibikoresho byayo byagaragaye kuri kaseti.

Isomo: Shakisha ibisubizo muri Excele

Ibihe Byikibazo

Dusobanura ikoreshwa rya MNK kurugero runaka. Dufite imirongo ibiri yimibare X. kandi y. Urukurikirane rwarwo rutangwa mu ishusho hepfo.

Byatanzwe neza kwishingikiriza birashobora gusobanura imikorere:

y = a + nx

Mugihe kimwe, birazwi ko iyo x = 0. y. Nanone 0 . Kubwibyo, iki kigereranyo gishobora gusobanurwa no kwizizirwa Y = NX..

Tugomba kubona igiteranyo gito cyibice byitandukaniro.

Igisubizo

Reka duhindukire kubisobanuro byuburyo butaziguye uburyo.

1. Ibumoso bw'igisobanuro cya mbere X. shyira imibare 1 . Bizaba agaciro kagereranijwe kagaciro kambere ka coekent N..



2. Iburyo bw'inkingi y. Ongeraho indi nkingi - NX. Muri selire ya mbere yiyi nkingi, andika kugwiza gahunda ya coefficient N. kuri selire yimpinduka yambere X. . Muri icyo gihe, ihuriro ryumurima hamwe na coeffificure rikorwa byuzuye, kubera ko aya gaciro katagira agaciro. Kanda kuri buto ya Enter.



3. Gukoresha ikimenyetso cyuzuye, wandukure iyi formula kumurongo wose wimeza mumiyoboro ikurikira.



4. Muri selile itandukanye, kubara igiteranyo cyitandukaniro mumirongo yindangagaciro y. kandi NX. . Kugirango ukore ibi, kanda ahanditse "Shyiramo imikorere".



5. Muri "Master yimikorere" bifungura, ndashaka inyandiko "Summkvvson". Hitamo hanyuma ukande kuri buto "OK".



6. Idirishya ry'impaka rifungura. Muri "manini_x", twinjije inkingi yinkingi y. . Muri "manini_y", twinjije urwego rwibigori NX. . Kugirango winjire indangagaciro, shyira gusa indanga mumurima hanyuma uhitemo urwego rukwiye kurupapuro. Nyuma yo kwinjira, kanda buto "OK".



7. Jya kuri tab "data". Kuri kaseti muri "Isesengura" Ibikoresho Twakanda kuri buto "Gushakisha Gushakisha.



8. Idirishya rya Parameter rifungura. Muri "optimize intego yintego", sobanura aderesi ya selire hamwe na formula "summkvson". Muri "BC", menya neza gushiraho umwanya wa "ntarengwa". Mu murima "Guhindura Akagari", byerekana aderesi hamwe nagaciro ka coekele N. . Kanda ahanditse "Shakisha igisubizo".



9. Igisubizo kizerekanwa muri selile coeked N. . Agaciro kazaba kare ntoya yimikorere. Niba ibisubizo bishimishije umukoresha, hanyuma ukande kuri buto ya "OK" muburyo bwo guhitamo.

Nkuko mubibona, gukoresha uburyo buke bwa kare ni inzira yimibare igoye. Twamweretse mubikorwa kurugero rworoshye, kandi hariho ibibazo bigoye cyane. Ariko, Microsoft Extkit yagenewe koroshya kubara.